mz0111GMX 13
Updated 2022-11-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
--credit to alik110
select 'GMX' as token,
sum (event_inputs:value/1e18) as Volume,
count (distinct tx_hash) as Transactions,
count (distinct origin_from_address) as Users_Count
from arbitrum.core.fact_event_logs
where contract_address = '0xfc5a1a6eb076a2c7ad06ed22c90d7e710e35ad0a'
and tx_status= 'SUCCESS'
group by 1
union ALL
select 'GNS' as token,
sum (event_inputs:value/1e18) as Volume,
count (distinct tx_hash) as Transactions,
count (distinct origin_from_address) as Users_Count
from polygon.core.fact_event_logs
where contract_address = '0xe5417af564e4bfda1c483642db72007871397896'
and tx_status= 'SUCCESS'
group by 1
Run a query to Download Data