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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5d6-9257-7252-ab55-85a99b63a569 | INTC | 2026-09-18 14:45 | call_ratio_spread | 2 | 1 | 120 | 33480.00 | long | ask | 106.5450 | 0.1600 | ["101","110"] | ["2.0865","1.2647"] | ["106.54","113.46"] | ["XCBO"] | 101.0000 | 110.0000 | 0 | 0 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:45:45Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b09d-6632-7812-909a-b9c6d71756db | INTC | 2026-09-17 14:24 | call_ratio_spread | 2 | 1 | 494 | 179075.00 | long | ask | 110.4900 | 0.0800 | ["120","140"] | ["0.6487","0.6873"] | ["121.93","158.07"] | ["XISX"] | 120.0000 | 140.0000 | 29 | 29 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:25:36Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b09c-e933-7851-91b3-361d2e31f461 | INTC | 2026-09-17 14:24 | call_ratio_spread | 2 | 1 | 912 | 329232.00 | long | ask | 110.4900 | 0.0900 | ["120","140"] | ["0.6478","0.6858"] | ["121.94","158.06"] | ["XISX"] | 120.0000 | 140.0000 | 29 | 29 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:24:47Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afe1-172b-7fc3-a609-2006c369415d | INTC | 2026-09-17 10:59 | call_ratio_spread | 2 | 3 | 276 | 167762.00 | long | ask | 109.8699 | 0.1300 | ["115","135"] | ["0.6660","0.7050"] | ["118.33","168.34"] | ["XBOX","XCBO","XISX"] | 115.0000 | 135.0000 | 29 | 29 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:59:24Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afae-eb6b-7c33-bb22-0445f44b2bba | INTC | 2026-09-17 10:04 | call_ratio_spread | 2 | 1 | 700 | 720110.00 | unknown | — | 109.0350 | 0.2500 | ["110","120"] | ["0.6512","0.6684"] | [] | ["XPHO"] | 110.0000 | 120.0000 | 29 | 29 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:04:34Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a62b-898d-7110-a4cb-c3a79eaf6a47 | INTC | 2026-09-15 13:44 | call_ratio_spread | 2 | 1 | 1000 | 27000.00 | unknown | — | 97.4750 | 0.0300 | ["105","115"] | ["0.7288","0.8576"] | [] | ["XISX"] | 105.0000 | 115.0000 | 3 | 3 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:44:58Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a081e1-4d90-7c52-991b-76914502c20d | INTC | 2026-09-08 12:36 | call_ratio_spread | 2 | 1 | 687 | 1017905.00 | long | ask | 104.7050 | 0.3500 | ["110","125"] | ["0.7155","0.7336"] | ["110.74","153.51"] | ["XPHO"] | 110.0000 | 125.0000 | 73 | 73 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:37:41Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06db2-4ff5-7990-a61c-c66a6296c2af | INTC | 2026-09-04 14:33 | call_ratio_spread | 2 | 1 | 120 | 76200.00 | long | ask | 94.9050 | 0.3000 | ["86","93"] | ["3.9361","1.0342"] | ["91.10","94.90"] | ["XCBO"] | 86.0000 | 93.0000 | 0 | 0 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:33:34Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |