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 |
|---|
| 01a0d472-6817-7d31-8fb1-4319938eac82 | CAT | 2026-09-24 13:24 | put_diagonal_spread | 2 | 1 | 5 | 35680.00 | short | bid | 805.6800 | 10.8000 | ["740","750"] | ["0.3941","0.4349"] | [] | ["XMIO"] | 740.0000 | 750.0000 | 43 | 176 | false | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T17:24:35Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0d470-0e86-73f2-b1b6-d7feb9cf3164 | CAT | 2026-09-24 13:21 | put_diagonal_spread | 2 | 1 | 2 | 83890.00 | short | ask | 806.5150 | 19.5000 | ["830","1180"] | ["0.3630","1.3562"] | [] | ["EMLD"] | 830.0000 | 1180.0000 | 8 | 29 | false | false | true | ||||||||||
| 01a0d434-3636-7033-8045-b01a41ff4864 | CAT | 2026-09-24 12:16 | put_diagonal_spread | 2 | 1 | 2 | 36152.00 | short | ask | 801.3600 | 9.3000 | ["850","860"] | ["0.3842","0.3925"] | [] | ["EMLD"] | 850.0000 | 860.0000 | 85 | 113 | false | false | true | ||||||||||
| 01a0d3a0-4b07-77f2-9ecf-e84f50f66faf | CAT | 2026-09-24 09:34 | put_diagonal_spread | 2 | 1 | 9 | 232740.00 | short | bid | 795.4000 | 36.0000 | ["770","790"] | ["0.4085","0.4465"] | [] | ["ARCO"] | 770.0000 | 790.0000 | 449 | 848 | false | true | true | ||||||||||
| 01a0cecd-00a7-7e63-ac44-dfe11d29a568 | CAT | 2026-09-23 11:05 | put_diagonal_spread | 2 | 1 | 6 | 263172.00 | short | ask | 806.5400 | 11.6500 | ["812.5","1220"] | ["0.3412","1.2054"] | [] | ["XPHO"] | 812.5000 | 1220.0000 | 9 | 16 | true | false | true | ||||||||||
| 01a0c9d6-e437-7970-9440-e1524d554148 | CAT | 2026-09-22 11:58 | put_diagonal_spread | 2 | 2 | 4 | 79984.00 | short | bid | 808.6650 | 29.8250 | ["640","760"] | ["0.4234","0.4284"] | [] | ["XISX"] | 640.0000 | 760.0000 | 633 | 850 | false | true | true | ||||||||||
| 01a0c9c8-9fde-7900-b78f-55467a16493c | CAT | 2026-09-22 11:42 | put_diagonal_spread | 2 | 1 | 8 | 55800.00 | short | bid | 805.5300 | 24.6500 | ["520","560"] | ["0.4363","0.4298"] | [] | ["XISX"] | 520.0000 | 560.0000 | 486 | 633 | false | true | true | ||||||||||
| 01a0c4e8-3237-7ab1-bf80-7f316b08a757 | CAT | 2026-09-21 12:59 | put_diagonal_spread | 2 | 1 | 6 | 82974.00 | short | ask | 819.7950 | 12.2750 | ["845","910"] | ["0.3602","0.5830"] | [] | ["XPHO"] | 845.0000 | 910.0000 | 4 | 32 | true | false | true | ||||||||||
| 01a0c4a6-1086-78a3-a3a8-6e3447379cf4 | CAT | 2026-09-21 11:46 | put_diagonal_spread | 2 | 1 | 8 | 168752.00 | short | bid | 818.8700 | 7.9500 | ["840","890"] | ["0.4002","0.4098"] | [] | ["EDGO"] | 840.0000 | 890.0000 | 88 | 269 | false | false | true | ||||||||||
| 01a0c49d-5626-7412-a27f-103c1e647e07 | CAT | 2026-09-21 11:37 | put_diagonal_spread | 2 | 1 | 2 | 42380.00 | short | bid | 818.4820 | 9.4500 | ["840","890"] | ["0.4019","0.4105"] | [] | ["ARCO"] | 840.0000 | 890.0000 | 88 | 269 | false | false | true | ||||||||||
| 01a0c464-48af-72f2-9026-7f35a55003ac | CAT | 2026-09-21 10:34 | put_diagonal_spread | 2 | 1 | 15 | 67410.00 | short | bid | 817.6700 | 2.0500 | ["760","790"] | ["0.4196","0.3562"] | [] | ["SPHR"] | 760.0000 | 790.0000 | 25 | 60 | false | true | true | ||||||||||
| 01a0c440-558e-74f1-957c-85c3823686c2 | CAT | 2026-09-21 09:55 | put_diagonal_spread | 2 | 3 | 78 | 227604.00 | short | ask | 810.4800 | 4.4500 | ["725","790"] | ["0.4449","0.3565"] | [] | ["AMXO","EDGO","XPHO"] | 725.0000 | 790.0000 | 18 | 39 | true | true | true | ||||||||||
| 01a0b554-79a8-75c3-a485-bbcf424fe885 | CAT | 2026-09-18 12:23 | put_diagonal_spread | 2 | 1 | 4 | 66952.00 | short | bid | 802.2100 | 14.6000 | ["880","885"] | ["0.3400","0.3363"] | [] | ["BATO"] | 880.0000 | 885.0000 | 14 | 35 | false | false | true | ||||||||||
| 01a0b4e5-ecdf-72b1-a882-40d061c0099d | CAT | 2026-09-18 10:22 | put_diagonal_spread | 2 | 1 | 5 | 32090.00 | short | bid | 807.2500 | 7.9000 | ["800","830"] | ["0.4246","0.8216"] | [] | ["XCBO"] | 800.0000 | 830.0000 | 0 | 42 | false | false | true | ||||||||||
| 01a0b0e4-7983-7651-8fec-95241b86be18 | CAT | 2026-09-17 15:42 | put_diagonal_spread | 2 | 1 | 6 | 28302.00 | short | bid | 796.7900 | 4.1000 | ["770","800"] | ["0.4158","0.3587"] | [] | ["XCBO"] | 770.0000 | 800.0000 | 1 | 64 | false | false | true | ||||||||||
| 01a0b0c0-4bcb-7c01-836d-2e6bea9436da | CAT | 2026-09-17 15:03 | put_diagonal_spread | 2 | 1 | 8 | 38944.00 | short | bid | 795.5850 | 10.7500 | ["812.5","820"] | ["0.3244","0.5800"] | [] | ["XMIO"] | 812.5000 | 820.0000 | 1 | 8 | false | false | true | ||||||||||
| 01a0a5b9-013e-7de2-97e5-7b53e28935bb | CAT | 2026-09-15 11:39 | put_diagonal_spread | 2 | 1 | 4 | 112800.00 | short | ask | 782.1200 | 28.8000 | ["740","800"] | ["0.4082","0.4311"] | [] | ["XMIO"] | 740.0000 | 800.0000 | 640 | 857 | false | false | true | ||||||||||
| 01a0a5b4-ee46-78c2-a6a2-d7bd1efb34b2 | CAT | 2026-09-15 11:34 | put_diagonal_spread | 2 | 1 | 2 | 34470.00 | short | bid | 781.0650 | 12.5000 | ["850","860"] | ["0.4086","0.5996"] | [] | ["EMLD"] | 850.0000 | 860.0000 | 3 | 66 | false | false | true | ||||||||||
| 01a0a0c2-4188-7971-a1e4-365ab6c121e7 | CAT | 2026-09-14 12:31 | put_diagonal_spread | 2 | 1 | 6 | 91896.00 | short | bid | 785.5600 | 5.1000 | ["780","810"] | ["0.4116","0.4023"] | [] | ["XPHO"] | 780.0000 | 810.0000 | 95 | 186 | false | false | true | ||||||||||
| 01a0a079-0771-7ec0-b506-ad5acb0451ec | CAT | 2026-09-14 11:11 | put_diagonal_spread | 2 | 1 | 5 | 27170.00 | short | bid | 782.8200 | 3.1750 | ["680","700"] | ["0.4150","0.4190"] | [] | ["XCBO"] | 680.0000 | 700.0000 | 67 | 158 | false | true | true | ||||||||||
| 01a0a038-8ba0-7041-b10a-0a029814b630 | CAT | 2026-09-14 10:00 | put_diagonal_spread | 2 | 3 | 84 | 52290.00 | short | bid | 788.1700 | 1.4700 | ["600","650"] | ["0.4532","0.4022"] | [] | ["ARCO","EDGO","XPHO"] | 600.0000 | 650.0000 | 32 | 67 | false | true | true | ||||||||||
| 01a091fe-5178-7f51-8ded-d7632fa61b4b | CAT | 2026-09-11 15:42 | put_diagonal_spread | 2 | 1 | 9 | 135675.00 | short | bid | 819.8400 | 7.4000 | ["800","810"] | ["0.4061","0.4067"] | [] | ["XCBO"] | 800.0000 | 810.0000 | 161 | 189 | false | true | true | ||||||||||
| 01a08c08-bab0-7ab1-a66f-be16bc6858d4 | CAT | 2026-09-10 11:56 | put_diagonal_spread | 2 | 2 | 5 | 28585.00 | short | bid | 804.5000 | 6.9000 | ["800","810"] | ["0.3776","0.3699"] | [] | ["ARCO","XPHO"] | 800.0000 | 810.0000 | 8 | 43 | false | false | true | ||||||||||
| 01a08157-0b08-7e50-9805-9d71e1f75e90 | CAT | 2026-09-08 10:05 | put_diagonal_spread | 2 | 1 | 4 | 119956.00 | short | bid | 822.1100 | 14.1250 | ["840","1100"] | ["0.4124","1.1578"] | [] | ["XPHO"] | 840.0000 | 1100.0000 | 3 | 10 | false | false | true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T17:22:04Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:16:26Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T13:34:58Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:05:51Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:58:55Z"} |
| 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:43:04Z"} |
| 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-21T16:59:48Z"} |
| 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:47:00Z"} |
| 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-21T15:37:24Z"} |
| 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-21T14:35:18Z"} |
| 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:55:49Z"} |
| 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-18T16:23:26Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:23:00Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:42:57Z"} |
| 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-17T19:03:06Z"} |
| 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-15T15:39:34Z"} |
| 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-15T15:35:25Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:31:37Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:11:36Z"} |
| 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-14T14:01:12Z"} |
| 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-11T19:42:57Z"} |
| 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-10T15:56:36Z"} |
| 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:06:05Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |