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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5c1-d5bf-7453-a800-1e146293e684 | CLS | 2026-09-18 14:22 | call_diagonal_spread | 2 | 1 | 10 | 151180.00 | long | bid | 332.2900 | 10.0000 | ["255","260"] | ["0.9714","0.7196"] | [] | ["BATO"] | 255.0000 | 260.0000 | 7 | 14 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:23:14Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0ab83-d3a3-74b2-9482-d00fd267ce90 | CLS | 2026-09-16 14:38 | call_diagonal_spread | 2 | 3 | 45 | 150328.00 | short | bid | 325.5100 | 3.9000 | ["360","400"] | ["0.6387","0.6800"] | [] | ["AMXO","XCBO","XISX"] | 360.0000 | 400.0000 | 30 | 93 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:38:57Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a091b1-2f60-7d63-a140-e5e398cfb40e | CLS | 2026-09-11 14:18 | call_diagonal_spread | 2 | 1 | 5 | 108200.00 | long | ask | 340.6300 | 11.1000 | ["300","330"] | ["0.7126","0.7163"] | [] | ["XPHO"] | 300.0000 | 330.0000 | 279 | 434 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:19:00Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09156-8c40-7292-b345-ab84d233af1a | CLS | 2026-09-11 12:39 | call_diagonal_spread | 2 | 1 | 9 | 133146.00 | long | bid | 339.9050 | 10.7000 | ["265","270"] | ["8.4072","1.1423"] | [] | ["XCBO"] | 265.0000 | 270.0000 | 0 | 7 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:39:54Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a086c3-8440-74e1-96bd-4541fd21fef8 | CLS | 2026-09-09 11:22 | call_diagonal_spread | 2 | 1 | 8 | 102840.00 | long | ask | 341.9300 | 6.9000 | ["310","320"] | ["0.7297","0.6896"] | [] | ["XMIO"] | 310.0000 | 320.0000 | 72 | 128 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:22:35Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08667-db69-7301-804f-efc2c84d2605 | CLS | 2026-09-09 09:42 | call_diagonal_spread | 2 | 2 | 74 | 139786.00 | short | bid | 339.4300 | 4.2000 | ["340","350"] | ["0.8542","0.7020"] | [] | ["ARCO","C2OX"] | 340.0000 | 350.0000 | 2 | 9 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:42:32Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |