freemartianMinters Etherum Transaction Profile
    Updated 2022-06-09
    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'
    )

    SELECT
    (CASE WHEN BLOCK_TIMESTAMP < '2022-05-05' THEN 'Before PreMint'
    ELSE 'After PreMint' END) AS "Minter Status",
    COUNT (DISTINCT FROM_ADDRESS) AS "Count"
    FROM ethereum.core.FACT_TRANSACTIONS
    WHERE FROM_ADDRESS in (SELECT NFT_TO_ADDRESS FROM minters)
    GROUP BY 1
    Run a query to Download Data