with tokens as ( select '0x9D575a9bF57a5e24a99D29724B86ca021A2b0435' as token_address ,'ETH' as token_name, 18 as decimal from arbitrum.core.dim_labels UNION select '0xff970a61a04b1ca14834a43f5de4533ebddb5cc8' as token_address ,'USDC' as token_name, 6 as decimal from arbitrum.core.dim_labels UNION select '0x82af49447d8a07e3bd95bd0d56f35241523fbab1' as token_address, 'WETH' as token_name , 18 as decimal from arbitrum.core.dim_labels UNION select '0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f' as token_address, 'WBTC' as token_name , 8 as decimal from arbitrum.core.dim_labels UNION select '0xda10009cbd5d07dd0cecc66161fc93d7c9000da1' as token_address, 'DAI' as token_name, 18 as decimal from arbitrum.core.dim_labels UNION select '0x17fc002b466eec40dae837fc4be5c67993ddbd6f' as token_address, 'FRAX' as token_name, 18 as decimal from arbitrum.core.dim_labels UNION select '0xf97f4df75117a78c1a5a0dbb814af92458539fb4' as token_address, 'LINK' as token_name, 18 as decimal from arbitrum.core.dim_labels UNION select '0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9' as token_address, 'USDT' as token_name, 6 as decimal from arbitrum.core.dim_labels UNION select '0xfa7f8980b0f1e64a2062791cc3b0871572f1f7f0' as token_address, 'UNI' as token_name, 18 as decimal from arbitrum.core.dim_labels), swaps as ( select date(BLOCK_TIMESTAMP) as date, ORIGIN_FROM_ADDRESS , tx_hash, EVENT_INPUTS:inputToken as token_in, EVENT_INPUTS:inputValue as amount_in, EVENT_INPUTS:outputToken as token_out, EVENT_INPUTS:outputValue as amount_out from arbitrum.core.fact_event_logs where contract_address = lower('0xabbc5f99639c9b6bcb58544ddf04efa6802f4064') and EVENT_NAME = 'Swap' and origin_from_address = EVENT_INPUTS:sender) , from_token as ( select date, origin_from_address, tx_hash, token_name as token_in_symbol , amount_in/pow(10,decimal) as amt_in, token_out, amount_out from swaps a join tokens b on a.token_in = b.token_address) , to_token as ( select date, origin_from_address, tx_hash, token_in_symbol, amt_in , token_name as token_out_symbol, amount_out/pow(10,decimal) as amt_out from from_token a join tokens b on a.token_out = b.token_address) , price as ( select date(hour) as p_date, symbol , avg(price) as price from ethereum.core.fact_hourly_token_prices where symbol in ( select token_in_symbol from to_token) group by 1,2) , from_usd as ( select date, origin_from_address, tx_hash, token_in_symbol, amt_in, amt_in*price as amt_in_usd, token_out_symbol, amt_out from price a left outer join to_token b on a.p_date = b.date and symbol = token_in_symbol) , final as ( select date, origin_from_address, tx_hash, token_in_symbol, amt_in, amt_in_usd, token_out_symbol, amt_out, amt_out*price as amt_out_usd from price a left outer join from_usd b on a.p_date = b.date and symbol = token_out_symbol ) , tb as (select origin_from_address, count(DISTINCT(tx_hash)) as total_tx, sum(amt_out_usd) as total_volume, total_volume*0.3/100 as total_fees from final group by 1) select count(DISTINCT(origin_from_address)) as total, case when total_fees < 1 then 'Below 1$' when total_fees >= 1 and total_fees <= 5 then '1-5$' when total_fees > 5 and total_fees <= 10 then '6-10$' when total_fees > 10 and total_fees <= 15 then '11-15$' when total_fees > 15 and total_fees <= 25 then '16-25$' when total_fees > 25 and total_fees <= 50 then '26-50$' when total_fees > 50 and total_fees <= 75 then '51-75$' when total_fees > 75 and total_fees <= 100 then '76-100$' when total_fees > 100 and total_fees <= 125 then '101-125$' when total_fees > 125 and total_fees <= 150 then '126-150$' when total_fees > 150 and total_fees <= 200 then '151-200$' when total_fees > 200 and total_fees <= 250 then '201-250$' when total_fees > 250 then '+250$' end as category from tb where category is not null group by 2

GMX Protocol Overview