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 | direction |
|---|
| 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 |
|---|
| 01a06d54-2e4d-7b32-b286-13ca4215dc43 | AEM | 2026-09-04 12:50 | other | 5 | 1 | 15 | 169196.00 | unknown | — | 204.9150 | 9.7000 | ["180","190","210","220","230"] | ["0.4741","0.4629","0.4652","0.4690","0.4653"] | [] | ["ARCO"] | 180.0000 | 230.0000 | 133 | 504 | false | false | true | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:50:58Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d54-2e4d-7b32-b286-13da1f4080f0 | AEM | 2026-09-04 12:50 | other | 5 | 1 | 15 | 169970.00 | unknown | — | 204.9150 | 9.7000 | ["180","190","210","220","230"] | ["0.4720","0.4665","0.4732","0.4816","0.4679"] | [] | ["BATO"] | 180.0000 | 230.0000 | 133 | 504 | false | false | true | true | |||||||||
| 01a06d72-b6b5-75b2-8f24-a8565fe8df81 | AEM | 2026-09-04 13:23 | call_vertical_spread | 2 | 1 | 50 | 118550.00 | short | bid | 205.2300 | 1.3000 | ["195","230"] | ["0.4513","0.4759"] | ["208.35"] | ["MCRY"] | 195.0000 | 230.0000 | 42 | 42 | false | false | |||||||||||
| 01a086a9-68a8-7e83-b77f-100261d6a32e | AEM | 2026-09-09 10:54 | call_vertical_spread | 2 | 1 | 12 | 140508.00 | short | bid | 204.2600 | 3.6000 | ["150","175"] | ["0.4612","0.4613"] | ["166.23"] | ["XCBO"] | 150.0000 | 175.0000 | 281 | 281 | false | false | |||||||||||
| 01a0878b-c5e0-7773-bf0e-efd3a2cf32bc | AEM | 2026-09-09 15:01 | synthetic | 2 | 2 | 250 | 1268750.00 | long | ask | 202.8800 | 3.2000 | ["170"] | ["0.4780"] | ["206.35"] | ["ARCO"] | 170.0000 | 170.0000 | 128 | 128 | false | false | false | ||||||||||
| 01a08c94-aed0-7723-b38a-8e8c14809c61 | AEM | 2026-09-10 14:29 | other | 3 | 1 | 44 | 191520.00 | unknown | — | 197.1125 | 8.6000 | ["215","222.5","225"] | ["1.6373","1.9042","2.0745"] | [] | ["XBOX"] | 215.0000 | 225.0000 | 1 | 1 | true | false | false | true | false | ||||||||
| 01a090b8-11f1-7752-b875-2dd5b5d474c2 | AEM | 2026-09-11 09:46 | call_diagonal_spread | 2 | 3 | 15 | 110920.00 | short | bid | 201.2050 | 4.4000 | ["140","190"] | ["1.5575","1.8583"] | [] | ["C2OX","EDGO","XBOX"] | 140.0000 | 190.0000 | 0 | 7 | false | false | |||||||||||
| 01a0a55b-02be-7b93-abc2-8a9cba13d94c | AEM | 2026-09-15 09:56 | call_diagonal_spread | 2 | 1 | 10 | 119510.00 | short | ask | 196.4300 | 5.5000 | ["125","150"] | ["2.5691","0.5956"] | [] | ["XCBO"] | 125.0000 | 150.0000 | 3 | 31 | false | false | |||||||||||
| 01a0aa6a-d9f3-7162-a146-ccb763570750 | AEM | 2026-09-16 09:32 | call_calendar | 2 | 1 | 5 | 105260.00 | unknown | — | 200.3408 | 7.7000 | ["110"] | ["0.4619"] | [] | ["XISX"] | 110.0000 | 110.0000 | 492 | 856 | false | false | true | false | false | ||||||||
| 01a0aa6b-3f83-7672-bcd9-938c2aa6b40b | AEM | 2026-09-16 09:32 | call_calendar | 2 | 1 | 5 | 104975.00 | short | ask | 200.8000 | 7.7000 | ["110"] | ["0.4422"] | [] | ["XMIO"] | 110.0000 | 110.0000 | 492 | 856 | false | false | true | ||||||||||
| 01a0aa6b-a8fb-7a72-81a2-36ee690d20bb | AEM | 2026-09-16 09:32 | call_calendar | 2 | 1 | 5 | 104995.00 | short | ask | 201.0300 | 7.7000 | ["110"] | ["0.4365"] | [] | ["XCBO"] | 110.0000 | 110.0000 | 492 | 856 | false | false | true | ||||||||||
| 01a0aa6d-182b-72c2-ab1c-08f905495983 | AEM | 2026-09-16 09:34 | call_calendar | 2 | 1 | 5 | 105780.00 | short | ask | 201.7050 | 8.9000 | ["110"] | ["0.4413"] | [] | ["XCBO"] | 110.0000 | 110.0000 | 492 | 856 | false | false | true | ||||||||||
| 01a0aa6d-c7f3-7ec3-95d2-2ca55339cad3 | AEM | 2026-09-16 09:35 | call_calendar | 2 | 1 | 5 | 105780.00 | short | ask | 201.7500 | 8.9000 | ["110"] | ["0.4400"] | [] | ["XCBO"] | 110.0000 | 110.0000 | 492 | 856 | false | false | true | ||||||||||
| 01a0aa80-5dc3-7b01-a40f-9ce2d18d6c60 | AEM | 2026-09-16 09:55 | call_calendar | 2 | 1 | 5 | 105160.00 | short | ask | 200.5900 | 6.4000 | ["110"] | ["0.4532"] | [] | ["XCBO"] | 110.0000 | 110.0000 | 492 | 856 | false | false | true | ||||||||||
| 01a0aa91-41fb-71f0-8773-e4568721fff2 | AEM | 2026-09-16 10:13 | call_calendar | 2 | 1 | 5 | 103980.00 | short | bid | 199.5200 | 6.1000 | ["110"] | ["0.4481"] | [] | ["XMIO"] | 110.0000 | 110.0000 | 492 | 856 | false | false | true | ||||||||||
| 01a0ab87-88db-7760-b147-c3d3a777e08a | AEM | 2026-09-16 14:42 | call_calendar | 2 | 1 | 20 | 265480.00 | short | bid | 196.7100 | 6.1000 | ["130"] | ["2.1084"] | [] | ["EDGO"] | 130.0000 | 130.0000 | 2 | 30 | false | false | true | ||||||||||
| 01a0af97-b603-7f02-991a-c7f4d715afbd | AEM | 2026-09-17 09:39 | call_diagonal_spread | 2 | 1 | 47 | 687610.00 | unknown | — | 199.9559 | 5.3000 | ["125","130"] | ["4.9004","1.7087"] | [] | ["XISX"] | 125.0000 | 130.0000 | 1 | 8 | false | false | true | true | |||||||||
| 01a0afa3-a0cc-71b2-95da-c5dd0fde0249 | AEM | 2026-09-17 09:52 | call_vertical_spread | 2 | 1 | 108 | 117040.00 | unknown | — | 201.4200 | 1.5000 | ["250","260"] | ["0.4871","0.4920"] | [] | ["XCBO"] | 250.0000 | 260.0000 | 92 | 92 | false | true | false | true | |||||||||
| 01a0afa5-1bb3-7771-b5fc-d5e8879e5b94 | AEM | 2026-09-17 09:53 | call_vertical_spread | 2 | 1 | 75 | 187875.00 | unknown | — | 201.6100 | 2.5000 | ["195","240"] | ["0.4692","0.4898"] | [] | ["BATO"] | 195.0000 | 240.0000 | 64 | 64 | false | false | false | true | |||||||||
| 01a0b0a8-7a23-71b2-a3fc-d429a5152167 | AEM | 2026-09-17 14:37 | other | 4 | 1 | 7 | 118769.00 | unknown | — | 201.4700 | 11.9000 | ["160","170","210","230"] | ["0.4532","0.4547","0.4579","0.4606"] | [] | ["C2OX"] | 160.0000 | 230.0000 | 120 | 491 | false | false | true | true | |||||||||
| 01a0b0a8-81f3-7931-8317-6bd305ea3b72 | AEM | 2026-09-17 14:37 | other | 4 | 1 | 34 | 576878.00 | unknown | — | 201.4700 | 11.9000 | ["160","170","210","230"] | ["0.4532","0.4547","0.4579","0.4606"] | [] | ["C2OX"] | 160.0000 | 230.0000 | 120 | 491 | false | false | true | true | |||||||||
| 01a0b0ad-0a1b-7e72-872f-efffaf9ea02f | AEM | 2026-09-17 14:42 | put_butterfly_spread | 3 | 1 | 57 | 215910.00 | unknown | — | 201.5800 | 6.5000 | ["217.5","220","222.5"] | ["1.5524","0.9971","1.5364"] | [] | ["XBOX"] | 217.5000 | 222.5000 | 1 | 1 | false | false | false | true | |||||||||
| 01a0b5df-2990-7672-b7b1-a5a49fbe9679 | AEM | 2026-09-18 14:54 | straddle | 2 | 2 | 300 | 2901000.00 | long | ask | 199.7000 | 5.7000 | ["240"] | ["0.4857"] | ["143.30","336.70"] | ["AMXO"] | 240.0000 | 240.0000 | 490 | 490 | true | false | false | ||||||||||
| 01a0c979-2437-7573-86b6-e0ae1c4471c5 | AEM | 2026-09-22 10:15 | call_calendar | 2 | 1 | 10 | 100050.00 | unknown | — | 199.6617 | 4.7000 | ["150"] | ["0.5713"] | [] | ["XMIO"] | 150.0000 | 150.0000 | 24 | 31 | false | false | true | false | false | ||||||||
| 01a0c9e3-4bff-73f1-9252-26ab63c3633e | AEM | 2026-09-22 12:11 | call_vertical_spread | 2 | 1 | 10 | 221590.00 | short | bid | 200.0700 | 6.6000 | ["90","95"] | ["0.4134","0.4389"] | ["94.63"] | ["XCBO"] | 90.0000 | 95.0000 | 268 | 268 | false | false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:50:58Z"} |
| 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-04T17:23:49Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:54:29Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:01:48Z"} |
| 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-10T18:29:15Z"} |
| 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-11T13:46:17Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T13:56:50Z"} |
| 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-16T13:32:04Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:32:42Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:33:05Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:34:37Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:35:21Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:55:50Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:14:15Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:43:15Z"} |
| 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-17T13:39:20Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:52:24Z"} |
| 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-17T13:54:03Z"} |
| 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-17T18:37:26Z"} |
| 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-17T18:37:26Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:42:34Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:55:08Z"} |
| 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-22T14:15:53Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:12:30Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |