0xaimanFlloor Price of June NFTs on Solana
Updated 2022-06-15
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
›
⌄
select date_trunc('week',block_timestamp) as week, address_name, min(floor_price) as floor_price_
from (with ax as (with sales as (select block_timestamp, mint, min(sales_amount) as floor_price from solana.core.fact_nft_sales
where block_timestamp>='2022-06-01'
group by 1 ,2 order by 1),
label as (select address, address_name from solana.core.dim_labels)
select block_timestamp, mint, address_name,floor_price
from sales inner join label on sales.mint=label.address),
bx as (
select project, nft_holding_pattern, n_address_minter
from (select address_name as project,NFT_holding_pattern,count(purchaser) as n_address_minter
from (select address_name, purchaser, case
when xd=0 then 'Held'
when xd>=1 and xd<7 then 'Flipped after 7 day'
when xd>=7 and xd<14 then 'Flipped after 14 days'
when xd>14 then 'Held more than 2 weeks before flip'
end as NFT_holding_pattern
from (with held as (select mint, purchaser, datediff(day,t1,t2) as days_hold_bfore_sold
from
(with a as (select mint, purchaser, block_timestamp as t1,mint_price, count(tx_id) as n_nft_minted from solana.core.fact_nft_mints
where block_timestamp>='2022-06-01'
group by 1,2,3,4 order by 1),
b as (
Run a query to Download Data