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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c4ac-e687-7721-b0d3-497d2a137b5b | SPX | 2026-09-21 11:54 | put_ratio_spread | 2 | 2 | 500 | 615900.00 | unknown | ask | 7738.5100 | 0.3000 | ["7690","7715"] | ["0.1308","0.1183"] | ["7702.68"] | ["XCBO"] | 7690.0000 | 7715.0000 | 1 | 1 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:54:39Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4ab-e4b7-7fd3-953c-feb429dccc52 | SPX | 2026-09-21 11:53 | put_ratio_spread | 2 | 3 | 500 | 609600.00 | unknown | ask | 7739.1700 | 0.2500 | ["7690","7715"] | ["0.1309","0.1193"] | ["7702.81"] | ["XCBO"] | 7690.0000 | 7715.0000 | 1 | 1 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:53:14Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c499-e73f-7742-92d3-5a4d3df3e0dc | SPX | 2026-09-21 11:33 | put_ratio_spread | 2 | 1 | 14 | 53886.00 | unknown | ask | 7729.6600 | 0.5500 | ["5600","7690"] | ["0.4493","0.1213"] | ["7613.02"] | ["XCBO"] | 5600.0000 | 7690.0000 | 28 | 28 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:33:41Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c470-9907-7b42-b8ee-f63e2c48cd76 | SPX | 2026-09-21 10:48 | put_ratio_spread | 2 | 3 | 1000 | 770000.00 | unknown | ask | 7722.5200 | 0.2000 | ["7550","7600"] | ["0.1528","0.1389"] | ["7584.60"] | ["XCBO"] | 7550.0000 | 7600.0000 | 4 | 4 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:48:50Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c46a-2896-7502-b8dc-97fc5906528f | SPX | 2026-09-21 10:41 | put_ratio_spread | 2 | 2 | 500 | 3608750.00 | unknown | ask | 7723.3500 | 1.3000 | ["7485","7650"] | ["0.1468","0.1252"] | ["7546.89"] | ["XCBO"] | 7485.0000 | 7650.0000 | 25 | 25 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:41:29Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c457-b9d7-7d00-aa73-4ba0460797c4 | SPX | 2026-09-21 10:21 | put_ratio_spread | 2 | 2 | 333 | 295340.00 | unknown | ask | 7714.9800 | 0.3000 | ["7705","7710"] | ["0.1115","0.1087"] | ["7702.58"] | ["XCBO"] | 7705.0000 | 7710.0000 | 0 | 0 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:21:25Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c44a-a247-7ed3-a99b-52d4765c880a | SPX | 2026-09-21 10:06 | put_ratio_spread | 2 | 3 | 158 | 122320.00 | unknown | ask | 7702.4600 | 0.2000 | ["7685","7695"] | ["0.1265","0.1120"] | ["7687.26"] | ["XCBO"] | 7685.0000 | 7695.0000 | 0 | 0 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:07:08Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c433-2e5e-7bf3-97b2-a42410e4cbba | SPX | 2026-09-21 09:41 | put_ratio_spread | 2 | 3 | 1000 | 351000.00 | unknown | ask | 7696.8000 | 0.1500 | ["7665","7675"] | ["0.1320","0.1203"] | ["7671.49"] | ["XCBO"] | 7665.0000 | 7675.0000 | 0 | 0 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:41:38Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b589-8b98-7d31-8133-1d090d16dcea | SPX | 2026-09-18 13:21 | put_ratio_spread | 2 | 2 | 1000 | 595000.00 | unknown | ask | 7624.0300 | 0.4000 | ["6500","7250"] | ["0.3463","0.1844"] | ["7238.10"] | ["XCBO"] | 6500.0000 | 7250.0000 | 14 | 14 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:21:57Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b56a-e3f0-7051-aabd-2986dd868085 | SPX | 2026-09-18 12:47 | put_ratio_spread | 2 | 1 | 88 | 1285908.00 | unknown | ask | 7620.1800 | 1.8000 | ["7550","7700"] | ["0.1346","0.1177"] | ["7511.17"] | ["XCBO"] | 7550.0000 | 7700.0000 | 28 | 28 | false | false | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:47:59Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b532-863f-7910-876c-1159e4bc87ea | SPX | 2026-09-18 11:46 | put_ratio_spread | 2 | 2 | 298 | 50910.00 | unknown | ask | 7622.6200 | 0.1000 | ["7570","7590"] | ["0.1880","0.1577"] | ["7588.29"] | ["XCBO"] | 7570.0000 | 7590.0000 | 0 | 0 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:46:50Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b51a-fecf-7662-a467-3b5d25cef082 | SPX | 2026-09-18 11:20 | put_ratio_spread | 2 | 1 | 12 | 50916.00 | unknown | ask | 7628.3200 | 0.4000 | ["5600","7590"] | ["0.4479","0.1308"] | ["7505.14"] | ["XCBO"] | 5600.0000 | 7590.0000 | 28 | 28 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:21:05Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b519-9387-7c91-87df-ef196c4d5c32 | SPX | 2026-09-18 11:19 | put_ratio_spread | 2 | 1 | 199 | 54695.00 | unknown | ask | 7626.2800 | 0.1000 | ["7575","7600"] | ["0.1831","0.1525"] | ["7597.25"] | ["XCBO"] | 7575.0000 | 7600.0000 | 0 | 0 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:19:20Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b500-df4f-7f01-83cf-299b8d0a5b6a | SPX | 2026-09-18 10:52 | put_ratio_spread | 2 | 2 | 150 | 118200.00 | unknown | ask | 7628.1400 | 0.2000 | ["7610","7615"] | ["0.1532","0.1525"] | ["7606.95"] | ["XCBO"] | 7610.0000 | 7615.0000 | 0 | 0 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:52:29Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4da-253f-7d31-ac17-8ff530d0e66c | SPX | 2026-09-18 10:09 | put_ratio_spread | 2 | 3 | 400 | 771200.00 | unknown | ask | 7623.5700 | 0.3000 | ["7620","7625"] | ["0.1650","0.1646"] | ["7609.82"] | ["XCBO"] | 7620.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-18T14:09:54Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d2-35ff-7a70-8443-5b0c004dbf91 | SPX | 2026-09-18 10:01 | put_ratio_spread | 2 | 1 | 395 | 560031.00 | unknown | ask | 7629.1100 | 0.3000 | ["7620","7625"] | ["0.1538","0.1524"] | ["7613.01"] | ["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-18T14:01:23Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4c5-d607-7b11-9402-0d99a85b17cb | SPX | 2026-09-18 09:47 | put_ratio_spread | 2 | 1 | 100 | 27700.00 | unknown | ask | 7640.1100 | 0.1000 | ["7575","7600"] | ["0.2017","0.1734"] | ["7597.23"] | ["XCBO"] | 7575.0000 | 7600.0000 | 0 | 0 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:47:37Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |