granadohoTotal New Trading Account Since February 10th
Updated 2022-02-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with tx_list as (
select
distinct tx_id
from solana.events
Where block_timestamp::date >='2022-02-10'
AND Succeeded = 'True' AND Index = 3
AND instruction:programId = 'mv3ekLzLbnVPNxjSKvqBpU3ZeZXPQdEC3bp5MDEBG68'
AND inner_instruction:instructions[0]:parsed:info:destination = 'AVn3JRGhifPCxjxZsU3tQuo4U4dTHizHzBDGW983tx47'
)
select
count(distinct(instruction:parsed:info:newAccount)) as total_new_trading_accounts
from solana.events
Where block_timestamp::date >='2022-02-10'
and tx_id in (select * from tx_list)
AND Succeeded = 'True' AND Index = 1
AND event_type = 'createAccount'
AND pretokenbalances[0]:mint::string = 'So11111111111111111111111111111111111111112'
AND instruction:programId = '11111111111111111111111111111111'
Run a query to Download Data