core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg403,968 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | direction |
|---|
| 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 |
|---|
| 01a0ca9b-e5cf-7801-b4a8-f0989e11621a | TLT | 2026-09-22 15:33 | call_diagonal_spread | 2 | 1 | 175 | 223825.00 | unknown | ask | 81.8750 | 0.3600 | ["70","82"] | ["0.1097","0.1239"] | [] | ["XISX"] | 70.0000 | 82.0000 | 3 | 486 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T19:33:31Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0ca48-c876-7132-8010-0dab09e2d1a0 | TLT | 2026-09-22 14:02 | call_diagonal_spread | 2 | 1 | 175 | 220150.00 | unknown | bid | 81.7762 | 0.2600 | ["70","82"] | ["0.1162","0.1181"] | [] | ["XISX"] | 70.0000 | 82.0000 | 3 | 486 | false | false | true | ||||||||||
| 01a0ca3f-8d30-7801-ba8f-2b27000c80b6 | TLT | 2026-09-22 13:52 | call_diagonal_spread | 2 | 2 | 175 | 220150.00 | long | ask | 81.7200 | 0.5600 | ["70","82"] | ["0.0949","0.1190"] | [] | ["XISX"] | 70.0000 | 82.0000 | 3 | 486 | false | false | true | ||||||||||
| 01a0c9b9-8c7f-7f42-82ac-3d20e1c4cd3d | TLT | 2026-09-22 11:26 | call_diagonal_spread | 2 | 1 | 164 | 205164.00 | unknown | bid | 81.6990 | 0.2600 | ["70","82"] | ["0.1111","0.1219"] | [] | ["BATO"] | 70.0000 | 82.0000 | 3 | 486 | false | false | true | ||||||||||
| 01a0c9a7-6027-7a32-858d-885e843615a5 | TLT | 2026-09-22 11:06 | call_diagonal_spread | 2 | 1 | 157 | 196878.00 | long | ask | 81.7550 | 0.1100 | ["70","82"] | ["0.1112","0.1211"] | [] | ["XCBO"] | 70.0000 | 82.0000 | 3 | 486 | false | false | true | ||||||||||
| 01a0c9a5-ed0f-73c1-9140-144816a87da8 | TLT | 2026-09-22 11:04 | call_diagonal_spread | 2 | 1 | 172 | 216032.00 | unknown | ask | 81.7251 | 0.2600 | ["70","82"] | ["0.1124","0.1253"] | [] | ["XISX"] | 70.0000 | 82.0000 | 3 | 486 | false | false | true | ||||||||||
| 01a0c4e4-ee47-7471-85f4-e9c424731cd0 | TLT | 2026-09-21 12:55 | call_diagonal_spread | 2 | 1 | 898 | 149966.00 | long | ask | 81.7550 | 0.0700 | ["81","82"] | ["0.3713","0.0938"] | [] | ["EDGO"] | 81.0000 | 82.0000 | 0 | 32 | false | false | true | ||||||||||
| 01a0b61a-cf18-7340-9eb7-1ab071c490c6 | TLT | 2026-09-18 16:00 | call_diagonal_spread | 2 | 1 | 3500 | 147000.00 | short | ask | 81.2500 | 0.0400 | ["81","82"] | ["0.4589","0.0979"] | [] | ["AMXO"] | 81.0000 | 82.0000 | 0 | 7 | false | false | true | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||
| 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 | ||||||||
| 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 | ||||||||
| 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 | ||||||||
| 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 | ||||||||
| 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 | ||||||||
| 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 | ||||||||
| 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 | ||||||||
| 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 | ||||||||
| 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 | ||||||||
| 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 | ||||||||
| 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 | ||||||||
| 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 | ||||||||
| 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 | ||||||||
| 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 | ||||||||
| 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 | ||||||||
| 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 | ||||||||||
| 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 | ||||||||
| 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 | ||||||||
| 01a0a5bc-29d6-7e63-9be4-95a8af6c00ca | TLT | 2026-09-15 11:42 | call_diagonal_spread | 2 | 2 | 1000 | 372000.00 | long | ask | 80.8350 | 0.1000 | ["85","88"] | ["0.0858","0.0726"] | [] | ["ARCO"] | 85.0000 | 88.0000 | 275 | 493 | false | true | true | ||||||||||
| 01a0a5bb-1866-7842-97c5-6ef2a896a99f | TLT | 2026-09-15 11:41 | call_diagonal_spread | 2 | 1 | 7000 | 2604000.00 | long | ask | 80.8180 | 0.1000 | ["85","88"] | ["0.0860","0.0728"] | [] | ["ARCO"] | 85.0000 | 88.0000 | 275 | 493 | false | true | true | ||||||||||
| 01a0a076-38b0-7411-875c-c64ddde84b60 | TLT | 2026-09-14 11:08 | call_diagonal_spread | 2 | 1 | 500 | 103500.00 | long | ask | 80.8650 | 0.3500 | ["95","110"] | ["0.1034","0.1310"] | [] | ["SPHR"] | 95.0000 | 110.0000 | 494 | 823 | false | true | true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:02:49Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:52:36Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:26:48Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:06:39Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:05:25Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:56:07Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:43:20Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:41:53Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:08:43Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |