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