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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b623-6e1f-7c21-a784-dbf8f5bb2908 | TLT | 2026-09-18 16:09 | other | 3 | 1 | 180 | 104940.00 | unknown | ask | 81.2100 | 0.3200 | ["83.5","84","85"] | ["0.1425","0.1437","0.1808"] | [] | ["XPHO"] | 83.5000 | 85.0000 | 7 | 12 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T20:10:20Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b55e-87e0-75d1-ab83-d8d79cf06c34 | TLT | 2026-09-18 12:34 | other | 3 | 1 | 1400 | 236600.00 | unknown | ask | 81.2299 | 0.0500 | ["81","83"] | ["0.1277","0.0933"] | [] | ["XPHO"] | 81.0000 | 83.0000 | 28 | 91 | false | true | true | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:34:41Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0a4-7e9a-7871-8785-bb33bd1b922f | TLT | 2026-09-17 14:32 | other | 4 | 1 | 1534 | 1176780.00 | unknown | — | 81.6400 | 0.3800 | ["83","87","89","90"] | ["0.2295","0.6930","0.8894","0.9833"] | [] | ["XBOX"] | 83.0000 | 90.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:33:02Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a3-ea2b-7a40-b01c-4c59872826a9 | TLT | 2026-09-17 14:32 | other | 5 | 1 | 6897 | 8775514.00 | unknown | — | 81.6400 | 0.5500 | ["84","87","92","93"] | ["0.3672","0.5074","1.1640","1.4090"] | [] | ["XBOX"] | 84.0000 | 93.0000 | 1 | 13 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:32:30Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a3-079b-7342-9d17-36f65285a96e | TLT | 2026-09-17 14:31 | other | 5 | 1 | 8982 | 5186484.00 | unknown | — | 81.6450 | 0.4800 | ["83","85","86","87","90"] | ["0.2360","0.1381","0.6004","0.7053","0.2877"] | [] | ["XBOX"] | 83.0000 | 90.0000 | 1 | 13 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:31:45Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab00-efd3-7150-8b2c-6b2be2e3a3a7 | TLT | 2026-09-16 12:15 | other | 4 | 3 | 5802 | 5274018.00 | unknown | — | 81.1350 | 0.1300 | ["80","84"] | ["0.0791","0.0973"] | [] | ["AMXO"] | 80.0000 | 84.0000 | 93 | 212 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:16:40Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0910c-bdb8-7771-986a-86f4cde4ee9b | TLT | 2026-09-11 11:18 | other | 3 | 2 | 2500 | 206500.00 | unknown | — | 81.1943 | 0.0400 | ["70","74","76"] | ["0.1693","0.1544","0.1518"] | [] | ["AMXO"] | 70.0000 | 76.0000 | 126 | 126 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:18:47Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09101-30b0-7980-be97-f10e87e68db4 | TLT | 2026-09-11 11:06 | other | 4 | 1 | 7406 | 5687808.00 | unknown | — | 81.1900 | 0.2600 | ["70","80","83"] | ["0.1738","0.1765","0.1456"] | [] | ["XPHO"] | 70.0000 | 83.0000 | 70 | 497 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:06:32Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cd0-67e1-7e53-88bf-4c8a420335dd | TLT | 2026-09-10 15:34 | other | 3 | 2 | 945 | 323565.00 | unknown | — | 80.6700 | 0.0800 | ["80","83","84"] | ["0.1536","0.1016","0.1034"] | [] | ["AMXO"] | 80.0000 | 84.0000 | 127 | 127 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:34:31Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08caa-de80-7570-8e8f-3912f37e9ce7 | TLT | 2026-09-10 14:53 | other | 8 | 1 | 9110 | 9335560.00 | unknown | — | 80.7750 | 0.9500 | ["84","84.5","85","86","89","90","91"] | ["0.2444","0.1755","0.2315","0.2691","0.4264","0.4646","0.5019"] | [] | ["XBOX"] | 84.0000 | 91.0000 | 4 | 15 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:54:05Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08caa-bf40-73a1-9d3d-1861f58018bc | TLT | 2026-09-10 14:53 | other | 2 | 1 | 6898 | 8967400.00 | unknown | — | 80.7650 | 0.2200 | ["82.5","92"] | ["0.2494","0.4884"] | [] | ["XBOX"] | 82.5000 | 92.0000 | 1 | 8 | true | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:53:17Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08caa-9c18-71c0-a98d-fbda0bc584cb | TLT | 2026-09-10 14:53 | other | 5 | 1 | 5168 | 4318400.00 | unknown | — | 80.7700 | 0.5200 | ["83","84.5","85","87"] | ["0.3161","0.1923","0.2317","0.3210"] | [] | ["XBOX"] | 83.0000 | 87.0000 | 1 | 15 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:53:17Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08caa-84a8-72b1-b8a4-7cfcd5cee5fa | TLT | 2026-09-10 14:52 | other | 6 | 1 | 1618 | 2003032.00 | unknown | — | 80.7850 | 0.6600 | ["83","83.5","84.5","85","86","93"] | ["0.3356","0.4127","0.1769","0.2076","0.1808","0.3877"] | [] | ["XBOX"] | 83.0000 | 93.0000 | 1 | 20 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:53:17Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08caa-6569-7120-aae5-92a692b486d1 | TLT | 2026-09-10 14:52 | other | 2 | 1 | 2127 | 1807950.00 | unknown | — | 80.7750 | 0.2500 | ["85"] | ["0.2058"] | [] | ["XBOX"] | 85.0000 | 85.0000 | 8 | 20 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:53:17Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bb1-e438-7a23-9565-bebe82cacbf6 | TLT | 2026-09-10 10:21 | other | 2 | 1 | 190 | 253650.00 | unknown | — | 81.1985 | 0.4000 | ["75"] | ["0.1386"] | [] | ["SPHR"] | 75.0000 | 75.0000 | 112 | 127 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:21:42Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ba9-f4f8-7b81-89f7-08f8d53a8024 | TLT | 2026-09-10 10:12 | other | 2 | 1 | 405 | 630990.00 | unknown | — | 81.0800 | 0.3500 | ["75"] | ["0.1217"] | [] | ["SPHR"] | 75.0000 | 75.0000 | 344 | 498 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:12:52Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08781-e2a0-76e0-9978-d4beaf879c5d | TLT | 2026-09-09 14:50 | other | 4 | 2 | 5000 | 2600000.00 | unknown | — | 81.7065 | 0.0900 | ["78","82"] | ["0.1386","0.1406"] | [] | ["ARCO"] | 78.0000 | 82.0000 | 72 | 100 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:51:03Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08773-dcc8-7f80-914c-6fe8c739b2f2 | TLT | 2026-09-09 14:35 | other | 2 | 2 | 1600 | 208800.00 | unknown | — | 81.7428 | 0.0300 | ["82","84"] | ["0.0899","0.1016"] | [] | ["AMXO"] | 82.0000 | 84.0000 | 37 | 100 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:35:59Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0876f-7bb0-71a1-b27c-3a87165298df | TLT | 2026-09-09 14:30 | other | 3 | 1 | 6000 | 3045000.00 | unknown | — | 81.7450 | 0.2300 | ["81","84","85"] | ["0.1438","0.1451","0.1489"] | [] | ["XPHO"] | 81.0000 | 85.0000 | 72 | 100 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:30:53Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0876a-3039-74e3-8a3b-aaa6d9f76060 | TLT | 2026-09-09 14:24 | other | 6 | 1 | 905 | 1625700.00 | unknown | — | 81.7600 | 0.6000 | ["88","89","90","91","92","93"] | ["0.2508","0.2834","0.3153","0.3466","0.3772","0.4072"] | [] | ["XBOX"] | 88.0000 | 93.0000 | 9 | 9 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:25:12Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086c5-5900-7441-a957-254007d0bea9 | TLT | 2026-09-09 11:24 | other | 3 | 1 | 2000 | 978000.00 | unknown | — | 81.3601 | 0.1000 | ["78","83"] | ["0.1381","0.1324"] | [] | ["XBOX"] | 78.0000 | 83.0000 | 9 | 72 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:24:37Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086bc-c1c8-7570-a2d9-61f415ccf2e5 | TLT | 2026-09-09 11:15 | other | 3 | 1 | 1728 | 812160.00 | unknown | — | 81.4850 | 0.0900 | ["78","83"] | ["0.1375","0.1366"] | [] | ["XBOX"] | 78.0000 | 83.0000 | 9 | 72 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:15:40Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0819e-f918-7902-b240-1be233eac992 | TLT | 2026-09-08 11:24 | other | 3 | 1 | 10000 | 915000.00 | unknown | — | 82.1700 | 0.0300 | ["85","86","87"] | ["0.1136","0.1060","0.1023"] | [] | ["AMXO"] | 85.0000 | 87.0000 | 22 | 129 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:24:38Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |