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 |
|---|
| 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 | true | 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 |
| 01a0ca89-a207-7412-80f9-1c0397be7f99 | SLV | 2026-09-22 15:13 | call_diagonal_spread | 2 | 1 | 140 | 145880.00 | long | ask | 60.5950 | 0.2000 | ["60","60.5"] | ["0.3883","0.3874"] | [] | ["XCBO"] | 60.0000 | 60.5000 | 87 | 100 | false | false | true | ||||||||||
| 01a0ca7c-fbbf-78d1-b858-245334903da8 | SLV | 2026-09-22 14:59 | call_diagonal_spread | 2 | 1 | 164 | 240752.00 | long | ask | 60.3950 | 0.2957 | ["60","63"] | ["0.3853","0.4055"] | [] | ["XISX"] | 60.0000 | 63.0000 | 87 | 360 | false | false | true | ||||||||||
| 01a0ca28-57c7-7902-bf4a-98c3a34c7a97 | SLV | 2026-09-22 13:27 | call_diagonal_spread | 2 | 1 | 92 | 141220.00 | long | ask | 59.6102 | 0.3000 | ["55","80"] | ["0.3586","0.4357"] | [] | ["XBOX"] | 55.0000 | 80.0000 | 59 | 633 | false | false | true | ||||||||||
| 01a0ca28-4827-7103-abc8-f1d0c494ab7c | SLV | 2026-09-22 13:27 | call_diagonal_spread | 2 | 1 | 72 | 110448.00 | long | ask | 59.6102 | 0.3000 | ["55","80"] | ["0.3586","0.4353"] | [] | ["XBOX"] | 55.0000 | 80.0000 | 59 | 633 | false | false | true | ||||||||||
| 01a0ca28-28e7-7a13-bbc4-12574d873c3a | SLV | 2026-09-22 13:27 | call_diagonal_spread | 2 | 2 | 94 | 144182.00 | long | ask | 59.6102 | 0.4000 | ["55","80"] | ["0.3592","0.4352"] | [] | ["ARCO","XBOX"] | 55.0000 | 80.0000 | 59 | 633 | false | false | true | ||||||||||
| 01a0ca28-155e-75a1-8ab7-dc41e67e4e38 | SLV | 2026-09-22 13:26 | call_diagonal_spread | 2 | 3 | 87 | 134067.00 | long | ask | 59.6050 | 0.4000 | ["55","80"] | ["0.3591","0.4377"] | [] | ["C2OX","XCBO","XISX"] | 55.0000 | 80.0000 | 59 | 633 | false | false | true | ||||||||||
| 01a0ca15-028e-7863-a926-15125d7aea69 | SLV | 2026-09-22 13:06 | call_diagonal_spread | 2 | 1 | 204 | 381684.00 | unknown | ask | 59.7050 | 0.4000 | ["58.5","69"] | ["0.3886","0.4138"] | [] | ["XMIO"] | 58.5000 | 69.0000 | 268 | 486 | 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 | ||||||||||
| 01a0c506-64af-7da3-af69-d9e37218f714 | SLV | 2026-09-21 13:32 | call_diagonal_spread | 2 | 1 | 72 | 133488.00 | long | ask | 59.4550 | 0.3500 | ["59.5","63"] | ["0.4021","0.4126"] | [] | ["EDGO"] | 59.5000 | 63.0000 | 282 | 361 | false | true | true | ||||||||||
| 01a0c506-64af-7da3-af69-d9d7c310f523 | SLV | 2026-09-21 13:32 | call_diagonal_spread | 2 | 1 | 90 | 166860.00 | long | ask | 59.4550 | 0.3500 | ["59.5","63"] | ["0.4021","0.4126"] | [] | ["XCBO"] | 59.5000 | 63.0000 | 282 | 361 | false | true | true | ||||||||||
| 01a0c4db-af17-7d71-90d3-3df8cd9b500d | SLV | 2026-09-21 12:45 | call_diagonal_spread | 2 | 1 | 197 | 360707.00 | long | ask | 59.6450 | 0.3500 | ["57","59"] | ["0.3937","0.4004"] | [] | ["XMIO"] | 57.0000 | 59.0000 | 207 | 269 | false | false | true | ||||||||||
| 01a0c4a3-1e9f-7c63-84f6-ceac099750e1 | SLV | 2026-09-21 11:43 | call_diagonal_spread | 2 | 1 | 100 | 103200.00 | long | ask | 59.7300 | 0.0700 | ["59","63"] | ["0.4023","0.4031"] | [] | ["XISX"] | 59.0000 | 63.0000 | 60 | 179 | false | false | true | ||||||||||
| 01a0c44d-d2af-7a02-9eb4-6929d0100aef | SLV | 2026-09-21 10:10 | call_diagonal_spread | 2 | 1 | 40 | 123640.00 | long | ask | 59.7600 | 0.7000 | ["40","60"] | ["0.3630","0.3965"] | [] | ["XMIO"] | 40.0000 | 60.0000 | 88 | 816 | 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 | ||||||||||
| 01a0a6a4-66f6-7be3-85a9-37f4b9929eef | SLV | 2026-09-15 15:56 | call_diagonal_spread | 2 | 1 | 180 | 296820.00 | long | ask | 57.5000 | 0.4000 | ["57","60.5"] | ["0.4210","0.4273"] | [] | ["XCBO"] | 57.0000 | 60.5000 | 213 | 288 | 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 | ||||||||||
| 01a0a5d7-faee-7912-ae0e-63b68b197191 | SLV | 2026-09-15 12:13 | call_diagonal_spread | 2 | 1 | 198 | 313038.00 | long | ask | 57.0400 | 0.2500 | ["53.5","60"] | ["0.4253","0.4305"] | [] | ["XISX"] | 53.5000 | 60.0000 | 122 | 275 | false | false | true | ||||||||||
| 01a0920a-53b1-72b1-8198-a220386f7df7 | SLV | 2026-09-11 15:55 | call_diagonal_spread | 2 | 1 | 139 | 154985.00 | long | ask | 58.1150 | 0.2500 | ["52","53.5"] | ["0.4642","0.3473"] | [] | ["SPHR"] | 52.0000 | 53.5000 | 7 | 14 | false | false | true | ||||||||||
| 01a090be-c4c8-7872-af12-1fba0ee71ad6 | SLV | 2026-09-11 09:53 | call_diagonal_spread | 2 | 1 | 90 | 153090.00 | long | ask | 58.6850 | 0.3800 | ["50","64"] | ["0.4096","0.5073"] | [] | ["BATO"] | 50.0000 | 64.0000 | 7 | 497 | false | false | true | ||||||||||
| 01a090b9-5a11-7293-9abc-dea68b9c2e3f | SLV | 2026-09-11 09:47 | call_diagonal_spread | 2 | 2 | 140 | 238280.00 | long | ask | 58.8120 | 0.4200 | ["50","64"] | ["0.4075","0.4723"] | [] | ["AMXO"] | 50.0000 | 64.0000 | 7 | 497 | false | false | true | ||||||||||
| 01a090b9-5a11-7293-9abc-de9be8aa156b | SLV | 2026-09-11 09:47 | call_diagonal_spread | 2 | 2 | 140 | 238770.00 | long | ask | 58.8120 | 0.4200 | ["50","64"] | ["0.4082","0.4851"] | [] | ["AMXO","XISX"] | 50.0000 | 64.0000 | 7 | 497 | false | false | true | ||||||||||
| 01a090b9-5628-7810-b961-06559dce4b65 | SLV | 2026-09-11 09:47 | call_diagonal_spread | 2 | 1 | 70 | 119630.00 | long | ask | 58.8120 | 0.4200 | ["50","64"] | ["0.4089","0.4980"] | [] | ["XISX"] | 50.0000 | 64.0000 | 7 | 497 | false | false | true | ||||||||||
| 01a08c69-2260-78f3-bf91-abfb17f79ec4 | SLV | 2026-09-10 13:41 | call_diagonal_spread | 2 | 2 | 2500 | 370000.00 | long | ask | 58.0097 | 0.0500 | ["65","73"] | ["0.5652","0.5145"] | [] | ["AMXO"] | 65.0000 | 73.0000 | 8 | 71 | false | true | 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 | ||||||||||
| 01a08797-6e41-7702-af1a-42c1544116bf | SLV | 2026-09-09 15:14 | call_diagonal_spread | 2 | 1 | 177 | 340194.00 | long | ask | 60.8150 | 0.4500 | ["58","74"] | ["0.4365","0.4534"] | [] | ["BATO"] | 58.0000 | 74.0000 | 191 | 499 | 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 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:13:52Z"} |
| 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-22T18:59:44Z"} |
| 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-22T17:27:16Z"} |
| 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-22T17:27:16Z"} |
| 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-22T17:27:16Z"} |
| 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-22T17:27:16Z"} |
| 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-22T17:06:23Z"} |
| 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:32:15Z"} |
| 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-21T17:32:15Z"} |
| 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-21T16:45:32Z"} |
| 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:43: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-21T14:10:36Z"} |
| 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-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 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:56:33Z"} |
| 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: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-15T16:13:16Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:55:54Z"} |
| 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-11T13:53:46Z"} |
| 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-11T13:47:53Z"} |
| 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-11T13:47:53Z"} |
| 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-11T13:47:53Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:41:35Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 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 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:14:13Z"} |
| 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-08T13:55:15Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |