misaghlbAB2 Gallery Wallets - wallets over time
Updated 2022-05-23
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
›
⌄
SELECT date(a.block_timestamp) as date, COUNT(DISTINCT b.sender) as wallets
from flipside_prod_db.algorand.transactions a
join flipside_prod_db.algorand.transactions b on a.tx_group_id = b.tx_group_id and b.TX_TYPE_NAME = 'asset transfer' and a.sender != b.sender
WHERE try_base64_decode_string(a.tx_message:txn:note::string) = 'ab2.gallery'
and a.TX_TYPE_NAME = 'asset transfer'
and a.tx_message:txn:aclose is not NULL
-- and tx_group_id = 'wWE2i1LDwQBpKv+RGPNGcNvKm7VrmskGUyV4snkFS1w='
GROUP by date
-- Q78. Let’s look at wallets that buy from AB2 Gallery!
-- How many wallets are buying NFTs on AB2 gallery. What is the total number of unique wallets that have purchased from AB2?
-- Create a distribution plot of how many NFTs each wallet has purchased from AB2.
-- Are we seeing new wallets purchasing on AB2 or is it only wallets that have purchased from AB2 before? Chart the first purchase on AB2 by wallet over time.
-- Create a table of the top 10 wallets that are purchasing from AB2 by ALGOs and number of NFTs
-- Tips: Check out this analysis for some inspiration on how to write your queries: https://app.flipsidecrypto.com/dashboard/15-ab-2-gallery-nf-ts-77b-ew https://ab2.gallery/
-- Here is an asset transfer example of an asset being purchased from AB2 Gallery tx_group_id = 'wWE2i1LDwQBpKv+RGPNGcNvKm7VrmskGUyV4snkFS1w='
-- -To look at transfer transactions in involving AB2 Gallery use: where try_base64_decode_string(tx_message:txn:note::string) = 'ab2.gallery' NFT Statistics and Explorer: https://www.nftexplorer.app/stats
Run a query to Download Data