hyoeisemanUN 2
Updated 2022-10-15
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
26
27
›
⌄
with tab1 as (select 'Arbitrum' as type, block_timestamp::date as date,
count (distinct tx_hash) as number_of_swaps,
count (distinct origin_from_address) as number_of_swappers
,number_of_swaps/number_of_swappers as avg_txn_per_user
from arbitrum.core.fact_event_logs
where origin_to_address = '0xe592427a0aece92de3edee1f18e0157c05861564'
and event_name ilike 'Swap'
and tx_status ilike 'SUCCESS' group by 1,2),
tab2 as (select 'Optimism' as type, block_timestamp::date as date,
count (distinct origin_from_address) as number_of_swappers,
count (distinct tx_hash) as number_of_swaps
,number_of_swaps/number_of_swappers as avg_txn_per_user
from optimism.core.fact_event_logs
where origin_to_address ilike '0xe592427a0aece92de3edee1f18e0157c05861564'
and event_name ilike 'Swap'
and tx_status ilike 'SUCCESS' group by 1,2),
tab3 as (select 'Polygon' as type, block_timestamp::date as date,
count (distinct tx_hash) as number_of_swaps,
count (distinct origin_from_address) as number_of_swappers
,number_of_swaps/number_of_swappers as avg_txn_per_user
from polygon.core.fact_event_logs
where origin_to_address ilike '0xe592427a0aece92de3edee1f18e0157c05861564'
and event_name ilike 'Swap'
and tx_status ilike 'SUCCESS' group by 1,2)
select * from tab1 union all
select * from tab2 union ALL
select * from tab3
Run a query to Download Data