NFT
Wallets
Data Transformations
- Data Transformations Overview
- Filter Data Sources
- Filters
- Workflows
Chains
Deep Dives
Transactions
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;
select * from monad_testnet.transactions
where from_address = '0x871cb5fbe43952fb373957b8f52d30dd800cee76'
limit 10;
curl 'https://api.allium.so/api/v1/developer/monad_testnet/raw/transactions/0xaa7ea99106868c2bb6cbe4c1c9fd1bf5642a23fc05800e343100a3c90acc18c7' \
-X GET \
-H 'X-API-KEY: <API KEY>'
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)
On this page