Transactions are cryptographically signed instructions from accounts.

An account will initiate a transaction to update the state of the Monad Testnet network. Transactions always originate from an externally owned account (a smart contract can not initiate a transaction). Transactions, which change the state of the EVM, need to be broadcast to the whole network. Any node can broadcast a request for a transaction to be executed on the EVM; after this happens, a validator will execute the transaction and propagate the resulting state change to the rest of the network.

​
Sample Query

Query transaction data by from/to address, block number or hash.

select * from monad_testnet.transactions
where from_address = '0x871cb5fbe43952fb373957b8f52d30dd800cee76'
limit 10;

​
Table Columns

Partitioned table "monad_testnet.transactions"
             Column              |            Type             | Collation | Nullable | Default
---------------------------------+-----------------------------+-----------+----------+---------
 hash                            | character varying(66)       |           | not null |
 nonce                           | numeric(38,0)               |           |          |
 transaction_index               | numeric(38,0)               |           |          |
 from_address                    | character varying(42)       |           |          |
 to_address                      | character varying(42)       |           |          |
 value                           | character varying           |           |          |
 gas                             | numeric(38,0)               |           |          |
 gas_price                       | numeric(38,0)               |           |          |
 input                           | text                        |           |          |
 receipt_cumulative_gas_used     | numeric(38,0)               |           |          |
 receipt_gas_used                | numeric(38,0)               |           |          |
 receipt_l1_gas_used             | numeric(38,0)               |           |          |
 receipt_l1_gas_price            | numeric(38,0)               |           |          |
 receipt_l1_fee                  | numeric(38,0)               |           |          |
 receipt_l1_fee_scalar           | character varying           |           |          |
 receipt_contract_address        | character varying(42)       |           |          |
 receipt_contract_address_hex    | character varying(42)       |           |          |
 receipt_contract_address_base58 | character varying(34)       |           |          |
 receipt_effective_gas_price     | numeric(38,0)               |           |          |
 receipt_root                    | character varying(66)       |           |          |
 receipt_status                  | numeric(38,0)               |           |          |
 receipt_gas_used_for_l1         | numeric(38,0)               |           |          |
 receipt_l1_block_number         | numeric(38,0)               |           |          |
 log_count                       | integer                     |           |          |
 source_hash                     | character varying           |           |          |
 mint                            | character varying           |           |          |
 schemaname_id                   | integer                     |           |          |
 block_timestamp                 | timestamp without time zone |           | not null |
 block_number                    | numeric(38,0)               |           |          |
 block_hash                      | character varying(66)       |           |          |
 max_fee_per_gas                 | numeric(38,0)               |           |          |
 max_priority_fee_per_gas        | numeric(38,0)               |           |          |
 transaction_type                | numeric(38,0)               |           |          |
 _extra_fields                   | jsonb                       |           |          |
 _metadata                       | jsonb                       |           |          |
 _created_at                     | timestamp without time zone |           |          |
 _updated_at                     | timestamp without time zone |           |          |
 chain_id                        | integer                     |           |          |
Partition key: RANGE (block_timestamp)
Indexes:
    "transactions_pk" PRIMARY KEY, btree (hash, block_timestamp)
    "transactions_block_index" btree (block_number)
    "transactions_block_timestamp_index" btree (block_timestamp DESC)
    "transactions_from_address_block_timestamp_index" btree (from_address, block_timestamp DESC)
    "transactions_to_address_block_timestamp_index" btree (to_address, block_timestamp DESC)