Query editor
WITH pool_info AS (SELECTpool.pool AS pool_address,pool.fee / 1e4 AS fee_percent,pool.token0,pool.token1,t0.decimals AS token0_decimals,t1.decimals AS token1_decimalsFROM dex.pools poolLEFT JOIN tokens.erc20 t0 ON pool.token0 = t0.contract_addressLEFT JOIN tokens.erc20 t1 ON pool.token1 = t1.contract_addressWHERE pool.pool = {{pool_address}}LIMIT 1),current_balances AS (SELECTcontract_address,SUM(CASE WHEN to = {{pool_address}} THEN "value"WHEN "from" = {{pool_address}} THEN -"value"ELSE 0 END) AS raw_balanceFROM (SELECT "from", to, "value", contract_address FROM erc20_ethereum.evt_TransferWHERE ("from" = {{pool_address}} OR to = {{pool_address}})UNION ALLSELECT "from", to, "value", contract_address FROM erc20_arbitrum.evt_TransferWHERE ("from" = {{pool_address}} OR to = {{pool_address}})UNION ALLSELECT "from", to, "value", contract_address FROM erc20_polygon.evt_TransferWHERE ("from" = {{pool_address}} OR to = {{pool_address}})UNION ALLSELECT "from", to, "value", contract_address FROM erc20_base.evt_TransferWHERE ("from" = {{pool_address}} OR to = {{pool_address}})) transfersGROUP BY contract_address),balances_24h_ago AS (SELECTcontract_address,SUM(CASE WHEN to = {{pool_address}} THEN "value"WHEN "from" = {{pool_address}} THEN -"value"ELSE 0 END) AS raw_balanceFROM (SELECT "from", to, "value", contract_address, evt_block_time FROM erc20_ethereum.evt_TransferWHERE ("from" = {{pool_address}} OR to = {{pool_address}})AND evt_block_time <= now() - interval '24' hourUNION ALLSELECT "from", to, "value", contract_address, evt_block_time FROM erc20_arbitrum.evt_TransferWHERE ("from" = {{pool_address}} OR to = {{pool_address}})AND evt_block_time <= now() - interval '24' hourUNION ALLSELECT "from", to, "value", contract_address, evt_block_time FROM erc20_polygon.evt_TransferWHERE ("from" = {{pool_address}} OR to = {{pool_address}})AND evt_block_time <= now() - interval '24' hourUNION ALL