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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b55e-7457-7213-9d2f-578a963d9e35 | SPX | 2026-09-18 12:34 | call_ratio_spread | 2 | 1 | 4 | 41000.00 | unknown | bid | 7621.5500 | 0.9000 | ["7605","7690"] | ["0.1156","0.1035"] | ["7701.67"] | ["XCBO"] | 7605.0000 | 7690.0000 | 14 | 14 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:34:41Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0ab93-219b-7bf2-a284-a1e9c6829e39 | SPX | 2026-09-16 14:55 | call_ratio_spread | 2 | 1 | 2 | 80285.00 | long | ask | 7565.9600 | 20.5000 | ["6900","7635"] | ["0.2673","0.1318"] | ["7468.45","7801.55"] | ["XCBO"] | 6900.0000 | 7635.0000 | 16 | 16 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:55:55Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab8e-4b53-7b80-a214-838dbe2d9d0d | SPX | 2026-09-16 14:50 | call_ratio_spread | 2 | 1 | 4 | 73233.00 | unknown | — | 7588.4000 | 2.7000 | ["7600","7655"] | ["0.1341","0.1272"] | [] | ["XCBO"] | 7600.0000 | 7655.0000 | 30 | 30 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:50:24Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aaa8-a25b-70e3-bc14-4a7c6e1141b4 | SPX | 2026-09-16 10:39 | call_ratio_spread | 2 | 1 | 2 | 45625.00 | long | ask | 7605.2400 | 2.2000 | ["7450","7650"] | ["0.1598","0.1324"] | ["7484.05","7815.95"] | ["XCBO"] | 7450.0000 | 7650.0000 | 30 | 30 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:40:02Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a61f-a696-7ac3-ada8-d57e36565656 | SPX | 2026-09-15 13:31 | call_ratio_spread | 2 | 1 | 6 | 30909.00 | unknown | — | 7581.7600 | 0.4000 | ["7575","7585"] | ["0.2041","0.2007"] | [] | ["XCBO"] | 7575.0000 | 7585.0000 | 1 | 1 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:32:16Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a561-34ae-7541-bdf8-e5cfc521a843 | SPX | 2026-09-15 10:03 | call_ratio_spread | 2 | 1 | 3 | 32709.00 | long | ask | 7603.1800 | 1.0000 | ["7680","7955"] | ["0.1339","0.1146"] | ["7765.58","8333.85"] | ["XCBO"] | 7680.0000 | 7955.0000 | 45 | 45 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:03:51Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a08cf5-2df0-76e3-8d92-40c2e0582131 | SPX | 2026-09-10 16:14 | call_ratio_spread | 2 | 1 | 20 | 33780.00 | long | ask | 7591.7000 | 0.4500 | ["7675","7800"] | ["0.1398","0.1182"] | ["7697.30","7902.70"] | ["XCBO"] | 7675.0000 | 7800.0000 | 7 | 7 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a086e6-17d0-7682-b96f-07306b28957a | SPX | 2026-09-09 12:00 | call_ratio_spread | 2 | 1 | 2 | 29471.00 | long | ask | 7635.5700 | 1.1000 | ["7775","8000"] | ["0.1317","0.1212"] | ["7795.55","8204.45"] | ["XCBO"] | 7775.0000 | 8000.0000 | 82 | 82 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:00:46Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0814d-c7f0-7060-8553-6ed02a4b17aa | SPX | 2026-09-08 09:55 | call_ratio_spread | 2 | 1 | 5 | 162825.00 | long | ask | 7693.8400 | 1.9000 | ["7650","7800"] | ["0.1426","0.1339"] | ["8045.35"] | ["XCBO"] | 7650.0000 | 7800.0000 | 101 | 101 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:55:55Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |