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 |
|---|
| 01a0d446-fae6-7562-b963-022e8048c5df | SOXL | 2026-09-24 12:36 | put_diagonal_spread | 2 | 1 | 13 | 180180.00 | long | ask | 144.3897 | 6.9500 | ["140","175"] | ["1.2783","1.2242"] | [] | ["XISX"] | 140.0000 | 175.0000 | 113 | 848 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T16:37:16Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0d407-f22f-7cb1-8d17-b2e99173af20 | SOXL | 2026-09-24 11:28 | put_diagonal_spread | 2 | 1 | 50 | 247800.00 | long | ask | 139.1900 | 3.5000 | ["60","70"] | ["1.2647","1.2535"] | [] | ["XISX"] | 60.0000 | 70.0000 | 484 | 848 | false | true | true | ||||||||||
| 01a0d3f6-e2ff-7c43-bc2a-647c6911b6f6 | SOXL | 2026-09-24 11:09 | put_diagonal_spread | 2 | 1 | 40 | 526600.00 | long | ask | 138.3100 | 1.9500 | ["140","220"] | ["1.0639","1.2457"] | [] | ["AMXO"] | 140.0000 | 220.0000 | 1 | 484 | false | false | true | ||||||||||
| 01a0d3aa-ca86-7381-9c6e-a51e0169e923 | SOXL | 2026-09-24 09:46 | put_diagonal_spread | 2 | 1 | 21 | 104076.00 | long | ask | 142.0650 | 5.7000 | ["164","165"] | ["1.1190","2.2772"] | [] | ["XISX"] | 164.0000 | 165.0000 | 1 | 11 | false | false | true | ||||||||||
| 01a0c570-9c17-7723-9c7f-0697a4fc7aa5 | SOXL | 2026-09-21 15:28 | put_diagonal_spread | 2 | 2 | 70 | 121170.00 | long | ask | 142.1300 | 0.9500 | ["100","120"] | ["1.2741","1.1498"] | [] | ["ARCO"] | 100.0000 | 120.0000 | 32 | 60 | false | true | true | ||||||||||
| 01a0c56f-195f-78c3-92db-e3c16c8c496c | SOXL | 2026-09-21 15:26 | put_diagonal_spread | 2 | 1 | 56 | 168560.00 | short | ask | 142.1000 | 1.4500 | ["90","120"] | ["1.2265","1.2302"] | [] | ["BATO"] | 90.0000 | 120.0000 | 60 | 151 | false | true | true | ||||||||||
| 01a0c53c-93c7-73b1-a5d0-4138bd5e7e72 | SOXL | 2026-09-21 14:31 | put_diagonal_spread | 2 | 1 | 10 | 131430.00 | short | ask | 140.9699 | 5.3000 | ["185","200"] | ["1.1979","1.2142"] | [] | ["EDGO"] | 185.0000 | 200.0000 | 60 | 88 | false | false | true | ||||||||||
| 01a0c45c-5587-7b53-9992-a18dc6461902 | SOXL | 2026-09-21 10:26 | put_diagonal_spread | 2 | 1 | 20 | 106560.00 | long | ask | 135.8601 | 1.5000 | ["120","145"] | ["1.2093","1.1885"] | [] | ["ARCO"] | 120.0000 | 145.0000 | 60 | 88 | false | false | true | ||||||||||
| 01a0c447-8d37-7ee3-9197-255f4a863314 | SOXL | 2026-09-21 10:03 | put_diagonal_spread | 2 | 1 | 20 | 115600.00 | long | ask | 134.5950 | 4.3000 | ["120","125"] | ["1.1737","1.1878"] | [] | ["AMXO"] | 120.0000 | 125.0000 | 116 | 151 | false | true | true | ||||||||||
| 01a0b525-7a67-7a60-82c5-77c76fc46458 | SOXL | 2026-09-18 11:32 | put_diagonal_spread | 2 | 1 | 40 | 547200.00 | long | ask | 118.3500 | 1.7100 | ["118","220"] | ["0.6530","1.2241"] | [] | ["XISX"] | 118.0000 | 220.0000 | 3 | 490 | false | false | true | ||||||||||
| 01a0b026-6173-7870-94d8-2ec936fbb6d4 | SOXL | 2026-09-17 12:14 | put_diagonal_spread | 2 | 2 | 26 | 258128.00 | short | ask | 114.7700 | 3.9000 | ["162","164"] | ["1.0869","1.1357"] | [] | ["EDGO","XISX"] | 162.0000 | 164.0000 | 15 | 29 | true | false | true | ||||||||||
| 01a0ab58-00e3-70e3-9e6f-ecf754b5d33e | SOXL | 2026-09-16 13:51 | put_diagonal_spread | 2 | 1 | 20 | 178680.00 | long | ask | 106.8500 | 3.2500 | ["135","150"] | ["1.1545","2.3293"] | [] | ["XCBO"] | 135.0000 | 150.0000 | 2 | 121 | false | false | true | ||||||||||
| 01a0aae9-aacb-7ed3-a5c1-2c4030eba751 | SOXL | 2026-09-16 11:50 | put_diagonal_spread | 2 | 1 | 43 | 310460.00 | long | ask | 108.7475 | 4.0500 | ["75","80"] | ["1.2372","1.2554"] | [] | ["XPHO"] | 75.0000 | 80.0000 | 492 | 856 | false | true | true | ||||||||||
| 01a0aad4-4e0b-7ac1-9e43-8bf961077cf7 | SOXL | 2026-09-16 11:27 | put_diagonal_spread | 2 | 1 | 45 | 125865.00 | long | ask | 108.6978 | 2.8500 | ["119","122"] | ["1.4423","1.1256"] | [] | ["XISX"] | 119.0000 | 122.0000 | 2 | 9 | false | false | true | ||||||||||
| 01a0a5a6-5bce-7901-9062-3c8327a8cf0c | SOXL | 2026-09-15 11:18 | put_diagonal_spread | 2 | 3 | 12 | 141560.00 | short | ask | 102.6207 | 5.6500 | ["161","162"] | ["1.4559","2.0363"] | [] | ["ARCO","XPHO"] | 161.0000 | 162.0000 | 3 | 10 | false | false | true | ||||||||||
| 01a0a59c-611e-7953-9109-ba715603e3e5 | SOXL | 2026-09-15 11:08 | put_diagonal_spread | 2 | 1 | 30 | 261630.00 | long | ask | 102.9100 | 6.1500 | ["145","147"] | ["2.1609","1.5875"] | [] | ["AMXO"] | 145.0000 | 147.0000 | 3 | 8 | false | false | true | ||||||||||
| 01a0a54d-5e8e-7382-82c1-09491ed1c89e | SOXL | 2026-09-15 09:41 | put_diagonal_spread | 2 | 1 | 8 | 158768.00 | short | ask | 104.0000 | 9.0000 | ["155","170"] | ["1.2163","1.2725"] | [] | ["XISX"] | 155.0000 | 170.0000 | 493 | 857 | false | false | true | ||||||||||
| 01a0a115-5710-76c2-88f1-0a4a264f4586 | SOXL | 2026-09-14 14:02 | put_diagonal_spread | 2 | 1 | 40 | 132760.00 | long | ask | 104.1950 | 2.5000 | ["115","120"] | ["1.0850","1.1560"] | [] | ["AMXO"] | 115.0000 | 120.0000 | 4 | 18 | false | false | true | ||||||||||
| 01a0a0ce-d060-74a1-a213-cd028d9e6865 | SOXL | 2026-09-14 12:45 | put_diagonal_spread | 2 | 1 | 20 | 180180.00 | short | ask | 103.7600 | 2.8000 | ["135","140"] | ["1.1547","1.1607"] | [] | ["AMXO"] | 135.0000 | 140.0000 | 67 | 95 | false | false | true | ||||||||||
| 01a0a0b7-d1a8-73d2-bef6-e76dba700654 | SOXL | 2026-09-14 12:19 | put_diagonal_spread | 2 | 1 | 100 | 893000.00 | short | ask | 103.7300 | 2.1500 | ["135","140"] | ["1.1381","1.1320"] | [] | ["XISX"] | 135.0000 | 140.0000 | 67 | 95 | false | false | true | ||||||||||
| 01a0a0b7-9af9-7940-9f77-ec11f38ad78b | SOXL | 2026-09-14 12:19 | put_diagonal_spread | 2 | 1 | 47 | 420274.00 | short | ask | 103.6900 | 2.1500 | ["135","140"] | ["1.1413","1.1322"] | [] | ["ARCO"] | 135.0000 | 140.0000 | 67 | 95 | false | false | true | ||||||||||
| 01a0a0b7-9710-7742-b712-89a9b16bb5e3 | SOXL | 2026-09-14 12:19 | put_diagonal_spread | 2 | 1 | 100 | 893100.00 | short | ask | 103.6750 | 2.1500 | ["135","140"] | ["1.1371","1.1298"] | [] | ["XISX"] | 135.0000 | 140.0000 | 67 | 95 | false | false | true | ||||||||||
| 01a0a087-8e31-7b91-9256-00a22db5d0aa | SOXL | 2026-09-14 11:27 | put_diagonal_spread | 2 | 2 | 48 | 375120.00 | long | ask | 101.9800 | 6.0000 | ["138","140"] | ["1.2404","2.0895"] | [] | ["XMIO"] | 138.0000 | 140.0000 | 4 | 25 | false | false | true | ||||||||||
| 01a0a027-d648-72f0-a5ae-ab6d46ecdaca | SOXL | 2026-09-14 09:42 | put_diagonal_spread | 2 | 1 | 453 | 1607697.00 | long | ask | 100.6000 | 2.7000 | ["80","90"] | ["1.1962","1.2147"] | [] | ["XISX"] | 80.0000 | 90.0000 | 95 | 158 | false | true | true | ||||||||||
| 01a091f8-f660-7e71-a33d-a81d4648e492 | SOXL | 2026-09-11 15:36 | put_diagonal_spread | 2 | 1 | 9 | 122454.00 | long | ask | 121.6400 | 2.3900 | ["120","220"] | ["0.6196","1.2347"] | [] | ["XCBO"] | 120.0000 | 220.0000 | 3 | 497 | false | false | true | ||||||||||
| 01a090e5-30b8-7601-8f14-cecc18895670 | SOXL | 2026-09-11 10:35 | put_diagonal_spread | 2 | 1 | 30 | 100020.00 | long | ask | 121.5700 | 1.1000 | ["125","135"] | ["1.0802","0.9684"] | [] | ["AMXO"] | 125.0000 | 135.0000 | 7 | 35 | false | false | true | ||||||||||
| 01a081d0-f210-7802-bd57-8443d0a783f4 | SOXL | 2026-09-08 12:19 | put_diagonal_spread | 2 | 1 | 23 | 171074.00 | long | ask | 125.7750 | 4.3500 | ["153","161"] | ["1.2155","1.2960"] | [] | ["BATO"] | 153.0000 | 161.0000 | 10 | 38 | false | false | true | ||||||||||
| 01a081cc-8158-7921-9230-7e2a971d5def | SOXL | 2026-09-08 12:14 | put_diagonal_spread | 2 | 1 | 5 | 108325.00 | long | ask | 126.0550 | 7.3500 | ["185","220"] | ["1.2662","1.1605"] | [] | ["AMXO"] | 185.0000 | 220.0000 | 164 | 500 | false | false | true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:28:43Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:09:54Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T13:46:36Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:28:20Z"} |
| 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:26:39Z"} |
| 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-21T18:31:22Z"} |
| 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:26:19Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:03: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-18T15:32:11Z"} |
| 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:15:07Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:51:53Z"} |
| 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-16T15:51:19Z"} |
| 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-16T15:28:00Z"} |
| 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-15T15:19:09Z"} |
| 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-15T15:08:36Z"} |
| 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-15T13:42:10Z"} |
| 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-14T18:02:12Z"} |
| 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-14T16:45:25Z"} |
| 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-14T16:20:08Z"} |
| 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-14T16:20:08Z"} |
| 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-14T16:20:08Z"} |
| 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-14T15:27:38Z"} |
| 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:42:54Z"} |
| 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-11T19:37:05Z"} |
| 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-11T14:35:45Z"} |
| 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-08T16:19:09Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:14:16Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |