CryptoIcicleFlow-10.NFT Buying Behavior on Flow - Flow
Updated 2022-07-16
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
›
⌄
-- NFT Buying Behavior on Flow
-- Payout 39.84 FLOW
-- Grand Prize 119.52 FLOW
-- Level Intermediate
-- Q10. Create a series of dashboards comparing wallet behavior for buying and selling NFTs on Flow compared to on Ethereum and Solana.
-- Is there more or less "whale" activity on Flow compared to each of the other chains?
-- What do "whales" tend to focus on in Flow?
-- How common is "flipping" on Flow (selling within 24 hrs, within a week etc) compared to other chains, or do wallets tend to hold onto their NFTs?
-- Are wallets more interested in new projects, or already existing projects on Flow?
with buyers_flow as (
select
distinct buyer as wallet,
count(distinct nft_id) as n_nfts,
iff(n_nfts > 100,'buyer-whale', 'buyer-average') as type
from flow.core.fact_nft_sales
where block_timestamp >= '2022-05-09'
group by wallet
),
sellers_flow as (
select
distinct seller as wallet,
count(distinct nft_id) as n_nfts,
iff(n_nfts > 100,'seller-whale', 'seller-average') as type
from flow.core.fact_nft_sales
where block_timestamp >= '2022-05-09'
group by wallet
),
flow_sales as (
(
select
block_timestamp::date as date,
b.type,
count(distinct b.wallet) as n_wallets,
count(distinct nft_id) as n_nfts
Run a query to Download Data