freemartianBefore & After PreMint Announcement
Updated 2022-06-09
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
›
⌄
WITH minters as (
SELECT TOKENID, BLOCK_TIMESTAMP, MINT_PRICE_ETH, NFT_TO_ADDRESS
FROM ethereum.core.ez_nft_mints
WHERE NFT_ADDRESS = LOWER('0x903E2F5d42EE23156D548DD46bb84B7873789E44')
AND BLOCK_TIMESTAMP < '2022-06-07 17:00:00.000'
),
before_pm AS (
SELECT
COUNT (DISTINCT FROM_ADDRESS) AS before_count
FROM ethereum.core.FACT_TRANSACTIONS
WHERE FROM_ADDRESS in (SELECT NFT_TO_ADDRESS FROM minters)
AND BLOCK_TIMESTAMP::date < '2022-05-05'
),
after_pm AS (
SELECT
COUNT (DISTINCT FROM_ADDRESS) AS after_count
FROM ethereum.core.FACT_TRANSACTIONS
WHERE FROM_ADDRESS in (SELECT NFT_TO_ADDRESS FROM minters)
AND BLOCK_TIMESTAMP::date >= '2022-05-05'
)
SELECT before_count AS count , 'Before PreMint 'AS "Minter Etherum Status" FROM before_pm
UNION
SELECT (after_count - before_count) AS COUNT, 'After PreMint' AS "Minter Etherum Status" FROM before_pm,after_pm
Run a query to Download Data