| order_id | VARCHAR(16777216) | Identifier of the order on the orderbook. |
| maker | VARCHAR(42) | Address that placed the order. |
| status | VARCHAR(16777216) | Current order status (e.g. open, filled, cancelled). |
| token | VARCHAR(42) | Contract address of the token being traded. |
| base_symbol | VARCHAR(16777216) | Symbol of the base asset of the market. |
| quote_symbol | VARCHAR(16777216) | Symbol of the quote asset of the market. |
| is_bid | BOOLEAN | True if the order is a bid (buy order). |
| side | VARCHAR(16777216) | Order side: buy or sell. |
| tick | NUMBER(38,0) | Price tick the order is placed at. |
| price | FLOAT | Decimal-adjusted limit price of the order. |
| amount_raw | VARCHAR(16777216) | Order size in the token’s smallest indivisible unit. |
| amount | FLOAT | Decimal-adjusted order size. |
| filled_raw | VARCHAR(16777216) | Filled quantity in the token’s smallest indivisible unit. |
| filled | FLOAT | Decimal-adjusted filled quantity. |
| remaining_raw | VARCHAR(16777216) | Remaining unfilled quantity in the token’s smallest indivisible unit. |
| remaining | FLOAT | Decimal-adjusted remaining unfilled quantity. |
| amount_usd | FLOAT | USD value of the order size. |
| filled_usd | FLOAT | USD value of the filled quantity. |
| remaining_usd | FLOAT | USD value of the remaining quantity. |
| is_flip_order | BOOLEAN | True if the order is a flip order (automatically reposts on the opposite side after filling). |
| flip_tick | NUMBER(38,0) | Tick the flip order reposts at after filling. |
| fill_count | NUMBER(38,0) | Number of fills the order has received. |
| placed_at | TIMESTAMP_NTZ(9) | Timestamp (UTC) when the order was placed. |
| placed_block_number | NUMBER(38,0) | Block number when the order was placed. |
| placed_transaction_hash | VARCHAR(66) | Hash of the transaction that placed the order. |
| last_fill_at | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the most recent fill. Null if never filled. |
| cancelled_at | TIMESTAMP_NTZ(9) | Timestamp (UTC) when the order was cancelled. Null if not cancelled. |
| _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. |
