shrimpboxcumulative sales
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
WITH DailySales AS (
SELECT
DATE(BLOCK_TIMESTAMP) AS SaleDate,
SUM(PRICE_USD) AS TotalDailySales
FROM ethereum.nft.ez_nft_sales
where nft_address = lower('0xBC4CA0EdA7647A8aB7C2061c2E118A18a936f13D')
GROUP BY SaleDate
),
CumulativeSales AS (
SELECT
SaleDate,
SUM(TotalDailySales) OVER (ORDER BY SaleDate) AS CumulativeSalesUSD
FROM DailySales
)
SELECT *
FROM CumulativeSales;
Run a query to Download Data