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 |
|---|
| 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 |
|---|
| 01a0ca51-ffd7-74f3-b376-4901181d79e3 | GOOG | 2026-09-22 14:12 | put_vertical_spread | 2 | 1 | 57 | 38190.00 | short | bid | 348.7000 | 0.1500 | ["320","325"] | ["0.3240","0.3194"] | ["324.10"] | ["C2OX"] | 320.0000 | 325.0000 | 31 | 31 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T18:13:21Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c9e6-39ff-7aa2-a3dd-12704bf54ef4 | GOOG | 2026-09-22 12:15 | put_calendar | 2 | 1 | 200 | 79800.00 | short | bid | 348.5900 | 0.3900 | ["320"] | ["0.3225"] | [] | ["XISX"] | 320.0000 | 320.0000 | 17 | 31 | false | true | |||||||||||
| 01a0c98d-830e-7580-97d8-0c7c24a98f30 | GOOG | 2026-09-22 10:38 | put_butterfly_spread | 3 | 1 | 34 | 115855.00 | long | ask | 356.6400 | 1.1500 | ["320","325","330"] | ["0.3495","0.3485","0.3480"] | ["320.15","329.85"] | ["C2OX"] | 320.0000 | 330.0000 | 178 | 178 | false | true | |||||||||||
| 01a0c971-b9c6-7e80-a7ee-cbe97b7fbee8 | GOOG | 2026-09-22 10:07 | call_vertical_spread | 2 | 1 | 20 | 122200.00 | long | ask | 355.5700 | 1.2500 | ["335","345"] | ["0.3724","0.3597"] | ["341.70"] | ["C2OX"] | 335.0000 | 345.0000 | 59 | 59 | false | false | |||||||||||
| 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 | |||||||||||
| 01a0c570-03bf-7801-ad13-2b02098b685c | GOOG | 2026-09-21 15:27 | call_diagonal_spread | 2 | 1 | 5 | 37375.00 | short | ask | 351.8100 | 1.1500 | ["312.5","317.5"] | ["0.5864","0.3584"] | [] | ["XCBO"] | 312.5000 | 317.5000 | 4 | 11 | false | false | |||||||||||
| 01a0c4fb-e917-7651-a29d-6a9b47ace0c0 | GOOG | 2026-09-21 13:20 | call_vertical_spread | 2 | 2 | 20 | 30800.00 | unknown | ask | 351.8000 | 0.1250 | ["350","365"] | ["0.3045","0.3038"] | ["365.20"] | ["MCRY","XPHO"] | 350.0000 | 365.0000 | 18 | 18 | false | false | |||||||||||
| 01a0c4e3-e0bf-7781-82da-07b31b7bf251 | GOOG | 2026-09-21 12:54 | call_diagonal_spread | 2 | 1 | 20 | 41280.00 | unknown | bid | 351.2740 | 0.4100 | ["360","400"] | ["0.3334","0.4805"] | [] | ["XBOX"] | 360.0000 | 400.0000 | 4 | 88 | false | true | |||||||||||
| 01a0b60e-ada0-71d0-931e-c0a8d608bf20 | GOOG | 2026-09-18 15:46 | call_calendar | 2 | 1 | 10 | 67850.00 | unknown | ask | 347.5500 | 3.8000 | ["315"] | ["7.4502"] | [] | ["XCBO"] | 315.0000 | 315.0000 | 0 | 28 | false | false | |||||||||||
| 01a0b5dd-5c9f-7821-bc24-0f8865c34073 | GOOG | 2026-09-18 14:52 | call_diagonal_spread | 2 | 1 | 2 | 49460.00 | short | bid | 347.7500 | 3.3500 | ["225","240"] | ["18.1717","0.3591"] | [] | ["MCRY"] | 225.0000 | 240.0000 | 0 | 364 | false | false | |||||||||||
| 01a0b564-6baf-7bc1-bada-36eadd6dd38b | GOOG | 2026-09-18 12:40 | put_vertical_spread | 2 | 1 | 3 | 28245.00 | short | bid | 345.9600 | 0.4000 | ["340","420"] | ["0.3373","0.3735"] | ["362.75"] | ["XISX"] | 340.0000 | 420.0000 | 91 | 91 | false | false | |||||||||||
| 01a0b4cb-e4cf-7a71-9170-2534e812bf23 | GOOG | 2026-09-18 09:54 | put_vertical_spread | 2 | 1 | 10 | 67350.00 | short | bid | 351.2450 | 0.5500 | ["345","350"] | ["0.3450","0.3452"] | ["347.55"] | ["C2OX"] | 345.0000 | 350.0000 | 272 | 272 | false | true | |||||||||||
| 01a0aa6a-513b-73a1-bb55-b80fb74437da | GOOG | 2026-09-16 09:31 | call_diagonal_spread | 2 | 1 | 10 | 59400.00 | unknown | — | 343.9550 | 1.6000 | ["342.5","345"] | ["0.3936","0.3504"] | [] | ["XPHO"] | 342.5000 | 345.0000 | 2 | 366 | false | false | true | true | |||||||||
| 01a0a6a3-de3e-7e10-b507-27f2277741c8 | GOOG | 2026-09-15 15:55 | call_diagonal_spread | 2 | 1 | 7 | 52150.00 | long | ask | 341.4401 | 2.0500 | ["335","340"] | ["0.3504","0.3532"] | [] | ["XCBO"] | 335.0000 | 340.0000 | 157 | 185 | false | false | |||||||||||
| 01a0a647-a0f6-7e13-a13c-976094bc2184 | GOOG | 2026-09-15 14:15 | call_vertical_spread | 2 | 1 | 5 | 28975.00 | short | bid | 340.4000 | 0.8000 | ["345","355"] | ["0.3474","0.3453"] | ["349.45"] | ["XISX"] | 345.0000 | 355.0000 | 157 | 157 | false | true | |||||||||||
| 01a0a113-c0d1-7862-840b-bbfb2c2fa81b | GOOG | 2026-09-14 14:00 | other | 2 | 1 | 8 | 25760.00 | unknown | — | 345.5900 | 0.8500 | ["330","340"] | ["0.3683","0.2982"] | [] | ["XISX"] | 330.0000 | 340.0000 | 4 | 32 | false | false | true | true | false | ||||||||
| 01a0a108-08d0-76b0-8a4a-fd218bee1e3b | GOOG | 2026-09-14 13:47 | call_diagonal_spread | 2 | 1 | 36 | 31680.00 | short | bid | 346.0100 | 0.8500 | ["350","380"] | ["0.3323","0.3341"] | [] | ["EMLD"] | 350.0000 | 380.0000 | 4 | 46 | false | true | |||||||||||
| 01a0a0d9-9e01-7f01-935d-bb267c931d2e | GOOG | 2026-09-14 12:56 | call_vertical_spread | 2 | 1 | 10 | 27050.00 | short | bid | 344.3100 | 0.2000 | ["340","345"] | ["0.2948","0.2937"] | ["342.65"] | ["XISX"] | 340.0000 | 345.0000 | 32 | 32 | false | false | |||||||||||
| 01a0a05e-8e18-7243-a075-6c3230124b9f | GOOG | 2026-09-14 10:42 | call_vertical_spread | 2 | 1 | 12 | 56280.00 | short | bid | 340.6100 | 1.5500 | ["315","440"] | ["0.3348","0.3385"] | ["354"] | ["XCBO"] | 315.0000 | 440.0000 | 123 | 123 | false | false | |||||||||||
| 01a08c35-4508-7282-9090-335039d8092b | GOOG | 2026-09-10 12:44 | other | 3 | 1 | 174 | 401157.00 | unknown | — | 329.0200 | 0.5800 | ["320","350","410"] | ["0.2992","0.3470","0.3684"] | [] | ["C2OX"] | 320.0000 | 410.0000 | 36 | 71 | false | false | true | true | |||||||||
| 01a08788-b4b8-7100-b000-c34a317346c5 | GOOG | 2026-09-09 14:57 | strangle | 2 | 1 | 32 | 111840.00 | short | bid | 327.9900 | 0.2000 | ["320","360"] | ["0.3312","0.3344"] | ["285.05","394.95"] | ["XISX"] | 320.0000 | 360.0000 | 128 | 128 | false | true | |||||||||||
| 01a08779-37e0-7c03-abf2-97dabe442ec4 | GOOG | 2026-09-09 14:41 | call_diagonal_spread | 2 | 1 | 14 | 147560.00 | long | bid | 328.3600 | 1.3500 | ["275","290"] | ["0.4910","0.3454"] | [] | ["XCBO"] | 275.0000 | 290.0000 | 9 | 128 | false | false | |||||||||||
| 01a08296-6108-79a3-b5ff-394b67f37d3f | GOOG | 2026-09-08 15:54 | put_vertical_spread | 2 | 1 | 10 | 25550.00 | long | ask | 334.6700 | 0.7000 | ["335","345"] | ["0.2924","0.2992"] | ["338.95"] | ["XCBO"] | 335.0000 | 345.0000 | 24 | 24 | false | false | |||||||||||
| 01a08248-dd49-7672-91f0-c9bb0ceb4b27 | GOOG | 2026-09-08 14:30 | call_diagonal_spread | 2 | 1 | 10 | 167850.00 | short | ask | 334.8200 | 1.5000 | ["280","360"] | ["0.3823","0.3768"] | [] | ["XCBO"] | 280.0000 | 360.0000 | 465 | 829 | false | false | |||||||||||
| 01a0822d-a488-7ef1-88eb-213c2d08b107 | GOOG | 2026-09-08 14:00 | put_vertical_spread | 2 | 1 | 40 | 41400.00 | unknown | — | 335.5700 | 0.3000 | ["315","320"] | ["0.2994","0.2974"] | [] | ["XISX"] | 315.0000 | 320.0000 | 38 | 38 | false | true | false | true | |||||||||
| 01a081b4-7130-7e22-b419-11fe526962f8 | GOOG | 2026-09-08 11:47 | call_vertical_spread | 2 | 1 | 5 | 32550.00 | long | ask | 335.1000 | 0.5000 | ["325","330"] | ["0.3371","0.3361"] | ["327.70"] | ["C2OX"] | 325.0000 | 330.0000 | 129 | 129 | false | false | |||||||||||
| 01a06d3a-12b5-7b30-887a-1e7f09c98764 | GOOG | 2026-09-04 12:21 | iron_condor | 4 | 1 | 102 | 119850.00 | unknown | — | 335.4000 | 0.7800 | ["300","310","365","375"] | ["0.2928","0.2833","0.2893","0.2949"] | [] | ["C2OX"] | 300.0000 | 375.0000 | 42 | 42 | false | true | false | true | |||||||||
| 01a06d25-7945-7821-a11e-fde9b3be5054 | GOOG | 2026-09-04 11:59 | other | 4 | 1 | 10 | 217725.00 | unknown | — | 334.9547 | 5.5000 | ["420","430","520","540"] | ["0.3800","0.3852","0.3529","0.3538"] | [] | ["XISX"] | 420.0000 | 540.0000 | 469 | 469 | false | false | false | true |
| false |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:15:43Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:38:21Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:08:05Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| 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 |
| true |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:27:47Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:20:47Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:54:47Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:47:05Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:52:57Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:40:58Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:54:15Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:31:46Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:56:10Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:15:11Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T18:00:37Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:47:43Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:57:12Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:42:25Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T16:45:06Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| true |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T18:58:22Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T18:41:44Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:55:01Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:30:36Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:00:22Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:48:07Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:22:25Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T15:59:38Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |