Afonso_Diazgrouping buyers
    Updated 2025-07-06
    with

    pricet as (
    select
    hour::date as date,
    avg(price) as price_usd
    from aptos.price.ez_prices_hourly
    where symbol = 'APT'
    group by 1
    ),

    main as (
    select
    tx_hash,
    block_timestamp,
    seller_address,
    buyer_address,
    'Near' as chain,
    platform_fee_usd,
    price_usd as price_usd
    from near.nft.ez_nft_sales
    where block_timestamp::date >= '2024-01-01'

    union all

    select
    tx_hash,
    block_timestamp,
    seller_address,
    buyer_address,
    'Aptos' as chain,
    platform_fee_usd,
    total_price * price_usd as price_usd
    from aptos.nft.ez_nft_sales
    left join pricet on date = block_timestamp::date
    where block_timestamp::date >= '2024-01-01'
    Last run: 29 days ago
    CHAIN
    TYPE
    BUYERS
    1
    Aptosb. 2 - 10 Transactions55206
    2
    Aptosh. More than 50 Transactions2284
    3
    Aptosc. 11 - 25 Transactions2431
    4
    Aptosa. 1 Transaction308094
    5
    Nearb. 2 - 10 Transactions12138
    6
    Nearh. More than 50 Transactions980
    7
    Neara. 1 Transaction16190
    8
    Nearc. 11 - 25 Transactions1419
    8
    323B
    205s