Afonso_DiazTop Buyers
    Updated 2025-03-07
    with

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

    select
    buyer_address,
    count(distinct tx_hash) as transactions,
    sum(price) as volume,
    avg(price) as average_price,
    sum(price_usd) as volume_usd,
    avg(price_usd) as average_price_usd
    from
    main
    group by 1
    order by volume_usd desc
    limit 10