Rodolfo-LimaNFT Traded per Buyer Type - Boryoku Dragonz
Updated 2023-05-18
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
›
⌄
⌄
/*Choose a NFT project from the following list and create a dashboard with the new Flipside dashboard layout
that can refresh once a day highlighting at least 4 metrics of your choosing that helps show the "health" of the project.
Note any noticeable trends or current events for the project.
Highlight how liquidity is flowing in and out of the project and what types of buyers and sellers are interacting with the project.*/
-- Boryoku DragonZ NFT
WITH NFT_BUYERS AS(
SELECT
PURCHASER,
COUNT(*) AS NFT_PURCHASES
FROM
solana.core.fact_nft_sales
GROUP BY 1
),
NFT_SALES AS (
SELECT
*,
DATE_TRUNC('day',BLOCK_TIMESTAMP) AS DATE
FROM
solana.core.fact_nft_sales
WHERE DATE_TRUNC('day',BLOCK_TIMESTAMP) >= '2021-11-04' -- DATE MINT
--AND (MARKETPLACE = 'magic eden v1' OR MARKETPLACE = 'magic eden v2')
AND MINT IN (SELECT
CONTRACT_ADDRESS
FROM
solana.core.dim_nft_metadata
WHERE (PROJECT_NAME LIKE '%Boryoku Dragonz%' OR CONTRACT_NAME LIKE '%Boryoku Dragonz%'
OR CREATOR_NAME LIKE '%Boryoku Dragonz%' OR TOKEN_NAME LIKE '%Boryoku Dragonz%'))
ORDER BY 2 ASC),
SOL_PRICE_TAB AS (
SELECT
DATE_TRUNC('day',BLOCK_TIMESTAMP) AS DATE,
AVG(SWAP_TO_AMOUNT/SWAP_FROM_AMOUNT) AS SOL_PRICE
FROM
Run a query to Download Data