thea[Blur Mega] NFT Traders Penetration on Ethereum
    Updated 2023-04-13
    with all_trader as (
    select block_date,
    sum(wallets) over (order by block_date rows between unbounded preceding and current row ) as cum_walltes
    from (
    select block_date,
    count(wallets) as wallets
    from (
    select *,
    row_number() over (partition by wallets order by block_timestamp) as rnk
    from (
    select block_timestamp,
    to_date(date_trunc('day', block_timestamp)) as block_date,
    buyer_address as wallets
    from ethereum.core.ez_nft_sales
    where price_usd is not null
    union all
    select block_timestamp,
    to_date(date_trunc('day', block_timestamp)) as block_date,
    seller_address as wallets
    from ethereum.core.ez_nft_sales
    where price_usd is not null
    )
    )
    where rnk = 1
    group by 1
    )
    ),
    trader as (
    select block_date,
    platform_name,
    sum(wallets)
    over (partition by platform_name order by block_date rows between unbounded preceding and current row ) as cum_walltes
    from (
    select block_date,
    platform_name,
    count(wallets) as wallets
    Run a query to Download Data