web3senseiWEEKLY VOLUME
Updated 2024-10-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
-- forked from Azin / over time @ https://flipsidecrypto.xyz/Azin/q/a3gUG2mpdGYc/over-time
select
count(*) as trades ,
count(distinct SENDER) as traders_number ,
sum(AMOUNT_IN_USD+AMOUNT_OUT_USD) as volume ,
volume/traders_number average_per_trades,
date_trunc('week',BLOCK_TIMESTAMP) as date ,
sum(volume) over (order by date) as cvolume ,
sum(trades) over (order by date) as ctrades
from
polygon.defi.ez_dex_swaps
WHERE
PLATFORM ='quickswap-v3'
group by date
QueryRunArchived: QueryRun has been archived