SELECT

--date_trunc('day', block_timestamp) as date,

NFT_ADDRESS,

project_name,

count (distinct TX_HASH) as count_this

from ethereum.core.ez_nft_sales

where event_type='sales'

group by NFT_ADDRESS,project_name

order by count_this desc

limit 10

SELECT

--date_trunc('day',block_timestamp) as date,

PROJECT_NAME,

currency_symbol,

count (DISTINCT TOKENID) as count_token

from ethereum.core.ez_nft_sales

where event_type = 'sale'

group by PROJECT_NAME,currency_symbol

order by count_token desc

limit 10

select DISTINCT PROJECT_NAME,platform_name from ethereum.core.ez_nft_sales