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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b095-a5d3-7b22-b20b-e2cf494658bc | CAT | 2026-09-17 14:16 | put_condor | 4 | 1 | 8 | 58208.00 | long | ask | 796.6100 | 17.7000 | ["790","795","805","810"] | ["0.3565","0.3488","0.3506","0.3455"] | ["790.84","809.16"] | ["XISX"] | 790.0000 | 810.0000 | 8 | 8 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:16:45Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afdd-f27b-7453-a95a-08e856930900 | CAT | 2026-09-17 10:55 | put_condor | 4 | 2 | 10 | 229100.00 | unknown | — | 795.3850 | 22.0500 | ["770","790","870","890"] | ["0.3673","0.3646","0.3661","0.3741"] | [] | ["XMIO"] | 770.0000 | 890.0000 | 29 | 29 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:56:05Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aa79-0ac3-7112-aa73-3fe2d7c81e84 | CAT | 2026-09-16 09:47 | put_condor | 4 | 1 | 5 | 44770.00 | short | bid | 788.3250 | 21.6200 | ["680","740","765","810"] | ["0.3870","0.3645","0.3620","0.3515"] | ["705.90","799.10"] | ["XPHO"] | 680.0000 | 810.0000 | 37 | 37 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:47:52Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa78-eb83-7631-a9ce-e1998d03ca4f | CAT | 2026-09-16 09:47 | put_condor | 4 | 1 | 5 | 44190.00 | long | ask | 787.5950 | 26.0900 | ["680","740","765","810"] | ["0.3953","0.3605","0.3566","0.3350"] | ["705.50","799.50"] | ["AMXO"] | 680.0000 | 810.0000 | 37 | 37 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:47:28Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a628-7095-7dc3-8700-d954253dbb0b | CAT | 2026-09-15 13:41 | put_condor | 4 | 1 | 10 | 74230.00 | unknown | — | 784.3550 | 12.2500 | ["665","735","755","780"] | ["0.3864","0.3697","0.3642","0.3608"] | [] | ["XPHO"] | 665.0000 | 780.0000 | 38 | 38 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:42:01Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a628-5d0e-7d21-bd7c-1017376ce7e2 | CAT | 2026-09-15 13:40 | put_condor | 4 | 1 | 5 | 42460.00 | long | ask | 784.4300 | 12.2100 | ["665","740","760","795"] | ["0.3900","0.3687","0.3606","0.3582"] | ["707.98","792.02"] | ["XPHO"] | 665.0000 | 795.0000 | 38 | 38 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:40:58Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a628-553d-7152-8fc3-da68a251e287 | CAT | 2026-09-15 13:40 | put_condor | 4 | 1 | 3 | 25500.00 | long | ask | 784.4250 | 12.2100 | ["665","740","760","795"] | ["0.3906","0.3689","0.3606","0.3585"] | ["708.02","791.98"] | ["XPHO"] | 665.0000 | 795.0000 | 38 | 38 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:40:58Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a628-35fd-7fd3-b714-4dc0a022a7f5 | CAT | 2026-09-15 13:40 | put_condor | 4 | 1 | 10 | 84190.00 | long | ask | 784.4250 | 12.5100 | ["665","740","760","795"] | ["0.3746","0.3674","0.3594","0.3586"] | ["707.69","792.31"] | ["AMXO"] | 665.0000 | 795.0000 | 38 | 38 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:40:58Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a08c-c238-7b93-a7ea-de7028453c06 | CAT | 2026-09-14 11:32 | put_condor | 4 | 1 | 8 | 157096.00 | unknown | — | 787.1750 | 24.1000 | ["745","800","820","880"] | ["0.3692","0.3817","0.3671","0.4203"] | [] | ["XISX"] | 745.0000 | 880.0000 | 25 | 25 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:33:04Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0910f-c710-7160-9fb7-7306174def68 | CAT | 2026-09-11 11:22 | put_condor | 4 | 1 | 7 | 112875.00 | short | bid | 820.4100 | 14.5000 | ["760","780","790","810"] | ["0.4156","0.4173","0.4150","0.4167"] | ["761.65","808.35"] | ["XCBO"] | 760.0000 | 810.0000 | 70 | 70 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:22:12Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0910f-55c8-7b63-aef1-c43dad49bd18 | CAT | 2026-09-11 11:21 | put_condor | 4 | 1 | 3 | 48753.00 | short | bid | 820.2100 | 12.1500 | ["760","780","790","810"] | ["0.4178","0.4174","0.4185","0.4183"] | ["761.65","808.35"] | ["ARCO"] | 760.0000 | 810.0000 | 70 | 70 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:21:40Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c1c-d720-70c1-ba27-cff63a331297 | CAT | 2026-09-10 12:18 | put_condor | 4 | 1 | 10 | 37440.00 | unknown | — | 801.7950 | 12.7000 | ["620","750","755","800"] | ["0.7561","0.3955","0.3929","0.3449"] | [] | ["XPHO"] | 620.0000 | 800.0000 | 15 | 15 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:18:30Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bde-0ce8-7591-974b-02c030eacc21 | CAT | 2026-09-10 11:09 | put_condor | 4 | 1 | 8 | 27936.00 | long | ask | 807.2800 | 12.5000 | ["800","805","810","815"] | ["0.4932","0.5032","0.4859","0.5033"] | ["801.06","813.94"] | ["XMIO"] | 800.0000 | 815.0000 | 1 | 1 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:09:58Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08702-8cf8-7a82-886a-96dc4bc49d1d | CAT | 2026-09-09 12:31 | put_condor | 4 | 1 | 10 | 272070.00 | unknown | — | 816.6100 | 16.5500 | ["640","760","800","880"] | ["0.4402","0.4224","0.4189","0.4168"] | [] | ["XPHO"] | 640.0000 | 880.0000 | 163 | 163 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:31:37Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08702-6200-7173-ae45-11ee4a355d80 | CAT | 2026-09-09 12:31 | put_condor | 4 | 1 | 10 | 273490.00 | short | bid | 816.6100 | 13.0000 | ["640","760","800","880"] | ["0.4399","0.4226","0.4223","0.4202"] | ["688.65","871.35"] | ["AMXO"] | 640.0000 | 880.0000 | 163 | 163 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:31:37Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08701-9eb0-7d13-81e3-84e4c0286648 | CAT | 2026-09-09 12:30 | put_condor | 4 | 2 | 2 | 46898.00 | short | bid | 816.0032 | 12.6250 | ["620","740","780","850"] | ["0.4348","0.4253","0.4216","0.4212"] | ["673.30","846.70"] | ["ARCO","XPHO"] | 620.0000 | 850.0000 | 163 | 163 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:30:42Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08136-859b-7600-809f-cd2ad03a7584 | CAT | 2026-09-08 09:30 | put_condor | 4 | 1 | 3 | 50214.00 | short | bid | 824.0200 | 30.3250 | ["700","720","780","800"] | ["0.4073","0.4086","0.4066","0.3998"] | ["701.80","798.20"] | ["XCBO"] | 700.0000 | 800.0000 | 129 | 129 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:30:07Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |