headitmanagervolume of collections
Updated 2022-06-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with nft_collections_count as (select count(distinct NFT_COLLECTION) from flow.core.fact_nft_sales)
, 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
Run a query to Download Data