core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg677,480 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | direction |
|---|
| net_sidetext |
|---|
| underlying_pricenumeric |
|---|
| bid_ask_spreadnumeric |
|---|
| strikesjsonb |
|---|
| ivsjsonb |
|---|
| breakevensjsonb |
|---|
| uniq_exchangesjsonb |
|---|
| min_strikenumeric |
|---|
| max_strikenumeric |
|---|
| min_dteinteger |
|---|
| max_dteinteger |
|---|
| all_opening_legsboolean |
|---|
| all_otmboolean |
|---|
| diff_expirationsboolean |
|---|
| diff_strikesboolean |
|---|
| diff_typesboolean |
|---|
| codetext |
|---|
| kept_bytext |
|---|
| sourcetext |
|---|
| endpointtext |
|---|
| request_paramsjsonb |
|---|
| as_ofdate |
|---|
| vintage_tstimestamp with time zone |
|---|
| retrieved_attimestamp with time zone |
|---|
| 01a0f7b0-45bf-7e62-b62f-f90c3b7406b0 | XLF | 2026-10-01 09:38 | put_ratio_spread | 2 | 1 | 476 | 55216.00 | unknown | bid | 53.4750 | 0.1200 | ["54","54.5"] | ["0.2805","0.2434"] | ["53.26"] | ["XISX"] | 54.0000 | 54.5000 | 1 | 1 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-10-01T13:38:51Z"} | 2026-10-01 | 2026-10-01 17:15 | 2026-10-01 17:15 |
| 01a0f7b0-45bf-7e62-b62f-f8d1534d75ca | XLF | 2026-10-01 09:38 | put_ratio_spread | 2 | 1 | 500 | 57500.00 | unknown | — | 53.4750 | 0.2500 | ["54","54.5"] | ["0.2749","0.2123"] | [] | ["XMIO"] | 54.0000 | 54.5000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a0f7ae-421e-7a93-ad27-2d56f7a2b978 | XLF | 2026-10-01 09:36 | put_ratio_spread | 2 | 2 | 884 | 99429.00 | unknown | bid | 53.6050 | 0.4300 | ["54","54.5"] | ["0.3422","0.4016"] | ["53.31"] | ["ARCO","XCBO"] | 54.0000 | 54.5000 | 1 | 1 | false | false | false | ||||||||||
| 01a0f7ae-421e-7a93-ad27-2d4e8de5542c | XLF | 2026-10-01 09:36 | put_ratio_spread | 2 | 1 | 258 | 25929.00 | unknown | bid | 53.6050 | 0.4300 | ["54","54.5"] | ["0.2834","0.2189"] | ["53.50"] | ["XBOX"] | 54.0000 | 54.5000 | 1 | 1 | false | false | false | ||||||||||
| 01a0f7ae-0787-7b61-acd8-c9eb2a8e18b9 | XLF | 2026-10-01 09:36 | put_ratio_spread | 2 | 1 | 688 | 72240.00 | unknown | bid | 53.5750 | 0.3800 | ["54","54.5"] | ["0.2827","0.2672"] | ["53.47"] | ["ARCO"] | 54.0000 | 54.5000 | 1 | 1 | false | false | false | ||||||||||
| 01a0f7ad-f3ff-7952-baf3-98ceadb06452 | XLF | 2026-10-01 09:36 | put_ratio_spread | 2 | 2 | 590 | 69610.00 | unknown | bid | 53.5650 | 0.4900 | ["54","54.5"] | ["0.3457","0.4243"] | ["53.30"] | ["ARCO","C2OX"] | 54.0000 | 54.5000 | 1 | 1 | false | false | false | ||||||||||
| 01a0f7ad-f017-70a3-bd2a-1edcb4bbf15e | XLF | 2026-10-01 09:36 | put_ratio_spread | 2 | 3 | 358 | 42199.00 | unknown | bid | 53.5750 | 0.4900 | ["54","54.5"] | ["0.3515","0.4326"] | ["53.30"] | ["AMXO","ARCO","XPHO"] | 54.0000 | 54.5000 | 1 | 1 | false | false | false | ||||||||||
| 01a0eebf-06df-73a1-8b2e-acba97a0924b | XLF | 2026-09-29 15:58 | put_ratio_spread | 2 | 1 | 700 | 70000.00 | unknown | bid | 54.0301 | 0.1300 | ["40","54"] | ["0.3277","0.1786"] | ["27.48","52.52"] | ["XMIO"] | 40.0000 | 54.0000 | 108 | 108 | false | true | false | ||||||||||
| 01a0da26-1f97-7580-94c7-037144d7695a | XLF | 2026-09-25 15:58 | put_ratio_spread | 2 | 1 | 348 | 27318.00 | unknown | bid | 54.8250 | 0.1100 | ["40","54"] | ["0.3130","0.1732"] | ["52.43"] | ["EDGO"] | 40.0000 | 54.0000 | 112 | 112 | false | true | false | ||||||||||
| 01a0b0c7-299b-72a3-9eb6-b8586124576e | XLF | 2026-09-17 15:10 | put_ratio_spread | 2 | 1 | 750 | 76750.00 | unknown | — | 55.9950 | 0.0600 | ["54","56"] | ["0.1847","0.1691"] | [] | ["XPHO"] | 54.0000 | 56.0000 | 29 | 29 | false | false | false | true | false | ||||||||
| 01a0afc1-61fb-7e80-b0fd-b915b46ef29e | XLF | 2026-09-17 10:24 | put_ratio_spread | 2 | 1 | 652 | 49552.00 | unknown | — | 55.7900 | 0.0600 | ["40","54"] | ["0.3318","0.1871"] | [] | ["XBOX"] | 40.0000 | 54.0000 | 120 | 120 | false | true | false | true | false | ||||||||
| 01a0abbd-b7f3-7443-bc29-fabdfe15c898 | XLF | 2026-09-16 15:42 | put_ratio_spread | 2 | 1 | 500 | 40750.00 | unknown | — | 55.6710 | 0.0900 | ["40","54"] | ["0.3311","0.1916"] | [] | ["EDGO"] | 40.0000 | 54.0000 | 121 | 121 | false | true | false | true | false | ||||||||
| 01a0abbb-23cc-7911-a811-9e6b72cc8d27 | XLF | 2026-09-16 15:39 | put_ratio_spread | 2 | 1 | 974 | 81329.00 | unknown | — | 55.6650 | 0.0600 | ["40","54"] | ["0.3334","0.1940"] | [] | ["EDGO"] | 40.0000 | 54.0000 | 121 | 121 | false | true | false | true | false | ||||||||
| 01a0abb1-8ac4-7910-8faf-69d86363dfe3 | XLF | 2026-09-16 15:28 | put_ratio_spread | 2 | 1 | 516 | 45150.00 | unknown | — | 55.5400 | 0.1000 | ["40","54"] | ["0.3362","0.1957"] | [] | ["XMIO"] | 40.0000 | 54.0000 | 121 | 121 | false | true | false | true | false |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T13:38:51Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T13:36:47Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T13:36:47Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T13:36:23Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T13:36:06Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T13:36:06Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T19:58:27Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T19:58:49Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:11:05Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:25:02Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:42:12Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:39:35Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:29:02Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |