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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a08136-f048-7e53-a463-a319108e0de9 | TQQQ | 2026-09-08 09:30 | call_vertical_spread | 2 | 4 | 27 | 233061.00 | short | bid | 73.0450 | 4.3667 | ["20","50"] | ["0.7496","0.6135"] | ["40.95"] | ["ARCO","XISX"] | 20.0000 | 50.0000 | 500 | 500 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:30:55Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0a03f-6d58-79b0-979b-8cf44550967c | TQQQ | 2026-09-14 10:08 | call_vertical_spread | 2 | 1 | 300 | 166500.00 | long | ask | 68.7050 | 0.3500 | ["70","75"] | ["0.5243","0.4845"] | ["72.01"] | ["XISX"] | 70.0000 | 75.0000 | 32 | 32 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:08:34Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a087-6ef1-7e62-a806-0ef397bb1c7f | TQQQ | 2026-09-14 11:27 | call_vertical_spread | 2 | 2 | 90 | 151650.00 | unknown | — | 68.7750 | 0.4000 | ["70","72.5"] | ["0.5780","0.5688"] | [] | ["EDGO","XCBO"] | 70.0000 | 72.5000 | 123 | 123 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:27:10Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0ab-46b8-76a0-9570-fc95fdc9f8ad | TQQQ | 2026-09-14 12:06 | call_vertical_spread | 2 | 1 | 40 | 194360.00 | long | ask | 69.2600 | 1.4500 | ["40","50"] | ["3.1158","1.3974"] | ["49.95"] | ["XCBO"] | 40.0000 | 50.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:06:49Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0aac5-03fb-7261-9a35-8542f9dda3c0 | TQQQ | 2026-09-16 11:10 | call_vertical_spread | 2 | 1 | 20 | 136900.00 | unknown | — | 69.8350 | 3.1000 | ["30","42"] | ["1.0144","0.6483"] | [] | ["EDGO"] | 30.0000 | 42.0000 | 93 | 93 | false | false | false | true | false | mlat | 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 |
| 01a0ab01-f973-7a93-98ce-f1f2363a427f | TQQQ | 2026-09-16 12:17 | call_vertical_spread | 2 | 1 | 32 | 112480.00 | short | bid | 69.5300 | 4.8500 | ["58.5","110"] | ["0.6158","0.5817"] | ["74.49"] | ["XISX"] | 58.5000 | 110.0000 | 492 | 492 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:17:49Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba5-1b2c-7ab0-bc17-5a6c2d5fbdcc | TQQQ | 2026-09-16 15:15 | call_vertical_spread | 2 | 1 | 225 | 387900.00 | long | ask | 67.2750 | 0.7500 | ["67.5","70"] | ["0.5793","0.5694"] | ["68.7"] | ["XISX"] | 67.5000 | 70.0000 | 121 | 121 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:15:19Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0af9e-d253-7592-87c2-9cb04ec1f5f7 | TQQQ | 2026-09-17 09:46 | call_vertical_spread | 2 | 1 | 1000 | 903000.00 | unknown | — | 70.7050 | 0.6500 | ["70.5","71"] | ["0.4935","0.5012"] | [] | ["XMIO"] | 70.5000 | 71.0000 | 36 | 36 | true | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:47:07Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b038-f35b-7f11-8a67-60511f450cc8 | TQQQ | 2026-09-17 12:35 | call_vertical_spread | 2 | 1 | 42 | 152292.00 | long | ask | 71.2300 | 1.7000 | ["70","90"] | ["0.6035","0.5833"] | ["77"] | ["BATO"] | 70.0000 | 90.0000 | 491 | 491 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:35:26Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b03a-e373-79a2-9044-8cbe5932a70c | TQQQ | 2026-09-17 12:37 | call_vertical_spread | 2 | 1 | 140 | 114100.00 | unknown | — | 71.2550 | 0.3000 | ["82.5","90"] | ["0.5288","0.5191"] | [] | ["XPHO"] | 82.5000 | 90.0000 | 120 | 120 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:37:34Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b03e-7d53-7441-8cbd-fc0d2ab6268e | TQQQ | 2026-09-17 12:41 | call_vertical_spread | 2 | 1 | 42 | 152880.00 | unknown | — | 71.3050 | 1.4500 | ["70","90"] | ["0.6025","0.5857"] | [] | ["XPHO"] | 70.0000 | 90.0000 | 491 | 491 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:41:46Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b040-4273-7f01-94be-4f6cfcd43309 | TQQQ | 2026-09-17 12:43 | call_vertical_spread | 2 | 1 | 80 | 276640.00 | long | ask | 71.3250 | 1.5500 | ["75","90"] | ["0.6042","0.5836"] | ["80.20"] | ["ARCO"] | 75.0000 | 90.0000 | 491 | 491 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:43:16Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b057-5c83-7c03-b280-20c3c10052c0 | TQQQ | 2026-09-17 13:08 | call_vertical_spread | 2 | 1 | 116 | 422240.00 | unknown | — | 71.4250 | 1.5000 | ["70","90"] | ["0.6031","0.5807"] | [] | ["SPHR"] | 70.0000 | 90.0000 | 491 | 491 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:09:06Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b099-5b0b-7a31-8b34-a24d14ae0d7f | TQQQ | 2026-09-17 14:20 | call_vertical_spread | 2 | 1 | 90 | 201690.00 | unknown | — | 71.3050 | 1.6500 | ["100","110"] | ["0.5766","0.5825"] | [] | ["BATO"] | 100.0000 | 110.0000 | 491 | 491 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:20:34Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b549-ee6f-7f32-adb0-f739516523cf | TQQQ | 2026-09-18 12:11 | call_vertical_spread | 2 | 2 | 20 | 104652.00 | long | ask | 71.1966 | 0.2500 | ["40","50"] | ["8.9466","7.8388"] | [] | ["EMLD","XISX"] | 40.0000 | 50.0000 | 0 | 0 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:12:17Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b611-c697-7222-bec4-ebbcbbeb3e39 | TQQQ | 2026-09-18 15:50 | call_vertical_spread | 2 | 2 | 198 | 609246.00 | long | ask | 72.3800 | 1.5500 | ["60","65"] | ["0.6025","0.5807"] | ["63.35"] | ["XMIO"] | 60.0000 | 65.0000 | 119 | 119 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:50:15Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |