DATE_TRUNC('{{Granularity}}', BLOCK_TIMESTAMP) AS DATE,

COUNT(DISTINCT TX_HASH) AS BRIDGED_TXNS,

COUNT(DISTINCT RECEIVER) AS TOTAL_RECEIVERS,

COUNT(DISTINCT SENDER) AS TOTAL_SENDERS,

SUM(AMOUNT_USD) AS BRIDGED_VOL_USD,

SUM(BRIDGED_TXNS) OVER (ORDER by DATE) CUMULATIVE_BRIDGED_TX,

sum(BRIDGED_VOL_USD) OVER (ORDER by date) CUMULATIVE_BRIDGED_VOL_USD

FROM base.defi.ez_bridge_activity

WHERE BLOCK_TIMESTAMP IS NOT NULL

GROUP BY 1