HosseinOvertime
Updated 2023-11-13
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
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