Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
367,592 rowsCSV — whole table, not this view
Sources in this table
uw_multileg367,592 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c520-ce67-7ab3-b60e-352684c43f47 | SMH | 2026-09-21 14:00 | put_ratio_spread | 2 | 3 | 525 | 93981.00 | long | bid | 593.5900 | 0.0800 | ["450","500"] | ["0.5124","0.4227"] | ["498.83"] | ["XBOX","XCBO","XISX"] | 450.0000 | 500.0000 | 25 | 25 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:01:21Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b606-f50f-7f13-80c0-757f690c4b5a | SPX | 2026-09-18 15:38 | put_ratio_spread | 2 | 1 | 4 | 40930.00 | long | bid | 7640.3300 | 0.9000 | ["5800","6800"] | ["0.2918","0.2121"] | ["6730.44"] | ["XCBO"] | 5800.0000 | 6800.0000 | 154 | 154 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:38:38Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b544-7be7-7f70-af14-0742f7bd6259 | SPX | 2026-09-18 12:05 | put_ratio_spread | 2 | 1 | 6 | 31167.00 | long | bid | 7619.6700 | 1.3000 | ["7625","7650"] | ["0.0839","0.0838"] | ["7620.25"] | ["XCBO"] | 7625.0000 | 7650.0000 | 3 | 3 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:06:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b511-90bf-7270-ad3a-c28fc10f0075 | SNDK | 2026-09-18 11:10 | put_ratio_spread | 2 | 1 | 4 | 64348.00 | long | bid | 1715.4400 | 1.7000 | ["1730","1815"] | ["0.6594","0.6739"] | ["1717.38"] | ["XCBO"] | 1730.0000 | 1815.0000 | 7 | 7 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:10:52Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4ed-5b37-7b81-8ced-65b0d1118b85 | URA | 2026-09-18 10:30 | put_ratio_spread | 2 | 1 | 375 | 221750.00 | long | bid | 41.9300 | 0.6000 | ["42","47.5"] | ["0.4665","0.4060"] | ["42.32"] | ["XBOX"] | 42.0000 | 47.5000 | 7 | 7 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:30:58Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0a69c-ba1e-79f3-b58e-74c39890bc0e | SPY | 2026-09-15 15:48 | put_ratio_spread | 2 | 1 | 16 | 59600.00 | long | bid | 756.8700 | 0.5100 | ["772","779"] | ["0.1431","0.1428"] | ["755.06"] | ["MCRY"] | 772.0000 | 779.0000 | 45 | 45 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:48:34Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a682-9e86-7fd3-be84-67888c85ffe3 | SPY | 2026-09-15 15:19 | put_ratio_spread | 2 | 1 | 500 | 263397.00 | long | bid | 757.2000 | 0.0600 | ["680","745"] | ["0.2928","0.1694"] | ["740.39"] | ["XMIO"] | 680.0000 | 745.0000 | 15 | 15 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:20:10Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a050-da48-7f02-b122-a0f4c2c9ed5a | SNDK | 2026-09-14 10:27 | put_ratio_spread | 2 | 1 | 2 | 26459.00 | long | bid | 1554.0250 | 1.7000 | ["1570","1635"] | ["0.7892","0.7971"] | ["1554.35"] | ["XCBO"] | 1570.0000 | 1635.0000 | 4 | 4 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:27:44Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a024-6379-70f1-8ac3-e75f7a5af1fd | SNDK | 2026-09-14 09:38 | put_ratio_spread | 2 | 1 | 2 | 28311.00 | long | bid | 1512.0500 | 4.7000 | ["1530","1600"] | ["0.8513","0.8601"] | ["1513.15"] | ["XCBO"] | 1530.0000 | 1600.0000 | 4 | 4 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:38:53Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08c67-af48-70d0-8b8f-7e2350482cfd | SPY | 2026-09-10 13:39 | put_ratio_spread | 2 | 1 | 4398 | 661899.00 | long | bid | 758.0800 | 0.0300 | ["690","730"] | ["0.3204","0.2180"] | ["728.78"] | ["XMIO"] | 690.0000 | 730.0000 | 8 | 8 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:40:07Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08143-6f81-7230-b59f-773c030e6110 | QQQ | 2026-09-08 09:44 | put_ratio_spread | 2 | 1 | 44 | 99726.00 | long | bid | 717.0900 | 0.1900 | ["710","715"] | ["0.2011","0.1970"] | ["702.41"] | ["XISX"] | 710.0000 | 715.0000 | 38 | 38 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:44:44Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |