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 * FROM tx WHERE block = 45090 ON base;
2
3/*
4  Description:
5  This query fetches all transactions included in block number 45090 on the Base network.
6
7  Use Case:
8  Useful for analyzing activity within a specific block, such as:
9  - Identifying which contracts or accounts were interacted with
10  - Measuring block-level gas usage or throughput
11  - Auditing protocol behavior or tracing specific events
12
13  The result includes all available fields for each transaction, such as `from`, `to`, `value`, `gas_price`, `input`, `status`, etc.
14*/
15
16
17
18
19
20
21
22
23
24

1SELECT balance, chain FROM account vitalik.eth ON eth, base 
2/* Fetches the balance and the chain for the account 'vitalik.eth' across Ethereum and Base.
3   You can use either an ENS name or a wallet address in place of 'vitalik.eth'. */
4
5/*
6  Notes:
7  - You can use either an ENS name (e.g. `vitalik.eth`) or a raw address (e.g. `0x...`) as the account identifier.
8  - This is useful for tracking an address's assets across multiple EVM-compatible chains.
9*/
10
11
12
13
14
15
16
17
18
19

1SELECT from,  to,value, gas_price, status  FROM tx 
2    0x6f93d4add2ef6cdfbb9f25b9895830d719dd8edf6637b639d5c33e808ded4247,
3    0xa9e39789f09753e7afa0838c52e3dd332627f1b18eec07e1652ede6f5a958fa1
4ON eth;
5
6/*
7  Description:
8  This query retrieves detailed transaction information for two specific transactions 
9  on the Base network.
10
11  Fields selected:
12  - `from`: Sender address of the transaction
13  - `to`: Recipient address (contract or user)
14  - `value`: Amount of ETH or token transferred
15  - `gas_price`: Price per unit of gas paid by the sender
16  - `status`: Whether the transaction succeeded or failed
17
18  Use Case:
19  Useful for auditing or tracking high-value or specific-purpose transactions 
20  such as contract deployments, token transfers, or protocol interactions.
21*/
22
23
24
25
26
27
28
29
30
31

1SELECT * 
2FROM block 1000:1010 
3ON base, eth;
4
5/*
6  Retrieves all block-level details for blocks 1000 to 1010 on both the Base and Ethereum networks.
7
8  For Ethereum (eth):
9  - These are among the earliest blocks from the Ethereum mainnet.
10  - Useful for historical analysis, such as studying the genesis period, early transaction patterns,
11    gas fee structures, and miner behavior.
12  - Can help in auditing early smart contract deployments or tracking the first appearances of key accounts.
13
14  For Base (base):
15  - Provides a view into the same block range (by block number), but on the Base L2 chain.
16  - Enables comparison of activity, throughput, and consensus behavior between L1 (Ethereum) and L2 (Base).
17*/
18
19
20
21
22
23
24
25
26
27

1SELECT * 
2FROM block 1:10 
3ON base;
4
5/**
6 * Retrieves all fields from blocks 1 through 10 on the Base chain.
7 * Useful for inspecting early block metadata such as timestamp, gas used, and miner.
8 */
9
10
11
12
13
14
15
16
17

1SELECT 
2  sender,
3  pool,
4  amount_in,
5  amount_out,
6  fee_amount,
7  TO_TIMESTAMP("timestampMs" / 1000) AS readable_time
8FROM sui.cetus_swap
9ORDER BY amount_in DESC
10LIMIT 1000;
11
12/*
13  Select all records from the sui.cetus_swap table,
14  convert timestampMs (milliseconds) to a readable timestamp,
15  and order the results by the amount_in field in descending order,
16  so the swaps with the largest input amounts appear first.
17*/
18
19
20
21
22
23
24
25
26

1SELECT b.owner,COUNT(*) AS burn_count FROM eth.uniswap_burn b
2GROUP BY b.owner
3LIMIT 50;
4
5/*
6 IT A CONTUNIATION OF SELECT * TOKEN BURN TRANSFER ON UNISWAP TOKENS 
7
8THE Goal  is to get the top 50 burners on eth 
9
10Run as Indexed data
11*/
12
13
14
15
16
17
18
19
20

1SELECT * FROM account 0xac5bceec1b789ff840d7d4e6ce4ce61c90d190a7f8c4f4ddf0bff6ee2413c33c, test.sui ON sui_testnet
2
3
4
5
6
7
8
9
10

1SELECT * FROM eth.uniswap_burn
2LIMIT 10000;
3
4/*
5  This query retrieves the first 10,000 token burn events from the Ethereum chain.
6  Token burns represent a permanent removal of tokens from circulation—commonly used 
7  to reduce supply or as part of deflationary tokenomics.
8
9  If the `eth.burn` table is indexed with Uniswap-specific data, this will return
10  burn transfers from Uniswap liquidity pools. Otherwise, it may include burns 
11  across various protocols and tokens.
12
13  Useful for analyzing token supply changes, protocol-level deflation strategies,
14  or user interaction patterns in DeFi ecosystems.
15*/
16
17
18
19
20
21
22
23
24
25