core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg637,282 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 |
|---|
| 01a0f2b4-e98f-7350-8176-9d385cad6837 | SOXX | 2026-09-30 10:25 | straddle | 2 | 6 | 30 | 43500.00 | short | bid | 566.6700 | 2.1667 | ["570"] | ["0.4252"] | ["555.50","584.50"] | ["C2OX","EMLD","MCRY","XCBO","XMIO","XPHO"] | 570.0000 | 570.0000 | 2 | 2 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-30T14:25:50Z"} | 2026-09-30 | 2026-09-30 17:15 | 2026-09-30 17:15 |
| 01a0f299-724f-77a1-8034-d758f6ec156b | SOXX | 2026-09-30 09:55 | straddle | 2 | 1 | 8 | 27360.00 | long | ask | 568.1500 | 3.1000 | ["570"] | ["0.3601"] | ["535.80","604.20"] | ["EDGO"] | 570.0000 | 570.0000 | 16 | 16 | false | false | false | false | |||||||||
| 01a0f299-6e67-7862-979f-c79091fe9205 | SOXX | 2026-09-30 09:55 | straddle | 2 | 1 | 9 | 30870.00 | long | ask | 568.1500 | 3.1000 | ["570"] | ["0.3611"] | ["535.70","604.30"] | ["EDGO"] | 570.0000 | 570.0000 | 16 | 16 | false | false | false | false | |||||||||
| 01a0f28a-b4df-71e2-a4bf-37aa13ec09e0 | SOXX | 2026-09-30 09:39 | straddle | 2 | 1 | 25 | 37150.00 | short | bid | 568.9400 | 1.0000 | ["570"] | ["0.4413"] | ["555.14","584.86"] | ["XISX"] | 570.0000 | 570.0000 | 2 | 2 | false | false | false | false | |||||||||
| 01a0e898-84a7-7712-96e3-93fbb362ddb9 | SOXX | 2026-09-28 11:18 | straddle | 2 | 1 | 50 | 98947.00 | long | ask | 552.8200 | 2.5000 | ["550"] | ["0.4265"] | ["530.21","569.79"] | ["XISX"] | 550.0000 | 550.0000 | 4 | 4 | false | false | false | false | |||||||||
| 01a0d984-4217-72c3-b094-c4a46c6fa243 | SOXX | 2026-09-25 13:01 | straddle | 2 | 1 | 25 | 57625.00 | unknown | — | 574.4600 | 1.9000 | ["570"] | ["0.3594"] | [] | ["XISX"] | 570.0000 | 570.0000 | 7 | 7 | false | false | false | false | true | mlat | |||||||
| 01a0cf54-2a37-7571-82dd-2cc8c29b1bfd | SOXX | 2026-09-23 13:33 | straddle | 2 | 1 | 11 | 82313.00 | long | ask | 560.6200 | 3.5000 | ["575"] | ["0.4135"] | ["500.17","649.83"] | ["EMLD"] | 575.0000 | 575.0000 | 58 | 58 | false | false | false | false | |||||||||
| 01a0cf54-2a37-7571-82dd-2c9b79c954fb | SOXX | 2026-09-23 13:33 | straddle | 2 | 1 | 5 | 37415.00 | long | ask | 560.6000 | 3.6000 | ["575"] | ["0.4135"] | ["500.17","649.83"] | ["EMLD"] | 575.0000 | 575.0000 | 58 | 58 | false | false | false | false | |||||||||
| 01a0ab89-2303-7611-9c97-438e7c3de2f9 | SOXX | 2026-09-16 14:44 | straddle | 2 | 2 | 20 | 25850.00 | unknown | — | 505.6600 | 2.1000 | ["510"] | ["0.4158"] | [] | ["C2OX","EDGO"] | 510.0000 | 510.0000 | 2 | 2 | false | false | false | false | true | mlet | |||||||
| 01a0ab5d-ec82-78d0-b3dc-84649232281b | SOXX | 2026-09-16 13:57 | straddle | 2 | 1 | 20 | 27200.00 | short | bid | 507.8850 | 1.5000 | ["510"] | ["0.4494"] | ["496.40","523.60"] | ["C2OX"] | 510.0000 | 510.0000 | 2 | 2 | false | false | false | false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-30T13:55:42Z"} |
| 2026-09-30 |
| 2026-09-30 17:15 |
| 2026-09-30 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-30T13:55:42Z"} |
| 2026-09-30 |
| 2026-09-30 17:15 |
| 2026-09-30 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-30T13:39:30Z"} |
| 2026-09-30 |
| 2026-09-30 17:15 |
| 2026-09-30 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T15:18:50Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T17:02:31Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:34:04Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:34:04Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:44:44Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:58:03Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |