1SELECT * FROM object  0x5617f3429da2b8bc698818fe0c57f05e4216623ab0975b7653405385134ad37e,0x5617f3429da2b8bc698818fe0c57f05e4216623ab0975b7653405385134ad378 
2ON sui_mainnet;
3
4/*
5Fetches full object details via Sui RPC using `sui_getObject` for the specified object IDs.
6These are raw on-chain Move objects from Sui's storage.
7This is useful for inspecting fields like `type`, `owner`, and custom content defined in the Move module.
8*/
9
10
11
12
13
14
15
16
17
18

1SELECT
2  id,
3  sender,
4  debts_count
5FROM sui.scallop_obligation
6LIMIT 20;
7
8
9
10
11
12
13
14
15

1SELECT
2  d.obligation_id AS obligation_id,
3  d.asset AS asset,
4  ROUND(CAST(d.amount AS BIGINT) / 1e9, 4) AS amount_sui,
5  TO_TIMESTAMP(CAST(d."timestampMs" AS BIGINT) / 1000) AS deposit_time,
6  o.debts_count AS linked_debts
7FROM sui.scallop_deposit d
8LEFT JOIN sui.scallop_obligation o
9  ON d.obligation_id = o.id
10WHERE CAST(d.amount AS BIGINT) > 0
11ORDER BY deposit_time DESC
12LIMIT 10;
13
14-- This query retrieves the 100 most recent deposits from the sui.scallop_deposit table, enriched with associated obligation data from sui.scallop_obligation.
15
16-- Key elements include:
17
18--     obligation_id: The ID tying the deposit to a specific obligation.
19
20--     asset: The deposited asset type (e.g., SUI).
21
22--     amount_sui: The deposit amount, converted from base units to readable SUI (using 1e9 divisor).
23
24--     deposit_time: Timestamp of the deposit (converted from milliseconds).
25
26--     linked_debts: Number of debt entries associated with the linked obligation (via LEFT JOIN).
27
28-- Only deposits with a positive amount are included, and results are sorted by the most recent deposit activity.
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49

1WITH filtered_mints AS (
2  SELECT
3    "depositAsset",
4    minter,
5    id,
6    ROUND(CAST("mintAmount" AS BIGINT) / 1e9, 4) AS mint_amount_sui,
7    to_timestamp(CAST("mintTime" AS BIGINT)) AS mint_time,
8    ROUND(CAST("depositAmount" AS BIGINT) / 1e9, 4) AS deposit_amount_sui
9  FROM sui.scallop_mint
10  WHERE CAST("depositAmount" AS BIGINT) > 10000242836381
11    AND to_timestamp(CAST("mintTime" AS BIGINT)) BETWEEN '2024-01-01' AND '2025-06-04'
12)
13SELECT
14  "depositAsset",
15  minter,
16  COUNT(id) AS mint_event_count,
17  SUM(mint_amount_sui) AS total_minted_sui,
18  SUM(deposit_amount_sui) AS total_deposited_sui,
19  MAX(mint_time) AS last_mint_time,
20  RANK() OVER (PARTITION BY "depositAsset" ORDER BY SUM(mint_amount_sui) DESC) AS mint_volume_rank
21FROM filtered_mints
22GROUP BY "depositAsset", minter
23ORDER BY total_minted_sui DESC
24LIMIT 100;
25
26
27
28
29
30
31
32
33
34