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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c580-3c17-7143-a2ce-c407e685cd5c | TQQQ | 2026-09-21 15:45 | call_vertical_spread | 2 | 1 | 200 | 107200.00 | long | ask | 79.2950 | 0.2200 | ["79","80"] | ["0.5005","0.4924"] | ["79.52"] | ["XMIO"] | 79.0000 | 80.0000 | 11 | 11 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:45:09Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4fa-d3bf-7171-aefd-f5dba6128a68 | TQQQ | 2026-09-21 13:19 | call_vertical_spread | 2 | 1 | 140 | 221900.00 | long | ask | 78.2200 | 0.3000 | ["70","75"] | ["0.5626","0.5181"] | ["73.71"] | ["XMIO"] | 70.0000 | 75.0000 | 25 | 25 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:19:42Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4fa-cfd7-7d73-9bfc-5b080ea1c679 | TQQQ | 2026-09-21 13:19 | call_vertical_spread | 2 | 1 | 160 | 253600.00 | long | ask | 78.2200 | 0.3000 | ["70","75"] | ["0.5626","0.5181"] | ["73.71"] | ["EMLD"] | 70.0000 | 75.0000 | 25 | 25 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:19:42Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4dd-2de7-7561-bf25-772b55906fe7 | TQQQ | 2026-09-21 12:47 | call_vertical_spread | 2 | 1 | 78 | 212316.00 | long | ask | 78.1500 | 0.5500 | ["70","75"] | ["0.6004","0.5829"] | ["72.94"] | ["XISX"] | 70.0000 | 75.0000 | 116 | 116 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:47:18Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4d9-884f-70d1-8cd0-32e6143bb6a4 | TQQQ | 2026-09-21 12:43 | call_vertical_spread | 2 | 1 | 47 | 181373.00 | long | ask | 78.1550 | 0.5000 | ["60","65"] | ["0.6659","0.6343"] | ["63.87"] | ["XISX"] | 60.0000 | 65.0000 | 88 | 88 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:43:14Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4cf-4b37-7632-873d-81d2246f76cb | TQQQ | 2026-09-21 12:31 | call_vertical_spread | 2 | 1 | 160 | 148160.00 | long | ask | 78.2350 | 0.3000 | ["73","75"] | ["0.5396","0.5144"] | ["74.72"] | ["BATO"] | 73.0000 | 75.0000 | 4 | 4 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:32:10Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4b6-604e-74f3-8c89-86be7f12e28f | TQQQ | 2026-09-21 12:04 | call_vertical_spread | 2 | 1 | 200 | 563000.00 | short | bid | 77.8150 | 0.6500 | ["67.5","75"] | ["0.6032","0.5751"] | ["72.05"] | ["XISX"] | 67.5000 | 75.0000 | 116 | 116 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:04:57Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c42f-753f-7983-8200-809306e9c577 | TQQQ | 2026-09-21 09:37 | call_vertical_spread | 2 | 1 | 165 | 167970.00 | long | ask | 75.2400 | 0.3600 | ["68","73"] | ["0.5597","0.4606"] | ["72.50"] | ["BATO"] | 68.0000 | 73.0000 | 4 | 4 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:37:33Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |