Simplify AnalyticsMulti-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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c45b-e827-7062-be42-5bc8d93cf83e | ASML | 2026-09-21 10:25 | strangle | 2 | 2 | 2 | 112104.00 | short | bid | 1685.7650 | 27.9000 | ["1840","2060"] | ["0.4690","0.4555"] | ["1279.48","2620.52"] | ["EDGO","XISX"] | 1840.0000 | 2060.0000 | 361 | 361 | true | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:26:01Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0820c-b2f0-7a40-87a3-6fda747e34e5 | ASML | 2026-09-08 13:24 | strangle | 2 | 5 | 5 | 112500.00 | long | ask | 1768.7900 | 5.8000 | ["1620","2000"] | ["0.4528","0.4607"] | ["1395","2225.00"] | ["AMXO","C2OX","XCBO","XISX","XPHO"] | 1620.0000 | 2000.0000 | 129 | 129 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:24:40Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08176-df78-7e61-879e-e7e6d1ba4cf9 | ASML | 2026-09-08 10:40 | strangle | 2 | 3 | 25 | 527608.00 | long | ask | 1752.1600 | 5.6000 | ["1660","1840"] | ["0.4671","0.4708"] | ["1448.96","2051.04"] | ["C2OX","XBOX","XCBO"] | 1660.0000 | 1840.0000 | 73 | 73 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:41:10Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06d60-efed-7d21-a723-77619c654b5e | ASML | 2026-09-04 13:04 | strangle | 2 | 2 | 2 | 137832.00 | short | bid | 1711.3000 | 20.6000 | ["1940","2100"] | ["0.4697","0.4526"] | ["1250.84","2789.16"] | ["AMXO","ARCO"] | 1940.0000 | 2100.0000 | 469 | 469 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:04:36Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d5c-5ff5-7131-a912-93dd78146ce2 | ASML | 2026-09-04 12:59 | strangle | 2 | 2 | 2 | 137834.00 | long | ask | 1712.0600 | 22.0000 | ["1940","2100"] | ["0.4705","0.4517"] | ["1250.83","2789.17"] | ["XISX","XPHO"] | 1940.0000 | 2100.0000 | 469 | 469 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:59:45Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d5b-7d65-7a13-adfc-961b95ffcd86 | ASML | 2026-09-04 12:58 | strangle | 2 | 2 | 2 | 137834.00 | long | ask | 1712.0800 | 15.1500 | ["1940","2100"] | ["0.4695","0.4527"] | ["1250.83","2789.17"] | ["ARCO","XPHO"] | 1940.0000 | 2100.0000 | 469 | 469 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:59:09Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |