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 |
|---|
| 01a0c94f-4d4c-7092-b153-832e6c94b848 | FCX | 2026-09-22 09:30 | other | 4 | 2 | 15 | 111185.00 | unknown | — | 72.3950 | 13.6000 | ["35","45","60"] | ["0.4625","0.5924","0.4767"] | [] | ["XPHO"] | 35.0000 | 60.0000 | 115 | 850 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T13:30:04Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0b505-a5f7-7050-83dc-5a536e5605d1 | FCX | 2026-09-18 10:57 | other | 3 | 1 | 683 | 698770.00 | unknown | ask | 70.6000 | 0.5700 | ["70","72.5","75"] | ["0.4498","0.4540","0.9275"] | [] | ["XBOX"] | 70.0000 | 75.0000 | 0 | 28 | false | false | true | true | true | ||||||||
| 01a0b502-fa5f-76e2-9d06-74992b674763 | FCX | 2026-09-18 10:54 | other | 3 | 2 | 114 | 117078.00 | unknown | — | 70.7100 | 0.5700 | ["70","72.5","75"] | ["0.4593","0.4470","1.4417"] | [] | ["XBOX"] | 70.0000 | 75.0000 | 0 | 28 | false | false | true | true | true | mlet | |||||||
| 01a09123-52f8-7622-baf2-1bc459c313cb | FCX | 2026-09-11 11:43 | other | 2 | 1 | 74 | 115884.00 | unknown | — | 71.9700 | 0.5000 | ["65","70"] | ["0.4974","0.4841"] | [] | ["XMIO"] | 65.0000 | 70.0000 | 7 | 98 | false | false | true | true | false | mlat | |||||||
| 01a08cb7-f228-7422-8d33-b6cab7eab53f | FCX | 2026-09-10 15:07 | other | 4 | 1 | 88 | 200240.00 | unknown | — | 71.0200 | 4.2000 | ["78","79","80","82"] | ["1.8903","1.9951","2.3574","2.7618"] | [] | ["XBOX"] | 78.0000 | 82.0000 | 1 | 1 | false | false | false | true | false | mlft | |||||||
| 01a08c9a-38c8-7eb3-a24d-ec6cfdec0f2d | FCX | 2026-09-10 14:35 | other | 5 | 1 | 61 | 124160.00 | unknown | — | 70.8500 | 6.1500 | ["80","81","82","83","85"] | ["2.2087","2.2369","1.7371","2.3017","2.7657"] | [] | ["XBOX"] | 80.0000 | 85.0000 | 1 | 1 | false | false | false | true | false | mlft | |||||||
| 01a0871d-5088-79a3-885d-fd6c6ab40ed8 | FCX | 2026-09-09 13:00 | other | 2 | 1 | 1980 | 151800.00 | unknown | — | 76.9199 | 0.4200 | ["50","100"] | ["0.5886","0.5198"] | [] | ["AMXO"] | 50.0000 | 100.0000 | 72 | 72 | false | true | false | true | true | mlft | |||||||
| 01a08703-38d8-7a31-b2e1-02a61225ef27 | FCX | 2026-09-09 12:32 | other | 2 | 4 | 291 | 145850.00 | unknown | — | 76.5850 | 0.1000 | ["80","82.5"] | ["0.4920","0.4960"] | [] | ["EMLD","SPHR","XBOX","XMIO"] | 80.0000 | 82.5000 | 37 | 37 | false | true | false | true | false | mlet | |||||||
| 01a08157-f950-7972-bef8-85e7063fa9fa | FCX | 2026-09-08 10:06 | other | 3 | 1 | 25 | 101190.00 | unknown | — | 77.4803 | 6.1500 | ["65","80","90"] | ["0.5033","0.4430","0.4370"] | [] | ["XBOX"] | 65.0000 | 90.0000 | 829 | 829 | false | true | false | true | true | mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:57:43Z"} |
| 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:54: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-11T15:43:46Z"} |
| 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-10T19:07:57Z"} |
| 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-10T18:35:25Z"} |
| 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-09T17:00:55Z"} |
| 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-09T16:32:33Z"} |
| 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-08T14:07:11Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |