SELECT

TX_ID,

BLOCK_TIMESTAMP,

AMOUNT,

FLOW_WALLET_ADDRESS,

BLOCKCHAIN

FROM

flow.defi.ez_bridge_transactions

COUNT(TX_ID) AS total_transactions,

BLOCKCHAIN,

COUNT(TX_ID) AS transactions_per_blockchain,

AVG(AMOUNT) AS average_amount_per_transaction,

COUNT(TX_ID) * 1.0 / COUNT(DISTINCT DATE_TRUNC('day', BLOCK_TIMESTAMP)) AS average_transactions_per_day

transactions_all_time

GROUP BY

BLOCKCHAIN

ORDER BY

transactions_per_blockchain DESC;