*,

sum(NET_BUY_AMT_USD) over (ORDER BY day) as cumulative_NET_BUY_AMT_USD

FROM (

SELECT --*

date_trunc('day', block_timestamp) as day,

sum(CASE WHEN symbol_out like 'BLUR' THEN AMOUNT_OUT_USD ELSE 0 END) as BLUR_BUY_AMT,

sum(CASE WHEN symbol_in like 'BLUR' THEN AMOUNT_IN_USD ELSE 0 END) as BLUR_SELL_AMT,

COUNT(DISTINCT CASE WHEN symbol_out like 'BLUR' THEN ORIGIN_FROM_ADDRESS END) as BLUR_BUY_Users,

COUNT(DISTINCT CASE WHEN symbol_in like 'BLUR' THEN ORIGIN_FROM_ADDRESS END) as BLUR_SELL_users,

sum(CASE WHEN symbol_out like 'BLUR' THEN amount_out_usd ELSE 0 END) - sum(CASE WHEN symbol_in like 'BLUR' THEN amount_in_usd ELSE 0 END) as NET_BUY_AMT_USD

FROM ethereum.core.ez_dex_swaps

WHERE (symbol_in LIKE 'BLUR' or symbol_out LIKE 'BLUR')

GROUP BY 1

HAVING day > '2023-02-13'