with priceTB as (

select

HOUR::date as p_date,

SYMBOL,

avg(PRICE) as price

from ronin.price.ez_prices_hourly

group by 1,2

, swap_from as (

BLOCK_TIMESTAMP,

'Swap From' as swap_type,

TX_HASH,

ORIGIN_FROM_ADDRESS as trader,

t.SYMBOL as SYMBOL_in,

AMOUNT_USD,

AMOUNT*price as AMOUNT_USD_IN

FROM ronin.core.ez_token_transfers t

LEFT JOIN priceTB p on t.SYMBOL=p.SYMBOL and trunc(t.BLOCK_TIMESTAMP, 'd')=p.p_date

where ORIGIN_TO_ADDRESS in (

,'0xa35a88753a6a32fde5738c26644a383d29684b03'

,'0x41c7778f7472c0f3177732a1d71c3f0613074401'

,'0xa650570c41ee2f8448a40e2b45c92f5d2ba13d2f'

,'0xc99a6a985ed2cac1ef41640596c5a5f9f4e19ef5'

,'0x69e2099fbc9020f8dd29c2d959ca15e5d529f041'

,'0xca11bde05977b3631167028862be2a173976ca11'

,'0x77f96cf7b98b963fb8a9b84787806d396d953b2b'

,'0x8417ac6838be147ab0e201496b2e5edf90a48cc5'

,'0xf8cdefa80fa07e0f38dad87cb8c2679d3e00b227'

,'0x3bf61bac291e999813332340947942b74ab0dd92'

,'0x3b3adf1422f84254b7fbb0e7ca62bd0865133fe3'

,'0x9d381565d0bfe916360a7e92f1cb686fb67f8902'

,'0x133fa77dea36b311292201efddfc58cbe3a140b7'