Query editor
WITH pool_info AS (SELECTpool.blockchain,CONCAT(t0.symbol, '-', t1.symbol) AS pool_name,pool.pool AS pool_address,pool.fee / 1e4 AS fee_percent,pool.token0,t0.symbol AS token0_symbol,t0.decimals AS token0_decimals,pool.token1,t1.symbol AS token1_symbol,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}}),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}})) transfersWHERE contract_address IN (SELECT token0 FROM pool_infoUNION ALLSELECT token1 FROM pool_info)GROUP 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 ALL