Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
367,592 rowsCSV — whole table, not this view
Sources in this table
uw_multileg367,592 rowsexportable
| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b604-f16f-7431-8b06-113341550659 | XLE | 2026-09-18 15:36 | other | 4 | 1 | 234 | 34632.00 | unknown | ask | 64.2950 | 0.1300 | ["62","64","66"] | ["0.3099","0.2652","0.2261"] | ["60.84","63.16","64.84","67.16"] | ["XMIO"] | 62.0000 | 66.0000 | 7 | 7 | false | false | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:36:31Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5b2-1e4f-7701-a90b-59e6d0dd9db2 | XLE | 2026-09-18 14:05 | other | 4 | 1 | 80 | 102720.00 | unknown | bid | 64.3350 | 0.4200 | ["58.5","59","64","64.5"] | ["0.1762","0.1929","0.2908","0.2864"] | [] | ["XMIO"] | 58.5000 | 64.5000 | 0 | 35 | false | false | true | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:06:14Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b035-8c43-7690-8c52-f9adf42937a7 | XLE | 2026-09-17 12:31 | other | 3 | 2 | 148 | 64084.00 | unknown | — | 64.1800 | 0.1600 | ["65","75"] | ["0.2448","0.2730"] | [] | ["MCRY","XPHO"] | 65.0000 | 75.0000 | 29 | 64 | false | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:32:03Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a129-92c0-7ce3-8c56-8359889e7216 | XLE | 2026-09-14 14:24 | other | 3 | 1 | 20 | 26620.00 | unknown | — | 64.7261 | 0.6800 | ["58.5","59","64.5"] | ["0.2001","0.1904","0.3042"] | [] | ["AMXO"] | 58.5000 | 64.5000 | 4 | 39 | false | false | true | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:24:30Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091e3-b8e0-7a53-ae5c-1a6b0a9224a2 | XLE | 2026-09-11 15:13 | other | 2 | 2 | 80 | 44600.00 | unknown | — | 65.0850 | 0.2200 | ["58","65"] | ["0.4862","0.2324"] | [] | ["XCBO","XPHO"] | 58.0000 | 65.0000 | 7 | 35 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:13:47Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0919d-af31-78f1-91bd-9368a0691b42 | XLE | 2026-09-11 13:57 | other | 3 | 2 | 60 | 86724.00 | unknown | — | 65.0000 | 1.5600 | ["58","58.5","65"] | ["0.1857","0.1712","0.2432"] | [] | ["XCBO","XISX"] | 58.0000 | 65.0000 | 7 | 42 | false | false | true | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:57:10Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0919d-af31-78f1-91bd-935c1ebe270c | XLE | 2026-09-11 13:57 | other | 3 | 2 | 32 | 45904.00 | unknown | — | 65.0000 | 1.5600 | ["58","58.5","65"] | ["0.2236","0.2215","0.2519"] | [] | ["XBOX","XISX"] | 58.0000 | 65.0000 | 7 | 42 | false | false | true | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:57:10Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09105-5348-7202-998d-8b6e6956d697 | XLE | 2026-09-11 11:10 | other | 2 | 6 | 115 | 77488.00 | unknown | — | 64.8050 | 0.1800 | ["65","68"] | ["0.2521","0.2412"] | [] | ["AMXO","EMLD","MCRY","XBOX","XMIO","XPHO"] | 65.0000 | 68.0000 | 70 | 189 | false | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:10:45Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09105-3fc0-7de2-953d-249b6b9f058a | XLE | 2026-09-11 11:10 | other | 2 | 2 | 63 | 42651.00 | unknown | — | 64.8150 | 0.1800 | ["65","68"] | ["0.2525","0.2421"] | [] | ["EMLD","XMIO"] | 65.0000 | 68.0000 | 70 | 189 | false | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:10:45Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09105-3fc0-7de2-953d-247bdffd6aa4 | XLE | 2026-09-11 11:10 | other | 2 | 4 | 112 | 75824.00 | unknown | — | 64.8150 | 0.1550 | ["65","68"] | ["0.2525","0.2421"] | [] | ["AMXO","MCRY","XBOX","XPHO"] | 65.0000 | 68.0000 | 70 | 189 | false | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:10:45Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09104-e9d1-7f91-97ac-abdb208299d4 | XLE | 2026-09-11 11:10 | other | 2 | 1 | 38 | 25916.00 | unknown | — | 64.8900 | 0.1700 | ["65","68"] | ["0.2498","0.2424"] | [] | ["MCRY"] | 65.0000 | 68.0000 | 70 | 189 | false | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:10:12Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090df-54b8-7250-aabe-c2e52f68c619 | XLE | 2026-09-11 10:29 | other | 2 | 1 | 111 | 34743.00 | unknown | — | 65.2401 | 0.0900 | ["63.5","64.5"] | ["0.5497","0.2605"] | [] | ["EDGO"] | 63.5000 | 64.5000 | 0 | 7 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:29:23Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cb8-f3f8-7ec3-b01f-9af07f2f8e9c | XLE | 2026-09-10 15:08 | other | 2 | 1 | 59 | 118590.00 | unknown | — | 65.2050 | 0.6500 | ["60","65"] | ["0.2202","0.1984"] | [] | ["MCRY"] | 60.0000 | 65.0000 | 280 | 827 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:09:11Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c8e-7ce0-7793-926d-e0517eb730e2 | XLE | 2026-09-10 14:22 | other | 3 | 1 | 38 | 44080.00 | unknown | — | 65.2000 | 0.4700 | ["59.5","60","64"] | ["0.9238","0.3258","0.2812"] | [] | ["XPHO"] | 59.5000 | 64.0000 | 1 | 8 | false | false | true | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:22:29Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c79-3791-7cd2-add3-ef4d5c9ab46b | XLE | 2026-09-10 13:59 | other | 2 | 2 | 24 | 33080.00 | unknown | — | 65.1050 | 0.7500 | ["59","60"] | ["0.4153","0.2008"] | [] | ["ARCO","XISX"] | 59.0000 | 60.0000 | 8 | 463 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:00:01Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c79-3791-7cd2-add3-ef38c3525553 | XLE | 2026-09-10 13:59 | other | 2 | 3 | 56 | 77312.00 | unknown | — | 65.1050 | 0.7500 | ["59","60"] | ["0.4435","0.2013"] | [] | ["ARCO","EDGO","XISX"] | 59.0000 | 60.0000 | 8 | 463 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:00:01Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c79-33a8-7d23-966a-b7626efe7b17 | XLE | 2026-09-10 13:59 | other | 2 | 3 | 42 | 57930.00 | unknown | — | 65.1050 | 0.7000 | ["59","60"] | ["0.4021","0.2012"] | [] | ["AMXO","XCBO","XPHO"] | 59.0000 | 60.0000 | 8 | 463 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:00:01Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c64-5fa0-7062-8829-7be771048636 | XLE | 2026-09-10 13:36 | other | 2 | 1 | 40 | 40960.00 | unknown | — | 65.2500 | 0.2800 | ["60","62.5"] | ["0.2272","0.2940"] | [] | ["C2OX"] | 60.0000 | 62.5000 | 8 | 127 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:36:26Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bcc-ced9-7e10-94f0-3081b766f90f | XLE | 2026-09-10 10:50 | other | 4 | 1 | 154 | 27566.00 | unknown | — | 64.6950 | 0.1700 | ["63","65","67"] | ["0.2821","0.2783","0.2785"] | [] | ["XPHO"] | 63.0000 | 67.0000 | 8 | 8 | false | false | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:51:09Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a081ae-a8b8-7423-af61-052ae4005798 | XLE | 2026-09-08 11:41 | other | 2 | 1 | 22 | 53350.00 | unknown | — | 64.7800 | 1.9000 | ["52.5","53"] | ["0.7851","0.4630"] | [] | ["BATO"] | 52.5000 | 53.0000 | 10 | 45 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:41:53Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08192-7210-7473-94c4-63d309e82c08 | XLE | 2026-09-08 11:10 | other | 2 | 1 | 180 | 25920.00 | unknown | — | 64.8750 | 0.0700 | ["62","63"] | ["0.2504","0.2710"] | [] | ["XMIO"] | 62.0000 | 63.0000 | 8 | 38 | false | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:11:10Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0818a-e091-7a72-b8c2-8d9cc94c9439 | XLE | 2026-09-08 11:02 | other | 2 | 1 | 10 | 32590.00 | unknown | — | 64.8150 | 1.7000 | ["50"] | ["0.2614"] | [] | ["AMXO"] | 50.0000 | 50.0000 | 101 | 465 | false | false | true | false | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:02:59Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06d46-3fe5-7ab1-84f5-dc5a0dda692e | XLE | 2026-09-04 12:35 | other | 2 | 4 | 76 | 33646.00 | unknown | — | 64.0850 | 0.2600 | ["57.5","60"] | ["0.2861","0.2678"] | [] | ["ARCO","EDGO","XBOX","XISX"] | 57.5000 | 60.0000 | 14 | 469 | false | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:35:27Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d45-7c95-7d32-96e9-32f71cb9cf0e | XLE | 2026-09-04 12:34 | other | 2 | 3 | 106 | 36781.00 | unknown | — | 64.0950 | 0.2200 | ["54","57.5"] | ["0.3778","0.2668"] | [] | ["EDGO","XBOX","XISX"] | 54.0000 | 57.5000 | 14 | 469 | false | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:34:48Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d44-d49d-7ed2-9fe0-e43ad4de0778 | XLE | 2026-09-04 12:33 | other | 2 | 1 | 108 | 47898.00 | unknown | — | 64.1100 | 0.2600 | ["57.5","60"] | ["0.2840","0.2684"] | [] | ["EDGO"] | 57.5000 | 60.0000 | 14 | 469 | false | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:34:11Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |