Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
312,778 rowsCSV — whole table, not this view
Sources in this table
uw_multileg312,778 rowsexportable
| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b565-ee68-7221-9c86-0bbd2372cbb8 | CAT | 2026-09-18 12:42 | call_diagonal_spread | 2 | 1 | 4 | 310700.00 | unknown | — | 802.4300 | 30.5000 | ["450","470"] | ["0.4088","0.3900"] | [] | ["ARCO"] | 450.0000 | 470.0000 | 490 | 637 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:42:47Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b511-4e58-7342-8585-2f31002b68e4 | CAT | 2026-09-18 11:10 | call_diagonal_spread | 2 | 1 | 16 | 49632.00 | unknown | ask | 801.2900 | 2.6500 | ["800","880"] | ["0.4878","0.4009"] | [] | ["XCBO"] | 800.0000 | 880.0000 | 0 | 63 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:10:19Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d6-fca7-7211-9d15-aedcbfc36fba | CAT | 2026-09-18 10:06 | call_diagonal_spread | 2 | 1 | 4 | 31840.00 | unknown | — | 804.4375 | 11.8000 | ["780","815"] | ["0.3800","0.4064"] | [] | ["ARCO"] | 780.0000 | 815.0000 | 14 | 42 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:06:30Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b097-305b-7f61-90a0-1e0bca4cd9e2 | CAT | 2026-09-17 14:18 | call_diagonal_spread | 2 | 1 | 10 | 44725.00 | unknown | — | 796.8500 | 4.5900 | ["800","830"] | ["0.4056","0.4423"] | [] | ["SPHR"] | 800.0000 | 830.0000 | 1 | 155 | false | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:18:15Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b023-2d23-7510-95f2-2f83b66c2e91 | CAT | 2026-09-17 12:11 | call_diagonal_spread | 2 | 1 | 6 | 33120.00 | unknown | — | 799.4550 | 3.3500 | ["810","920"] | ["0.3620","0.3974"] | [] | ["XISX"] | 810.0000 | 920.0000 | 29 | 92 | false | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:12:03Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0affb-fde3-7a90-b000-5eaba591e741 | CAT | 2026-09-17 11:28 | call_diagonal_spread | 2 | 2 | 2 | 51500.00 | unknown | — | 798.1850 | 21.4000 | ["690","770"] | ["0.4323","0.4051"] | [] | ["EDGO","XCBO"] | 690.0000 | 770.0000 | 64 | 246 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:29:00Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afcd-3d23-7f90-abfc-ae1cf2d41eda | CAT | 2026-09-17 10:37 | call_diagonal_spread | 2 | 7 | 29 | 115379.00 | unknown | — | 801.1550 | 2.7000 | ["800","810"] | ["0.5005","0.3743"] | [] | ["C2OX","EDGO","EMLD","MCRY","XBOX","XISX"] | 800.0000 | 810.0000 | 1 | 29 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:38:03Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afad-b2eb-7050-a9b1-3e3b5878246d | CAT | 2026-09-17 10:03 | call_diagonal_spread | 2 | 1 | 16 | 101504.00 | unknown | — | 798.4580 | 12.1000 | ["770","775"] | ["0.4157","0.6409"] | [] | ["ARCO"] | 770.0000 | 775.0000 | 1 | 8 | false | false | true | true | 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 |
| 01a0afad-9f63-74e3-bd1d-f6d274728ba1 | CAT | 2026-09-17 10:03 | call_diagonal_spread | 2 | 1 | 4 | 25416.00 | unknown | — | 798.4580 | 12.3000 | ["770","775"] | ["0.4102","0.6685"] | [] | ["ARCO"] | 770.0000 | 775.0000 | 1 | 8 | false | false | true | true | false | mlet | tracked | 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 |
| 01a0abb4-8c4c-7401-8288-816b40fb7714 | CAT | 2026-09-16 15:32 | call_diagonal_spread | 2 | 1 | 8 | 390432.00 | unknown | — | 779.2600 | 19.9000 | ["600","680"] | ["0.3993","0.3971"] | [] | ["MCRY"] | 600.0000 | 680.0000 | 457 | 639 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:32:20Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab79-34e4-76b3-82c1-0bd80a5fba0c | CAT | 2026-09-16 14:27 | call_diagonal_spread | 2 | 4 | 96 | 781876.00 | unknown | — | 788.3300 | 4.7281 | ["720","890"] | ["0.3836","0.3722"] | [] | ["EDGO","XCBO","XISX","XPHO"] | 720.0000 | 890.0000 | 16 | 30 | true | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:27:22Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab1f-ca43-7482-ad90-9643e585af95 | CAT | 2026-09-16 12:49 | call_diagonal_spread | 2 | 1 | 7 | 130585.00 | unknown | — | 791.3700 | 14.2000 | ["860","900"] | ["0.3956","0.3854"] | [] | ["BATO"] | 860.0000 | 900.0000 | 274 | 366 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:50:20Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aace-6653-78c0-86a2-a2f190ece746 | CAT | 2026-09-16 11:20 | call_diagonal_spread | 2 | 1 | 4 | 350080.00 | unknown | — | 789.0450 | 25.4000 | ["310","400"] | ["6.0692","0.4106"] | [] | ["XMIO"] | 310.0000 | 400.0000 | 2 | 121 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:20:55Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aacb-2e1b-73e3-ab9a-1abff212bd27 | CAT | 2026-09-16 11:17 | call_diagonal_spread | 2 | 1 | 2 | 175100.00 | unknown | — | 789.9420 | 26.6500 | ["310","400"] | ["5.1675","0.7754"] | [] | ["XISX"] | 310.0000 | 400.0000 | 2 | 121 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:17:37Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a6a3-f5ae-7320-8233-86e3f70e4fa2 | CAT | 2026-09-15 15:55 | call_diagonal_spread | 2 | 1 | 4 | 238640.00 | unknown | — | 781.9300 | 16.1000 | ["520","540"] | ["0.4253","0.4221"] | [] | ["MCRY"] | 520.0000 | 540.0000 | 367 | 458 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:56:10Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a692-80ed-7db1-ab58-99a2f5b736a8 | CAT | 2026-09-15 15:36 | call_diagonal_spread | 2 | 1 | 2 | 29932.00 | unknown | — | 781.5601 | 10.4000 | ["700","800"] | ["0.8007","0.3909"] | [] | ["EMLD"] | 700.0000 | 800.0000 | 3 | 122 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:37:09Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a60d-a14d-7090-a2b9-ea5501592e16 | CAT | 2026-09-15 13:11 | call_diagonal_spread | 2 | 1 | 2 | 155600.00 | unknown | — | 783.2200 | 35.8000 | ["430","440"] | ["0.4362","0.3873"] | [] | ["XISX"] | 430.0000 | 440.0000 | 493 | 640 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:12:25Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5d9-71ed-7f83-b6eb-be62b348da37 | CAT | 2026-09-15 12:14 | call_diagonal_spread | 2 | 1 | 3 | 212109.00 | unknown | — | 779.8350 | 30.0500 | ["470","480"] | ["0.4364","0.3909"] | [] | ["XMIO"] | 470.0000 | 480.0000 | 458 | 640 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:14:55Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5ce-d716-74c1-8b4e-bb37c0dcbb29 | CAT | 2026-09-15 12:03 | call_diagonal_spread | 2 | 1 | 3 | 149940.00 | unknown | — | 781.5200 | 28.2000 | ["640","720"] | ["0.4158","0.3972"] | [] | ["XPHO"] | 640.0000 | 720.0000 | 640 | 857 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:03:50Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5a9-f1c6-7f12-8476-dfa9955e6c12 | CAT | 2026-09-15 11:22 | call_diagonal_spread | 2 | 1 | 4 | 124200.00 | unknown | — | 781.3698 | 19.4000 | ["600","650"] | ["1.7876","0.8399"] | [] | ["ARCO"] | 600.0000 | 650.0000 | 3 | 10 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:22:51Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a575-7ffe-7eb1-b131-302ba8740fd3 | CAT | 2026-09-15 10:25 | call_diagonal_spread | 2 | 1 | 4 | 218344.00 | unknown | — | 780.6900 | 17.5000 | ["540","560"] | ["0.4424","0.4417"] | [] | ["MCRY"] | 540.0000 | 560.0000 | 275 | 367 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:25:54Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a570-f006-7d22-a36b-274bce0c42a0 | CAT | 2026-09-15 10:20 | call_diagonal_spread | 2 | 2 | 3 | 52824.00 | unknown | — | 781.9200 | 15.3167 | ["700","740"] | ["0.8985","0.4154"] | [] | ["ARCO","XISX"] | 700.0000 | 740.0000 | 3 | 94 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:20:40Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a15d-9ef9-7272-9292-2aff9660e541 | CAT | 2026-09-14 15:21 | call_diagonal_spread | 2 | 1 | 4 | 321428.00 | unknown | — | 787.8000 | 31.1500 | ["410","420"] | ["0.3626","0.3742"] | [] | ["ARCO"] | 410.0000 | 420.0000 | 459 | 494 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:21:04Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |