Drsimonkem 3-1
    Updated 2025-01-10
    select
    'https://basescan.org/address/' || BUYER_ADDRESS AS BUYER_ADDRESS,
    count(distinct tx_hash) as nft_sales ,
    count(distinct tokenid) ,
    sum(price) as price_eth,
    sum(price_usd) as price_usd,
    sum(TOTAL_FEES) as "TOTAL FEES (ETH)",
    sum(TOTAL_FEES_USD) as "TOTAL FEES (USD)"
    from base.nft.ez_nft_sales
    where nft_address = lower('0xee7d1b184be8185adc7052635329152a4d0cdefa')
    group by 1
    order by 2 desc
    offset 1 rows FETCH first 10 rows only
    Last run: 3 months agoAuto-refreshes every 12 hours
    BUYER_ADDRESS
    NFT_SALES
    COUNT(DISTINCT TOKENID)
    PRICE_ETH
    PRICE_USD
    TOTAL FEES (ETH)
    TOTAL FEES (USD)
    1
    https://basescan.org/address/0x5149ae7f9445e70331608ea03c592c078ae7399d17116223.040879459.2021281.077385753625.705090473
    2
    https://basescan.org/address/0xc044282f35f0aaed53c530ee226698ae9cc0ab5110810513.66069169746063.5189089190.48152272741617.364967721
    3
    https://basescan.org/address/0xef0b56692f78a44cf4034b07f80204757c31bcc989888.39775245927682.7817089880.2614268565865.549839429
    4
    https://basescan.org/address/0xd875e4d4637577e5e9ab4808cb321d8e03aa5c33687211.55341459.4080050.49664841801.5701431
    5
    https://basescan.org/address/0x69c5669e9d4fe33a51d4ff31c1d5248d1a0d7cfb67654.4766513881.0828750.17832939560.512702689
    6
    https://basescan.org/address/0xd0ab651368836f98dc35f2a6989a3636c8eb115767714.652614844.756450.1843376589.494544118
    7
    https://basescan.org/address/0xb06239263faa19f29115c5b527854f1ae2acd7e365713.8898899911673.5039165360.1468607497433.566526601
    8
    https://basescan.org/address/0x8e0b43e2c16cc5f54dc00ae49096261522e5aed063712.44178324.4949730.09087351310.066811286
    9
    https://basescan.org/address/0xad569083dee565d4ddb648f32fa392d6d42864c661688.26518925607.620280260.32674479491048.724128019
    10
    https://basescan.org/address/0x50e56eae322c9efa5b420e50fd5d00d36f6d619659593.237910230.0330090.12523685398.536125822
    10
    1KB
    4s