SyndicaSOL, MATIC, AVAX, BNB, ARB NFT Mints Gas Prices
    Updated 2025-05-12
    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-04-01'
    AND MIN(block_timestamp) < '2025-05-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: 18 days ago
    BLOCKCHAIN
    TOKEN_STANDARD
    MIN_GAS_USED_USD
    MAX_GAS_USED_USD
    AVG_GAS_USED_USD
    MEDIAN_GAS_USED_USD
    1
    aptosv10.000207060.119166480.011668374740.005904905
    2
    aptosv20.003210740.094249920.0052806322210.00433048
    3
    arbitrumerc11550.000082472724751.6434569920.0088022481970.002689775047
    4
    arbitrumerc7210.000078773141855.397158760.018920376120.001531451399
    5
    avalancheerc11553.931909963e-100.11139627480.0067045056550.003036510978
    6
    avalancheerc7211.25473425e-130.083447370170.00099968306840.0005362045857
    7
    bnberc11550.000041950156580.01627994470.012237090640.01257219729
    8
    bnberc72100.1873956450.007606361750.005946095326
    9
    polygonerc11550.000156376440312.5648747880.005880423590.002464773917
    10
    polygonerc721097.0925307090.0042485336060.001834489167
    11
    seiregular0.006847312290.0238702150.015407946710.01543238516
    12
    solanacompressed3.2821527e-160.61861230.00077032476980.00087904
    13
    solanaregular3.34471605e-1667.29899550.011172305060.00189568
    13
    956B
    430s