SyndicaSOL, MATIC, AVAX, BNB, ARB NFT Mints Gas Prices
    Updated 2025-04-02
    with

    avalanche_mints as (
    SELECT
    CONCAT(nft_address, token_id) AS nft,
    case
    when erc1155_value is not null then 'erc1155'
    else 'erc721'
    end as token_standard,
    min_data.mint_date,
    tx_hash
    FROM avalanche.nft.ez_nft_transfers AS transfers
    JOIN (
    SELECT
    CONCAT(nft_address, token_id) AS nft,
    MIN(block_timestamp) AS mint_date
    FROM avalanche.nft.ez_nft_transfers
    GROUP BY CONCAT(nft_address, token_id)
    HAVING MIN(block_timestamp) >= '2025-03-01'
    AND MIN(block_timestamp) < '2025-04-01'
    ) AS min_data
    ON CONCAT(transfers.nft_address, transfers.tokenid) = min_data.nft
    AND transfers.block_timestamp = min_data.mint_date
    )

    , avalanche as (
    select
    'avalanche' as blockchain
    , token_standard
    , min(tx_fee * price)/100 as min_gas_used_usd
    , max(tx_fee * price)/100 as max_gas_used_usd
    , avg(tx_fee * price)/100 as avg_gas_used_usd
    , median(tx_fee * price)/100 as median_gas_used_usd
    from avalanche.core.fact_transactions tx inner join avalanche_mints m
    on tx.tx_hash = m.tx_hash
    left join ethereum.price.ez_prices_hourly p
    Last run: 24 days ago
    BLOCKCHAIN
    TOKEN_STANDARD
    MIN_GAS_USED_USD
    MAX_GAS_USED_USD
    AVG_GAS_USED_USD
    MEDIAN_GAS_USED_USD
    1
    aptosv10.000166590.557511890.032917719720.00808848
    2
    aptosv20.003620950.0955840.0082001766420.00866598
    3
    arbitrumerc11550.00009868822180.95025209540.0083116686870.007303075122
    4
    arbitrumerc7210.000096537410096.0430192390.021887602830.001155374813
    5
    avalancheerc11550.000016616727050.62009857590.0097864293190.005091875908
    6
    avalancheerc7210.000010707894010.659893760.00060085038380.0002715699955
    7
    bnberc115500.50240016170.082520313320.007099063897
    8
    bnberc72103.3660076210.035116800060.007051161226
    9
    polygonerc1155012.4297630960.0058833103240.002416193699
    10
    polygonerc721023.2315299050.0041183192760.001980963835
    11
    seiregular0.00193330360.050478532050.0058487737760.002124525595
    12
    solanacompressed4.10530018e-160.50414940.00077442282630.00100869668
    13
    solanaregular4.10530018e-16195.5340864090.01021732480.001451640364
    13
    940B
    312s