core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg541,738 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext |
|---|
| 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 |
|---|
| 01a08cbc-0139-7631-9187-e0b546a4f0e3 | ORCL | 2026-09-10 15:12 | synthetic | 2 | 2 | 27 | 50220.00 | short | ask | 154.6650 | 0.1000 | ["155"] | ["2.8791"] | ["154.70"] | ["XISX","XPHO"] | 155.0000 | 155.0000 | 1 | 1 | false | false | false | false | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:12:10Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c7e-9e60-7551-9670-0581c621eee2 | ORCL | 2026-09-10 14:05 | synthetic | 2 | 1 | 3 | 30057.00 | short | bid | 155.8100 | 2.9500 | ["145"] | ["0.5903"] | ["166.83"] | ["XPHO"] | 145.0000 | 145.0000 | 827 | 827 | false | false | false | false | true | ||||||||
| 01a08c73-e449-7d22-b197-772559f05a62 | ORCL | 2026-09-10 13:53 | synthetic | 2 | 1 | 73 | 136145.00 | short | bid | 155.9400 | 0.3000 | ["155"] | ["2.8728"] | ["156.05"] | ["XPHO"] | 155.0000 | 155.0000 | 1 | 1 | false | false | false | false | true | ||||||||
| 01a08773-38b8-7040-bb14-47d0fcbb0925 | ORCL | 2026-09-09 14:34 | synthetic | 2 | 1 | 10 | 31100.00 | short | ask | 163.3763 | 1.0500 | ["170"] | ["0.6689"] | ["163.70"] | ["XCBO"] | 170.0000 | 170.0000 | 44 | 44 | false | false | false | false | true | ||||||||
| 01a08148-3240-7463-90e6-48ba48c4f504 | ORCL | 2026-09-08 09:49 | synthetic | 2 | 5 | 5 | 25110.00 | long | ask | 165.9900 | 1.1200 | ["135"] | ["0.6025"] | ["167.42"] | ["AMXO","ARCO","EMLD","XBOX","XMIO"] | 135.0000 | 135.0000 | 129 | 129 | false | false | false | false | |||||||||
| 01a06dfe-a6ed-7cd2-8378-2b8ec64d6599 | ORCL | 2026-09-04 15:56 | synthetic | 2 | 2 | 21 | 46515.00 | long | ask | 158.2600 | 0.6500 | ["145"] | ["0.8131"] | ["158.16"] | ["ARCO","EMLD"] | 145.0000 | 145.0000 | 14 | 14 | false | false | false | false | true | ||||||||
| 01a06df2-a89d-7f73-a65c-1c71d33c1920 | ORCL | 2026-09-04 15:43 | synthetic | 2 | 7 | 41 | 98032.00 | long | ask | 157.5200 | 0.5793 | ["157.5"] | ["0.6889"] | ["158.09"] | ["ARCO","EMLD","MCRY","XISX","XPHO"] | 157.5000 | 157.5000 | 28 | 28 | false | false | false | false | |||||||||
| 01a06dc6-9375-7693-9c79-55f144824147 | ORCL | 2026-09-04 14:55 | synthetic | 2 | 1 | 10 | 45160.00 | short | ask | 157.2200 | 0.9000 | ["160"] | ["0.5987"] | ["159"] | ["XPHO"] | 160.0000 | 160.0000 | 133 | 133 | false | false | false | false | true |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:05:05Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:53:24Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T18:34:54Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:50:03Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:56:44Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:43:45Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:55:39Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |