mz0111opti 9
    Updated 2023-02-23
    select
    SELLER_ADDRESS,
    count(distinct tx_hash) as "sales count",
    sum (price_usd) as "Total USD amount"
    from optimism.core.ez_nft_sales
    join optimism.core.dim_labels b on NFT_ADDRESS = address
    where BLOCK_TIMESTAMP >= CURRENT_DATE - {{period}}
    and PROJECT_NAME = 'project galaxy'
    and PRICE_USD is not null
    and project_name is not null
    group by 1
    order by 3 DESC
    limit 5
    Run a query to Download Data