Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
312,778 rowsCSV — whole table, not this view
Sources in this table
uw_multileg312,778 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5f0-adef-7c91-b667-3ddf0c12bb12 | XLU | 2026-09-18 15:14 | strangle | 2 | 1 | 2100 | 128100.00 | short | bid | 41.2250 | 0.1100 | ["39.5","43"] | ["0.1880","0.1460"] | ["38.89","43.61"] | ["ARCO"] | 39.5000 | 43.0000 | 42 | 42 | false | true | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:14:17Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b581-ea77-72b3-86b3-37c49f6d2e34 | SFM | 2026-09-18 13:13 | strangle | 2 | 1 | 1000 | 485000.00 | short | bid | 70.9500 | 0.8500 | ["60","90"] | ["0.4722","0.4585"] | ["55.15","94.85"] | ["ARCO"] | 60.0000 | 90.0000 | 119 | 119 | false | true | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:13:28Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b572-c38f-7f93-b614-3a92e55c0c3d | DOW | 2026-09-18 12:56 | strangle | 2 | 1 | 1500 | 1335000.00 | short | bid | 28.5200 | 0.9000 | ["30","35"] | ["0.4571","0.3576"] | ["21.10","43.90"] | ["AMXO"] | 30.0000 | 35.0000 | 490 | 490 | false | false | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:56:35Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b555-e4f0-7972-a01d-12e34f1b5e52 | CRWV | 2026-09-18 12:24 | strangle | 2 | 2 | 3000 | 26775000.00 | short | bid | 79.6200 | 1.7000 | ["150","170"] | ["0.8330","0.7622"] | ["60.75","259.25"] | ["ARCO"] | 150.0000 | 170.0000 | 490 | 490 | true | false | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:25:11Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b542-a727-7fe0-a116-5e0a6006c176 | SOFI | 2026-09-18 12:03 | strangle | 2 | 1 | 1000 | 547000.00 | short | bid | 16.8414 | 0.1500 | ["15","17"] | ["0.5622","0.5802"] | ["9.53","22.47"] | ["ARCO"] | 15.0000 | 17.0000 | 272 | 272 | false | true | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:04:02Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b504-a427-76b0-89df-532519d53059 | QQQ | 2026-09-18 10:56 | strangle | 2 | 1 | 2000 | 74000.00 | short | bid | 717.3900 | 0.0200 | ["710","720"] | ["0.2477","0.1691"] | ["709.63","720.37"] | ["AMXO"] | 710.0000 | 720.0000 | 0 | 0 | false | true | false | true | true | mlct | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:56:13Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4ec-9400-7ac3-b8b6-8bafc5671a19 | ETOR | 2026-09-18 10:29 | strangle | 2 | 1 | 1500 | 1125000.00 | short | bid | 28.0700 | 2.0000 | ["25","40"] | ["0.5001","0.5020"] | ["17.50","47.50"] | ["ARCO"] | 25.0000 | 40.0000 | 490 | 490 | true | true | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:30:10Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d9-0fe7-7691-bbf7-78d57b9bb639 | XLK | 2026-09-18 10:08 | strangle | 2 | 1 | 1200 | 441600.00 | short | bid | 187.5900 | 0.6000 | ["189","190"] | ["0.1897","0.1856"] | ["185.32","193.68"] | ["XBOX"] | 189.0000 | 190.0000 | 7 | 7 | true | false | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:08:42Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |