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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5df-a2a8-7382-99dd-7d341c20ec46 | SPX | 2026-09-18 14:55 | call_vertical_spread | 2 | 1 | 8 | 177152.00 | long | ask | 7643.2900 | 1.6000 | ["7500","8000"] | ["0.1371","0.0977"] | ["7711"] | ["XCBO"] | 7500.0000 | 8000.0000 | 28 | 28 | false | false | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:55:34Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5c5-d917-7ed2-9854-cab227d9d815 | SPX | 2026-09-18 14:27 | call_vertical_spread | 2 | 1 | 33 | 686400.00 | long | ask | 7633.2900 | 1.4000 | ["7500","8500"] | ["0.1353","0.1359"] | ["7707.50"] | ["XCBO"] | 7500.0000 | 8500.0000 | 28 | 28 | false | false | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:27:22Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b544-83b8-7630-a168-3a27f14b9e73 | SPX | 2026-09-18 12:05 | call_vertical_spread | 2 | 4 | 492 | 27060.00 | long | ask | 7619.6100 | 0.1000 | ["7660","7670"] | ["0.1411","0.1542"] | ["7660.15"] | ["XCBO"] | 7660.0000 | 7670.0000 | 0 | 0 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:06:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b544-83b8-7630-a168-3a1453bb4bf5 | SPX | 2026-09-18 12:05 | call_vertical_spread | 2 | 4 | 492 | 27060.00 | long | ask | 7619.6100 | 0.1000 | ["7660","7670"] | ["0.1411","0.1542"] | ["7660.15"] | ["XCBO"] | 7660.0000 | 7670.0000 | 0 | 0 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:06:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b541-c497-75a0-8d85-8603ad4314df | SPX | 2026-09-18 12:02 | call_vertical_spread | 2 | 2 | 93 | 2619996.00 | long | ask | 7619.4000 | 0.9500 | ["7500","8500"] | ["0.1443","0.1161"] | ["7777"] | ["XCBO"] | 7500.0000 | 8500.0000 | 63 | 63 | false | false | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:03:25Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b525-c0b8-7533-b449-db12ed36c08a | SPX | 2026-09-18 11:32 | call_vertical_spread | 2 | 1 | 200 | 33000.00 | long | ask | 7626.2500 | 0.1000 | ["7655","7665"] | ["0.1325","0.1366"] | ["7655.65"] | ["XCBO"] | 7655.0000 | 7665.0000 | 0 | 0 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:32:46Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0f8-e7fb-7bd1-82a5-9c13d4245681 | SPX | 2026-09-17 16:04 | call_vertical_spread | 2 | 1 | 65 | 869765.00 | long | ask | 7637.7700 | 1.6000 | ["7875","7950"] | ["0.1181","0.1148"] | ["7899.05"] | ["XCBO"] | 7875.0000 | 7950.0000 | 64 | 64 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T20:07:11Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0cb-d4eb-7ea2-bee7-09c85134e0c3 | SPX | 2026-09-17 15:15 | call_vertical_spread | 2 | 1 | 500 | 82000.00 | long | ask | 7639.3600 | 0.1000 | ["7645","7650"] | ["0.1154","0.1240"] | ["7645.70"] | ["XCBO"] | 7645.0000 | 7650.0000 | 0 | 0 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:15:54Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afc2-6b9a-7a13-9e95-5795c44931da | SPX | 2026-09-17 10:25 | call_vertical_spread | 2 | 1 | 120 | 79080.00 | long | ask | 7631.4300 | 0.1500 | ["7650","7655"] | ["0.1382","0.1369"] | ["7651.15"] | ["XCBO"] | 7650.0000 | 7655.0000 | 0 | 0 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:25:51Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afb3-489b-7e42-91c4-d76157624a47 | SPX | 2026-09-17 10:09 | call_vertical_spread | 2 | 1 | 500 | 140000.00 | long | ask | 7612.4200 | 0.1000 | ["7650","7660"] | ["0.1594","0.1630"] | ["7650.80"] | ["XCBO"] | 7650.0000 | 7660.0000 | 0 | 0 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:09:15Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afac-d82b-7663-a9bf-c201db1fc74f | PLNT | 2026-09-17 10:02 | call_vertical_spread | 2 | 2 | 330 | 141900.00 | long | ask | 50.7500 | 1.8000 | ["50","52.5"] | ["0.4101","0.3802"] | ["51.3"] | ["XCBO"] | 50.0000 | 52.5000 | 29 | 29 | false | false | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:02:24Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abb4-6153-7351-ac51-f669ab07208f | SPX | 2026-09-16 15:31 | call_vertical_spread | 2 | 2 | 1500 | 30000.00 | long | ask | 7527.7900 | 0.1000 | ["7600","7610"] | ["0.5885","0.5766"] | ["7600.10"] | ["XCBO"] | 7600.0000 | 7610.0000 | 0 | 0 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:32:05Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab73-58e3-7f11-88f3-b4b9deca07f8 | SPX | 2026-09-16 14:20 | call_vertical_spread | 2 | 1 | 198 | 111276.00 | long | ask | 7610.0100 | 0.7500 | ["8700","8800"] | ["0.1175","0.1204"] | ["8701"] | ["XCBO"] | 8700.0000 | 8800.0000 | 93 | 93 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:21:10Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab03-d602-7ab2-aecf-9355139c9f23 | SPX | 2026-09-16 12:19 | call_vertical_spread | 2 | 1 | 100 | 60200.00 | long | ask | 7615.0100 | 0.1500 | ["7675","7700"] | ["0.3650","0.3605"] | ["7677.70"] | ["XCBO"] | 7675.0000 | 7700.0000 | 0 | 0 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:19:54Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a614-7f1d-7230-a89e-93e38cbb9f62 | SPX | 2026-09-15 13:19 | call_vertical_spread | 2 | 2 | 1884 | 56520.00 | long | ask | 7580.2800 | 0.1000 | ["7620","7630"] | ["0.1532","0.1674"] | ["7620.10"] | ["XCBO"] | 7620.0000 | 7630.0000 | 0 | 0 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:19:56Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5ee-da66-7f02-9ac8-df9a4d5d1121 | SPX | 2026-09-15 12:38 | call_vertical_spread | 2 | 2 | 100 | 45000.00 | long | ask | 7587.9500 | 0.3500 | ["7730","7780"] | ["0.1421","0.1409"] | ["7732.50"] | ["XCBO"] | 7730.0000 | 7780.0000 | 3 | 3 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:38:41Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a592-184e-7642-bc93-080d821c98f5 | SPX | 2026-09-15 10:56 | call_vertical_spread | 2 | 3 | 415 | 45235.00 | long | ask | 7575.2700 | 0.1500 | ["7630","7635"] | ["0.1776","0.1810"] | ["7630.15"] | ["XCBO"] | 7630.0000 | 7635.0000 | 0 | 0 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:56:53Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a097-f568-7ef1-a950-f8328b985631 | MU | 2026-09-14 11:45 | call_vertical_spread | 2 | 1 | 30 | 535920.00 | long | ask | 923.3000 | 4.9500 | ["1000","1100"] | ["0.6103","0.6053"] | ["1031.50"] | ["XCBO"] | 1000.0000 | 1100.0000 | 123 | 123 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:45:15Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a024-c138-78a1-a876-30d34399399c | SPX | 2026-09-14 09:39 | call_vertical_spread | 2 | 1 | 400 | 46000.00 | long | ask | 7598.2200 | 0.1000 | ["7650","7655"] | ["0.1525","0.1562"] | ["7650.15"] | ["XCBO"] | 7650.0000 | 7655.0000 | 0 | 0 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:39:26Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09155-3868-7900-9a41-183ce4198c5b | SPX | 2026-09-11 12:37 | call_vertical_spread | 2 | 1 | 636 | 41340.00 | long | ask | 7664.9900 | 0.1000 | ["7700","7705"] | ["0.1380","0.1411"] | ["7700.15"] | ["XCBO"] | 7700.0000 | 7705.0000 | 0 | 0 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:38:30Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0914b-12c0-7a60-b0bf-794addf742e3 | SPX | 2026-09-11 12:26 | call_vertical_spread | 2 | 1 | 985 | 73875.00 | long | ask | 7666.9800 | 0.1000 | ["7700","7705"] | ["0.1312","0.1360"] | ["7700.15"] | ["XCBO"] | 7700.0000 | 7705.0000 | 0 | 0 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:27:08Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09127-8918-7d70-813e-84761c51ea59 | SPX | 2026-09-11 11:47 | call_vertical_spread | 2 | 2 | 250 | 31000.00 | long | ask | 7671.7600 | 0.1000 | ["7700","7710"] | ["0.1244","0.1305"] | ["7700.50"] | ["XCBO"] | 7700.0000 | 7710.0000 | 0 | 0 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:48:26Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090f6-3819-7692-96ee-1c7831d2a595 | SPX | 2026-09-11 10:54 | call_vertical_spread | 2 | 2 | 500 | 258500.00 | long | ask | 7655.7200 | 0.1500 | ["7675","7685"] | ["0.1399","0.1403"] | ["7676.75"] | ["XCBO"] | 7675.0000 | 7685.0000 | 0 | 0 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:54:21Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a087b7-fe30-7ff3-b301-985e315b885a | SPX | 2026-09-09 15:49 | call_vertical_spread | 2 | 1 | 130 | 3787420.00 | long | ask | 7643.0600 | 1.1000 | ["7750","7800"] | ["0.1332","0.1300"] | ["7775.40"] | ["XCBO"] | 7750.0000 | 7800.0000 | 72 | 72 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:49:45Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08760-a6d0-77e3-a855-90fb76c6995b | SPX | 2026-09-09 14:14 | call_vertical_spread | 2 | 2 | 200 | 156000.00 | long | ask | 7639.9200 | 0.2000 | ["7640","7645"] | ["0.1182","0.1109"] | ["7642.40"] | ["XCBO"] | 7640.0000 | 7645.0000 | 0 | 0 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:14:38Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086b5-b518-7833-aef4-72b383ee8c24 | SPX | 2026-09-09 11:07 | call_vertical_spread | 2 | 2 | 100 | 27500.00 | long | ask | 7640.7500 | 0.1500 | ["7665","7680"] | ["0.1355","0.1391"] | ["7666.45"] | ["XCBO"] | 7665.0000 | 7680.0000 | 0 | 0 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:07:49Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086b3-d4a0-7032-9ce6-03bd3785dcec | SPX | 2026-09-09 11:05 | call_vertical_spread | 2 | 2 | 150 | 42150.00 | long | ask | 7642.8600 | 0.2000 | ["7775","7800"] | ["0.1443","0.1412"] | ["7776.15"] | ["XCBO"] | 7775.0000 | 7800.0000 | 2 | 2 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:05:27Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08249-2780-7e63-96c1-4e8f79c3e1cb | SPX | 2026-09-08 14:30 | call_vertical_spread | 2 | 1 | 500 | 87000.00 | long | ask | 7692.6400 | 0.1000 | ["7700","7705"] | ["0.0934","0.1018"] | ["7700.60"] | ["XCBO"] | 7700.0000 | 7705.0000 | 0 | 0 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:30:36Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0813c-e3b9-71f3-9056-a923db991b83 | SPX | 2026-09-08 09:37 | call_vertical_spread | 2 | 1 | 200 | 44000.00 | long | ask | 7697.6400 | 0.1000 | ["7730","7740"] | ["0.1274","0.1321"] | ["7730.70"] | ["XCBO"] | 7730.0000 | 7740.0000 | 0 | 0 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:37:30Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |