select

'2025-02-12'::date as dt,

0.05 as price

from avalanche.price.ez_prices_hourly

where hour::date = '2025-02-12'

group by 1

union all

select

trunc(block_timestamp, 'day') as dt,

avg(amount_in_usd/amount_out) as price

from avalanche.defi.ez_dex_swaps

where symbol_in in ('WAVAX','USDC')

and (symbol_out = 'WINK'

or token_out = '0x7698a5311da174a95253ce86c21ca7272b9b05f8')

and block_timestamp >= '2025-02-12'

and block_timestamp < '2025-02-18'

group by 1

having price < 1

union all

select

date_trunc('day',hour) as dt,

avg(price) as price

from avalanche.price.ez_prices_hourly

where token_address = '0x7698a5311da174a95253ce86c21ca7272b9b05f8'

and hour::date >= '2025-02-18'

group by 1

),

buy as ( -- swaps

SELECT

block_timestamp,

TX_HASH,

ORIGIN_FROM_ADDRESS as swapper,

AMOUNT_OUT as swap_to_amount,

AMOUNT_OUT*price as swap_to_amount_usd,

upper(symbol) as swap_from_token,