HosseinOvertime
    Updated 2023-11-13
    select
    date_trunc('month', block_timestamp) as date,
    count(distinct tx_hash) as txns,
    count(distinct origin_from_address) as users,
    sum(amount_in_usd) as volume_usd,
    avg(amount_in_usd) as avg_volume_usd,
    sum(txns) over (order by date) as cumulative_txns,
    sum(volume_usd) over (order by date) as cumulative_volume_usd
    from arbitrum.defi.ez_dex_swaps
    where platform = 'curve'
    group by 1
    Run a query to Download Data