select date_trunc (day,block_timestamp) as day,

'0xffff003a6bad9b743d658048742935fffe2b6ed7' as token_address,

'KET' as symbol,

'18' as decimals,

avg (amount_in_usd/amount_out) as USDPrice

from avalanche.defi.ez_dex_swaps

where (symbol_in = 'WAVAX' or symbol_in ilike 'USDC')

and (symbol_out = 'KET' or token_out = '0xffff003a6bad9b743d658048742935fffe2b6ed7')

and block_timestamp >= '2025-02-05'

group by 1,2,3,4 having USDPrice < 10

union all

select hour::date as day,

token_address,

'USDC' as symbol,

decimals,

avg (price) as usdprice

from avalanche.price.ez_prices_hourly

where token_address ilike '0xB97EF9Ef8734C71904D8002F8b6Bc66Dd9c48a6E'

group by 1,2,3,4),

SimpleSwap as (

block_timestamp,

tx_hash,

decoded_log:maker as maker,

decoded_log:makerAsset as makerAsset,

decoded_log:makerAmountReceived as makerAmountReceived,

decoded_log:taker as taker,

decoded_log:takerAsset as takerAsset,

decoded_log:takerAmountReceived as takerAmountReceived,

decoded_log

avalanche.core.ez_decoded_event_logs