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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c57b-1b97-7b71-a323-a7b131f2458e | MCD | 2026-09-21 15:39 | call_calendar | 2 | 1 | 129 | 131322.00 | long | ask | 248.8250 | 0.3500 | ["265"] | ["0.2333"] | [] | ["BATO"] | 265.0000 | 265.0000 | 60 | 88 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:39:54Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5a3-7c37-7250-9653-e8b063c1d550 | MCD | 2026-09-18 13:49 | call_vertical_spread | 2 | 1 | 60 | 303360.00 | long | ask | 249.0900 | 2.1000 | ["240","250"] | ["0.2218","0.2225"] | ["245.40"] | ["BATO"] | 240.0000 | 250.0000 | 272 | 272 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:50:13Z"} | 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 |
| 01a0aad0-bfe3-7bf2-af73-2c3a26672c8e | MCD | 2026-09-16 11:23 | put_calendar | 2 | 1 | 20 | 214420.00 | long | ask | 250.2250 | 2.6500 | ["300"] | ["0.3129"] | [] | ["XMIO"] | 300.0000 | 300.0000 | 184 | 457 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:23:31Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa84-8443-7d80-ae06-33ba7a7afad3 | MCD | 2026-09-16 10:00 | call_ratio_spread | 2 | 3 | 70 | 148532.00 | long | ask | 249.2850 | 1.7000 | ["250","270"] | ["0.2282","0.2275"] | ["251.50","297.75"] | ["ARCO","EMLD","SPHR"] | 250.0000 | 270.0000 | 184 | 184 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:00:19Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a647-3396-7aa0-be95-6c0ed9fb1997 | MCD | 2026-09-15 14:14 | risk_reversal | 2 | 1 | 22 | 111100.00 | long | bid | 253.7300 | 2.9500 | ["305","370"] | ["1.0829","2.1775"] | ["255.80"] | ["EMLD"] | 305.0000 | 370.0000 | 3 | 3 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:15:11Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 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 |
| 01a0a0fe-3149-79c0-ba31-cfc811d1fdd9 | MCD | 2026-09-14 13:36 | put_calendar | 2 | 1 | 22 | 107668.00 | long | ask | 257.1300 | 2.5000 | ["280"] | ["0.2394"] | [] | ["XMIO"] | 280.0000 | 280.0000 | 32 | 95 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:37:27Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 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 |