Query editor
withDEX_aggregators (contract_address, contract_name) AS (--, call_contract) AS (VALUES-- KyberSwap Contracts(0x6131B5fae19EA4f9D964eAc0408E4408b66337b5, 'KyberSwap Aggregator'),(0x30c5322e4e08ad500c348007f92f120ab4e2b79e, 'KyberSwap Aggregator'), -- KSZapRouter-- 1Inch Aggregators(0x1111111254EEB25477B68fb85Ed929f73A960582, '1Inch v5'),-- Magpie Protocol - Bridge & DEX Aggregator(0x956Df8424B556F0076E8abf5481605f5A791cc7f, 'Magpie Protocol'),--,0x0e8e403c2d36126272b08c75823e988381d9dc47f2f0a9a080d95f891d95c469),(0xba7bAC71a8Ee550d89B827FE6d67bc3dCA07b104, 'Magpie Protocol'),-- OpenOcean(0x84a7059096a393f09f3d3f5771e4f25e2d1474ce, 'OpenOcean'),-- Other Services(0xBA12222222228d8Ba445958a75a0704d566BF2C8, 'BalancerV2'),(0x27425e9FB6A9A625E8484CFD9620851D1Fa322E5, 'WOO RouterV2'),(0x59C7C832e96D2568bea6db468C1aAdcbbDa08A52, 'Paraswap'),(0x3335733c454805df6a77f825f266e136FB4a3333, 'Rubic Exchange'),(0x53fe57c0fdB6E67293233527A735BFA6069a0164, 'SharkSwap V2'),-- Velocimeter(0xA98791aECC70909baF130392B31B3F855A618919, 'Velocimeter UI'),(0x060d03259541B67EC55D7a565dbe3f24c9659203, 'Velocimeter UI' ),(0xE11b93B61f6291d35c5a2beA0A9fF169080160cF, 'Velocimeter UI'),(0x2E14B53E2cB669f3A974CeaF6C735e134F3Aa9BC, 'Velocimeter UI'),-- SquidRouter(0x4fd39C9E151e50580779bd04B1f7eCc310079fd3, 'SquidRouter')),tokens_data AS (SELECTpool_contract, pool_symbol, isStable AS stable,token0_contract, token1_contract,token0_symbol, token1_symbol,token0_decimals, token1_decimalsFROM query_3810629),Swap_evt AS (SELECT *FROM TABLE (decode_evm_event (abi => '{"anonymous":false,"inputs":[{"indexed":true,"internalType":"address","name":"sender","type":"address"},{"indexed":false,"internalType":"uint256","name":"amount0In","type":"uint256"},{"indexed":false,"internalType":"uint256","name":"amount1In","type":"uint256"},{"indexed":false,"internalType":"uint256","name":"amount0Out","type":"uint256"},{"indexed":false,"internalType":"uint256","name":"amount1Out","type":"uint256"},{"indexed":true,"internalType":"address","name":"to","type":"address"}],"name":"Swap","type":"event"}',input => TABLE (SELECT * FROM fantom.logs flWHERE 1=1 AND fl.contract_address IN ( SELECT pool_contract FROM tokens_data ))))),token0_prices AS (SELECTcontract_address,AVG(price) AS avg_price,DATE_TRUNC('day', minute) AS block_dateFROM prices.usdWHERE blockchain = 'fantom' AND contract_address IN (SELECT token0_contract FROM tokens_data)GROUP BY contract_address, DATE_TRUNC('day', minute)),token1_prices AS (SELECTcontract_address,AVG(price) AS avg_price,