BLOCK_TIMESTAMP :: date AS date,

COUNT(DISTINCT FROM_ADDRESS) AS unique_addresses,

SUM(unique_addresses) OVER(

ORDER BY

date ROWS BETWEEN UNBOUNDED PRECEDING

AND CURRENT ROW

) AS cumulative_addresses,

COUNT(TX_HASH) AS transactions,

SUM(transactions) OVER(

ORDER BY

date ROWS BETWEEN UNBOUNDED PRECEDING

AND CURRENT ROW

) AS cumulative_transactions,

AVG(transactions) OVER (

ORDER BY

date ROWS BETWEEN 5 PRECEDING

AND CURRENT ROW

) AS transactions_MA5,

SUM(TX_FEE) AS fees_paid,

AVG(TX_FEE) AS average_fee,

SUM(fees_paid) OVER(

ORDER BY

date ROWS BETWEEN UNBOUNDED PRECEDING

AND CURRENT ROW

) AS cumulative_paid_fees

FROM

polygon.core.fact_transactions

WHERE

date >= '2022-07-01'

AND date < CURRENT_DATE

GROUP BY

date

ORDER BY

date DESC