core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg473,794 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 |
|---|
| 01a0d3ab-b0ff-7222-8208-58950180c9f6 | HOOD | 2026-09-24 09:47 | call_diagonal_spread | 2 | 1 | 13 | 123890.00 | short | bid | 119.8900 | 5.2000 | ["85","130"] | ["0.7108","0.6891"] | [] | ["XISX"] | 85.0000 | 130.0000 | 266 | 813 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T13:47:30Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0cef6-c027-7361-874b-f9a61670385b | HOOD | 2026-09-23 11:51 | call_diagonal_spread | 2 | 1 | 13 | 165282.00 | short | ask | 125.4500 | 1.2500 | ["60","70"] | ["1.3762","0.7160"] | [] | ["XISX"] | 60.0000 | 70.0000 | 23 | 240 | false | false | true | ||||||||||
| 01a0cec3-5416-7143-927c-1aea6f150c91 | HOOD | 2026-09-23 10:55 | call_diagonal_spread | 2 | 1 | 27 | 300753.00 | short | ask | 125.2700 | 3.0000 | ["115","120"] | ["0.6814","0.6783"] | [] | ["XISX"] | 115.0000 | 120.0000 | 814 | 849 | false | false | true | ||||||||||
| 01a0ce89-4c9f-79d3-8595-c5e617e57631 | HOOD | 2026-09-23 09:51 | call_diagonal_spread | 2 | 1 | 63 | 164808.00 | short | bid | 125.7500 | 0.4000 | ["113","115"] | ["0.8941","0.6252"] | [] | ["XCBO"] | 113.0000 | 115.0000 | 2 | 16 | false | false | true | ||||||||||
| 01a0c9a9-2d16-7bd2-8a37-c4e741541a6b | HOOD | 2026-09-22 11:08 | call_diagonal_spread | 2 | 1 | 100 | 121000.00 | short | bid | 124.3216 | 0.3000 | ["120","125"] | ["0.7003","0.6133"] | [] | ["AMXO"] | 120.0000 | 125.0000 | 3 | 17 | false | false | true | ||||||||||
| 01a0c97a-686f-7f33-9b16-738451a28efc | HOOD | 2026-09-22 10:17 | call_diagonal_spread | 2 | 1 | 17 | 143106.00 | short | bid | 124.0800 | 1.3000 | ["100","105"] | ["0.6825","0.6824"] | [] | ["XISX"] | 100.0000 | 105.0000 | 268 | 360 | false | false | true | ||||||||||
| 01a0c956-0407-7431-b4d2-9ff78902e2d9 | HOOD | 2026-09-22 09:37 | call_diagonal_spread | 2 | 1 | 70 | 162820.00 | short | bid | 125.1300 | 0.9500 | ["114","115"] | ["0.7550","0.6416"] | [] | ["BATO"] | 114.0000 | 115.0000 | 3 | 10 | false | false | true | ||||||||||
| 01a0c952-ac8f-7d93-9b86-08a4f4dd234a | HOOD | 2026-09-22 09:33 | call_diagonal_spread | 2 | 1 | 54 | 468342.00 | short | bid | 124.8000 | 1.6000 | ["85","160"] | ["0.6898","0.6764"] | [] | ["XCBO"] | 85.0000 | 160.0000 | 87 | 850 | false | false | true | ||||||||||
| 01a0c579-b81f-7501-bd27-af6c2f19002e | HOOD | 2026-09-21 15:38 | call_diagonal_spread | 2 | 1 | 40 | 118640.00 | short | bid | 124.5200 | 0.5000 | ["160","170"] | ["0.6653","0.6747"] | [] | ["XISX"] | 160.0000 | 170.0000 | 207 | 242 | false | true | true | ||||||||||
| 01a0c56c-814f-7cf3-a123-e0074cb3ff33 | HOOD | 2026-09-21 15:23 | call_diagonal_spread | 2 | 1 | 90 | 758520.00 | short | bid | 124.1399 | 1.2500 | ["100","105"] | ["0.6807","0.6820"] | [] | ["XMIO"] | 100.0000 | 105.0000 | 269 | 361 | false | false | true | ||||||||||
| 01a0c51e-420f-7f11-9543-93e6eaf3ef3b | HOOD | 2026-09-21 13:58 | call_diagonal_spread | 2 | 4 | 34 | 218960.00 | short | ask | 124.4501 | 1.2765 | ["100","105"] | ["0.6644","0.6727"] | [] | ["ARCO","BATO","C2OX","EDGO"] | 100.0000 | 105.0000 | 116 | 151 | false | false | true | ||||||||||
| 01a0c493-b54f-7b31-9d9e-e752152ae035 | HOOD | 2026-09-21 11:26 | call_diagonal_spread | 2 | 1 | 53 | 103721.00 | short | bid | 123.4400 | 0.7500 | ["180","280"] | ["0.6818","0.6818"] | [] | ["BATO"] | 180.0000 | 280.0000 | 151 | 487 | false | true | true | ||||||||||
| 01a0c490-0bcf-7b11-8d1c-0a7a243615bb | HOOD | 2026-09-21 11:22 | call_diagonal_spread | 2 | 1 | 80 | 137360.00 | short | bid | 123.1800 | 0.7500 | ["195","250"] | ["0.6900","0.6814"] | [] | ["XISX"] | 195.0000 | 250.0000 | 116 | 452 | false | true | true | ||||||||||
| 01a0c478-af57-76c2-bd12-46652edd710d | HOOD | 2026-09-21 10:57 | call_diagonal_spread | 2 | 1 | 20 | 147540.00 | short | bid | 123.3900 | 1.4000 | ["110","125"] | ["0.6754","0.6774"] | [] | ["XISX"] | 110.0000 | 125.0000 | 269 | 452 | false | false | true | ||||||||||
| 01a0c448-5c3f-7741-9a3f-4c411aae5e00 | HOOD | 2026-09-21 10:04 | call_diagonal_spread | 2 | 1 | 80 | 196480.00 | short | ask | 122.7850 | 0.5500 | ["125","135"] | ["0.6845","0.6594"] | [] | ["ARCO"] | 125.0000 | 135.0000 | 60 | 88 | false | true | true | ||||||||||
| 01a0c42e-3108-7c03-8654-e7c48e8dee51 | HOOD | 2026-09-21 09:35 | call_diagonal_spread | 2 | 1 | 150 | 440700.00 | short | bid | 123.3100 | 0.9000 | ["115","130"] | ["0.6583","0.6600"] | [] | ["XCBO"] | 115.0000 | 130.0000 | 25 | 116 | false | false | true | ||||||||||
| 01a0b618-4a90-74a3-8484-5a13aa356fb2 | HOOD | 2026-09-18 15:57 | call_diagonal_spread | 2 | 1 | 99 | 216414.00 | short | bid | 119.9100 | 1.2500 | ["160","200"] | ["0.6926","0.6764"] | [] | ["XISX"] | 160.0000 | 200.0000 | 63 | 455 | false | true | true | ||||||||||
| 01a0b609-c7b7-7922-901c-e15b79d74457 | HOOD | 2026-09-18 15:41 | call_diagonal_spread | 2 | 1 | 40 | 190600.00 | short | bid | 119.4400 | 0.5000 | ["103","105"] | ["0.6172","0.6654"] | [] | ["C2OX"] | 103.0000 | 105.0000 | 35 | 154 | false | false | true | ||||||||||
| 01a0b600-fdb7-7c60-bdf3-7e713ca02b66 | HOOD | 2026-09-18 15:31 | call_diagonal_spread | 2 | 1 | 133 | 683620.00 | short | bid | 119.5300 | 0.8500 | ["95","100"] | ["14.7767","0.6575"] | [] | ["BATO"] | 95.0000 | 100.0000 | 0 | 91 | false | false | true | ||||||||||
| 01a0b548-d917-7d02-9f03-4233196bbf08 | HOOD | 2026-09-18 12:10 | call_diagonal_spread | 2 | 1 | 177 | 326388.00 | short | bid | 118.3100 | 0.3712 | ["115","120"] | ["0.8844","0.6502"] | [] | ["XISX"] | 115.0000 | 120.0000 | 0 | 91 | false | false | true | ||||||||||
| 01a0b540-c6af-7300-b4bc-c76151c2a60a | HOOD | 2026-09-18 12:01 | call_diagonal_spread | 2 | 1 | 150 | 194250.00 | short | bid | 118.1900 | 0.4000 | ["125","135"] | ["0.6198","0.6724"] | [] | ["XMIO"] | 125.0000 | 135.0000 | 28 | 63 | false | true | true | ||||||||||
| 01a0b526-dddf-70c2-b34d-4fddd2832434 | HOOD | 2026-09-18 11:33 | call_diagonal_spread | 2 | 1 | 45 | 110700.00 | short | bid | 118.2700 | 0.5500 | ["111","115"] | ["1.3864","0.6500"] | [] | ["BATO"] | 111.0000 | 115.0000 | 0 | 91 | false | false | true | ||||||||||
| 01a0b4ef-2ff7-74f3-8d04-d9c291f1e88e | HOOD | 2026-09-18 10:32 | call_diagonal_spread | 2 | 1 | 12 | 103608.00 | short | ask | 117.2300 | 1.7500 | ["85","145"] | ["0.6801","0.6814"] | [] | ["XCBO"] | 85.0000 | 145.0000 | 272 | 819 | false | false | true | ||||||||||
| 01a0ab8f-8ba3-7161-a5f5-df6a2dcce8bc | HOOD | 2026-09-16 14:51 | call_diagonal_spread | 2 | 1 | 82 | 120540.00 | short | bid | 104.2400 | 0.7000 | ["150","170"] | ["0.6706","0.6746"] | [] | ["BATO"] | 150.0000 | 170.0000 | 156 | 247 | false | true | true | ||||||||||
| 01a0ab71-a363-74e3-acbe-22555b3deaa1 | HOOD | 2026-09-16 14:19 | call_diagonal_spread | 2 | 1 | 20 | 101400.00 | short | ask | 104.7100 | 2.3000 | ["85","195"] | ["0.6621","0.6794"] | [] | ["BATO"] | 85.0000 | 195.0000 | 93 | 821 | false | false | true | ||||||||||
| 01a0a6a6-7265-7482-b591-3df16d16d11c | HOOD | 2026-09-15 15:58 | call_diagonal_spread | 2 | 1 | 103 | 174688.00 | short | ask | 110.3350 | 0.3000 | ["100","115"] | ["0.8433","0.6263"] | [] | ["EDGO"] | 100.0000 | 115.0000 | 3 | 31 | false | false | true | ||||||||||
| 01a0a660-f556-7921-9303-ce090dd361ac | HOOD | 2026-09-15 14:42 | call_diagonal_spread | 2 | 1 | 40 | 210820.00 | short | bid | 108.0000 | 3.1500 | ["140","200"] | ["0.6933","0.6917"] | [] | ["EDGO"] | 140.0000 | 200.0000 | 493 | 822 | false | true | true | ||||||||||
| 01a0a180-4610-7493-aef0-bc48c80c13dd | HOOD | 2026-09-14 15:58 | call_diagonal_spread | 2 | 1 | 50 | 232800.00 | short | ask | 114.3200 | 1.2000 | ["90","115"] | ["1.2455","0.6593"] | [] | ["XMIO"] | 90.0000 | 115.0000 | 4 | 186 | false | false | true | ||||||||||
| 01a0a04e-0b89-7fa2-8eb0-b5f4adfd4292 | HOOD | 2026-09-14 10:24 | call_diagonal_spread | 2 | 1 | 44 | 120428.00 | short | ask | 113.4950 | 0.7500 | ["100","155"] | ["0.6434","0.6772"] | [] | ["XMIO"] | 100.0000 | 155.0000 | 32 | 186 | false | false | true | ||||||||||
| 01a0a033-e051-7972-827c-a6af1caf2f2a | HOOD | 2026-09-14 09:55 | call_diagonal_spread | 2 | 1 | 30 | 120930.00 | short | bid | 114.4200 | 1.0000 | ["95","105"] | ["1.0278","0.6696"] | [] | ["XMIO"] | 95.0000 | 105.0000 | 4 | 95 | false | false | true | ||||||||||
| 01a0a032-9448-7f90-9668-60c34c679ac2 | HOOD | 2026-09-14 09:54 | call_diagonal_spread | 2 | 1 | 23 | 104834.00 | short | bid | 114.5900 | 1.3500 | ["125","145"] | ["0.6753","0.6753"] | [] | ["XMIO"] | 125.0000 | 145.0000 | 249 | 368 | false | true | true | ||||||||||
| 01a086a3-1b61-76d1-b7a2-cfb06e302745 | HOOD | 2026-09-09 10:47 | call_diagonal_spread | 2 | 1 | 30 | 126810.00 | short | bid | 117.8586 | 1.5000 | ["160","220"] | ["0.6853","0.6860"] | [] | ["BATO"] | 160.0000 | 220.0000 | 219 | 828 | false | true | true | ||||||||||
| 01a0867f-89e8-7280-9656-288c4f0baa75 | HOOD | 2026-09-09 10:08 | call_diagonal_spread | 2 | 1 | 20 | 170340.00 | short | bid | 117.6200 | 2.4000 | ["115","135"] | ["0.7039","0.6957"] | [] | ["BATO"] | 115.0000 | 135.0000 | 464 | 828 | false | false | true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:51:22Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:55:14Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T13:51:47Z"} |
| 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-22T15:08:37Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:17:24Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:37:32Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:34:07Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:38:02Z"} |
| 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-21T19:23:56Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:58:47Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:27:07Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:22:49Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:57:38Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:04:44Z"} |
| 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-21T13:35:59Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:57:30Z"} |
| 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-18T19:41:32Z"} |
| 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-18T19:31:55Z"} |
| 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-18T16:11:06Z"} |
| 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-18T16:02:10Z"} |
| 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:33:59Z"} |
| 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-18T14:32:55Z"} |
| 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-16T18:51:51Z"} |
| 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:19:43Z"} |
| 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-15T19:58:56Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:43:13Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:59:02Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:24:27Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T13:55:50Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T13:54:27Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:47:31Z"} |
| 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-09T14:08:29Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |