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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5e9-7a2f-7b91-b69d-fed5ab8f50e7 | GDX | 2026-09-18 15:06 | other | 5 | 2 | 20 | 107550.00 | unknown | ask | 95.4000 | 3.4300 | ["75","80","89","90"] | ["0.4320","11.5935","0.4256","0.4046"] | [] | ["XCBO","XMIO"] | 75.0000 | 90.0000 | 0 | 490 | false | false | true | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:06:15Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5c4-98c7-7db0-9e68-d4964c95ff55 | GDX | 2026-09-18 14:25 | other | 4 | 1 | 3053 | 476268.00 | unknown | — | 95.4800 | 0.3000 | ["90","92","93","95"] | ["0.4218","1.3081","0.4043","0.4082"] | [] | ["XCBO"] | 90.0000 | 95.0000 | 0 | 7 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:26:06Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4fc-fb37-7910-ac64-72ee4c267208 | GDX | 2026-09-18 10:47 | other | 3 | 1 | 200 | 269100.00 | unknown | ask | 94.8000 | 1.1300 | ["85","100","120"] | ["3.1728","0.4380","0.4586"] | [] | ["XMIO"] | 85.0000 | 120.0000 | 0 | 91 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:48:18Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0ab98-e62b-76b3-a4a0-e4a33c57adb1 | GDX | 2026-09-16 15:01 | other | 4 | 1 | 3053 | 1059391.00 | unknown | — | 92.5300 | 0.8900 | ["86","92","97","100"] | ["0.5063","0.6317","0.4905","0.6560"] | [] | ["XPHO"] | 86.0000 | 100.0000 | 2 | 9 | false | true | true | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:02:02Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a09108-cde9-7c03-83c5-dc657acb4574 | GDX | 2026-09-11 11:14 | other | 5 | 1 | 6106 | 1312790.00 | unknown | — | 97.0200 | 0.5400 | ["90","92","95","100"] | ["1.8152","0.4690","0.4429","0.5497"] | [] | ["AMXO"] | 90.0000 | 100.0000 | 0 | 7 | false | true | true | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:14:58Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090df-6840-7f72-8b4c-94db1777aaef | GDX | 2026-09-11 10:29 | other | 4 | 1 | 4700 | 944700.00 | unknown | — | 97.8300 | 0.3500 | ["99","101","103","105"] | ["0.6648","0.4594","0.9153","0.4780"] | [] | ["EDGO"] | 99.0000 | 105.0000 | 0 | 7 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:29:23Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08682-c609-7d33-b61c-a99e63b7467b | GDX | 2026-09-09 10:11 | other | 2 | 1 | 17 | 155295.00 | unknown | — | 100.2300 | 4.7500 | ["55"] | ["2.8011"] | [] | ["MCRY"] | 55.0000 | 55.0000 | 2 | 30 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:12:08Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a06dd8-6dc5-7da1-a90a-4a8068922f06 | GDX | 2026-09-04 15:14 | other | 4 | 1 | 3053 | 286982.00 | unknown | — | 99.2900 | 0.1100 | ["90","95","96","99"] | ["0.4426","0.4015","2.1915","0.6784"] | [] | ["AMXO"] | 90.0000 | 99.0000 | 0 | 7 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:15:16Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |