RamaharMango Markets Activites
Updated 2022-07-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
SELECT
DATE(block_timestamp) as dayz,
count(distinct tx_id) as MatchOrders,
count(distinct instruction:accounts[2]::string) as Traders,
sum(Traders) over (order by dayz asc rows between unbounded preceding and current row) as cumulative_traders,
sum(MatchOrders) over (order by dayz asc rows between unbounded preceding and current row) as cumulative_MatchOrders
FROM solana.core.fact_events
--WHERE tx_id = '2ZGS7hVKWfZi9MPToqCYBv2tvv6xKLFqoHwq7kCFckoFKMdrWckZLqPnz1StZSj5eUHBWVg3Dq3m9iWmLNZ3iBBL'
WHERE program_id = 'mv3ekLzLbnVPNxjSKvqBpU3ZeZXPQdEC3bp5MDEBG68'
AND succeeded = 'TRUE'
AND inner_instruction:instructions[1]:parsed:type::string = 'transfer'
AND inner_instruction:instructions[0]:programId::string = '9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin'
group by 1
--AND tx_id = '2qXznKA9Kq1toPRxT6Fb27GV2P1xFZo9ExaQHTuQ9if6NPc2zmseph4Hdex7Sx284QHkd1ZLemahTg8QPuXXh1cw'
--AND inner_instruction:instructions[0]:parsed:info:owner::string = 'mv3ekLzLbnVPNxjSKvqBpU3ZeZXPQdEC3bp5MDEBG68'
Run a query to Download Data