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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c582-c86f-7b03-90ff-f94a8d0f79aa | XLE | 2026-09-21 15:47 | call_diagonal_spread | 2 | 1 | 532 | 256424.00 | long | ask | 62.5200 | 0.0600 | ["65","66"] | ["0.2598","0.2707"] | [] | ["EDGO"] | 65.0000 | 66.0000 | 88 | 101 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:47:59Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c582-c86f-7b03-90ff-f9254033c324 | XLE | 2026-09-21 15:47 | call_diagonal_spread | 2 | 3 | 229 | 110016.00 | long | ask | 62.5200 | 0.0400 | ["65","66"] | ["0.2592","0.2700"] | [] | ["AMXO","ARCO","SPHR"] | 65.0000 | 66.0000 | 88 | 101 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:47:59Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5d5-a7f8-7213-8af6-831ec7f96f27 | XLE | 2026-09-18 14:44 | call_diagonal_spread | 2 | 1 | 34 | 91766.00 | long | ask | 64.4000 | 1.0500 | ["51","52"] | ["0.3364","0.2031"] | [] | ["XISX"] | 51.0000 | 52.0000 | 63 | 182 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:45:03Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4db-1388-7321-a814-f6fb67de5469 | XLE | 2026-09-18 10:10 | call_calendar | 2 | 1 | 10 | 35940.00 | long | ask | 64.3950 | 0.7500 | ["46.5"] | ["3.1932"] | [] | ["XISX"] | 46.5000 | 46.5000 | 0 | 91 | false | false | true | false | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:11:06Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4c0-9a30-7913-a959-114037dd9fdb | XLE | 2026-09-18 09:41 | call_calendar | 2 | 1 | 10 | 35500.00 | long | ask | 64.2600 | 0.7000 | ["46.5"] | ["2.9396"] | [] | ["XMIO"] | 46.5000 | 46.5000 | 0 | 91 | false | false | true | false | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:41:57Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b05d-dc93-7b53-80cf-8a5015268ba9 | XLE | 2026-09-17 13:15 | call_vertical_spread | 2 | 1 | 10 | 26720.00 | long | ask | 64.3050 | 2.2500 | ["48","55"] | ["0.3899","0.1490"] | ["54.50"] | ["XMIO"] | 48.0000 | 55.0000 | 120 | 120 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:15:55Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aac3-7d5b-7721-8e5a-132832080d70 | XLE | 2026-09-16 11:08 | put_diagonal_spread | 2 | 1 | 10 | 25150.00 | long | ask | 63.9400 | 1.4000 | ["61","85"] | ["0.2722","0.3622"] | [] | ["EMLD"] | 61.0000 | 85.0000 | 196 | 821 | true | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:09:08Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aabc-b313-7d83-ae43-519c6f4fc5fb | XLE | 2026-09-16 11:01 | call_diagonal_spread | 2 | 1 | 20 | 50080.00 | long | bid | 64.0800 | 0.9500 | ["51","55"] | ["1.9070","0.2149"] | [] | ["XPHO"] | 51.0000 | 55.0000 | 2 | 274 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:01:56Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aaa9-3ab3-76b3-ba49-3f2b213786c7 | XLE | 2026-09-16 10:40 | call_ratio_spread | 2 | 1 | 1734 | 62424.00 | long | ask | 64.5050 | 0.0300 | ["65","66"] | ["0.3303","0.3287"] | ["65.12","66.88"] | ["EDGO"] | 65.0000 | 66.0000 | 2 | 2 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:40:50Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a6a1-9066-7083-8166-4f9861f6c1f9 | XLE | 2026-09-15 15:53 | call_vertical_spread | 2 | 1 | 25 | 64375.00 | long | ask | 65.7950 | 0.3250 | ["50","57.5"] | ["0.3299","0.2119"] | ["56.75"] | ["MCRY"] | 50.0000 | 57.5000 | 122 | 122 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:53:23Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a67c-aefe-7f50-9424-b710db6a2ea3 | XLE | 2026-09-15 15:13 | call_diagonal_spread | 2 | 1 | 20 | 117920.00 | long | ask | 65.8000 | 3.5000 | ["35","38"] | ["1.1512","2.6667"] | [] | ["BATO"] | 35.0000 | 38.0000 | 3 | 31 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:13:03Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a64c-adee-7702-bb29-6e6db856ab7e | XLE | 2026-09-15 14:20 | call_vertical_spread | 2 | 1 | 25 | 65175.00 | long | ask | 65.9550 | 0.6500 | ["50","57.5"] | ["0.3263","0.2143"] | ["56.75"] | ["XMIO"] | 50.0000 | 57.5000 | 122 | 122 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:20:53Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a637-ab06-7f72-bcd5-7669fa0829a8 | XLE | 2026-09-15 13:57 | call_diagonal_spread | 2 | 1 | 14 | 25816.00 | long | ask | 66.1000 | 0.8500 | ["65","70"] | ["0.2161","0.2078"] | [] | ["XPHO"] | 65.0000 | 70.0000 | 458 | 822 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:58:07Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a160-71a1-77e3-a32f-1cf19410ddbd | XLE | 2026-09-14 15:24 | call_vertical_spread | 2 | 1 | 12 | 61176.00 | long | ask | 64.3850 | 2.4500 | ["39","39.5"] | ["2.9355","2.9072"] | ["39.48"] | ["XISX"] | 39.0000 | 39.5000 | 4 | 4 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:24:39Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 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 | mlet | 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 |
| 01a09105-5348-7202-998d-8b9c21764a08 | XLE | 2026-09-11 11:10 | call_diagonal_spread | 2 | 7 | 215 | 145383.00 | long | ask | 64.8050 | 0.1800 | ["65","68"] | ["0.2527","0.2421"] | [] | ["BATO","C2OX","EDGO","XCBO","XISX"] | 65.0000 | 68.0000 | 70 | 189 | false | true | true | true | false | mlet | market_whale | 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-5348-7202-998d-8b8a0007119c | XLE | 2026-09-11 11:10 | call_diagonal_spread | 2 | 6 | 161 | 108533.00 | long | ask | 64.8050 | 0.1800 | ["65","68"] | ["0.2517","0.2416"] | [] | ["AMXO","ARCO","EMLD","MCRY","XBOX","XPHO"] | 65.0000 | 68.0000 | 70 | 189 | false | true | true | true | false | mlet | market_whale | 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-5348-7202-998d-8b7393e63be3 | XLE | 2026-09-11 11:10 | call_diagonal_spread | 2 | 6 | 108 | 73008.00 | long | ask | 64.8050 | 0.1800 | ["65","68"] | ["0.2526","0.2421"] | [] | ["ARCO","BATO","C2OX","EDGO","XCBO","XISX"] | 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-5348-7202-998d-8b5441204ddf | XLE | 2026-09-11 11:10 | call_diagonal_spread | 2 | 5 | 120 | 81144.00 | long | ask | 64.8050 | 0.1800 | ["65","68"] | ["0.2527","0.2421"] | [] | ["BATO","C2OX","EDGO","XCBO","XISX"] | 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-248c79abb6ae | XLE | 2026-09-11 11:10 | call_diagonal_spread | 2 | 6 | 168 | 113624.00 | long | ask | 64.8150 | 0.1800 | ["65","68"] | ["0.2523","0.2419"] | [] | ["ARCO","BATO","C2OX","EDGO","XCBO","XISX"] | 65.0000 | 68.0000 | 70 | 189 | false | true | true | true | false | mlet | market_whale | 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 |
| 01a08ba2-a1f8-75c1-9293-2d609e2ceee7 | XLE | 2026-09-10 10:04 | call_vertical_spread | 2 | 5 | 170 | 84000.00 | long | ask | 64.9000 | 0.1503 | ["66","71"] | ["0.2587","0.2638"] | ["67.68"] | ["ARCO","EMLD","SPHR","XBOX","XPHO"] | 66.0000 | 71.0000 | 99 | 99 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:05:03Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a087a5-4150-7dd0-a4c9-b7e8c37ff910 | XLE | 2026-09-09 15:29 | call_vertical_spread | 2 | 1 | 200 | 35200.00 | long | ask | 65.4750 | 0.0700 | ["65","67.5"] | ["0.2671","0.2623"] | ["66.0"] | ["XMIO"] | 65.0000 | 67.5000 | 9 | 9 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:29:20Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08770-6de0-7d33-a65d-95283093cf27 | XLE | 2026-09-09 14:31 | put_vertical_spread | 2 | 1 | 20 | 36640.00 | long | ask | 65.3500 | 0.5000 | ["74","75"] | ["4.3908","3.2756"] | ["74.02"] | ["BATO"] | 74.0000 | 75.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:31:42Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086c3-6500-79a1-bad4-e83a1a45f5a2 | XLE | 2026-09-09 11:22 | call_diagonal_spread | 2 | 7 | 28 | 36682.00 | long | bid | 65.2750 | 0.2500 | ["57.5","62.5"] | ["0.4092","0.2449"] | [] | ["AMXO","ARCO","EMLD","XBOX","XISX","XMIO","XPHO"] | 57.5000 | 62.5000 | 9 | 100 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:22:35Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086c3-6500-79a1-bad4-e817c65e8591 | XLE | 2026-09-09 11:22 | call_diagonal_spread | 2 | 7 | 53 | 69437.00 | long | bid | 65.2750 | 0.2500 | ["57.5","62.5"] | ["0.4064","0.2449"] | [] | ["AMXO","ARCO","EMLD","XBOX","XISX","XMIO","XPHO"] | 57.5000 | 62.5000 | 9 | 100 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:22:35Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086c3-6500-79a1-bad4-e80f774108a1 | XLE | 2026-09-09 11:22 | call_diagonal_spread | 2 | 7 | 53 | 69433.00 | long | bid | 65.2750 | 0.2500 | ["57.5","62.5"] | ["0.4058","0.2449"] | [] | ["AMXO","ARCO","EMLD","XBOX","XISX","XMIO","XPHO"] | 57.5000 | 62.5000 | 9 | 100 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:22:35Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08672-10b0-7640-98c0-930a48025274 | XLE | 2026-09-09 09:53 | call_vertical_spread | 2 | 1 | 15 | 26835.00 | long | ask | 65.7700 | 0.9000 | ["55","60"] | ["0.2598","0.2340"] | ["59.25"] | ["AMXO"] | 55.0000 | 60.0000 | 72 | 72 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:53:37Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0865d-5fd1-7293-b34c-a9a971ee51b3 | XLE | 2026-09-09 09:30 | call_vertical_spread | 2 | 1 | 15 | 26220.00 | long | ask | 65.6850 | 0.6500 | ["57.5","65"] | ["0.2155","0.2302"] | ["62.0"] | ["XMIO"] | 57.5000 | 65.0000 | 281 | 281 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:30:59Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08142-42b8-7022-a953-d9420262fbad | XLE | 2026-09-08 09:43 | call_vertical_spread | 2 | 1 | 30 | 51570.00 | long | ask | 64.8601 | 0.7000 | ["54","59"] | ["0.3427","0.1828"] | ["58.85"] | ["XMIO"] | 54.0000 | 59.0000 | 38 | 38 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:43:31Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |