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 |
|---|
| 01a0f34c-3fbf-7d10-9f50-e9d3da6df0a7 | BKNG | 2026-09-30 13:10 | call_vertical_spread | 2 | 1 | 78 | 234780.00 | short | bid | 162.8500 | 4.3000 | ["150","185"] | ["0.4302","0.4040"] | ["165.80"] | ["XPHO"] | 150.0000 | 185.0000 | 107 | 107 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-30T17:11:36Z"} | 2026-09-30 | 2026-09-30 17:15 | 2026-09-30 17:15 |
| 01a0d4b6-f6df-7283-9ca7-12b201cdebd3 | BKNG | 2026-09-24 14:39 | put_diagonal_spread | 2 | 2 | 130 | 268970.00 | short | bid | 157.6700 | 4.8000 | ["160","167.5"] | ["0.4515","0.8515"] | [] | ["C2OX","EDGO"] | 160.0000 | 167.5000 | 1 | 43 | false | false | |||||||||||
| 01a0d3d7-4926-7650-91ad-139244555df5 | BKNG | 2026-09-24 10:34 | put_butterfly_spread | 3 | 1 | 50 | 130777.00 | short | bid | 157.4750 | 3.1000 | ["140","164","165"] | ["0.4376","0.4185","0.4202"] | ["153.39"] | ["XMIO"] | 140.0000 | 165.0000 | 85 | 85 | false | false | |||||||||||
| 01a0cee8-25df-7e20-a0de-527550995c1f | BKNG | 2026-09-23 11:35 | put_diagonal_spread | 2 | 1 | 50 | 117000.00 | short | bid | 156.1900 | 0.7000 | ["140","150"] | ["0.4301","0.4324"] | [] | ["XISX"] | 140.0000 | 150.0000 | 114 | 267 | false | true | |||||||||||
| 01a0cee7-899f-7522-b957-4debfdab40a7 | BKNG | 2026-09-23 11:34 | put_diagonal_spread | 2 | 1 | 43 | 100620.00 | short | bid | 156.1200 | 0.6000 | ["140","150"] | ["0.4296","0.4316"] | [] | ["C2OX"] | 140.0000 | 150.0000 | 114 | 267 | false | true | |||||||||||
| 01a0cee7-85b7-7641-ba7e-266077b0bcd0 | BKNG | 2026-09-23 11:34 | put_diagonal_spread | 2 | 1 | 50 | 117000.00 | short | bid | 156.1200 | 0.6000 | ["140","150"] | ["0.4296","0.4316"] | [] | ["XISX"] | 140.0000 | 150.0000 | 114 | 267 | false | true | |||||||||||
| 01a0ce90-517e-7760-8028-d18b72a7dbc4 | BKNG | 2026-09-23 09:59 | iron_butterfly | 4 | 1 | 25 | 237275.00 | short | ask | 157.2700 | 15.8500 | ["190","208","226"] | ["0.3879","0.3984","0.4014"] | ["191.25","224.75"] | ["XCBO"] | 190.0000 | 226.0000 | 177 | 177 | false | false | |||||||||||
| 01a0c9c5-67a7-7a32-b686-e2a2d43b8cdf | BKNG | 2026-09-22 11:39 | put_diagonal_spread | 2 | 1 | 15 | 132585.00 | short | ask | 161.7900 | 12.1000 | ["205","210"] | ["0.8182","1.0424"] | [] | ["MCRY"] | 205.0000 | 210.0000 | 10 | 17 | false | false | |||||||||||
| 01a0c9c4-042f-7ae1-a3a4-a351b54513b9 | BKNG | 2026-09-22 11:37 | put_diagonal_spread | 2 | 1 | 15 | 130350.00 | short | ask | 162.3900 | 15.0000 | ["205","210"] | ["0.9677","1.2918"] | [] | ["XMIO"] | 205.0000 | 210.0000 | 10 | 17 | false | false | |||||||||||
| 01a0c993-a177-72b1-acbb-521da5aa3622 | BKNG | 2026-09-22 10:44 | synthetic | 2 | 1 | 25 | 141250.00 | short | bid | 163.9200 | 25.5000 | ["150"] | ["0.3992"] | ["171.20"] | ["XISX"] | 150.0000 | 150.0000 | 451 | 451 | false | false | |||||||||||
| 01a0b5a7-9318-72d2-b9a4-0c7f52f663ea | BKNG | 2026-09-18 13:54 | put_vertical_spread | 2 | 1 | 100 | 180800.00 | short | bid | 168.3800 | 1.4000 | ["157.2","157.6"] | ["0.3991","0.3997"] | ["157.42"] | ["XCBO"] | 157.2000 | 157.6000 | 119 | 119 | false | true | |||||||||||
| 01a0b5a7-8377-7b31-9d37-44722e4588db | BKNG | 2026-09-18 13:54 | put_vertical_spread | 2 | 1 | 100 | 181000.00 | short | bid | 168.3700 | 1.4000 | ["157.2","157.6"] | ["0.3993","0.3999"] | ["157.42"] | ["XMIO"] | 157.2000 | 157.6000 | 119 | 119 | false | true | |||||||||||
| 01a0b5a5-0aa7-7473-8758-7d092a2cc981 | BKNG | 2026-09-18 13:51 | put_vertical_spread | 2 | 1 | 72 | 130176.00 | short | bid | 168.3500 | 1.4000 | ["157.2","157.6"] | ["0.3988","0.3994"] | ["157.42"] | ["XCBO"] | 157.2000 | 157.6000 | 119 | 119 | false | true | |||||||||||
| 01a0b5a4-fb07-7e42-8a52-ad2b897447cc | BKNG | 2026-09-18 13:51 | put_vertical_spread | 2 | 1 | 100 | 181000.00 | short | bid | 168.3600 | 1.4000 | ["157.2","157.6"] | ["0.3992","0.3998"] | ["157.42"] | ["XMIO"] | 157.2000 | 157.6000 | 119 | 119 | false | true | |||||||||||
| 01a0b5a4-85d7-7103-9653-c031b5ad01fe | BKNG | 2026-09-18 13:50 | put_vertical_spread | 2 | 1 | 100 | 181000.00 | short | bid | 168.3700 | 1.4000 | ["157.2","157.6"] | ["0.3993","0.3999"] | ["157.42"] | ["XISX"] | 157.2000 | 157.6000 | 119 | 119 | false | true | |||||||||||
| 01a0b555-b227-7241-b03b-f571182bc279 | BKNG | 2026-09-18 12:24 | put_vertical_spread | 2 | 1 | 105 | 187950.00 | short | bid | 168.6000 | 1.4000 | ["154","160"] | ["0.4030","0.4012"] | ["157.70"] | ["C2OX"] | 154.0000 | 160.0000 | 119 | 119 | false | true | |||||||||||
| 01a0b536-2bd7-7ed1-8562-6346cbe4e005 | BKNG | 2026-09-18 11:50 | call_vertical_spread | 2 | 1 | 44 | 128392.00 | short | bid | 168.8950 | 1.4000 | ["165","170"] | ["0.3870","0.3892"] | ["167.40"] | ["BATO"] | 165.0000 | 170.0000 | 91 | 91 | false | false | |||||||||||
| 01a0b4b8-937f-7190-b881-74b9c58b17a3 | BKNG | 2026-09-18 09:33 | call_calendar | 2 | 2 | 108 | 907038.00 | short | ask | 169.2000 | 16.4000 | ["152.8"] | ["0.3907"] | [] | ["ARCO","EMLD"] | 152.8000 | 152.8000 | 455 | 490 | true | false | |||||||||||
| 01a0aa75-c2eb-7ec0-85a4-9e5d03a12bab | BKNG | 2026-09-16 09:43 | call_vertical_spread | 2 | 1 | 48 | 135840.00 | short | bid | 170.8950 | 2.8000 | ["170","175"] | ["0.4090","0.4067"] | ["172.36"] | ["XMIO"] | 170.0000 | 175.0000 | 93 | 93 | false | false | |||||||||||
| 01a086d4-7c00-7c03-91ab-f8199e1225a4 | BKNG | 2026-09-09 11:41 | put_calendar | 2 | 1 | 22 | 143594.00 | short | ask | 172.1600 | 5.7000 | ["205"] | ["1.0959"] | [] | ["XCBO"] | 205.0000 | 205.0000 | 2 | 30 | false | false | |||||||||||
| 01a0865c-c4c8-7033-8d7f-48ef7a55cf2e | BKNG | 2026-09-09 09:30 | call_condor | 4 | 1 | 10 | 133910.00 | short | bid | 176.7280 | 37.0000 | ["192","208","212","228"] | ["0.3667","0.3620","0.3662","0.3600"] | ["192.75","227.25"] | ["XCBO"] | 192.0000 | 228.0000 | 828 | 828 | false | true | |||||||||||
| 01a0814b-6a78-71b0-9163-7547983455e3 | BKNG | 2026-09-08 09:53 | call_vertical_spread | 2 | 1 | 40 | 125400.00 | short | bid | 185.9850 | 4.7000 | ["182","230"] | ["0.3719","0.3690"] | ["198.11"] | ["ARCO"] | 182.0000 | 230.0000 | 192 | 192 | false | false | |||||||||||
| 01a0814b-62a9-7bd2-8f08-61086a7bb870 | BKNG | 2026-09-08 09:53 | call_vertical_spread | 2 | 1 | 40 | 124760.00 | short | bid | 185.9900 | 4.8000 | ["182","230"] | ["0.3736","0.3635"] | ["198.45"] | ["ARCO"] | 182.0000 | 230.0000 | 192 | 192 | false | false | |||||||||||
| 01a0814b-62a9-7bd2-8f08-60edb7044d06 | BKNG | 2026-09-08 09:53 | call_vertical_spread | 2 | 2 | 100 | 311600.00 | short | bid | 185.9900 | 5.1000 | ["182","230"] | ["0.3712","0.3656"] | ["198.23"] | ["ARCO","C2OX"] | 182.0000 | 230.0000 | 192 | 192 | false | false | |||||||||||
| 01a08142-bfb8-7311-8dd5-b31cf5314b3a | BKNG | 2026-09-08 09:43 | call_vertical_spread | 2 | 1 | 48 | 138912.00 | short | bid | 185.6350 | 7.7000 | ["185","195"] | ["0.3965","0.3937"] | ["189.42"] | ["XCBO"] | 185.0000 | 195.0000 | 101 | 101 | false | false | |||||||||||
| 01a06dcc-5fd5-7292-b1fa-6d56228e30a6 | BKNG | 2026-09-04 15:01 | put_calendar | 2 | 1 | 195 | 271050.00 | short | ask | 193.6150 | 3.4000 | ["200"] | ["1.1061"] | [] | ["XMIO"] | 200.0000 | 200.0000 | 0 | 7 | false | false | |||||||||||
| 01a06dca-9ab5-7b42-bb57-9c84952b92d9 | BKNG | 2026-09-04 14:59 | put_calendar | 2 | 1 | 115 | 205275.00 | short | bid | 193.6750 | 4.9000 | ["202.5"] | ["2.6181"] | [] | ["XMIO"] | 202.5000 | 202.5000 | 0 | 7 | false | false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:39:58Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:35:03Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:35:16Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:34:54Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:34:54Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T13:59:24Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:39:11Z"} |
| 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-22T15:38:09Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:44:55Z"} |
| 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-18T17:54:37Z"} |
| 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:54:37Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:52:05Z"} |
| 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:52:05Z"} |
| 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:51:21Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:24:49Z"} |
| 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-18T15:50:53Z"} |
| 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-18T13:33:16Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:44:27Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:41:34Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:30:30Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:53:21Z"} |
| 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-08T13:53:21Z"} |
| 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-08T13:53:21Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:43:53Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:02:08Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:00:17Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |