rustygeePooly Minter Experience
    Updated 2022-12-28
    WITH minters AS (
    SELECT ORIGIN_FROM_ADDRESS
    FROM ETHEREUM.CORE.FACT_EVENT_LOGS
    WHERE
    contract_address = LOWER('0x90B3832e2F2aDe2FE382a911805B6933C056D6ed')
    OR contract_address = LOWER('0x3545192b340F50d77403DC0A64cf2b32F03d00A9')
    OR contract_address = LOWER('0x5663e3E096f1743e77B8F71b5DE0CF9Dfd058523')
    ORDER BY BLOCK_TIMESTAMP DESC
    ),

    number_of_txs as (
    SELECT ORIGIN_FROM_ADDRESS, COUNT(*) as nt
    FROM ethereum.core.fact_transactions tx
    RIGHT JOIN minters ON minters.ORIGIN_FROM_ADDRESS = tx.FROM_ADDRESS
    GROUP BY 1
    ),
    combined as (
    SELECT
    CASE
    WHEN nt < 5 AND nt > 0 THEN 'first time (5 tx)'
    WHEN nt > 1 AND nt <= 40 THEN 'average (< 40 txs)'
    WHEN nt > 40 AND nt <= 200 THEN 'seasoned (< 200 txs)'
    WHEN nt > 200 THEN 'veteran (> 200 txs)'
    END as funder_type,
    ORIGIN_FROM_ADDRESS,
    nt as Total_Transactions

    FROM number_of_txs
    GROUP BY 1, ORIGIN_FROM_ADDRESS, nt
    )

    SELECT
    funder_type,
    COUNT(*) as num_instances
    FROM combined
    GROUP BY funder_type
    Run a query to Download Data