SalehTracking top Solana NFT Collections-Possibility of selling and buying from others
Updated 2022-05-02
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
›
⌄
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