date_trunc(day, block_TIMESTAMP) as date,

COUNT(DISTINCT TX_HASH) as txn,

count(DISTINCT FROM_ADDRESS) as user,

SUM(txn) over (order by date) as cumulative_txn,

sum(tx_fee) as Gas_fee,

SUM(Value) as Eth_trading_volume,

SUM(user) over (order by date) as cumulative_users

FROM blast.core.fact_transactions

WHERE

STATUS = 'SUCCESS' AND

block_timestamp::date >= '2024-02-29'

GROUP BY 1