Table Details
| Property | Value |
|---|---|
| Table Name | tempo.dex.orders |
| Table Status | Production-Ready |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| order_id | NUMBER(38,0) | |
| maker | VARCHAR(42) | |
| status | VARCHAR(16777216) | |
| token | VARCHAR(42) | |
| base_symbol | VARCHAR(16777216) | |
| quote_symbol | VARCHAR(16777216) | |
| is_bid | BOOLEAN | |
| side | VARCHAR(16777216) | |
| tick | NUMBER(38,0) | |
| price | FLOAT | |
| amount_raw | NUMBER(38,0) | |
| amount | FLOAT | |
| filled_raw | NUMBER(38,0) | |
| filled | FLOAT | |
| remaining_raw | NUMBER(38,0) | |
| remaining | FLOAT | |
| amount_usd | FLOAT | |
| filled_usd | FLOAT | |
| remaining_usd | FLOAT | |
| is_flip_order | BOOLEAN | |
| flip_tick | NUMBER(38,0) | |
| fill_count | NUMBER(38,0) | |
| placed_at | TIMESTAMP_NTZ(9) | |
| placed_block_number | NUMBER(38,0) | |
| placed_transaction_hash | VARCHAR(66) | |
| last_fill_at | TIMESTAMP_NTZ(9) | |
| cancelled_at | TIMESTAMP_NTZ(9) |