Updated 2022-11-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
date_trunc('WEEK', block_timestamp) as date,
COUNT(DISTINCT TX_ID) as Nft_Sales,
COUNT(DISTINCT BUYER) as Buyers ,
COUNT(DISTINCT NFT_ID) as New_NFTs ,
COUNT(DISTINCT NFT_COLLECTION) as New_NFT_Collections ,
sum(PRICE) as volume,
sum(Buyers) over (order by date) as cumulative_Buyers_growth,
sum(Nft_Sales) over (order by date) as cumulative_Nft_Sales_growth,
sum(volume) over (order by date) as cumulative__volume_growth
FROM flow.core.ez_nft_sales WHERE TX_SUCCEEDED='TRUE'AND date > CURRENT_DATE - 365
GROUP by 1
order by date desc
Run a query to Download Data