Moe1 Quixotic NFT
Updated 2022-08-04Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select
date_trunc(week,BLOCK_TIMESTAMP) as weeks,
count(distinct BUYER_ADDRESS) as unique_purchasers,
100*((unique_purchasers-lag(unique_purchasers,1)over(order by weeks))/lag(unique_purchasers,1)over(order by weeks)) as weekly_change_unique_purchasers,
count(distinct SELLER_ADDRESS) as unique_sellers,
100*((unique_sellers-lag(unique_sellers,1)over(order by weeks))/lag(unique_sellers,1)over(order by weeks)) as weekly_change_unique_sellers,
count(distinct TX_HASH) as sales,
100*((sales-lag(sales,1)over(order by weeks))/lag(sales,1)over(order by weeks)) as weekly_change_sales
--sum(sales)over(order by days asc) as cum_sale
from optimism.core.ez_nft_sales
where
PLATFORM_NAME ilike 'Quixotic'
group by 1
Run a query to Download Data