fb3ce38c-7bfe-475c-bca8-3f1e44ae80a62023-09-26 04:41 PM copy
    Updated 2023-10-02

    SELECT
    COUNT(from_address)total_moments_minted,
    To_address AS contract,
    CASE WHEN LOWER(TO_ADDRESS) ='0xca28251acf27e55fdbfbf997397a28db122e70b2'
    THEN 'Base (BRKWY)'
    WHEN LOWER(TO_ADDRESS) ='0x88f685878261a3c29e6015e1560c01aa148e1d5b'
    THEN 'Base 2022-23 Expansion Pack (BRKWY)'
    WHEN LOWER(TO_ADDRESS)='0x78cda9b5fa2b74274c83747083f319c14584b53b'
    THEN 'Preseason Starter Pack (BRKWY)'
    WHEN LOWER(TO_ADDRESS)='0xabae4022c87bc74f4b2c525f52710fbd5822160f'
    THEN 'The Hunt for Stanley 2023 Debut LE (BRKWY)'
    WHEN LOWER(TO_ADDRESS)='0xa6536e1947e3c8317c2b13f7692936d52783e1a4'
    THEN 'Inaugural Founding Fan Base Pack (BRKWY)'
    ELSE 'other'
    END AS pack_drop,
    DATE_TRUNC('hour', block_timestamp) AS date


    FROM polygon.core.fact_transactions

    WHERE FROM_ADDRESS ='0x610123c1f5e34974c63343c84973cd5603b08e7c'
    AND pack_drop <> 'other'

    GROUP BY contract,pack_drop,date



    Run a query to Download Data