alleriaFirst Time Deposits at Mango Markets Wallet Dated
Updated 2022-02-18
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
account_creation as (
SELECT
*,
date(block_timestamp) as dates,
inner_instruction:instructions[0]:parsed:info:source::string as wallet_address
FROM solana.events
--WHERE tx_id = '2ZGS7hVKWfZi9MPToqCYBv2tvv6xKLFqoHwq7kCFckoFKMdrWckZLqPnz1StZSj5eUHBWVg3Dq3m9iWmLNZ3iBBL'
WHERE instruction:programId::string = 'mv3ekLzLbnVPNxjSKvqBpU3ZeZXPQdEC3bp5MDEBG68'
AND dates >='2022-02-10'
AND succeeded = 'TRUE'
AND inner_instruction:instructions[0]:parsed:info:owner::string = 'mv3ekLzLbnVPNxjSKvqBpU3ZeZXPQdEC3bp5MDEBG68'
AND inner_instruction:instructions[0]:parsed:info:newAccount is not NULL
AND inner_instruction:instructions[0]:parsed:type::string = 'createAccount'
AND pretokenbalances[0]:mint::string = 'So11111111111111111111111111111111111111112' --Solana
)
SELECT
dates,
COUNT(DISTINCT wallet_address) as daily_wallet_created,
SUM(daily_wallet_created) over (order by dates asc) as cumulative_wallets
FROM account_creation
GROUP BY dates
ORDER BY dates ASC
Run a query to Download Data