PLATFORM | DISTINCT_TRADER_COUNT | |
---|---|---|
1 | GAINS | 9619 |
2 | GMX | 114506 |
3 | MUX | 18332 |
logx_tradeDistinct Traders Per Platform - 1yr
Updated 2024-02-04
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
32
33
34
35
36
›
⌄
with gmx_combined as (
select
logs.decoded_log:account as trader,
'GMX' as platform,
sum(case
when event_name = 'IncreasePosition' then decoded_log:sizeDelta / pow(10, 30)
when event_name = 'DecreasePosition' then decoded_log:sizeDelta / pow(10, 30)
when event_name = 'LiquidatePosition' then ifnull(decoded_log:size / pow(10, 30), 0)
else 0
end) as total_usd
from
arbitrum.core.ez_decoded_event_logs as logs
where
logs.contract_address = '0x489ee077994b6658eafa855c308275ead8097c4a'
and logs.tx_status = 'SUCCESS'
and block_timestamp >= current_date() - 365
group by trader
),
mux_combined as (
select
decoded_log:trader as trader,
'MUX' as platform,
sum(case
when event_name = 'OpenPosition' then (decoded_log:args:collateralPrice * decoded_log:args:remainCollateral) / (pow(10, 18) * pow(10, 18))
when event_name = 'ClosePosition' then (decoded_log:args:collateralPrice * decoded_log:args:remainCollateral) / (pow(10, 18) * pow(10, 18))
when event_name = 'Liquidate' then (decoded_log:args:collateralPrice * decoded_log:args:remainCollateral) / (pow(10, 18) * pow(10, 18))
else 0
end) as total_usd
from
arbitrum.core.ez_decoded_event_logs as logs
where
logs.contract_address = '0x3e0199792ce69dc29a0a36146bfa68bd7c8d6633'
and logs.tx_status = 'SUCCESS'
and block_timestamp >= current_date() - 365
and (event_name = 'ClosePosition' or event_name = 'OpenPosition' or event_name = 'Liquidate')
Last run: about 1 year agoAuto-refreshes every 12 hours
3
45B
317s