logx_tradeDistinct Traders Per Platform - 1yr
    Updated 2024-02-04
    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
    PLATFORM
    DISTINCT_TRADER_COUNT
    1
    GAINS9619
    2
    GMX114506
    3
    MUX18332
    3
    45B
    317s