sarathUser behavior_reduxx_1_0
Updated 2022-10-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
select block_timestamp::date as date,'Sushiswap' as platform, count (distinct tx_hash) as tx, count (distinct origin_from_address) as swappers
from optimism.sushi.ez_swaps
where block_timestamp >= current_date -30
and block_timestamp < current_date
group by 1,2
union ALL
select block_timestamp::date as date,'Velodrome' as platform, count (distinct tx_hash) as tx, count (distinct origin_from_address) as swappers
from optimism.velodrome.ez_swaps
where block_timestamp >= current_date -30
and block_timestamp < current_date
group by 1,2
union ALL
select block_timestamp::date as date,'Uniswap' as platform, count (distinct tx_hash) as tx, count (distinct origin_from_address) as swappers
from optimism.core.fact_event_logs
where origin_to_address in ('0xe592427a0aece92de3edee1f18e0157c05861564','0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45')
and event_name = 'Swap'
and tx_status = 'SUCCESS'
and block_timestamp >= current_date -30
and block_timestamp < current_date
group by 1,2
Run a query to Download Data