Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
367,592 rowsCSV — whole table, not this view
Sources in this table
uw_multileg367,592 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-1717-7a90-8cd0-ed7f0dfeb714 | MCD | 2026-09-18 15:47 | put_vertical_spread | 2 | 1 | 15 | 218880.00 | short | bid | 249.3800 | 4.7500 | ["315","330"] | ["0.4118","0.4778"] | [] | ["AMXO"] | 315.0000 | 330.0000 | 63 | 63 | false | false | false | true | false | mlet | market_whale | 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 |
| 01a0b56b-b6e0-7741-a228-0a96fd3e7874 | MCD | 2026-09-18 12:48 | put_vertical_spread | 2 | 4 | 34 | 133346.00 | short | bid | 249.6300 | 2.1000 | ["255","280"] | ["0.2195","0.2512"] | ["259.25"] | ["ARCO","EMLD","SPHR"] | 255.0000 | 280.0000 | 35 | 35 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:49:22Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4fa-5f40-7a50-9a15-455d60abed54 | MCD | 2026-09-18 10:44 | put_vertical_spread | 2 | 1 | 45 | 215685.00 | long | ask | 250.0650 | 1.7000 | ["265","275"] | ["0.2602","0.2698"] | ["267.51"] | ["BATO"] | 265.0000 | 275.0000 | 91 | 91 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:45:06Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b007-6f93-7292-8ce0-e4316b58b7ae | MCD | 2026-09-17 11:41 | put_vertical_spread | 2 | 1 | 6 | 150714.00 | long | ask | 249.2926 | 9.4000 | ["350","400"] | ["0.3930","0.5005"] | ["350.05"] | ["XMIO"] | 350.0000 | 400.0000 | 491 | 491 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:41:32Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afd4-a793-7480-801b-8f6ad3cb95f5 | MCD | 2026-09-17 10:45 | put_vertical_spread | 2 | 1 | 6 | 111684.00 | long | ask | 249.8100 | 3.5000 | ["340","345"] | ["2.9981","3.0904"] | ["340.02"] | ["XMIO"] | 340.0000 | 345.0000 | 1 | 1 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:46:09Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abb6-39fb-78b3-8910-22087106ce78 | MCD | 2026-09-16 15:33 | put_vertical_spread | 2 | 1 | 542 | 4444400.00 | unknown | — | 249.4400 | 3.8500 | ["285","295"] | ["1.1172","1.3393"] | [] | ["XBOX"] | 285.0000 | 295.0000 | 2 | 2 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:34:16Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a5d7-f706-73b2-9871-8a5b7cf2aad5 | MCD | 2026-09-15 12:13 | put_vertical_spread | 2 | 6 | 49 | 127706.00 | long | ask | 254.4850 | 0.6000 | ["250","260"] | ["0.2452","0.2473"] | ["255.0"] | ["ARCO","BATO","C2OX","EMLD","SPHR","XBOX"] | 250.0000 | 260.0000 | 122 | 122 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:13:16Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a091ea-8ee0-7f90-8839-603459e7f9fb | MCD | 2026-09-11 15:21 | put_vertical_spread | 2 | 1 | 117 | 1194570.00 | unknown | — | 252.8350 | 4.2500 | ["300","310"] | ["0.8755","0.9892"] | [] | ["XBOX"] | 300.0000 | 310.0000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:21:18Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08695-1588-7262-803b-52e0a8937897 | MCD | 2026-09-09 10:31 | put_vertical_spread | 2 | 1 | 47 | 225553.00 | unknown | — | 254.6200 | 3.5500 | ["270","280"] | ["0.2410","0.2492"] | [] | ["BATO"] | 270.0000 | 280.0000 | 100 | 100 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:32:13Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08661-1508-7631-b7e4-b3580c5d0cf1 | MCD | 2026-09-09 09:35 | put_vertical_spread | 2 | 6 | 111 | 438006.00 | long | ask | 253.8100 | 0.9500 | ["250","260"] | ["0.2608","0.2628"] | ["255"] | ["BATO","EDGO","XCBO","XISX","XPHO"] | 250.0000 | 260.0000 | 281 | 281 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:35:13Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0826c-a958-7b40-8954-8da7d8d9386e | MCD | 2026-09-08 15:09 | put_vertical_spread | 2 | 1 | 17 | 219980.00 | unknown | — | 256.0600 | 2.8000 | ["310","330"] | ["0.7719","0.9612"] | [] | ["XBOX"] | 310.0000 | 330.0000 | 10 | 10 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:09:34Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |