core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg438,407 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 |
|---|
| 01a0cf35-058e-76e3-9c8e-a3bc776d2b8e | BKNG | 2026-09-23 12:59 | call_diagonal_spread | 2 | 1 | 25 | 112825.00 | unknown | bid | 156.4600 | 3.2000 | ["150","160"] | ["0.4182","0.4089"] | [] | ["XPHO"] | 150.0000 | 160.0000 | 177 | 267 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-23T16:59:24Z"} | 2026-09-23 | 2026-09-23 17:15 | 2026-09-23 17:15 |
| 01a0cf1a-e9f7-7f82-a3e6-ae0e8eb0e445 | BKNG | 2026-09-23 12:30 | put_butterfly_spread | 3 | 1 | 50 | 130575.00 | unknown | bid | 157.4250 | 8.3000 | ["140","164","165"] | ["0.4451","0.4107","0.4153"] | ["146.92"] | ["XPHO"] | 140.0000 | 165.0000 | 86 | 86 | false | 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 | 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 | 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 | true | ||||||||||
| 01a0ceac-9baf-7100-afab-1c7593a2aa29 | BKNG | 2026-09-23 10:30 | other | 4 | 1 | 25 | 112975.00 | unknown | bid | 157.9750 | 4.9500 | ["140","175"] | ["0.4566","0.4521"] | [] | ["XCBO"] | 140.0000 | 175.0000 | 23 | 58 | false | false | true | true | |||||||||
| 01a0ca89-5bb6-7fd1-aefa-bd6478666290 | BKNG | 2026-09-22 15:13 | put_ratio_spread | 2 | 1 | 500 | 1470750.00 | unknown | bid | 161.2300 | 4.9000 | ["150","184"] | ["0.3997","0.3786"] | ["141.72"] | ["XBOX"] | 150.0000 | 184.0000 | 268 | 268 | false | 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 | false | false | |||||||||
| 01a0c569-e16f-7683-8a7d-94090db297ba | BKNG | 2026-09-21 15:20 | put_diagonal_spread | 2 | 1 | 30 | 192600.00 | unknown | bid | 169.6050 | 5.9000 | ["200","205"] | ["1.2474","0.8842"] | [] | ["XBOX"] | 200.0000 | 205.0000 | 4 | 18 | false | false | true | ||||||||||
| 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 | false | ||||||||||
| 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 | false | ||||||||||
| 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 | false | ||||||||||
| 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 | false | ||||||||||
| 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 | false | ||||||||||
| 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 | false | ||||||||||
| 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 | false | ||||||||||
| 01a0b4e5-fc7f-7e02-81d2-e57c5933b521 | BKNG | 2026-09-18 10:22 | put_diagonal_spread | 2 | 1 | 25 | 152875.00 | unknown | bid | 168.3300 | 30.6000 | ["184","191.2"] | ["0.3284","0.2995"] | [] | ["XBOX"] | 184.0000 | 191.2000 | 490 | 819 | false | false | true | ||||||||||
| 01a0ab25-f07a-7342-b3a3-7db6afde517c | BKNG | 2026-09-16 12:56 | risk_reversal | 2 | 1 | 125 | 395625.00 | long | bid | 172.6500 | 5.5500 | ["200","240"] | ["0.3943","0.4046"] | ["170.45"] | ["XPHO"] | 200.0000 | 240.0000 | 93 | 93 | false | false | 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 | false | ||||||||||
| 01a0a5a5-8cc6-7280-b33e-acf1f5df82be | BKNG | 2026-09-15 11:18 | put_diagonal_spread | 2 | 1 | 80 | 169600.00 | long | bid | 170.9100 | 2.6000 | ["160","168"] | ["0.4006","0.4059"] | [] | ["SPHR"] | 160.0000 | 168.0000 | 94 | 122 | false | true | true | ||||||||||
| 01a08cd1-69b0-78f0-8145-beddf2517d4e | BKNG | 2026-09-10 15:35 | put_calendar | 2 | 1 | 50 | 257900.00 | long | bid | 174.2400 | 5.8000 | ["200"] | ["0.8300"] | [] | ["XCBO"] | 200.0000 | 200.0000 | 1 | 8 | false | false | true | false | |||||||||
| 01a086b9-85a8-7042-b1c7-fa7df4fb4640 | BKNG | 2026-09-09 11:11 | put_diagonal_spread | 2 | 1 | 15 | 136800.00 | long | bid | 171.8000 | 19.4000 | ["215","222.5"] | ["1.0223","1.6726"] | [] | ["XMIO"] | 215.0000 | 222.5000 | 9 | 16 | false | false | true | ||||||||||
| 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 | false | ||||||||||
| 01a0817e-0b69-7b13-81e1-88b6928145e4 | BKNG | 2026-09-08 10:48 | call_diagonal_spread | 2 | 2 | 118 | 581681.00 | long | bid | 183.8700 | 5.9000 | ["180","188"] | ["0.3678","0.3691"] | [] | ["ARCO","XPHO"] | 180.0000 | 188.0000 | 220 | 282 | false | 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 | 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 | 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 | 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 | 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 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:31:25Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| 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 |
| 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 |
| 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 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:30:12Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:13:52Z"} |
| 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-22T14:44:55Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:20:46Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:23:00Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:57:19Z"} |
| 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:44:27Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:18:04Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:35:39Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:11:44Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| 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 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:49:04Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |