freemartianGMX Token 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
›
⌄
with gmx_stats as(
select
block_timestamp::date as TIME,
sum(event_inputs:value/pow(10, 18)) as volume,
count(distinct tx_hash) as count
from arbitrum.core.fact_event_logs
where contract_address = '0xfc5a1a6eb076a2c7ad06ed22c90d7e710e35ad0a'
and event_name = 'Transfer'
and tx_status= 'SUCCESS'
group by 1
),
total_stats as (
select
block_timestamp::date as TIME,
sum(event_inputs:value/pow(10, 18)) as volume,
count(distinct tx_hash) as count
from arbitrum.core.fact_event_logs
where contract_address != '0xfc5a1a6eb076a2c7ad06ed22c90d7e710e35ad0a'
and event_name = 'Transfer'
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