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,