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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c576-ca1f-7530-abc6-89330cc4940a | ETHA | 2026-09-21 15:34 | other | 4 | 1 | 12455 | 1556875.00 | unknown | ask | 20.9350 | 0.0500 | ["18","19","20","21"] | ["0.7824","0.6620","0.5409","0.5376"] | [] | ["AMXO"] | 18.0000 | 21.0000 | 4 | 11 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:35:11Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c46b-93df-76f1-b953-5e69565e5af5 | ETHA | 2026-09-21 10:42 | call_vertical_spread | 2 | 1 | 500 | 701000.00 | long | ask | 20.6300 | 0.4000 | ["13","19"] | ["0.6464","0.5838"] | ["16.86"] | ["EDGO"] | 13.0000 | 19.0000 | 269 | 269 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:43:01Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5ec-e148-71a3-95cd-1dd5b9c0d0fe | ETHA | 2026-09-18 15:09 | call_vertical_spread | 2 | 1 | 805 | 191590.00 | short | bid | 19.8000 | 0.0800 | ["24","35"] | ["0.5586","0.6088"] | ["25.32"] | ["MCRY"] | 24.0000 | 35.0000 | 182 | 182 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:10:00Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b590-4640-7163-a8cc-fb311227c5e4 | ETHA | 2026-09-18 13:28 | call_ratio_spread | 2 | 1 | 210 | 194850.00 | unknown | — | 19.5799 | 0.4000 | ["15","16"] | ["0.5784","0.5659"] | [] | ["XCBO"] | 15.0000 | 16.0000 | 119 | 119 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:29:16Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4f0-648f-76a2-8210-9adee32a8548 | ETHA | 2026-09-18 10:34 | other | 4 | 1 | 3623 | 282594.00 | unknown | bid | 19.4100 | 0.0600 | ["17.5","18.5","19.5"] | ["2.4351","0.8222","0.4855"] | [] | ["AMXO"] | 17.5000 | 19.5000 | 0 | 7 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:34:22Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4e9-a217-7d51-86e7-b5b36abc99ce | ETHA | 2026-09-18 10:26 | other | 6 | 1 | 489 | 107580.00 | unknown | — | 19.4150 | 0.2000 | ["17.5","18","18.5","19","19.5","20.5"] | ["0.5383","0.5207","1.1169","0.7111","0.4880","0.5436"] | [] | ["AMXO"] | 17.5000 | 20.5000 | 0 | 7 | false | false | true | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:27:03Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4ce-9067-75d0-90fa-f219bc4d6133 | ETHA | 2026-09-18 09:57 | straddle | 2 | 1 | 1000 | 465000.00 | short | bid | 19.2650 | 0.1200 | ["19"] | ["0.5371"] | ["14.35","23.65"] | ["XCBO"] | 19.0000 | 19.0000 | 119 | 119 | false | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:57:16Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4ce-2307-7570-8369-c42ac519f856 | ETHA | 2026-09-18 09:56 | synthetic | 2 | 2 | 1000 | 1053026.00 | short | bid | 19.2800 | 0.6500 | ["20"] | ["0.6106"] | ["20.41"] | ["XMIO"] | 20.0000 | 20.0000 | 490 | 490 | false | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:56:43Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0afe8-8583-7c21-bd5c-0de6aefeb644 | ETHA | 2026-09-17 11:07 | other | 8 | 1 | 1724 | 141368.00 | unknown | — | 18.4550 | 0.1000 | ["17.5","18","19.5","20.5","21"] | ["0.5409","0.4763","0.6282","0.5594","1.2186"] | [] | ["XCBO"] | 17.5000 | 21.0000 | 1 | 8 | false | true | true | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:07:31Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afe6-186a-7121-96b4-907573a81aa2 | ETHA | 2026-09-17 11:04 | call_vertical_spread | 2 | 1 | 1300 | 118300.00 | unknown | — | 18.4950 | 0.0600 | ["25","35"] | ["0.5664","0.6632"] | [] | ["XPHO"] | 25.0000 | 35.0000 | 120 | 120 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:05:00Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a682-92ce-7321-b716-f616d482d4c2 | ETHA | 2026-09-15 15:19 | call_vertical_spread | 2 | 1 | 4000 | 256000.00 | unknown | — | 18.2100 | 0.0600 | ["26","30"] | ["0.6004","0.6419"] | [] | ["XPHO"] | 26.0000 | 30.0000 | 94 | 94 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:20:10Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a580-d26e-7310-ac58-e14edb03f54d | ETHA | 2026-09-15 10:37 | call_vertical_spread | 2 | 1 | 629 | 249084.00 | unknown | — | 18.2800 | 0.1700 | ["17","21"] | ["0.5517","0.5637"] | [] | ["XBOX"] | 17.0000 | 21.0000 | 94 | 94 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:38:17Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a565-99ae-7890-b405-5d277860e990 | ETHA | 2026-09-15 10:08 | call_vertical_spread | 2 | 1 | 1846 | 186446.00 | unknown | — | 18.4250 | 0.1400 | ["40","50"] | ["0.6485","0.6821"] | [] | ["XCBO"] | 40.0000 | 50.0000 | 275 | 275 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:08:12Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a09201-62a0-7402-b7a3-ac7921cab6fc | ETHA | 2026-09-11 15:45 | other | 4 | 1 | 12543 | 1229214.00 | unknown | — | 19.1850 | 0.0600 | ["18","18.5","19"] | ["0.5129","5.1607","1.4583"] | [] | ["XPHO"] | 18.0000 | 19.0000 | 0 | 14 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:46:18Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091e1-9218-71e2-8c43-4706dc66b5f6 | ETHA | 2026-09-11 15:11 | other | 2 | 1 | 192 | 124224.00 | unknown | — | 19.1900 | 0.3000 | ["16"] | ["4.8061"] | [] | ["XCBO"] | 16.0000 | 16.0000 | 0 | 14 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:11:28Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090fa-7dd8-74d3-8066-c7b8e34cbba9 | ETHA | 2026-09-11 10:58 | call_diagonal_spread | 2 | 1 | 1000 | 352000.00 | long | bid | 19.6900 | 0.1300 | ["18","19"] | ["0.5580","0.5514"] | [] | ["XCBO"] | 18.0000 | 19.0000 | 7 | 35 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:59:16Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090f9-e580-7321-8d88-031aae900b37 | ETHA | 2026-09-11 10:58 | call_diagonal_spread | 2 | 2 | 1000 | 301000.00 | short | ask | 19.6950 | 0.1700 | ["18","20"] | ["0.5293","0.5487"] | [] | ["XCBO"] | 18.0000 | 20.0000 | 7 | 35 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:58:15Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090f9-1678-7542-af7a-c49698a441e5 | ETHA | 2026-09-11 10:57 | call_diagonal_spread | 2 | 1 | 600 | 112800.00 | short | ask | 19.6750 | 0.1400 | ["18.5","19.5"] | ["1.2671","0.5552"] | [] | ["XCBO"] | 18.5000 | 19.5000 | 0 | 7 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:57:18Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090cd-3418-7472-90bc-f6d673d98b20 | ETHA | 2026-09-11 10:09 | call_vertical_spread | 2 | 3 | 666 | 202462.00 | unknown | — | 19.7301 | 0.1000 | ["18","22"] | ["0.5560","0.5850"] | [] | ["XBOX","XCBO","XISX"] | 18.0000 | 22.0000 | 35 | 35 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:09:34Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08bd5-0850-7c60-a2e3-c04ba4aca2dc | ETHA | 2026-09-10 10:59 | call_vertical_spread | 2 | 1 | 2000 | 136000.00 | long | ask | 18.4300 | 0.0800 | ["28","38"] | ["0.6042","0.6877"] | ["28.34"] | ["XMIO"] | 28.0000 | 38.0000 | 127 | 127 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:00:02Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a06df6-0bcd-7b21-8c74-163a941464cb | ETHA | 2026-09-04 15:47 | other | 6 | 1 | 1778 | 240030.00 | unknown | — | 18.5250 | 0.1000 | ["17.5","18","18.5","19.5","20","21"] | ["0.5263","0.5069","0.9917","0.4903","9.5719","0.5351"] | [] | ["XPHO"] | 17.5000 | 21.0000 | 0 | 14 | false | false | true | true | true | mlat | market_whale | 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 |
| 01a06ddb-212d-7c13-9c2a-d7306a9b1cac | ETHA | 2026-09-04 15:17 | call_vertical_spread | 2 | 1 | 250 | 103500.00 | unknown | — | 18.5300 | 0.1700 | ["15","22"] | ["0.5440","0.5393"] | [] | ["XCBO"] | 15.0000 | 22.0000 | 42 | 42 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:18:22Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d52-9bf5-7e43-b8c9-2c4a900ca074 | ETHA | 2026-09-04 12:48 | other | 4 | 1 | 3530 | 501260.00 | unknown | — | 18.5750 | 0.0800 | ["17.5","18.5","19"] | ["0.4948","0.5332","0.9179"] | [] | ["XPHO"] | 17.5000 | 19.0000 | 0 | 14 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:48:56Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |