AmiRdaily
Updated 2024-10-02
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
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,
sum(AMOUNT_OUT_USD) as vol,
avg(AMOUNT_OUT_USD) as Avg_vol
from arbitrum.defi.ez_dex_swaps
where BLOCK_TIMESTAMP>=current_date-60 and platform='camelot-v3'
group by 1
order by 1
QueryRunArchived: QueryRun has been archived