with price as(

SELECT

HOUR::date as date,

token_address,

AVG(price) as avg_price

FROM crosschain.price.fact_hourly_token_prices

GROUP BY 1,2

)

SELECT

date_trunc(day, block_timestamp):: date as date,

sum(amount * avg_price) as Bridge_Volume,

avg(amount * avg_price) as Avg_Volume,

count(DISTINCT sender) as No_of_users,

count(DISTINCT tx_hash) as No_of_bridges,

count(DISTINCT a.TOKEN_ADDRESS) as No_of_tokens

FROM axelar.defi.ez_bridge_squid a JOIN price p on a.block_timestamp::date = p.date and a.token_address = p.token_address

WHERE block_timestamp::date BETWEEN '2024-01-01' AND '2024-03-31'

GROUP BY 1