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 |
|---|
| 01a0ca3f-8d30-7801-ba8f-266cdc593c91 | DIA | 2026-09-22 13:52 | call_diagonal_spread | 2 | 1 | 2500 | 827500.00 | short | bid | 517.8100 | 0.2600 | ["545","550"] | ["0.1300","0.1282"] | [] | ["XMIO"] | 545.0000 | 550.0000 | 24 | 59 | false | true | true | true | 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 |
| 01a0c9e3-c8ff-7d73-80a3-118a6b113fcd | DIA | 2026-09-22 12:12 | call_diagonal_spread | 2 | 2 | 20 | 125860.00 | short | bid | 517.2500 | 1.6500 | ["470","512"] | ["0.1723","0.1538"] | [] | ["XISX"] | 470.0000 | 512.0000 | 3 | 115 | false | false | true | ||||||||||
| 01a0c9ce-8797-70b1-8e69-51972018ca56 | DIA | 2026-09-22 11:49 | call_diagonal_spread | 2 | 1 | 10 | 92350.00 | long | ask | 516.7050 | 8.6000 | ["480","520"] | ["0.1755","0.1448"] | [] | ["XCBO"] | 480.0000 | 520.0000 | 87 | 451 | false | false | true | ||||||||||
| 01a0c9a6-335e-7ea0-bd77-ede3ce56d774 | DIA | 2026-09-22 11:05 | call_diagonal_spread | 2 | 1 | 4 | 34820.00 | short | bid | 517.6200 | 8.4500 | ["490","520"] | ["0.1749","0.1354"] | [] | ["XISX"] | 490.0000 | 520.0000 | 115 | 451 | false | false | true | ||||||||||
| 01a0c999-90ff-7413-a100-cbb8a6b8aabb | DIA | 2026-09-22 10:51 | call_diagonal_spread | 2 | 1 | 4 | 26860.00 | long | ask | 517.5900 | 3.4500 | ["520","535"] | ["0.1379","0.1425"] | [] | ["XISX"] | 520.0000 | 535.0000 | 190 | 486 | false | true | true | ||||||||||
| 01a0c97a-398f-78d3-bb52-63aa1860e36c | DIA | 2026-09-22 10:17 | call_diagonal_spread | 2 | 1 | 14 | 81130.00 | short | ask | 517.8900 | 4.9000 | ["500","530"] | ["0.1640","0.1438"] | [] | ["XISX"] | 500.0000 | 530.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c4c3-b65f-7463-bc49-b428e8821561 | DIA | 2026-09-21 12:19 | call_diagonal_spread | 2 | 1 | 10 | 152150.00 | short | bid | 518.9800 | 7.8500 | ["450","455"] | ["0.2171","0.1841"] | [] | ["XISX"] | 450.0000 | 455.0000 | 88 | 179 | false | 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 | true | ||||||||||
| 01a0b06a-cd13-7a93-bc0a-ec3f819e44ac | DIA | 2026-09-17 13:29 | call_diagonal_spread | 2 | 1 | 3 | 32475.00 | long | bid | 518.2288 | 2.0000 | ["450","490"] | ["1.1157","0.1498"] | [] | ["XMIO"] | 450.0000 | 490.0000 | 1 | 120 | false | false | true | ||||||||||
| 01a0b05e-ab9b-7830-ae56-18f2e653d8ac | DIA | 2026-09-17 13:16 | call_diagonal_spread | 2 | 1 | 6 | 54372.00 | short | ask | 518.4000 | 3.5500 | ["460","500"] | ["1.0160","0.1417"] | [] | ["ARCO"] | 460.0000 | 500.0000 | 1 | 120 | false | false | true | ||||||||||
| 01a0aff9-ac23-7e81-9551-49a89676573b | DIA | 2026-09-17 11:26 | call_diagonal_spread | 2 | 1 | 2 | 31124.00 | unknown | — | 517.9700 | 2.0000 | ["440","445"] | ["1.3675","0.1889"] | [] | ["XISX"] | 440.0000 | 445.0000 | 1 | 92 | false | false | true | true | false | ||||||||
| 01a0abbf-9c53-7942-9825-4a05a1a55266 | DIA | 2026-09-16 15:44 | call_diagonal_spread | 2 | 2 | 20 | 61470.00 | unknown | — | 513.8000 | 1.3750 | ["500","517"] | ["0.1497","0.1579"] | [] | ["XISX"] | 500.0000 | 517.0000 | 2 | 121 | false | false | true | true | false | ||||||||
| 01a0ab5a-fa9b-7023-b6b0-d7ae2077ec4f | DIA | 2026-09-16 13:54 | call_diagonal_spread | 2 | 2 | 26 | 29484.00 | long | bid | 521.6600 | 0.4000 | ["516","521"] | ["0.1835","0.1269"] | [] | ["EMLD","XMIO"] | 516.0000 | 521.0000 | 2 | 9 | false | false | true | ||||||||||
| 01a0ab5a-f6b3-7363-b927-b32b9b43fda4 | DIA | 2026-09-16 13:54 | call_diagonal_spread | 2 | 1 | 52 | 66300.00 | short | ask | 521.6450 | 0.3000 | ["515","520"] | ["0.1862","0.1280"] | [] | ["XISX"] | 515.0000 | 520.0000 | 2 | 9 | false | false | true | ||||||||||
| 01a0ab1a-57ba-7440-bdad-c2c5a4a4999d | DIA | 2026-09-16 12:43 | call_diagonal_spread | 2 | 1 | 2 | 25280.00 | long | ask | 520.9800 | 9.2000 | ["520","535"] | ["0.1419","0.1400"] | [] | ["XMIO"] | 520.0000 | 535.0000 | 639 | 821 | false | false | true | ||||||||||
| 01a0aaee-9884-7b33-af19-62c061326fdd | DIA | 2026-09-16 11:55 | call_diagonal_spread | 2 | 1 | 4 | 27768.00 | long | ask | 521.6162 | 8.2000 | ["525","530"] | ["0.1346","0.1420"] | [] | ["XISX"] | 525.0000 | 530.0000 | 196 | 457 | false | true | true | ||||||||||
| 01a0aaae-72a3-7770-87e2-908ee8a436b2 | DIA | 2026-09-16 10:45 | call_diagonal_spread | 2 | 1 | 75 | 1332150.00 | long | bid | 520.6650 | 4.3500 | ["370","499"] | ["1.9700","0.1536"] | [] | ["SPHR"] | 370.0000 | 499.0000 | 2 | 44 | true | false | true | ||||||||||
| 01a0aaa6-6424-7311-9a51-358b74657be4 | DIA | 2026-09-16 10:37 | call_diagonal_spread | 2 | 1 | 5 | 41005.00 | short | bid | 520.0900 | 1.9000 | ["480","490"] | ["0.4541","0.1524"] | [] | ["AMXO"] | 480.0000 | 490.0000 | 2 | 121 | false | false | true | ||||||||||
| 01a0aaa6-603b-74b3-8f71-b78c80764a43 | DIA | 2026-09-16 10:37 | call_diagonal_spread | 2 | 1 | 5 | 41075.00 | short | bid | 520.0900 | 2.1000 | ["480","490"] | ["0.5064","0.1534"] | [] | ["BATO"] | 480.0000 | 490.0000 | 2 | 121 | false | false | true | ||||||||||
| 01a0aaa6-603b-74b3-8f71-b774a24c96a2 | DIA | 2026-09-16 10:37 | call_diagonal_spread | 2 | 1 | 5 | 41075.00 | short | bid | 520.0900 | 3.1000 | ["480","490"] | ["0.5064","0.1534"] | [] | ["EMLD"] | 480.0000 | 490.0000 | 2 | 121 | false | false | true | ||||||||||
| 01a0aa8c-e0e3-76b0-89d5-3f33acf6b2d3 | DIA | 2026-09-16 10:09 | call_diagonal_spread | 2 | 1 | 4 | 58192.00 | short | bid | 520.2050 | 4.1500 | ["450","465"] | ["0.8769","0.1565"] | [] | ["ARCO"] | 450.0000 | 465.0000 | 2 | 274 | false | false | true | ||||||||||
| 01a0aa8a-354b-7330-8569-95f9e86ed8f9 | DIA | 2026-09-16 10:06 | call_diagonal_spread | 2 | 1 | 5 | 72540.00 | short | ask | 520.3500 | 2.4000 | ["440","470"] | ["0.9506","0.1603"] | [] | ["XCBO"] | 440.0000 | 470.0000 | 2 | 184 | false | false | true | ||||||||||
| 01a0a5ff-35e6-79b0-95c9-a748fc0646c2 | DIA | 2026-09-15 12:55 | call_diagonal_spread | 2 | 1 | 2 | 34650.00 | long | ask | 521.0000 | 3.6000 | ["435","440"] | ["0.8423","0.1897"] | [] | ["XMIO"] | 435.0000 | 440.0000 | 3 | 122 | false | false | true | ||||||||||
| 01a0a5de-4836-7bb1-bd65-5458ad2d4405 | DIA | 2026-09-15 12:20 | call_diagonal_spread | 2 | 1 | 2 | 34168.00 | unknown | — | 519.7300 | 2.9500 | ["435","440"] | ["0.8007","0.1862"] | [] | ["XISX"] | 435.0000 | 440.0000 | 3 | 122 | false | false | true | true | false | ||||||||
| 01a0a5d7-3f6e-77c3-a3fa-0175f4b911d5 | DIA | 2026-09-15 12:12 | call_diagonal_spread | 2 | 2 | 4 | 68508.00 | unknown | — | 519.6407 | 1.7500 | ["435","440"] | ["0.7835","0.2006"] | [] | ["AMXO","XISX"] | 435.0000 | 440.0000 | 3 | 122 | false | false | true | true | false | ||||||||
| 01a0a572-3c0e-7060-be2f-47e22ac612b0 | DIA | 2026-09-15 10:21 | call_diagonal_spread | 2 | 1 | 6 | 86124.00 | unknown | — | 519.6900 | 3.0500 | ["440","470"] | ["0.7920","0.1769"] | [] | ["XISX"] | 440.0000 | 470.0000 | 3 | 185 | false | false | true | true | false | ||||||||
| 01a0a03c-c5a9-7e01-95cc-e9c333f4a237 | DIA | 2026-09-14 10:05 | call_diagonal_spread | 2 | 1 | 5 | 47145.00 | short | ask | 525.0000 | 6.2000 | ["470","530"] | ["0.2130","0.1341"] | [] | ["XISX"] | 470.0000 | 530.0000 | 95 | 276 | false | false | true | ||||||||||
| 01a09196-4c90-7783-b271-152d6249ae8b | DIA | 2026-09-11 13:48 | call_diagonal_spread | 2 | 1 | 10 | 46250.00 | long | ask | 526.5850 | 4.2000 | ["525","530"] | ["0.1482","0.1339"] | [] | ["ARCO"] | 525.0000 | 530.0000 | 126 | 189 | false | false | true | ||||||||||
| 01a08b90-cb90-7700-b523-1560904da581 | DIA | 2026-09-10 09:45 | call_diagonal_spread | 2 | 1 | 3 | 54528.00 | short | ask | 522.1600 | 9.3000 | ["460","500"] | ["0.1482","0.1478"] | [] | ["XPHO"] | 460.0000 | 500.0000 | 498 | 827 | false | false | true | ||||||||||
| 01a08154-eff8-7a22-a572-61b218444057 | DIA | 2026-09-08 10:03 | call_diagonal_spread | 2 | 1 | 102 | 657492.00 | short | ask | 528.1500 | 1.0000 | ["495","500"] | ["0.3530","0.1328"] | [] | ["XMIO"] | 495.0000 | 500.0000 | 3 | 38 | false | false | true | ||||||||||
| 01a08154-e441-7f43-b61b-3ed28a14fe56 | DIA | 2026-09-08 10:03 | call_diagonal_spread | 2 | 1 | 6 | 38748.00 | short | ask | 528.1900 | 1.0500 | ["495","500"] | ["0.3615","0.1337"] | [] | ["XMIO"] | 495.0000 | 500.0000 | 3 | 38 | false | false | true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:12:30Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:49:42Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| tracked |
| 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 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:51:21Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:17:24Z"} |
| 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:19:50Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| 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 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:30:09Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:16:54Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:26:24Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:44:30Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:55:02Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:55:02Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:43:46Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:56:33Z"} |
| 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-16T14:46:26Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:37:43Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:37:43Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:37:43Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:09:26Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:06:30Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:56:14Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:20:34Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:12:30Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:22:06Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:05:53Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T17:49:38Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T13:45:22Z"} |
| 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-08T14:03:45Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| 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 |