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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b53a-004f-75d3-a920-8ae18c5d1814 | SPX | 2026-09-18 11:54 | call_butterfly_spread | 3 | 1 | 120 | 202740.00 | unknown | ask | 7619.9600 | 0.4000 | ["7615","7620","7625"] | ["0.1292","0.1257","0.1233"] | ["7628.45"] | ["XCBO"] | 7615.0000 | 7625.0000 | 0 | 0 | false | false | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:54:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0a2-f02b-7d02-9afc-d94153836d05 | SPX | 2026-09-17 14:31 | call_butterfly_spread | 3 | 1 | 100 | 95100.00 | unknown | — | 7638.8800 | 0.2500 | ["7630","7640","7650"] | ["0.1257","0.1070","0.1099"] | [] | ["XCBO"] | 7630.0000 | 7650.0000 | 0 | 0 | false | false | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:31:45Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afc2-9a7a-7671-b978-8047fa535a90 | SPX | 2026-09-17 10:25 | call_butterfly_spread | 3 | 1 | 100 | 1045100.00 | unknown | — | 7630.1700 | 1.0000 | ["7700","7775","7850"] | ["0.1205","0.1136","0.1090"] | [] | ["XCBO"] | 7700.0000 | 7850.0000 | 29 | 29 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:26:17Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afb7-192b-7991-90b7-277ea02ce75e | SPX | 2026-09-17 10:13 | call_butterfly_spread | 3 | 2 | 106 | 373120.00 | unknown | — | 7614.9200 | 0.4000 | ["7595","7605","7625"] | ["0.1721","0.1630","0.1551"] | [] | ["XCBO"] | 7595.0000 | 7625.0000 | 0 | 0 | false | false | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:13:28Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afb1-f8ab-7342-928c-2deb05fce369 | SPX | 2026-09-17 10:07 | call_butterfly_spread | 3 | 2 | 200 | 82800.00 | unknown | — | 7613.6900 | 0.3000 | ["7635","7655","7675"] | ["0.1608","0.1609","0.1744"] | [] | ["XCBO"] | 7635.0000 | 7675.0000 | 0 | 0 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:07:53Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abc0-01e3-7c40-8297-efe15cd33ab5 | SPX | 2026-09-16 15:44 | call_butterfly_spread | 3 | 1 | 200 | 391400.00 | unknown | — | 7532.3500 | 0.6000 | ["7560","7590","7620"] | ["0.1896","0.1806","0.1746"] | [] | ["XCBO"] | 7560.0000 | 7620.0000 | 1 | 1 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:44:59Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab21-7bdb-7d70-b122-38e479ab15c0 | SPX | 2026-09-16 12:51 | call_butterfly_spread | 3 | 1 | 400 | 257800.00 | unknown | — | 7609.9700 | 0.3000 | ["7660","7680","7700"] | ["0.3944","0.3856","0.3860"] | [] | ["XCBO"] | 7660.0000 | 7700.0000 | 0 | 0 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:52:33Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab16-96cb-7183-8366-263e11167ef0 | SPX | 2026-09-16 12:39 | call_butterfly_spread | 3 | 1 | 100 | 445950.00 | unknown | — | 7610.1700 | 0.5000 | ["7605","7615","7625"] | ["0.4195","0.4114","0.4049"] | [] | ["XCBO"] | 7605.0000 | 7625.0000 | 0 | 0 | false | false | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:40:35Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab0c-1f1b-7422-80ce-d2b201176546 | SPX | 2026-09-16 12:28 | call_butterfly_spread | 3 | 1 | 400 | 827500.00 | unknown | — | 7610.9000 | 0.5000 | ["7650","7710","7770"] | ["0.1350","0.1227","0.1141"] | [] | ["XCBO"] | 7650.0000 | 7770.0000 | 5 | 5 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:29:13Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aafe-b583-7cd2-9219-b0eb68fa9050 | SPX | 2026-09-16 12:13 | call_butterfly_spread | 3 | 1 | 200 | 109500.00 | unknown | — | 7613.7600 | 0.5000 | ["7725","7750","7775"] | ["0.1570","0.1553","0.1575"] | [] | ["XCBO"] | 7725.0000 | 7775.0000 | 2 | 2 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:14:28Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa77-e5cb-7fc0-afc8-2481e0326b11 | SPX | 2026-09-16 09:46 | call_butterfly_spread | 3 | 1 | 396 | 626868.00 | unknown | — | 7606.7600 | 0.8000 | ["7800","7850","7925"] | ["0.1099","0.1069","0.1054"] | [] | ["XCBO"] | 7800.0000 | 7925.0000 | 16 | 16 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:46:20Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a5a4-023e-7c00-a403-19cb3a129b56 | SPX | 2026-09-15 11:16 | call_butterfly_spread | 3 | 2 | 118 | 25370.00 | short | bid | 7580.3500 | 0.2000 | ["7605","7630","7655"] | ["0.1481","0.1766","0.2139"] | ["7606.30","7653.70"] | ["XCBO"] | 7605.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-15T15:16:41Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a54d-1456-7650-99f3-f191ed01eaa7 | SPX | 2026-09-15 09:41 | call_butterfly_spread | 3 | 1 | 200 | 139900.00 | unknown | — | 7609.4500 | 0.2500 | ["7620","7635","7650"] | ["0.1401","0.1391","0.1446"] | [] | ["XCBO"] | 7620.0000 | 7650.0000 | 0 | 0 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:41:39Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a086c4-b4f0-7fc0-9e66-7aef165a8dc4 | SPX | 2026-09-09 11:23 | call_butterfly_spread | 3 | 1 | 200 | 492000.00 | unknown | — | 7625.6900 | 1.0000 | ["7790","7890","7990"] | ["0.1105","0.1039","0.1027"] | [] | ["XCBO"] | 7790.0000 | 7990.0000 | 21 | 21 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:23:58Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08272-ac68-7693-a41f-dbddb3f64c7e | SIMO | 2026-09-08 15:15 | call_butterfly_spread | 3 | 3 | 800 | 2046100.00 | long | ask | 272.0500 | 5.7000 | ["260","270","280"] | ["0.8003","0.7863","0.8196"] | ["277.06"] | ["XCBO"] | 260.0000 | 280.0000 | 10 | 10 | false | false | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:15:54Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |