Query editor
-- Comprehensive pool analyticsWITH swaps AS (SELECTDATE_TRUNC('day', block_time) AS day,COUNT(*) AS swap_count,SUM(ABS(bytearray_to_int256(bytearray_substring(data, 1, 32)))) / 1e18 AS volume_token0,SUM(ABS(bytearray_to_int256(bytearray_substring(data, 33, 32)))) / 1e18 AS volume_token1FROM ink.logsWHERE contract_address = 0xf9349c5af43d2abc2758e90cfb341722116fac38AND topic0 = 0xc42079f94a6350d7e6235f29174924f928cc2ac818eb64fed8004e115fbcca67GROUP BY 1),unique_traders AS (SELECTDATE_TRUNC('day', block_time) AS day,COUNT(DISTINCT topic2) AS unique_recipientsFROM ink.logsWHERE contract_address = 0xf9349c5af43d2abc2758e90cfb341722116fac38AND topic0 = 0xc42079f94a6350d7e6235f29174924f928cc2ac818eb64fed8004e115fbcca67GROUP BY 1)SELECTs.day,s.swap_count,s.volume_token0 AS weeth_volume,s.volume_token1 AS eth_volume,u.unique_recipients AS unique_tradersFROM swaps sLEFT JOIN unique_traders u ON s.day = u.dayORDER BY s.day DESC