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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b563-7598-7020-8397-7495ed2b195e | ASML | 2026-09-18 12:39 | strangle | 2 | 2 | 25 | 607525.00 | long | ask | 1649.1500 | 7.7000 | ["1600","2900"] | ["0.4547","0.4800"] | ["1356.99","3143.01"] | ["AMXO"] | 1600.0000 | 2900.0000 | 272 | 272 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:40:19Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 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 |
| 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 |