adambalaMonthly Swap Volume
Updated 2022-05-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with app as (
SELECT origin_address ,
tx_id,
amount_usd ,
date_trunc('month',block_timestamp) as date
FROM ethereum.udm_events
WHERE tO_LABEL ilike'%paraswap%' or to_address = '0xDEF171Fe48CF0115B1d80b88dc8eAB59176FEe57'
or to_address = '0x1bd435f3c054b6e901b7b108a0ab7617c808677b' -- paraswap router
and BLOCK_TIMESTAMP > '2021-01-01'
)
select
count(distinct tx_id) as tx_id_number,
count(distinct origin_address) as user_number,
sum(amount_usd) as amount,
date
from app
group by 4
--having origin_function_name is not null
Run a query to Download Data