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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b4bd-bfb8-7b70-9643-0dd08e7ffa6c | TLT | 2026-09-18 09:38 | call_vertical_spread | 2 | 1 | 100 | 121800.00 | unknown | bid | 81.3740 | 4.1100 | ["77","90"] | ["0.1269","0.0618"] | ["89.18"] | ["ARCO"] | 77.0000 | 90.0000 | 854 | 854 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:39:02Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b01d-83eb-7a62-8e04-b3f7a1b83365 | TLT | 2026-09-17 12:05 | straddle | 2 | 1 | 759 | 399993.00 | short | bid | 81.6900 | 0.0900 | ["81"] | ["0.1052"] | ["75.73","86.27"] | ["XISX"] | 81.0000 | 81.0000 | 183 | 183 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:05:37Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b019-9803-7792-978d-e39d7c112506 | TLT | 2026-09-17 12:01 | synthetic | 2 | 1 | 198 | 105732.00 | short | bid | 81.6800 | 0.0200 | ["81"] | ["0.1071"] | ["81.58"] | ["XISX"] | 81.0000 | 81.0000 | 183 | 183 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:01:25Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aff5-00d2-7d30-aa3d-029e29970588 | TLT | 2026-09-17 11:21 | synthetic | 2 | 1 | 401 | 214134.00 | short | bid | 81.7200 | 0.0900 | ["81"] | ["0.1067"] | ["81.62"] | ["XCBO"] | 81.0000 | 81.0000 | 183 | 183 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:21:15Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afc3-fa0b-75d2-8f6a-2bc72c1523a9 | TLT | 2026-09-17 10:27 | put_butterfly_spread | 3 | 1 | 100 | 122050.00 | short | bid | 81.5950 | 1.2700 | ["60","81","95"] | ["0.1831","0.1859","0.2450"] | ["71.95","90.05"] | ["ARCO"] | 60.0000 | 95.0000 | 820 | 820 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:27:45Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afa8-c14a-7b21-b308-a077d91d4c32 | TLT | 2026-09-17 09:57 | put_vertical_spread | 2 | 4 | 5000 | 990648.00 | short | bid | 81.5800 | 0.0293 | ["75","80"] | ["0.1519","0.1456"] | ["78.90"] | ["XISX"] | 75.0000 | 80.0000 | 120 | 120 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:58:01Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab17-17b2-7bb0-82d7-a67e0f8e2090 | TLT | 2026-09-16 12:40 | call_diagonal_spread | 2 | 2 | 308 | 519596.00 | short | bid | 81.1200 | 0.0632 | ["65","99"] | ["0.1229","3.9268"] | [] | ["ARCO","XBOX"] | 65.0000 | 99.0000 | 0 | 856 | true | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:40:35Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab13-b86a-7b92-8af3-91e7b23951f3 | TLT | 2026-09-16 12:36 | call_vertical_spread | 2 | 1 | 50 | 114500.00 | short | bid | 81.0950 | 0.9500 | ["67","78"] | ["0.1198","0.1279"] | ["74.20"] | ["XPHO"] | 67.0000 | 78.0000 | 856 | 856 | true | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:37:06Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab09-294b-7a21-ad6b-038d81c02ac8 | TLT | 2026-09-16 12:24 | put_vertical_spread | 2 | 1 | 150 | 217650.00 | short | bid | 81.0800 | 1.1500 | ["79","89"] | ["0.1889","0.2172"] | ["83.55"] | ["XISX"] | 79.0000 | 89.0000 | 856 | 856 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:25:43Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab09-11db-7d01-9df8-9977c508c98a | TLT | 2026-09-16 12:24 | put_vertical_spread | 2 | 1 | 150 | 222900.00 | short | bid | 81.0850 | 0.6500 | ["78","90"] | ["0.1879","0.2219"] | ["83.46"] | ["XISX"] | 78.0000 | 90.0000 | 856 | 856 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:25:43Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a578-8956-73a1-9b26-17388b0c8da1 | TLT | 2026-09-15 10:28 | put_vertical_spread | 2 | 3 | 388 | 134246.00 | short | bid | 80.6050 | 0.0200 | ["80","81"] | ["0.1506","0.1509"] | ["80.54"] | ["AMXO","XCBO","XISX"] | 80.0000 | 81.0000 | 66 | 66 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:29:06Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a141-9b18-7eb1-a6ca-b08bf33543f4 | TLT | 2026-09-14 14:50 | put_vertical_spread | 2 | 1 | 490 | 111230.00 | short | bid | 81.1750 | 0.0200 | ["80","82"] | ["0.1335","0.1368"] | ["81.07"] | ["XPHO"] | 80.0000 | 82.0000 | 32 | 32 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:50:58Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08c7f-f620-75d1-9935-0368d904e413 | TLT | 2026-09-10 14:06 | risk_reversal | 2 | 1 | 1990 | 206960.00 | long | bid | 80.8150 | 0.0200 | ["80","82"] | ["0.1239","0.1240"] | ["80","82"] | ["XMIO"] | 80.0000 | 82.0000 | 20 | 20 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:06:29Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08be4-42c0-7b03-a931-dc4ae648ca41 | TLT | 2026-09-10 11:16 | put_calendar | 2 | 7 | 60 | 153214.00 | long | bid | 81.0450 | 0.5054 | ["93"] | ["0.2259"] | [] | ["ARCO","EMLD","MCRY","SPHR","XBOX","XISX","XPHO"] | 93.0000 | 93.0000 | 309 | 827 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:16:44Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b8c-9d40-75b3-aeb2-fb4df18b68d7 | TLT | 2026-09-10 09:40 | risk_reversal | 3 | 5 | 304 | 120360.00 | long | bid | 80.9250 | 0.0700 | ["78","83","90"] | ["0.1512","0.0867","0.1091"] | ["77.8"] | ["C2OX","EDGO","MCRY","XBOX","XCBO"] | 78.0000 | 90.0000 | 190 | 190 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:40:52Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b88-e808-7732-8726-6fc17a3bf6a0 | TLT | 2026-09-10 09:36 | put_vertical_spread | 2 | 3 | 419 | 166758.00 | short | bid | 80.9850 | 0.0600 | ["81","82"] | ["0.1409","0.1421"] | ["81.48"] | ["AMXO","XCBO","XISX"] | 81.0000 | 82.0000 | 71 | 71 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:36:39Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |