mehrancrypto-dxoepqUntitled Query
9
1
2
3
4
5
6
7
8
9
›
⌄
with tab1 as ( SELECT BUYER_ADDRESS,PLATFORM_NAME , min( BLOCK_TIMESTAMP::date) as creation
from ethereum.core.ez_nft_sales
where EVENT_TYPE = 'sale'
GROUP by 1 , 2
)
SELECT creation , PLATFORM_NAME , COUNT(BUYER_ADDRESS) as new_users ,
sum(new_users) over(partition by PLATFORM_NAME order by creation) as cumulative
from tab1
GROUP by 1 , 2
Run a query to Download Data