nft_address as address,

project_name as collection,

-- platform_name,

count(distinct buyer_address) as buyers,

count(distinct tx_hash) as txns,

avg(price_usd) as avg_priceUSD,

sum(price_usd) as volumeUSD

from ethereum.core.ez_nft_sales

where 1=1

and block_timestamp::date >= '2022-01-01'

-- and project_name = '10ktf'

and nft_address = '0x0cfb5d82be2b949e8fa73a656df91821e2ad99fd'

group by block_timestamp::date,

nft_address,

project_name

-- platform_name

order by date;

select *

from ethereum.core.ez_nft_sales

where nft_address in ('0x0cfb5d82be2b949e8fa73a656df91821e2ad99fd')

and platform_name = 'opensea'

and price_usd > 1000

select block_timestamp, tx_hash, nft_address, project_name, tokenid, currency_symbol, currency_address, price, price_usd

from ethereum.core.ez_nft_sales

where 1=1

and nft_address in ('0x60e4d786628fea6478f785a6d7e704777c86a7c6', '0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d', '0xba30e5f9bb24caa003e9f2f0497ad287fdf95623',

'0x7bd29408f11d2bfc23c34f18275bbf23bb716bc7', '0x19b86299c21505cdf59ce63740b240a9c822b5e4', '0x469823c7b84264d1bafbcd6010e9cdf1cac305a3')

and CURRENCY_SYMBOL = 'APE'

order by block_timestamp desc