Afonso_Diaz by marketplace
    Updated 2025-04-15
    with

    main as (
    select
    tx_hash,
    block_timestamp,
    buyer_address,
    seller_address,
    price,
    platform_name,
    price_usd,
    nft_address,
    token_id,
    platform_fee_usd
    from
    near.nft.ez_nft_sales
    where
    nft_address = 'tinkerunion_nft.enleap.near'
    )

    select
    platform_name,
    count(distinct tx_hash) as transactions,
    sum(price) as volume_near,
    sum(price_usd) as volume_usd,
    sum(platform_fee_usd) as total_platform_fee_usd,
    avg(platform_fee_usd) as average_platform_fee_usd
    from
    main
    group by 1
    Last run: 22 days ago
    PLATFORM_NAME
    TRANSACTIONS
    VOLUME_NEAR
    VOLUME_USD
    TOTAL_PLATFORM_FEE_USD
    AVERAGE_PLATFORM_FEE_USD
    1
    Apollo42235100.861406476
    2
    Mitte17918.5254117.162649773
    3
    Paras5023120714.598618361866394.13573732817327.8827147473.449707887
    4
    Mintbase11355677.08757.0875
    5
    FewAndFar4123.7394.016688837
    6
    TradePort30616308.52996982332.525081144
    6
    306B
    2s