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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c556-2e76-79b1-9447-7c943729f7ad | SPX | 2026-09-21 14:59 | put_ratio_spread | 2 | 1 | 3 | 28895.00 | unknown | — | 7772.1200 | 0.7000 | ["7275","7850"] | ["0.1889","0.1138"] | [] | ["XCBO"] | 7275.0000 | 7850.0000 | 25 | 25 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:59:21Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c539-0d6e-7440-acc6-16dfa029cb37 | SPX | 2026-09-21 14:27 | put_ratio_spread | 2 | 1 | 6 | 305040.00 | unknown | — | 7767.8300 | 2.2000 | ["7750","8300"] | ["0.1448","0.1278"] | [] | ["XCBO"] | 7750.0000 | 8300.0000 | 88 | 88 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:27:43Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c47b-66a6-70e3-aa57-146c1c341f54 | SPX | 2026-09-21 11:00 | put_ratio_spread | 2 | 1 | 2 | 27725.00 | unknown | — | 7723.0600 | 0.9000 | ["7150","7500"] | ["0.1889","0.1599"] | [] | ["XCBO"] | 7150.0000 | 7500.0000 | 101 | 101 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:00:29Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c462-9ee6-7c13-aba3-cd026b941476 | SPX | 2026-09-21 10:33 | put_ratio_spread | 2 | 1 | 14 | 93408.00 | unknown | bid | 7722.3900 | 1.1000 | ["7010","7410"] | ["0.2068","0.1643"] | ["6615","7405"] | ["XCBO"] | 7010.0000 | 7410.0000 | 60 | 60 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:33:23Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b606-f50f-7f13-80c0-757f690c4b5a | SPX | 2026-09-18 15:38 | put_ratio_spread | 2 | 1 | 4 | 40930.00 | long | bid | 7640.3300 | 0.9000 | ["5800","6800"] | ["0.2918","0.2121"] | ["6730.44"] | ["XCBO"] | 5800.0000 | 6800.0000 | 154 | 154 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:38:38Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5fb-5c4f-7683-8249-c0369398adec | SPX | 2026-09-18 15:25 | put_ratio_spread | 2 | 1 | 20 | 99060.00 | unknown | bid | 7639.9600 | 0.4500 | ["7610","7640"] | ["0.1075","0.1010"] | ["7560.50"] | ["XCBO"] | 7610.0000 | 7640.0000 | 7 | 7 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:26:01Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b544-7be7-7f70-af14-0742f7bd6259 | SPX | 2026-09-18 12:05 | put_ratio_spread | 2 | 1 | 6 | 31167.00 | long | bid | 7619.6700 | 1.3000 | ["7625","7650"] | ["0.0839","0.0838"] | ["7620.25"] | ["XCBO"] | 7625.0000 | 7650.0000 | 3 | 3 | false | false | false | true | false | mlat | 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 |
| 01a0b528-165f-7b63-920d-67354b61d96d | SPX | 2026-09-18 11:34 | put_ratio_spread | 2 | 1 | 8 | 48840.00 | unknown | — | 7626.9800 | 0.4000 | ["7610","7640"] | ["0.1122","0.1068"] | [] | ["XCBO"] | 7610.0000 | 7640.0000 | 7 | 7 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:35:10Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b524-93f0-7b60-93c4-d289b4b48b03 | SPX | 2026-09-18 11:31 | put_ratio_spread | 2 | 1 | 3 | 36745.00 | unknown | — | 7627.4000 | 1.5000 | ["6150","7600"] | ["0.2625","0.1558"] | [] | ["XCBO"] | 6150.0000 | 7600.0000 | 154 | 154 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:31:12Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0dc-a1b3-7440-93b6-26e2caa38d9d | SPX | 2026-09-17 15:34 | put_ratio_spread | 2 | 1 | 10 | 85980.00 | unknown | — | 7639.5900 | 1.1000 | ["6700","6930"] | ["0.2310","0.2094"] | [] | ["XCBO"] | 6700.0000 | 6930.0000 | 92 | 92 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:34:32Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0c4-7e02-7371-9d0d-548d75d8793c | SPX | 2026-09-17 15:07 | put_ratio_spread | 2 | 1 | 10 | 49435.00 | unknown | — | 7640.4500 | 0.5000 | ["7640","7660"] | ["0.0993","0.0952"] | [] | ["XCBO"] | 7640.0000 | 7660.0000 | 4 | 4 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:07:41Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b09a-5122-7241-a503-4564977dd2d9 | SPX | 2026-09-17 14:21 | put_ratio_spread | 2 | 1 | 10 | 37600.00 | unknown | — | 7638.8500 | 0.4000 | ["7640","7660"] | ["0.1350","0.1254"] | [] | ["XCBO"] | 7640.0000 | 7660.0000 | 1 | 1 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:22:16Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b06f-071b-7761-bfc6-a39bc3005507 | SPX | 2026-09-17 13:34 | put_ratio_spread | 2 | 1 | 12 | 97584.00 | unknown | — | 7633.2700 | 0.9000 | ["7525","7575"] | ["0.1352","0.1272"] | [] | ["XCBO"] | 7525.0000 | 7575.0000 | 19 | 19 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:34:40Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b041-fbdb-7d52-b7a6-ae1af1e4dfdb | SPX | 2026-09-17 12:45 | put_ratio_spread | 2 | 1 | 6 | 26865.00 | unknown | — | 7638.0100 | 0.6000 | ["7000","7200"] | ["0.2105","0.1852"] | [] | ["XCBO"] | 7000.0000 | 7200.0000 | 43 | 43 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:45:17Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afe0-7703-7262-843e-02a926c20286 | SPX | 2026-09-17 10:58 | put_ratio_spread | 2 | 1 | 10 | 47250.00 | unknown | — | 7621.3500 | 0.7000 | ["6150","6700"] | ["0.2853","0.2314"] | [] | ["XCBO"] | 6150.0000 | 6700.0000 | 92 | 92 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:58:53Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afcb-d5c3-70f2-a049-f066524f7174 | SPX | 2026-09-17 10:36 | put_ratio_spread | 2 | 1 | 10 | 48415.00 | unknown | — | 7630.4300 | 0.5000 | ["7620","7640"] | ["0.1128","0.1088"] | [] | ["XCBO"] | 7620.0000 | 7640.0000 | 4 | 4 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:36:12Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afad-8023-7d90-be36-363ec0c45ecc | SPX | 2026-09-17 10:02 | put_ratio_spread | 2 | 1 | 20 | 72800.00 | unknown | — | 7617.1300 | 0.5000 | ["6925","7400"] | ["0.2288","0.1594"] | [] | ["XCBO"] | 6925.0000 | 7400.0000 | 29 | 29 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:02:57Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abb4-4dcb-7e90-96fb-65326288ab37 | SPX | 2026-09-16 15:31 | put_ratio_spread | 2 | 1 | 2 | 48688.00 | unknown | — | 7528.6900 | 1.6000 | ["7450","7600"] | ["0.1631","0.1485"] | [] | ["XCBO"] | 7450.0000 | 7600.0000 | 65 | 65 | false | false | false | true | false | mlat | 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 |
| 01a0abaf-8723-7e32-8e5a-fe76a5d7cee0 | SPX | 2026-09-16 15:26 | put_ratio_spread | 2 | 1 | 3 | 32115.00 | unknown | — | 7509.4100 | 0.8000 | ["7540","7565"] | ["0.1904","0.1819"] | [] | ["XCBO"] | 7540.0000 | 7565.0000 | 2 | 2 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:26:54Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abac-106b-78e2-9110-ad95df5003b1 | SPX | 2026-09-16 15:22 | put_ratio_spread | 2 | 1 | 15 | 54675.00 | unknown | — | 7514.7800 | 0.6000 | ["7375","7500"] | ["0.2518","0.2061"] | [] | ["XCBO"] | 7375.0000 | 7500.0000 | 2 | 2 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:23:01Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba5-711b-77d3-97df-67edf940ffe1 | SPX | 2026-09-16 15:15 | put_ratio_spread | 2 | 1 | 12 | 36120.00 | unknown | — | 7529.1700 | 0.6000 | ["7375","7500"] | ["0.2490","0.2060"] | [] | ["XCBO"] | 7375.0000 | 7500.0000 | 2 | 2 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:15:40Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab92-c3db-7020-b435-2b3b0644c886 | SPX | 2026-09-16 14:55 | put_ratio_spread | 2 | 1 | 6 | 42320.00 | unknown | — | 7563.0500 | 0.8000 | ["7575","7590"] | ["0.2103","0.2049"] | [] | ["XCBO"] | 7575.0000 | 7590.0000 | 1 | 1 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:55:27Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab60-0f63-70c0-a3e9-5286798dbccd | SPX | 2026-09-16 13:59 | put_ratio_spread | 2 | 1 | 14 | 144690.00 | unknown | — | 7612.6500 | 29.3000 | ["7010","7410"] | ["0.2080","0.1656"] | [] | ["XCBO"] | 7010.0000 | 7410.0000 | 65 | 65 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:59:58Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab55-4d7b-7ff1-873f-6f5028181bfe | SPX | 2026-09-16 13:48 | put_ratio_spread | 2 | 1 | 12 | 110520.00 | unknown | — | 7608.1200 | 1.5000 | ["5325","6650"] | ["0.3165","0.2237"] | [] | ["XCBO"] | 5325.0000 | 6650.0000 | 212 | 212 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:48:18Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aada-1683-74c1-88bb-294d9ef40b54 | SPX | 2026-09-16 11:33 | put_ratio_spread | 2 | 1 | 20 | 76150.00 | unknown | — | 7611.9200 | 0.8000 | ["5850","6450"] | ["0.3190","0.2589"] | [] | ["XCBO"] | 5850.0000 | 6450.0000 | 93 | 93 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:33:52Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aaae-8244-7512-a3b5-30295fe6dcf3 | SPX | 2026-09-16 10:45 | put_ratio_spread | 2 | 1 | 14 | 145649.00 | unknown | — | 7610.0000 | 1.4000 | ["7010","7410"] | ["0.2079","0.1655"] | [] | ["XCBO"] | 7010.0000 | 7410.0000 | 65 | 65 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:46:26Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a65e-4da6-7e02-91cf-b8125240b9b9 | SPX | 2026-09-15 14:39 | put_ratio_spread | 2 | 1 | 2 | 27570.00 | unknown | — | 7584.1800 | 1.1000 | ["6900","7350"] | ["0.2158","0.1742"] | [] | ["XCBO"] | 6900.0000 | 7350.0000 | 94 | 94 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:39:57Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a65d-fb9d-7413-a0e3-65ff023134e1 | SPX | 2026-09-15 14:39 | put_ratio_spread | 2 | 1 | 2 | 27590.00 | unknown | — | 7583.5200 | 1.2000 | ["6900","7350"] | ["0.2158","0.1741"] | [] | ["XCBO"] | 6900.0000 | 7350.0000 | 94 | 94 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:39:57Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a60e-31d6-7bb1-b9d0-6b5ff8336ce5 | SPX | 2026-09-15 13:12 | put_ratio_spread | 2 | 1 | 2 | 27721.00 | unknown | — | 7584.4100 | 0.9000 | ["6900","7350"] | ["0.2163","0.1747"] | [] | ["XCBO"] | 6900.0000 | 7350.0000 | 94 | 94 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:12:25Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a60e-2236-7950-a977-8c661dfd33d4 | SPX | 2026-09-15 13:12 | put_ratio_spread | 2 | 1 | 2 | 27701.00 | unknown | — | 7584.6200 | 1.0000 | ["6900","7350"] | ["0.2163","0.1747"] | [] | ["XCBO"] | 6900.0000 | 7350.0000 | 94 | 94 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:12:25Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a589-8116-76b3-814a-ff0e9d46c023 | SPX | 2026-09-15 10:47 | put_ratio_spread | 2 | 1 | 8 | 53268.00 | unknown | — | 7582.9200 | 0.7000 | ["7100","7450"] | ["0.2104","0.1608"] | [] | ["XCBO"] | 7100.0000 | 7450.0000 | 31 | 31 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:47:29Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a589-561e-7222-91bc-78134b7e8c8c | SPX | 2026-09-15 10:47 | put_ratio_spread | 2 | 1 | 10 | 66585.00 | unknown | — | 7583.0100 | 0.7000 | ["7100","7450"] | ["0.2105","0.1608"] | [] | ["XCBO"] | 7100.0000 | 7450.0000 | 31 | 31 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:47:29Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |