adambalaTOP 5 buyer -- number of transactions
    Updated 2022-12-09
    SELECT
    count(distinct TX_HASH ) as txs , BUYER_ADDRESS AS ADDRESS ,'BUYER for ' AS TITLE
    FROM ethereum.core.ez_nft_sales
    WHERE EVENT_TYPE = 'sale' and CURRENCY_SYMBOL = 'ETH' and NFT_ADDRESS=lower('0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d')
    group by 2,3 order by 1 desc limit 5
    Run a query to Download Data