CarlOwOsGoblers: mints
Updated 2022-11-30Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH mints AS (
SELECT
block_timestamp::DATE AS date,
COUNT(*) AS mint_count
FROM
ethereum.core.ez_nft_mints
WHERE
nft_address ilike '0x60bb1e2AA1c9ACAfB4d34F71585D7e959f387769'
GROUP BY
1
)
SELECT
*,
SUM(mint_count) OVER (ORDER BY date) AS cumulative_mints,
CASE
WHEN date <= '2022-11-07' THEN 'Before Market Downturn'
ELSE 'Market Downturn'
END AS label
FROM
mints
Run a query to Download Data