PS0G1numeric uni
Updated 2022-10-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
select 'Optimism' as blockchain,
count (distinct tx_hash) as Swaps_Count,
count (distinct origin_from_address) as Swappers_Count
from optimism.core.fact_event_logs t1
where origin_to_address = '0xe592427a0aece92de3edee1f18e0157c05861564'
and event_name = 'Swap'
and tx_status = 'SUCCESS'
group by 1
union ALL
select 'Arbitrum' as blockchain,
count (distinct tx_hash) as Swaps_Count,
count (distinct origin_from_address) as Swappers_Count
from arbitrum.core.fact_event_logs t1
where origin_to_address = '0xe592427a0aece92de3edee1f18e0157c05861564' and event_name = 'Swap' and tx_status = 'SUCCESS'
group by 1
union ALL
select 'Polygon' as blockchain,
count (distinct tx_hash) as Swaps_Count,
count (distinct origin_from_address) as Swappers_Count
from polygon.core.fact_event_logs t1
where origin_to_address = '0xe592427a0aece92de3edee1f18e0157c05861564' and event_name = 'Swap' and tx_status = 'SUCCESS'
group by 1
Run a query to Download Data