select

hour,

token_address,

symbol,

decimals,

avg (price) as usd_amount

from crosschain.price.ez_prices_hourly

group by 1,2,3,4)

SELECT

COUNT(DISTINCT tx_hash) AS total_transaction_count,

COUNT(DISTINCT sender) AS unique_sender,

-- COUNT(DISTINCT receiver) AS unique_receiver,

SUM(amount*usd_amount) AS total_transaction_volume,

total_transaction_count / unique_sender AS average_transactions_per_sender,

total_transaction_volume / unique_sender AS average_volume_per_sender,

-- total_transaction_count / unique_receiver AS average_transactions_per_receiver,

-- total_transaction_volume / unique_receiver AS average_volume_per_receiver,

total_transaction_volume / total_transaction_count AS average_volume_per_transaction,

FROM

axelar.defi.ez_bridge_satellite t1 join price t2 on date_trunc('hour', t1.block_timestamp) = t2.hour and t1.token_address = t2.token_address

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