date_trunc('month', block_timestamp) as date,

count(DISTINCT from_address) as user_count,

count(DISTINCT tx_id) as tx_count,

count(distinct pool_name) as pool_count,

sum(from_amount_usd) as total_vol,

avg(from_amount_usd) as avg_tx_vol,

sum(total_vol) over (order by date) as cum_total_vol,

sum(tx_count) over (order by date) as cum_tx_count

from

thorchain.defi.fact_swaps

where

date <= '2024-11-30'

group by

date

order by

date asc