where currency = 'A.ead892083b3e2c6c.DapperUtilityCoin'----ADRESS CONTRACT

and price is not null

group by 1

order by 2 DESC

limit 924),

eth as (select buyer_address, sum(price)---TOTALL VOLUME

from ethereum.core.ez_nft_sales----I US GENERAL TABEL

where currency_address = 'ETH'----ADRESS CONTRACT

and price is not null

group by 1

order by 2 desc

limit 17276),

sol as (

select purchaser, sum(sales_amount)---TOTALL VOLUME

from solana.core.fact_nft_sales---I US TABEL GENERAL SOL FOR SELL NFT DATA

group by 1

order by 2 desc

limit 5751)

select block_timestamp::date as times, case when

block_timestamp::date<= min_date+7 then 'New' else 'Old' end as type, count(1) as number_0f_transaction---count of number tx

from flow.core.fact_nft_sales as A

join(select nft_collection, min(block_timestamp::date) as min_date

from flow.core.fact_nft_sales----I US TABEL

group by 1

) as B on A.nft_collection = B.nft_collection

where buyer in (select buyer from flow)

and currency = 'A.ead892083b3e2c6c.DapperUtilityCoin'

and price is not null---VOLUME

and block_timestamp::date<current_date

group by 1,2