DATE_TRUNC('day', block_timestamp) AS "Date",

symbol,

SUM(CASE WHEN source_chain = 'Aptos' THEN amount_in_usd ELSE 0 END) AS "Daily Bridge From Aptos Volume",

COUNT(DISTINCT CASE WHEN source_chain = 'Aptos' THEN sender ELSE NULL END) AS "Daily Bridge From Aptos Wallets",

COUNT(DISTINCT CASE WHEN source_chain = 'Aptos' THEN tx_hash ELSE NULL END) AS "Daily Bridge From Aptos Count",

SUM(CASE WHEN destination_chain = 'Aptos' THEN amount_in_usd ELSE 0 END) AS "Daily Bridge To Aptos Volume",

COUNT(DISTINCT CASE WHEN destination_chain = 'Aptos' THEN sender ELSE NULL END) AS "Daily Bridge To Aptos Wallets",

COUNT(DISTINCT CASE WHEN destination_chain = 'Aptos' THEN tx_hash ELSE NULL END) AS "Daily Bridge To Aptos Count"

aptos.defi.ez_bridge_activity

block_timestamp >= DATE_TRUNC('month', CURRENT_DATE)

GROUP BY

DATE_TRUNC('day', block_timestamp),

symbol

ORDER BY

"Date" ASC,

symbol ASC;