with pricet as (

select

hour::date as p_date,

symbol,

avg(price) as usd_price

from crosschain.price.ez_prices_hourly

where blockchain = 'ethereum'

group by 1 ,2

count(distinct tx_hash) as txs,

count(distinct receiver) as receivers,

count(distinct sender) as senders,

count(distinct source_chain_name) as sources,

count(distinct destination_chain_name) as destinations,

count(distinct b.symbol) as tokens,

round(sum((amount_unadj/pow(10, decimals))*usd_price),0) as amount_usd

from aptos.defi.fact_bridge_activity a

join aptos.core.dim_tokens b using(token_address)

join pricet c on block_timestamp::date = p_date::date and lower(b.symbol) = lower(c.symbol)

where platform = 'layerzero'

and block_timestamp::date >= '2024-01-01'