core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg403,968 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 |
|---|
| 01a0c9aa-1b5f-7e71-a4a5-fbb8989c0b07 | HOOD | 2026-09-22 11:09 | call_diagonal_spread | 2 | 1 | 50 | 252300.00 | long | ask | 124.4750 | 1.6000 | ["150","160"] | ["0.6638","0.6689"] | [] | ["XPHO"] | 150.0000 | 160.0000 | 268 | 486 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T15:09:50Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c959-fba7-7772-8968-489e1f991a21 | HOOD | 2026-09-22 09:41 | call_diagonal_spread | 2 | 1 | 70 | 169190.00 | long | bid | 125.0001 | 0.9500 | ["113","115"] | ["0.7642","0.6765"] | [] | ["SPHR"] | 113.0000 | 115.0000 | 3 | 10 | false | false | true | ||||||||||
| 01a0c585-319f-7563-ae80-7bb990282e53 | HOOD | 2026-09-21 15:50 | call_diagonal_spread | 2 | 1 | 40 | 169160.00 | long | ask | 123.9000 | 0.7500 | ["120","125"] | ["0.6583","0.6695"] | [] | ["XISX"] | 120.0000 | 125.0000 | 116 | 151 | false | false | true | ||||||||||
| 01a0c56c-fe4f-7603-aa27-c876b873f388 | HOOD | 2026-09-21 15:24 | call_diagonal_spread | 2 | 1 | 60 | 168900.00 | long | ask | 124.1071 | 0.4500 | ["125","160"] | ["0.6808","0.6662"] | [] | ["XISX"] | 125.0000 | 160.0000 | 60 | 207 | false | true | true | ||||||||||
| 01a0c52b-7cc7-7871-941b-58e7e900f068 | HOOD | 2026-09-21 14:12 | call_diagonal_spread | 2 | 1 | 280 | 1414000.00 | long | ask | 125.0000 | 1.7500 | ["220","230"] | ["0.6774","0.6767"] | [] | ["XISX"] | 220.0000 | 230.0000 | 487 | 851 | false | true | true | ||||||||||
| 01a0c46e-6a6f-7d50-9e8b-50b92fc7950e | HOOD | 2026-09-21 10:46 | call_diagonal_spread | 2 | 1 | 100 | 183900.00 | long | ask | 123.8450 | 0.4000 | ["200","290"] | ["0.6877","0.6859"] | [] | ["XISX"] | 200.0000 | 290.0000 | 179 | 487 | false | true | true | ||||||||||
| 01a0c43a-13ff-75b0-950c-fd6e54fbc6d3 | HOOD | 2026-09-21 09:48 | call_diagonal_spread | 2 | 2 | 100 | 312900.00 | long | bid | 122.1800 | 0.9000 | ["110","130"] | ["0.6553","0.6609"] | [] | ["XMIO"] | 110.0000 | 130.0000 | 25 | 116 | false | false | true | ||||||||||
| 01a0b55f-5acf-7712-9ef7-29bfccf3ecc9 | HOOD | 2026-09-18 12:35 | call_diagonal_spread | 2 | 3 | 61 | 125900.00 | long | bid | 119.6900 | 0.4500 | ["115","145"] | ["0.6130","0.6543"] | [] | ["EDGO","XBOX","XMIO"] | 115.0000 | 145.0000 | 28 | 119 | false | false | true | ||||||||||
| 01a0b557-30f7-7cb0-9a78-8a9bb9cff042 | HOOD | 2026-09-18 12:26 | call_diagonal_spread | 2 | 2 | 15 | 114150.00 | long | bid | 118.2900 | 1.5500 | ["120","170"] | ["0.6772","0.6784"] | [] | ["XCBO","XISX"] | 120.0000 | 170.0000 | 490 | 854 | false | true | true | ||||||||||
| 01a0b54a-1d4f-7f80-a839-d9fe291f4032 | HOOD | 2026-09-18 12:12 | call_diagonal_spread | 2 | 1 | 15 | 103200.00 | long | bid | 118.3600 | 1.5000 | ["90","190"] | ["0.6634","0.6773"] | [] | ["XISX"] | 90.0000 | 190.0000 | 119 | 854 | false | false | true | ||||||||||
| 01a0b52c-4c80-7a80-898b-1811cf4575f1 | HOOD | 2026-09-18 11:39 | call_diagonal_spread | 2 | 1 | 81 | 108459.00 | long | ask | 118.3519 | 0.6500 | ["115","120"] | ["0.9898","0.6510"] | [] | ["XPHO"] | 115.0000 | 120.0000 | 0 | 42 | false | false | true | ||||||||||
| 01a0b50f-ac5f-7a63-8df4-52789abbb2ac | HOOD | 2026-09-18 11:08 | call_diagonal_spread | 2 | 1 | 58 | 211932.00 | long | ask | 118.1400 | 0.6000 | ["100","130"] | ["3.9997","0.6619"] | [] | ["XCBO"] | 100.0000 | 130.0000 | 0 | 182 | false | false | true | ||||||||||
| 01a0b042-422b-73a2-987d-57dc0a8b8ae7 | HOOD | 2026-09-17 12:45 | call_diagonal_spread | 2 | 1 | 180 | 848880.00 | long | bid | 107.9100 | 1.2500 | ["100","115"] | ["0.6404","0.6667"] | [] | ["BATO"] | 100.0000 | 115.0000 | 183 | 273 | false | false | true | ||||||||||
| 01a0aad6-808b-78d2-86bc-e74ea0a5fbc2 | HOOD | 2026-09-16 11:29 | call_diagonal_spread | 2 | 2 | 83 | 171727.00 | long | ask | 105.0200 | 0.5596 | ["95","96"] | ["1.0096","0.6936"] | [] | ["XISX"] | 95.0000 | 96.0000 | 2 | 9 | false | false | true | ||||||||||
| 01a0aa83-0573-75b0-8aea-51289a3254bd | HOOD | 2026-09-16 09:58 | call_diagonal_spread | 2 | 1 | 9 | 147780.00 | long | bid | 107.5400 | 1.7500 | ["15","50"] | ["1.5408","0.7227"] | [] | ["XCBO"] | 15.0000 | 50.0000 | 121 | 856 | false | false | true | ||||||||||
| 01a0a6a4-efae-7641-a699-3f197d516b3b | HOOD | 2026-09-15 15:56 | call_diagonal_spread | 2 | 1 | 103 | 176439.00 | long | bid | 110.5000 | 0.3000 | ["100","115"] | ["0.8306","0.6236"] | [] | ["EDGO"] | 100.0000 | 115.0000 | 3 | 31 | false | false | true | ||||||||||
| 01a0a660-d22e-7fc1-96cb-9c9a07506716 | HOOD | 2026-09-15 14:42 | call_diagonal_spread | 2 | 1 | 57 | 573648.00 | long | ask | 108.0400 | 2.2500 | ["60","95"] | ["0.7797","0.7023"] | [] | ["XISX"] | 60.0000 | 95.0000 | 94 | 857 | false | false | true | ||||||||||
| 01a0a08a-4199-77c1-b0c5-b3e89ab3f7b2 | HOOD | 2026-09-14 11:30 | call_diagonal_spread | 2 | 1 | 30 | 149910.00 | long | bid | 113.9068 | 0.6600 | ["85","95"] | ["1.5897","0.6617"] | [] | ["XCBO"] | 85.0000 | 95.0000 | 4 | 32 | false | false | true | ||||||||||
| 01a090bf-64f0-78b0-aacb-5e1c988818b2 | HOOD | 2026-09-11 09:54 | call_diagonal_spread | 2 | 5 | 868 | 689700.00 | long | ask | 112.1450 | 0.6500 | ["130","131"] | ["0.6276","0.6669"] | [] | ["C2OX","EDGO","XCBO","XISX","XPHO"] | 130.0000 | 131.0000 | 35 | 49 | false | true | true | ||||||||||
| 01a090bb-afb8-7e42-aa15-a5c9e78edfb3 | HOOD | 2026-09-11 09:50 | call_diagonal_spread | 2 | 1 | 80 | 134000.00 | long | ask | 112.5700 | 1.8000 | ["105","110"] | ["1.8250","0.6084"] | [] | ["EDGO"] | 105.0000 | 110.0000 | 0 | 28 | false | false | true | ||||||||||
| 01a08cd4-dc80-7561-8de9-a8b13900e869 | HOOD | 2026-09-10 15:39 | call_diagonal_spread | 2 | 1 | 36 | 115524.00 | long | bid | 114.2400 | 0.8000 | ["115","120"] | ["0.6713","0.6618"] | [] | ["XMIO"] | 115.0000 | 120.0000 | 99 | 127 | false | true | true | ||||||||||
| 01a081f1-9970-7711-a0db-fa3b7d78c93a | HOOD | 2026-09-08 12:54 | call_diagonal_spread | 2 | 1 | 20 | 150260.00 | long | bid | 120.8200 | 1.0500 | ["90","130"] | ["0.6989","0.7011"] | [] | ["XMIO"] | 90.0000 | 130.0000 | 129 | 500 | false | false | true | ||||||||||
| 01a081c2-57c8-7d60-8798-e00feebe5495 | HOOD | 2026-09-08 12:03 | call_diagonal_spread | 2 | 1 | 30 | 168270.00 | long | ask | 121.3779 | 1.1500 | ["110","150"] | ["0.6793","0.7014"] | [] | ["XPHO"] | 110.0000 | 150.0000 | 129 | 465 | false | false | true | ||||||||||
| 01a081a2-f888-7821-95b6-ef97b11650f9 | HOOD | 2026-09-08 11:28 | call_diagonal_spread | 2 | 1 | 55 | 329120.00 | long | ask | 121.7350 | 2.6000 | ["75","118"] | ["0.7760","0.6874"] | [] | ["SPHR"] | 75.0000 | 118.0000 | 10 | 164 | false | false | true | ||||||||||
| 01a08184-f8d8-7f72-adda-411feb6b740f | HOOD | 2026-09-08 10:56 | call_diagonal_spread | 2 | 1 | 50 | 153600.00 | long | ask | 122.3000 | 1.3500 | ["125","150"] | ["0.7110","0.6924"] | [] | ["AMXO"] | 125.0000 | 150.0000 | 73 | 192 | false | true | true | ||||||||||
| 01a08158-d7f8-7b82-b323-59e7aaa1b1e0 | HOOD | 2026-09-08 10:07 | call_diagonal_spread | 2 | 1 | 18 | 130680.00 | long | ask | 122.8200 | 2.5000 | ["135","190"] | ["0.7050","0.6984"] | [] | ["BATO"] | 135.0000 | 190.0000 | 465 | 829 | false | true | true | ||||||||||
| 01a08156-5b40-7341-8c90-e4fdd3010779 | HOOD | 2026-09-08 10:05 | call_diagonal_spread | 2 | 1 | 130 | 396890.00 | long | bid | 123.0266 | 1.6000 | ["108","116"] | ["0.9791","0.6578"] | [] | ["XCBO"] | 108.0000 | 116.0000 | 3 | 45 | false | false | true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:41:56Z"} |
| 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:50:40Z"} |
| 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-21T19:24:26Z"} |
| 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-21T18:12:57Z"} |
| 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:46:14Z"} |
| 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-21T13:48:57Z"} |
| 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-18T16:35:18Z"} |
| 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:26:39Z"} |
| 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:12:17Z"} |
| 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:40:00Z"} |
| 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-18T15:08:20Z"} |
| 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-17T16:45:59Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:30:24Z"} |
| 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:58:40Z"} |
| 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:57:00Z"} |
| 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-15T18:43:13Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:30:30Z"} |
| 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-11T13:54:29Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T13:50:18Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:39:25Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:55:25Z"} |
| 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-08T16:03:18Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:29:25Z"} |
| 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-08T14:56:31Z"} |
| 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-08T14:08:00Z"} |
| 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-08T14:05:21Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |