mehrancrypto-dxoepqQ70-4
Updated 2022-10-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with tab1 as (
SELECT BUYER, min(BLOCK_TIMESTAMP::date) as daily
from flow.core.ez_nft_sales
where NFT_COLLECTION ilike '%raceday%'
and TX_SUCCEEDED ilike '%TRUE%'
group by 1
)
SELECT daily , count(buyer) as new_buyer,
sum(new_buyer) over(order by daily) as cumulative_new_buyer
from tab1
GROUP by 1
order by 3 DESC
Run a query to Download Data