CryptoIcicleStepN Growth - Daily # of Wallets
Updated 2022-02-26
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
›
⌄
-- Payout 0.49 SOL
-- Grand Prize 1.47 SOL
-- Level Beginner
-- StepN is a Solana based ""move-to-earn' game (you earn the game's native token GST by moving around using their NFT sneakers and GPS system).
-- The game has seen steady growth in popularity since it launched at the end of December
-- (transitioned from a private beta mode to its current public mode).
-- Create a visualization showing
-- the number of unique wallets that have transacted with GST by day since January 1st.
-- How much total GST has been transacted per day since January 1st?
-- Provide some insights over the adoption of GST and how long it can accommodate its limitless supply as an in-game token.
-- Sample Query:
-- Select block_timestamp::date as date, count(__________) as uniquewallets from Solana.Transactions
-- where block_timestamp::date >= '2022-01-01' and ___________________ group by date
select
block_timestamp::date as date,
count(distinct tx_from_address) as n_wallets
from solana.transactions
where block_timestamp::date >= '2022-01-01'
and (pre_mint = 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB' or post_mint = 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB')
group by date
Run a query to Download Data