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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5a6-27d0-7281-ae92-5a85485e7a2e | VRT | 2026-09-18 13:52 | call_vertical_spread | 2 | 1 | 50 | 114124.00 | long | ask | 248.4050 | 0.7500 | ["240","290"] | ["0.5438","0.5360"] | ["256.48"] | ["XCBO"] | 240.0000 | 290.0000 | 28 | 28 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:52:45Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b087-1743-7101-ba74-532276cf219c | VRT | 2026-09-17 14:00 | call_vertical_spread | 2 | 1 | 7 | 128030.00 | long | ask | 241.6950 | 7.3000 | ["250","260"] | ["0.6274","0.6257"] | ["253.26"] | ["XPHO"] | 250.0000 | 260.0000 | 820 | 820 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:01:08Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b05f-5b63-7833-9d5a-5395e963f3e3 | VRT | 2026-09-17 13:17 | call_diagonal_spread | 2 | 1 | 72 | 151344.00 | long | ask | 242.6500 | 0.7200 | ["247.5","270"] | ["0.6112","0.5985"] | [] | ["XISX"] | 247.5000 | 270.0000 | 1 | 92 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:17:44Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab51-7133-7510-bae8-51a5c0e3729d | VRT | 2026-09-16 13:43 | call_diagonal_spread | 2 | 1 | 170 | 167450.00 | long | ask | 242.9400 | 1.8900 | ["275","290"] | ["0.5630","0.5532"] | [] | ["XMIO"] | 275.0000 | 290.0000 | 30 | 37 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:44:02Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aabe-b6b3-73f2-9117-2aa1fb2f71a1 | VRT | 2026-09-16 11:03 | put_ladder | 3 | 1 | 100 | 225200.00 | short | ask | 241.8200 | 2.2100 | ["215","240","250"] | ["0.6273","0.5881","0.5757"] | ["234.99"] | ["XPHO"] | 215.0000 | 250.0000 | 9 | 9 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:04:00Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a0e8-20d8-7cc0-9a65-e545a2662131 | VRT | 2026-09-14 13:12 | put_diagonal_spread | 2 | 1 | 40 | 322960.00 | long | ask | 238.7400 | 4.7000 | ["267.5","270"] | ["0.8267","0.6081"] | [] | ["XMIO"] | 267.5000 | 270.0000 | 4 | 123 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:12:43Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0e3-e6d1-75f0-81d8-931a9eececc8 | VRT | 2026-09-14 13:08 | call_diagonal_spread | 2 | 1 | 5 | 107130.00 | long | ask | 238.4700 | 7.3000 | ["185","200"] | ["0.6342","0.6511"] | [] | ["XCBO"] | 185.0000 | 200.0000 | 641 | 823 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:08:23Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a063-e549-7220-aeaf-9117f2a99bd6 | VRT | 2026-09-14 10:48 | put_diagonal_spread | 2 | 1 | 9 | 150399.00 | long | ask | 236.6450 | 6.6000 | ["260","300"] | ["0.6172","0.6130"] | [] | ["XCBO"] | 260.0000 | 300.0000 | 186 | 823 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:48:28Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08c75-b138-77b2-838e-de5c8df0078f | VRT | 2026-09-10 13:55 | call_vertical_spread | 2 | 1 | 10 | 117110.00 | long | ask | 247.9050 | 5.8000 | ["260","270"] | ["0.6165","0.6156"] | ["263.57"] | ["XCBO"] | 260.0000 | 270.0000 | 372 | 372 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:55:22Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08789-0e91-7551-9cea-211b9c5da866 | VRT | 2026-09-09 14:58 | call_vertical_spread | 2 | 1 | 7 | 143766.00 | long | ask | 261.9650 | 7.9500 | ["260","270"] | ["0.6398","0.6385"] | ["263.32"] | ["XMIO"] | 260.0000 | 270.0000 | 828 | 828 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:58:22Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0824e-9df0-76c3-b9d9-8763f2845274 | VRT | 2026-09-08 14:36 | call_diagonal_spread | 2 | 1 | 10 | 108550.00 | long | ask | 293.1300 | 4.1000 | ["220","272.5"] | ["0.6167","0.7266"] | [] | ["XMIO"] | 220.0000 | 272.5000 | 3 | 129 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:37:02Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |