msafadoostNFL ALL DAY sales volume growth
Updated 2022-09-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
›
⌄
WITH sale_volume AS (
SELECT date(BLOCK_TIMESTAMP) as dates,
sum(PRICE) as prices,
COUNT(TX_ID) AS number_of_sales,
COUNT(DISTINCT(buyer)) AS number_of_buyers,
COUNT(DISTINCT(seller)) AS number_of_sellers
FROM flow.core.fact_nft_sales
WHERE NFT_COLLECTION = 'A.e4cf4bdc1751c65d.AllDay'
AND BLOCK_TIMESTAMP >= '2022-08-04'
AND BLOCK_TIMESTAMP <= '2022-08-28'
AND TX_SUCCEEDED = 'TRUE'
GROUP by 1
),
prices AS (
SELECT date(TIMESTAMP) as dates,
avg(PRICE_USD) as prices2
FROM flow.core.fact_prices
WHERE SYMBOL LIKE 'FLOW'
AND TIMESTAMP >= '2022-08-04'
AND TIMESTAMP <= '2022-08-28'
GROUP by 1
)
SELECT dates,
sum(prices*prices2) as daily_price,
sum(daily_price)over(order by dates) as cumulative_price,
number_of_sales,
sum(number_of_sales)over(order by dates) as cumulative_sales,
number_of_buyers,
number_of_sellers
FROM prices JOIN sale_volume USING(dates)
GROUP by 1,4,6,7
ORDER by 1
Run a query to Download Data