Flippppppatest query copy
    Updated 2024-11-05
    -- forked from test query @ https://flipsidecrypto.xyz/edit/queries/805ad5dc-2053-4237-abfe-17e37f21ff07

    select
    project_name,
    round(sum(mint_price_eth * nft_count),0) as eth_spent
    from ethereum.nft.ez_nft_mints
    where project_name is not null
    and nft_count > 0
    and nft_count is not null
    and project_name not in ('uniswap')
    and block_timestamp > current_date - interval '{{numDays}} days'
    group by 1
    order by eth_spent desc
    limit {{numRows}}


    QueryRunArchived: QueryRun has been archived