strawbettypopular DEXs
Updated 2022-05-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select
distinct platform
,date_trunc('Month',block_timestamp) as MONTH
,sum(amount_usd) over (partition by platform,MONTH) as monthly_swap_volume
from ethereum.dex_swaps
where
to_address in ('0xdef171fe48cf0115b1d80b88dc8eab59176fee57',
'0x1bd435f3c054b6e901b7b108a0ab7617c808677b',
'0xf90e98f3d8dce44632e5020abf2e122e0f99dfab',
'0x9509665d015bfe3c77aa5ad6ca20c8afa1d98989',
'0x86969d29f5fd327e1009ba66072be22db6017cc6')
and block_timestamp::date >= CURRENT_DATE - interval '12 months'
Run a query to Download Data