DATE_TRUNC ('day', BLOCK_TIMESTAMP) AS Date,

COUNT (DISTINCT TX_HASH) AS Swaps,

COUNT(DISTINCT origin_from_address) AS Swappers,

SUM(coalesce(amount_in_usd, amount_out_usd)) AS USD_volume

kaia.defi.ez_dex_swaps

platform = 'capybara'

AND date >= current_date -30

GROUP BY

1

USD_volume > 0