SELECT

DATE_TRUNC('day', block_timestamp) AS date,

SUM(amount_usd) AS daily_volume

FROM

avalanche.defi.ez_bridge_activity

WHERE

amount_usd IS NOT NULL

GROUP BY

date

SELECT

AVG(daily_volume) AS avg_bridged_volume

FROM

totals;