core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg473,794 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 |
|---|
| 01a0d47f-0a77-7fd2-825e-cfaa1967cf42 | CAT | 2026-09-24 13:38 | call_diagonal_spread | 2 | 1 | 6 | 186204.00 | short | ask | 803.9800 | 10.9250 | ["525","797.5"] | ["1.8133","0.3434"] | [] | ["MCRY"] | 525.0000 | 797.5000 | 8 | 22 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T17:38:09Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0c493-096e-7f20-8a2c-6c9d3c5d1516 | CAT | 2026-09-21 11:26 | call_diagonal_spread | 2 | 3 | 7 | 33814.00 | short | bid | 820.0500 | 2.0000 | ["840","900"] | ["0.3500","0.3998"] | [] | ["ARCO","EMLD","SPHR"] | 840.0000 | 900.0000 | 25 | 60 | false | true | true | ||||||||||
| 01a0c484-cce6-77d1-b953-e8cced9e8e10 | CAT | 2026-09-21 11:10 | call_diagonal_spread | 2 | 1 | 50 | 424000.00 | short | bid | 818.8900 | 5.5740 | ["800","850"] | ["0.3642","0.4031"] | [] | ["XPHO"] | 800.0000 | 850.0000 | 25 | 60 | false | false | true | ||||||||||
| 01a0c437-7fd7-78c2-a29a-70102eb59d64 | CAT | 2026-09-21 09:46 | call_diagonal_spread | 2 | 1 | 11 | 114356.00 | short | bid | 806.6150 | 14.3000 | ["760","770"] | ["0.5239","0.3761"] | [] | ["XMIO"] | 760.0000 | 770.0000 | 4 | 25 | false | false | true | ||||||||||
| 01a0c42a-6076-7bc1-b9cd-34f041f2a9e4 | CAT | 2026-09-21 09:31 | call_diagonal_spread | 2 | 1 | 3 | 35208.00 | short | bid | 816.9400 | 22.5000 | ["780","810"] | ["0.4073","0.4123"] | [] | ["SPHR"] | 780.0000 | 810.0000 | 25 | 60 | false | false | true | ||||||||||
| 01a0b4ff-9b17-71e0-8424-2985e727d2a4 | CAT | 2026-09-18 10:50 | call_diagonal_spread | 2 | 1 | 2 | 152546.00 | short | bid | 805.0850 | 25.8500 | ["430","440"] | ["0.3794","0.3965"] | [] | ["XCBO"] | 430.0000 | 440.0000 | 119 | 272 | false | false | true | ||||||||||
| 01a0b055-c643-72a2-9f37-daddbcb2c945 | CAT | 2026-09-17 13:06 | call_diagonal_spread | 2 | 1 | 4 | 311360.00 | short | ask | 799.1000 | 19.2000 | ["440","450"] | ["0.3901","0.3971"] | [] | ["XISX"] | 440.0000 | 450.0000 | 456 | 491 | false | false | true | ||||||||||
| 01a0afbe-5c8b-7ec3-82b2-6061f8fc5a28 | CAT | 2026-09-17 10:21 | call_diagonal_spread | 2 | 3 | 80 | 33840.00 | short | bid | 803.8700 | 2.8800 | ["1040","1060"] | ["0.4539","0.4365"] | [] | ["ARCO","EMLD","XMIO"] | 1040.0000 | 1060.0000 | 36 | 43 | true | true | true | ||||||||||
| 01a0afad-93ab-7072-8f75-aa34db36ea56 | CAT | 2026-09-17 10:03 | call_diagonal_spread | 2 | 1 | 20 | 127060.00 | short | bid | 798.4580 | 12.3000 | ["770","775"] | ["0.4089","0.6720"] | [] | ["ARCO"] | 770.0000 | 775.0000 | 1 | 8 | false | false | true | ||||||||||
| 01a0afad-8fc4-71f0-9ddd-0cc110916504 | CAT | 2026-09-17 10:02 | call_diagonal_spread | 2 | 1 | 40 | 254560.00 | short | bid | 798.4580 | 13.3000 | ["770","775"] | ["0.4149","0.6615"] | [] | ["ARCO"] | 770.0000 | 775.0000 | 1 | 8 | false | false | true | ||||||||||
| 01a0afad-8fc4-71f0-9ddd-0cb4d2752509 | CAT | 2026-09-17 10:02 | call_diagonal_spread | 2 | 2 | 34 | 217787.00 | short | bid | 798.4580 | 13.3250 | ["770","775"] | ["0.4180","0.6871"] | [] | ["ARCO","XPHO"] | 770.0000 | 775.0000 | 1 | 8 | true | false | true | ||||||||||
| 01a0afa0-60c3-7540-a986-b1c177e7fe05 | CAT | 2026-09-17 09:48 | call_diagonal_spread | 2 | 1 | 8 | 189922.00 | short | bid | 803.9100 | 9.9375 | ["870","900"] | ["0.3987","0.3910"] | [] | ["MCRY"] | 870.0000 | 900.0000 | 365 | 456 | false | true | true | ||||||||||
| 01a0afa0-60c3-7540-a986-b1bdc531f6e5 | CAT | 2026-09-17 09:48 | call_diagonal_spread | 2 | 1 | 2 | 47584.00 | short | bid | 803.9100 | 11.0500 | ["870","900"] | ["0.3995","0.3918"] | [] | ["EMLD"] | 870.0000 | 900.0000 | 365 | 456 | false | true | true | ||||||||||
| 01a0ab79-a243-7fe2-adb2-2492b491b310 | CAT | 2026-09-16 14:27 | call_diagonal_spread | 2 | 1 | 5 | 45015.00 | short | bid | 787.5900 | 7.0800 | ["710","885"] | ["0.3947","0.3858"] | [] | ["ARCO"] | 710.0000 | 885.0000 | 16 | 30 | false | false | true | ||||||||||
| 01a0ab79-9a73-7420-b382-f0f283a85cc1 | CAT | 2026-09-16 14:27 | call_diagonal_spread | 2 | 1 | 5 | 44545.00 | short | bid | 787.5900 | 7.8100 | ["710","885"] | ["0.3877","0.3622"] | [] | ["EDGO"] | 710.0000 | 885.0000 | 16 | 30 | false | false | true | ||||||||||
| 01a0ab79-9a73-7420-b382-f0e400bce23a | CAT | 2026-09-16 14:27 | call_diagonal_spread | 2 | 2 | 10 | 90500.00 | short | bid | 787.5900 | 6.7250 | ["710","885"] | ["0.3998","0.3920"] | [] | ["ARCO","XPHO"] | 710.0000 | 885.0000 | 16 | 30 | false | false | true | ||||||||||
| 01a0ab79-8ebb-77e2-868d-e3502820e7cb | CAT | 2026-09-16 14:27 | call_diagonal_spread | 2 | 1 | 5 | 46105.00 | short | bid | 787.5900 | 12.7000 | ["710","885"] | ["0.4194","0.4152"] | [] | ["ARCO"] | 710.0000 | 885.0000 | 16 | 30 | false | false | true | ||||||||||
| 01a0a5a3-3b06-7320-b657-26122dfa2c8e | CAT | 2026-09-15 11:15 | call_diagonal_spread | 2 | 1 | 3 | 66666.00 | short | bid | 779.2667 | 35.9000 | ["920","980"] | ["0.4081","0.3924"] | [] | ["ARCO"] | 920.0000 | 980.0000 | 458 | 640 | false | true | true | ||||||||||
| 01a0a56a-21d6-7512-8a93-c196cae311cb | CAT | 2026-09-15 10:13 | call_diagonal_spread | 2 | 1 | 2 | 75916.00 | short | ask | 783.2400 | 19.4500 | ["600","660"] | ["0.4431","0.4259"] | [] | ["XMIO"] | 600.0000 | 660.0000 | 157 | 185 | false | false | true | ||||||||||
| 01a0a546-9c15-7c10-bd1f-9ac1a946a35f | CAT | 2026-09-15 09:34 | call_diagonal_spread | 2 | 1 | 2 | 136502.00 | short | bid | 788.6600 | 33.3500 | ["500","510"] | ["0.3979","0.4308"] | [] | ["XISX"] | 500.0000 | 510.0000 | 493 | 640 | false | false | true | ||||||||||
| 01a0a16f-fe19-7921-8f69-13537cfc9006 | CAT | 2026-09-14 15:41 | call_diagonal_spread | 2 | 2 | 11 | 117830.00 | short | bid | 784.5400 | 6.9000 | ["740","800"] | ["0.4760","0.3989"] | [] | ["MCRY","XMIO"] | 740.0000 | 800.0000 | 4 | 95 | false | false | true | ||||||||||
| 01a0a162-7158-7623-9a43-fed49c4ddbbf | CAT | 2026-09-14 15:26 | call_diagonal_spread | 2 | 1 | 4 | 324668.00 | short | bid | 786.9950 | 27.4000 | ["410","420"] | ["0.3530","0.4208"] | [] | ["XCBO"] | 410.0000 | 420.0000 | 459 | 641 | false | false | true | ||||||||||
| 01a0a14f-9538-79d3-b79a-4abeb2375044 | CAT | 2026-09-14 15:05 | call_diagonal_spread | 2 | 1 | 3 | 211464.00 | short | bid | 788.2350 | 27.6500 | ["460","490"] | ["0.4187","0.4159"] | [] | ["ARCO"] | 460.0000 | 490.0000 | 276 | 641 | false | false | true | ||||||||||
| 01a0a149-6730-7a10-a91d-b73ae13564cd | CAT | 2026-09-14 14:58 | call_diagonal_spread | 2 | 1 | 3 | 211548.00 | short | bid | 788.2800 | 28.9000 | ["460","470"] | ["0.4364","0.3553"] | [] | ["XMIO"] | 460.0000 | 470.0000 | 276 | 494 | false | false | true | ||||||||||
| 01a0a134-6c18-7372-919e-61336cb2a498 | CAT | 2026-09-14 14:36 | call_diagonal_spread | 2 | 1 | 2 | 35586.00 | short | bid | 787.5100 | 8.3500 | ["700","730"] | ["0.4248","0.4118"] | [] | ["XMIO"] | 700.0000 | 730.0000 | 4 | 67 | false | false | true | ||||||||||
| 01a0a122-10e0-7aa3-bd72-b591e450fe1d | CAT | 2026-09-14 14:15 | call_diagonal_spread | 2 | 3 | 23 | 46912.00 | short | bid | 787.5200 | 1.9800 | ["880","900"] | ["0.4876","0.4091"] | [] | ["ARCO","XPHO"] | 880.0000 | 900.0000 | 4 | 67 | false | true | true | ||||||||||
| 01a091fb-9640-7b83-9d24-c777698a0742 | CAT | 2026-09-11 15:39 | call_diagonal_spread | 2 | 1 | 2 | 34626.00 | short | bid | 819.7889 | 9.5000 | ["700","800"] | ["0.4044","0.3418"] | [] | ["XISX"] | 700.0000 | 800.0000 | 7 | 98 | false | false | true | ||||||||||
| 01a08c56-f609-7910-8f40-8f13d39ea338 | CAT | 2026-09-10 13:21 | call_diagonal_spread | 2 | 1 | 4 | 46480.00 | short | bid | 802.2750 | 5.8500 | ["770","830"] | ["0.3803","0.4011"] | [] | ["ARCO"] | 770.0000 | 830.0000 | 36 | 99 | false | false | true | ||||||||||
| 01a08b97-c8a1-7682-8932-ac0021886d8d | CAT | 2026-09-10 09:52 | call_diagonal_spread | 2 | 1 | 4 | 32896.00 | short | ask | 801.0400 | 19.4500 | ["780","820"] | ["0.4144","0.4047"] | [] | ["MCRY"] | 780.0000 | 820.0000 | 22 | 43 | false | false | true | ||||||||||
| 01a086d8-d160-7163-b80d-02bd22f3d65b | CAT | 2026-09-09 11:45 | call_diagonal_spread | 2 | 1 | 4 | 230528.00 | short | bid | 816.5150 | 20.3500 | ["540","600"] | ["0.4601","0.4292"] | [] | ["XMIO"] | 540.0000 | 600.0000 | 100 | 464 | false | false | true | ||||||||||
| 01a08268-b1b9-7f72-9202-b9d5ae4943e1 | CAT | 2026-09-08 15:04 | call_diagonal_spread | 2 | 1 | 8 | 498976.00 | short | ask | 825.2950 | 25.6500 | ["410","700"] | ["0.4315","0.4211"] | [] | ["XPHO"] | 410.0000 | 700.0000 | 192 | 282 | false | false | true | ||||||||||
| 01a08263-8580-76f2-a0b4-3b95f103d599 | CAT | 2026-09-08 14:59 | call_diagonal_spread | 2 | 1 | 4 | 37600.00 | short | bid | 826.4700 | 10.3000 | ["790","820"] | ["0.4069","0.3771"] | [] | ["XISX"] | 790.0000 | 820.0000 | 10 | 45 | false | false | true | ||||||||||
| 01a081da-f879-71a1-99fb-db084ebd55de | CAT | 2026-09-08 12:30 | call_diagonal_spread | 2 | 1 | 6 | 37716.00 | short | ask | 826.4950 | 5.6000 | ["840","870"] | ["0.3756","0.3754"] | [] | ["XISX"] | 840.0000 | 870.0000 | 38 | 45 | false | true | true | ||||||||||
| 01a081b8-0728-7d82-8a3b-476898d6fb9e | CAT | 2026-09-08 11:51 | call_diagonal_spread | 2 | 1 | 3 | 48354.00 | short | bid | 827.6700 | 11.6500 | ["720","840"] | ["0.3926","0.3877"] | [] | ["XMIO"] | 720.0000 | 840.0000 | 10 | 129 | false | false | true | ||||||||||
| 01a0813e-d3d0-70d2-b293-b23891a020c4 | CAT | 2026-09-08 09:39 | call_diagonal_spread | 2 | 1 | 4 | 74416.00 | short | ask | 827.7100 | 18.1500 | ["850","920"] | ["0.4011","0.4043"] | [] | ["XCBO"] | 850.0000 | 920.0000 | 192 | 282 | false | true | true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:26:07Z"} |
| 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-21T15:10:52Z"} |
| 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-21T13:46:05Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:31:49Z"} |
| 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-18T14:50:58Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:06:50Z"} |
| 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-17T14:21:33Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:03:13Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:03:13Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:03:13Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:48:46Z"} |
| 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-17T13:48:46Z"} |
| 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-16T18:27:53Z"} |
| 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-16T18:27:53Z"} |
| 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-16T18:27:53Z"} |
| 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-16T18:27:53Z"} |
| 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-15T15:15:56Z"} |
| 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-15T14:13:18Z"} |
| 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-15T13:34:23Z"} |
| 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-14T19:41:14Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:26:54Z"} |
| 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-14T19:05:58Z"} |
| 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-14T18:59:12Z"} |
| 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-14T18:36:11Z"} |
| 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-14T18:16:32Z"} |
| 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-11T19:39:50Z"} |
| 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-10T17:22:29Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T13:52:54Z"} |
| 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-09T15:46:13Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:05:18Z"} |
| 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-08T18:59:50Z"} |
| 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-08T16:30:34Z"} |
| 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-08T15:52:17Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:39:37Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |