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 |
|---|
| 01a08bd4-e528-7b33-827b-22f4f8277eeb | MRK | 2026-09-10 10:59 | call_calendar | 2 | 1 | 54 | 489672.00 | short | bid | 144.4400 | 2.7500 | ["100"] | ["0.6045"] | [] | ["SPHR"] | 100.0000 | 100.0000 | 8 | 190 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:00:02Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bd4-f4c8-7a21-ab75-69f667f63694 | MRK | 2026-09-10 10:59 | call_calendar | 2 | 1 | 83 | 752644.00 | short | bid | 144.4350 | 2.7500 | ["100"] | ["0.6176"] | [] | ["SPHR"] | 100.0000 | 100.0000 | 8 | 190 | false | false | true | false | |||||||||
| 01a08c66-bd18-7913-b1da-348a70e166d4 | MRK | 2026-09-10 13:38 | call_calendar | 2 | 1 | 81 | 743904.00 | short | ask | 144.9800 | 2.6500 | ["100"] | ["0.6491"] | [] | ["XPHO"] | 100.0000 | 100.0000 | 8 | 190 | false | false | true | false | |||||||||
| 01a0a0a1-e460-7fc0-9e71-7c7a3f1c5b6c | MRK | 2026-09-14 11:55 | call_calendar | 2 | 2 | 40 | 167520.00 | short | bid | 145.2400 | 4.2500 | ["125"] | ["0.2566"] | [] | ["ARCO"] | 125.0000 | 125.0000 | 32 | 67 | false | false | true | false | |||||||||
| 01a0a0a1-fbd0-7d32-8556-bb3fb3b692ad | MRK | 2026-09-14 11:56 | call_calendar | 2 | 1 | 40 | 165790.00 | short | bid | 145.2000 | 3.4313 | ["125"] | ["0.2427"] | [] | ["XISX"] | 125.0000 | 125.0000 | 32 | 67 | false | false | true | false | |||||||||
| 01a0a0a2-22e0-7752-9ca7-ca4fc17b37ed | MRK | 2026-09-14 11:56 | call_calendar | 2 | 1 | 35 | 144830.00 | short | bid | 145.2100 | 2.7500 | ["125"] | ["0.2360"] | [] | ["XMIO"] | 125.0000 | 125.0000 | 32 | 67 | false | false | true | false | |||||||||
| 01a0a0a2-3668-7070-961b-588a79b0e89a | MRK | 2026-09-14 11:56 | call_calendar | 2 | 1 | 40 | 167200.00 | short | bid | 145.2450 | 2.7000 | ["125"] | ["0.2452"] | [] | ["XMIO"] | 125.0000 | 125.0000 | 32 | 67 | false | false | true | false | |||||||||
| 01a0a126-56a1-77e3-848e-b1902c0204c1 | MRK | 2026-09-14 14:20 | call_calendar | 2 | 1 | 12 | 134016.00 | short | ask | 145.2800 | 3.4500 | ["90"] | ["0.3593"] | [] | ["EDGO"] | 90.0000 | 90.0000 | 123 | 214 | false | false | true | false | |||||||||
| 01a0ca38-9bd7-7cf0-b2ad-d5eed996552c | MRK | 2026-09-22 13:45 | call_calendar | 2 | 1 | 21 | 336420.00 | short | ask | 151.7700 | 6.3500 | ["75"] | ["0.4399"] | [] | ["XISX"] | 75.0000 | 75.0000 | 486 | 850 | false | false | true | false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:00:02Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:39:29Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:55:58Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:56:40Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:56:40Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:56:40Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T18:21:00Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:45:01Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |