Query editor
WITH memers AS (SELECT tx_from , sum(amount_usd) as amount, MAX(amount_usd) as biggest_trade, COUNT(*) as nb_trades, 'CLOSEDAI' as memecoinFROM dex.tradesWHERE block_date > NOW() -interval '30' day AND token_bought_address = 0x50b0696468f42cab1ddc76413a1312aff3cabdf6 --CLOSEDAIGROUP BY 1UNION ALLSELECT tx_from , sum(amount_usd) as amount, MAX(amount_usd) as biggest_trade, COUNT(*) as nb_trades, 'AIDOGE' as memecoinFROM dex.tradesWHERE block_date > NOW() -interval '30' day AND token_bought_address = 0x09e18590e8f76b6cf471b3cd75fe1a1a9d2b2c2b --AIDOGEGROUP BY 1UNION ALLSELECT tx_from , sum(amount_usd) as amount, MAX(amount_usd) as biggest_trade, COUNT(*) as nb_trades, 'FakeAI' as memecoinFROM dex.tradesWHERE block_date > NOW() -interval '30' day AND token_bought_address = 0x5aef5bba19e6a1644805bd4f5c93c8557b87c62c --FakeAIGROUP BY 1UNION ALLSELECT tx_from , sum(amount_usd) as amount, MAX(amount_usd) as biggest_trade, COUNT(*) as nb_trades, 'MEMEAI' as memecoinFROM dex.tradesWHERE block_date > NOW() -interval '30' day AND token_bought_address = 0x695d38eb4e57e0f137e36df7c1f0f2635981246b --MEMEAIGROUP BY 1UNION ALLSELECT tx_from , sum(amount_usd) as amount, MAX(amount_usd) as biggest_trade, COUNT(*) as nb_trades, 'YOURAI' as memecoinFROM dex.tradesWHERE block_date > NOW()-interval '30' day AND token_bought_address = 0xc5ba042bf8832999b17c9036e8212f49dce0501a --YOURAIGROUP BY 1UNION ALLSELECT tx_from , sum(amount_usd) as amount, MAX(amount_usd) as biggest_trade, COUNT(*) as nb_trades, 'AITECH' as memecoinFROM dex.tradesWHERE block_date > NOW()-interval '30' day AND token_bought_address = 0x2d060ef4d6bf7f9e5edde373ab735513c0e4f944 --AITECHGROUP BY 1UNION ALLSELECT tx_from , sum(amount_usd) as amount, MAX(amount_usd) as biggest_trade, COUNT(*) as nb_trades, 'DOGEAI' as memecoinFROM dex.tradesWHERE block_date > NOW()-interval '30' day AND token_bought_address = 0xd31e53966bf212e860d48a3a8651a23d09a7fdc3 --DOGEAIGROUP BY 1UNION ALLSELECT tx_from , sum(amount_usd) as amount, MAX(amount_usd) as biggest_trade, COUNT(*) as nb_trades, 'AITEK' as memecoinFROM dex.tradesWHERE block_date > NOW()-interval '30' day AND token_bought_address = 0xd289ea09aeece390629e9414d41b4d9d9bf43fd9 --AITEKGROUP BY 1UNION ALLSELECT tx_from , sum(amount_usd) as amount, MAX(amount_usd) as biggest_trade,COUNT(*) as nb_trades, 'GROKAI' as memecoinFROM dex.tradesWHERE block_date > NOW() -interval '30' day AND token_bought_address = 0xc297f0eeace5afdaf4e39f7fd1f82c0335d05deb -- GROKAI