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 |
| 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 |
| 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 |
| 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 |
| 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 |