Simplify AnalyticsMulti-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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b61a-84e0-74f1-9a2b-3ce4ef50887c | DRAM | 2026-09-18 15:59 | risk_reversal | 3 | 4 | 28 | 113608.00 | long | ask | 59.6250 | 7.1000 | ["25","65","87"] | ["0.6076","0.6222","0.6277"] | ["67.92"] | ["ARCO","EMLD","SPHR","XPHO"] | 25.0000 | 87.0000 | 819 | 819 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:59:54Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a08298-9770-7712-919b-2af70af6254e | DRAM | 2026-09-08 15:57 | risk_reversal | 3 | 1 | 47 | 204403.00 | long | ask | 60.9350 | 6.8300 | ["25","65","87"] | ["0.6214","0.6453","0.6515"] | ["67.65"] | ["XPHO"] | 25.0000 | 87.0000 | 829 | 829 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:57:23Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0823b-67f8-7311-b4f9-4b56721f3d0b | DRAM | 2026-09-08 14:15 | risk_reversal | 3 | 1 | 53 | 241044.00 | long | ask | 61.9850 | 3.0400 | ["25","65","87"] | ["0.6289","0.6542","0.6607"] | ["67.70"] | ["EDGO"] | 25.0000 | 87.0000 | 829 | 829 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:16:09Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0823b-6029-76c0-9a6e-2ca9272796f5 | DRAM | 2026-09-08 14:15 | risk_reversal | 3 | 3 | 42 | 191008.00 | long | ask | 61.9850 | 3.0400 | ["25","65","87"] | ["0.6288","0.6542","0.6607"] | ["67.70"] | ["BATO","C2OX","EDGO"] | 25.0000 | 87.0000 | 829 | 829 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:16:09Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06d82-5a9d-72e0-9068-fc468a5f2aac | DRAM | 2026-09-04 13:40 | risk_reversal | 2 | 1 | 800 | 171200.00 | long | bid | 58.9000 | 0.1300 | ["49","75"] | ["0.6250","0.6361"] | ["48.82"] | ["AMXO"] | 49.0000 | 75.0000 | 42 | 42 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:41:43Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d2e-ef25-7521-81ac-35f71b68b162 | DRAM | 2026-09-04 12:09 | risk_reversal | 2 | 4 | 998 | 237124.00 | long | ask | 58.9100 | 0.0200 | ["55","62"] | ["0.5676","0.5493"] | ["62.35"] | ["AMXO","XCBO","XISX","XPHO"] | 55.0000 | 62.0000 | 14 | 14 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:09:48Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |