Comprehensive RDW Datasets
The following table includes all attributes across RDW Datasets and tables. All attributes can be used for queries, joins, and other BigQuery functions.
Field Name | Type | Mode | Description | v_product_btec | v_instrument_btec | v_product_ebs | v_instrument_ebs | v_product_fno | v_product_spec_fno | v_option_series_fno | v_instrument_fno |
zero_px_elig_ind | STRING | NULLABLE | Indicates instrument is eligible to trade at zero price. |
|
|
|
|
|
|
| x |
workup_public_timer_ext | NUMERIC | NULLABLE | Duration in seconds for the extension of the public phase of a Workup, if needed. |
| x |
|
|
|
|
|
|
workup_public_timer | NUMERIC | NULLABLE | Duration in seconds for the public phase of a Workup. |
| x |
|
|
|
|
|
|
workup_private_timer | NUMERIC | NULLABLE | Duration in seconds for the private phase of a Workup. |
| x |
|
|
|
|
|
|
vtt_px_threshold | NUMERIC | NULLABLE | Threshold for VTT application. |
|
|
|
|
|
|
| x |
vtt_low_tick | NUMERIC | NULLABLE | Low tick for VTT. |
|
|
|
|
|
|
| x |
vtt_high_tick | NUMERIC | NULLABLE | High tick for VTT. |
|
|
|
|
|
|
| x |
variable_tick_idx | STRING | NULLABLE | Variable Tick Table (VTT) indicator. |
|
|
|
| x |
|
|
|
variable_qty_ind | STRING | NULLABLE | Indicates if product is subject to Variable Quantity processing. | x |
| x |
| x |
|
|
|
var_cab_low_px | NUMERIC | NULLABLE | Low price for variable cabinet trades. |
|
|
|
| x |
|
|
|
var_cab_high_px | NUMERIC | NULLABLE | High price for variable cabinet trades. |
|
|
|
| x |
|
|
|
valuation_mthd | STRING | NULLABLE | Type of valuation method used FUT - Futures Style FWD - Forward BILL - Bills BOND - Cash Notes and bonds IRS - Interest Rate Swap SPOT - Spot RPO - Repo Specific | x | x | x | x | x |
|
| x |
user_defined_ind | STRING | NULLABLE | Identifies a Tailor-Made or User-Defined Instrument |
| x |
|
|
|
|
| x |
unit_of_measure_qty | NUMERIC | NULLABLE | Unit of measure quantity for the product. | x |
| x |
| x |
|
|
|
unit_of_measure | STRING | NULLABLE | Unit of measure for the product. | x |
| x |
| x |
|
|
|
underlying_instr_guid_int | NUMERIC | NULLABLE | Underlying instrument GUID in integer format for the options series. |
|
|
|
|
|
| x |
|
underlying_instr_guid | STRING | NULLABLE | Underlying instrument GUID for the options series. |
|
|
|
|
|
| x |
|
trdg_unit_period_mult | NUMERIC | NULLABLE | Transaction Size |
| x |
| x |
|
|
| x |
transformed_insts | JSON | REPEATED | Repeating group of instruments that the traded instrument is transformed into. |
|
|
|
|
|
|
| x |
transformation_date | DATETIME | NULLABLE | Date when Clearing transformation occurs for eligible instruments. |
|
|
|
|
|
|
| x |
trading_hours_json | JSON | REPEATED | Trading hours information in JSON format. |
|
|
|
|
| x |
|
|
trading_cutoff_time | STRING | NULLABLE | Cut off time for trading. |
|
|
|
| x |
|
|
|
trade_tick | NUMERIC | NULLABLE | Trade price tick. May differ from the settlement tick. |
| x |
| x |
|
|
| x |
trade_close_offset | STRING | NULLABLE | Fixing close offsets - Time duration before scheduled fixing time of the eFix Matching Service instrument. |
|
| x |
|
|
|
|
|
tot_json | JSON | REPEATED | Termination of trading information in JSON format. |
|
|
|
|
| x |
|
|
termination_date | DATETIME | NULLABLE | Termination date for the options series. |
|
|
|
|
|
| x |
|
tenor_type | STRING | NULLABLE | Indicates the settlement period or contract tenor type and duration. |
| x |
| x |
|
|
|
|
tcc_sym | STRING | NULLABLE | Product code used for trade reporting on CME ClearPort, --CME STP FIXML and --CME STP FIX. |
|
|
|
| x |
|
|
|
tcc_alias | STRING | NULLABLE | Instrument symbol used for trade reporting on CME ClearPort, --CME STP FIXML and --CME STP FIX. |
| x |
| x |
|
|
| x |