CryptoIcicleSolana-42.The Rise of DeGods - NFT Sales
Updated 2022-07-17
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
›
⌄
-- Payout 0.81 SOL
-- Grand Prize 2.43 SOL
-- Level Intermediate
-- Q42. DeGods have risen to become one of the most valuable NFT collections on Solana with an extremely devoted community.
-- Create visualizations showing sales volume and unique wallet purchases since January 1st on Magic Eden.
-- Using the NFT metadata, are there certain traits that have become more popular over time in anticipation of DeadGods?
-- $DUST is the token created by DeGods for NFT auctions and will be a necessity for modifying the DeGod art to a DeadGod.
-- Who is swapping for $DUST on Jupiter?
-- Is it correlated with the wallets that have purchased the most DeGods?
-- What do you think will happen to the price of the DeGods collection and $DUST when DeadGods launches on March 31st?
-- Explainer on DeadGods: https://twitter.com/DeGodsNFT/status/1506097466071871495
-- Explainer on $DUST: https://twitter.com/DeGodsNFT/status/1482314189595033601
-- Hint: Use fact_nft_sales, fact_swaps, and dim_nft_metadata
with sales as (
select
s.block_timestamp,
s.tx_id,
s.purchaser,
s.sales_amount,
m.*
from solana.fact_nft_sales s
join solana.dim_nft_metadata m on s.mint = m.mint
where marketplace = 'magic eden v1'
and m.token_name = 'DeGods'
and block_timestamp >= '2022-01-01'
),
swappers as (
select
*
from solana.fact_swaps
where swap_to_mint = 'DUSTawucrTsGU8hcqRdHDCbuYhCPADMLM2VcCb8VnFnQ' -- DUST token address
and block_timestamp >= '2022-01-01'
Run a query to Download Data