Query editor
1SELECT2 SUM(CAST(amount_usd AS DOUBLE)) / 1000000000 /* Convert to billion :D */ AS usd_volume_in_billion3FROM4 dex."trades" AS t5-- WHERE6-- block_time >= NOW() - INTERVAL '12' month
SELECT
SUM(CAST(amount_usd AS DOUBLE)) / 1000000000 /* Convert to billion :D */ AS usd_volume_in_billion
FROM
dex."trades" AS t
-- WHERE
-- block_time >= NOW() - INTERVAL '12' month