1SELECT 
2  pool,
3  COUNT(*) AS total_swaps,
4  SUM(COALESCE(amount_in, 0)) AS total_volume_in,
5  SUM(COALESCE(amount_out, 0)) AS total_volume_out
6FROM sui.cetus_swap
7WHERE DATE(TO_TIMESTAMP("timestampMs" / 1000)) = '2025-05-21'
8GROUP BY pool
9ORDER BY total_swaps DESC
10LIMIT 10;
11
12
13
14
15
16
17
18
19
20

1SELECT id, symbol, name, decimals, tx_count FROM base.uniswap_token
2ORDER BY tx_count DESC
3LIMIT 20;
4
5
6
7
8
9
10
11
12
13

1SELECT 
2  pool,
3  COUNT(*) AS total_swaps
4FROM sui.cetus_swap
5WHERE DATE(TO_TIMESTAMP("timestampMs" / 1000)) = '2025-05-22'
6GROUP BY pool
7ORDER BY total_swaps DESC 
8LIMIT 10;
9
10
11
12
13
14
15
16
17
18

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