winnie-fsBar 2
Updated 2024-11-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from Alex_Dyan / Leaderboard 7D @ https://flipsidecrypto.xyz/Alex_Dyan/q/wFGeWDLpSx4p/leaderboard-7d
select
PROJECT_NAME,
sum(PRICE_USD) as sevenday_volume_usd
from
base.nft.ez_nft_sales
where
PROJECT_NAME is not null
and BLOCK_TIMESTAMP >= CURRENT_TIMESTAMP - interval '7 days'
and PROJECT_NAME != 'Dryads'
and PROJECT_NAME != 'MagicBooks'
and PROJECT_NAME != 'Star Wars Outlaws'
and PROJECT_NAME != 'VeeCon 2024 Tickets'
and PROJECT_NAME != 'Pingu'
and PROJECT_NAME != 'BEEPLE - FAKE RARE'
and PROJECT_NAME != 'Anime Mochi'
and PROJECT_NAME != 'Based Zaza'
and PROJECT_NAME != 'Vegetables'
and PROJECT_NAME != 'Birds'
and PROJECT_NAME != 'Fruit'
and PROJECT_NAME != 'NoUnkes'
and PROJECT_NAME != 'Skies'
and PROJECT_NAME != 'Minerals'
and PROJECT_NAME != 'Jewels'
and PROJECT_NAME != 'Fruit flowers'
and PROJECT_NAME != 'Vegetable flowers'
and PROJECT_NAME != 'Lil Penguins'
and PROJECT_NAME != 'Motorcycles'
and PROJECT_NAME != 'Flowers'
and PROJECT_NAME != 'Marine'
and PROJECT_NAME != 'd00punks'
and PROJECT_NAME != 'Capy Friends'
and PROJECT_NAME != 'Match'
and PROJECT_NAME != 'MEME WL'
and PROJECT_NAME != 'BaseApe'
QueryRunArchived: QueryRun has been archived