msafadoostdaily sales volume
Updated 2022-07-01
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
35
36
›
⌄
WITH sale_volume AS (
SELECT date(BLOCK_TIMESTAMP) as dates,
sum(PRICE) as prices,
'Top Shot' as label
FROM flow.core.fact_nft_sales
WHERE NFT_COLLECTION = 'A.0b2a3299cc857e29.TopShot'
GROUP by 1
UNION
SELECT date(BLOCK_TIMESTAMP) as dates,
sum(PRICE),
'All Day' as label
FROM flow.core.fact_nft_sales
WHERE NFT_COLLECTION = 'A.e4cf4bdc1751c65d.AllDay'
GROUP by 1
UNION
sELECT date(BLOCK_TIMESTAMP) as dates,
sum(PRICE),
'Ufc Nft' as label
FROM flow.core.fact_nft_sales
WHERE NFT_COLLECTION = 'A.329feb3ab062d289.UFC_NFT'
GROUP by 1
),
prices AS (
SELECT date(TIMESTAMP) as dates2,
avg(PRICE_USD) as prices2
FROM flow.core.fact_prices
WHERE SYMBOL LIKE 'FLOW'
GROUP by 1
)
SELECT dates,
label,
sum(prices*prices2) as daily_price,
sum(daily_price)over(partition by label order by dates)
FROM prices JOIN sale_volume ON dates2 = dates
GROUP by 1,2
Run a query to Download Data