maybeyonasmoonbird_mint_dist
    Updated 2022-04-20
    with
    moon_mints as (
    select
    block_timestamp,
    tx_hash,
    event_inputs:to::string as user,
    event_inputs:tokenId::string as token
    from ethereum_core.fact_event_logs
    where contract_address = '0x23581767a106ae21c074b2276d25e5c3e136a68b'
    and event_name = 'Transfer'
    and event_inputs:from::string = '0x0000000000000000000000000000000000000000'
    )

    select
    block_timestamp,
    count(token) as mints
    from moon_mints
    group by 1

    Run a query to Download Data