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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5de-4ed0-74d1-92ca-aa326cb87c74 | AAPL | 2026-09-18 14:53 | call_ratio_spread | 2 | 1 | 20 | 46900.00 | unknown | bid | 336.1200 | 0.8000 | ["330","360"] | ["0.2581","0.2418"] | ["365.63"] | ["XBOX"] | 330.0000 | 360.0000 | 119 | 119 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:54:08Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b512-3c9f-71f1-b5a5-37acf7a63d76 | AAPL | 2026-09-18 11:11 | call_ratio_spread | 2 | 1 | 744 | 97092.00 | unknown | bid | 334.9700 | 0.1400 | ["340","345"] | ["0.2158","0.2175"] | ["342.61"] | ["ARCO"] | 340.0000 | 345.0000 | 5 | 5 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:11:23Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d0-e228-7063-a1f7-8583c3f8f1af | AAPL | 2026-09-18 09:59 | call_ratio_spread | 2 | 1 | 350 | 84300.00 | long | ask | 335.1400 | 0.2600 | ["340","360"] | ["0.2298","0.2229"] | ["363.88"] | ["EDGO"] | 340.0000 | 360.0000 | 28 | 28 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:59:53Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0afdd-e6c4-7a73-b519-28fb636a1707 | AAPL | 2026-09-17 10:55 | call_ratio_spread | 2 | 1 | 20 | 28080.00 | unknown | — | 332.4500 | 0.4500 | ["330","360"] | ["0.2674","0.2538"] | [] | ["XMIO"] | 330.0000 | 360.0000 | 64 | 64 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:56:05Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afb1-067b-75b1-ba31-63f42c8c674d | AAPL | 2026-09-17 10:06 | call_ratio_spread | 2 | 1 | 57 | 109079.00 | unknown | — | 332.3200 | 0.4500 | ["370","380"] | ["0.2571","0.2556"] | [] | ["MCRY"] | 370.0000 | 380.0000 | 183 | 183 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:06:48Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aae7-590b-7aa2-afa0-e01a2430fbea | AAPL | 2026-09-16 11:48 | call_ratio_spread | 2 | 2 | 20 | 97170.00 | unknown | — | 333.2750 | 1.9500 | ["305","330"] | ["0.2844","0.2617"] | [] | ["EMLD","SPHR"] | 305.0000 | 330.0000 | 93 | 93 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:48:14Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aac5-5dd3-74d2-956b-738e7186804b | AAPL | 2026-09-16 11:10 | call_ratio_spread | 2 | 1 | 21 | 110592.00 | unknown | — | 333.6500 | 0.7000 | ["350","360"] | ["0.2723","0.2698"] | [] | ["XCBO"] | 350.0000 | 360.0000 | 274 | 274 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:11:05Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa97-1243-7d52-850a-6b63eff487e2 | AAPL | 2026-09-16 10:20 | call_ratio_spread | 2 | 5 | 49 | 60070.00 | unknown | — | 333.0500 | 0.2500 | ["360","385"] | ["0.2506","0.2457"] | [] | ["ARCO","C2OX","XBOX","XISX"] | 360.0000 | 385.0000 | 121 | 121 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:20:43Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa97-068b-7ac2-b26e-b1d6ab9f8e19 | AAPL | 2026-09-16 10:20 | call_ratio_spread | 2 | 5 | 30 | 38250.00 | unknown | — | 333.0000 | 0.2500 | ["360","385"] | ["0.2505","0.2459"] | [] | ["ARCO","C2OX","EDGO"] | 360.0000 | 385.0000 | 121 | 121 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:20:43Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa97-068b-7ac2-b26e-b1c7cfed1082 | AAPL | 2026-09-16 10:20 | call_ratio_spread | 2 | 3 | 37 | 39300.00 | unknown | — | 333.0000 | 0.2500 | ["360","385"] | ["0.2512","0.2464"] | [] | ["ARCO","XBOX"] | 360.0000 | 385.0000 | 121 | 121 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:20:43Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa93-2e2b-7203-ab91-32c3e8895a51 | AAPL | 2026-09-16 10:16 | call_ratio_spread | 2 | 1 | 1848 | 949872.00 | unknown | — | 333.6117 | 0.1900 | ["340","360"] | ["0.2431","0.2356"] | [] | ["ARCO"] | 340.0000 | 360.0000 | 30 | 30 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:16:32Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa93-2a43-7330-ad4d-1fe29db4f28b | AAPL | 2026-09-16 10:16 | call_ratio_spread | 2 | 1 | 124 | 63736.00 | unknown | — | 333.6117 | 0.1900 | ["340","360"] | ["0.2431","0.2356"] | [] | ["EDGO"] | 340.0000 | 360.0000 | 30 | 30 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:16:32Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa90-9233-78b1-8c72-b90f3d0e3cad | AAPL | 2026-09-16 10:13 | call_ratio_spread | 2 | 3 | 20 | 25619.00 | unknown | — | 333.7675 | 0.5000 | ["360","385"] | ["0.2522","0.2471"] | [] | ["ARCO","C2OX","XISX"] | 360.0000 | 385.0000 | 121 | 121 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:13:37Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa87-00fc-7ce1-aeee-117a7a6f7e50 | AAPL | 2026-09-16 10:02 | call_ratio_spread | 2 | 3 | 28 | 40721.00 | unknown | — | 333.4800 | 0.5000 | ["360","385"] | ["0.2510","0.2457"] | [] | ["ARCO","C2OX","XISX"] | 360.0000 | 385.0000 | 121 | 121 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:02:54Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a690-ee96-73a2-bb19-f0980b019437 | AAPL | 2026-09-15 15:35 | call_ratio_spread | 2 | 3 | 26 | 39940.00 | unknown | — | 330.1900 | 0.7500 | ["320","340"] | ["0.2574","0.2406"] | [] | ["ARCO","XBOX","XPHO"] | 320.0000 | 340.0000 | 38 | 38 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:35:42Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a68c-d7b6-7b72-b1e6-28649c99f59a | AAPL | 2026-09-15 15:30 | call_ratio_spread | 2 | 1 | 18 | 27270.00 | unknown | — | 329.9100 | 1.1500 | ["320","340"] | ["0.2568","0.2406"] | [] | ["XISX"] | 320.0000 | 340.0000 | 38 | 38 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:31:25Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a68c-d7b6-7b72-b1e6-28555d001ab3 | AAPL | 2026-09-15 15:30 | call_ratio_spread | 2 | 1 | 28 | 42700.00 | unknown | — | 329.9100 | 1.1500 | ["320","340"] | ["0.2594","0.2419"] | [] | ["EDGO"] | 320.0000 | 340.0000 | 38 | 38 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:31:25Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a542-b957-7493-b212-4ca170c625b7 | AAPL | 2026-09-15 09:30 | call_ratio_spread | 2 | 2 | 65 | 69268.00 | unknown | — | 328.7700 | 4.5000 | ["295","325"] | ["0.5199","0.2880"] | [] | ["XISX"] | 295.0000 | 325.0000 | 10 | 10 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:30:03Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a09206-e0e0-7902-831b-0d4db3a6c013 | AAPL | 2026-09-11 15:51 | call_ratio_spread | 2 | 2 | 260 | 88000.00 | long | ask | 332.3900 | 0.1200 | ["335","340"] | ["0.2416","0.2394"] | ["345.03"] | ["EMLD","XMIO"] | 335.0000 | 340.0000 | 7 | 7 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:52:06Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090c0-8601-7fc0-b093-570b5b32bb03 | AAPL | 2026-09-11 09:55 | call_ratio_spread | 2 | 1 | 590 | 86140.00 | long | ask | 331.6601 | 0.0400 | ["340","350"] | ["0.2695","0.2748"] | ["341","359.00"] | ["XBOX"] | 340.0000 | 350.0000 | 7 | 7 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T13:55:31Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08740-2a68-75c0-b086-e7f5f1711ac9 | AAPL | 2026-09-09 13:38 | call_ratio_spread | 2 | 2 | 14 | 57294.00 | long | ask | 311.4100 | 0.5000 | ["315","365"] | ["0.2862","0.2744"] | ["415.70"] | ["AMXO","XCBO"] | 315.0000 | 365.0000 | 373 | 373 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:39:15Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a06da3-119d-7672-8ec1-79ee8dda8d2f | AAPL | 2026-09-04 14:16 | call_ratio_spread | 2 | 2 | 40 | 27840.00 | long | ask | 321.0500 | 0.2400 | ["325","350"] | ["0.2442","0.2396"] | ["329.98","370.02"] | ["ARCO","XPHO"] | 325.0000 | 350.0000 | 42 | 42 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:16:55Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06da3-119d-7672-8ec1-79b56a3c948d | AAPL | 2026-09-04 14:16 | call_ratio_spread | 2 | 5 | 118 | 82246.00 | long | ask | 321.0500 | 0.2400 | ["325","350"] | ["0.2445","0.2398"] | ["329.98","370.02"] | ["AMXO","ARCO","XISX","XMIO","XPHO"] | 325.0000 | 350.0000 | 42 | 42 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:16:55Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06da3-0db5-7d00-9e24-726f1caffce9 | AAPL | 2026-09-04 14:16 | call_ratio_spread | 2 | 3 | 72 | 50144.00 | long | ask | 321.0500 | 0.2400 | ["325","350"] | ["0.2443","0.2397"] | ["329.98","370.02"] | ["AMXO","ARCO","XMIO"] | 325.0000 | 350.0000 | 42 | 42 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:16:55Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06da3-0db5-7d00-9e24-71e2f31237ae | AAPL | 2026-09-04 14:16 | call_ratio_spread | 2 | 2 | 44 | 30668.00 | long | ask | 321.0201 | 0.2400 | ["325","350"] | ["0.2448","0.2400"] | ["329.98","370.02"] | ["AMXO","XMIO"] | 325.0000 | 350.0000 | 42 | 42 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:16:55Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06da3-0db5-7d00-9e24-71dc1fb29cc8 | AAPL | 2026-09-04 14:16 | call_ratio_spread | 2 | 2 | 48 | 33456.00 | long | ask | 321.0201 | 0.2400 | ["325","350"] | ["0.2448","0.2400"] | ["329.98","370.02"] | ["ARCO","XPHO"] | 325.0000 | 350.0000 | 42 | 42 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:16:55Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06da3-0db5-7d00-9e24-7175f51a0757 | AAPL | 2026-09-04 14:16 | call_ratio_spread | 2 | 2 | 44 | 30628.00 | long | ask | 321.0201 | 0.2400 | ["325","350"] | ["0.2446","0.2398"] | ["329.98","370.02"] | ["AMXO","XMIO"] | 325.0000 | 350.0000 | 42 | 42 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:16:55Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06da3-0db5-7d00-9e24-711b3cbbce4f | AAPL | 2026-09-04 14:16 | call_ratio_spread | 2 | 2 | 68 | 47508.00 | long | ask | 321.0201 | 0.2400 | ["325","350"] | ["0.2452","0.2403"] | ["329.98","370.02"] | ["ARCO","XBOX"] | 325.0000 | 350.0000 | 42 | 42 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:16:55Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |