KaskoazulMeta Pool
Updated 2022-08-07
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
›
⌄
with raw_to as (
select t.tx_hash,
t.block_timestamp,
t.tx_signer,
try_parse_json (t.tx) as p_tx,
t.transaction_fee / pow(10,24) as fee,
e.action_name, --if function_call table, all are FunctionCall
e.method_name,
e.deposit / pow(10,24) as e_deposit,
p_tx:actions[0]:FunctionCall:args as args,
p_tx:actions[0]:FunctionCall:deposit as deposit,
p_tx:actions[0]:FunctionCall:method_name as p_method_name,
--base64_decode_string (r.receipt_object_id) as d_1,
--base64_decode_string (r.receipt_outcome_id[0]) as d_2,
r.receipt_object_id as d_1,
r.receipt_outcome_id as d_3,
r.status_value,
r.logs
from near.core.fact_transactions t
left join near.core.fact_actions_events_function_call e
on t.tx_hash = e.tx_hash
left join near.core.fact_receipts r
on t.tx_hash = r.tx_hash
where t.tx_receiver = 'meta-pool.near'
)
select method_name, count (tx_hash) from raw_to group by 1
Run a query to Download Data