flipside

    Phase1 vs Phase2 total mints
    freemartianPhase1 vs Phase2 total mints
    Updated 2025-02-24
    with mints AS (
    SELECT
    block_timestamp,
    tx_hash,
    (CASE
    WHEN decoded_log:dropStageIndex = 1 THEN 'Phase1'
    WHEN decoded_log:dropStageIndex = 2 THEN 'Phase2'
    END
    ) AS phase,
    decoded_log:feeRecipient AS fee_recipient,
    decoded_log:minter AS minter,
    decoded_log:quantityMinted AS quantity_minted,
    decoded_log:unitMintPrice / pow(10,18) AS unit_mint_price,
    unit_mint_price * quantity_minted AS mint_price,
    FROM ethereum.core.ez_decoded_event_logs
    WHERE block_timestamp::date >= '2024-12-20'
    -- AND block_timestamp::date <= '2024-12-21'
    -- AND tx_hash = lower('0x750d65f99cd335a12a08738bd8442ddf9b998377ae2e1df9fd1495466b50580e')
    AND event_name = 'SeaDropMint'
    AND decoded_log:nftContract = lower('0x9830b32f7210f0857A859c2A86387e4d1bB760B8')
    ),

    phase1 AS(
    SELECT * FROM mints
    where phase = 'Phase1'
    ),

    phase2 AS(
    SELECT * FROM mints
    where phase = 'Phase2'
    )


    SELECT
    phase,
    count(tx_hash) AS transactions,