select date_trunc (day,block_timestamp) as day,

'0x7a842193d291840fc38b45f991c5b8cc908f8a7c' as token_address,

'PLSR' 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 = 'PLSR' or token_out = '0x7a842193d291840fc38b45f991c5b8cc908f8a7c')

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),

maindextable as (

select block_timestamp,

tx_hash,

origin_from_address,

case when platform ilike '%trader-joe%' then 'Trader Joe'

when platform ilike '%uniswap%' then 'Uniswap'

when platform ilike '%pharaoh%' then 'Pharaoh' else initcap(platform) end as dex,

Token_In,

symbol_in,

Amount_In,

Amount_In_USD,

Token_Out,

symbol_out,