SELECT block_timestamp as trade_time, origin_from_address AS user_address, event_inputs:amount AS amount,

case when contract_address = lower('0x3E4a3a4796d16c0Cd582C382691998f7c06420B6') then 'USDT'

when contract_address = lower('0x22B1Cbb8D98a01a3B71D034BB899775A76Eb1cc2') then 'MATIC'

when contract_address = lower('0x3d4Cc8A61c7528Fd86C55cfe061a78dCBA48EDd1') then 'DAI'

when contract_address = lower('0x0000000000000000000000000000000000000000') then 'WETH'

when contract_address = lower('0xb98454270065A31D71Bf635F6F7Ee6A518dFb849') then 'WBTC'

when contract_address = lower('0x3666f603Cc164936C1b87e207F36BEBa4AC5f18a') then 'DAI'

end as currency, event_inputs:chainId AS dest_chainId, event_inputs:recipient AS dest_address,

'ETH' AS origin_chain, origin_function_signature, tx_hash

FROM ethereum.core.fact_event_logs

WHERE ( contract_address = lower('0x3E4a3a4796d16c0Cd582C382691998f7c06420B6')

or contract_address = lower('0x22B1Cbb8D98a01a3B71D034BB899775A76Eb1cc2')

or contract_address = lower('0x3d4Cc8A61c7528Fd86C55cfe061a78dCBA48EDd1')

or contract_address = lower('0x0000000000000000000000000000000000000000')

or contract_address = lower('0xb98454270065A31D71Bf635F6F7Ee6A518dFb849')

or contract_address = lower('0x3666f603Cc164936C1b87e207F36BEBa4AC5f18a')

)

AND event_name = 'TransferSentToL2'

AND tx_status = 'SUCCESS'

limit 5

),

base2 as (select *, a.decimals, a.price

from base1 b

left join ethereum.core.fact_hourly_token_prices a

on b.currency = a.symbol

where datediff(min, b.trade_time, a.hour) >= 0 and (datediff(min, b.trade_time, a.hour)<60) )