2844percentage of OG holders have made a deposit into the sol volt
Updated 2022-03-30
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
›
⌄
WITH buyers AS (
SELECT fact_nft_sales.purchaser
from solana.fact_nft_sales INNER JOIN solana.dim_nft_metadata
WHERE fact_nft_sales.mint = dim_nft_metadata.mint
AND fact_nft_sales.marketplace LIKE '%magic%'
AND fact_nft_sales.succeeded = 'true'
AND fact_nft_sales.block_timestamp >= '2022-02-05'
AND dim_nft_metadata.contract_name like '%Lightning%'
GROUP BY purchaser),
OGs AS (
SELECT block_timestamp, instruction:parsed:info:source AS Holders
FROM solana.fact_events
WHERE block_timestamp >= '2022-02-05'
AND instruction:parsed:info:mint = '4Hnh1UCC6HLzx9NaGKnTVHR2bANcRrhydumdHCnrT3i2'
AND instruction:parsed:info:source in (SELECT fact_nft_sales.purchaser
from solana.fact_nft_sales INNER JOIN solana.dim_nft_metadata
WHERE fact_nft_sales.mint = dim_nft_metadata.mint
AND fact_nft_sales.marketplace LIKE '%magic%'
AND fact_nft_sales.succeeded = 'true'
AND fact_nft_sales.block_timestamp >= '2022-02-05'
AND dim_nft_metadata.contract_name like '%Lightning%'
GROUP BY purchaser))
SELECT COUNT(DISTINCT OGs.holders)/COUNT(DISTINCT buyers.purchaser)*100 AS "Percentageof OG holders have made a deposit into the SOL covered call Friktion volt since February 5th"
From buyers,OGs
Run a query to Download Data