KaskoazulUntitled Query
    Updated 2022-10-11
    with sellers as (
    select block_timestamp::date as fecha,
    seller_address as address
    from ethereum.core.ez_nft_sales
    ),

    buyers as (
    select block_timestamp::date as fecha,
    seller_address as address
    from ethereum.core.ez_nft_sales
    )

    select date_trunc ('month', fecha) as dia,
    count (distinct address) as unique_users
    from (select * from sellers
    union all
    select * from buyers)
    group by fecha
    order by fecha desc


    Run a query to Download Data