binhachonMoonbirds Gas Fees - Compare with Shinsei Galverse Official
    Updated 2022-04-21
    with mint_transactions as (
    select
    block_timestamp,
    tx_fee as mint_fee,
    'Moonbird' as NFT,
    floor(mint_fee, 3) as rounded_mint_cost
    from ethereum_core.fact_transactions
    where block_timestamp > '2022-04-10'
    and to_address = '0x23581767a106ae21c074b2276d25e5c3e136a68b'
    and origin_function_signature = '0x0dfd025a'
    and status = 'SUCCESS'
    union all
    select
    block_timestamp,
    tx_fee as mint_fee,
    'Shinsei Galverse' as NFT,
    floor(mint_fee, 3) as rounded_mint_cost
    from ethereum_core.fact_transactions
    where block_timestamp > '2022-04-10'
    and to_address = '0x582048c4077a34e7c3799962f1f8c5342a3f4b12'
    and origin_function_signature = '0x1b59169d'
    and status = 'SUCCESS'
    )
    select
    NFT,
    rounded_mint_cost::string --Just to make the chart easier to read
    as rounded_mint_cost,
    count(*) as number_of_transactions,
    100 * ratio_to_report(number_of_transactions) over (partition by NFT) as percentage
    from mint_transactions
    group by 1, 2

    Run a query to Download Data