CryptoIcicleAlgo-107.NFDomains
Updated 2022-06-24
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
›
⌄
-- Q107. NFDomains are .ALGO domains NFTs that have launched on Algorand. Lets look how many domains NFDomains have sold
-- Payout 318.044 ALGO
-- Grand Prize 954.13 ALGO
-- Level Intermediate
-- Q107. NFDomains are .ALGO domains NFTs that have launched on Algorand. Lets look how many domains NFDomains have sold
-- -Look at number of NFDomains have sold by day and how much revenue they have generated for NFDomains?
-- -Look at how many wallets have bought an NFDomain by day.
-- -Show the distribution of the number of NFDomains purchased by wallet.
-- -Show the distribution of the amount of ALGOs spent on NFDomains purchased by wallet.
-- -What are the top 10 biggest NFDomain sales?
-- -Note any other interesting insights such as fees generated from secondary sales or average purchase price of an NFDomain sale.
-- Tips: To look at NFDomain sales: https://app.nf.domains/analytics
-- - Purchase Example https://algoexplorer.io/tx/group/2a1wrzaz%2FhaZFtf%2BBhx4yunYcG3cTkM0MzVXfx7InSQ%3D
-- Purchase Example https://algoexplorer.io/tx/group/Cs1brThgZs0saXCcjGbxMcA29pWLsk5WBT28wPhG%2FbE%3D
with nfts as (
select * from flipside_prod_db.algorand.asset
where asset_name ilike '%.algo'
and total_supply = 1
and asset_deleted = 'FALSE'
),
sale_txns as (
select
t.tx_id,
t.amount as n_nfts
from flipside_prod_db.algorand.transfers t join nfts n where t.asset_id = n.asset_id
),
txns as (
select
n_nfts,
t.*
from flipside_prod_db.algorand.payment_transaction t join sale_txns s on t.tx_id = s.tx_id
where receiver = 'RSV2YCHXA7MWGFTX3WYI7TVGAS5W5XH5M7ZQVXPPRQ7DNTNW36OW2TRR6I'
Run a query to Download Data