core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg403,968 rowsexportable| idtext | tickertext | executed_at ↑timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext |
|---|
| 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 |
|---|
| 01a08673-7040-7aa1-8b0b-9abb2ec0cfa0 | OSCR | 2026-09-09 09:55 | put_vertical_spread | 2 | 1 | 1118 | 152048.00 | long | ask | 31.2550 | 0.3400 | ["28","30"] | ["0.7965","0.8022"] | ["29.40"] | ["EDGO"] | 28.0000 | 30.0000 | 9 | 9 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:55:07Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086e2-ef39-78f3-a3f3-d555bf73ae01 | OSCR | 2026-09-09 11:56 | call_vertical_spread | 2 | 1 | 73 | 105996.00 | unknown | — | 31.2800 | 0.6500 | ["23","25"] | ["2.5785","2.1675"] | [] | ["XMIO"] | 23.0000 | 25.0000 | 2 | 2 | false | false | false | true | false | ||||||||
| 01a09198-a239-7933-91b7-63484eb3e53f | OSCR | 2026-09-11 13:51 | call_frontspread | 2 | 1 | 10000 | 1450000.00 | long | bid | 33.3000 | 0.4200 | ["34","36"] | ["0.7053","0.8000"] | ["34.39","50.50"] | ["XPHO"] | 34.0000 | 36.0000 | 7 | 7 | false | true | false | true | |||||||||
| 01a0a0b9-2199-7ad2-a5be-c2a5397f0c89 | OSCR | 2026-09-14 12:21 | call_diagonal_spread | 2 | 1 | 62 | 127782.00 | long | ask | 33.7200 | 3.3500 | ["35","50"] | ["0.6850","0.6835"] | [] | ["XCBO"] | 35.0000 | 50.0000 | 459 | 858 | false | true | true | true | |||||||||
| 01a0aa77-e5cb-7fc0-afc8-265324d15988 | OSCR | 2026-09-16 09:46 | call_vertical_spread | 2 | 1 | 500 | 120000.00 | unknown | — | 31.5400 | 0.6800 | ["33","40"] | ["0.6849","0.7357"] | [] | ["XMIO"] | 33.0000 | 40.0000 | 30 | 30 | false | true | false | true | false | ||||||||
| 01a0afd9-3b73-7cb1-81ae-06859285261f | OSCR | 2026-09-17 10:50 | call_vertical_spread | 2 | 1 | 499 | 166666.00 | short | bid | 33.3950 | 0.4700 | ["33","40"] | ["0.6482","0.6805"] | ["35"] | ["ARCO"] | 33.0000 | 40.0000 | 29 | 29 | false | false | false | true | |||||||||
| 01a0afe5-d9eb-70c0-85e9-0a30e132b8de | OSCR | 2026-09-17 11:04 | call_diagonal_spread | 2 | 1 | 135 | 319545.00 | unknown | — | 32.9401 | 1.9500 | ["32","42"] | ["0.7193","0.6899"] | [] | ["XISX"] | 32.0000 | 42.0000 | 491 | 855 | false | false | true | true | false | ||||||||
| 01a0afee-cee3-7be3-bffc-ad268973942c | OSCR | 2026-09-17 11:14 | call_calendar | 2 | 3 | 32 | 128384.00 | short | ask | 33.1000 | 2.8500 | ["13"] | ["8.1501"] | [] | ["C2OX","EDGO","XCBO"] | 13.0000 | 13.0000 | 1 | 29 | false | false | true | false | |||||||||
| 01a0afef-bd2a-70a0-9dea-043cbb5e8280 | OSCR | 2026-09-17 11:15 | call_calendar | 2 | 3 | 32 | 128384.00 | short | ask | 33.0250 | 2.8500 | ["13"] | ["4.1741"] | [] | ["C2OX","EDGO","XCBO"] | 13.0000 | 13.0000 | 1 | 29 | false | false | true | false | |||||||||
| 01a0aff2-ce53-72c2-9085-efd759556b17 | OSCR | 2026-09-17 11:18 | call_calendar | 2 | 3 | 32 | 128384.00 | short | ask | 32.9800 | 2.8500 | ["13"] | ["5.0298"] | [] | ["C2OX","EDGO","XCBO"] | 13.0000 | 13.0000 | 1 | 29 | false | false | true | false | |||||||||
| 01a0aff3-7263-7092-bfbb-b019521837dd | OSCR | 2026-09-17 11:19 | call_calendar | 2 | 4 | 47 | 188594.00 | short | ask | 32.9450 | 2.8500 | ["13"] | ["5.4342"] | [] | ["BATO","C2OX","EDGO","XCBO"] | 13.0000 | 13.0000 | 1 | 29 | false | false | true | false | |||||||||
| 01a0aff4-975b-71d0-9c50-2a5c26dee965 | OSCR | 2026-09-17 11:20 | call_calendar | 2 | 3 | 32 | 128384.00 | short | ask | 32.9450 | 2.8500 | ["13"] | ["5.4050"] | [] | ["C2OX","EDGO","XCBO"] | 13.0000 | 13.0000 | 1 | 29 | false | false | true | false | |||||||||
| 01a0aff4-9372-7c13-bd99-e92cf5b7d6db | OSCR | 2026-09-17 11:20 | call_calendar | 2 | 3 | 32 | 128384.00 | short | ask | 32.9450 | 2.8500 | ["13"] | ["5.4050"] | [] | ["C2OX","EDGO","XCBO"] | 13.0000 | 13.0000 | 1 | 29 | false | false | true | false | |||||||||
| 01a0aff5-acb3-7ee2-a129-0e824d6067c0 | OSCR | 2026-09-17 11:21 | call_calendar | 2 | 3 | 32 | 128384.00 | short | ask | 32.9500 | 2.8500 | ["13"] | ["5.3576"] | [] | ["C2OX","EDGO","XCBO"] | 13.0000 | 13.0000 | 1 | 29 | false | false | true | false | |||||||||
| 01a0aff6-4cdb-7992-904f-56282916b2d3 | OSCR | 2026-09-17 11:22 | call_calendar | 2 | 3 | 32 | 128384.00 | short | ask | 32.9900 | 2.8500 | ["13"] | ["4.8964"] | [] | ["C2OX","EDGO","XCBO"] | 13.0000 | 13.0000 | 1 | 29 | false | false | true | false | |||||||||
| 01a0aff7-fa8b-71f2-a3b3-ff41be9f5a91 | OSCR | 2026-09-17 11:24 | call_calendar | 2 | 1 | 59 | 238242.00 | short | ask | 32.8650 | 2.8500 | ["13"] | ["6.7375"] | [] | ["XPHO"] | 13.0000 | 13.0000 | 1 | 29 | false | false | true | false | |||||||||
| 01a0aff8-390b-7dc1-81b2-cfb2fb705a73 | OSCR | 2026-09-17 11:24 | call_calendar | 2 | 1 | 28 | 113064.00 | short | ask | 32.8650 | 2.8500 | ["13"] | ["6.7375"] | [] | ["XPHO"] | 13.0000 | 13.0000 | 1 | 29 | false | false | true | false | |||||||||
| 01a0aff8-390b-7dc1-81b2-cfaa7949aeb1 | OSCR | 2026-09-17 11:24 | call_calendar | 2 | 1 | 34 | 137292.00 | short | ask | 32.8650 | 2.8500 | ["13"] | ["6.7375"] | [] | ["XPHO"] | 13.0000 | 13.0000 | 1 | 29 | false | false | true | false | |||||||||
| 01a0aff8-390b-7dc1-81b2-cf9f421cb4ec | OSCR | 2026-09-17 11:24 | call_calendar | 2 | 1 | 43 | 173634.00 | short | ask | 32.8650 | 2.8500 | ["13"] | ["6.7375"] | [] | ["XPHO"] | 13.0000 | 13.0000 | 1 | 29 | false | false | true | false | |||||||||
| 01a0aff8-778b-7fa3-aa02-c83aeb96d56e | OSCR | 2026-09-17 11:24 | call_calendar | 2 | 1 | 25 | 100950.00 | short | ask | 32.8900 | 2.8500 | ["13"] | ["6.6174"] | [] | ["XPHO"] | 13.0000 | 13.0000 | 1 | 29 | false | false | true | false | |||||||||
| 01a0b02d-7dc3-7ce2-897d-8f681b135250 | OSCR | 2026-09-17 12:22 | call_diagonal_spread | 2 | 1 | 360 | 898200.00 | long | bid | 33.1200 | 2.2500 | ["30","40"] | ["0.7130","0.6842"] | [] | ["XCBO"] | 30.0000 | 40.0000 | 491 | 855 | false | false | true | true |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:56:55Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T17:52:12Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:21:22Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:46:20Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:50:55Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:04:29Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:14:19Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:15:31Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:18:41Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:19:52Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:21:15Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:21:15Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:22:02Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:22:46Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:24:56Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:24:56Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:24:56Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:24:56Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:24:56Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:23:09Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |