WITH daily_volumes AS (
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS day,
COUNT(TX_ID) AS daily_volume
FROM
sei.core.fact_msg_attributes
WHERE
TX_SUCCEEDED = TRUE
GROUP BY
DATE_TRUNC('day', BLOCK_TIMESTAMP)
)
SELECT
AVG(daily_volume) AS avg_daily_volume,
MEDIAN(daily_volume) AS median_daily_volume,
MAX(daily_volume) AS max_daily_volume
FROM
daily_volumes;