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 |
|---|
| 01a0ca5a-a2c7-7a70-a4a1-9e809a9e8de6 | XLF | 2026-09-22 14:22 | other | 6 | 7 | 2927 | 3585552.00 | unknown | ask | 54.9000 | 1.9500 | ["50","54","55","57","61"] | ["0.2037","0.1847","0.1692","0.1407","0.1825"] | [] | ["AMXO"] | 50.0000 | 61.0000 | 24 | 178 | false | false | true | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T18:22:22Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c9f1-f9cf-7be3-b670-f39bc2502279 | XLF | 2026-09-22 12:27 | other | 7 | 1 | 34830 | 23802840.00 | unknown | — | 54.8900 | 0.5800 | ["54","55","57","60","61","62"] | ["0.1839","0.1657","0.1492","0.1531","0.1561","0.1540"] | [] | ["AMXO"] | 54.0000 | 62.0000 | 17 | 178 | false | false | true | true | true | mlct | |||||||
| 01a0c4fc-0857-7332-86ed-5414d381c3a6 | XLF | 2026-09-21 13:20 | other | 4 | 3 | 64 | 35691.00 | unknown | — | 56.0350 | 0.4300 | ["54","55","56","57"] | ["0.1836","0.1792","0.2120","0.2106"] | [] | ["AMXO","ARCO","XPHO"] | 54.0000 | 57.0000 | 179 | 487 | false | false | true | true | false | mlet | |||||||
| 01a0b5d3-8ce8-73d2-89a6-aecec467e3ab | XLF | 2026-09-18 14:42 | other | 4 | 4 | 12500 | 14887500.00 | unknown | ask | 55.8850 | 0.3300 | ["50"] | ["2.4658"] | [] | ["AMXO"] | 50.0000 | 50.0000 | 0 | 28 | false | false | true | false | true | ||||||||
| 01a0b4e3-54cf-7383-8fcc-289ce85df0ad | XLF | 2026-09-18 10:19 | other | 3 | 2 | 12400 | 541334.00 | unknown | bid | 55.7800 | 0.0722 | ["54","57","61"] | ["0.1832","0.1317","0.1544"] | ["53.64"] | ["AMXO"] | 54.0000 | 61.0000 | 28 | 28 | false | true | false | true | true | ||||||||
| 01a0abab-7fe3-74c3-9207-c25672df42fc | XLF | 2026-09-16 15:22 | other | 4 | 5 | 7500 | 8523750.00 | unknown | — | 55.4850 | 0.4400 | ["50"] | ["0.4908"] | [] | ["AMXO"] | 50.0000 | 50.0000 | 2 | 30 | false | false | true | false | true | mlft | |||||||
| 01a0a651-70ae-7101-9e55-ca6e7e9eb83b | XLF | 2026-09-15 14:25 | other | 4 | 1 | 3000 | 354000.00 | unknown | — | 56.6400 | 0.0700 | ["55","56","58","59"] | ["0.1851","0.2000","0.1461","0.2516"] | [] | ["ARCO"] | 55.0000 | 59.0000 | 3 | 31 | false | true | true | true | true | mlct | |||||||
| 01a0a645-0116-73d0-b3b6-69db1f6d5256 | XLF | 2026-09-15 14:12 | other | 4 | 1 | 820 | 195000.00 | unknown | — | 56.6600 | 0.2200 | ["57","58"] | ["0.2072","0.2330"] | [] | ["XBOX"] | 57.0000 | 58.0000 | 3 | 3 | false | false | false | true | true | mlft | |||||||
| 01a091c5-1521-70b3-b9e5-ab285df168a7 | XLF | 2026-09-11 14:40 | other | 2 | 1 | 1000 | 130000.00 | unknown | — | 57.2150 | 0.0700 | ["57"] | ["0.1534"] | [] | ["ARCO"] | 57.0000 | 57.0000 | 7 | 35 | false | true | true | false | false | mlct | |||||||
| 01a091b8-e7f0-70b1-8481-3afa16f2c838 | XLF | 2026-09-11 14:26 | other | 3 | 3 | 1125 | 157750.00 | unknown | — | 57.2700 | 0.1400 | ["56","58"] | ["0.1732","0.1692"] | [] | ["AMXO"] | 56.0000 | 58.0000 | 7 | 35 | false | false | true | true | false | mlft | |||||||
| 01a091b2-8ef1-7620-8530-af72cb42314a | XLF | 2026-09-11 14:19 | other | 3 | 1 | 49500 | 5709000.00 | unknown | — | 57.3050 | 0.1500 | ["56","58"] | ["0.1729","0.1491"] | [] | ["AMXO"] | 56.0000 | 58.0000 | 7 | 35 | false | false | true | true | false | mlct | |||||||
| 01a091b2-5070-7c30-92d0-09c47ccf6bcc | XLF | 2026-09-11 14:19 | other | 3 | 1 | 135000 | 15570000.00 | unknown | — | 57.3050 | 0.1500 | ["56","58"] | ["0.1729","0.1491"] | [] | ["AMXO"] | 56.0000 | 58.0000 | 7 | 35 | false | false | true | true | false | mlct | |||||||
| 01a09199-6970-7312-9d68-f9007f1009be | XLF | 2026-09-11 13:52 | other | 2 | 1 | 810 | 31590.00 | unknown | — | 57.2900 | 0.0800 | ["57","57.5"] | ["0.1309","0.1089"] | [] | ["XBOX"] | 57.0000 | 57.5000 | 0 | 4 | false | false | true | true | false | mlat | |||||||
| 01a087ca-2a88-7e81-9b13-ab8e43a2eb10 | XLF | 2026-09-09 16:09 | other | 4 | 1 | 5000 | 1805000.00 | unknown | — | 57.0813 | 1.3500 | ["57"] | ["0.1669"] | [] | ["ARCO"] | 57.0000 | 57.0000 | 9 | 37 | false | false | true | false | true | mlct | |||||||
| 01a087af-0550-7e00-bac2-c0c1dab8d4af | XLF | 2026-09-09 15:39 | other | 2 | 1 | 27 | 136890.00 | unknown | — | 57.1850 | 3.4500 | ["30","35"] | ["0.7126","0.5064"] | [] | ["XBOX"] | 30.0000 | 35.0000 | 100 | 128 | false | false | true | true | false | mlet | |||||||
| 01a0878f-8ea1-7d32-a34b-4d03706d86ba | XLF | 2026-09-09 15:05 | other | 2 | 2 | 1200 | 81000.00 | unknown | — | 57.1450 | 0.0700 | ["48","53"] | ["0.2548","0.1970"] | [] | ["AMXO"] | 48.0000 | 53.0000 | 100 | 128 | false | true | true | true | false | mlft | |||||||
| 01a08751-e961-7003-a3cd-30d26788bffb | XLF | 2026-09-09 13:58 | other | 2 | 1 | 15000 | 1605000.00 | unknown | — | 57.1800 | 0.0700 | ["50"] | ["0.2218"] | [] | ["XBOX"] | 50.0000 | 50.0000 | 100 | 191 | false | true | true | false | false | mlct | |||||||
| 01a0869f-c3e8-7f62-9fec-469373297c8c | XLF | 2026-09-09 10:43 | other | 2 | 1 | 138 | 46920.00 | unknown | — | 57.2050 | 0.1900 | ["53","56"] | ["0.1972","0.1936"] | [] | ["EDGO"] | 53.0000 | 56.0000 | 128 | 281 | false | true | true | true | false | mlet | |||||||
| 01a08691-8f30-7ba0-95d9-fd4775f25ec9 | XLF | 2026-09-09 10:27 | other | 2 | 1 | 58700 | 1096600.00 | unknown | — | 57.2250 | 0.1100 | ["60.5","62"] | ["0.1551","0.1550"] | [] | ["SPHR"] | 60.5000 | 62.0000 | 23 | 100 | false | true | true | true | false | mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:28:26Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:20:47Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:42:16Z"} |
| 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-18T14:20:10Z"} |
| 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-16T19:22:22Z"} |
| 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-15T18:26:47Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:12:19Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:40:18Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:27:23Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:20:10Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:19:45Z"} |
| 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-11T17:53:04Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T20:11:19Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:39:51Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:05:47Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:58:35Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:43:47Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:28:23Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |