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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b60b-90c0-7a22-a986-777a4c9cc895 | SPX | 2026-09-18 15:43 | put_vertical_spread | 2 | 1 | 10 | 389600.00 | long | ask | 7642.3600 | 1.6000 | ["7000","8000"] | ["0.2026","0.1201"] | ["7690"] | ["XCBO"] | 7000.0000 | 8000.0000 | 63 | 63 | false | false | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:43:38Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5c5-c977-7802-a963-be2dd9c12e20 | SPX | 2026-09-18 14:27 | put_vertical_spread | 2 | 1 | 33 | 2963895.00 | long | ask | 7632.8900 | 20.2000 | ["7500","8500"] | ["0.1390","0.1787"] | ["7710.65"] | ["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 |
| 01a0b54e-efaf-7fc1-9148-b29b0a0df2e0 | SPX | 2026-09-18 12:17 | put_vertical_spread | 2 | 2 | 12 | 1137048.00 | long | ask | 7620.6400 | 2.6000 | ["7500","8500"] | ["0.1525","0.1549"] | ["7784.50"] | ["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:17:49Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d5-4340-7b03-8d53-253529b416b7 | SPX | 2026-09-18 10:04 | put_vertical_spread | 2 | 2 | 200 | 2422000.00 | long | ask | 7621.8900 | 1.4000 | ["6000","6050"] | ["0.2655","0.2621"] | ["6047.30"] | ["XCBO"] | 6000.0000 | 6050.0000 | 210 | 210 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:04:31Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4b7-85f8-7cf1-a5d4-5d409000b8b8 | SPX | 2026-09-18 09:31 | put_vertical_spread | 2 | 1 | 770 | 438900.00 | long | ask | 7648.5000 | 0.3000 | ["6875","6900"] | ["0.2681","0.2632"] | ["6899.80"] | ["XCBO"] | 6875.0000 | 6900.0000 | 14 | 14 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:32:03Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4b7-85f8-7cf1-a5d4-5d31e01f5935 | SPX | 2026-09-18 09:31 | put_vertical_spread | 2 | 2 | 2530 | 1442100.00 | long | ask | 7648.5000 | 0.3000 | ["6875","6900"] | ["0.2681","0.2632"] | ["6899.80"] | ["XCBO"] | 6875.0000 | 6900.0000 | 14 | 14 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:32:03Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0aff2-4983-78a2-a64e-5820cbdb5571 | SPX | 2026-09-17 11:18 | put_vertical_spread | 2 | 1 | 200 | 324000.00 | long | ask | 7625.3500 | 0.4000 | ["7620","7625"] | ["0.1356","0.1335"] | ["7622.90"] | ["XCBO"] | 7620.0000 | 7625.0000 | 0 | 0 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:18:41Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afe7-9f0b-75f0-9b18-78d34327b5c6 | SPX | 2026-09-17 11:06 | put_vertical_spread | 2 | 1 | 60 | 30060.00 | long | ask | 7615.7900 | 0.3000 | ["7500","7525"] | ["0.1903","0.1753"] | ["7523.93"] | ["XCBO"] | 7500.0000 | 7525.0000 | 1 | 1 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:06:27Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afa1-ef33-7012-8cd0-53d464a614f1 | SPX | 2026-09-17 09:50 | put_vertical_spread | 2 | 1 | 30 | 71130.00 | long | ask | 7625.9500 | 0.2000 | ["7620","7625"] | ["0.1685","0.1680"] | ["7622.75"] | ["XCBO"] | 7620.0000 | 7625.0000 | 0 | 0 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:50:31Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aa9d-2cc3-7c10-a955-2b21a0e1fd58 | GLD | 2026-09-16 10:27 | put_vertical_spread | 2 | 4 | 80000 | 8800000.00 | long | ask | 397.3700 | 0.0800 | ["390","392"] | ["0.6232","0.6565"] | ["391.60"] | ["XCBO"] | 390.0000 | 392.0000 | 0 | 0 | true | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:27:28Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a5fd-ab5e-7c90-aa8f-d4e0c79875df | SPX | 2026-09-15 12:54 | put_vertical_spread | 2 | 2 | 200 | 150000.00 | long | ask | 7591.0000 | 0.2000 | ["7580","7585"] | ["0.1272","0.1255"] | ["7583.50"] | ["XCBO"] | 7580.0000 | 7585.0000 | 0 | 0 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:54:46Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5ae-9545-79b1-8f87-3db6dd99ab57 | SPX | 2026-09-15 11:27 | put_vertical_spread | 2 | 2 | 200 | 48000.00 | long | ask | 7585.7000 | 0.1500 | ["7355","7560"] | ["0.4748","0.1547"] | ["7557.70"] | ["XCBO"] | 7355.0000 | 7560.0000 | 0 | 0 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:28:32Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a163-05c8-7f51-a71a-cc68df2364d7 | SPX | 2026-09-14 15:26 | put_vertical_spread | 2 | 1 | 500 | 26000.00 | long | ask | 7630.0000 | 0.1500 | ["6500","7250"] | ["0.9513","0.4107"] | ["7249.60"] | ["XCBO"] | 6500.0000 | 7250.0000 | 1 | 1 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:26:54Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a06f-7250-7f00-abba-1e0b237866b9 | CRL | 2026-09-14 11:00 | put_vertical_spread | 2 | 1 | 100 | 164000.00 | long | ask | 271.5750 | 6.6000 | ["240","270"] | ["0.4458","0.4586"] | ["259.60"] | ["XCBO"] | 240.0000 | 270.0000 | 32 | 32 | true | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:00:55Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091d8-c048-7832-aea8-090fd8038d04 | SPX | 2026-09-11 15:01 | put_vertical_spread | 2 | 2 | 700 | 49000.00 | long | ask | 7664.9100 | 0.1000 | ["7635","7645"] | ["0.2081","0.1703"] | ["7644.80"] | ["XCBO"] | 7635.0000 | 7645.0000 | 0 | 0 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:02:05Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c8c-a050-7182-98e6-15f839edf9e9 | SPX | 2026-09-10 14:20 | put_vertical_spread | 2 | 1 | 1500 | 82500.00 | long | ask | 7591.2900 | 0.1000 | ["7540","7550"] | ["0.2431","0.2229"] | ["7549.85"] | ["XCBO"] | 7540.0000 | 7550.0000 | 0 | 0 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:20:58Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c22-49a8-76e3-841c-6deb450c47b0 | SPX | 2026-09-10 12:24 | put_vertical_spread | 2 | 2 | 300 | 256800.00 | long | ask | 7594.2300 | 0.3000 | ["7350","7400"] | ["0.1946","0.1802"] | ["7398.10"] | ["XCBO"] | 7350.0000 | 7400.0000 | 4 | 4 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:24:50Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c18-6e38-7862-b1f7-4393d3a4fc5a | RUT | 2026-09-10 12:13 | put_vertical_spread | 2 | 2 | 300 | 1087500.00 | long | ask | 2896.3535 | 1.1000 | ["2720","2840"] | ["0.2697","0.2248"] | ["2821.75"] | ["XCBO"] | 2720.0000 | 2840.0000 | 15 | 15 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:13:49Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c09-81e8-7c12-ace3-b58ecf4759cb | SPX | 2026-09-10 11:57 | put_vertical_spread | 2 | 1 | 60 | 264600.00 | long | ask | 7596.0100 | 0.6000 | ["7300","7400"] | ["0.1978","0.1797"] | ["7389.50"] | ["XCBO"] | 7300.0000 | 7400.0000 | 12 | 12 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:57:12Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a087c5-f468-7d02-8c53-1e7f46ea172c | SPX | 2026-09-09 16:04 | put_vertical_spread | 2 | 1 | 200 | 282200.00 | long | ask | 7636.3800 | 0.4000 | ["7425","7450"] | ["0.1641","0.1586"] | ["7448.45"] | ["XCBO"] | 7425.0000 | 7450.0000 | 6 | 6 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T20:07:42Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087b9-7530-7d31-b5c9-547e3a189ff4 | RUT | 2026-09-09 15:51 | put_vertical_spread | 2 | 1 | 650 | 110500.00 | long | ask | 2919.8569 | 0.4000 | ["2450","2600"] | ["0.4585","0.3673"] | ["2599.20"] | ["XCBO"] | 2450.0000 | 2600.0000 | 9 | 9 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:51:19Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086ba-a2d0-7d13-8a89-2551eb1fd5f5 | SPX | 2026-09-09 11:12 | put_vertical_spread | 2 | 1 | 181 | 329420.00 | long | ask | 7628.7200 | 0.3500 | ["7580","7640"] | ["0.1972","0.1462"] | ["7624.40"] | ["XCBO"] | 7580.0000 | 7640.0000 | 0 | 0 | false | false | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:13:15Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08217-ab88-7d12-8d8e-170f96528158 | SPX | 2026-09-08 13:36 | put_vertical_spread | 2 | 3 | 1000 | 40000.00 | long | ask | 7692.4600 | 0.1000 | ["7645","7655"] | ["0.1792","0.1594"] | ["7654.90"] | ["XCBO"] | 7645.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-08T17:37:15Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08179-6fb8-7921-bdfd-8abcbcb0b30f | RUT | 2026-09-08 10:43 | put_vertical_spread | 2 | 2 | 100 | 525900.00 | long | ask | 2964.6470 | 1.3000 | ["2500","2800"] | ["0.2768","0.2157"] | ["2769.91"] | ["XCBO"] | 2500.0000 | 2800.0000 | 73 | 73 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:43:56Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06d76-a685-7970-9e9c-f0dfd20e2ce9 | SPX | 2026-09-04 13:28 | put_vertical_spread | 2 | 1 | 499 | 45908.00 | long | ask | 7716.6300 | 0.1000 | ["7675","7685"] | ["0.1799","0.1579"] | ["7684.80"] | ["XCBO"] | 7675.0000 | 7685.0000 | 0 | 0 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:28:15Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |