SalehTracking top Solana NFT Collections-Possibility of selling and buying from others
    Updated 2022-05-02
    with nfts as (
    select
    distinct address_name as collection, address
    from solana.dim_labels
    where (
    address_name ilike ('Aurory') or
    address_name ilike ('Astrals') or
    address_name ilike ('degods token') or
    address_name ilike ('Pesky Penguins') or
    address_name ilike ('Degenerate Ape Academy') or
    address_name ilike ('stoned ape crew token') or
    address_name ilike ('Cets on Creck') or
    address_name ilike ('Taiyo Robotics') or
    address_name ilike ('SolGods') or
    address_name ilike ('Portals') or
    address_name ilike ('HD Boryoku Dragonz') or
    address_name ilike ('catalina whale mixer token') or
    address_name ilike ('galactic geckos token') or
    address_name ilike ('Thugbirdz') or
    address_name ilike ('mindfolk token') or
    address_name ilike ('solsteads surreal estate token') or
    address_name ilike ('Famous Fox Federation') or
    address_name ilike ('Shadowy Super Coder DAO') or
    address_name ilike ('Solana Monkey Business') or
    address_name ilike ('Meerkat Millionaires Country Club')
    )
    order by address_name
    ),
    sales as (
    select
    block_timestamp,
    n.collection,
    mint,
    purchaser,
    sales_amount as selling_price,
    lag(purchaser, 1) ignore nulls over (partition by mint order by block_timestamp asc) as seller,
    Run a query to Download Data