winnie-fs2023-03-22 03:31 PM
    Updated 2023-04-18
    select
    project_name,
    round(sum(mint_price_eth * nft_count),0) as eth_spent
    from ethereum.core.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 '7 days'
    group by 1
    order by eth_spent desc
    limit 60
    Run a query to Download Data