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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c573-4b97-7fa2-840b-75c1c0775ab0 | LRCX | 2026-09-21 15:31 | call_vertical_spread | 2 | 1 | 2074 | 2069852.00 | short | bid | 303.9400 | 0.6000 | ["307.5","315"] | ["0.6146","0.6223"] | ["310.02"] | ["XPHO"] | 307.5000 | 315.0000 | 4 | 4 | true | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:31:13Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c501-8e67-7211-b327-1c65c67f568c | LRCX | 2026-09-21 13:26 | other | 3 | 1 | 5 | 110320.00 | unknown | bid | 300.4800 | 10.6500 | ["210","250","450"] | ["0.6231","0.6025","0.5945"] | [] | ["XCBO"] | 210.0000 | 450.0000 | 487 | 816 | false | false | true | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:27:09Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c42f-59e7-7031-84e6-c85079ed08f2 | LRCX | 2026-09-21 09:37 | iron_butterfly | 4 | 1 | 10 | 173470.00 | long | bid | 292.6900 | 10.7500 | ["280","300","320"] | ["0.5974","0.5900","0.5810"] | ["281.47","318.53"] | ["XCBO"] | 280.0000 | 320.0000 | 179 | 179 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:37:16Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5fb-e8ef-7382-97db-9a3e3a28c618 | LRCX | 2026-09-18 15:26 | call_diagonal_spread | 2 | 1 | 10 | 173510.00 | short | bid | 283.4250 | 5.6500 | ["200","210"] | ["27.3189","0.5856"] | [] | ["XCBO"] | 200.0000 | 210.0000 | 0 | 182 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:26:28Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b598-aaaf-78a3-8f24-e9a9f18fcbbc | LRCX | 2026-09-18 13:37 | call_vertical_spread | 2 | 1 | 33 | 195756.00 | short | bid | 282.7200 | 2.3500 | ["280","310"] | ["0.5885","0.5885"] | ["291.88"] | ["XCBO"] | 280.0000 | 310.0000 | 91 | 91 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:38:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4eb-d0af-7160-8737-1ac18a2aaa3b | LRCX | 2026-09-18 10:29 | put_vertical_spread | 2 | 1 | 100 | 194300.00 | unknown | bid | 280.3150 | 1.0000 | ["280","285"] | ["0.5548","0.5571"] | ["272.78"] | ["XCBO"] | 280.0000 | 285.0000 | 7 | 7 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:29:27Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4bc-9abf-7422-b3ef-663334b7cc10 | LRCX | 2026-09-18 09:37 | call_vertical_spread | 2 | 1 | 10 | 130360.00 | short | bid | 277.3200 | 5.2500 | ["200","240"] | ["0.6019","0.5863"] | ["232.04"] | ["XCBO"] | 200.0000 | 240.0000 | 63 | 63 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:37:49Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0afaa-4fbb-7870-bbc6-4f1f4ef5bdb2 | LRCX | 2026-09-17 09:59 | put_vertical_spread | 2 | 1 | 50 | 120050.00 | short | bid | 271.4550 | 3.2000 | ["230","250"] | ["0.5870","0.5849"] | ["243.29"] | ["XCBO"] | 230.0000 | 250.0000 | 64 | 64 | false | true | false | true | false | mlat | 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 |
| 01a0ab31-4ea3-7c51-805d-60eb225393f8 | LRCX | 2026-09-16 13:08 | call_vertical_spread | 2 | 1 | 9 | 322641.00 | short | bid | 271.4000 | 7.3000 | ["90","95"] | ["6.6390","6.3552"] | ["94.99"] | ["XCBO"] | 90.0000 | 95.0000 | 2 | 2 | false | false | false | 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 |
| 01a0ab1d-0f0b-7f41-83da-cca6f4e87b09 | LRCX | 2026-09-16 12:46 | call_vertical_spread | 2 | 1 | 9 | 314145.00 | short | bid | 272.0450 | 4.0500 | ["95","100"] | ["7.4542","7.2408"] | ["99.99"] | ["XCBO"] | 95.0000 | 100.0000 | 2 | 2 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:46:51Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a5d1-9636-7b51-af29-dc9323c341b4 | LRCX | 2026-09-15 12:06 | call_diagonal_spread | 2 | 1 | 10 | 297400.00 | short | bid | 266.2050 | 6.5000 | ["120","135"] | ["0.7544","0.6351"] | [] | ["XPHO"] | 120.0000 | 135.0000 | 122 | 493 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:06:47Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a172-1d10-7a92-b5f2-de2795518104 | LRCX | 2026-09-14 15:43 | iron_condor | 4 | 1 | 1080 | 1395487.00 | short | bid | 274.9100 | 1.5400 | ["255","275","285","305"] | ["0.6760","0.6414","0.6429","0.6745"] | ["266.11","293.89"] | ["XCBO"] | 255.0000 | 305.0000 | 4 | 4 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:43:50Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a09d-48b0-72b0-85c9-beeb782c4e57 | LRCX | 2026-09-14 11:50 | call_vertical_spread | 2 | 1 | 5 | 224785.00 | short | bid | 277.0550 | 7.4000 | ["50","55"] | ["6.7641","6.4203"] | ["54.99"] | ["XCBO"] | 50.0000 | 55.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:51:28Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08ce5-b8e9-7263-8ab0-5267f5c4b82b | LRCX | 2026-09-10 15:57 | call_diagonal_spread | 2 | 1 | 4 | 125384.00 | long | bid | 297.5800 | 7.0500 | ["165","195"] | ["0.6141","0.6103"] | [] | ["XCBO"] | 165.0000 | 195.0000 | 498 | 827 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:57:49Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ca2-acd8-7723-8aca-e416b507faea | LRCX | 2026-09-10 14:44 | call_diagonal_spread | 2 | 1 | 9 | 236151.00 | long | bid | 300.3675 | 6.1000 | ["210","260"] | ["0.6120","0.6113"] | [] | ["XCBO"] | 210.0000 | 260.0000 | 498 | 827 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:44:40Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c7b-2b90-7362-9fb6-c0aaa83b6433 | LRCX | 2026-09-10 14:01 | call_diagonal_spread | 2 | 1 | 5 | 162845.00 | long | bid | 301.4500 | 8.4000 | ["160","190"] | ["0.6099","0.6084"] | [] | ["XMIO"] | 160.0000 | 190.0000 | 498 | 827 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:01:27Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08222-bf78-7d20-8b87-7e96e2e95713 | LRCX | 2026-09-08 13:48 | call_vertical_spread | 2 | 1 | 10 | 122900.00 | short | bid | 320.0700 | 6.4500 | ["260","270"] | ["0.6280","0.6222"] | ["268.14"] | ["XCBO"] | 260.0000 | 270.0000 | 38 | 38 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:48:39Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081d1-3c48-7eb1-b560-5d32fce6c557 | LRCX | 2026-09-08 12:19 | put_vertical_spread | 2 | 1 | 4 | 159312.00 | short | bid | 319.6700 | 7.5000 | ["460","470"] | ["0.6714","0.6743"] | ["462.38"] | ["XCBO"] | 460.0000 | 470.0000 | 829 | 829 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:19:52Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081b8-eda0-7270-96f6-e127d83263ab | LRCX | 2026-09-08 11:52 | call_vertical_spread | 2 | 1 | 3 | 100773.00 | short | bid | 320.0600 | 6.9500 | ["150","155"] | ["3.7701","3.6324"] | ["154.99"] | ["XCBO"] | 150.0000 | 155.0000 | 3 | 3 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:52:59Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |