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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c595-5e3f-7890-8c95-ba8ee10e6cbf | QQQ | 2026-09-21 16:08 | other | 2 | 1 | 20000 | 29500000.00 | unknown | ask | 741.1469 | 0.1800 | ["725","775"] | ["0.1951","0.1851"] | [] | ["AMXO"] | 725.0000 | 775.0000 | 11 | 60 | true | 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 |
| 01a0c44c-4ff7-7f63-a116-7f7108e78295 | TLT | 2026-09-21 10:08 | other | 2 | 1 | 5100 | 227800.00 | unknown | ask | 81.5600 | 0.0200 | ["78","87"] | ["0.1493","0.1131"] | [] | ["AMXO"] | 78.0000 | 87.0000 | 60 | 88 | false | true | true | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:08:55Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b619-f83f-7921-a460-03153d69ccce | GFL | 2026-09-18 15:59 | other | 3 | 1 | 1000 | 338000.00 | unknown | ask | 42.5050 | 5.8500 | ["37.5","47.5","55"] | ["0.7270","0.5240","0.3496"] | [] | ["SPHR"] | 37.5000 | 55.0000 | 28 | 63 | false | true | true | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:59:18Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5fd-e4bf-77b1-8bd6-3dff9ca57620 | BNTX | 2026-09-18 15:28 | other | 3 | 1 | 250 | 272500.00 | unknown | ask | 96.3200 | 2.5500 | ["97.5"] | ["1.7546"] | [] | ["XBOX"] | 97.5000 | 97.5000 | 0 | 28 | false | false | true | false | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:28:53Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5ea-35af-73c2-91d7-b18fab4bc5fc | CYTK | 2026-09-18 15:06 | other | 3 | 1 | 300 | 258000.00 | unknown | ask | 69.1000 | 2.7500 | ["70"] | ["1.6091"] | [] | ["XBOX"] | 70.0000 | 70.0000 | 0 | 28 | false | false | true | false | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:07:06Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5e0-b030-7510-b70c-f8ab04f48a47 | HNI | 2026-09-18 14:56 | other | 3 | 1 | 6250 | 6600000.00 | unknown | ask | 45.9400 | 9.8000 | ["40","45","55"] | ["0.6303","5.2249","0.5224"] | [] | ["XCBO"] | 40.0000 | 55.0000 | 0 | 63 | false | false | true | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:57:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b531-0b57-7ed3-9886-ebdde52ada40 | RAL | 2026-09-18 11:44 | other | 3 | 1 | 1355 | 385565.00 | unknown | ask | 67.3900 | 6.0000 | ["60","65","75"] | ["0.6073","0.4238","0.4696"] | ["63.75"] | ["XCBO"] | 60.0000 | 75.0000 | 28 | 28 | true | true | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:45:08Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4f5-5dff-7eb1-99b8-6ea4500ae70a | SILJ | 2026-09-18 10:39 | other | 3 | 1 | 3000 | 342000.00 | unknown | ask | 29.7700 | 0.9000 | ["29","29.5","31"] | ["0.5292","0.7512","1.6841"] | [] | ["XISX"] | 29.0000 | 31.0000 | 0 | 7 | false | false | true | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:39:42Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4cd-cd18-73b3-9fd0-62972c37f016 | EWZ | 2026-09-18 09:56 | other | 3 | 1 | 5000 | 1745000.00 | unknown | ask | 37.3200 | 0.1000 | ["30","35","41"] | ["0.4620","0.4497","0.4500"] | ["41.29"] | ["AMXO"] | 30.0000 | 41.0000 | 63 | 63 | false | true | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:56:24Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |