Skip to main content

Table Details

PropertyValue
Table Namemonad_testnet.assets.native_credit_debit
Table StatusProduction-Ready
Unique Keyblock_timestamp, unique_id

Table Columns

Column NameData TypeDescription
addressVARCHAR(42)Address of the account that was credited or debited value amount of ETH
counterparty_addressVARCHAR(42)The address of counter party of this credit or debit transfer
raw_amount_strVARCHAR(16777216)Amount of ETH in wei in string format
raw_amountFLOATAmount of ETH in wei
amount_strVARCHAR(16777216)Amount of ether in string format
amountFLOATAmount of ether
usd_amountFLOATThe amount of ether moved, in $USD
usd_exchange_rateFLOATThe exchange rate used to calculate the usd_value
transfer_typeVARCHAR(16777216)Type of transfers. Includes value_transfer, gas_payment_to_mine, gas_burn
transaction_from_addressVARCHAR(42)The address of the sending party of this transaction.
transaction_to_addressVARCHAR(42)The address of the receiving party of this transaction.
transaction_hashVARCHAR(66)Transaction hash that this transfer belongs to
transaction_indexNUMBER(38,0)The position of this transaction in the block. The first transaction has index 0
block_timestampTIMESTAMP_NTZ(9)The timestamp of the block that the corresponding transaction of this transfer belongs to
block_numberNUMBER(38,0)The block number that the corresponding transaction of this transfer belongs to
block_hashVARCHAR(66)The block hash that the corresponding transaction of this transfer belongs to
unique_idVARCHAR(16777216)Unique id generated to each transfer
_tokens_updated_atTIMESTAMP_NTZ(9)Timestamp of when the token metadata was last updated.
_created_atTIMESTAMP_NTZ(9)Timestamp of when the entry was created
_updated_atTIMESTAMP_NTZ(9)Timestamp of when the entry was last updated
_changed_since_full_refreshBOOLEANIndicates if the record has changed since the last full refresh