select * --contract_address, count(*)

from arbitrum.core.fact_event_logs

where --tx_hash = '0xc93383f92879c6f0f81bf9bb6df212f54e84ba15f2d611985c82c9399b264dde' and

origin_to_address in ('0xe592427a0aece92de3edee1f18e0157c05861564')

qualify row_number() over (partition by tx_hash order by event_index asc) = 1

),

token_data as (

select

block_timestamp,

-- contract_address,

case

when contract_address = '0xfa7f8980b0f1e64a2062791cc3b0871572f1f7f0' then 'UNI'

when contract_address = '0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9' then 'USDT'

when contract_address = '0xff970a61a04b1ca14834a43f5de4533ebddb5cc8' then 'USDC'

when contract_address = '0xf97f4df75117a78c1a5a0dbb814af92458539fb4' then 'LINK'

when contract_address = '0x11cdb42b0eb46d95f990bedd4695a6e3fa034978' then 'CRV'

when contract_address = '0x82af49447d8a07e3bd95bd0d56f35241523fbab1' then 'WETH'

when contract_address = '0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f' then 'WBTC'

when contract_address = '0x66ba30d5d7c66afd4ed41c3498ec9e20a03a1368' then 'eFIL'

-- when contract_address = '0xfc5a1a6eb076a2c7ad06ed22c90d7e710e35ad0a' then 'GMX'

-- when contract_address = '0xd74f5255d557944cf7dd0e45ff521520002d5748' then 'USDs'

when contract_address = '0xda10009cbd5d07dd0cecc66161fc93d7c9000da1' then 'DAI'

when contract_address = '0x5575552988a3a80504bbaeb1311674fcfd40ad4b' then 'SPA'

else 'others' end as token_name0,

event_inputs:value as token_amount0

from token_transfer

where token_name0 != 'others'

),

token_price as (

hour::date as date,

symbol,

decimals,

avg(price) as price

from ethereum.core.fact_hourly_token_prices