Query editor
WITH election_markets AS (SELECT DISTINCT unique_keyFROM polymarket_polygon.market_detailsWHERE LOWER(tags) LIKE '%usa election%'OR LOWER(tags) LIKE '%2024 presidential election%'OR LOWER(tags) LIKE '%state presidential election%'),election_wallets AS (SELECT DISTINCT makerFROM polymarket_polygon.market_trades tINNER JOIN election_markets em ON t.unique_key = em.unique_keyWHERE t.block_month >= DATE '2024-01-01'AND t.block_month <= DATE '2024-12-01'),monthly AS (SELECTDATE_TRUNC('month', block_time) AS mth,COUNT(DISTINCT maker) AS total_wallets,COUNT(DISTINCT CASE WHEN maker NOT IN (SELECT maker FROM election_wallets) THEN maker END) AS non_election_walletsFROM polymarket_polygon.market_tradesWHERE block_month >= DATE '2024-01-01'GROUP BY 1)SELECTmth,total_wallets,non_election_wallets,total_wallets - non_election_wallets AS election_wallets,ROUND(non_election_wallets * 100.0 / total_wallets, 2) AS non_election_pctFROM monthlyORDER BY mth ASC