Query editor
WITH volume_windows AS (SELECTSUM(amount_usd) FILTER (WHERE block_time >= now() - interval '24' hourAND block_time < now()) AS volume_24h,SUM(amount_usd) FILTER (WHERE block_time >= now() - interval '48' hourAND block_time < now() - interval '24' hour) AS volume_prev_24hFROM dex.tradesWHERE project_contract_address = {{pool_address}})SELECTvolume_24h,volume_prev_24h,(volume_24h - volume_prev_24h) / NULLIF(volume_prev_24h, 0) * 100 AS volume_24h_pct_changeFROM volume_windows