datavortexslippery-emerald
Updated 2024-12-06
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
›
⌄
⌄
/*
SELECT
signer_id,
method_name,
COUNT(DISTINCT tx_hash) AS method_call_count
FROM
near.core.fact_actions_events_function_call
WHERE
signer_id = 'zaikhanh.near'
GROUP BY
signer_id,
method_name
ORDER BY
method_call_count DESC;
--zaikhanh.near
*/
WITH categorized_methods AS (
SELECT
signer_id,
method_name,
CASE
WHEN method_name IN ('ft_transfer_call', 'ft_resolve_transfer', 'ft_on_transfer') THEN 'Token Transfers'
WHEN method_name IN ('add_request_and_confirm', 'add_liquidity') THEN 'Liquidity Management'
WHEN method_name IN ('withdraw_reward', 'claim_reward_by_seed') THEN 'Reward & Staking'
WHEN method_name IN ('delete_request', 'exchange_callback_post_withdraw') THEN 'Requests & Withdrawals'
WHEN method_name = 'storage_deposit' THEN 'Storage & Fees'
ELSE 'Other'
END AS category
FROM
near.core.fact_actions_events_function_call
)
SELECT
signer_id,
QueryRunArchived: QueryRun has been archived