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 |
| 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 |
| 01a0b5f8-33b7-7983-848b-4c359330d886 | LRCX | 2026-09-18 15:22 | call_diagonal_spread | 2 | 1 | 4 | 170500.00 | short | ask | 283.2550 | 7.7000 | ["70","72"] | ["0.9838","1.4145"] | [] | ["XMIO"] | 70.0000 | 72.0000 | 91 | 119 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:22:42Z"} | 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 |
| 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 |
| 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 |
| 01a06d7c-e42d-72c0-987d-fbd56ec9d79a | LRCX | 2026-09-04 13:34 | call_diagonal_spread_bearish | 2 | 1 | 19 | 578303.00 | short | ask | 302.5700 | 7.2500 | ["145","270"] | ["0.6222","0.6089"] | [] | ["XMIO"] | 145.0000 | 270.0000 | 504 | 833 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:35:32Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |