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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b613-ed5f-7a93-895a-ad0b36756195 | APP | 2026-09-18 15:52 | put_vertical_spread | 2 | 1 | 400 | 373200.00 | short | bid | 310.7900 | 1.3000 | ["300","305"] | ["0.4828","0.4824"] | ["303.25"] | ["XCBO"] | 300.0000 | 305.0000 | 7 | 7 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:52:51Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4ff-3d57-7183-b45d-e36cb8fdf3e3 | APP | 2026-09-18 10:50 | put_vertical_spread | 2 | 1 | 50 | 237674.00 | long | ask | 315.7050 | 2.6000 | ["290","300"] | ["0.6756","0.6734"] | ["295.64"] | ["XCBO"] | 290.0000 | 300.0000 | 63 | 63 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:50:36Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0afcc-470a-7322-b09a-40f8a8291512 | APP | 2026-09-17 10:36 | put_vertical_spread | 2 | 1 | 180 | 292680.00 | short | bid | 318.2850 | 1.4000 | ["310","317.5"] | ["0.5497","0.5491"] | ["314.2"] | ["XPHO"] | 310.0000 | 317.5000 | 8 | 8 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:36:36Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a140-2031-7111-b8e5-b51300426433 | APP | 2026-09-14 14:48 | put_vertical_spread | 2 | 2 | 10 | 132330.00 | long | ask | 334.6700 | 5.8000 | ["360","400"] | ["0.6717","0.6740"] | ["371.65"] | ["EDGO"] | 360.0000 | 400.0000 | 67 | 67 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:49:10Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a087be-c878-7540-a664-7a426ecf5dbd | APP | 2026-09-09 15:56 | put_vertical_spread | 2 | 1 | 3 | 238869.00 | unknown | — | 305.2400 | 10.5000 | ["700","710"] | ["2.6394","2.7028"] | [] | ["XISX"] | 700.0000 | 710.0000 | 9 | 9 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:57:02Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086f1-9d08-7cc3-a153-6a9c61f37e40 | APP | 2026-09-09 12:12 | put_vertical_spread | 2 | 1 | 526 | 17080798.00 | short | bid | 309.1050 | 4.3000 | ["440","450"] | ["0.6982","0.7000"] | ["442.05"] | ["XCBO"] | 440.0000 | 450.0000 | 281 | 281 | true | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:13:21Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0818e-e3e8-7093-ade9-823a5a55ad17 | APP | 2026-09-08 11:06 | put_vertical_spread | 2 | 1 | 15 | 334665.00 | long | ask | 310.6900 | 8.4000 | ["410","420"] | ["0.6805","0.6856"] | ["411.27"] | ["XCBO"] | 410.0000 | 420.0000 | 73 | 73 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:07:08Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |