AzinTotal
    Updated 2025-03-12
    Select
    count(*) as transactions_number ,
    count(distinct BUYER_ADDRESS) as buyer_number,
    count(distinct SELLER_ADDRESS) as seller_number ,
    count(distinct NFT_ADDRESS) as nft_number ,
    sum(TOTAL_PRICE_USD) as seals_volume ,
    sum(PLATFORM_FEE_USD) as PLATFORM_FEE_USD ,
    sum(case when BLOCK_TIMESTAMP>current_date-1 then TOTAL_PRICE_USD else 0 end) as volume_24

    from
    aptos.nft.ez_nft_sales
    where
    PLATFORM_NAME='Topaz'

    Last run: about 1 month ago
    TRANSACTIONS_NUMBER
    BUYER_NUMBER
    SELLER_NUMBER
    NFT_NUMBER
    SEALS_VOLUME
    PLATFORM_FEE_USD
    VOLUME_24
    1
    92289811798617094249940217661555.00361291018086.020254133.322130891
    1
    77B
    19s