flipside

    Joepegs Peon Public Mint
    cloudr3nJoepegs Peon Public Mint
    Updated 2022-08-22
    with mint_tb as (select event_inputs:tokenAmount::integer as mints, origin_from_address as minter, block_timestamp
    from avalanche.core.fact_event_logs
    where origin_to_address=lower('0x4c5A8B71330D751bf995472f3AB8CeB06a98dD47') and event_name='Mint' and origin_function_signature='0xb3ab66b0'
    )

    select date_trunc('SECOND',block_timestamp) as secs, count(mints) as minter_count, sum(mints) as mint_count, mints
    from mint_tb
    group by mints, secs

    Run a query to Download Data