where price < 1000

group by 1

order by 2 desc

limit 10)

, nft_topbuyer_chart as (select count(distinct TX_HASH) as count , sum (price) as amount ,buyer , to_date(block_timestamp) as date

from ethereum.core.ez_nft_sales

inner join nft_topbuyer on BUYER_ADDRESS=buyer

group by 3,4)

select buyer , amount from nft_topbuyer