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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a06d34-985d-7613-8d3e-e11ae5a31eb6 | AMZN | 2026-09-04 12:15 | call_diagonal_spread_bearish | 2 | 1 | 62 | 227974.00 | short | bid | 256.4726 | 0.6000 | ["260","280"] | ["0.2769","0.3589"] | [] | ["XPHO"] | 260.0000 | 280.0000 | 14 | 378 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:15:58Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d7b-b765-7911-a737-5109645ebc05 | AMZN | 2026-09-04 13:33 | call_diagonal_spread_bearish | 2 | 1 | 12 | 56160.00 | short | bid | 256.8200 | 0.3000 | ["235","250"] | ["0.3228","0.3505"] | [] | ["C2OX"] | 235.0000 | 250.0000 | 14 | 105 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:34:11Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d7b-b765-7911-a737-50d8b76d8a04 | AMZN | 2026-09-04 13:33 | call_diagonal_spread_bearish | 2 | 3 | 17 | 79924.00 | long | ask | 256.8200 | 0.8147 | ["235","250"] | ["0.3374","0.3526"] | [] | ["C2OX","EDGO","XBOX"] | 235.0000 | 250.0000 | 14 | 105 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:34:11Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d8e-782c-7e30-a812-8c5d251e6b78 | AMZN | 2026-09-04 13:54 | call_diagonal_spread_bearish | 2 | 1 | 3 | 88248.00 | short | bid | 257.2100 | 8.3500 | ["115","125"] | ["0.9661","0.4124"] | [] | ["EMLD"] | 115.0000 | 125.0000 | 105 | 833 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:54:42Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d90-3195-7e63-abe4-c2bbd96858ae | AMZN | 2026-09-04 13:55 | call_diagonal_spread_bearish | 2 | 1 | 4 | 112424.00 | short | bid | 257.1300 | 7.0000 | ["120","135"] | ["0.7746","0.4270"] | [] | ["XMIO"] | 120.0000 | 135.0000 | 105 | 833 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:56:04Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06db3-8875-7523-8b1f-52cf3df9d676 | AMZN | 2026-09-04 14:34 | call_diagonal_spread_bearish | 2 | 1 | 8 | 67400.00 | long | ask | 257.3100 | 1.6500 | ["225","230"] | ["0.3643","0.3734"] | [] | ["XPHO"] | 225.0000 | 230.0000 | 105 | 168 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:35:12Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06de1-9585-7ba3-84a2-8225ad6a4f02 | AMZN | 2026-09-04 15:24 | call_diagonal_spread_bearish | 2 | 1 | 3 | 30054.00 | short | bid | 258.2150 | 2.5500 | ["250","260"] | ["0.3690","0.3785"] | [] | ["XMIO"] | 250.0000 | 260.0000 | 286 | 651 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:25:21Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06df5-d905-7cf0-8e0e-33c62c757609 | AMZN | 2026-09-04 15:47 | call_diagonal_spread_bearish | 2 | 1 | 4 | 29720.00 | long | bid | 258.8350 | 1.2000 | ["220","225"] | ["16.3575","0.3278"] | [] | ["XMIO"] | 220.0000 | 225.0000 | 0 | 35 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:47:20Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |