Updated 2022-10-06
    with project1 as (
    SELECT A.PLATFORM_NAME , A.BUYER_ADDRESS , min(BLOCK_TIMESTAMP::date ) as launch_date
    from ethereum.core.ez_nft_sales A
    where CURRENCY_SYMBOL ilike '%ETH%'
    and ( A.PLATFORM_NAME = 'x2y2' or A.PLATFORM_NAME = 'looksrare' or A.PLATFORM_NAME = 'opensea' )
    GROUP by 1 , 2

    )
    , project2 as (
    SELECT BLOCK_TIMESTAMP::date as daily , A.PLATFORM_NAME , count(DISTINCT A.BUYER_ADDRESS) as number
    from ethereum.core.ez_nft_sales A , project1 B
    where CURRENCY_SYMBOL ilike '%ETH%'
    and A.BUYER_ADDRESS = B.BUYER_ADDRESS
    and daily = launch_date
    and A.PLATFORM_NAME = B.PLATFORM_NAME

    GROUP by 1 , 2
    )
    , tab3 as (
    SELECT daily , PLATFORM_NAME , sum(number) over(PARTITION BY PLATFORM_NAME order by daily) as cumulative
    from project2
    )
    SELECT daily , PLATFORM_NAME , cumulative
    from tab3
    where daily >= '2022-01-01'
    Run a query to Download Data