CREATE TABLE `algonode.algorand_mainnet_dev.transactions`
block_number INT64 NOT NULL -- Block number in which this transaction is located
block_timestamp TIMESTAMP NOT NULL -- Unix timestamp when the block was assembled
block_index INT64 NOT NULL -- Transaction's index position in the block
transaction_hash STRING NOT NULL -- Hash of the transaction
transaction_group BYTES -- Parent atomic group id (binary)
transaction_type STRING NOT NULL -- One of
-- acc_payment : simple transfer of Algo to account with non-zero balance
-- acc_payment_create : transfer of Algo to zero balance (nonexisting/closed) account
-- acc_close : transfer of Algo with a secondary transfer of the remider balance
-- app_call : smart contract call
-- app_clear : call "clear-state" part of the SC, clear local SC state
-- app_close : call the SC, clear local SC state
-- app_delete : call the SC, delete the SC
-- app_optin : allocate local state, call th SC
-- app_update : call the SC, replace SC code
-- asa_transfer : simple transfer of Token/NFT
-- asa_config : token/NFT reconfiguraion (of allowed fields)
-- asa_create : token/NFT mint
-- asa_optin asa_optout : allocate/remove minimal balance on the account for the token
-- asa_clawback : force withdraw token from the account
-- asa_destroy : destroy token/NFT completly
-- asa_freeze asa_unfreeze : freeze/unfreeze token/NFT in the account
-- key_reg key_unreg : un/register participation key
-- stpf : state proof transaction
from_address_id INT64 -- Sender address id - join with v_accounts_last_state to get address / state
to_address_id INT64 -- Recipient address id - join with v_accounts_last_state to get address / state
value_float FLOAT64 NOT NULL -- Decimal adjusted amount of Algo or token (lossy floating point)
value_int NUMERIC(20) NOT NULL-- Integer amount of Algo or Token without decimal shift
-- (raw value, needs decimal shift as in v_tokens_last_state)
close_to_address_id INT64 -- Address id of recipient of the closing balance
close_value_float FLOAT64 NOT NULL -- Closing balance amount, decimal adjusted
close_value_int NUMERIC(20) NOT NULL-- Closing balance amount without decimal shift
gas INT64 NOT NULL -- Transaction free in microAlgos
note STRING -- Optional note (up to 1KB)
rekey_to_address_id INT64 -- Account rekey to address id
auth_by_address_id INT64 -- Transaction authorized by this address id (if sender is rekeyed)
has_inners BOOL NOT NULL -- Transaction has inner transactions
is_inner BOOL NOT NULL -- Transaction is an inner transaction issued by smart contract
clawback_from_address_id INT64 -- Address id of the account the token is clawed back from
token_cfg STRUCT<list ARRAY<STRUCT<element INT64>>> NOT NULL -- clawback,freeze,manager,reserve address id in random order
token_id INT64 -- Asset id (token/nft) - join with v_assets_last_state
token_total NUMERIC(20) -- Total number of assets minted
token_unit_name STRING -- Asset unit name
contract_id INT64 -- ID of the contract called
input STRING -- Extra TX data / app call input")
PARTITION BY TIMESTAMP_TRUNC(block_timestamp, MONTH)
CLUSTER BY block_number,block_index
description="Algorand mainnet transactions, updated every hour. See: https://nodely.io/docs/public/bigquery",
1labels=[("status", "development")]