Sbhn_NPGMX
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
›
⌄
--credit : alik110
with gmxtable as (
select block_timestamp::date as day,
sum (event_inputs:value/1e18) as GMX_Volume,
count (distinct tx_hash) as GMX_Transactions
from arbitrum.core.fact_event_logs
where contract_address = '0xfc5a1a6eb076a2c7ad06ed22c90d7e710e35ad0a'
and event_name = 'Transfer'
and tx_status= 'SUCCESS'
group by 1)
select block_timestamp::date as date,
gmx_volume,
GMX_Transactions,
count (distinct tx_hash) as Arbitrum_Transactions,
count (distinct from_address) as Artbitrum_Active_Users
from arbitrum.core.fact_transactions t1 join gmxtable t2 on t1.block_timestamp::Date = t2.DAY
where status = 'SUCCESS'
group by 1,2,3
order by 1
Run a query to Download Data