core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
Simplify Analyticsuw_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 |
|---|
| 01a06d28-ad95-7d41-a947-a82e2c635348 | SOXX | 2026-09-04 12:02 | put_calendar | 2 | 1 | 10 | 30860.00 | long | bid | 517.6700 | 4.0000 | ["480"] | ["0.3988"] | [] | ["XCBO"] | 480.0000 | 480.0000 | 42 | 77 | false | true | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:03:06Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a086d9-f270-7702-b081-3229b4c51412 | SOXX | 2026-09-09 11:47 | put_calendar | 2 | 7 | 10 | 142848.00 | long | ask | 530.8000 | 10.3000 | ["575"] | ["0.4164"] | [] | ["ARCO","BATO","C2OX","EDGO","EMLD","SPHR","XBOX"] | 575.0000 | 575.0000 | 100 | 128 | false | false | true | false | |||||||||
| 01a0a0ff-fe38-7a03-8a37-ef1967e4236c | SOXX | 2026-09-14 13:38 | put_calendar | 2 | 1 | 250 | 990000.00 | short | bid | 500.6100 | 5.3000 | ["510"] | ["0.3829"] | [] | ["AMXO"] | 510.0000 | 510.0000 | 4 | 32 | false | false | true | false | |||||||||
| 01a0a542-c7a3-7b53-804c-f5a325dcb0b1 | SOXX | 2026-09-15 09:30 | put_calendar | 2 | 3 | 6 | 40288.00 | short | bid | 501.0000 | 8.2667 | ["530"] | ["0.4461"] | [] | ["XISX"] | 530.0000 | 530.0000 | 3 | 31 | false | false | true | false | |||||||||
| 01a0a553-59ce-78b2-938a-8ccac360e8b7 | SOXX | 2026-09-15 09:48 | put_calendar | 2 | 1 | 20 | 606460.00 | short | bid | 502.8700 | 13.1000 | ["650"] | ["0.4345"] | [] | ["XCBO"] | 650.0000 | 650.0000 | 94 | 185 | false | false | true | false | |||||||||
| 01a0ab71-2e33-76e3-8ed2-902557157c97 | SOXX | 2026-09-16 14:18 | put_calendar | 2 | 1 | 32 | 213152.00 | short | ask | 507.0100 | 8.6000 | ["540"] | ["0.5293"] | [] | ["XCBO"] | 540.0000 | 540.0000 | 2 | 9 | false | false | true | false | |||||||||
| 01a0ab71-2a4b-7fb0-9240-4ebd70d5f20e | SOXX | 2026-09-16 14:18 | put_calendar | 2 | 1 | 4 | 26920.00 | short | ask | 507.0100 | 4.9000 | ["540"] | ["0.3831"] | [] | ["XISX"] | 540.0000 | 540.0000 | 2 | 9 | false | false | true | false | |||||||||
| 01a0b0e7-c543-79b0-b88b-88ef2a535cae | SOXX | 2026-09-17 15:46 | put_calendar | 2 | 1 | 25 | 58825.00 | unknown | — | 519.5700 | 1.9000 | ["520"] | ["0.3244"] | [] | ["XISX"] | 520.0000 | 520.0000 | 8 | 15 | false | false | true | false | false | mlet | |||||||
| 01a0b0ed-3f9b-7963-aeb2-11e7ccbb9038 | SOXX | 2026-09-17 15:52 | put_calendar | 2 | 1 | 50 | 33000.00 | short | bid | 519.7700 | 1.3500 | ["510"] | ["0.3499"] | [] | ["AMXO"] | 510.0000 | 510.0000 | 1 | 8 | false | true | true | false | |||||||||
| 01a0c9ef-cb37-79a1-85ab-ffe88575624f | SOXX | 2026-09-22 12:25 | put_calendar | 2 | 1 | 10 | 30290.00 | short | bid | 566.8400 | 3.6000 | ["550"] | ["0.3813"] | [] | ["XPHO"] | 550.0000 | 550.0000 | 24 | 31 | false | true | true | false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:47:45Z"} |
| 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-14T17:38:59Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T13:30:12Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T13:48:27Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:18:56Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:18:56Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:46:34Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:52:15Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:25:53Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |