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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c525-46ee-7931-af79-e889d6b6d849 | META | 2026-09-21 14:05 | put_frontspread | 2 | 1 | 48 | 63672.00 | long | ask | 742.4650 | 0.2500 | ["700","740"] | ["0.6126","0.6150"] | ["668.81","731.19"] | ["XISX"] | 700.0000 | 740.0000 | 4 | 4 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:06:02Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b077-a623-7b21-85ca-cc1e9b00358d | META | 2026-09-17 13:43 | put_frontspread | 2 | 1 | 20 | 33510.00 | long | ask | 677.9440 | 0.3500 | ["500","580"] | ["0.4297","0.4133"] | ["427.27","572.73"] | ["XMIO"] | 500.0000 | 580.0000 | 120 | 120 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:44:31Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a666-b9e6-71b0-ab0a-e323c85fa227 | META | 2026-09-15 14:49 | put_frontspread | 2 | 1 | 5 | 44381.00 | long | ask | 668.7000 | 3.8000 | ["480","500"] | ["0.4263","0.4242"] | ["406.76"] | ["XMIO"] | 480.0000 | 500.0000 | 822 | 822 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:49:24Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a0f2-1b88-7462-8be0-65f29f98ba9a | META | 2026-09-14 13:23 | put_frontspread | 2 | 1 | 4 | 62512.00 | long | ask | 664.2650 | 10.7000 | ["740","820"] | ["0.4859","0.7512"] | ["661.44","818.56"] | ["XMIO"] | 740.0000 | 820.0000 | 11 | 11 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:24:02Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a087af-5f28-7131-8361-7be376450b05 | META | 2026-09-09 15:40 | put_frontspread | 2 | 1 | 6 | 59606.00 | long | ask | 656.0700 | 6.1500 | ["700","725"] | ["0.4219","0.4403"] | ["641.49"] | ["XCBO"] | 700.0000 | 725.0000 | 16 | 16 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:40:23Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087ad-ec10-7592-9d4d-41aae1d57100 | META | 2026-09-09 15:38 | put_frontspread | 2 | 1 | 2 | 36147.00 | long | ask | 655.7900 | 5.6500 | ["550","750"] | ["0.4446","0.4603"] | ["373.99","726.01"] | ["XCBO"] | 550.0000 | 750.0000 | 828 | 828 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:39:14Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087ad-ec10-7592-9d4d-4198d4ac0372 | META | 2026-09-09 15:38 | put_frontspread | 2 | 1 | 2 | 36147.00 | long | ask | 655.8100 | 5.6500 | ["550","750"] | ["0.4446","0.4603"] | ["373.99","726.01"] | ["XCBO"] | 550.0000 | 750.0000 | 828 | 828 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:39:14Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087a4-10a0-7440-ba93-99044bfca42f | META | 2026-09-09 15:27 | put_frontspread | 2 | 1 | 4 | 43161.00 | long | ask | 655.7199 | 4.7000 | ["700","720"] | ["0.4196","0.4344"] | ["634.33"] | ["XMIO"] | 700.0000 | 720.0000 | 23 | 23 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:27:54Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086ec-6130-7060-aa99-84f04dabc216 | META | 2026-09-09 12:07 | put_frontspread | 2 | 1 | 8 | 83297.00 | long | ask | 653.7650 | 6.1000 | ["700","730"] | ["0.4501","0.4849"] | ["639.39"] | ["XCBO"] | 700.0000 | 730.0000 | 16 | 16 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:07:55Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0868e-2430-76a1-be34-9d8b0b5d2a29 | META | 2026-09-09 10:24 | put_frontspread | 2 | 1 | 20 | 56800.00 | long | ask | 642.5700 | 0.5000 | ["640","660"] | ["0.4124","0.4183"] | ["616.72"] | ["XMIO"] | 640.0000 | 660.0000 | 9 | 9 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:24:29Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |