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 |
|---|
| 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 |
|---|
| 01a0caba-9547-7253-b472-a5c7ebcbc9bb | DIA | 2026-09-22 16:06 | call_ratio_spread | 2 | 1 | 40 | 37300.00 | unknown | ask | 518.0300 | 0.5000 | ["517","527"] | ["0.1325","0.1261"] | ["529.88"] | ["XISX"] | 517.0000 | 527.0000 | 31 | 31 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T20:08:31Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0ca9f-29bf-7312-a50e-40b008edaf87 | DIA | 2026-09-22 15:37 | call_vertical_spread | 2 | 1 | 38 | 144400.00 | short | bid | 518.9250 | 3.1500 | ["515","560"] | ["0.1397","0.1280"] | ["535.70"] | ["C2OX"] | 515.0000 | 560.0000 | 190 | 190 | false | false | |||||||||||
| 01a0c586-db67-7af3-9d52-1fd3751a19aa | DIA | 2026-09-21 15:52 | put_vertical_spread | 2 | 1 | 30 | 25650.00 | unknown | ask | 519.8600 | 0.5000 | ["495","500"] | ["0.1662","0.1596"] | ["493.22"] | ["XISX"] | 495.0000 | 500.0000 | 60 | 60 | false | true | |||||||||||
| 01a0c445-eb3e-79a1-88d8-a22ecda5a5bc | DIA | 2026-09-21 10:01 | call_calendar | 2 | 1 | 100 | 497000.00 | short | bid | 517.2500 | 2.2000 | ["535"] | ["0.1390"] | [] | ["XISX"] | 535.0000 | 535.0000 | 269 | 282 | false | true | |||||||||||
| 01a0c445-8d7e-72e1-8ddf-4505f9628adc | DIA | 2026-09-21 10:01 | call_calendar | 2 | 1 | 20 | 99600.00 | short | bid | 517.2550 | 2.2000 | ["535"] | ["0.1393"] | [] | ["XISX"] | 535.0000 | 535.0000 | 269 | 282 | false | true | |||||||||||
| 01a0b54e-7e67-7560-8f9d-5326053b5fb5 | DIA | 2026-09-18 12:16 | call_calendar | 2 | 1 | 60 | 284400.00 | short | bid | 514.6500 | 5.6000 | ["535"] | ["0.1392"] | [] | ["XISX"] | 535.0000 | 535.0000 | 272 | 285 | false | true | |||||||||||
| 01a0b54e-3817-73f2-86aa-87dfa2da4835 | DIA | 2026-09-18 12:16 | call_calendar | 2 | 1 | 20 | 94800.00 | short | bid | 514.6700 | 3.7500 | ["535"] | ["0.1392"] | [] | ["XISX"] | 535.0000 | 535.0000 | 272 | 285 | false | true | |||||||||||
| 01a0b078-7913-7470-a111-f583cde19c54 | DIA | 2026-09-17 13:44 | call_diagonal_spread | 2 | 1 | 5 | 50925.00 | short | ask | 518.4500 | 4.0000 | ["455","500"] | ["0.9980","0.1423"] | [] | ["XCBO"] | 455.0000 | 500.0000 | 1 | 183 | false | false | |||||||||||
| 01a0afb2-94eb-7d52-840a-04a6cb8950db | DIA | 2026-09-17 10:08 | put_calendar | 2 | 2 | 10 | 28130.00 | long | bid | 516.6200 | 0.9000 | ["525"] | ["0.2673"] | [] | ["XCBO"] | 525.0000 | 525.0000 | 1 | 120 | false | false | true | ||||||||||
| 01a0afa3-7da3-7153-8217-f0bb7b292cb8 | DIA | 2026-09-17 09:52 | call_calendar | 2 | 1 | 10 | 37100.00 | unknown | — | 518.0200 | 0.4500 | ["500"] | ["0.1120"] | [] | ["XISX"] | 500.0000 | 500.0000 | 8 | 13 | false | false | true | false | false | ||||||||
| 01a0a59e-f15d-7de1-906f-6781e8798c55 | DIA | 2026-09-15 11:10 | iron_condor | 4 | 1 | 125 | 83250.00 | unknown | — | 519.2468 | 0.4900 | ["490","495","541","546"] | ["0.1960","0.1862","0.1184","0.1196"] | [] | ["XISX"] | 490.0000 | 546.0000 | 31 | 31 | false | true | false | true | |||||||||
| 01a0a0f4-9070-7523-b574-1105a52ec90d | DIA | 2026-09-14 13:26 | other | 2 | 2 | 16 | 41280.00 | unknown | — | 525.0000 | 0.7000 | ["525","538"] | ["0.1405","0.1438"] | [] | ["MCRY","XPHO"] | 525.0000 | 538.0000 | 32 | 67 | false | false | true | true | false | ||||||||
| 01a091e1-8660-7c32-b2d3-63bec5ab3ed9 | DIA | 2026-09-11 15:11 | other | 2 | 2 | 2 | 51990.00 | unknown | — | 525.7500 | 1.7500 | ["400"] | ["0.3640"] | [] | ["XPHO"] | 400.0000 | 400.0000 | 7 | 189 | false | false | true | false | false | ||||||||
| 01a08c27-5a88-7100-92fe-007f029a7726 | DIA | 2026-09-10 12:29 | other | 2 | 1 | 25 | 76000.00 | unknown | — | 520.7900 | 0.6000 | ["530","535"] | ["0.1710","0.1509"] | [] | ["XISX"] | 530.0000 | 535.0000 | 8 | 71 | false | false | true | true | false | ||||||||
| 01a08ba6-7670-7663-a640-0fd02f01168c | DIA | 2026-09-10 10:08 | call_vertical_spread | 2 | 1 | 25 | 81000.00 | unknown | — | 520.4900 | 0.8500 | ["508","518"] | ["0.1521","0.1420"] | [] | ["XPHO"] | 508.0000 | 518.0000 | 43 | 43 | true | false | false | true | |||||||||
| 01a086a3-e680-7642-accc-61a1130d38d8 | DIA | 2026-09-09 10:48 | call_vertical_spread | 2 | 1 | 458 | 46258.00 | short | bid | 524.7300 | 0.0750 | ["537","539"] | ["0.1201","0.1224"] | ["537.17"] | ["XCBO"] | 537.0000 | 539.0000 | 9 | 9 | false | true | |||||||||||
| 01a086a0-6028-79f3-8eef-1791aac50b45 | DIA | 2026-09-09 10:44 | other | 4 | 1 | 28 | 45832.00 | unknown | — | 524.7900 | 0.6900 | ["524","525","528","529"] | ["0.1558","0.1548","0.1386","0.1394"] | [] | ["C2OX"] | 524.0000 | 529.0000 | 2 | 21 | false | false | true | true | |||||||||
| 01a081cd-d148-7dd2-93a3-2dee677db45c | DIA | 2026-09-08 12:15 | iron_condor | 4 | 1 | 125 | 82500.00 | short | bid | 528.1250 | 0.3800 | ["500","505","552","557"] | ["0.1659","0.1575","0.1152","0.1172"] | ["504.04","552.96"] | ["XISX"] | 500.0000 | 557.0000 | 38 | 38 | false | true | |||||||||||
| 01a08154-d889-7af3-9533-547f6aba48ca | DIA | 2026-09-08 10:03 | other | 2 | 1 | 9 | 49680.00 | unknown | — | 528.2300 | 1.0500 | ["500","505"] | ["0.3205","0.1324"] | [] | ["XISX"] | 500.0000 | 505.0000 | 3 | 38 | false | false | true | true | false | ||||||||
| 01a06dd0-c8bd-7183-9433-5206313c58d5 | DIA | 2026-09-04 15:06 | call_diagonal_spread_bearish | 2 | 1 | 6 | 26700.00 | short | ask | 533.8400 | 0.6500 | ["510","530"] | ["0.1216","0.1265"] | [] | ["XISX"] | 510.0000 | 530.0000 | 14 | 105 | false | false |
| true |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:37:23Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:52:30Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:02:06Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:01:34Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:17:09Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:17:09Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:45:18Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:08:29Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:52:03Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:10:55Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:26:39Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:11:28Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T16:30:16Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:09:05Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:48:09Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:44:22Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| true |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:16:16Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:03:45Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:06:36Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |