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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5c1-702f-7620-a308-8360922d1865 | GLD | 2026-09-18 14:22 | call_calendar | 2 | 1 | 9 | 275355.00 | short | bid | 402.5000 | 1.6000 | ["250"] | ["7.0055"] | [] | ["MCRY"] | 250.0000 | 250.0000 | 0 | 28 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:22:37Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b525-479f-74c2-8e9d-41f80313d61c | GLD | 2026-09-18 11:31 | call_calendar | 2 | 1 | 275 | 322850.00 | short | ask | 399.3700 | 0.4000 | ["470"] | ["0.2500"] | [] | ["XMIO"] | 470.0000 | 470.0000 | 119 | 154 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:32:11Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4c9-ae68-7201-8975-9360674e1ece | GLD | 2026-09-18 09:51 | call_calendar | 2 | 1 | 13 | 161005.00 | unknown | — | 399.0600 | 2.0000 | ["340"] | ["0.3182"] | [] | ["XCBO"] | 340.0000 | 340.0000 | 28 | 63 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:52:01Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0f0-ed03-71e3-b85a-679bf5805750 | GLD | 2026-09-17 15:56 | call_calendar | 2 | 1 | 400 | 240400.00 | short | ask | 398.5200 | 0.2700 | ["400"] | ["0.2333"] | [] | ["XMIO"] | 400.0000 | 400.0000 | 1 | 8 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:56:18Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |