Most Active Congressional Traders

Custom SQL query returning 62 rows (hide)

SELECT st.member_name, cm.party, cm.state, cm.chamber, COUNT(*) AS trade_count, COUNT(DISTINCT st.ticker) AS unique_tickers, SUM(CASE WHEN st.transaction_type LIKE '%Purchase%' THEN 1 ELSE 0 END) AS purchases, SUM(CASE WHEN st.transaction_type LIKE '%Sale%' THEN 1 ELSE 0 END) AS sales, MIN(st.transaction_date) AS first_trade, MAX(st.transaction_date) AS last_trade FROM stock_trades st LEFT JOIN congress_members cm ON st.bioguide_id = cm.bioguide_id WHERE st.chamber = 'Senate' AND st.ticker IS NOT NULL AND st.ticker != '' GROUP BY st.member_name ORDER BY trade_count DESC LIMIT 100

Edit SQL