, nft_count as (select count(distinct NFT_ID) from flow.core.fact_nft_sales)

, buyer_count as (select count(distinct BUYER) from flow.core.fact_nft_sales)

, seller_count as (select count(distinct SELLER) from flow.core.fact_nft_sales)

, volume as (select sum(price), block_timestamp::date from flow.core.fact_nft_sales

where block_timestamp::date > '2022-05-09'

group by block_timestamp::date)

, number as (select count(1), block_timestamp::date from flow.core.fact_nft_sales

where block_timestamp::date > '2022-05-09'

group by block_timestamp::date)

, volume_collections as (select sum(price), nft_collection from flow.core.fact_nft_sales

where block_timestamp::date > '2022-05-09'

group by nft_collection)

, number_collection as (select count(1), nft_collection from flow.core.fact_nft_sales

where block_timestamp::date > '2022-05-09'

group by nft_collection)

, buyer_nft_collections as (select count(distinct buyer) as count , nft_collection from flow.core.fact_nft_sales

group by nft_collection)

, seller_nft_collections as (select count(distinct seller) as count , nft_collection from flow.core.fact_nft_sales

group by nft_collection)

select * from volume_collections