Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
367,592 rowsCSV — whole table, not this view
Sources in this table
uw_multileg367,592 rowsexportable
| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c559-f34f-7a91-b28b-93ecea9ee5e2 | BKNG | 2026-09-21 15:03 | call_diagonal_spread | 2 | 1 | 31000 | 108477500.00 | unknown | ask | 169.6850 | 3.1000 | ["150","162.4"] | ["0.4387","0.3310"] | [] | ["SPHR"] | 150.0000 | 162.4000 | 25 | 88 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:03:34Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5d6-ccf0-7192-8a81-ff4720fe4214 | BKNG | 2026-09-18 14:45 | other | 3 | 1 | 140 | 1044320.00 | unknown | ask | 168.1600 | 10.7000 | ["200","205","215"] | ["0.6933","0.6013","1.2395"] | [] | ["XPHO"] | 200.0000 | 215.0000 | 7 | 21 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:46:05Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b555-c1c8-7d21-b109-feccc24bd441 | BKNG | 2026-09-18 12:24 | put_vertical_spread | 2 | 3 | 23 | 130871.00 | long | ask | 168.5750 | 1.4000 | ["170","200"] | ["0.4054","0.4055"] | ["181.19"] | ["ARCO","C2OX","EDGO"] | 170.0000 | 200.0000 | 210 | 210 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:25:11Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b555-b9f7-78e1-ae2a-0767d7d0e219 | BKNG | 2026-09-18 12:24 | put_vertical_spread | 2 | 6 | 45 | 256116.00 | unknown | ask | 168.5850 | 1.4000 | ["170","200"] | ["0.4057","0.4057"] | ["156.54"] | ["AMXO","ARCO","EMLD","XISX","XMIO","XPHO"] | 170.0000 | 200.0000 | 210 | 210 | false | false | false | true | false | mlet | 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 |
| 01a0b555-b9f7-78e1-ae2a-07590955acef | BKNG | 2026-09-18 12:24 | put_vertical_spread | 2 | 6 | 49 | 279944.00 | unknown | ask | 168.5850 | 1.4061 | ["170","200"] | ["0.4079","0.4080"] | ["156.43"] | ["AMXO","EMLD","XBOX","XISX","XMIO","XPHO"] | 170.0000 | 200.0000 | 210 | 210 | false | false | false | true | false | mlet | 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 |
| 01a0b555-a670-72d3-bc1b-e13a6a3ab8bb | BKNG | 2026-09-18 12:24 | put_vertical_spread | 2 | 4 | 37 | 211843.00 | long | ask | 168.6000 | 1.6000 | ["170","200"] | ["0.4092","0.4095"] | ["181.19"] | ["AMXO","EMLD","XBOX","XISX"] | 170.0000 | 200.0000 | 210 | 210 | false | false | false | true | false | mlet | 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 |
| 01a0b554-a0b7-7702-bf12-7618f02d5c83 | BKNG | 2026-09-18 12:23 | put_vertical_spread | 2 | 5 | 26 | 148912.00 | unknown | ask | 168.5150 | 1.6000 | ["170","200"] | ["0.4087","0.4086"] | ["156.36"] | ["EMLD","XBOX","XISX","XMIO","XPHO"] | 170.0000 | 200.0000 | 210 | 210 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:23:38Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b554-a0b7-7702-bf12-76008998f5ab | BKNG | 2026-09-18 12:23 | put_vertical_spread | 2 | 3 | 31 | 177789.00 | long | ask | 168.5150 | 1.6000 | ["170","200"] | ["0.4094","0.4094"] | ["181.19"] | ["AMXO","XBOX","XISX"] | 170.0000 | 200.0000 | 210 | 210 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:23:38Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b554-a0b7-7702-bf12-75feea93fbcf | BKNG | 2026-09-18 12:23 | put_vertical_spread | 2 | 6 | 56 | 320320.00 | long | ask | 168.5150 | 1.6000 | ["170","200"] | ["0.4079","0.4079"] | ["181.19"] | ["AMXO","ARCO","EMLD","XBOX","XISX","XPHO"] | 170.0000 | 200.0000 | 210 | 210 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:23:38Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b554-9ccf-73e0-82d8-1709e4289f1c | BKNG | 2026-09-18 12:23 | put_vertical_spread | 2 | 4 | 45 | 257656.00 | long | ask | 168.5200 | 1.8000 | ["170","200"] | ["0.4085","0.4085"] | ["181.19"] | ["AMXO","ARCO","XBOX","XISX"] | 170.0000 | 200.0000 | 210 | 210 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:23:38Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b553-77d7-7f60-82af-1ebc15d24d70 | BKNG | 2026-09-18 12:22 | put_vertical_spread | 2 | 7 | 21 | 119100.00 | unknown | ask | 168.6700 | 3.6000 | ["170","200"] | ["0.4044","0.4048"] | ["156.64"] | ["AMXO","ARCO","EMLD","XBOX","XISX","XMIO","XPHO"] | 170.0000 | 200.0000 | 210 | 210 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:22:35Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b553-77d7-7f60-82af-1eae012f0e87 | BKNG | 2026-09-18 12:22 | put_vertical_spread | 2 | 7 | 34 | 192340.00 | unknown | ask | 168.6700 | 3.6000 | ["170","200"] | ["0.4030","0.4033"] | ["156.71"] | ["AMXO","ARCO","EMLD","XBOX","XISX","XMIO","XPHO"] | 170.0000 | 200.0000 | 210 | 210 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:22:35Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b553-77d7-7f60-82af-1e9fc2abf6df | BKNG | 2026-09-18 12:22 | put_vertical_spread | 2 | 4 | 29 | 165760.00 | unknown | ask | 168.6700 | 4.1862 | ["170","200"] | ["0.4089","0.4093"] | ["156.42"] | ["AMXO","XBOX","XISX","XMIO"] | 170.0000 | 200.0000 | 210 | 210 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:22:35Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 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 | true | 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 |
| 01a0920b-9400-7a81-a823-9434148f8197 | BKNG | 2026-09-11 15:57 | put_diagonal_spread | 2 | 1 | 100 | 189500.00 | long | ask | 174.1700 | 3.7000 | ["170","180"] | ["0.4113","0.3688"] | [] | ["XCBO"] | 170.0000 | 180.0000 | 7 | 98 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:57:06Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 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 | true | 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 |
| 01a08671-64d0-7ba2-a3d7-a8017164e703 | BKNG | 2026-09-09 09:52 | put_condor | 4 | 1 | 25 | 163900.00 | long | ask | 170.6600 | 13.9000 | ["172","180","188","196"] | ["0.3721","0.3724","0.3268","0.3194"] | ["174","194"] | ["XCBO"] | 172.0000 | 196.0000 | 37 | 37 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:53:13Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0866d-4620-7223-8369-fbeaeb0f59c0 | BKNG | 2026-09-09 09:48 | put_condor | 4 | 1 | 25 | 213650.00 | long | ask | 172.0800 | 18.5000 | ["175","185","190","200"] | ["0.4110","0.3962","0.4164","0.3858"] | ["176.20","198.80"] | ["AMXO"] | 175.0000 | 200.0000 | 72 | 72 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:48:42Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0865c-cf49-77b0-8c8a-98e61fd6bcc3 | BKNG | 2026-09-09 09:30 | call_condor | 4 | 1 | 10 | 136850.00 | long | ask | 176.7280 | 55.6000 | ["192","208","212","228"] | ["0.3735","0.3361","0.4061","0.3673"] | ["192.75","227.25"] | ["XCBO"] | 192.0000 | 228.0000 | 828 | 828 | false | true | false | 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 |
| 01a0821b-fd00-7fa2-877e-702cf18dd766 | BKNG | 2026-09-08 13:41 | call_butterfly_spread | 3 | 1 | 16 | 155284.00 | long | ask | 181.3100 | 31.1000 | ["164","180","250"] | ["0.3937","0.3812","0.3403"] | ["229.63"] | ["XMIO"] | 164.0000 | 250.0000 | 829 | 829 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:41:28Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 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 | true | 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 |