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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a06dfd-a51d-7b42-b07f-bbbcb686ed40 | BE | 2026-09-04 15:55 | call_diagonal_spread_bearish | 2 | 1 | 27 | 258336.00 | long | bid | 252.7050 | 7.2000 | ["202.5","210"] | ["61.6759","0.8565"] | [] | ["BATO"] | 202.5000 | 210.0000 | 0 | 14 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:55:40Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dfc-12c5-7783-b0b7-58b79a0029a0 | BE | 2026-09-04 15:53 | call_diagonal_spread_bearish | 2 | 6 | 556 | 2178602.00 | short | bid | 252.8100 | 1.3378 | ["235","250"] | ["19.6639","0.9478"] | [] | ["ARCO","C2OX","EDGO","XISX","XMIO","XPHO"] | 235.0000 | 250.0000 | 0 | 14 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:54:07Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06df9-bd1e-7732-9c79-e20ce8ef4dc3 | BE | 2026-09-04 15:51 | call_diagonal_spread_bearish | 2 | 1 | 51 | 155193.00 | short | ask | 253.0900 | 2.6500 | ["260","275"] | ["0.9666","0.9261"] | [] | ["XMIO"] | 260.0000 | 275.0000 | 14 | 21 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:51:34Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dec-094d-7910-bb81-dedc7ef1c928 | BE | 2026-09-04 15:36 | call_diagonal_spread_bearish | 2 | 1 | 85 | 305490.00 | short | ask | 251.2300 | 1.4000 | ["235","245"] | ["11.1147","1.0548"] | [] | ["MCRY"] | 235.0000 | 245.0000 | 0 | 7 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:36:42Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06de8-b1d5-7ba3-b056-4dcd44502691 | BE | 2026-09-04 15:32 | call_diagonal_spread_bearish | 2 | 1 | 100 | 427800.00 | long | bid | 251.0518 | 2.5500 | ["230","240"] | ["10.1007","1.0667"] | [] | ["XMIO"] | 230.0000 | 240.0000 | 0 | 7 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:32:48Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06de7-3ebe-7591-964f-0919d8ed3d2e | BE | 2026-09-04 15:31 | call_diagonal_spread_bearish | 2 | 2 | 20 | 145640.00 | long | ask | 250.6450 | 2.7500 | ["230","270"] | ["0.9259","0.9276"] | [] | ["ARCO"] | 230.0000 | 270.0000 | 14 | 105 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:31:23Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dde-3255-7881-abe6-0284e2691f61 | BE | 2026-09-04 15:21 | call_diagonal_spread_bearish | 2 | 1 | 40 | 145120.00 | short | ask | 247.2950 | 3.8500 | ["260","350"] | ["0.8944","0.9779"] | [] | ["XMIO"] | 260.0000 | 350.0000 | 28 | 77 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:21:27Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dd4-7a0d-7df3-87cd-fbe7d9a1944b | BE | 2026-09-04 15:10 | call_diagonal_spread_bearish | 2 | 2 | 64 | 337472.00 | long | bid | 246.3550 | 1.6250 | ["220","225"] | ["5.5820","0.9806"] | [] | ["EDGO","XCBO"] | 220.0000 | 225.0000 | 0 | 7 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:11:00Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dcc-9a6d-7b31-9619-dfe65a89bd47 | BE | 2026-09-04 15:01 | call_diagonal_spread_bearish | 2 | 4 | 588 | 2783200.00 | short | bid | 245.5160 | 4.0250 | ["270","300"] | ["0.8686","0.9472"] | [] | ["ARCO","XCBO","XISX","XPHO"] | 270.0000 | 300.0000 | 49 | 77 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:02:08Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dcc-4865-7dd0-a05b-c49dabb018f3 | BE | 2026-09-04 15:01 | call_diagonal_spread_bearish | 2 | 1 | 100 | 324400.00 | long | bid | 245.3900 | 0.4000 | ["240","250"] | ["1.0153","0.9281"] | [] | ["BATO"] | 240.0000 | 250.0000 | 7 | 14 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:02:08Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dba-52bd-7961-b4cf-7e6d7681e075 | BE | 2026-09-04 14:41 | call_diagonal_spread_bearish | 2 | 1 | 100 | 113600.00 | long | bid | 243.8600 | 0.3500 | ["250","270"] | ["6.9969","1.0783"] | [] | ["XISX"] | 250.0000 | 270.0000 | 0 | 7 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:42:17Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d8d-a53d-77e2-8ff2-d4bc091eb1c1 | BE | 2026-09-04 13:53 | call_diagonal_spread_bearish | 2 | 2 | 92 | 425868.00 | long | ask | 244.8600 | 1.2500 | ["222.5","227.5"] | ["4.0808","0.9896"] | [] | ["C2OX","EDGO"] | 222.5000 | 227.5000 | 0 | 7 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:53:52Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d6b-b9a5-71a2-acd9-a50459d9a227 | BE | 2026-09-04 13:16 | call_diagonal_spread_bearish | 2 | 1 | 26 | 115414.00 | short | ask | 245.7550 | 1.5000 | ["220","237.5"] | ["4.6188","0.9924"] | [] | ["BATO"] | 220.0000 | 237.5000 | 0 | 7 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:16:28Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d44-28bd-7f91-894f-58b60ecb27ff | BE | 2026-09-04 12:32 | call_diagonal_spread_bearish | 2 | 1 | 50 | 294800.00 | long | ask | 245.6400 | 2.8000 | ["245","270"] | ["1.0177","0.8960"] | [] | ["BATO"] | 245.0000 | 270.0000 | 7 | 133 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:33:27Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d3e-6fe6-76c2-926d-1e22d96f7fe5 | BE | 2026-09-04 12:26 | call_diagonal_spread_bearish | 2 | 1 | 10 | 120940.00 | long | bid | 246.2350 | 2.4500 | ["210","270"] | ["0.8743","0.8947"] | [] | ["XISX"] | 210.0000 | 270.0000 | 133 | 168 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:27:05Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |