Table Description

The bob.transactions table contains information about all transactions on the bob blockchain. Each row represents a single transaction and includes information such as block number, hash, timestamp, sender, recipient, value, gas, gas price, and more. Transactions are the fundamental unit of interaction with the bob blockchain. Transactions are created by users and are used to send value, deploy smart contracts, and interact with smart contracts.

This is the raw version of this table. If the chain is a Fully Managed chain, decoded transaction calls will be available, see call tables section. If this is a Hosted chain, decoded call tables will not be available.

Column Descriptions

Datatypes on Snowflake datashare are different in some cases, read more here.

Table Sample

Examples

Show all transactions sent by a specific address

SELECT * 
FROM bob.transactions WHERE "from" = '0x50A1b5c358F8D34F0d35aA2f10742c46054E247e'

Count the number of transactions per block

SELECT 
    block_number, 
    COUNT(*)
FROM bob.transactions
GROUP BY 1
ORDER BY 1 DESC
LIMIT 10

Show the top 10 transactions with the highest gas price

SELECT 
    hash, 
    gas_price
FROM bob.transactions
ORDER BY gas_price DESC
LIMIT 10

Table Description

The bob.transactions table contains information about all transactions on the bob blockchain. Each row represents a single transaction and includes information such as block number, hash, timestamp, sender, recipient, value, gas, gas price, and more. Transactions are the fundamental unit of interaction with the bob blockchain. Transactions are created by users and are used to send value, deploy smart contracts, and interact with smart contracts.

This is the raw version of this table. If the chain is a Fully Managed chain, decoded transaction calls will be available, see call tables section. If this is a Hosted chain, decoded call tables will not be available.

Column Descriptions

Datatypes on Snowflake datashare are different in some cases, read more here.

Table Sample

Examples

Show all transactions sent by a specific address

SELECT * 
FROM bob.transactions WHERE "from" = '0x50A1b5c358F8D34F0d35aA2f10742c46054E247e'

Count the number of transactions per block

SELECT 
    block_number, 
    COUNT(*)
FROM bob.transactions
GROUP BY 1
ORDER BY 1 DESC
LIMIT 10

Show the top 10 transactions with the highest gas price

SELECT 
    hash, 
    gas_price
FROM bob.transactions
ORDER BY gas_price DESC
LIMIT 10