niloMonthly Swap Volume on ParaSwap
Updated 2022-05-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
date_trunc('month',block_timestamp) as monthly,
sum(amount_usd) as swap_volume
from ethereum.dex_swaps
where (from_address ilike '0x1bD435F3C054b6e901B7b108a0ab7617C808677b' or -- ILIKE, For case-insensitive matching
from_address ilike '0x86969d29f5fd327e1009ba66072be22db6017cc6' or
from_address ilike '0x9509665d015bfe3c77aa5ad6ca20c8afa1d98989' or
from_address ilike '0xf90e98f3d8dce44632e5020abf2e122e0f99dfab' or
from_address ilike '0xdef171fe48cf0115b1d80b88dc8eab59176fee57'
) --- paraswap contract address v1+v2+v3+v4+v5
and block_timestamp >= CURRENT_DATE - 365
group by 1
order by 1 DESC
Run a query to Download Data