Multi-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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a06d2b-68ce-7890-b95b-4f52a1d53403 | SNOW | 2026-09-04 12:05 | call_diagonal_spread_bearish | 2 | 1 | 18 | 107352.00 | long | bid | 347.4200 | 2.1750 | ["310","440"] | ["0.4744","0.4964"] | [] | ["XISX"] | 310.0000 | 440.0000 | 14 | 168 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:06:27Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d43-d6b5-7060-b9e7-98dd210042d3 | SNOW | 2026-09-04 12:32 | call_diagonal_spread_bearish | 2 | 1 | 35 | 542570.00 | long | ask | 343.3500 | 4.7000 | ["270","300"] | ["0.5146","0.5379"] | [] | ["XCBO"] | 270.0000 | 300.0000 | 42 | 196 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:32:51Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d48-188d-72d1-a119-6fb540d4181a | SNOW | 2026-09-04 12:37 | call_diagonal_spread_bearish | 2 | 1 | 100 | 1445100.00 | long | ask | 342.8250 | 9.2000 | ["280","300"] | ["0.4997","0.5173"] | [] | ["XCBO"] | 280.0000 | 300.0000 | 77 | 168 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:37:38Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d74-701d-7b20-bdce-963486d2efb9 | SNOW | 2026-09-04 13:25 | call_diagonal_spread_bearish | 2 | 1 | 20 | 812480.00 | long | bid | 342.6100 | 4.4500 | ["135","145"] | ["25.2349","2.8097"] | [] | ["XCBO"] | 135.0000 | 145.0000 | 0 | 7 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:25:52Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d90-b27d-73d1-afd1-c24747603f73 | SNOW | 2026-09-04 13:56 | call_diagonal_spread_bearish | 2 | 1 | 45 | 165870.00 | long | bid | 342.2800 | 2.0000 | ["330","400"] | ["0.4225","0.4394"] | [] | ["XCBO"] | 330.0000 | 400.0000 | 42 | 77 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:56:56Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06da0-5665-7a32-b949-258b6d1ffa0d | SNOW | 2026-09-04 14:13 | call_diagonal_spread_bearish | 2 | 1 | 69 | 498525.00 | long | ask | 341.7400 | 2.6500 | ["310","320"] | ["4.3712","0.4426"] | [] | ["XCBO"] | 310.0000 | 320.0000 | 0 | 77 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:13:45Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dcf-49ed-76e0-a160-9bb90af18b97 | SNOW | 2026-09-04 15:04 | call_diagonal_spread_bearish | 2 | 1 | 10 | 205010.00 | short | ask | 339.5500 | 12.8500 | ["300","310"] | ["0.5854","0.5484"] | [] | ["XISX"] | 300.0000 | 310.0000 | 378 | 469 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:05:17Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |