core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg438,407 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 |
|---|
| 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 | false | 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 |
| 01a0cfbe-f227-7690-8498-770b0bf44ba2 | P | 2026-09-23 15:29 | other | 8 | 3 | 19 | 102554.00 | unknown | — | 109.6400 | 1.0000 | ["105","110","115","120"] | ["0.6920","0.6889","0.6885","0.6921"] | [] | ["MCRY","XISX","XPHO"] | 105.0000 | 120.0000 | 58 | 58 | false | false | false | true | true | ||||||||
| 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 | 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 | 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 | 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 | 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 | true | ||||||||||
| 01a0c512-4b8f-73d3-a9b7-cf1200a196cc | P | 2026-09-21 13:45 | iron_butterfly | 4 | 1 | 10 | 111970.00 | unknown | — | 112.9900 | 9.2000 | ["70","90","120"] | ["0.7292","0.7049","0.6876"] | [] | ["XISX"] | 70.0000 | 120.0000 | 487 | 487 | false | false | false | true | true | ||||||||
| 01a0c4c3-877f-7041-9f86-c6ee3ef4feba | P | 2026-09-21 12:19 | call_diagonal_spread | 2 | 1 | 550 | 1468500.00 | unknown | — | 113.3000 | 1.8000 | ["115","130"] | ["0.6764","0.6917"] | [] | ["XCBO"] | 115.0000 | 130.0000 | 60 | 151 | false | true | true | true | false | ||||||||
| 01a0c4c2-4eff-7c33-b18a-db3c53a927c5 | P | 2026-09-21 12:17 | call_diagonal_spread | 2 | 1 | 45 | 121230.00 | long | ask | 113.5100 | 1.4000 | ["115","130"] | ["0.6729","0.6948"] | [] | ["EDGO"] | 115.0000 | 130.0000 | 60 | 151 | false | true | 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 | true | ||||||||||
| 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 | true | ||||||||||
| 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 | ||||||||||
| 01a090e1-3530-73c0-99d8-90d7f5198f67 | P | 2026-09-11 10:31 | call_diagonal_spread | 2 | 1 | 28 | 114100.00 | short | ask | 98.1300 | 3.9000 | ["80","105"] | ["0.6657","0.6722"] | [] | ["AMXO"] | 80.0000 | 105.0000 | 126 | 161 | false | false | true | ||||||||||
| 01a090e1-1208-7ff1-b40e-54d17c9cb26a | P | 2026-09-11 10:31 | other | 2 | 1 | 40 | 162640.00 | unknown | — | 98.1300 | 4.3000 | ["80","105"] | ["0.6629","0.6707"] | [] | ["ARCO"] | 80.0000 | 105.0000 | 126 | 161 | false | false | true | true | false | ||||||||
| 01a090e1-1208-7ff1-b40e-54c569a6eaae | P | 2026-09-11 10:31 | call_diagonal_spread | 2 | 2 | 108 | 437670.00 | short | ask | 98.1300 | 4.3000 | ["80","105"] | ["0.6634","0.6651"] | [] | ["ARCO","XISX"] | 80.0000 | 105.0000 | 126 | 161 | false | false | true | ||||||||||
| 01a06d8a-51ad-7dd1-800a-554d37dda462 | P | 2026-09-04 13:49 | call_diagonal_spread_bearish | 2 | 1 | 70 | 174090.00 | short | ask | 98.3400 | 2.7000 | ["95","140"] | ["0.6106","0.6570"] | [] | ["XISX"] | 95.0000 | 140.0000 | 77 | 286 | false | false | true | ||||||||||
| 01a06d88-abcd-7053-847e-5cd80d4e9c9c | P | 2026-09-04 13:47 | call_diagonal_spread_bearish | 2 | 1 | 30 | 110100.00 | short | ask | 98.3100 | 3.9000 | ["85","130"] | ["0.6239","0.6574"] | [] | ["XPHO"] | 85.0000 | 130.0000 | 77 | 378 | false | false | true | ||||||||||
| 01a06d75-1045-7b21-99f7-534c698d3a0b | P | 2026-09-04 13:26 | call_diagonal_spread_bearish | 2 | 2 | 80 | 169600.00 | short | ask | 98.7900 | 1.9000 | ["100","150"] | ["0.6250","0.6497"] | [] | ["AMXO","XISX"] | 100.0000 | 150.0000 | 77 | 286 | false | true | true | ||||||||||
| 01a06d75-1045-7b21-99f7-532d297af6ee | P | 2026-09-04 13:26 | call_diagonal_spread_bearish | 2 | 2 | 80 | 169600.00 | short | ask | 98.7900 | 1.9000 | ["100","150"] | ["0.6247","0.6499"] | [] | ["AMXO","XISX"] | 100.0000 | 150.0000 | 77 | 286 | false | true | true |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:30:17Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:45:12Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:19:13Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:18:06Z"} |
| 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-15T15:51:42Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| 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 |
| 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 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:31:23Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:31:23Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:31:23Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:49:48Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:47:51Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:26:45Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:26:45Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |