flipside

    new vs returning minters
    datavortexnew vs returning minters
    Updated 2025-03-02
    WITH minters AS (
    SELECT
    origin_from_address,
    MIN(DATE(block_timestamp)) AS first_mint_date
    FROM (
    SELECT 'Ethereum' AS chain, origin_from_address, block_timestamp
    FROM ethereum.core.ez_decoded_event_logs
    WHERE
    contract_address = LOWER('0x8236a87084f8B84306f72007F36F2618A5634494')
    AND decoded_log:from = '0x0000000000000000000000000000000000000000'
    AND event_name = 'Transfer'

    UNION ALL

    SELECT 'Base' AS chain, origin_from_address, block_timestamp
    FROM base.core.ez_decoded_event_logs
    WHERE
    contract_address = LOWER('0xecAc9C5F704e954931349Da37F60E39f515c11c1')
    AND decoded_log:from = '0x0000000000000000000000000000000000000000'
    AND event_name = 'Transfer'

    UNION ALL

    SELECT 'BSC' AS chain, origin_from_address, block_timestamp
    FROM bsc.core.ez_decoded_event_logs
    WHERE
    contract_address = LOWER('0xecAc9C5F704e954931349Da37F60E39f515c11c1')
    AND decoded_log:from = '0x0000000000000000000000000000000000000000'
    AND event_name = 'Transfer'
    ) t
    GROUP BY origin_from_address
    ),

    daily_minters AS (
    SELECT
    chain,
    Last run: 2 months ago
    CHAIN
    MINT_DATE
    NEW_MINTERS
    RETURNING_MINTERS
    1
    		Base2025-03-02 00:00:00.00002
    2
    		Ethereum2025-03-02 00:00:00.00003
    3
    		Ethereum2025-03-01 00:00:00.00013
    4
    		Base2025-03-01 00:00:00.00004
    5
    		BSC2025-03-01 00:00:00.00001
    6
    		Base2025-02-28 00:00:00.00013
    7
    		BSC2025-02-28 00:00:00.00004
    8
    		Ethereum2025-02-28 00:00:00.00026
    9
    		Ethereum2025-02-27 00:00:00.00017
    10
    		BSC2025-02-27 00:00:00.00001
    11
    		Base2025-02-27 00:00:00.00009
    12
    		Ethereum2025-02-26 00:00:00.00006
    13
    		Base2025-02-26 00:00:00.00036
    14
    		Ethereum2025-02-25 00:00:00.00036
    15
    		BSC2025-02-25 00:00:00.00003
    16
    		Base2025-02-25 00:00:00.000210
    17
    		Base2025-02-24 00:00:00.00003
    18
    		BSC2025-02-24 00:00:00.00001
    19
    		Ethereum2025-02-24 00:00:00.000110
    20
    		Base2025-02-23 00:00:00.00009
    ...
    416
    17KB
    41s