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 |
|---|
| 01a0d4ca-770f-7e10-95cf-156f84e256b8 | GOOG | 2026-09-24 15:00 | put_diagonal_spread | 2 | 1 | 5 | 27450.00 | short | ask | 337.7900 | 1.1000 | ["360","370"] | ["0.3250","0.8032"] | [] | ["BATO"] | 360.0000 | 370.0000 | 1 | 8 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T19:00:45Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0d4be-038f-76b3-a618-b2b6ae9777dc | GOOG | 2026-09-24 14:46 | put_diagonal_spread | 2 | 1 | 109 | 1871530.00 | unknown | ask | 338.4200 | 4.9500 | ["365","480"] | ["1.3494","0.5448"] | [] | ["XBOX"] | 365.0000 | 480.0000 | 1 | 113 | false | false | true | ||||||||||
| 01a0cea7-30f6-7b92-9750-ead1f8b37817 | GOOG | 2026-09-23 10:24 | put_diagonal_spread | 2 | 1 | 10 | 123500.00 | long | ask | 337.0600 | 4.9000 | ["350","400"] | ["0.3550","0.3790"] | [] | ["XPHO"] | 350.0000 | 400.0000 | 267 | 450 | false | false | true | ||||||||||
| 01a0ce8b-c957-7ba1-b158-cbf154fc2f5a | GOOG | 2026-09-23 09:54 | put_diagonal_spread | 2 | 1 | 17 | 66045.00 | short | ask | 341.6500 | 1.5500 | ["325","335"] | ["0.3460","0.3300"] | [] | ["XPHO"] | 325.0000 | 335.0000 | 114 | 149 | false | true | true | ||||||||||
| 01a0c966-a9bf-7e60-bdc3-7cd31923664b | GOOG | 2026-09-22 09:55 | put_diagonal_spread | 2 | 4 | 198 | 406659.00 | unknown | ask | 357.0800 | 0.5722 | ["345","375"] | ["0.3093","0.3572"] | [] | ["ARCO","EMLD","SPHR","XISX"] | 345.0000 | 375.0000 | 24 | 59 | false | false | true | ||||||||||
| 01a0c966-9e08-7e83-8616-a73f435ca6dd | GOOG | 2026-09-22 09:55 | put_diagonal_spread | 2 | 1 | 46 | 94530.00 | unknown | ask | 357.1800 | 0.3500 | ["345","375"] | ["0.3106","0.3582"] | [] | ["C2OX"] | 345.0000 | 375.0000 | 24 | 59 | false | false | true | ||||||||||
| 01a0c965-d6cf-7862-af12-92cfd6aadb4e | GOOG | 2026-09-22 09:54 | put_diagonal_spread | 2 | 2 | 56 | 115108.00 | unknown | ask | 357.2500 | 0.6000 | ["345","375"] | ["0.3119","0.3584"] | [] | ["C2OX","EDGO"] | 345.0000 | 375.0000 | 24 | 59 | false | false | true | ||||||||||
| 01a0c961-3736-7c50-9647-599d8bbb8edc | GOOG | 2026-09-22 09:49 | put_diagonal_spread | 2 | 1 | 400 | 775600.00 | unknown | ask | 359.3700 | 0.4500 | ["345","375"] | ["0.3136","0.3590"] | [] | ["XCBO"] | 345.0000 | 375.0000 | 24 | 59 | false | false | true | ||||||||||
| 01a0b5ee-351f-7520-86a6-ec5ffb2899f1 | GOOG | 2026-09-18 15:11 | put_diagonal_spread | 2 | 1 | 10 | 25600.00 | long | ask | 347.4400 | 0.7500 | ["350","370"] | ["0.6676","0.3256"] | [] | ["XPHO"] | 350.0000 | 370.0000 | 0 | 7 | false | false | true | ||||||||||
| 01a0b4c6-2fdf-72e0-bc0b-a71e4f85eeed | GOOG | 2026-09-18 09:47 | put_diagonal_spread | 2 | 1 | 15 | 102900.00 | short | ask | 350.7900 | 4.9500 | ["300","375"] | ["0.3633","0.3278"] | [] | ["XISX"] | 300.0000 | 375.0000 | 91 | 819 | false | false | true | ||||||||||
| 01a0b4b5-efdb-7551-9ab5-8e1397dc57f4 | GOOG | 2026-09-18 09:30 | put_diagonal_spread | 2 | 1 | 5 | 36135.00 | short | ask | 351.3600 | 9.2000 | ["330","335"] | ["0.3546","0.3557"] | [] | ["XCBO"] | 330.0000 | 335.0000 | 455 | 490 | false | true | true | ||||||||||
| 01a0b0ac-98d3-7db2-99f3-34e0586be80b | GOOG | 2026-09-17 14:41 | put_diagonal_spread | 2 | 1 | 10 | 28070.00 | long | ask | 342.1400 | 1.3100 | ["350","355"] | ["0.2885","0.5030"] | [] | ["XMIO"] | 350.0000 | 355.0000 | 1 | 29 | false | false | true | ||||||||||
| 01a0abc9-e523-7b02-ae63-366f6460910e | GOOG | 2026-09-16 15:55 | put_diagonal_spread | 2 | 1 | 20 | 105240.00 | long | ask | 339.4950 | 4.0500 | ["360","370"] | ["0.3432","0.3051"] | [] | ["XMIO"] | 360.0000 | 370.0000 | 2 | 30 | false | false | true | ||||||||||
| 01a0abbd-005b-77c0-a655-7724a772f1e5 | GOOG | 2026-09-16 15:41 | put_diagonal_spread | 2 | 1 | 10 | 83550.00 | long | ask | 339.6900 | 3.8500 | ["375","380"] | ["0.3634","0.3555"] | [] | ["XPHO"] | 375.0000 | 380.0000 | 30 | 65 | false | false | true | ||||||||||
| 01a0a022-7b30-7443-9b9f-706dbb2acb0c | GOOG | 2026-09-14 09:36 | put_diagonal_spread | 2 | 1 | 45 | 295651.00 | short | ask | 339.4550 | 5.0500 | ["360","375"] | ["0.3404","0.7091"] | [] | ["XCBO"] | 360.0000 | 375.0000 | 4 | 67 | false | false | true | ||||||||||
| 01a0916c-2398-7ae0-8ad8-bb21a7dcb2c9 | GOOG | 2026-09-11 13:02 | put_diagonal_spread | 2 | 2 | 12 | 27828.00 | long | ask | 337.9000 | 1.0500 | ["340","345"] | ["0.2951","0.2818"] | [] | ["XISX"] | 340.0000 | 345.0000 | 7 | 42 | false | false | true | ||||||||||
| 01a0916a-9cf9-7572-86a6-8ba2cdcd665f | GOOG | 2026-09-11 13:01 | put_diagonal_spread | 2 | 2 | 13 | 36920.00 | short | ask | 337.6999 | 1.6000 | ["350","352.5"] | ["0.2895","1.2863"] | [] | ["XMIO"] | 350.0000 | 352.5000 | 0 | 7 | false | false | true | ||||||||||
| 01a08721-bd58-70c2-9b86-82b7fc7ab3f6 | GOOG | 2026-09-09 13:05 | put_diagonal_spread | 2 | 1 | 5 | 26295.00 | long | ask | 328.1300 | 2.1500 | ["352.5","355"] | ["0.6034","0.3361"] | [] | ["C2OX"] | 352.5000 | 355.0000 | 2 | 16 | false | false | true | ||||||||||
| 01a086c0-f7e8-7622-b805-3187d6aea5e9 | GOOG | 2026-09-09 11:19 | put_diagonal_spread | 2 | 1 | 4 | 40080.00 | long | ask | 326.7700 | 5.4000 | ["370","375"] | ["0.3526","0.5337"] | [] | ["ARCO"] | 370.0000 | 375.0000 | 9 | 128 | false | false | true | ||||||||||
| 01a0868d-5cf8-7e60-88e6-1b60d0280d10 | GOOG | 2026-09-09 10:23 | put_diagonal_spread | 2 | 7 | 10 | 54790.00 | long | ask | 328.0800 | 1.4500 | ["340","350"] | ["0.3476","0.3204"] | [] | ["ARCO","BATO","C2OX","EDGO","EMLD","SPHR","XBOX"] | 340.0000 | 350.0000 | 37 | 100 | false | false | true | ||||||||||
| 01a0867f-ef78-70a3-b77d-7b97f85d7328 | GOOG | 2026-09-09 10:08 | put_diagonal_spread | 2 | 1 | 30 | 43980.00 | long | ask | 327.3200 | 0.5500 | ["305","325"] | ["0.3507","0.3063"] | [] | ["XISX"] | 305.0000 | 325.0000 | 9 | 72 | false | true | true | ||||||||||
| 01a08182-ca40-7001-acc4-f2540935a91e | GOOG | 2026-09-08 10:53 | put_diagonal_spread | 2 | 1 | 50 | 188300.00 | long | ask | 334.3300 | 1.8500 | ["315","350"] | ["0.3372","0.3209"] | [] | ["XISX"] | 315.0000 | 350.0000 | 10 | 192 | false | false | true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:46:58Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:24:24Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T13:54:23Z"} |
| 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-22T13:55:52Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:55: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-22T13:54:58Z"} |
| 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-22T13:49:51Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:11:33Z"} |
| 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-18T13:48:09Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:30:09Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:41:47Z"} |
| 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-16T19:55:31Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:41:34Z"} |
| 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-14T13:36:58Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T17:03:27Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T17:01:52Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:06:09Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:19:59Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:23:34Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:08:56Z"} |
| 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-08T14:53:53Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |