SELECT date_trunc('hour',a.block_timestamp) as hour,

source_chain,

count(DISTINCT sender) as n_senders,

count(DISTINCT tx_hash) as n_bridges,

sum(amount*price) as vol

FROM axelar.core.ez_satellite a

LEFT JOIN osmosis.core.ez_prices b

on a.token_symbol = b.symbol AND date_trunc('hour',a.block_timestamp) = b.recorded_hour

WHERE destination_chain = 'cosmoshub'

AND a.block_timestamp::date >= '2023-05-01'

GROUP BY 1,2