core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg438,407 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 |
|---|
| 01a0cfab-c3fe-7b81-a4bc-acedf6f56de4 | JNJ | 2026-09-23 15:08 | call_diagonal_spread | 2 | 1 | 8 | 187912.00 | short | ask | 268.5700 | 4.5500 | ["150","170"] | ["0.3829","0.3531"] | [] | ["XCBO"] | 150.0000 | 170.0000 | 485 | 849 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-23T19:09:22Z"} | 2026-09-23 | 2026-09-23 17:15 | 2026-09-23 17:15 |
| 01a0b5e3-7338-7531-9399-6cdec5e35441 | JNJ | 2026-09-18 14:59 | call_calendar | 2 | 1 | 200 | 444000.00 | short | ask | 271.5500 | 0.7500 | ["270"] | ["0.2580"] | [] | ["XISX"] | 270.0000 | 270.0000 | 28 | 63 | false | false | true | false | |||||||||
| 01a0b5e2-1b78-78b0-b9a2-2319a3240f36 | JNJ | 2026-09-18 14:58 | call_calendar | 2 | 1 | 200 | 444000.00 | short | ask | 271.6300 | 0.7500 | ["270"] | ["0.2568"] | [] | ["XISX"] | 270.0000 | 270.0000 | 28 | 63 | false | false | true | false | |||||||||
| 01a0b030-583b-7f92-9b23-18c96b6d5f7d | JNJ | 2026-09-17 12:25 | call_diagonal_spread | 2 | 1 | 175 | 243250.00 | short | ask | 268.2000 | 1.9000 | ["260","300"] | ["0.5097","0.2368"] | [] | ["SPHR"] | 260.0000 | 300.0000 | 1 | 120 | false | false | true | true | |||||||||
| 01a08243-5f08-7f60-8c25-704168efb6a6 | JNJ | 2026-09-08 14:24 | call_calendar | 2 | 1 | 13 | 165620.00 | short | ask | 270.6550 | 4.9500 | ["210"] | ["0.3021"] | [] | ["XISX"] | 210.0000 | 210.0000 | 38 | 192 | false | false | true | false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:59:36Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:58:08Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:26:24Z"} |
| 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-08T18:24:11Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |