mattkstewQuixotic NFT Dashboard 9
    Updated 2022-08-03
    select
    date_trunc('day', block_timestamp),
    count(*) as Sales,
    count(distinct seller_address) as Unique_Seller,
    count(distinct buyer_address ) as Unique_Buyer
    from optimism.core.ez_nft_sales left outer join optimism.core.dim_labels
    on address = nft_address
    where price_usd is not null
    and project_name is not null
    group by 1

    Run a query to Download Data