nsightsvol traded dex
Updated 2024-09-21Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
DATE_TRUNC('day', block_timestamp) as date,
SUM((AMOUNT_IN_USD + AMOUNT_OUT_USD)/2) AS daily_volume_traded,
count(TX_HASH) as total_tx,
count(distinct ORIGIN_FROM_ADDRESS) as users,
from ethereum.defi.ez_dex_swaps
where (TOKEN_IN = '0x455e53cbb86018ac2b8092fdcd39d8444affc3f6' or TOKEN_OUT = '0x455e53cbb86018ac2b8092fdcd39d8444affc3f6')
and BLOCK_TIMESTAMP >= '2023-01-01'
group by date
order by date desc;
QueryRunArchived: QueryRun has been archived