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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b0b2-5593-77c3-aee8-8b5d4ee48828 | SPY | 2026-09-17 14:47 | call_diagonal_spread | 2 | 1 | 10 | 224110.00 | unknown | — | 762.4200 | 3.3300 | ["640","700"] | ["1.8995","0.2021"] | [] | ["XBOX"] | 640.0000 | 700.0000 | 1 | 273 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:48:13Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a6-c4a3-7851-a499-1a0a5627520c | SPY | 2026-09-17 14:35 | call_diagonal_spread | 2 | 1 | 10 | 269800.00 | unknown | — | 762.4820 | 2.8700 | ["610","680"] | ["2.1609","0.2111"] | [] | ["XBOX"] | 610.0000 | 680.0000 | 1 | 273 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:35:42Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a610-48fe-7623-a31e-d2f264ac0392 | SPY | 2026-09-15 13:14 | call_diagonal_spread | 2 | 1 | 62 | 222518.00 | short | bid | 757.2400 | 2.2000 | ["740","741"] | ["0.3391","0.1526"] | [] | ["SPHR"] | 740.0000 | 741.0000 | 1 | 7 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:14:38Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a023-9470-79d1-b4f3-57169fa3be79 | SPY | 2026-09-14 09:37 | call_diagonal_spread | 2 | 1 | 14 | 241304.00 | short | ask | 758.5700 | 3.9400 | ["660","750"] | ["0.2609","0.1668"] | [] | ["XBOX"] | 660.0000 | 750.0000 | 95 | 276 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:38:02Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09133-9af0-76e0-9404-67a8fb88de68 | SPY | 2026-09-11 12:01 | call_diagonal_spread | 2 | 1 | 90 | 329760.00 | long | bid | 765.9000 | 0.3700 | ["750","763"] | ["0.1119","0.1304"] | [] | ["SPHR"] | 750.0000 | 763.0000 | 14 | 49 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:01:46Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0877f-7588-76e1-a972-94bb91de0d3e | SPY | 2026-09-09 14:47 | call_diagonal_spread | 2 | 1 | 72 | 1087272.00 | long | bid | 763.0900 | 3.2300 | ["680","765"] | ["0.3353","0.1651"] | [] | ["SPHR"] | 680.0000 | 765.0000 | 9 | 373 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:48:00Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08767-7118-7601-bf85-646d68edfcd5 | SPY | 2026-09-09 14:21 | call_diagonal_spread | 2 | 1 | 53 | 746558.00 | short | ask | 762.8100 | 2.5600 | ["690","765"] | ["0.3465","0.1650"] | [] | ["SPHR"] | 690.0000 | 765.0000 | 9 | 373 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:21:41Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08146-2ab8-7143-ae8a-6974f1abb472 | SPY | 2026-09-08 09:47 | call_diagonal_spread | 2 | 1 | 16 | 237809.00 | short | bid | 767.3880 | 7.3500 | ["700","750"] | ["0.4035","0.1657"] | [] | ["XBOX"] | 700.0000 | 750.0000 | 10 | 374 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:47:33Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |