Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
403,968 rowsCSV — whole table, not this view
Sources in this table
uw_multileg403,968 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0ca37-6f0f-73c0-ae8f-fe41686448b0 | CLS | 2026-09-22 13:43 | call_vertical_spread | 2 | 1 | 10 | 113770.00 | long | ask | 353.0950 | 6.9000 | ["330","370"] | ["0.6763","0.6701"] | ["348.19"] | ["XCBO"] | 330.0000 | 370.0000 | 115 | 115 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T17:44:07Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c97d-5a57-7131-838e-e81ee525d08d | CLS | 2026-09-22 10:20 | call_vertical_spread | 2 | 1 | 5 | 135000.00 | unknown | ask | 349.1400 | 11.6000 | ["300","320"] | ["0.7235","0.7228"] | ["445.00"] | ["XBOX"] | 300.0000 | 320.0000 | 486 | 486 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T14:20:48Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c965-984f-7790-ae33-fee20ee4d9df | CLS | 2026-09-22 09:54 | put_vertical_spread | 2 | 3 | 57 | 173244.00 | long | ask | 353.6800 | 11.2000 | ["350","360"] | ["0.6305","0.6178"] | ["354.99"] | ["AMXO","ARCO"] | 350.0000 | 360.0000 | 10 | 10 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T13:54:37Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c958-03bf-77a2-9cc2-c88d2f828866 | CLS | 2026-09-22 09:39 | call_diagonal_spread | 2 | 1 | 9 | 240930.00 | long | ask | 346.7200 | 14.1000 | ["310","400"] | ["0.7037","0.6966"] | [] | ["XISX"] | 310.0000 | 400.0000 | 486 | 850 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T13:39:49Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c585-b66e-7f92-99e4-30d588f4d74f | CLS | 2026-09-21 15:51 | put_diagonal_spread | 2 | 2 | 38 | 402439.00 | long | ask | 344.4200 | 14.4000 | ["270","320"] | ["0.7052","0.7032"] | [] | ["ARCO","XCBO"] | 270.0000 | 320.0000 | 269 | 333 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:51:19Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c429-2028-7622-8ddd-20d91efd0cd0 | CLS | 2026-09-21 09:30 | call_vertical_spread | 2 | 1 | 20 | 599260.00 | long | ask | 343.3200 | 17.5000 | ["195","200"] | ["0.7113","0.7118"] | ["199.57"] | ["XCBO"] | 195.0000 | 200.0000 | 88 | 88 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:30:08Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b56c-8db7-7e83-82a7-bbfa15c00d35 | CLS | 2026-09-18 12:49 | straddle | 2 | 3 | 21 | 537628.00 | long | ask | 333.3600 | 9.0000 | ["470"] | ["0.6949"] | ["213.99","726.01"] | ["ARCO","C2OX","EDGO"] | 470.0000 | 470.0000 | 490 | 490 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:50:02Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b50f-a48f-7d82-a1eb-ca54034afd2d | CLS | 2026-09-18 11:08 | call_vertical_spread | 2 | 1 | 20 | 326840.00 | long | ask | 333.8100 | 11.6000 | ["400","410"] | ["0.6942","0.6923"] | ["403"] | ["BATO"] | 400.0000 | 410.0000 | 427 | 427 | true | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:08:20Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b08e-00cb-7781-b1f2-21bc9c9a46dc | CLS | 2026-09-17 14:08 | call_vertical_spread | 2 | 1 | 20 | 629400.00 | long | ask | 331.4700 | 11.6000 | ["170","180"] | ["2.2824","2.1220"] | ["179.96"] | ["XMIO"] | 170.0000 | 180.0000 | 8 | 8 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:08:17Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a178-5ea0-7e43-b4f8-7bd8186cc000 | CLS | 2026-09-14 15:50 | call_vertical_spread | 2 | 1 | 281 | 3735052.00 | long | ask | 317.5300 | 12.6000 | ["310","320"] | ["0.7014","0.6960"] | ["314.62"] | ["XCBO"] | 310.0000 | 320.0000 | 186 | 186 | true | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:50:35Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0cf-bea8-73f3-ac15-7db351380339 | CLS | 2026-09-14 12:46 | call_calendar | 2 | 1 | 5 | 119955.00 | short | ask | 320.0999 | 12.4000 | ["200"] | ["2.0763"] | [] | ["XCBO"] | 200.0000 | 200.0000 | 4 | 32 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:46:12Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091b1-2f60-7d63-a140-e5e398cfb40e | CLS | 2026-09-11 14:18 | call_diagonal_spread | 2 | 1 | 5 | 108200.00 | long | ask | 340.6300 | 11.1000 | ["300","330"] | ["0.7126","0.7163"] | [] | ["XPHO"] | 300.0000 | 330.0000 | 279 | 434 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:19:00Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0914d-1a49-7d30-964d-755d212f2bb1 | CLS | 2026-09-11 12:29 | call_vertical_spread | 2 | 1 | 20 | 294800.00 | long | ask | 340.7900 | 10.2000 | ["300","310"] | ["0.6916","0.6879"] | ["305.60"] | ["XISX"] | 300.0000 | 310.0000 | 126 | 126 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:29:20Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0914d-1278-7a60-b1de-2c4ebb13ca69 | CLS | 2026-09-11 12:29 | call_vertical_spread | 2 | 1 | 20 | 294780.00 | long | ask | 340.7900 | 10.2000 | ["300","310"] | ["0.6914","0.6879"] | ["305.59"] | ["XISX"] | 300.0000 | 310.0000 | 126 | 126 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:29:20Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090b6-48e8-75e0-8275-75c47dae9cbe | CLS | 2026-09-11 09:44 | call_vertical_spread | 2 | 1 | 9 | 110880.00 | long | ask | 337.3450 | 10.8000 | ["330","380"] | ["0.6861","0.6764"] | ["349.50"] | ["XMIO"] | 330.0000 | 380.0000 | 189 | 189 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T13:44:32Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c42-4528-7331-9a22-3ada50fb8cf9 | CLS | 2026-09-10 12:59 | call_vertical_spread | 2 | 1 | 10 | 301100.00 | long | ask | 326.9250 | 10.2000 | ["195","200"] | ["0.7315","0.7279"] | ["198.68"] | ["XMIO"] | 195.0000 | 200.0000 | 253 | 253 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:59:47Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c3e-0350-79a2-adea-b05d1ba9c835 | CLS | 2026-09-10 12:54 | call_vertical_spread | 2 | 1 | 14 | 418334.00 | long | ask | 326.1550 | 11.6000 | ["195","200"] | ["0.7223","0.7198"] | ["198.63"] | ["AMXO"] | 195.0000 | 200.0000 | 253 | 253 | true | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:54:29Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0876e-75f8-77f2-bd8d-c5f0fe046673 | CLS | 2026-09-09 14:29 | call_vertical_spread | 2 | 1 | 100 | 278000.00 | long | ask | 337.0900 | 2.0000 | ["360","400"] | ["0.6384","0.6540"] | ["369.60"] | ["XMIO"] | 360.0000 | 400.0000 | 37 | 37 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:29:19Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086c3-8440-74e1-96bd-4541fd21fef8 | CLS | 2026-09-09 11:22 | call_diagonal_spread | 2 | 1 | 8 | 102840.00 | long | ask | 341.9300 | 6.9000 | ["310","320"] | ["0.7297","0.6896"] | [] | ["XMIO"] | 310.0000 | 320.0000 | 72 | 128 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:22:35Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a081c9-1658-7091-ae23-4aa8535b6c6f | CLS | 2026-09-08 12:10 | put_vertical_spread | 2 | 1 | 30 | 153690.00 | long | ask | 331.2100 | 6.4000 | ["330","340"] | ["0.6256","0.6264"] | ["334.45"] | ["XCBO"] | 330.0000 | 340.0000 | 31 | 31 | true | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:10:48Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |