Sandeshnear treasury
Updated 2023-02-16
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
›
⌄
with near_txns_out as
(
select block_timestamp,
tx_hash as tx_id,
parse_json(actions):"receipt":"Action":"actions"[0]:"Transfer":"deposit" /pow(10,24) as amount,
parse_json(actions):"receipt":"Action":"signer_id" as sender,
parse_json(actions):"receiver_id" as reciever
from near.core.fact_receipts
where 1=1
-- and tx_hash='BSudcmqufUaHRZcvPqdgexGHYBM7xrfDC9JF7uHy6wAy'
and sender = 'metricsdao.multisafe.near'
-- and reciever!='metricsdao.multisafe.near'
-- and RECEIVER_ID !='metricsdao.multisafe.near'
and amount is not null
),
near_txns_in as
(
select block_timestamp,
tx_hash as tx_id,
parse_json(actions):"receipt":"Action":"actions"[0]:"Transfer":"deposit" /pow(10,24) as amount,
parse_json(actions):"receipt":"Action":"signer_id" as sender,
parse_json(actions):"receiver_id" as reciever
from near.core.fact_receipts
where 1=1
-- and tx_hash='BSudcmqufUaHRZcvP̦qdgexGHYBM7xrfDC9JF7uHy6wAy'
and reciever = 'metricsdao.multisafe.near'
-- and sender!='79501b068d4fcbbcea3e7c332891a7d8abfd9864657b9c2cc3c18c944b1db558'
-- and RECEIVER_ID ='metricsdao.multisafe.near'
and amount is not null
)
-- select sum(i.amount) as in_amount,sum(o.amount) as out_amount,in_amount-out_amount as balance from near_txns_in i , near_txns_out o
select sum(amount) as balance from near_txns_in
Run a query to Download Data