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 |
|---|
| 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 |
|---|
| 01a0caa8-323f-7f91-a0cb-1cd5ab0296e1 | SOXX | 2026-09-22 15:46 | other | 3 | 1 | 15 | 118140.00 | unknown | bid | 571.8000 | 5.5000 | ["550","570"] | ["0.3792","0.3722"] | ["555.90"] | ["EDGO"] | 550.0000 | 570.0000 | 24 | 24 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T19:47:17Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c96b-9777-75e3-9ccf-bda1b60f5d0d | SOXX | 2026-09-22 10:01 | other | 4 | 1 | 4 | 37130.00 | unknown | bid | 562.9600 | 8.3000 | ["500","525","535","560"] | ["0.4266","0.4193","0.4185","0.4094"] | ["450.73"] | ["XCBO"] | 500.0000 | 560.0000 | 115 | 115 | false | true | false | true | |||||||||
| 01a0c4c6-851f-73a2-8592-dcb7ee4df5b4 | SOXX | 2026-09-21 12:22 | other | 4 | 1 | 15 | 98340.00 | unknown | ask | 555.4700 | 4.9000 | ["510","515","520","525"] | ["0.4155","0.4266","0.4083","0.4215"] | [] | ["XCBO"] | 510.0000 | 525.0000 | 39 | 60 | false | true | true | true | |||||||||
| 01a0b51e-5a2f-7883-bf98-e83b0c11c33d | SOXX | 2026-09-18 11:24 | other | 4 | 1 | 10 | 40620.00 | unknown | ask | 524.9250 | 7.3000 | ["520","525","530"] | ["0.3497","0.3915","0.3285"] | [] | ["XCBO"] | 520.0000 | 530.0000 | 0 | 21 | false | false | true | true | |||||||||
| 01a0afd7-b4d3-72c2-b065-624d7ee0ae2d | SOXX | 2026-09-17 10:49 | other | 3 | 1 | 140 | 813187.00 | unknown | — | 517.6200 | 7.3000 | ["520","530","585"] | ["0.3866","0.3904","0.3786"] | [] | ["XMIO"] | 520.0000 | 585.0000 | 64 | 64 | false | false | false | true | true | mlat | |||||||
| 01a0afd7-9593-7413-9cd1-a6f4981fc5fa | SOXX | 2026-09-17 10:48 | other | 3 | 1 | 50 | 290395.00 | unknown | — | 517.8630 | 7.3000 | ["520","530","585"] | ["0.3876","0.3894","0.3774"] | [] | ["XMIO"] | 520.0000 | 585.0000 | 64 | 64 | false | false | false | true | true | mlat | |||||||
| 01a0ab79-b5cb-7691-a760-675726102390 | SOXX | 2026-09-16 14:27 | other | 3 | 1 | 22 | 39523.00 | unknown | — | 504.8700 | 10.2000 | ["475","505","520"] | ["0.3885","0.3776","0.3855"] | [] | ["MCRY"] | 475.0000 | 520.0000 | 16 | 16 | false | false | false | true | true | mlat | |||||||
| 01a0a0a5-37f1-79c3-ba93-2357b82b0a05 | SOXX | 2026-09-14 11:59 | other | 2 | 1 | 21 | 849765.00 | unknown | — | 499.8200 | 14.1000 | ["300","310"] | ["0.6534","0.5169"] | [] | ["MCRY"] | 300.0000 | 310.0000 | 67 | 186 | false | false | true | true | false | mlat | |||||||
| 01a0a03f-e289-7743-ad6d-86bac5c2b469 | SOXX | 2026-09-14 10:08 | other | 3 | 1 | 750 | 2238030.00 | unknown | — | 501.3600 | 8.0000 | ["475","500","505"] | ["0.4140","0.3990","0.3964"] | [] | ["XCBO"] | 475.0000 | 505.0000 | 32 | 32 | false | false | false | true | false | mlat | |||||||
| 01a0a02e-d740-7b30-962f-b8412f5db60f | SOXX | 2026-09-14 09:50 | other | 3 | 1 | 1024 | 1301032.00 | unknown | — | 502.1800 | 3.5500 | ["400","480","500"] | ["0.5010","0.4094","0.4819"] | [] | ["XPHO"] | 400.0000 | 500.0000 | 4 | 32 | false | true | true | true | false | mlat | |||||||
| 01a091f8-d339-7520-ac9e-e4cc8c0f31c2 | SOXX | 2026-09-11 15:36 | other | 3 | 1 | 750 | 1808248.00 | unknown | — | 526.7300 | 0.8500 | ["425","500","565"] | ["0.4627","0.3816","0.3502"] | [] | ["XCBO"] | 425.0000 | 565.0000 | 35 | 35 | false | true | false | true | true | mlat | |||||||
| 01a08c9a-ec78-7643-9734-9805bbadb612 | SOXX | 2026-09-10 14:35 | other | 4 | 1 | 4 | 47528.00 | unknown | — | 519.2800 | 31.3000 | ["295","300","520","675"] | ["0.4913","0.4872","0.4447","0.4104"] | [] | ["XCBO"] | 295.0000 | 675.0000 | 645 | 645 | false | false | false | true | true | mlat | |||||||
| 01a08c81-7cc0-7771-8bae-1c4a15dddb46 | SOXX | 2026-09-10 14:08 | other | 4 | 1 | 10 | 37900.00 | unknown | — | 519.6800 | 9.4000 | ["490","495"] | ["0.4093","0.4074"] | [] | ["AMXO"] | 490.0000 | 495.0000 | 8 | 43 | false | true | true | true | false | mlat | |||||||
| 01a081b4-3698-7e71-872b-2b3981d4ab27 | SOXX | 2026-09-08 11:47 | other | 2 | 1 | 80 | 150400.00 | unknown | — | 533.6000 | 1.6000 | ["525","535"] | ["0.4451","0.4317"] | [] | ["XMIO"] | 525.0000 | 535.0000 | 10 | 10 | false | true | false | true | true | mlat |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:01:17Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:22:30Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:24:27Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:49:24Z"} |
| 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-17T14:48:58Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:27:53Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:00:00Z"} |
| 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-14T14:08:55Z"} |
| 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-14T13:50:24Z"} |
| 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-11T19:37:05Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:36:02Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:08:55Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:48:07Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |