kellenNFT Movement
Updated 2022-06-26
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
WITH base AS (
SELECT s.mint, s.purchaser, s.block_timestamp AS date, s.sales_amount AS price
FROM solana.fact_nft_sales s
JOIN solana.dim_labels l ON l.address = s.mint
WHERE l.label = 'okay bears' AND s.mint = '2E9NM1zugqH253SKiUDN22xnaVgH5vZz44Pv1e4V3PZq'
UNION
SELECT s.mint, s.purchaser, s.block_timestamp AS date, s.mint_price AS price
FROM solana.fact_nft_mints s
JOIN solana.dim_labels l ON l.address = s.mint
WHERE l.label = 'okay bears' AND s.mint = '2E9NM1zugqH253SKiUDN22xnaVgH5vZz44Pv1e4V3PZq'
)
SELECT * FROM base ORDER BY date
Run a query to Download Data