Updated 10 days ago
    with

    main as (
    select * from $query('30cc1e7e-5555-4111-b772-0dfb21b067b1')
    )

    select
    count(distinct tx_hash) as transactions,
    count(distinct buyer_address) as buyers,
    count(distinct seller_address) as sellers,
    count(distinct token_id) as nfts,
    sum(price) as volume,
    avg(price) as average_price,
    sum(price_usd) as volume_usd,
    avg(price_usd) as average_price_usd
    from
    main

    Last run: 10 days ago
    TRANSACTIONS
    BUYERS
    SELLERS
    NFTS
    VOLUME
    AVERAGE_PRICE
    VOLUME_USD
    AVERAGE_PRICE_USD
    1
    851016303604101143625.9037481322.5954972781685271.9903735933.29721594
    1
    80B
    1s