samMints Overview copy
    Updated 2024-12-13
    -- -- forked from alitaslimi / Mints Overview @ https://flipsidecrypto.xyz/alitaslimi/q/GHVSCKpKnFC_/mints-overview

    -- with
    -- logs as (
    -- select
    -- block_number,
    -- block_timestamp,
    -- tx_hash,
    -- origin_from_address,
    -- origin_to_address,
    -- origin_function_signature,
    -- '0x' || right(topics[1], 40) as from_address,
    -- '0x' || right(topics[2], 40) as to_address,
    -- livequery.utils.udf_hex_to_int(topics[3]) as token_id
    -- from
    -- core.core.fact_event_logs
    -- where
    -- tx_succeeded
    -- and block_timestamp::date >= '2024-12-12'
    -- and contract_address = '0xe48696582061011beadcdb1eb132ff2261ced5cf'
    -- and topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef' -- ERC-20 & ERC-721
    -- and topics[1] is not null
    -- and topics[2] is not null
    -- ),
    -- mints as (
    -- select
    -- block_timestamp,
    -- tx_hash,
    -- to_address as minter,
    -- token_id
    -- from
    -- logs
    -- where
    -- from_address = '0x0000000000000000000000000000000000000000'
    -- )
    -- select
    QueryRunArchived: QueryRun has been archived