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 |
|---|
| 01a0d4af-51d7-7583-92a2-6d0312e55b05 | SLV | 2026-09-24 14:30 | call_diagonal_spread | 2 | 1 | 173 | 168675.00 | short | ask | 57.6600 | 0.3000 | ["68.5","70"] | ["0.4090","0.4116"] | [] | ["XISX"] | 68.5000 | 70.0000 | 266 | 279 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T18:30:54Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0d3f6-7986-77e0-8ba4-6358f2f6e2f3 | SLV | 2026-09-24 11:08 | call_diagonal_spread | 2 | 1 | 168 | 157416.00 | short | ask | 57.0500 | 0.2500 | ["57","70"] | ["0.3708","0.4167"] | [] | ["XISX"] | 57.0000 | 70.0000 | 98 | 279 | false | false | true | ||||||||||
| 01a0cf5e-9a16-7063-8f41-84d081bdb6e5 | SLV | 2026-09-23 13:44 | call_diagonal_spread | 2 | 1 | 70 | 213710.00 | short | bid | 58.3299 | 0.3500 | ["45","50"] | ["0.3654","0.3675"] | [] | ["BATO"] | 45.0000 | 50.0000 | 205 | 485 | false | false | true | ||||||||||
| 01a0cecc-c9f7-7291-8386-3f70835f1737 | SLV | 2026-09-23 11:05 | call_diagonal_spread | 2 | 1 | 168 | 163968.00 | short | bid | 58.4550 | 0.2000 | ["66","71"] | ["0.4088","0.4232"] | [] | ["XISX"] | 66.0000 | 71.0000 | 205 | 267 | false | true | true | ||||||||||
| 01a0ce8f-112f-7890-ad89-b60bcadd37e8 | SLV | 2026-09-23 09:57 | call_diagonal_spread | 2 | 3 | 122 | 114924.00 | short | bid | 58.3050 | 0.2500 | ["58","65"] | ["0.3798","0.4033"] | [] | ["BATO","EDGO","XCBO"] | 58.0000 | 65.0000 | 86 | 189 | false | false | true | ||||||||||
| 01a0caa1-834f-73d1-89ea-425e4db09c4e | SLV | 2026-09-22 15:39 | call_diagonal_spread | 2 | 1 | 164 | 179908.00 | short | ask | 60.9300 | 0.2500 | ["60.5","61.5"] | ["0.3905","0.3933"] | [] | ["XCBO"] | 60.5000 | 61.5000 | 100 | 115 | false | false | true | ||||||||||
| 01a0c9b3-3767-76f0-a7ae-e06828b5ac90 | SLV | 2026-09-22 11:19 | call_diagonal_spread | 2 | 1 | 174 | 331992.00 | short | bid | 59.6650 | 0.1500 | ["55","58.5"] | ["0.3763","0.3896"] | [] | ["XISX"] | 55.0000 | 58.5000 | 190 | 281 | false | false | true | ||||||||||
| 01a0c970-f28f-7492-8575-9923e39dd925 | SLV | 2026-09-22 10:06 | call_diagonal_spread | 2 | 1 | 204 | 374748.00 | short | ask | 59.3890 | 0.4500 | ["56","63"] | ["0.3841","0.4084"] | [] | ["XISX"] | 56.0000 | 63.0000 | 206 | 360 | false | false | true | ||||||||||
| 01a0c962-6017-7583-9a41-4b02a0fcffad | SLV | 2026-09-22 09:51 | call_diagonal_spread | 2 | 1 | 106 | 199810.00 | short | ask | 59.5776 | 0.4500 | ["55","63"] | ["0.3817","0.4094"] | [] | ["MCRY"] | 55.0000 | 63.0000 | 190 | 360 | false | false | true | ||||||||||
| 01a0c542-6bdf-73f2-8c85-5d8195ae7c90 | SLV | 2026-09-21 14:37 | call_diagonal_spread | 2 | 1 | 80 | 150240.00 | short | ask | 59.6100 | 0.5500 | ["63","70"] | ["0.4140","0.4250"] | [] | ["XCBO"] | 63.0000 | 70.0000 | 361 | 487 | false | true | true | ||||||||||
| 01a0c50a-c9ae-7200-9e24-64162d941eb0 | SLV | 2026-09-21 13:36 | call_diagonal_spread | 2 | 1 | 100 | 282490.00 | short | bid | 59.3850 | 0.5300 | ["40","70"] | ["0.3601","0.4306"] | [] | ["XISX"] | 40.0000 | 70.0000 | 116 | 816 | false | false | true | ||||||||||
| 01a0c505-998f-7831-b13b-42580218b764 | SLV | 2026-09-21 13:31 | call_diagonal_spread | 2 | 1 | 162 | 298080.00 | short | bid | 59.4100 | 0.4500 | ["59","59.5"] | ["0.4026","0.4025"] | [] | ["XISX"] | 59.0000 | 59.5000 | 269 | 282 | false | false | true | ||||||||||
| 01a0aba2-2944-7c83-936f-608dfa346e7d | SLV | 2026-09-16 15:12 | call_diagonal_spread | 2 | 1 | 80 | 123680.00 | short | bid | 56.5950 | 0.3500 | ["56","60.5"] | ["0.4158","0.4264"] | [] | ["BATO"] | 56.0000 | 60.5000 | 196 | 287 | false | false | true | ||||||||||
| 01a0ab6d-f5fb-7193-a4f2-d7ca8fe73ab0 | SLV | 2026-09-16 14:15 | call_diagonal_spread | 2 | 1 | 105 | 172200.00 | short | ask | 57.4750 | 0.4500 | ["57","60.5"] | ["0.4217","0.4252"] | [] | ["XISX"] | 57.0000 | 60.5000 | 212 | 287 | false | false | true | ||||||||||
| 01a0ab6d-f5fb-7193-a4f2-d7bb988736f3 | SLV | 2026-09-16 14:15 | call_diagonal_spread | 2 | 2 | 95 | 155914.00 | short | ask | 57.4750 | 0.4500 | ["57","60.5"] | ["0.4220","0.4255"] | [] | ["EDGO","XISX"] | 57.0000 | 60.5000 | 212 | 287 | false | false | true | ||||||||||
| 01a0aa69-479b-7410-88f5-c5a65d376dad | SLV | 2026-09-16 09:30 | call_diagonal_spread | 2 | 4 | 48 | 153744.00 | short | ask | 58.3850 | 0.3500 | ["42","44"] | ["2.1552","0.4228"] | [] | ["C2OX","EDGO","XCBO","XISX"] | 42.0000 | 44.0000 | 2 | 121 | false | false | true | ||||||||||
| 01a0aa69-43ba-7cd0-b514-4178d8968336 | SLV | 2026-09-16 09:30 | call_diagonal_spread | 2 | 3 | 42 | 134518.00 | short | ask | 58.3950 | 0.3500 | ["42","44"] | ["2.0944","0.4210"] | [] | ["C2OX","MCRY","XISX"] | 42.0000 | 44.0000 | 2 | 121 | false | false | true | ||||||||||
| 01a0a667-5a0e-7592-a36d-ee2baa7fd4c5 | SLV | 2026-09-15 14:49 | call_diagonal_spread | 2 | 1 | 199 | 331335.00 | short | ask | 57.6100 | 0.2000 | ["57","60"] | ["0.4241","0.4280"] | [] | ["XISX"] | 57.0000 | 60.0000 | 213 | 275 | false | false | true | ||||||||||
| 01a0a0c1-d429-75c2-b2c4-22073d0fbe97 | SLV | 2026-09-14 12:30 | call_diagonal_spread | 2 | 2 | 182 | 286238.00 | short | bid | 57.2900 | 0.4500 | ["57","66"] | ["0.4244","0.4388"] | [] | ["BATO","XISX"] | 57.0000 | 66.0000 | 198 | 368 | false | false | true | ||||||||||
| 01a08c3c-3660-7301-9d77-2ad72b73e5d7 | SLV | 2026-09-10 12:52 | call_diagonal_spread | 2 | 1 | 1061 | 185675.00 | short | ask | 58.0700 | 0.0300 | ["85","100"] | ["0.5610","0.5960"] | [] | ["C2OX"] | 85.0000 | 100.0000 | 99 | 127 | false | true | true | ||||||||||
| 01a08c39-8eb0-7e90-929f-deeffd134775 | SLV | 2026-09-10 12:49 | call_diagonal_spread | 2 | 3 | 986 | 172550.00 | short | ask | 58.0281 | 0.0300 | ["85","100"] | ["0.5618","0.5967"] | [] | ["C2OX","EDGO","XCBO"] | 85.0000 | 100.0000 | 99 | 127 | false | true | true | ||||||||||
| 01a08bdd-12e9-7912-976c-092352590b05 | SLV | 2026-09-10 11:08 | call_diagonal_spread | 2 | 1 | 300 | 117900.00 | short | bid | 58.1900 | 0.1300 | ["56.5","57.5"] | ["0.6823","0.4698"] | [] | ["XMIO"] | 56.5000 | 57.5000 | 1 | 8 | false | false | true | ||||||||||
| 01a08b85-5211-7931-92d1-0cfd17e763ff | SLV | 2026-09-10 09:32 | call_diagonal_spread | 2 | 3 | 191 | 304867.00 | short | bid | 58.3500 | 0.3859 | ["58","68"] | ["0.4334","0.4467"] | [] | ["EDGO","XBOX","XCBO"] | 58.0000 | 68.0000 | 190 | 372 | false | false | true | ||||||||||
| 01a08173-c681-76b3-84c8-0b16182ef453 | SLV | 2026-09-08 10:37 | call_diagonal_spread | 2 | 1 | 300 | 232800.00 | short | bid | 59.5895 | 0.2000 | ["56","59"] | ["0.5262","0.4329"] | [] | ["SPHR"] | 56.0000 | 59.0000 | 3 | 45 | false | false | true | ||||||||||
| 01a0814c-fcd0-7a60-ad02-8fe4f6355041 | SLV | 2026-09-08 09:54 | call_diagonal_spread | 2 | 2 | 105 | 189075.00 | short | ask | 59.8950 | 0.5500 | ["59","86"] | ["0.4354","0.4683"] | [] | ["BATO","XISX"] | 59.0000 | 86.0000 | 220 | 647 | false | false | true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:09:23Z"} |
| 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-23T17:45:01Z"} |
| 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-23T15:05:51Z"} |
| 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:58:01Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:39:50Z"} |
| 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-22T15:19:35Z"} |
| 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:07:15Z"} |
| 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:51:07Z"} |
| 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-21T18:37: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-21T17:37:02Z"} |
| 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:31:33Z"} |
| 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-16T19:12:05Z"} |
| 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:15:16Z"} |
| 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:15:16Z"} |
| 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-16T13:30:23Z"} |
| 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-16T13:30:23Z"} |
| 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-15T18:50:05Z"} |
| 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-14T16:30:51Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T16:52:38Z"} |
| 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-10T16:50:07Z"} |
| 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-10T15:08: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-10T13:32:48Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:37:44Z"} |
| 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:55:15Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |