Tobi_12024-06-09 10:57 AM
Updated 2024-08-22
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
›
⌄
WITH NFT_Sales_Last_30_Days AS (
SELECT
COUNT(*) AS nfts_sold_last_30_days
FROM
polygon.nft.ez_nft_sales
WHERE
BLOCK_TIMESTAMP >= DATEADD(DAY, -30, CURRENT_TIMESTAMP())
AND BLOCK_TIMESTAMP < CURRENT_TIMESTAMP()
),
NFT_Sales_Previous_30_Days AS (
SELECT
COUNT(*) AS nfts_sold_previous_30_days
FROM
polygon.nft.ez_nft_sales
WHERE
BLOCK_TIMESTAMP >= DATEADD(DAY, -60, CURRENT_TIMESTAMP())
AND BLOCK_TIMESTAMP < DATEADD(DAY, -30, CURRENT_TIMESTAMP())
)
SELECT
nfts_sold_last_30_days,
nfts_sold_previous_30_days,
CASE
WHEN nfts_sold_previous_30_days = 0 THEN NULL
ELSE (nfts_sold_last_30_days - nfts_sold_previous_30_days) / nfts_sold_previous_30_days::FLOAT * 100
END AS percentage_increase
FROM
NFT_Sales_Last_30_Days,
NFT_Sales_Previous_30_Days;
QueryRunArchived: QueryRun has been archived