NuveveCryptoArchivedUNI Volume by DEX
Updated 2023-05-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with daily as (
select
block_timestamp::date as date,
platform,
sum(amount_in_usd) as volume_usd
from ethereum.core.ez_dex_swaps
where block_timestamp >= current_date - 30
and token_in = '0x1f9840a85d5af5bf1d1762f925bdaddc4201f984'
or token_out = '0x1f9840a85d5af5bf1d1762f925bdaddc4201f984'
group by date, platform
)
select
platform,
sum(volume_usd) as volume_usd
from daily
where date >= current_date - 30
group by platform
order by volume_usd desc
Run a query to Download Data