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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a08661-3c19-77f1-b14b-9e1c1b5c1c89 | ASST | 2026-09-09 09:35 | call_diagonal_spread | 2 | 1 | 466 | 1257245.00 | short | ask | 27.8750 | 2.8000 | ["13","18"] | ["6.8976","1.0163"] | [] | ["XPHO"] | 13.0000 | 18.0000 | 2 | 128 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:35:13Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0879d-fdf0-7252-b9b7-dc7f5ab3a3f6 | ASST | 2026-09-09 15:21 | call_diagonal_spread | 2 | 1 | 7600 | 972800.00 | long | ask | 26.4900 | 0.2600 | ["27","28"] | ["0.8382","0.8589"] | [] | ["AMXO"] | 27.0000 | 28.0000 | 2 | 9 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:21:12Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0879f-b758-7470-8ee6-6cef64ed9770 | ASST | 2026-09-09 15:23 | call_diagonal_spread | 2 | 1 | 7600 | 1048800.00 | unknown | — | 26.5795 | 0.2700 | ["27","28"] | ["0.9603","0.8188"] | [] | ["AMXO"] | 27.0000 | 28.0000 | 2 | 9 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:23:39Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a09105-5348-7202-998d-8c29e789811c | ASST | 2026-09-11 11:10 | call_diagonal_spread | 2 | 1 | 94 | 248254.00 | long | bid | 28.1150 | 2.7500 | ["14","18"] | ["0.9612","0.9695"] | [] | ["AMXO"] | 14.0000 | 18.0000 | 98 | 126 | false | false | 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-8c195f29cc25 | ASST | 2026-09-11 11:10 | call_diagonal_spread | 2 | 1 | 94 | 248724.00 | long | bid | 28.1150 | 2.7500 | ["14","18"] | ["0.9816","0.9750"] | [] | ["XPHO"] | 14.0000 | 18.0000 | 98 | 126 | false | false | 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-b108-7351-bdec-8b4244097c06 | ASST | 2026-09-11 11:11 | call_diagonal_spread | 2 | 1 | 90 | 238590.00 | short | ask | 28.0900 | 2.0500 | ["14","18"] | ["1.0099","0.9890"] | [] | ["XISX"] | 14.0000 | 18.0000 | 98 | 126 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:11:19Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09105-b108-7351-bdec-8b3f8ef08910 | ASST | 2026-09-11 11:11 | call_diagonal_spread | 2 | 1 | 94 | 249194.00 | short | ask | 28.0900 | 2.4500 | ["14","18"] | ["1.0099","0.9890"] | [] | ["XPHO"] | 14.0000 | 18.0000 | 98 | 126 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:11:19Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09105-b108-7351-bdec-8b27702d5309 | ASST | 2026-09-11 11:11 | call_diagonal_spread | 2 | 1 | 76 | 201932.00 | short | ask | 28.0900 | 2.4500 | ["14","18"] | ["1.0285","0.9971"] | [] | ["AMXO"] | 14.0000 | 18.0000 | 98 | 126 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:11:19Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0912e-8628-7ab2-b451-e660e03fcef1 | ASST | 2026-09-11 11:55 | call_diagonal_spread | 2 | 1 | 9677 | 1983785.00 | short | bid | 27.7400 | 0.4000 | ["27","28"] | ["2.3477","0.7579"] | [] | ["AMXO"] | 27.0000 | 28.0000 | 0 | 7 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:55:55Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0a576-52ee-7f93-b32b-efce2ca9e0f8 | ASST | 2026-09-15 10:26 | call_diagonal_spread | 2 | 1 | 50 | 129500.00 | unknown | — | 28.0950 | 1.6500 | ["35","40"] | ["1.0215","1.0323"] | [] | ["XPHO"] | 35.0000 | 40.0000 | 493 | 857 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:26:29Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a57e-c6fe-7152-8e2c-2545e0c89c21 | ASST | 2026-09-15 10:35 | call_diagonal_spread | 2 | 1 | 50 | 128500.00 | unknown | — | 27.8200 | 0.9500 | ["35","40"] | ["1.0289","1.0397"] | [] | ["XISX"] | 35.0000 | 40.0000 | 493 | 857 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:36:02Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a58e-c4be-7a30-9be1-2d7d4d46a404 | ASST | 2026-09-15 10:53 | call_diagonal_spread | 2 | 1 | 50 | 121400.00 | long | ask | 27.1500 | 1.0000 | ["35","40"] | ["1.0089","1.0217"] | [] | ["XISX"] | 35.0000 | 40.0000 | 493 | 857 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:53:26Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0ab04-762b-7223-a78f-283d59b04231 | ASST | 2026-09-16 12:19 | call_diagonal_spread | 2 | 1 | 50 | 119500.00 | long | ask | 27.2000 | 0.6500 | ["35","40"] | ["0.9879","1.0080"] | [] | ["XISX"] | 35.0000 | 40.0000 | 492 | 856 | false | true | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:19:54Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab31-7d83-79c3-bb60-968f1dd49029 | ASST | 2026-09-16 13:08 | call_diagonal_spread | 2 | 1 | 50 | 119750.00 | unknown | — | 27.1700 | 1.0000 | ["35","40"] | ["0.9896","1.0131"] | [] | ["AMXO"] | 35.0000 | 40.0000 | 492 | 856 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:09:01Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab4c-9703-7893-852d-d66677b1844b | ASST | 2026-09-16 13:38 | call_diagonal_spread | 2 | 1 | 50 | 121750.00 | unknown | — | 27.4800 | 1.2000 | ["35","40"] | ["0.9892","1.0113"] | [] | ["XISX"] | 35.0000 | 40.0000 | 492 | 856 | false | true | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:38:54Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0afaa-578c-7e13-b64a-270af921c109 | ASST | 2026-09-17 09:59 | call_diagonal_spread | 2 | 6 | 400 | 133984.00 | unknown | — | 28.4300 | 0.6100 | ["27","29"] | ["0.7451","0.7184"] | [] | ["ARCO","BATO","C2OX","EDGO","EMLD","SPHR"] | 27.0000 | 29.0000 | 22 | 29 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:59:29Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afda-1633-77b0-8ed3-0ca13bbbb9a8 | ASST | 2026-09-17 10:51 | call_diagonal_spread | 2 | 1 | 18500 | 3977500.00 | unknown | — | 28.8100 | 0.4300 | ["28","29"] | ["0.8260","0.7215"] | [] | ["AMXO"] | 28.0000 | 29.0000 | 1 | 8 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:51:52Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0da-e07b-70c1-80bf-949e1e6132f4 | ASST | 2026-09-17 15:32 | call_diagonal_spread | 2 | 1 | 184 | 161920.00 | unknown | — | 28.6000 | 1.4000 | ["24","26"] | ["3.8226","1.2942"] | [] | ["XBOX"] | 24.0000 | 26.0000 | 1 | 8 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:32:30Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b609-9cbf-7862-9a82-7da69bf634b6 | ASST | 2026-09-18 15:41 | call_diagonal_spread | 2 | 1 | 100 | 241200.00 | long | ask | 30.1200 | 1.3500 | ["17","38"] | ["0.9924","0.9530"] | [] | ["XMIO"] | 17.0000 | 38.0000 | 182 | 490 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:41:32Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0c448-8f07-7161-8186-ea3615e3b95e | ASST | 2026-09-21 10:04 | call_diagonal_spread | 2 | 1 | 55 | 116490.00 | short | bid | 30.3296 | 3.3500 | ["24","37"] | ["0.9371","0.9648"] | [] | ["XMIO"] | 24.0000 | 37.0000 | 116 | 487 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:04:44Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c465-cf4e-70d0-83d0-53d0fa1826a7 | ASST | 2026-09-21 10:36 | call_diagonal_spread | 2 | 1 | 72 | 140760.00 | short | bid | 29.7400 | 0.9500 | ["25","40"] | ["0.9431","0.9940"] | [] | ["XPHO"] | 25.0000 | 40.0000 | 116 | 487 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:36:51Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4b2-8bd6-7282-a312-682fa46881cc | ASST | 2026-09-21 12:00 | call_diagonal_spread | 2 | 1 | 18500 | 4671250.00 | unknown | ask | 29.1450 | 0.5100 | ["29","30"] | ["0.9638","0.8080"] | [] | ["XPHO"] | 29.0000 | 30.0000 | 4 | 11 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:00:55Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c543-f667-7703-8143-eadd9e53bde1 | ASST | 2026-09-21 14:39 | call_diagonal_spread | 2 | 1 | 82 | 207542.00 | short | bid | 30.0550 | 2.1000 | ["15","36"] | ["0.9301","0.9868"] | [] | ["SPHR"] | 15.0000 | 36.0000 | 179 | 487 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:39:33Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c544-11bf-7471-8916-3372e18cea62 | ASST | 2026-09-21 14:39 | call_diagonal_spread | 2 | 1 | 65 | 258245.00 | long | ask | 30.0700 | 4.2500 | ["15","20"] | ["1.0427","1.0131"] | [] | ["XPHO"] | 15.0000 | 20.0000 | 487 | 851 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:39:33Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c557-5f27-7850-baaa-4874db06417e | ASST | 2026-09-21 15:00 | call_diagonal_spread | 2 | 1 | 65 | 167050.00 | short | bid | 30.0501 | 0.8000 | ["15","35"] | ["0.9526","0.9831"] | [] | ["ARCO"] | 15.0000 | 35.0000 | 179 | 487 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:00:48Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |