cardano.transaction_scripts

Description of the transaction_scripts table on Dune

Table Description

Contains smart contract script execution data for Cardano transactions. Each row represents a script (Plutus or native) invoked during a transaction, including its purpose (spend, mint, certify, reward), redeemer data, datum hash, and computational resource consumption (memory and CPU units).

Column Descriptions

Column	Description	Type
slot	The absolute slot number of the block containing this transaction.	bigint
block_number	The sequential number of the block containing this transaction.	bigint
block_hash	The hash of the block containing this transaction.	varchar
block_time	The timestamp of the block containing this transaction.	timestamp
tx_hash	The hash of the transaction that invoked this script.	varchar
script_hash	The hash uniquely identifying the script.	varchar
script_type	The type of script (e.g., 0 = native, 1 = Plutus V1, 2 = Plutus V2, 3 = Plutus V3).	integer
datum_hash	The hash of the datum consumed by the script.	varchar
purpose	The purpose of the script execution (e.g., spend, mint, certify, reward).	varchar
redeemer_index	The index of the redeemer in the transaction’s redeemer list.	integer
redeemer_cbor	The CBOR-encoded redeemer data passed to the script.	varchar
redeemer_data_hash	The hash of the redeemer data.	varchar
execution_mem_units	The memory units consumed by the script execution.	bigint
execution_cpu_steps	The CPU steps consumed by the script execution.	bigint
_updated_at	The time when this record was last updated.	timestamp
_ingested_at	The time when this record was ingested into Dune.	timestamp

Table Sample