Query editor
with strats as (selectblock_time,tx_hash,substring(topic1 from 13 for 20) as nft_collection,substring(topic2 from 13 for 20) as token,--from_utf8(substring(data from 1 for 32)) as one,--from_utf8(substring(data from 33 for 32)) as two,--from_utf8(substring(data from 65 for 32)) as three,casewhen topic0 = 0xb21b33691d96c9afed29d52f5c03e912785d0fb36b91a4658534f7c8d408e9b8 then from_utf8(substring(data from 97 for 32))when topic0 = 0xd8de4ea6d1e8ee697cfd7c8bdf672deda866da7a73ad6fe705d9f11c6e6fc588 then from_utf8(substring(data from 161 for 32))end as strat_name,--from_utf8(substring(data from 129 for 32)) as five,casewhen topic0 = 0xb21b33691d96c9afed29d52f5c03e912785d0fb36b91a4658534f7c8d408e9b8 then from_utf8(substring(data from 161 for 32))when topic0 = 0xd8de4ea6d1e8ee697cfd7c8bdf672deda866da7a73ad6fe705d9f11c6e6fc588 then from_utf8(substring(data from 225 for 32))end as token_namefrom ethereum.logswhere contract_address in (0xA1a196b5BE89Be04a2c1dc71643689CE013c22e5, 0x05852ed6b0397F252969Ec6A92b26C725Bd975ff,0x6c108B4973b92638e713dC6B8e1601882C83B70a)and topic0 in (0xb21b33691d96c9afed29d52f5c03e912785d0fb36b91a4658534f7c8d408e9b8, 0xd8de4ea6d1e8ee697cfd7c8bdf672deda866da7a73ad6fe705d9f11c6e6fc588)and block_time > cast('2025-09-01' as timestamp))selectdate_trunc('day', block_time) as day,casewhen token_bought_address = 0x9ebf91b8d6ff68aa05545301a3d0984eaee54a03 or token_sold_address = 0x9ebf91b8d6ff68aa05545301a3d0984eaee54a03 then 'APESTR'when token_bought_address = 0xb3d6e9e142a785ea8a4f0050fee73bcc3438c5c5 or token_sold_address = 0xb3d6e9e142a785ea8a4f0050fee73bcc3438c5c5 then 'PUDGYSTR'when token_bought_address = 0x6bcba7cd81a5f12c10ca1bf9b36761cc382658e8 or token_sold_address = 0x6bcba7cd81a5f12c10ca1bf9b36761cc382658e8 then 'BIRBSTR'when token_bought_address = 0xc9b2c00f31b210fcea1242d91307a5b1e3b2be68 or token_sold_address = 0xc9b2c00f31b210fcea1242d91307a5b1e3b2be68 then 'MEEBSTR'when token_bought_address = 0x8680acfacb3fed5408764343fc7e8358e8c85a4c or token_sold_address = 0x8680acfacb3fed5408764343fc7e8358e8c85a4c then 'DICKSTR'when token_bought_address = 0x742fd09cBBeb1EC4E3d6404DfC959A324Deb50E6 or token_sold_address = 0x742fd09cBBeb1EC4E3d6404DfC959A324Deb50E6 then 'SQUIGSTR'when token_bought_address = 0x92cedfdbce6e87b595e4a529afa2905480368af4 or token_sold_address = 0x92cedfdbce6e87b595e4a529afa2905480368af4 then 'TOADSTR'when token_bought_address = 0x5d855d8a3090243fed9bf73999eedfbc2d1dcf21 or token_sold_address = 0x5d855d8a3090243fed9bf73999eedfbc2d1dcf21 then 'GOBSTR'when token_bought_address = 0xdfc3af477979912ec90b138d3e5552d5304c5663 or token_sold_address = 0xdfc3af477979912ec90b138d3e5552d5304c5663 then 'PAINSTR'when token_bought_address = 0x2090dc81f42f6ddd8deace0d3c3339017417b0dc or token_sold_address = 0x2090dc81f42f6ddd8deace0d3c3339017417b0dc then 'CHKSTR'when token_bought_address = 0xd0cc2b0efb168bfe1f94a948d8df70fa10257196 or token_sold_address = 0xd0cc2b0efb168bfe1f94a948d8df70fa10257196 then 'VIBESTR'end as token_name,sum(amount_usd) as usd_volfrom dex.tradeswhere (token_bought_address in (select token from strats) or token_sold_address in (select token from strats))and block_time > cast('2025-09-01' as timestamp)group by 1,2order by 1 desc