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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a06def-0ad6-72b1-a391-4ef6921a0125 | COST | 2026-09-04 15:39 | call_condor | 4 | 1 | 5 | 174475.00 | long | ask | 916.2900 | 23.3500 | ["1000","1100","1200","1300"] | ["0.2519","0.2516","0.2521","0.2544"] | ["1016.29","1283.71"] | ["ARCO"] | 1000.0000 | 1300.0000 | 742 | 742 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:39:39Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a08684-21b0-70e1-a7d6-d8da999701ae | COST | 2026-09-09 10:13 | call_condor | 4 | 1 | 5 | 169105.00 | short | bid | 906.3700 | 26.0000 | ["1000","1100","1200","1300"] | ["0.2560","0.2563","0.2547","0.2574"] | ["1015.73","1284.27"] | ["XCBO"] | 1000.0000 | 1300.0000 | 737 | 737 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:13:45Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08684-21b0-70e1-a7d6-d8cd3df16032 | COST | 2026-09-09 10:13 | call_condor | 4 | 1 | 5 | 169105.00 | short | bid | 906.3700 | 26.0000 | ["1000","1100","1200","1300"] | ["0.2560","0.2563","0.2547","0.2574"] | ["1015.73","1284.27"] | ["XCBO"] | 1000.0000 | 1300.0000 | 737 | 737 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:13:45Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08684-1dc8-7e80-8e44-9e0006244784 | COST | 2026-09-09 10:13 | call_condor | 4 | 1 | 5 | 169105.00 | short | bid | 906.3700 | 26.0000 | ["1000","1100","1200","1300"] | ["0.2560","0.2563","0.2547","0.2574"] | ["1015.73","1284.27"] | ["XCBO"] | 1000.0000 | 1300.0000 | 737 | 737 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:13:45Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08691-5c69-7ea1-ab24-f12766ad54c4 | COST | 2026-09-09 10:27 | call_condor | 4 | 1 | 15 | 503745.00 | short | bid | 902.0800 | 23.6000 | ["1000","1100","1200","1300"] | ["0.2570","0.2589","0.2568","0.2618"] | ["1015.75","1284.25"] | ["MCRY"] | 1000.0000 | 1300.0000 | 737 | 737 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:27:55Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0869f-0c50-7323-b2c0-48e21b7a9519 | COST | 2026-09-09 10:42 | call_condor | 4 | 2 | 3 | 100503.00 | short | bid | 904.0200 | 22.7500 | ["1000","1100","1200","1300"] | ["0.2543","0.2558","0.2562","0.2600"] | ["1015.53","1284.47"] | ["XISX","XPHO"] | 1000.0000 | 1300.0000 | 737 | 737 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:43:10Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0a16f-ded8-7e32-800b-28f63d646b46 | COST | 2026-09-14 15:40 | call_condor | 4 | 2 | 30 | 205320.00 | unknown | — | 920.0700 | 2.9500 | ["930","940","950","960"] | ["0.2387","0.2382","0.2377","0.2366"] | [] | ["BATO","XPHO"] | 930.0000 | 960.0000 | 32 | 32 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:41:14Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a61e-6646-7462-9d1d-338aa7b70bc2 | COST | 2026-09-15 13:30 | call_condor | 4 | 2 | 7 | 371315.00 | unknown | — | 907.5650 | 25.3500 | ["900","1000","1100","1200"] | ["0.2574","0.2545","0.2563","0.2557"] | [] | ["XISX","XPHO"] | 900.0000 | 1200.0000 | 857 | 857 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:30:34Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a62c-1a16-73e0-a4f7-23e60c14d442 | COST | 2026-09-15 13:45 | call_condor | 4 | 1 | 3 | 131460.00 | unknown | — | 908.5700 | 23.0000 | ["830","1030","1340","1540"] | ["0.2520","0.2534","0.2611","0.2658"] | [] | ["XPHO"] | 830.0000 | 1540.0000 | 822 | 822 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:45:55Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a62c-21e6-79a3-bd19-4d1455170480 | COST | 2026-09-15 13:45 | call_condor | 4 | 1 | 3 | 131460.00 | unknown | — | 908.5700 | 23.0000 | ["830","1030","1340","1540"] | ["0.2520","0.2534","0.2611","0.2658"] | [] | ["XPHO"] | 830.0000 | 1540.0000 | 822 | 822 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:45:55Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a62c-29b6-7153-a1f5-887cfc773c8f | COST | 2026-09-15 13:45 | call_condor | 4 | 1 | 3 | 131460.00 | unknown | — | 908.5700 | 23.0000 | ["830","1030","1340","1540"] | ["0.2520","0.2534","0.2611","0.2658"] | [] | ["XPHO"] | 830.0000 | 1540.0000 | 822 | 822 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:45:55Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a62f-b7de-71b2-a8ed-2b92eaec7e8e | COST | 2026-09-15 13:48 | call_condor | 4 | 1 | 3 | 131610.00 | unknown | — | 907.5500 | 22.5000 | ["830","1030","1340","1540"] | ["0.2550","0.2544","0.2618","0.2664"] | [] | ["XPHO"] | 830.0000 | 1540.0000 | 822 | 822 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:49:01Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a630-05fe-7470-a5d1-bd0884f492b0 | COST | 2026-09-15 13:49 | call_condor | 4 | 1 | 3 | 131613.00 | unknown | — | 907.5700 | 22.5000 | ["830","1030","1340","1540"] | ["0.2549","0.2544","0.2617","0.2663"] | [] | ["XPHO"] | 830.0000 | 1540.0000 | 822 | 822 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:50:10Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a630-4c4e-7ed0-a14d-f048aaf7fd73 | COST | 2026-09-15 13:49 | call_condor | 4 | 1 | 3 | 131676.00 | unknown | — | 907.5100 | 22.5000 | ["830","1030","1340","1540"] | ["0.2548","0.2551","0.2618","0.2664"] | [] | ["XPHO"] | 830.0000 | 1540.0000 | 822 | 822 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:50:10Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |