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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c596-0e07-7631-8f3d-ff25bfa3c6af | QQQ | 2026-09-21 16:08 | other | 2 | 1 | 5000 | 7375000.00 | unknown | bid | 741.2900 | 0.1900 | ["725","775"] | ["0.1959","0.1847"] | [] | ["AMXO"] | 725.0000 | 775.0000 | 11 | 60 | false | true | true | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T20:09:30Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c569-8f67-7322-894f-daa48354b289 | QQQ | 2026-09-21 15:20 | other | 6 | 1 | 3000 | 7011400.00 | unknown | bid | 741.7500 | 0.2200 | ["665","670","680","690","703","710"] | ["0.2528","0.2542","0.2416","0.2358","0.2170","0.2078"] | [] | ["AMXO"] | 665.0000 | 710.0000 | 25 | 88 | false | true | true | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:20:46Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c51b-e0ae-7653-9c41-93a1ec343be5 | IBIT | 2026-09-21 13:55 | other | 2 | 1 | 3300 | 429000.00 | unknown | bid | 48.5651 | 0.0200 | ["42","56"] | ["0.4381","0.4318"] | [] | ["XBOX"] | 42.0000 | 56.0000 | 25 | 60 | false | true | true | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:55:42Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5e0-71af-7ae1-8aa3-1c2c148f8cc1 | INSM | 2026-09-18 14:56 | other | 3 | 1 | 300 | 1124700.00 | unknown | bid | 120.4100 | 5.9000 | ["130"] | ["2.0754"] | [] | ["EDGO"] | 130.0000 | 130.0000 | 0 | 119 | false | false | true | false | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:56:32Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5e0-3717-7e13-b10e-ffea22c20171 | IWM | 2026-09-18 14:56 | other | 4 | 1 | 2250 | 10354500.00 | unknown | bid | 283.5500 | 1.6400 | ["285","290","295"] | ["0.2079","0.1728","0.1787"] | [] | ["XBOX"] | 285.0000 | 295.0000 | 119 | 245 | false | false | true | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:56:06Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b588-a907-73d1-b5f7-9c4683f282c1 | INBX | 2026-09-18 13:20 | other | 3 | 1 | 250 | 1045000.00 | unknown | bid | 107.9850 | 23.1000 | ["95"] | ["3.7756"] | [] | ["EDGO"] | 95.0000 | 95.0000 | 0 | 63 | false | false | true | false | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:20:28Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b549-ea87-7832-afc7-1877dd64cdb9 | AI | 2026-09-18 12:11 | other | 4 | 2 | 1800 | 100800.00 | unknown | bid | 11.0697 | 0.0850 | ["11","11.5","12"] | ["0.5243","0.9169","2.2779"] | [] | ["EDGO"] | 11.0000 | 12.0000 | 0 | 7 | false | false | true | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:12:17Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b52c-7f47-7b71-81cb-1356f75e2ad3 | QQQ | 2026-09-18 11:39 | other | 2 | 1 | 1000 | 160000.00 | unknown | bid | 716.6000 | 0.0200 | ["710","725"] | ["0.1339","0.0996"] | [] | ["AMXO"] | 710.0000 | 725.0000 | 3 | 4 | false | true | true | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:40:00Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b50a-b6d8-72f0-9a0b-62ac2d62565b | SMCI | 2026-09-18 11:02 | other | 4 | 1 | 7500 | 1147500.00 | unknown | bid | 38.7050 | 0.0700 | ["39.5","42"] | ["0.7159","1.1562"] | [] | ["EDGO"] | 39.5000 | 42.0000 | 0 | 7 | false | true | true | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:02:59Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4db-3a97-7e43-b319-5e67e3bd2ba8 | UTHR | 2026-09-18 10:10 | other | 8 | 1 | 3220 | 5879650.00 | unknown | bid | 497.6700 | 36.3500 | ["430","460","480","540","570","600"] | ["0.3755","0.9213","1.4545","0.3671","1.6307","2.7493"] | [] | ["XPHO"] | 430.0000 | 600.0000 | 0 | 28 | false | true | true | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:11:06Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |