Lordking852
Updated 2022-12-06
999
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
›
⌄
/*As I can see in this section, various data related to NFT Topshot collection are shown In the month of March 2021, the highest price and transaction volume was recorded for this NFT collection, and after that it has steadily decreased. Also, the price changes on a daily basis are also shown in the above chart, and the price floor of this NFT collection is also shown. it has been shown.*/
with a as
(SELECT
sum(PRICE) as volume ,
avg (PRICE) as prices ,
DATE_TRUNC('day',BLOCK_TIMESTAMP) as date
FROM flow.core.ez_nft_sales
WHERE
LOWER(NFT_COLLECTION)
ilike ('%TopShot%')
and PRICE > 1 and BLOCK_TIMESTAMP::date between '2020-10-14' and '2020-10-21'
group by date
)
, B AS (
SELECT * FROM (SELECT
PRICESS ,DATE ,
LAG(PRICESS,1) IGNORE NULLS OVER (ORDER BY date) as a,
Run a query to Download Data