Yousefi_1994Total GMX staking/unstaking
Updated 2022-10-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with stake_gmx as (
select
'Stake GMX' as type,
sum(event_inputs:value)/1e18 as "Amount"
from arbitrum.core.fact_event_logs
where contract_address = '0x4d268a7d4c16ceb5a606c173bd974984343fea13'
and event_inputs:to = '0xd2d1162512f927a7e282ef43a362659e4f2a728f'
and event_name = 'Transfer'
),
unstake_gmx as (
select
'UnStake GMX' as type,
sum(event_inputs:value)/1e18 as "Amount"
from arbitrum.core.fact_event_logs
where contract_address = '0x4d268a7d4c16ceb5a606c173bd974984343fea13'
and event_inputs:from = '0xd2d1162512f927a7e282ef43a362659e4f2a728f'
and event_name = 'Transfer'
)
select * from stake_gmx
union all
select * from unstake_gmx
Run a query to Download Data