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 |
|---|
| 01a0caae-ae67-7212-9c84-d8325d7bab0c | GLD | 2026-09-22 15:53 | put_vertical_spread | 2 | 5 | 12 | 424508.00 | long | ask | 400.4700 | 6.6000 | ["575","580"] | ["0.7752","0.7934"] | [] | ["ARCO","EMLD","SPHR"] | 575.0000 | 580.0000 | 24 | 24 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T19:54:15Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c955-2d2f-7fe2-8751-229888ceef9c | GLD | 2026-09-22 09:36 | put_vertical_spread | 2 | 1 | 25 | 169025.00 | long | ask | 397.5885 | 1.1500 | ["410","440"] | ["0.2309","0.2556"] | ["417.47"] | ["BATO"] | 410.0000 | 440.0000 | 87 | 87 | false | false | false | ||||||||||
| 01a0c511-16f7-73b0-9ee9-efce3108e84b | GLD | 2026-09-21 13:43 | put_vertical_spread | 2 | 1 | 10 | 150310.00 | long | ask | 397.9600 | 1.0000 | ["470","475"] | ["0.2969","0.3062"] | ["470.25"] | ["XISX"] | 470.0000 | 475.0000 | 116 | 116 | false | false | false | ||||||||||
| 01a0c474-f24e-7dd3-b974-b6e5e4743f9e | GLD | 2026-09-21 10:53 | put_vertical_spread | 2 | 1 | 120 | 345960.00 | long | ask | 398.1400 | 0.5500 | ["391","395"] | ["0.2282","0.2292"] | ["393.17"] | ["XMIO"] | 391.0000 | 395.0000 | 101 | 101 | false | true | false | ||||||||||
| 01a0b60f-4210-7531-90b3-18e0a8f5731a | GLD | 2026-09-18 15:47 | put_vertical_spread | 2 | 1 | 3 | 105432.00 | long | ask | 401.8600 | 6.1000 | ["575","580"] | ["0.7538","0.7708"] | [] | ["SPHR"] | 575.0000 | 580.0000 | 28 | 28 | false | false | false | ||||||||||
| 01a0b60f-4210-7531-90b3-18d886eff41e | GLD | 2026-09-18 15:47 | put_vertical_spread | 2 | 4 | 5 | 175746.00 | long | ask | 401.8600 | 6.1000 | ["575","580"] | ["0.7558","0.7729"] | [] | ["ARCO","EMLD","SPHR"] | 575.0000 | 580.0000 | 28 | 28 | false | false | false | ||||||||||
| 01a0b5b9-908f-7692-8366-94849aae9f36 | GLD | 2026-09-18 14:13 | put_vertical_spread | 2 | 1 | 3 | 259356.00 | long | ask | 402.6899 | 2.3000 | ["830","840"] | ["22.4905","21.3676"] | ["830.02"] | ["XPHO"] | 830.0000 | 840.0000 | 0 | 0 | false | false | false | ||||||||||
| 01a0b584-0970-70d3-9ed9-f0b91f1327ae | GLD | 2026-09-18 13:15 | put_vertical_spread | 2 | 1 | 80 | 101440.00 | long | ask | 402.1500 | 0.4500 | ["392","400"] | ["0.2144","0.2142"] | ["396.90"] | ["XCBO"] | 392.0000 | 400.0000 | 28 | 28 | false | true | false | ||||||||||
| 01a0b567-b770-7a82-8feb-dfeebd0f3c0c | GLD | 2026-09-18 12:44 | put_vertical_spread | 2 | 1 | 2 | 138424.00 | long | ask | 401.3900 | 2.3000 | ["745","750"] | ["14.1548","13.9484"] | ["745.02"] | ["XPHO"] | 745.0000 | 750.0000 | 0 | 0 | false | false | false | ||||||||||
| 01a0b4ff-4cf7-7cd2-91e8-f108d31110bd | GLD | 2026-09-18 10:50 | put_vertical_spread | 2 | 1 | 4 | 138688.00 | long | ask | 399.3000 | 1.4500 | ["570","575"] | ["6.0757","6.1195"] | ["570.02"] | ["XPHO"] | 570.0000 | 575.0000 | 0 | 0 | false | false | false | ||||||||||
| 01a0afca-7e03-7a61-be09-69ca26c1df5c | GLD | 2026-09-17 10:34 | put_vertical_spread | 2 | 4 | 114 | 121638.00 | long | ask | 400.2600 | 0.3800 | ["380","400"] | ["0.2399","0.2313"] | ["393.75"] | ["XCBO"] | 380.0000 | 400.0000 | 22 | 22 | false | true | false | ||||||||||
| 01a0ab61-76c3-7902-95bf-9fc2599273b8 | GLD | 2026-09-16 14:01 | put_vertical_spread | 2 | 1 | 150 | 316050.00 | long | ask | 396.9700 | 4.7000 | ["365","400"] | ["0.2487","0.2514"] | ["387.37"] | ["EDGO"] | 365.0000 | 400.0000 | 65 | 65 | false | false | false | ||||||||||
| 01a0aaea-c7f3-7d10-b3b5-0a402f9913f5 | GLD | 2026-09-16 11:51 | put_vertical_spread | 2 | 1 | 500 | 272500.00 | long | ask | 399.0300 | 0.1300 | ["385","400"] | ["0.3832","0.3776"] | ["395.63"] | ["XPHO"] | 385.0000 | 400.0000 | 2 | 2 | false | false | false | ||||||||||
| 01a0aae8-3f83-7472-9c8f-2283cd033a58 | GLD | 2026-09-16 11:48 | put_vertical_spread | 2 | 1 | 8000 | 136000.00 | long | ask | 399.2100 | 0.0400 | ["368","375"] | ["0.4797","0.4345"] | ["374.93"] | ["XMIO"] | 368.0000 | 375.0000 | 2 | 2 | false | true | false | ||||||||||
| 01a0aa9d-2cc3-7c10-a955-2b21a0e1fd58 | GLD | 2026-09-16 10:27 | put_vertical_spread | 2 | 4 | 80000 | 8800000.00 | long | ask | 397.3700 | 0.0800 | ["390","392"] | ["0.6232","0.6565"] | ["391.60"] | ["XCBO"] | 390.0000 | 392.0000 | 0 | 0 | true | true | false | ||||||||||
| 01a0a55d-ecd6-7f20-b046-534210d8f3d3 | GLD | 2026-09-15 09:59 | put_vertical_spread | 2 | 1 | 12 | 189324.00 | long | ask | 393.9200 | 2.3500 | ["440","500"] | ["0.2665","0.3670"] | ["443.95"] | ["XMIO"] | 440.0000 | 500.0000 | 122 | 122 | false | false | false | ||||||||||
| 01a0a0ba-1b98-7a60-9fa8-d2fddd7cf84f | GLD | 2026-09-14 12:22 | put_vertical_spread | 2 | 1 | 70 | 136060.00 | long | ask | 394.4000 | 0.2500 | ["390","395"] | ["0.2417","0.2431"] | ["392.60"] | ["XCBO"] | 390.0000 | 395.0000 | 32 | 32 | false | false | false | ||||||||||
| 01a09201-08c8-7fc3-a216-9fa2a83f62ad | GLD | 2026-09-11 15:45 | put_vertical_spread | 2 | 3 | 5 | 238712.00 | long | ask | 398.4000 | 1.8000 | ["635","640"] | ["1.3749","1.4113"] | [] | ["EMLD","SPHR","XBOX"] | 635.0000 | 640.0000 | 7 | 7 | false | false | false | ||||||||||
| 01a090cc-7c81-70e2-8648-85cb47e8f491 | GLD | 2026-09-11 10:08 | put_vertical_spread | 2 | 1 | 210 | 123060.00 | long | ask | 402.3900 | 0.1500 | ["370","380"] | ["0.2593","0.2503"] | ["378.44"] | ["ARCO"] | 370.0000 | 380.0000 | 35 | 35 | false | true | false | ||||||||||
| 01a08cdf-d518-7501-a66f-1a12d881d084 | GLD | 2026-09-10 15:51 | put_vertical_spread | 2 | 3 | 3 | 144426.00 | long | ask | 396.0600 | 4.2500 | ["635","640"] | ["1.3705","1.4009"] | [] | ["EMLD","SPHR","XBOX"] | 635.0000 | 640.0000 | 8 | 8 | false | false | false | ||||||||||
| 01a08c8c-3ac0-7ea2-b0f8-29a775ed371a | GLD | 2026-09-10 14:19 | put_vertical_spread | 2 | 1 | 71 | 206823.00 | long | ask | 398.0500 | 0.5500 | ["400","405"] | ["0.2590","0.2619"] | ["402.11"] | ["XCBO"] | 400.0000 | 405.0000 | 36 | 36 | false | false | false | ||||||||||
| 01a08bb1-d499-7bf3-bf14-fa5d7cae27c2 | GLD | 2026-09-10 10:21 | put_vertical_spread | 2 | 1 | 20 | 100440.00 | long | ask | 400.0200 | 0.5500 | ["406","414"] | ["0.2514","0.2554"] | ["409.20"] | ["AMXO"] | 406.0000 | 414.0000 | 112 | 112 | false | false | false | ||||||||||
| 01a087b8-2158-7561-b77a-cef2ce73972f | GLD | 2026-09-09 15:49 | put_vertical_spread | 2 | 3 | 3 | 139910.00 | long | ask | 403.4800 | 5.3000 | ["635","640"] | ["1.2882","1.3183"] | [] | ["EMLD","SPHR","XBOX"] | 635.0000 | 640.0000 | 9 | 9 | false | false | false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:36:42Z"} |
| 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-21T17:43:50Z"} |
| 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:53:34Z"} |
| 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:47: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-18T19:47: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-18T18:13:55Z"} |
| 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-18T17:15:31Z"} |
| 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:44:37Z"} |
| 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-18T14:50:36Z"} |
| 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-17T14:34:47Z"} |
| 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-16T18:01:24Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:52:17Z"} |
| 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-16T15:49:43Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:27:28Z"} |
| 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-15T14:00:09Z"} |
| 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-14T16:22:37Z"} |
| 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-11T19:45:50Z"} |
| 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:08:50Z"} |
| 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:51:33Z"} |
| 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-10T18:20:09Z"} |
| 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-10T14:21:42Z"} |
| 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:49:45Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |