Table Details
| Property | Value |
|---|---|
| Table Name | robinhood.dex.uniswap_v4_hooks |
| Table Status | Production-Ready |
| Unique Key | id |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| pool_manager | VARCHAR(16777216) | Address of the Uniswap v4 PoolManager singleton contract that manages this pool |
| hook_contract | VARCHAR(16777216) | Address of the hook contract attached to the pool |
| hook_int | VARCHAR(16777216) | Integer-encoded bitmap of the hook permission flags enabled for this hook contract |
| hook_signatures | VARIANT | Decoded list of hook callback functions (e.g. beforeSwap, afterSwap) enabled by the hook’s permission flags |
| hook_parameters | VARIANT | Parsed parameters associated with the hook’s enabled callbacks |
| currency0 | VARCHAR(16777216) | Address of the first token in the pool’s currency pair (lower-sorted). The zero address denotes native currency |
| currency1 | VARCHAR(16777216) | Address of the second token in the pool’s currency pair (higher-sorted) |
| id | VARCHAR(16777216) | Pool ID: keccak256 hash of the pool key (currency0, currency1, fee, tick_spacing, hooks) uniquely identifying it |
| fee | NUMBER(38,0) | Swap fee tier of the pool, in hundredths of a basis point (e.g. 3000 = 0.30%) |
| tick_spacing | NUMBER(38,0) | Minimum tick granularity for liquidity positions in the pool |
| params | VARIANT | Raw pool key parameters emitted when the pool was initialized |
| deployer | VARCHAR(16777216) | Address that initialized the pool |
| transaction_hash | VARCHAR(16777216) | Transaction hash of the pool initialization |
| transaction_index | NUMBER(38,0) | Index of the transaction within its block |
| transaction_from_address | VARCHAR(16777216) | Address that sent the transaction |
| transaction_to_address | VARCHAR(16777216) | Address the transaction was sent to (typically the PoolManager) |
| log_index | NUMBER(38,0) | Index of the log within the transaction |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block containing this record |
| block_number | NUMBER(38,0) | Number of the block containing this record |
| block_hash | VARCHAR(16777216) | Hash of the block containing this record |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |