date_trunc(month, block_timestamp) as date,

count(DISTINCT TX_HASH) as "# Swaps",

count(DISTINCT TRADER) as "# Traders",

"# Swaps" / "# Traders" as "# Swaps per User",

sum(coalesce(AMOUNT_OUT_USD, AMOUNT_IN_USD)) as "Swap Volume",

sum("Swap Volume") over(order by date) as "Cum. Swap Volume",

sum("# Swaps") over(order by date) as "Cum. # Swaps"

from near.defi.ez_dex_swaps

where PLATFORM in ('ref-finance.near', 'v2.ref-finance.near')

group by 1

order by date asc