strawbettyunique buyers/sellers over time on Magic Eden for the Lightning OGs since February 5th
Updated 2022-04-05
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
›
⌄
-- Friktion Lightning OGs
-- Payout 0.54 SOL
-- Grand Prize 1.62 SOL
-- Level Beginner
-- Q45. Friktion has a community NFT created for its loyal supporters called the Lightning OGs.
-- How do these OG NFTs work?
-- Create a visualization showing unique buyers/sellers over time on Magic Eden for the Lightning OGs since February 5th.
-- Who is accumulating the OGs?
-- What percentage of OG holders have made a deposit into the SOL covered call Friktion volt since February 5th?
-- What are best utilities for NFTs across DeFi (cite other examples if you know any)? What are the most interesting ways
-- to integrate the OGs into the upcoming roadmap of Friktion? What utility would make the most sense?
-- Note: The most innovative idea can win a Lightning OG!
-- Hint: https://twitter.com/friktion_labs/status/1489835576945745922
-- Hint: use fact_nft_sales , dim_nft_metadata, and fact_events
-- Hint: https://magiceden.io/marketplace/lightning_ogs
-- Hint: https://docs.friktion.fi/
-- Sample SOL deposit: https://solscan.io/tx/4Fv3HzL5atPYHRcEVzuPCu2MwHb7qEBzwroBbXLiFDzrADp9CuypCCVMuUjRR33FamrNYzkJSqvCbGiF9rPzjfM2
-- Hint: SOL Covered Call Volt token mint: 4Hnh1UCC6HLzx9NaGKnTVHR2bANcRrhydumdHCnrT3i2"
with og_txns as (
select
m.contract_name,
s.*
from solana.fact_nft_sales s
join solana.dim_nft_metadata m on s.mint = m.mint and m.contract_name = 'Lightning OG'
where block_timestamp >= '2022-02-05'
and marketplace ilike '%magic eden%'
)
select
block_timestamp::date as date,
Run a query to Download Data