core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg637,282 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | direction |
|---|
| 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 |
|---|
| 01a0f8d6-ef57-7de3-b02c-ce1f17a6c9b9 | ORCL | 2026-10-01 15:00 | strangle | 2 | 1 | 5 | 102500.00 | long | ask | 137.9400 | 3.4000 | ["190","320"] | ["0.5583","0.8179"] | ["115","395.00"] | ["XMIO"] | 190.0000 | 320.0000 | 477 | 477 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-10-01T19:00:38Z"} | 2026-10-01 | 2026-10-01 17:15 | 2026-10-01 17:15 |
| 01a0f3a5-67f7-7853-b8dd-b40b32ee29bb | ORCL | 2026-09-30 14:48 | strangle | 2 | 1 | 20 | 410000.00 | short | bid | 137.9435 | 1.4500 | ["190","320"] | ["0.5571","0.8188"] | ["115","395.00"] | ["ARCO"] | 190.0000 | 320.0000 | 478 | 478 | false | false | false | ||||||||||
| 01a0e8bb-b85f-7a20-97c2-9aeaa8558419 | ORCL | 2026-09-28 11:56 | strangle | 2 | 8 | 63 | 113085.00 | short | bid | 132.4100 | 0.3548 | ["100","340"] | ["0.5745","0.5846"] | ["82.05","357.95"] | ["AMXO","EDGO","MCRY","XBOX","XCBO","XISX"] | 100.0000 | 340.0000 | 445 | 445 | false | true | false | ||||||||||
| 01a0da0a-9c9f-7553-8c7e-3dd4eeb79dac | ORCL | 2026-09-25 15:28 | strangle | 2 | 2 | 28 | 111860.00 | short | bid | 137.6450 | 0.6214 | ["145","155"] | ["0.5711","0.5578"] | ["105.05","194.95"] | ["XISX","XPHO"] | 145.0000 | 155.0000 | 175 | 175 | false | false | false | ||||||||||
| 01a0b040-1b63-7982-878c-f9244e67b50c | ORCL | 2026-09-17 12:43 | strangle | 2 | 1 | 1105 | 258570.00 | unknown | — | 150.6900 | 0.1700 | ["115","230"] | ["0.5404","0.5761"] | [] | ["XBOX"] | 115.0000 | 230.0000 | 64 | 64 | false | true | false | true | true | ||||||||
| 01a0abb6-9ba3-7170-b555-42a82ebd602a | ORCL | 2026-09-16 15:34 | strangle | 2 | 1 | 80 | 1572800.00 | long | ask | 142.1401 | 2.0000 | ["180","310"] | ["0.5507","0.7725"] | ["113.40","376.60"] | ["SPHR"] | 180.0000 | 310.0000 | 492 | 492 | false | false | false | ||||||||||
| 01a0a69f-793e-72f2-8058-a11b7d12cddf | ORCL | 2026-09-15 15:51 | strangle | 2 | 1 | 27 | 530901.00 | long | ask | 140.1650 | 1.9000 | ["180","310"] | ["0.5508","0.7669"] | ["113.37","376.63"] | ["EDGO"] | 180.0000 | 310.0000 | 493 | 493 | false | false | false | ||||||||||
| 01a0a67a-bafe-74c3-b565-9899ded5a316 | ORCL | 2026-09-15 15:10 | strangle | 2 | 1 | 30 | 588600.00 | short | bid | 141.2700 | 1.1000 | ["180","310"] | ["0.5492","0.7640"] | ["113.80","376.20"] | ["XMIO"] | 180.0000 | 310.0000 | 493 | 493 | false | false | false | ||||||||||
| 01a0a67a-bafe-74c3-b565-988cc2b034c0 | ORCL | 2026-09-15 15:10 | strangle | 2 | 1 | 20 | 392400.00 | short | bid | 141.2700 | 1.1000 | ["180","310"] | ["0.5492","0.7640"] | ["113.80","376.20"] | ["XMIO"] | 180.0000 | 310.0000 | 493 | 493 | false | false | false | ||||||||||
| 01a0a06c-c2d0-7160-9024-7fe6116379f0 | ORCL | 2026-09-14 10:57 | strangle | 2 | 4 | 54 | 102060.00 | long | ask | 143.9450 | 0.3176 | ["145","165"] | ["0.5279","0.5202"] | ["126.10","183.90"] | ["AMXO","XCBO","XISX","XPHO"] | 145.0000 | 165.0000 | 67 | 67 | false | false | false | ||||||||||
| 01a08cc1-3928-7cd1-9646-7603655fb99d | ORCL | 2026-09-10 15:17 | strangle | 2 | 1 | 150 | 245100.00 | long | ask | 154.6800 | 0.3500 | ["150","180"] | ["0.6895","0.7134"] | ["133.66","196.34"] | ["XISX"] | 150.0000 | 180.0000 | 36 | 36 | false | true | false | ||||||||||
| 01a08c75-ad50-7e51-9df2-3876282e82fb | ORCL | 2026-09-10 13:55 | strangle | 2 | 1 | 300 | 708000.00 | short | bid | 155.8300 | 0.5600 | ["175","250"] | ["1.1804","1.4117"] | ["151.40","273.60"] | ["SPHR"] | 175.0000 | 250.0000 | 8 | 8 | false | false | false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-30T18:48:52Z"} |
| 2026-09-30 |
| 2026-09-30 17:15 |
| 2026-09-30 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T15:57:02Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T19:28:46Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:43:16Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:34:37Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:51:26Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:11:20Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:11:20Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:58:06Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:17:47Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:55:22Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |