Flippppppatest query copy
Updated 2024-11-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
-- 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