core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg508,354 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric |
|---|
| 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 |
|---|
| 01a0da20-c097-7282-9bc0-6803b575751f | P | 2026-09-25 15:52 | call_diagonal_spread | 2 | 1 | 21 | 104580.00 | short | bid | 126.2450 | 2.7000 | ["120","135"] | ["0.6666","0.6937"] | [] | ["XISX"] | 120.0000 | 135.0000 | 112 | 265 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T19:53:09Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d8fb-95cf-7a11-82c5-02d6b8f7d465 | P | 2026-09-25 10:32 | call_diagonal_spread | 2 | 1 | 57 | 487635.00 | long | bid | 124.6600 | 5.6000 | ["85","130"] | ["0.7247","0.7043"] | [] | ["XISX"] | 85.0000 | 130.0000 | 265 | 357 | false | false | |||||||||||
| 01a0d4f8-68c7-7053-be26-ee7462ea888e | P | 2026-09-24 15:50 | call_diagonal_spread | 2 | 2 | 30 | 282780.00 | short | bid | 122.5800 | 5.7000 | ["80","90"] | ["0.7666","0.7464"] | [] | ["XMIO"] | 80.0000 | 90.0000 | 113 | 266 | false | false | |||||||||||
| 01a0d462-1c37-7b61-9427-0b5c30856dce | P | 2026-09-24 13:06 | call_vertical_spread | 2 | 1 | 10 | 103140.00 | short | bid | 127.6050 | 6.2000 | ["125","160"] | ["0.6968","0.6838"] | ["135.30"] | ["XPHO"] | 125.0000 | 160.0000 | 848 | 848 | true | false | |||||||||||
| 01a0d3c2-d6c7-79d0-a424-70e138586496 | P | 2026-09-24 10:12 | call_diagonal_spread | 2 | 1 | 595 | 2855405.00 | short | bid | 128.3850 | 4.6000 | ["130","145"] | ["0.7304","0.6982"] | [] | ["XCBO"] | 130.0000 | 145.0000 | 148 | 239 | false | true | |||||||||||
| 01a0cfbf-cce7-7ed1-be0a-bbe35963aa39 | P | 2026-09-23 15:30 | other | 4 | 7 | 196 | 588974.00 | unknown | bid | 109.8000 | 2.5500 | ["120","125","145"] | ["0.7208","0.7371","0.7226"] | ["110.72"] | ["ARCO","EMLD","XISX","XMIO","XPHO"] | 120.0000 | 145.0000 | 58 | 58 | false | false | |||||||||||
| 01a0ced8-4f2f-7b40-b07f-f733aeb972c2 | P | 2026-09-23 11:17 | call_diagonal_spread | 2 | 2 | 82 | 143032.00 | unknown | bid | 109.4950 | 1.6000 | ["110","150"] | ["0.6669","0.6774"] | [] | ["ARCO","XBOX"] | 110.0000 | 150.0000 | 58 | 114 | false | true | |||||||||||
| 01a0ced7-ed87-7d63-878d-e375077ac739 | P | 2026-09-23 11:17 | call_diagonal_spread | 2 | 5 | 109 | 193650.00 | unknown | bid | 109.3500 | 1.3000 | ["110","150"] | ["0.6809","0.6873"] | [] | ["EDGO","XBOX","XCBO","XISX"] | 110.0000 | 150.0000 | 58 | 114 | false | true | |||||||||||
| 01a0ced4-1527-7942-ba2a-8da091465e29 | P | 2026-09-23 11:13 | call_diagonal_spread | 2 | 4 | 90 | 159684.00 | long | bid | 109.3750 | 1.7000 | ["110","150"] | ["0.6794","0.6864"] | [] | ["ARCO","EDGO","XBOX","XISX"] | 110.0000 | 150.0000 | 58 | 114 | false | true | |||||||||||
| 01a0cecf-f677-7500-9f2b-cb4ed397f1ae | P | 2026-09-23 11:08 | call_diagonal_spread | 2 | 5 | 59 | 105667.00 | long | bid | 109.1300 | 1.2966 | ["110","150"] | ["0.6896","0.6960"] | [] | ["C2OX","EMLD","XISX"] | 110.0000 | 150.0000 | 58 | 114 | false | true | |||||||||||
| 01a0cecf-d737-7890-8919-161a3913d460 | P | 2026-09-23 11:08 | call_diagonal_spread | 2 | 2 | 75 | 133705.00 | unknown | bid | 109.2000 | 3.0000 | ["110","150"] | ["0.6838","0.6940"] | [] | ["ARCO","XBOX"] | 110.0000 | 150.0000 | 58 | 114 | false | true | |||||||||||
| 01a0a5c3-7cd6-7ca1-89f4-fa8737739b9b | P | 2026-09-15 11:50 | call_diagonal_spread | 2 | 1 | 30 | 247293.00 | short | bid | 97.6500 | 3.1000 | ["60","75"] | ["0.7208","0.7024"] | [] | ["XCBO"] | 60.0000 | 75.0000 | 122 | 493 | false | false | |||||||||||
| 01a0a56f-175e-7e71-9bab-602ff5256c0c | P | 2026-09-15 10:18 | call_diagonal_spread | 2 | 1 | 10 | 109540.00 | long | bid | 97.6500 | 5.7000 | ["30","70"] | ["0.9697","0.7102"] | [] | ["XCBO"] | 30.0000 | 70.0000 | 122 | 367 | false | false | |||||||||||
| 01a0a0de-be80-73c0-869a-0c34662d1537 | P | 2026-09-14 13:02 | call_diagonal_spread | 2 | 1 | 24 | 204000.00 | short | bid | 95.4950 | 5.1000 | ["60","80"] | ["0.8354","0.6831"] | [] | ["C2OX"] | 60.0000 | 80.0000 | 123 | 858 | false | false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T14:32:47Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:51:03Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T17:07:08Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:12:47Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:31:21Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:17:59Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:17:59Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:13:32Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:09:29Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:08:48Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:51:42Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:19:00Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:02:42Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |