arctic-night-foxdaily PackNFT sold
Updated 2022-07-04
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
›
⌄
with allDAy as (
SELECT
DATE_TRUNC ('day' ,BLOCK_TIMESTAMP ) as daily,
sum(price) AS price
FROM flow.core.fact_nft_sales
WHERE nft_collection like '%AllDay%'
AND TX_SUCCEEDED = 'TRUE'
GROUP BY daily
ORDER BY daily
),
avg as (
SELECT
sum(price) / COUNT (DISTINCT DATE_TRUNC ('day' ,BLOCK_TIMESTAMP )) as avrage
FROM flow.core.fact_nft_sales
WHERE nft_collection like '%PackNFT%'
AND TX_SUCCEEDED = 'TRUE'
)
SELECT
daily,
price,
avrage
FROM
allDAy,avg
Run a query to Download Data