core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg570,195 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 |
|---|
| 01a0eeb7-90b7-7f62-a2d5-1cd4686d8916 | GOOGL | 2026-09-29 15:50 | put_calendar | 2 | 1 | 100 | 403000.00 | long | bid | 341.6900 | 5.4000 | ["360"] | ["0.3163"] | [] | ["XISX"] | 360.0000 | 360.0000 | 10 | 17 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-29T19:50:02Z"} | 2026-09-29 | 2026-09-29 17:15 | 2026-09-29 17:15 |
| 01a0e881-011e-74d3-b8bd-f5687c1a99b4 | GOOGL | 2026-09-28 10:52 | put_calendar | 2 | 1 | 6 | 122226.00 | short | bid | 340.6529 | 4.0500 | ["440"] | ["0.4006"] | [] | ["BATO"] | 440.0000 | 440.0000 | 109 | 262 | false | false | true | false | |||||||||
| 01a0da1a-dcc6-7843-8f79-3c5548f43250 | GOOGL | 2026-09-25 15:46 | put_calendar | 2 | 1 | 45 | 145125.00 | short | bid | 344.1699 | 1.3500 | ["360"] | ["0.3094"] | [] | ["XISX"] | 360.0000 | 360.0000 | 3 | 5 | false | false | true | false | |||||||||
| 01a0d9b9-a9f6-75a2-87cd-cb1ef30b46b2 | GOOGL | 2026-09-25 14:00 | put_calendar | 2 | 1 | 50 | 245300.00 | short | bid | 344.2400 | 0.7000 | ["350"] | ["0.3330"] | [] | ["XMIO"] | 350.0000 | 350.0000 | 84 | 112 | false | false | true | false | |||||||||
| 01a0d997-be5f-7490-9194-7367d25699d2 | GOOGL | 2026-09-25 13:23 | put_calendar | 2 | 1 | 1000 | 1968000.00 | short | bid | 344.4968 | 1.0500 | ["340"] | ["0.3278"] | [] | ["ARCO"] | 340.0000 | 340.0000 | 21 | 35 | false | true | true | false | |||||||||
| 01a0d931-827e-7683-9767-a2e0413244f1 | GOOGL | 2026-09-25 11:31 | put_calendar | 2 | 2 | 125 | 104731.00 | long | bid | 344.5800 | 0.5300 | ["340"] | ["0.2663"] | [] | ["XBOX"] | 340.0000 | 340.0000 | 3 | 21 | false | true | true | false | |||||||||
| 01a0cf65-9b0e-7671-ba77-b23cb66dd6df | GOOGL | 2026-09-23 13:52 | put_calendar | 2 | 1 | 100 | 324800.00 | unknown | bid | 338.7700 | 2.4000 | ["355"] | ["1.3213"] | [] | ["XCBO"] | 355.0000 | 355.0000 | 0 | 2 | false | false | true | false | |||||||||
| 01a0cf65-4906-7cc0-96e5-8b4edc9fbab7 | GOOGL | 2026-09-23 13:51 | put_calendar | 2 | 1 | 100 | 325200.00 | long | bid | 338.9000 | 2.4500 | ["355"] | ["0.9286"] | [] | ["BATO"] | 355.0000 | 355.0000 | 0 | 2 | false | false | true | false | |||||||||
| 01a0ce96-7f86-7130-bfd4-ad449862be59 | GOOGL | 2026-09-23 10:06 | put_calendar | 2 | 1 | 100 | 284700.00 | long | bid | 342.6700 | 2.0500 | ["355"] | ["0.3176"] | [] | ["XISX"] | 355.0000 | 355.0000 | 7 | 9 | false | false | true | false | |||||||||
| 01a0caa8-baf6-7652-9576-d909f242497b | GOOGL | 2026-09-22 15:47 | put_calendar | 2 | 1 | 45 | 119700.00 | long | bid | 352.0900 | 2.5000 | ["365"] | ["0.3789"] | [] | ["XMIO"] | 365.0000 | 365.0000 | 1 | 3 | false | false | true | false | |||||||||
| 01a0c965-6d56-7d40-9acd-25d442c6768f | GOOGL | 2026-09-22 09:54 | put_calendar | 2 | 1 | 200 | 133400.00 | long | bid | 361.4500 | 0.5800 | ["352.5"] | ["0.3144"] | [] | ["XISX"] | 352.5000 | 352.5000 | 8 | 10 | false | true | true | false | |||||||||
| 01a0b4ea-905f-78b3-a9ef-5d6b00b28393 | GOOGL | 2026-09-18 10:27 | put_calendar | 2 | 1 | 100 | 207000.00 | short | bid | 351.0350 | 1.3000 | ["357.5"] | ["0.2821"] | [] | ["XMIO"] | 357.5000 | 357.5000 | 10 | 12 | false | false | true | false | |||||||||
| 01a0b4d2-747f-7423-b3f1-b4ee5cf473f6 | GOOGL | 2026-09-18 10:01 | put_calendar | 2 | 1 | 171 | 224865.00 | unknown | bid | 355.4600 | 1.3000 | ["355"] | ["0.2851"] | [] | ["XISX"] | 355.0000 | 355.0000 | 10 | 12 | false | true | true | false | |||||||||
| 01a0b4b5-fb72-74d2-bcfe-8d8fce27602d | GOOGL | 2026-09-18 09:30 | put_calendar | 2 | 1 | 100 | 127900.00 | unknown | bid | 356.4400 | 6.3500 | ["355"] | ["0.2738"] | [] | ["XISX"] | 355.0000 | 355.0000 | 12 | 14 | true | true | true | false | |||||||||
| 01a0afa5-7973-7ca3-9c4b-7ae44529011f | GOOGL | 2026-09-17 09:54 | put_calendar | 2 | 3 | 11 | 101395.00 | short | bid | 344.0100 | 1.6591 | ["355"] | ["0.3565"] | [] | ["ARCO","XMIO","XPHO"] | 355.0000 | 355.0000 | 273 | 491 | false | false | true | false | |||||||||
| 01a0afa5-7973-7ca3-9c4b-7adac5febad3 | GOOGL | 2026-09-17 09:54 | put_calendar | 2 | 4 | 13 | 119841.00 | short | bid | 344.0100 | 1.7000 | ["355"] | ["0.3565"] | [] | ["AMXO","ARCO","XMIO","XPHO"] | 355.0000 | 355.0000 | 273 | 491 | false | false | true | false | |||||||||
| 01a0a54f-2796-7870-88b2-715c87e2cd79 | GOOGL | 2026-09-15 09:43 | put_calendar | 2 | 1 | 200 | 297400.00 | short | bid | 346.3500 | 1.3500 | ["347.5"] | ["0.2891"] | [] | ["XISX"] | 347.5000 | 347.5000 | 10 | 13 | false | false | true | false | |||||||||
| 01a0a542-fa66-7aa2-8ed9-5507925c7ec9 | GOOGL | 2026-09-15 09:30 | put_calendar | 2 | 1 | 100 | 115700.00 | short | bid | 347.6400 | 2.0500 | ["345"] | ["0.2956"] | [] | ["XISX"] | 345.0000 | 345.0000 | 10 | 13 | false | true | true | false | |||||||||
| 01a0a542-a476-75e1-b705-8a3b363751bc | GOOGL | 2026-09-15 09:30 | put_calendar | 2 | 1 | 100 | 123600.00 | short | bid | 346.9000 | 2.6500 | ["345"] | ["0.2988"] | [] | ["XISX"] | 345.0000 | 345.0000 | 10 | 13 | false | true | true | false | |||||||||
| 01a0a0fd-8180-75d0-aa1b-d7c4af5b0c09 | GOOGL | 2026-09-14 13:36 | put_calendar | 2 | 1 | 6 | 135570.00 | short | bid | 349.4800 | 4.5500 | ["460"] | ["0.3839"] | [] | ["XISX"] | 460.0000 | 460.0000 | 186 | 214 | false | false | true | false | |||||||||
| 01a09108-1a38-78f3-8644-81e3eebcba25 | GOOGL | 2026-09-11 11:13 | put_calendar | 2 | 1 | 80 | 128800.00 | long | bid | 341.2250 | 0.5000 | ["335"] | ["0.2873"] | [] | ["XMIO"] | 335.0000 | 335.0000 | 28 | 35 | false | true | true | false | |||||||||
| 01a08cd9-7830-7930-b5cc-af4da8451c81 | GOOGL | 2026-09-10 15:44 | put_calendar | 2 | 1 | 40 | 178120.00 | short | bid | 332.9800 | 1.9500 | ["355"] | ["0.5716"] | [] | ["XISX"] | 355.0000 | 355.0000 | 1 | 4 | false | false | true | false | |||||||||
| 01a08c56-fdd8-72c1-abdf-b3c001bc2ce0 | GOOGL | 2026-09-10 13:21 | put_calendar | 2 | 1 | 30 | 140100.00 | long | bid | 332.2500 | 2.0000 | ["355"] | ["0.5884"] | [] | ["XPHO"] | 355.0000 | 355.0000 | 1 | 8 | false | false | true | false | |||||||||
| 01a08c13-bf00-7a91-9e26-da11771b37cd | GOOGL | 2026-09-10 12:08 | put_calendar | 2 | 1 | 50 | 182300.00 | short | bid | 330.2900 | 1.5000 | ["345"] | ["0.3141"] | [] | ["ARCO"] | 345.0000 | 345.0000 | 8 | 36 | false | false | true | false | |||||||||
| 01a08ba4-0d40-79e3-95bb-532b3565e40e | GOOGL | 2026-09-10 10:06 | put_calendar | 2 | 1 | 30 | 194880.00 | short | bid | 328.6301 | 1.7500 | ["360"] | ["0.3359"] | [] | ["XCBO"] | 360.0000 | 360.0000 | 8 | 36 | false | false | true | false | |||||||||
| 01a086fb-b6f8-7742-abd1-2ea7b494c41e | GOOGL | 2026-09-09 12:23 | put_calendar | 2 | 1 | 500 | 1993000.00 | short | bid | 329.5000 | 0.8000 | ["305"] | ["0.3522"] | [] | ["XBOX"] | 305.0000 | 305.0000 | 100 | 373 | false | true | true | false | |||||||||
| 01a086ce-7cd8-7b01-94e8-f08aac4d5619 | GOOGL | 2026-09-09 11:34 | put_calendar | 2 | 1 | 20 | 115120.00 | short | bid | 329.3650 | 1.6000 | ["340"] | ["0.3433"] | [] | ["BATO"] | 340.0000 | 340.0000 | 100 | 128 | false | false | true | false | |||||||||
| 01a0868a-6ef8-75c2-972d-e93a02c8952b | GOOGL | 2026-09-09 10:20 | put_calendar | 2 | 1 | 10 | 115940.00 | long | bid | 330.4900 | 3.1500 | ["385"] | ["0.3706"] | [] | ["XMIO"] | 385.0000 | 385.0000 | 37 | 128 | false | false | true | false | |||||||||
| 01a0866e-3468-7791-9721-d92d9f46ad4c | GOOGL | 2026-09-09 09:49 | put_calendar | 2 | 2 | 40 | 120500.00 | long | bid | 328.7099 | 0.9500 | ["335"] | ["0.3083"] | [] | ["AMXO","XISX"] | 335.0000 | 335.0000 | 30 | 37 | false | false | true | false | |||||||||
| 01a0865d-4860-7450-898f-87bc7feef1b2 | GOOGL | 2026-09-09 09:30 | put_calendar | 2 | 1 | 75 | 222900.00 | long | bid | 329.1300 | 3.9500 | ["335"] | ["0.3090"] | [] | ["AMXO"] | 335.0000 | 335.0000 | 30 | 37 | false | false | true | false | |||||||||
| 01a08276-59d0-7890-852c-87c3f4eeedb9 | GOOGL | 2026-09-08 15:19 | put_calendar | 2 | 1 | 20 | 120600.00 | long | bid | 337.3000 | 3.8000 | ["360"] | ["0.4088"] | [] | ["XMIO"] | 360.0000 | 360.0000 | 3 | 129 | false | false | true | false | |||||||||
| 01a08139-f9a0-7542-b58e-0abe942ea681 | GOOGL | 2026-09-08 09:34 | put_calendar | 2 | 2 | 200 | 554900.00 | long | bid | 335.7536 | 1.2000 | ["340"] | ["0.2982"] | [] | ["ARCO","XPHO"] | 340.0000 | 340.0000 | 31 | 38 | false | false | true | false | |||||||||
| 01a08136-ffe8-71b0-ba0a-8a1f04d8cfe4 | GOOGL | 2026-09-08 09:30 | put_calendar | 2 | 1 | 63 | 172935.00 | long | bid | 335.5650 | 3.0500 | ["340"] | ["0.2922"] | [] | ["XCBO"] | 340.0000 | 340.0000 | 31 | 38 | false | false | true | false | |||||||||
| 01a08136-a610-7e53-bb6e-fed6202cbd0b | GOOGL | 2026-09-08 09:30 | put_calendar | 2 | 2 | 37 | 104081.00 | long | bid | 335.5600 | 2.6000 | ["340"] | ["0.3009"] | [] | ["XISX"] | 340.0000 | 340.0000 | 31 | 38 | false | false | true | false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T14:52:45Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T19:46:47Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T18:00:50Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T17:23:22Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T15:31:51Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:52:40Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:52:40Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:06:12Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:47:50Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:54:37Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:27:56Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:01:37Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:30:15Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:54:18Z"} |
| 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-17T13:54:18Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T13:43:54Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T13:30:23Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T13:30:01Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:36:34Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:13:53Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:44:29Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:22:29Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T16:08:47Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:06:19Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:24:21Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:34:35Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:20:20Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:49:45Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:30:59Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:19:58Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:34:21Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:31:07Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:30:29Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |