freemartianAll GMX Products Impact
Updated 2022-11-05
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
28
29
30
31
›
⌄
with gmx_stats as(
select
block_timestamp::date as TIME,
count(distinct tx_hash) as count
from arbitrum.core.fact_event_logs
where contract_address in(
'0xfc5a1a6eb076a2c7ad06ed22c90d7e710e35ad0a',
'0x3d6ba331e3d9702c5e8a8d254e5d8a285f223aba',
'0xb87a436b93ffe9d75c5cfa7bacfff96430b09868')
and tx_status= 'SUCCESS'
group by 1
),
total_stats as (
select
block_timestamp::date as TIME,
count(distinct tx_hash) as count
from arbitrum.core.fact_event_logs
where contract_address not in(
'0xfc5a1a6eb076a2c7ad06ed22c90d7e710e35ad0a',
'0x3d6ba331e3d9702c5e8a8d254e5d8a285f223aba',
'0xb87a436b93ffe9d75c5cfa7bacfff96430b09868')
and tx_status= 'SUCCESS'
group by 1
)
select a.TIME, (a.count/b.count)*100 as impact_percentage
from gmx_stats a inner join total_stats b on a.TIME = b.TIME
Run a query to Download Data