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 |
|---|
| 01a0c50e-9a3f-7f43-b0ad-2413346da649 | LITE | 2026-09-21 13:41 | call_diagonal_spread | 2 | 2 | 8 | 400808.00 | short | ask | 957.5400 | 23.1000 | ["700","740"] | ["0.8079","0.7620"] | [] | ["EDGO","XISX"] | 700.0000 | 740.0000 | 25 | 39 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:41:21Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c50e-9657-7f91-b7e9-332d617f5cf2 | LITE | 2026-09-21 13:41 | call_diagonal_spread | 2 | 1 | 5 | 250535.00 | short | ask | 957.5400 | 23.1000 | ["700","740"] | ["0.8083","0.7628"] | [] | ["XCBO"] | 700.0000 | 740.0000 | 25 | 39 | false | false | true | ||||||||||
| 01a0c4c3-48ff-78e0-807b-887d68731063 | LITE | 2026-09-21 12:18 | call_diagonal_spread | 2 | 1 | 3 | 108564.00 | short | bid | 969.9600 | 17.8000 | ["700","890"] | ["0.7770","0.7941"] | [] | ["XISX"] | 700.0000 | 890.0000 | 4 | 25 | false | false | true | ||||||||||
| 01a0b60c-a22f-7c81-b400-ceb437fcb16b | LITE | 2026-09-18 15:44 | call_diagonal_spread | 2 | 1 | 9 | 110070.00 | short | ask | 926.6300 | 8.0000 | ["950","980"] | ["0.7013","0.6992"] | [] | ["XISX"] | 950.0000 | 980.0000 | 28 | 35 | false | true | true | ||||||||||
| 01a0b5d4-e0bf-7970-924a-fb06bd74c078 | LITE | 2026-09-18 14:43 | call_diagonal_spread | 2 | 1 | 9 | 1241064.00 | short | ask | 913.3000 | 21.3000 | ["190","260"] | ["69.9576","1.2727"] | [] | ["XMIO"] | 190.0000 | 260.0000 | 0 | 119 | false | false | true | ||||||||||
| 01a0b5b5-5a6f-7fb3-8653-6d829d85903a | LITE | 2026-09-18 14:09 | call_diagonal_spread | 2 | 1 | 6 | 928752.00 | short | ask | 914.7000 | 31.0000 | ["105","200"] | ["67.1067","0.8824"] | [] | ["XCBO"] | 105.0000 | 200.0000 | 0 | 490 | false | false | true | ||||||||||
| 01a0b59d-947f-7c93-8bb1-f817165c6a68 | LITE | 2026-09-18 13:43 | call_diagonal_spread | 2 | 3 | 52 | 586464.00 | short | bid | 911.0850 | 3.7846 | ["860","890"] | ["2.6972","0.7030"] | [] | ["ARCO","XBOX","XISX"] | 860.0000 | 890.0000 | 0 | 14 | false | false | true | ||||||||||
| 01a0b591-01c0-7d90-a344-beb1e1a9853d | LITE | 2026-09-18 13:29 | call_diagonal_spread | 2 | 3 | 37 | 417870.00 | short | bid | 911.4050 | 3.0000 | ["860","890"] | ["1.7299","0.7026"] | [] | ["ARCO","XCBO","XISX"] | 860.0000 | 890.0000 | 0 | 14 | false | false | true | ||||||||||
| 01a0b590-ea50-7351-818c-96d10d2ba75d | LITE | 2026-09-18 13:29 | call_diagonal_spread | 2 | 4 | 11 | 124391.00 | short | bid | 911.4050 | 5.8000 | ["860","890"] | ["2.4678","0.7043"] | [] | ["ARCO","EDGO","XCBO","XPHO"] | 860.0000 | 890.0000 | 0 | 14 | false | false | true | ||||||||||
| 01a0b590-daaf-7393-b042-9a25deb2477c | LITE | 2026-09-18 13:29 | call_diagonal_spread | 2 | 3 | 18 | 204170.00 | short | bid | 911.4050 | 6.6000 | ["860","890"] | ["1.6752","0.7068"] | [] | ["EDGO","XCBO","XPHO"] | 860.0000 | 890.0000 | 0 | 14 | false | false | true | ||||||||||
| 01a0b571-6fb8-7fa3-b40a-4125e7e4935c | LITE | 2026-09-18 12:55 | call_diagonal_spread | 2 | 3 | 10 | 112668.00 | short | bid | 911.5000 | 12.5100 | ["860","890"] | ["2.8942","0.6992"] | [] | ["ARCO","MCRY","XCBO"] | 860.0000 | 890.0000 | 0 | 14 | false | false | true | ||||||||||
| 01a0b544-e947-7c21-81f3-73d971b26304 | LITE | 2026-09-18 12:06 | call_diagonal_spread | 2 | 3 | 20 | 234448.00 | short | bid | 914.0000 | 6.7000 | ["860","890"] | ["1.8969","0.7071"] | [] | ["EDGO","XCBO","XISX"] | 860.0000 | 890.0000 | 0 | 14 | false | false | true | ||||||||||
| 01a0b4b8-ca30-7b00-b69a-91b35b61fd86 | LITE | 2026-09-18 09:33 | call_diagonal_spread | 2 | 1 | 120 | 138720.00 | short | bid | 934.4350 | 3.9000 | ["1000","1020"] | ["1.2287","0.7464"] | [] | ["XPHO"] | 1000.0000 | 1020.0000 | 0 | 7 | false | true | true | ||||||||||
| 01a0b041-5bb2-7663-b7c7-15614d03931f | LITE | 2026-09-17 12:44 | call_diagonal_spread | 2 | 2 | 2 | 112052.00 | short | bid | 917.5100 | 23.7000 | ["700","1100"] | ["0.7639","0.7782"] | [] | ["BATO","C2OX"] | 700.0000 | 1100.0000 | 120 | 491 | false | false | true | ||||||||||
| 01a0af99-0dc3-72c0-9ea0-18da243af04a | LITE | 2026-09-17 09:40 | call_diagonal_spread | 2 | 1 | 22 | 109340.00 | short | ask | 921.3350 | 4.8000 | ["910","960"] | ["0.9749","0.7382"] | [] | ["XMIO"] | 910.0000 | 960.0000 | 1 | 8 | false | false | true | ||||||||||
| 01a0a5c7-ed8e-77f1-9952-7b4a327b59d5 | LITE | 2026-09-15 11:55 | call_diagonal_spread | 2 | 2 | 18 | 154890.00 | short | bid | 842.5200 | 3.7000 | ["820","830"] | ["0.8304","0.7439"] | [] | ["EDGO","XISX"] | 820.0000 | 830.0000 | 3 | 10 | false | false | true | ||||||||||
| 01a0a172-1159-7760-bf96-81c20a704113 | LITE | 2026-09-14 15:43 | call_diagonal_spread | 2 | 1 | 2 | 102840.00 | short | bid | 835.4000 | 23.3000 | ["600","650"] | ["0.8502","0.7936"] | [] | ["XCBO"] | 600.0000 | 650.0000 | 32 | 158 | false | false | true | ||||||||||
| 01a0a051-0d10-7783-a4b3-a2352b04fce5 | LITE | 2026-09-14 10:27 | call_diagonal_spread | 2 | 1 | 3 | 107922.00 | short | bid | 857.1400 | 22.3000 | ["950","1000"] | ["0.7926","0.7966"] | [] | ["XCBO"] | 950.0000 | 1000.0000 | 186 | 276 | false | true | true | ||||||||||
| 01a091af-a0f1-7050-8fb4-54a859a2b912 | LITE | 2026-09-11 14:16 | call_diagonal_spread | 2 | 1 | 3 | 123918.00 | short | ask | 928.1200 | 20.5000 | ["720","730"] | ["11.1853","1.1287"] | [] | ["EDGO"] | 720.0000 | 730.0000 | 0 | 7 | false | false | true | ||||||||||
| 01a086b9-2400-7821-bbce-76728ab47c79 | LITE | 2026-09-09 11:11 | call_diagonal_spread | 2 | 1 | 25 | 1494850.00 | short | ask | 1012.0500 | 27.6000 | ["900","1030"] | ["0.8467","0.8043"] | [] | ["ARCO"] | 900.0000 | 1030.0000 | 191 | 310 | false | false | true | ||||||||||
| 01a086b7-0120-7f41-9a2e-7a86381a17db | LITE | 2026-09-09 11:08 | call_diagonal_spread | 2 | 2 | 6 | 164208.00 | short | bid | 1020.5000 | 21.9000 | ["915","920"] | ["0.8268","0.8109"] | [] | ["ARCO","XISX"] | 915.0000 | 920.0000 | 16 | 23 | false | false | true | ||||||||||
| 01a08680-60c0-7841-8595-58effe637b41 | LITE | 2026-09-09 10:09 | call_diagonal_spread | 2 | 2 | 20 | 351010.00 | short | ask | 1010.0000 | 11.3750 | ["1000","1020"] | ["0.8115","0.7876"] | [] | ["C2OX"] | 1000.0000 | 1020.0000 | 23 | 30 | false | false | true | ||||||||||
| 01a0820f-ef10-71e2-bc5e-0ed6bbf4d268 | LITE | 2026-09-08 13:27 | call_diagonal_spread | 2 | 1 | 30 | 945870.00 | short | bid | 991.7701 | 20.1000 | ["890","920"] | ["0.8284","0.8408"] | [] | ["XISX"] | 890.0000 | 920.0000 | 17 | 73 | false | false | true | ||||||||||
| 01a08209-b551-7502-9133-48080d2dfb6d | LITE | 2026-09-08 13:21 | call_diagonal_spread | 2 | 1 | 50 | 3011500.00 | short | bid | 993.0000 | 28.9000 | ["1300","1500"] | ["0.8048","0.8082"] | [] | ["XCBO"] | 1300.0000 | 1500.0000 | 500 | 647 | false | true | true | ||||||||||
| 01a081ad-06c0-7de1-9954-933d3f60e833 | LITE | 2026-09-08 11:39 | call_diagonal_spread | 2 | 1 | 15 | 169995.00 | short | ask | 987.2185 | 15.5000 | ["1015","1080"] | ["0.8183","0.7780"] | [] | ["BATO"] | 1015.0000 | 1080.0000 | 17 | 31 | false | true | true | ||||||||||
| 01a081a7-1f08-7cd2-bab2-07a487f2dbd8 | LITE | 2026-09-08 11:33 | call_diagonal_spread | 2 | 1 | 18 | 292608.00 | short | ask | 984.4350 | 11.2000 | ["950","1000"] | ["0.8284","0.7960"] | [] | ["BATO"] | 950.0000 | 1000.0000 | 17 | 24 | false | false | true | ||||||||||
| 01a08173-b2f8-75d1-ad7b-095a571c903d | LITE | 2026-09-08 10:37 | call_diagonal_spread | 2 | 2 | 10 | 179235.00 | short | ask | 965.1100 | 4.2000 | ["900","925"] | ["0.8183","0.8156"] | [] | ["ARCO","XPHO"] | 900.0000 | 925.0000 | 10 | 17 | false | false | true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:41:21Z"} |
| 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:19:13Z"} |
| 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-18T19:44:37Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:43:51Z"} |
| 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-18T18:09:21Z"} |
| 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-18T17:43:46Z"} |
| 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-18T17:29:57Z"} |
| 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-18T17:29:57Z"} |
| 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-18T17:29:57Z"} |
| 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-18T16:55:15Z"} |
| 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-18T16:06:38Z"} |
| 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-18T13:33:32Z"} |
| 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-17T16:44:44Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:40:39Z"} |
| 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:55:41Z"} |
| 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:43:50Z"} |
| 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-14T14:27:44Z"} |
| 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-11T18:17:25Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:11:14Z"} |
| 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-09T15:08:59Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:09:26Z"} |
| 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-08T17:28:42Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:21:13Z"} |
| 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-08T15:40:08Z"} |
| 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-08T15:33:34Z"} |
| 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-08T14:37:16Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |