Query editor
WITH majors AS (SELECT token FROM (VALUES('SOL'), ('WSOL'), ('USDC'), ('USDT'), ('USDS'),('JUP'), ('JTO'), ('BONK'), ('JLP'), ('mSOL'), ('jitoSOL')) AS t(token)),classified AS (SELECTblock_date,amount_usd,CASEWHEN token_bought_symbol IN (SELECT token FROM majors)AND token_sold_symbol IN (SELECT token FROM majors)THEN 'major'ELSE 'nonmajor'END AS trade_typeFROM dex_solana.tradesWHERE project = 'pumpswap'AND block_time >= now() - interval '365' dayAND amount_usd IS NOT NULL)SELECTblock_date,sum(CASE WHEN trade_type = 'nonmajor' THEN amount_usd ELSE 0 END) AS nonmajor_vol,sum(CASE WHEN trade_type = 'major' THEN amount_usd ELSE 0 END) AS major_vol,100.0 * sum(CASE WHEN trade_type = 'nonmajor' THEN amount_usd ELSE 0 END) / sum(amount_usd) AS nonmajor_pct,100.0 * sum(CASE WHEN trade_type = 'major' THEN amount_usd ELSE 0 END) / sum(amount_usd) AS major_pctFROM classifiedGROUP BY block_dateORDER BY block_date