core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg508,354 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 |
|---|
| 01a0d9c5-1f8e-73a3-a223-ec90d9f6743f | XLE | 2026-09-25 14:12 | put_calendar | 2 | 1 | 4000 | 836000.00 | long | ask | 61.7900 | 0.0700 | ["59"] | ["0.2683"] | [] | ["AMXO"] | 59.0000 | 59.0000 | 35 | 56 | false | true | true | false | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T18:12:52Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d91a-dd9f-7972-8739-90aa51e1d89d | XLE | 2026-09-25 11:06 | put_calendar | 2 | 1 | 200 | 78000.00 | short | bid | 62.1550 | 0.3800 | ["64"] | ["0.4746"] | [] | ["XMIO"] | 64.0000 | 64.0000 | 0 | 7 | false | false | true | false | false | ||||||||
| 01a0d916-ce8f-7be1-80b0-2513eea54170 | XLE | 2026-09-25 11:02 | put_calendar | 2 | 1 | 90 | 28260.00 | short | bid | 62.0450 | 0.5300 | ["63.5"] | ["0.5679"] | [] | ["XMIO"] | 63.5000 | 63.5000 | 0 | 7 | false | false | true | false | false | ||||||||
| 01a0d912-2b0f-7a91-9235-3b2ce3833deb | XLE | 2026-09-25 10:57 | put_calendar | 2 | 1 | 300 | 72300.00 | short | bid | 62.0100 | 0.1200 | ["63"] | ["0.3478"] | [] | ["XMIO"] | 63.0000 | 63.0000 | 0 | 7 | false | false | true | false | false | ||||||||
| 01a0d90e-b06f-7cf3-bdd0-1cb4cd3d64c1 | XLE | 2026-09-25 10:53 | put_calendar | 2 | 1 | 100 | 41400.00 | short | ask | 62.0527 | 0.4700 | ["64"] | ["0.5706"] | [] | ["XCBO"] | 64.0000 | 64.0000 | 0 | 7 | false | false | true | false | false | ||||||||
| 01a0cf71-2047-7b72-9177-bbfc13b37093 | XLE | 2026-09-23 14:04 | put_calendar | 2 | 1 | 150 | 51300.00 | unknown | — | 62.4100 | 0.2400 | ["64"] | ["0.2786"] | [] | ["XISX"] | 64.0000 | 64.0000 | 2 | 30 | false | false | true | false | false | mlet | |||||||
| 01a0c9c4-7576-73b1-afef-7bad4e9b9938 | XLE | 2026-09-22 11:38 | put_calendar | 2 | 1 | 2500 | 467500.00 | long | ask | 62.4699 | 0.1300 | ["59"] | ["0.2692"] | [] | ["XISX"] | 59.0000 | 59.0000 | 38 | 59 | false | true | true | false | false | ||||||||
| 01a0aac8-1cf2-7711-8a34-daf8908d18c6 | XLE | 2026-09-16 11:13 | put_calendar | 2 | 1 | 515 | 95275.00 | unknown | — | 64.0900 | 0.0800 | ["63"] | ["0.3101"] | [] | ["XBOX"] | 63.0000 | 63.0000 | 9 | 16 | false | true | true | false | false | mlat | |||||||
| 01a0aac8-019b-7433-b666-670cffa6b570 | XLE | 2026-09-16 11:13 | put_calendar | 2 | 1 | 138 | 25668.00 | short | ask | 64.1000 | 0.0600 | ["63"] | ["0.3123"] | [] | ["EDGO"] | 63.0000 | 63.0000 | 9 | 16 | false | true | true | false | false | ||||||||
| 01a0aac7-8883-7882-93f7-6956202c3cdd | XLE | 2026-09-16 11:13 | put_calendar | 2 | 1 | 195 | 36465.00 | unknown | — | 64.0700 | 0.1200 | ["63"] | ["0.3107"] | [] | ["XMIO"] | 63.0000 | 63.0000 | 9 | 16 | false | true | true | false | false | mlat | |||||||
| 01a0a5d4-0736-7812-a38f-2f1e6ac604ca | XLE | 2026-09-15 12:08 | put_calendar | 2 | 1 | 5000 | 630000.00 | unknown | — | 65.7300 | 0.1700 | ["59"] | ["0.3008"] | [] | ["AMXO"] | 59.0000 | 59.0000 | 45 | 66 | true | true | true | false | false | mlft | |||||||
| 01a0a0de-fd00-7b13-9607-406caeef0b4e | XLE | 2026-09-14 13:02 | put_calendar | 2 | 2 | 532 | 68628.00 | long | ask | 64.6650 | 0.0400 | ["63.5"] | ["0.3220"] | [] | ["ARCO","C2OX"] | 63.5000 | 63.5000 | 4 | 11 | false | true | true | false | false | ||||||||
| 01a0a0de-f530-7563-9cd3-86a82bd811c4 | XLE | 2026-09-14 13:02 | put_calendar | 2 | 1 | 654 | 84366.00 | long | ask | 64.6750 | 0.0400 | ["63.5"] | ["0.3230"] | [] | ["ARCO"] | 63.5000 | 63.5000 | 4 | 11 | false | true | true | false | false | ||||||||
| 01a0a0de-f149-7c51-881c-efa95e3c68ed | XLE | 2026-09-14 13:02 | put_calendar | 2 | 2 | 209 | 26961.00 | long | ask | 64.6750 | 0.0400 | ["63.5"] | ["0.3230"] | [] | ["SPHR","XBOX"] | 63.5000 | 63.5000 | 4 | 11 | false | true | true | false | false |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T15:07:04Z"} |
| 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-25T15:02:42Z"} |
| 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-25T14:57:43Z"} |
| 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-25T14:53:45Z"} |
| 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-23T18:04:55Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:38:09Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:14:39Z"} |
| 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-16T15:13:50Z"} |
| 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-16T15:13:50Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:09:21Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:02:42Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:02:42Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:02:42Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |