Updated 2022-11-06
    --credit : alik110
    with gmxtable as (
    select block_timestamp::date as day,
    sum (event_inputs:value/1e18) as GMX_Volume,
    count (distinct tx_hash) as GMX_Transactions
    from arbitrum.core.fact_event_logs
    where contract_address = '0xfc5a1a6eb076a2c7ad06ed22c90d7e710e35ad0a'
    and event_name = 'Transfer'
    and tx_status= 'SUCCESS'
    group by 1)

    select block_timestamp::date as date,
    gmx_volume,
    GMX_Transactions,
    count (distinct tx_hash) as Arbitrum_Transactions,
    count (distinct from_address) as Artbitrum_Active_Users
    from arbitrum.core.fact_transactions t1 join gmxtable t2 on t1.block_timestamp::Date = t2.DAY
    where status = 'SUCCESS'
    group by 1,2,3
    order by 1
    Run a query to Download Data