core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg473,794 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric |
|---|
| 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 |
|---|
| 01a0d3c7-08ff-7812-a291-4e324e6e2bc6 | FCX | 2026-09-24 10:17 | call_diagonal_spread | 2 | 1 | 56 | 215096.00 | unknown | bid | 71.6100 | 2.5000 | ["55","65"] | ["0.4489","0.4685"] | [] | ["XISX"] | 55.0000 | 65.0000 | 113 | 484 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T14:17:22Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0d3c2-2ecf-7f73-a032-e2ea7c3c9340 | FCX | 2026-09-24 10:11 | put_calendar | 2 | 2 | 3000 | 3146230.00 | unknown | ask | 71.6200 | 3.3720 | ["76"] | ["1.0323"] | [] | ["XISX"] | 76.0000 | 76.0000 | 1 | 8 | false | false | |||||||||||
| 01a0d39c-b8f7-7bb1-9fa0-fc45de85f222 | FCX | 2026-09-24 09:30 | call_diagonal_spread | 2 | 1 | 39 | 117936.00 | unknown | ask | 71.2920 | 11.6750 | ["80","95"] | ["0.4796","0.4804"] | [] | ["XISX"] | 80.0000 | 95.0000 | 484 | 848 | false | true | |||||||||||
| 01a0cea7-b5c7-76a3-8708-1437d15708ef | FCX | 2026-09-23 10:24 | put_calendar | 2 | 1 | 333 | 376290.00 | short | bid | 71.7500 | 1.6000 | ["77"] | ["0.6576"] | [] | ["EDGO"] | 77.0000 | 77.0000 | 2 | 9 | false | false | true | ||||||||||
| 01a0cea7-b5c7-76a3-8708-142b348a84b8 | FCX | 2026-09-23 10:24 | put_calendar | 2 | 3 | 667 | 694952.00 | unknown | bid | 71.7650 | 2.5305 | ["77"] | ["0.7353"] | [] | ["BATO","XBOX"] | 77.0000 | 77.0000 | 2 | 9 | false | false | |||||||||||
| 01a0ca1d-304f-7493-9a1c-2e2ebdd8f501 | FCX | 2026-09-22 13:15 | call_calendar | 2 | 1 | 157 | 1315660.00 | short | bid | 74.0850 | 5.1500 | ["33"] | ["0.7619"] | [] | ["XPHO"] | 33.0000 | 33.0000 | 115 | 486 | false | false | |||||||||||
| 01a0c9b7-c75f-7372-b052-29eb0e9b7595 | FCX | 2026-09-22 11:24 | put_calendar | 2 | 1 | 59 | 193461.00 | short | bid | 73.6850 | 3.3000 | ["75"] | ["0.5070"] | [] | ["BATO"] | 75.0000 | 75.0000 | 486 | 815 | false | false | true | ||||||||||
| 01a0c94f-7071-7cc2-aac4-2958dc983abf | FCX | 2026-09-22 09:30 | call_vertical_spread | 2 | 1 | 115 | 118450.00 | short | bid | 72.4050 | 1.5100 | ["80","100"] | ["0.4783","0.4926"] | ["84.30"] | ["XMIO"] | 80.0000 | 100.0000 | 178 | 178 | false | true | |||||||||||
| 01a0c94f-4d4c-7092-b153-8337ff34e989 | FCX | 2026-09-22 09:30 | call_diagonal_spread | 2 | 1 | 68 | 267240.00 | short | ask | 72.3950 | 5.3500 | ["80","85"] | ["0.4831","0.4636"] | [] | ["XISX"] | 80.0000 | 85.0000 | 815 | 850 | false | true | |||||||||||
| 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 | |||||||||
| 01a0c506-c657-72f2-89b6-c199d58fc3a6 | FCX | 2026-09-21 13:32 | call_diagonal_spread | 2 | 1 | 72 | 246384.00 | long | bid | 71.7450 | 1.5500 | ["55","60"] | ["0.5028","0.4762"] | [] | ["ARCO"] | 55.0000 | 60.0000 | 88 | 151 | false | false | |||||||||||
| 01a0b5b9-84d7-7322-a3b3-54f82d4907c8 | FCX | 2026-09-18 14:13 | call_butterfly_spread | 3 | 3 | 282 | 117829.00 | unknown | ask | 71.5000 | 0.3900 | ["75","85","95"] | ["0.4708","0.4747","0.4899"] | ["75.25","94.75"] | ["C2OX","EDGO","XPHO"] | 75.0000 | 95.0000 | 63 | 63 | false | true | |||||||||||
| 01a0b599-1bf7-7d32-a4de-8cd0e61c7e02 | FCX | 2026-09-18 13:38 | call_diagonal_spread | 2 | 1 | 16 | 104464.00 | long | ask | 71.5500 | 3.2000 | ["45","47.5"] | ["0.4459","0.4508"] | [] | ["BATO"] | 45.0000 | 47.5000 | 490 | 854 | false | false | |||||||||||
| 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 | |||||||||
| 01a0b0b4-16cb-7ed3-870f-6c9dc6237a83 | FCX | 2026-09-17 14:49 | call_calendar | 2 | 1 | 45 | 151065.00 | long | bid | 70.9550 | 1.0500 | ["55"] | ["1.3627"] | [] | ["AMXO"] | 55.0000 | 55.0000 | 1 | 92 | false | false | true | ||||||||||
| 01a0b03c-46eb-7fe3-bcb3-2bd59ff0bbd7 | FCX | 2026-09-17 12:38 | call_diagonal_spread | 2 | 1 | 14 | 101850.00 | unknown | — | 70.9800 | 0.7250 | ["30","40"] | ["7.0583","0.5377"] | [] | ["MCRY"] | 30.0000 | 40.0000 | 1 | 120 | false | false | true | true | |||||||||
| 01a0aff4-54f3-7031-906a-7d44e1dc022e | FCX | 2026-09-17 11:20 | call_diagonal_spread | 2 | 1 | 182 | 128492.00 | unknown | — | 71.0700 | 0.3500 | ["85","95"] | ["0.4795","0.4884"] | [] | ["C2OX"] | 85.0000 | 95.0000 | 120 | 183 | false | true | true | true | |||||||||
| 01a0aff4-54f3-7031-906a-7d3b04f3825a | FCX | 2026-09-17 11:20 | call_diagonal_spread | 2 | 1 | 182 | 128492.00 | unknown | — | 71.0950 | 0.4000 | ["85","95"] | ["0.4790","0.4880"] | [] | ["ARCO"] | 85.0000 | 95.0000 | 120 | 183 | false | true | true | true | |||||||||
| 01a0aabc-b313-7d83-ae43-510f9d02811d | FCX | 2026-09-16 11:01 | call_diagonal_spread | 2 | 2 | 128 | 256640.00 | unknown | — | 69.9150 | 2.1000 | ["70","75"] | ["0.4721","0.4652"] | [] | ["ARCO"] | 70.0000 | 75.0000 | 184 | 274 | false | true | true | true | |||||||||
| 01a0aa7a-f6f3-7e62-8e18-8a1988b63e6d | FCX | 2026-09-16 09:49 | call_calendar | 2 | 1 | 57 | 150081.00 | unknown | — | 69.7164 | 2.4500 | ["70"] | ["0.4703"] | [] | ["XMIO"] | 70.0000 | 70.0000 | 274 | 366 | false | true | true | false | false | ||||||||
| 01a0a5bc-6085-7c51-ac9c-39a9f65e4b87 | FCX | 2026-09-15 11:42 | call_ladder | 3 | 1 | 110 | 362614.00 | unknown | — | 68.6025 | 2.4000 | ["60","70","100"] | ["0.4779","0.4826","0.4874"] | [] | ["XCBO"] | 60.0000 | 100.0000 | 493 | 493 | false | false | false | true | |||||||||
| 01a08c65-3678-7b40-858b-a43e33e132ac | FCX | 2026-09-10 13:37 | put_calendar | 2 | 1 | 3000 | 3381000.00 | unknown | — | 70.8200 | 1.0500 | ["76"] | ["0.6235"] | [] | ["XCBO"] | 76.0000 | 76.0000 | 1 | 15 | false | false | true | false | false | ||||||||
| 01a08c61-d348-75b3-89c1-fb5710937e06 | FCX | 2026-09-10 13:33 | put_calendar | 2 | 1 | 333 | 442224.00 | short | bid | 70.8800 | 1.5500 | ["77"] | ["0.8473"] | [] | ["XMIO"] | 77.0000 | 77.0000 | 1 | 15 | false | false | true | ||||||||||
| 01a08c61-d348-75b3-89c1-fb44c02ea5ea | FCX | 2026-09-10 13:33 | put_calendar | 2 | 1 | 333 | 441306.00 | short | bid | 70.8700 | 1.5500 | ["77"] | ["0.8126"] | [] | ["EDGO"] | 77.0000 | 77.0000 | 1 | 15 | false | false | true | ||||||||||
| 01a08c61-d348-75b3-89c1-fb3042582f24 | FCX | 2026-09-10 13:33 | put_calendar | 2 | 1 | 334 | 439230.00 | short | bid | 70.9100 | 1.6000 | ["77"] | ["0.8834"] | [] | ["XBOX"] | 77.0000 | 77.0000 | 1 | 15 | false | false | true | ||||||||||
| 01a08c26-6858-76a3-9923-8ab213fe293d | FCX | 2026-09-10 12:28 | call_diagonal_spread | 2 | 1 | 27 | 134703.00 | long | ask | 70.9601 | 2.0500 | ["50","55"] | ["0.4787","0.4721"] | [] | ["XISX"] | 50.0000 | 55.0000 | 280 | 498 | false | false | |||||||||||
| 01a08c0d-5e30-7031-b89f-1d82aefc743f | FCX | 2026-09-10 12:01 | call_vertical_spread | 2 | 7 | 700 | 124895.00 | unknown | — | 70.9700 | 0.2000 | ["80","90"] | ["0.4753","0.5011"] | [] | ["AMXO","ARCO","C2OX","EDGO","XCBO","XISX","XPHO"] | 80.0000 | 90.0000 | 36 | 36 | false | true | false | true | |||||||||
| 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 | |||||||||
| 01a0826d-12d0-7992-98ac-251aa12f014e | FCX | 2026-09-08 15:09 | call_diagonal_spread | 2 | 1 | 27 | 128034.00 | unknown | — | 77.1250 | 2.8500 | ["60","65"] | ["0.4937","0.4806"] | [] | ["XCBO"] | 60.0000 | 65.0000 | 282 | 500 | false | false | true | true | |||||||||
| 01a0815b-a6b8-7421-905c-8c6cd18413a9 | FCX | 2026-09-08 10:11 | call_vertical_spread | 2 | 1 | 300 | 101700.00 | unknown | — | 77.7580 | 0.4700 | ["95","105"] | ["0.5200","0.5313"] | [] | ["XISX"] | 95.0000 | 105.0000 | 73 | 73 | false | true | false | true | |||||||||
| 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 | |||||||||
| 01a06dfe-06c5-7952-aeb3-f20af38c9a7f | FCX | 2026-09-04 15:55 | call_frontspread | 2 | 2 | 26 | 157396.00 | long | bid | 72.7000 | 3.8000 | ["50","55"] | ["0.4496","0.4554"] | ["50.08","114.00"] | ["XMIO"] | 50.0000 | 55.0000 | 833 | 833 | false | false | |||||||||||
| 01a06dc9-2b86-7150-8fc7-b1e5dad69838 | FCX | 2026-09-04 14:58 | call_diagonal_spread_bearish | 2 | 1 | 133 | 245385.00 | long | bid | 72.8800 | 1.8500 | ["62","66"] | ["8.8144","0.4799"] | [] | ["EDGO"] | 62.0000 | 66.0000 | 0 | 14 | false | false |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:12:20Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T13:31:04Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:25:07Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:25:07Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:15:22Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:24:20Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:30:30Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| 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 |
| 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 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:32:56Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:13:55Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:38:44Z"} |
| 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-18T14:54:27Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:49:56Z"} |
| 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-17T16:39:19Z"} |
| 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-17T15:20:32Z"} |
| 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-17T15:20:32Z"} |
| 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-16T15:01:56Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:49:45Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:43:20Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:37:55Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:33:42Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:33:42Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:33:42Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T16:28:48Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T16:01:44Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| 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 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:10:18Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:11:05Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| 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 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:56:00Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:58:23Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |