Updated 2022-11-05Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with tab1 as (select
count (distinct origin_from_address) as count_users,
count (distinct tx_hash) as count_transactions, 'GMX' as type
from arbitrum.core.fact_event_logs
where contract_address ilike '0xfc5a1a6eb076a2c7ad06ed22c90d7e710e35ad0a'
and event_name ilike 'transfer'
and tx_status ilike 'SUCCESS'
),
tab2 as (select
count (distinct from_address) as count_users,
count (distinct tx_hash) as count_transactions, 'Arbitrum' as type
from arbitrum.core.fact_transactions
where status ilike 'SUCCESS'
)
select * from tab1 union all
select * from tab2
Run a query to Download Data