Moe1 Quixotic NFT
    Updated 2022-08-04
    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