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 |
|---|
| 01a0c9c3-15e7-71a2-b0ae-91bf1605dd58 | ZS | 2026-09-22 11:36 | call_diagonal_spread | 2 | 1 | 13 | 105300.00 | unknown | bid | 207.2300 | 5.0000 | ["165","170"] | ["0.8579","0.4481"] | [] | ["XBOX"] | 165.0000 | 170.0000 | 10 | 59 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T15:37:05Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c982-e837-7d00-a656-f20da0f1a8f8 | ZS | 2026-09-22 10:26 | call_diagonal_spread | 2 | 1 | 17 | 103530.00 | long | ask | 205.4900 | 2.8000 | ["200","240"] | ["0.5971","0.6051"] | [] | ["EMLD"] | 200.0000 | 240.0000 | 115 | 241 | false | false | true | ||||||||||
| 01a0c4d3-a47f-7091-972c-d29a9d17756b | ZS | 2026-09-21 12:36 | call_diagonal_spread | 2 | 2 | 10 | 194864.00 | short | bid | 204.4400 | 4.8500 | ["140","145"] | ["0.6210","0.6042"] | [] | ["XCBO","XISX"] | 140.0000 | 145.0000 | 487 | 851 | false | false | true | ||||||||||
| 01a0c4d3-a47f-7091-972c-d27db401b065 | ZS | 2026-09-21 12:36 | call_diagonal_spread | 2 | 3 | 65 | 1265906.00 | short | bid | 204.4400 | 4.2808 | ["140","145"] | ["0.6206","0.6031"] | [] | ["XCBO","XISX","XPHO"] | 140.0000 | 145.0000 | 487 | 851 | false | false | true | ||||||||||
| 01a0c4d3-a47f-7091-972c-d23b906ea906 | ZS | 2026-09-21 12:36 | call_diagonal_spread | 2 | 2 | 53 | 1031648.00 | short | bid | 204.4400 | 4.6000 | ["140","145"] | ["0.6197","0.6024"] | [] | ["XISX","XPHO"] | 140.0000 | 145.0000 | 487 | 851 | false | false | true | ||||||||||
| 01a0c4cd-10e7-7643-8109-46110393ab77 | ZS | 2026-09-21 12:29 | call_diagonal_spread | 2 | 1 | 15 | 292410.00 | long | ask | 204.8250 | 4.4000 | ["140","145"] | ["0.6158","0.6008"] | [] | ["XISX"] | 140.0000 | 145.0000 | 487 | 851 | false | false | true | ||||||||||
| 01a0c46e-629f-7fd1-8f77-428164d91caa | ZS | 2026-09-21 10:46 | call_diagonal_spread | 2 | 1 | 10 | 160440.00 | short | ask | 204.6900 | 3.6500 | ["125","150"] | ["0.6465","0.6214"] | [] | ["XISX"] | 125.0000 | 150.0000 | 179 | 269 | false | false | true | ||||||||||
| 01a0c461-0c8f-7f21-9f8b-88dd0edc561f | ZS | 2026-09-21 10:31 | call_diagonal_spread | 2 | 1 | 30 | 115260.00 | long | ask | 205.4300 | 2.3500 | ["200","220"] | ["0.5667","0.6263"] | [] | ["XISX"] | 200.0000 | 220.0000 | 39 | 88 | false | false | true | ||||||||||
| 01a0ab26-d6f3-7643-a224-b71af0ed4586 | ZS | 2026-09-16 12:57 | call_diagonal_spread | 2 | 1 | 10 | 160470.00 | long | bid | 194.3650 | 5.1000 | ["145","200"] | ["0.6164","0.5924"] | [] | ["XCBO"] | 145.0000 | 200.0000 | 639 | 856 | false | false | true | ||||||||||
| 01a0a6a6-011e-7de1-bff6-2418c62144eb | ZS | 2026-09-15 15:58 | call_diagonal_spread | 2 | 1 | 50 | 177350.00 | unknown | — | 193.6000 | 5.1500 | ["175","190"] | ["0.7105","0.5777"] | [] | ["XPHO"] | 175.0000 | 190.0000 | 3 | 38 | false | false | true | true | false | ||||||||
| 01a0a66f-417e-7fe1-89bb-130ca6f6bcf6 | ZS | 2026-09-15 14:58 | call_diagonal_spread | 2 | 1 | 8 | 103080.00 | unknown | — | 194.2350 | 6.7000 | ["200","230"] | ["0.6090","0.5947"] | [] | ["XPHO"] | 200.0000 | 230.0000 | 640 | 857 | false | true | true | true | false | ||||||||
| 01a0a66a-868e-70d0-a485-88b4d7a4b1e1 | ZS | 2026-09-15 14:53 | call_diagonal_spread | 2 | 6 | 13 | 166839.00 | short | bid | 194.2650 | 6.0423 | ["200","230"] | ["0.6059","0.5923"] | [] | ["EMLD","SPHR","XBOX","XMIO"] | 200.0000 | 230.0000 | 640 | 857 | false | true | true | ||||||||||
| 01a0a66a-868e-70d0-a485-88a09590c550 | ZS | 2026-09-15 14:53 | call_diagonal_spread | 2 | 4 | 9 | 115437.00 | short | bid | 194.2650 | 6.0500 | ["200","230"] | ["0.6055","0.5920"] | [] | ["EMLD","SPHR","XBOX","XMIO"] | 200.0000 | 230.0000 | 640 | 857 | false | true | true | ||||||||||
| 01a0a66a-868e-70d0-a485-889f55af0223 | ZS | 2026-09-15 14:53 | call_diagonal_spread | 2 | 7 | 14 | 180342.00 | short | bid | 194.2650 | 6.0500 | ["200","230"] | ["0.6085","0.5945"] | [] | ["EMLD","SPHR","XBOX","XMIO"] | 200.0000 | 230.0000 | 640 | 857 | false | true | true | ||||||||||
| 01a0a66a-868e-70d0-a485-888894de23eb | ZS | 2026-09-15 14:53 | call_diagonal_spread | 2 | 7 | 11 | 140993.00 | short | bid | 194.2650 | 6.0500 | ["200","230"] | ["0.6050","0.5916"] | [] | ["EMLD","SPHR","XBOX","XMIO"] | 200.0000 | 230.0000 | 640 | 857 | false | true | true | ||||||||||
| 01a0a66a-868e-70d0-a485-8854c5da5f8f | ZS | 2026-09-15 14:53 | call_diagonal_spread | 2 | 1 | 10 | 129010.00 | short | bid | 194.2650 | 6.4500 | ["200","230"] | ["0.6095","0.5953"] | [] | ["XPHO"] | 200.0000 | 230.0000 | 640 | 857 | false | true | true | ||||||||||
| 01a0a0c9-13a0-7f13-9cd7-15dcbbb1f193 | ZS | 2026-09-14 12:38 | call_diagonal_spread | 2 | 2 | 38 | 184737.00 | unknown | — | 188.6569 | 1.9000 | ["195","200"] | ["0.5879","0.5699"] | [] | ["ARCO","XPHO"] | 195.0000 | 200.0000 | 123 | 158 | false | true | true | true | false | ||||||||
| 01a08bb1-24d0-7963-a3e2-86ac37bd9f70 | ZS | 2026-09-10 10:20 | call_diagonal_spread | 2 | 1 | 90 | 230400.00 | long | ask | 166.1450 | 1.7000 | ["175","185"] | ["0.5186","0.5802"] | [] | ["ARCO"] | 175.0000 | 185.0000 | 71 | 99 | false | true | true | ||||||||||
| 01a08282-4880-72f1-bc56-58401ae1ff6e | ZS | 2026-09-08 15:32 | call_diagonal_spread | 2 | 3 | 60 | 507260.00 | long | ask | 162.8050 | 2.4500 | ["180","200"] | ["0.5885","0.5947"] | [] | ["EDGO","XCBO","XPHO"] | 180.0000 | 200.0000 | 500 | 647 | false | true | true | ||||||||||
| 01a081d7-4b10-77b0-bc29-79bf87d3a496 | ZS | 2026-09-08 12:26 | call_diagonal_spread | 2 | 2 | 100 | 807760.00 | short | ask | 163.2796 | 4.1500 | ["180","210"] | ["0.5771","0.5839"] | [] | ["XISX","XMIO"] | 180.0000 | 210.0000 | 500 | 647 | false | true | true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:26:57Z"} |
| 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:36:50Z"} |
| 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:36:50Z"} |
| 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:36:50Z"} |
| 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:29:40Z"} |
| 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-21T14:46:14Z"} |
| 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-21T14:31:49Z"} |
| 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-16T16:58:25Z"} |
| 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:58:18Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:58:26Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:53:17Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:53:17Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:53:17Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:53:17Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:53:17Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:39:14Z"} |
| 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-10T14:20:47Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:33:11Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:26:35Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |