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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b61a-c747-7b10-a53b-abda5e78212f | TLT | 2026-09-18 16:00 | call_diagonal_spread | 2 | 1 | 10107 | 405388.00 | unknown | ask | 81.2200 | 0.0400 | ["81","82"] | ["0.4589","0.1000"] | [] | ["XCBO"] | 81.0000 | 82.0000 | 0 | 7 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T20:00:17Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b61a-bf78-7562-909f-62590a6c3e75 | TLT | 2026-09-18 15:59 | call_diagonal_spread | 2 | 1 | 4500 | 184500.00 | unknown | bid | 81.2200 | 0.0400 | ["81","82"] | ["12.5908","0.1000"] | [] | ["XCBO"] | 81.0000 | 82.0000 | 0 | 7 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T20:00:17Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0afcb-d5c3-70f2-a049-f0383517f305 | TLT | 2026-09-17 10:36 | call_diagonal_spread | 2 | 1 | 66 | 113076.00 | unknown | — | 81.6350 | 1.1100 | ["65","96"] | ["0.1154","0.1512"] | [] | ["ARCO"] | 65.0000 | 96.0000 | 105 | 855 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:36:12Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afcb-aeb3-7341-90e2-19e66ed5ac16 | TLT | 2026-09-17 10:35 | call_diagonal_spread | 2 | 1 | 66 | 113006.00 | unknown | — | 81.6301 | 1.1100 | ["65","96"] | ["0.1154","0.1482"] | [] | ["XPHO"] | 65.0000 | 96.0000 | 105 | 855 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:36:12Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afbb-a923-7671-bac0-1dcc8524496e | TLT | 2026-09-17 10:18 | call_diagonal_spread | 2 | 1 | 10000 | 184000.00 | unknown | — | 81.5900 | 0.0200 | ["82","83"] | ["0.1399","0.1160"] | [] | ["AMXO"] | 82.0000 | 83.0000 | 1 | 8 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:18:31Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afb4-811b-7083-adbb-f41959564af8 | TLT | 2026-09-17 10:10 | call_diagonal_spread | 2 | 1 | 2400 | 546400.00 | unknown | — | 81.6250 | 0.0500 | ["82","87"] | ["0.0882","0.0921"] | [] | ["ARCO"] | 82.0000 | 87.0000 | 92 | 183 | false | true | true | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:10:43Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afb1-50b3-7c21-bfe4-9c8b7b0f54ef | TLT | 2026-09-17 10:07 | call_diagonal_spread | 2 | 1 | 165 | 162050.00 | unknown | — | 81.6100 | 0.4100 | ["75","110"] | ["0.1243","0.1580"] | [] | ["AMXO"] | 75.0000 | 110.0000 | 302 | 820 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:07:11Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afb0-fac3-70b1-889f-046ac9150b9e | TLT | 2026-09-17 10:06 | call_diagonal_spread | 2 | 1 | 165 | 162515.00 | unknown | — | 81.6150 | 0.4100 | ["75","110"] | ["0.1243","0.1546"] | [] | ["ARCO"] | 75.0000 | 110.0000 | 302 | 820 | false | false | true | 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 |
| 01a0afa9-d6a3-7c13-99a4-3738a9ca41d6 | TLT | 2026-09-17 09:58 | call_diagonal_spread | 2 | 1 | 99 | 175450.00 | unknown | — | 81.5650 | 0.8900 | ["65","85"] | ["0.1029","0.0765"] | [] | ["ARCO"] | 65.0000 | 85.0000 | 273 | 855 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:59:09Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afa9-a7c3-7900-be9d-b1e376f1ab5c | TLT | 2026-09-17 09:58 | call_diagonal_spread | 2 | 1 | 99 | 175340.00 | unknown | — | 81.5783 | 0.8900 | ["65","85"] | ["0.1022","0.0770"] | [] | ["XPHO"] | 65.0000 | 85.0000 | 273 | 855 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:58:45Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afa6-a253-7e83-b426-20084174f5dc | TLT | 2026-09-17 09:55 | call_diagonal_spread | 2 | 2 | 90 | 154665.00 | unknown | — | 81.5800 | 1.0600 | ["65","92"] | ["0.0981","0.1348"] | [] | ["ARCO","XPHO"] | 65.0000 | 92.0000 | 92 | 855 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:55:33Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afa1-ef33-7012-8cd0-52f17e06d20e | TLT | 2026-09-17 09:50 | call_diagonal_spread | 2 | 1 | 105 | 171010.00 | unknown | — | 81.5950 | 2.6100 | ["66","101"] | ["0.1057","0.1390"] | [] | ["AMXO"] | 66.0000 | 101.0000 | 195 | 855 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:50:31Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afa0-ed62-7ee2-a653-d2c55a22f7ea | TLT | 2026-09-17 09:49 | call_diagonal_spread | 2 | 1 | 105 | 182070.00 | unknown | — | 81.5450 | 2.7100 | ["65","81"] | ["0.1057","0.1038"] | [] | ["XPHO"] | 65.0000 | 81.0000 | 11 | 855 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:49:23Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab4c-c1fb-7c33-99fb-a5d818db3ee4 | TLT | 2026-09-16 13:38 | call_diagonal_spread | 2 | 1 | 90 | 154830.00 | unknown | — | 81.2150 | 1.1100 | ["65","114"] | ["0.1122","0.1324"] | [] | ["XPHO"] | 65.0000 | 114.0000 | 821 | 856 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:38:54Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab4b-c7fb-7e63-af03-96765e7e4251 | TLT | 2026-09-16 13:37 | call_diagonal_spread | 2 | 1 | 75 | 127400.00 | unknown | — | 81.2100 | 1.1200 | ["65","101"] | ["0.1100","0.0937"] | [] | ["AMXO"] | 65.0000 | 101.0000 | 639 | 856 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:38:01Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab31-3b1b-77b0-a8ca-ff299d18608b | TLT | 2026-09-16 13:08 | call_diagonal_spread | 2 | 1 | 99 | 154420.00 | unknown | — | 81.1550 | 0.3600 | ["67","93"] | ["0.1167","0.0879"] | [] | ["XPHO"] | 67.0000 | 93.0000 | 492 | 856 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:09:01Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab2c-f942-7231-adad-7207ec3e29b0 | TLT | 2026-09-16 13:04 | call_diagonal_spread | 2 | 1 | 60 | 102400.00 | unknown | — | 81.1500 | 1.4500 | ["69","72"] | ["0.1196","0.1348"] | [] | ["ARCO"] | 69.0000 | 72.0000 | 287 | 856 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:04:28Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab25-d90b-7a32-a33f-1344490fa72e | TLT | 2026-09-16 12:56 | call_diagonal_spread | 2 | 1 | 75 | 144650.00 | unknown | — | 81.1700 | 0.5500 | ["67","70"] | ["0.1213","0.1206"] | [] | ["XPHO"] | 67.0000 | 70.0000 | 639 | 856 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:57:19Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aaa6-298b-7133-8d9d-c515eecd7449 | TLT | 2026-09-16 10:36 | call_diagonal_spread | 2 | 1 | 3000 | 846000.00 | unknown | — | 81.0250 | 0.0400 | ["82","88"] | ["0.0846","0.1168"] | [] | ["XBOX"] | 82.0000 | 88.0000 | 121 | 184 | false | true | true | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:36:59Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a697-ad26-7df2-bcb1-f24bc45b5477 | TLT | 2026-09-15 15:42 | call_diagonal_spread | 2 | 1 | 10000 | 1480000.00 | unknown | — | 80.7550 | 0.0300 | ["81.5","82"] | ["0.1702","0.1133"] | [] | ["AMXO"] | 81.5000 | 82.0000 | 3 | 66 | false | true | true | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:42:57Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |