winnie-fsLeaderboard ATH copy
    Updated 2024-11-07
    -- forked from Alex_Dyan / Leaderboard ATH @ https://flipsidecrypto.xyz/Alex_Dyan/q/r7zgNWNAFlBN/leaderboard-ath

    select
    PROJECT_NAME,
    sum(PRICE_USD) as alltime_volume_USD
    from
    base.nft.ez_nft_sales
    where
    PROJECT_NAME is not null
    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'
    and PROJECT_NAME != 'BaseZuki'
    QueryRunArchived: QueryRun has been archived