core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg637,282 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 |
|---|
| 01a0f8fa-78ff-7920-9c1d-0fb208de7e09 | EEM | 2026-10-01 15:39 | straddle | 2 | 1 | 500 | 234500.00 | short | bid | 66.8000 | 0.1600 | ["67"] | ["0.2380"] | ["62.31","71.69"] | ["XPHO"] | 67.0000 | 67.0000 | 50 | 50 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-10-01T19:39:35Z"} | 2026-10-01 | 2026-10-01 17:15 | 2026-10-01 17:15 |
| 01a0f8c8-06ef-7eb2-81b1-779f66df5462 | EEM | 2026-10-01 14:44 | call_calendar | 2 | 1 | 279 | 1121580.00 | long | bid | 66.7600 | 5.9500 | ["47"] | ["0.5730"] | [] | ["XISX"] | 47.0000 | 47.0000 | 50 | 78 | false | false | true | ||||||||||
| 01a0f7b7-3ee6-7db0-999c-7d8f79d5a53e | EEM | 2026-10-01 09:46 | put_vertical_spread | 2 | 1 | 3305 | 198300.00 | short | bid | 66.8550 | 0.7500 | ["45","54"] | ["0.4989","0.3560"] | ["53.80"] | ["SPHR"] | 45.0000 | 54.0000 | 78 | 78 | false | true | |||||||||||
| 01a0f3ba-3817-75b0-b88a-9ef9c3af736b | EEM | 2026-09-30 15:11 | put_ladder | 3 | 1 | 30000 | 707200.00 | unknown | bid | 66.7300 | 0.3900 | ["50","55","63"] | ["0.5077","0.4108","0.2668"] | ["62.01"] | ["AMXO"] | 50.0000 | 63.0000 | 30 | 30 | true | true | |||||||||||
| 01a0da1d-7ca7-7a11-bcf5-8d265b4aa002 | EEM | 2026-09-25 15:49 | put_vertical_spread | 2 | 5 | 785 | 200219.00 | unknown | bid | 67.9250 | 1.1600 | ["46","53"] | ["0.3452","0.3115"] | ["50.45"] | ["ARCO","EDGO","XBOX","XCBO","XISX"] | 46.0000 | 53.0000 | 357 | 357 | false | true | |||||||||||
| 01a0d99b-295e-7621-98c4-0288913556e5 | EEM | 2026-09-25 13:26 | put_vertical_spread | 2 | 1 | 10000 | 660000.00 | short | bid | 67.8800 | 0.1000 | ["62.5","65"] | ["0.2747","0.2390"] | ["64.74"] | ["XPHO"] | 62.5000 | 65.0000 | 21 | 21 | false | true | |||||||||||
| 01a0d950-83ff-7d73-8368-6e1760c27728 | EEM | 2026-09-25 12:05 | strangle | 2 | 1 | 1400 | 109200.00 | short | bid | 68.0800 | 0.5400 | ["66.5","68.5"] | ["0.2387","0.1716"] | ["65.72","69.28"] | ["XPHO"] | 66.5000 | 68.5000 | 7 | 7 | true | true | |||||||||||
| 01a0d8d4-81e6-7ed0-8503-75344b16e253 | EEM | 2026-09-25 09:49 | put_vertical_spread | 2 | 1 | 975 | 108495.00 | short | bid | 67.8150 | 0.7000 | ["62","66.5"] | ["0.3028","0.2344"] | ["65.85"] | ["XPHO"] | 62.0000 | 66.5000 | 21 | 21 | false | true | |||||||||||
| 01a0ca18-65bf-78d2-bc91-fd9211292584 | EEM | 2026-09-22 13:09 | put_diagonal_spread | 2 | 1 | 2000 | 816000.00 | unknown | bid | 68.7700 | 5.7200 | ["50","60"] | ["0.3182","0.2963"] | [] | ["ARCO"] | 50.0000 | 60.0000 | 486 | 850 | false | true | |||||||||||
| 01a0c9f8-c02f-7012-abec-f3ef28890925 | EEM | 2026-09-22 12:35 | put_vertical_spread | 2 | 1 | 2500 | 2912500.00 | short | bid | 68.7000 | 9.3000 | ["50","70"] | ["0.3181","0.2949"] | ["63.83"] | ["ARCO"] | 50.0000 | 70.0000 | 850 | 850 | true | false | |||||||||||
| 01a0c9c6-d2ee-7cd1-9e47-75b7077e736f | EEM | 2026-09-22 11:40 | put_diagonal_spread | 2 | 1 | 2000 | 1506000.00 | short | bid | 68.6600 | 1.4400 | ["61","68"] | ["0.2953","0.2780"] | [] | ["ARCO"] | 61.0000 | 68.0000 | 115 | 486 | false | true | |||||||||||
| 01a0c9bd-68c7-7dc3-879f-1c39ce49e6e3 | EEM | 2026-09-22 11:30 | put_diagonal_spread | 2 | 1 | 11000 | 8261000.00 | short | bid | 68.7550 | 1.5000 | ["61","68"] | ["0.2960","0.2788"] | [] | ["ARCO"] | 61.0000 | 68.0000 | 115 | 486 | false | true | |||||||||||
| 01a0c4cf-1c57-7e00-b7f7-0bc9c7f2dc36 | EEM | 2026-09-21 12:31 | risk_reversal | 2 | 1 | 1500 | 376500.00 | long | bid | 68.6900 | 0.3400 | ["63","74"] | ["0.2829","0.2115"] | ["62.89"] | ["AMXO"] | 63.0000 | 74.0000 | 88 | 88 | false | true | |||||||||||
| 01a0c4ce-8bcf-7743-bc24-dc6dfdd6f71c | EEM | 2026-09-21 12:31 | risk_reversal | 2 | 1 | 3500 | 878500.00 | long | bid | 68.6700 | 0.3400 | ["63","74"] | ["0.2825","0.2120"] | ["62.89"] | ["AMXO"] | 63.0000 | 74.0000 | 88 | 88 | false | true | |||||||||||
| 01a0c4b0-5d3f-7a22-b959-96864017dd69 | EEM | 2026-09-21 11:58 | call_vertical_spread | 2 | 5 | 150 | 110810.00 | short | bid | 68.4800 | 0.3000 | ["67","69"] | ["0.2341","0.2259"] | ["68.17"] | ["ARCO","C2OX","XBOX","XISX"] | 67.0000 | 69.0000 | 88 | 88 | false | false | |||||||||||
| 01a0c442-4d76-7c51-a64d-248a9f8c52ba | EEM | 2026-09-21 09:57 | call_vertical_spread | 2 | 1 | 9500 | 4693000.00 | short | bid | 68.2600 | 0.2800 | ["65","70"] | ["0.2541","0.2231"] | ["68.04"] | ["ARCO"] | 65.0000 | 70.0000 | 25 | 25 | false | false | |||||||||||
| 01a0b5e4-9fff-71b3-8050-479675845c4d | EEM | 2026-09-18 15:00 | put_vertical_spread | 2 | 1 | 2500 | 2455000.00 | short | bid | 66.9150 | 5.9400 | ["45","66"] | ["0.3212","0.2967"] | ["60.12"] | ["ARCO"] | 45.0000 | 66.0000 | 854 | 854 | false | true | |||||||||||
| 01a0b5cc-f950-7711-ac57-c867dd6bfaf8 | EEM | 2026-09-18 14:35 | put_vertical_spread | 2 | 1 | 2500 | 2455000.00 | short | bid | 66.8600 | 5.9500 | ["45","66"] | ["0.3209","0.2962"] | ["60.12"] | ["ARCO"] | 45.0000 | 66.0000 | 854 | 854 | false | true | |||||||||||
| 01a0b59b-ac38-7050-87be-2189cbc61f0b | EEM | 2026-09-18 13:41 | put_vertical_spread | 2 | 1 | 2500 | 2495000.00 | short | bid | 66.8250 | 6.2400 | ["45","66"] | ["0.3251","0.2982"] | ["60.12"] | ["ARCO"] | 45.0000 | 66.0000 | 854 | 854 | false | true | |||||||||||
| 01a0b59b-a468-7a72-9ffb-d9a8119284d6 | EEM | 2026-09-18 13:41 | put_vertical_spread | 2 | 1 | 2000 | 1996000.00 | short | bid | 66.8250 | 6.2400 | ["45","66"] | ["0.3251","0.2982"] | ["60.12"] | ["ARCO"] | 45.0000 | 66.0000 | 854 | 854 | false | true | |||||||||||
| 01a0b00b-efea-7950-9527-4b1cecfc385a | EEM | 2026-09-17 11:46 | call_diagonal_spread | 2 | 1 | 165 | 167475.00 | short | bid | 66.9550 | 0.5000 | ["62","63.5"] | ["0.9604","0.2590"] | [] | ["SPHR"] | 62.0000 | 63.5000 | 1 | 64 | false | false | |||||||||||
| 01a086af-3120-7680-83ee-92b73f0d2c84 | EEM | 2026-09-09 11:00 | call_diagonal_spread | 2 | 2 | 402 | 104504.00 | short | bid | 68.8050 | 0.0900 | ["69.5","71.5"] | ["0.2222","0.2314"] | [] | ["AMXO","XISX"] | 69.5000 | 71.5000 | 9 | 72 | false | true | |||||||||||
| 01a0865d-fff8-7171-b185-1278107ce999 | EEM | 2026-09-09 09:31 | call_calendar | 2 | 2 | 113 | 179539.00 | short | bid | 68.6700 | 0.7500 | ["61"] | ["0.3588"] | [] | ["AMXO","XCBO"] | 61.0000 | 61.0000 | 9 | 37 | false | false | |||||||||||
| 01a0865d-fff8-7171-b185-1264a7bb8f21 | EEM | 2026-09-09 09:31 | call_calendar | 2 | 1 | 96 | 152256.00 | short | bid | 68.6700 | 0.8500 | ["61"] | ["0.3586"] | [] | ["XCBO"] | 61.0000 | 61.0000 | 9 | 37 | false | false | true | ||||||||||
| 01a08228-12c0-79f2-826d-9bc67baed443 | EEM | 2026-09-08 13:54 | straddle | 2 | 2 | 750 | 517500.00 | short | bid | 69.0000 | 0.2000 | ["70"] | ["0.2379"] | ["63.10","76.90"] | ["AMXO"] | 70.0000 | 70.0000 | 101 | 101 | false | false |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T18:44:43Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T13:46:17Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-30T19:11:06Z"} |
| 2026-09-30 |
| 2026-09-30 17:15 |
| 2026-09-30 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T19:49:28Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T17:27:44Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T16:05:36Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T13:50:17Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:10:13Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:36:04Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:41:00Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:30:27Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| true |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:31:51Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| true |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:31:06Z"} |
| 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-21T15:58:17Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:57:56Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:00:58Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:35:38Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:41:42Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:41:42Z"} |
| 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-17T15:46:14Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:00:32Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:31:46Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:31:46Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:54:59Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |