SELECT

--Date_trunc('day', Block_timestamp) AS Date,

SUM(AMOUNT_USD) AS Total_Traded_Volume,

COUNT(DISTINCT FROM_ADDRESS) AS Total_Traders,

COUNT(DISTINCT TX_HASH) AS TOTAL_TRADES

FROM near.core.ez_token_transfers

WHERE block_timestamp :: Date = Current_date - 1

--WHERE SYMBOL ILIKE 'NEAR'

GROUP BY 1

SELECT

Date,

Total_Traded_Volume,

SUM(Total_Traded_Volume) OVER (ORDER BY Date) AS Cumul_volume,

Total_Traders,

SUM(Total_Traders) OVER (ORDER BY Date) AS Cumul_Traders,

TOTAL_TRADES,

SUM(TOTAL_TRADES) OVER (ORDER BY Date) AS Cumul_Trades

FROM Main