TIME | AVG_BUERS | AVG_SELLERS | AVG_NFT_SOLD | AVG_SALE_COUNT | |
|---|---|---|---|---|---|
1 | WEEK | 595.387097 | 338.790323 | 1451.33871 | 1734.33871 |
0-MIDs3
Updated 2024-01-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
with tab1 as (
select date_trunc('week',BLOCK_TIMESTAMP) as week
,sum(PRICE_USD) as volume
,avg(PRICE_USD) as avg_volume
,count(distinct BUYER_ADDRESS) as buyers
,count(distinct SELLER_ADDRESS) as sellers
,count(distinct TOKENID) as nft_sold
,count(distinct TX_HASH) as sale_count
from bsc.nft.ez_nft_sales
where PROJECT_NAME='SPACE ID'
group by 1)
select 'WEEK' as time
,avg(buyers) as avg_buers
,avg(sellers) as avg_sellers
,avg(nft_sold) as avg_nft_sold
,avg(sale_count) as avg_sale_count
from tab1
group by 1
Last run: about 1 year agoAuto-refreshes every 24 hours
1
54B
4s