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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b60f-6537-7521-a193-e2ad7b15d034 | CAT | 2026-09-18 15:47 | put_diagonal_spread | 2 | 2 | 15 | 110388.00 | unknown | ask | 806.9550 | 5.3500 | ["800","840"] | ["0.4189","4.7037"] | [] | ["XCBO","XMIO"] | 800.0000 | 840.0000 | 0 | 42 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:47:39Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b60f-6537-7521-a193-e2913b7a5ff6 | CAT | 2026-09-18 15:47 | put_diagonal_spread | 2 | 5 | 37 | 271224.00 | long | ask | 806.9550 | 6.0176 | ["800","840"] | ["0.4175","3.9274"] | [] | ["AMXO","ARCO","XISX","XPHO"] | 800.0000 | 840.0000 | 0 | 42 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:47:39Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b60f-1ee8-7c10-8063-d6f728af0fac | CAT | 2026-09-18 15:47 | put_diagonal_spread | 2 | 1 | 8 | 59360.00 | long | ask | 807.0100 | 8.1000 | ["800","840"] | ["0.4219","5.4576"] | [] | ["XPHO"] | 800.0000 | 840.0000 | 0 | 42 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:47:19Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b60e-d4b0-70a0-9602-2d98feb142ef | CAT | 2026-09-18 15:46 | put_diagonal_spread | 2 | 1 | 12 | 90108.00 | long | ask | 806.9300 | 11.4500 | ["800","840"] | ["0.4264","5.8925"] | [] | ["XMIO"] | 800.0000 | 840.0000 | 0 | 42 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:47:05Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d7-0477-7891-886c-f4d80fc4fe1a | CAT | 2026-09-18 10:06 | put_diagonal_spread | 2 | 1 | 5 | 31960.00 | long | ask | 804.4375 | 3.7000 | ["780","790"] | ["0.4167","0.3507"] | [] | ["XCBO"] | 780.0000 | 790.0000 | 28 | 63 | false | true | true | true | false | mlat | 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 |
| 01a0b4cc-c760-7bb1-bed1-eb1d4d269325 | CAT | 2026-09-18 09:55 | put_diagonal_spread | 2 | 1 | 9 | 191520.00 | long | ask | 805.1050 | 22.2500 | ["780","790"] | ["0.4092","0.4159"] | [] | ["XCBO"] | 780.0000 | 790.0000 | 364 | 455 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:55:14Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0dc-99e3-7912-b68e-c3c91794ffe9 | CAT | 2026-09-17 15:33 | put_diagonal_spread | 2 | 1 | 45 | 595035.00 | long | ask | 796.8900 | 7.0500 | ["800","850"] | ["0.4098","0.7268"] | [] | ["XISX"] | 800.0000 | 850.0000 | 1 | 155 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:34:32Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b05a-c782-7a30-b96c-56d3c333971b | CAT | 2026-09-17 13:12 | put_diagonal_spread | 2 | 1 | 10 | 47360.00 | long | ask | 798.7050 | 7.3500 | ["765","775"] | ["0.4314","0.3717"] | [] | ["XPHO"] | 765.0000 | 775.0000 | 22 | 43 | false | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:12:19Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b05a-b7e2-7ae1-beda-15c9c877c7e1 | CAT | 2026-09-17 13:12 | put_diagonal_spread | 2 | 1 | 10 | 48270.00 | long | ask | 798.7050 | 7.3500 | ["765","775"] | ["0.4342","0.3804"] | [] | ["XMIO"] | 765.0000 | 775.0000 | 22 | 43 | false | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:12:19Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afb0-b08b-7cd3-8b11-156a8cc73ab6 | CAT | 2026-09-17 10:06 | put_diagonal_spread | 2 | 1 | 5 | 31770.00 | long | ask | 798.5600 | 7.9700 | ["720","760"] | ["0.4146","0.6212"] | [] | ["XCBO"] | 720.0000 | 760.0000 | 1 | 273 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:06:27Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 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 | true | 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 |
| 01a0a588-3126-72a3-b41f-965af512c5fa | CAT | 2026-09-15 10:45 | put_diagonal_spread | 2 | 1 | 2 | 28414.00 | long | ask | 780.5500 | 13.2500 | ["820","850"] | ["0.4054","0.8172"] | [] | ["XMIO"] | 820.0000 | 850.0000 | 3 | 66 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:46:01Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a11a-0260-72b2-a6c9-ecbdd36d0d42 | CAT | 2026-09-14 14:07 | put_diagonal_spread | 2 | 1 | 9 | 185022.00 | long | ask | 786.5800 | 17.2500 | ["780","810"] | ["0.4245","0.4177"] | [] | ["XCBO"] | 780.0000 | 810.0000 | 186 | 368 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:07:14Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a08e-2d80-78a0-8c2a-eac748e418a0 | CAT | 2026-09-14 11:34 | put_diagonal_spread | 2 | 1 | 10 | 340320.00 | long | ask | 787.6800 | 21.2000 | ["890","900"] | ["0.4309","0.4235"] | [] | ["XCBO"] | 890.0000 | 900.0000 | 276 | 368 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:34:40Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08bf4-d108-7d93-9363-9b9849aca47a | CAT | 2026-09-10 11:34 | put_diagonal_spread | 2 | 1 | 4 | 174292.00 | long | ask | 806.3550 | 18.3000 | ["845","1200"] | ["0.3601","0.9395"] | [] | ["XPHO"] | 845.0000 | 1200.0000 | 8 | 15 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:35:13Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |