AmiRdaily
Updated 2024-08-17
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select block_timestamp::date as day,
count(DISTINCT TX_hash) as swaps,
count(DISTINCT ORIGIN_FROM_ADDRESS) as swappers,
count(DISTINCT pool_name) as pool_count,
count(DISTINCT token_in) as sold_tokens,
count(DISTINCT token_out) as purchase_tokens,
sum(AMOUNT_OUT_USD) as vol,
avg(AMOUNT_OUT_USD) as Avg_vol
from polygon.defi.ez_dex_swaps
where BLOCK_TIMESTAMP>=current_date-60 and platform='quickswap-v3'
group by 1
QueryRunArchived: QueryRun has been archived