Query editor
WITHevm_daily_stats AS (SELECTDATE_TRUNC('day', block_time) AS day,SUM(amount_usd) AS trading_volume,COUNT(DISTINCT tx_from) AS trading_addresses,COUNT(*) AS trading_transactionsFROMdex.tradesWHEREtx_to in (0x1A8f43e01B78979EB4Ef7feBEC60F32c9A72f58E,0xD1ca1F4dBB645710f5D5a9917AA984a47524f49A,0x4325ccCAc772ba1dea9d7F13782A8D5BaAc1aF1b,0x15844509968D85d1b25b4a7Fc86Affb557083CC8,0x22cE84A7F86662b78E49C6ec9E51D60FddE7b70A,0xDe44500b5d1479DF5C003bf48915b3E24Df3e8dD,0x8b9d635C35544A49A0830013A86ab61fF9B519C6,0x9f28A9fFcA902Ec6B89cBd4eA53bfb3d6226755b,0x6f0164e494D727a6bCbBA96f04cc6fC4d51621D3,0x08a94C996Ff66F842DF1260be896f2BB9602e187)AND block_time > timestamp '2025-03-16 00:00:00' - INTERVAL '30' dayAND block_time < timestamp '2025-03-16 00:00:00'GROUP BY1),solana_daily_stats AS (SELECTDATE_TRUNC('day', block_time) AS day,SUM(amount_usd) AS trading_volume,COUNT(DISTINCT trader_id) AS trading_addresses,COUNT(*) AS trading_transactionsFROMdex_solana.tradesWHEREtrade_source in ('4Ji3eRdwjCg2wuuJVbRBvqkPKz2xs4tchxQ4tZNhbUfs','DGumNmyMhSeuNYsJLWD7VELLoENEenp99pTtDqSR9dUy','2WKs6hQg3cesC2D7Hxtt878beWFezbd5dJZmFmrXumnH','AG22uRpgfYjeLbLBGdJtHM6siWT7zZKiTkZTojNMCkfg')AND block_time > timestamp '2025-03-16 00:00:00' - INTERVAL '30' dayAND block_time < timestamp '2025-03-16 00:00:00'GROUP BY1),combined_stats AS (SELECTday,trading_volume,trading_addresses,trading_transactionsFROMevm_daily_statsUNION ALL