swaptx as (

select distinct

tx_hash

from

avalanche.core.ez_decoded_event_logs

where

origin_to_address = lower('0x60aE616a2155Ee3d9A68541Ba4544862310933d4')

and event_name = 'Swap'

and tx_status = 'SUCCESS'

),

pricet as (

select

hour::date as day,

t1.symbol,

t1.address,

t1.decimals,

avg(price) as USDPrice

from

avalanche.core.dim_contracts t1

join ethereum.core.fact_hourly_token_prices t2 on t1.symbol = t2.symbol

where

hour >= '2021-06-29 04:40:31.000'

group by

1,

2,

3,

4

union ALL

select

hour::date as day,

t1.symbol,

t1.address,

t1.decimals,

'1' as usdprice