KaskoazulMango Markets deposits and fees stats
Updated 2022-02-20
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
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH openAccountTX AS (
SELECT
block_timestamp::date as fecha,
tx_id,
inner_instruction:instructions[0]:parsed:info:lamports/pow(10,9) as fee
FROM
solana.events
WHERE
block_timestamp::date >='2022-02-10'
AND instruction:programId = 'mv3ekLzLbnVPNxjSKvqBpU3ZeZXPQdEC3bp5MDEBG68' --Mango Markets V3
AND inner_instruction:instructions[0]:parsed:type = 'createAccount' --create Trading account
AND succeeded = 'TRUE'
),
Deposit_account AS (
SELECT
block_timestamp::date as fecha,
tx_id,
instruction:parsed:info:lamports/pow(10,9) as amount
FROM
solana.events
WHERE
tx_id in (select tx_id from openAccountTX)
AND index = 1
AND amount != 0
)
SELECT
d.fecha,
count( distinct d.tx_id) as New_trading_accounts,
sum(t.fee) as Total_Fees_per_day,
avg(t.fee) as Avg_Fee_per_day,
median(t.fee) as Median_Fee_per_day,
sum(d.amount) as Total_Deposits_per_day,
avg(d.amount) as Avg_Deposit_per_day,
median(d.amount) as Median_Deposit_per_day,
Run a query to Download Data