Query editor
WITH rp AS (SELECTtx_hash,token_sold_address AS tokenIn,token_bought_address AS tokenOutFROM (SELECTtx_hash,token_sold_address,token_bought_address,block_time,blockchainFROM sushiswap_agg.tradesUNION ALLSELECTtx_hash,token_sold_address,token_bought_address,block_time,blockchainFROM dune.sushi_labs.result_rp_trades_spellbook_pr) tWHERE t.block_time >= CURRENT_TIMESTAMP - INTERVAL '1' DAYAND t.blockchain = '{{blockchain}}'),dexes AS (selecttx_hash,CASEWHEN position('uniswap' IN project) > 0 THEN project || ' v' || versionWHEN position('sushiswap' IN project) > 0 THEN project || ' v' || versionELSE replace(project, '_', ' ')END AS project,amount_usdFROM dex.tradesWHEREblock_time >= NOW() - INTERVAL '1' DAYAND blockchain = '{{blockchain}}'AND tx_to IN (0xf2614a233c7c3e7f08b1f887ba133a13f1eb2c55, -- RP50x9e55e562D40FD01f38cD4057e632352fE0758F16, -- RP5, zklink/zksync0x85CD07Ea01423b1E937929B44E4Ad8c40BbB5E71, -- RP60xE6fD46600A97CE06703b58333B9C2399F4bF6FEc, -- RP6 ZK0xAC4c6e212A361c968F1725b4d055b47E63F80b75, --REDSWPR0x35E98C2b3894D71D3D4D7edb8b30E4f36E2f9179, --REDSWPR ZK0x3Ced11c610556e5292fBC2e75D68c3899098C14C, -- RP70xd7C94C8C61628911C41141289af1D0dE17d7aC8d, -- RP7 ZK,0x2905d7e4D048d29954F81b02171DD313F457a4a4, -- RP80x81602EF321C46d73f5Ba7f476947AE1a862957dc, -- RP90xE2eFedE921B3114fdde3F9529bc682dBAf742058, -- RP9ZK0x3B0AA7d38Bf3C103bf02d1De2E37568cBED3D6e8, -- RP9.10xd2b37aDE14708bf18904047b1E31F8166d39612b, -- RP9_20xE0a091CEEB255cE3Abc3B18305d48a07521e19e1, -- RP9_2ZK0xe89AAb725a2b2C0656248DCCcc894A04661BE55A -- RP10)