select

hour::date as price_date

,symbol

,decimals

,avg (price) as token_price

from ethereum.core.fact_hourly_token_prices

where (symbol = 'USDC' or symbol ='MIM' or symbol ='LINK' or symbol ='USDT'

or symbol ='WETH' or symbol ='WBTC' or symbol ='DAI' or symbol ='FRAX'

or token_address ='0x1f9840a85d5af5bf1d1762f925bdaddc4201f984')

group by price_date,symbol,decimals

,lst_gmx_data as (

select

block_timestamp

,tx_hash

,origin_from_address

,event_inputs:value as volume

,case contract_address

when '0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9' then 'USDT'

when '0x17fc002b466eec40dae837fc4be5c67993ddbd6f' then 'FRAX'

when '0xfa7f8980b0f1e64a2062791cc3b0871572f1f7f0' then 'UNI'

when '0x82af49447d8a07e3bd95bd0d56f35241523fbab1' then 'WETH'

when '0xff970a61a04b1ca14834a43f5de4533ebddb5cc8' then 'USDC'

when '0xfea7a6a0b346362bf88a9e4a88416b77a57d6c2a' then 'MIM'

when '0xf97f4df75117a78c1a5a0dbb814af92458539fb4' then 'LINK'

when '0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f' then 'WBTC'

when '0xda10009cbd5d07dd0cecc66161fc93d7c9000da1' then 'DAI'

else contract_address

end as Token

from arbitrum.core.fact_event_logs

where (origin_to_address = '0x3d6ba331e3d9702c5e8a8d254e5d8a285f223aba'

or origin_to_address='0xb87a436b93ffe9d75c5cfa7bacfff96430b09868')

and not(event_inputs:value is null)

and event_name = 'Transfer'

and tx_status= 'SUCCESS'