Pmisha-bmlMdxDeposit.Mango.markets
Updated 2022-02-21Copy Reference Fork
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
›
⌄
with dep as (select block_timestamp::date as d1,
sum(inner_instruction:instructions[0]:parsed:info:amount/1e9) as amountDeposited
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'
group by 1),
wl as (select block_timestamp::date as d2,
count(distinct instruction:parsed:info:newAccount) as acconts
from solana.events
Where block_timestamp::date >='2022-02-10'
AND Succeeded = 'True'
and event_type = 'createAccount'
and index=1
group by 1)
select
dep.d1 as day,
amountDeposited,
acconts
from DEP
inner join wl on dep.d1=wl.d2
Run a query to Download Data