date_trunc(day, block_TIMESTAMP) AS DATE,

COUNT(DISTINCT TX_HASH) AS tx_COUNT,

COUNT(DISTINCT FROM_ADDRESS) AS User_count,

Tx_Count/User_Count as "# TX per User",

sum(tx_COUNT) over(order by date) as "Total # TXs"

blast.core.fact_transactions

1 = 1

and STATUS = 'SUCCESS'

and block_timestamp >= '2024-02-29'

group by

1

order by date desc