msafadoostgenerated sales volume over time
Updated 2022-07-24
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 top10 AS (
SELECT {{Features}} as typess,
sum(PRICE) as volume
FROM flow.core.fact_nft_sales JOIN flow.core.dim_topshot_metadata USING(NFT_ID)
WHERE TX_SUCCEEDED = 'TRUE'
GROUP by 1
ORDER by 2 DESC
LIMIT 10
),
types AS (
SELECT
DATE(BLOCK_TIMESTAMP) AS dates,
{{Features}} as typesss,
sum(PRICE) as volume,
COUNT({{Features}}) as counts
FROM flow.core.fact_nft_sales JOIN flow.core.dim_topshot_metadata USING(NFT_ID)
WHERE TX_SUCCEEDED = 'TRUE'
AND {{Features}} IN (
SELECT typess
FROM top10
)
GROUP by 1,2
),
usd_prices AS (
SELECT DATE(TIMESTAMP) as dates,
avg(PRICE_USD) AS usd_price
FROM flow.core.fact_prices
WHERE TOKEN = 'Flow'
GROUP by 1
)
SELECT dates,
typesss,
volume*usd_price as usd_prices,
sum(usd_prices)over(partition by typesss ORDER by dates) as cumulative,
counts
FROM types JOIN usd_prices USING(dates)
Run a query to Download Data