SELECT

DATE_TRUNC('day', block_timestamp) as date,

SUM(transaction_fee) as daily_volume

FROM near.core.fact_transactions TABLESAMPLE(10)

WHERE block_timestamp >= '2024-07-23' -- 90 days before Oct 21

AND block_timestamp <= CURRENT_DATE

GROUP BY 1

SELECT

MEDIAN(CASE

WHEN date < '2024-10-21'

THEN daily_volume

END) as median_daily_volume_before_oct22,

MEDIAN(CASE

WHEN date >= '2024-10-22'

THEN daily_volume

END) as median_daily_volume_oct22_onwards

FROM daily_volumes;