0-MIDsushi2 copy
Updated 2023-09-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
-- forked from sushi2 @ https://flipsidecrypto.xyz/edit/queries/db82c87e-2717-4393-a020-9e031b2dee9f
select BLOCK_TIMESTAMP::date as date
,sum(AMOUNT_IN_USD) as volume
,avg(AMOUNT_IN_USD) as avg_volume
,count(distinct ORIGIN_FROM_ADDRESS) as swappers
,count(distinct TX_HASH) as swaps
from base.defi.ez_dex_swaps
where PLATFORM='aerodrome'
and AMOUNT_IN_USD is not null
group by 1
Run a query to Download Data