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 | directiontext |
|---|
| 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 |
|---|
| 01a08675-f4c8-7f81-b031-f3ad05b213bb | GOOGL | 2026-09-09 09:57 | put_diagonal_spread | 2 | 1 | 37 | 185222.00 | short | bid | 329.2700 | 1.4500 | ["290","295"] | ["0.3611","0.3576"] | [] | ["XCBO"] | 290.0000 | 295.0000 | 373 | 464 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:58:01Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08696-2ae0-7f80-8a0d-484fa1d5afb7 | GOOGL | 2026-09-09 10:33 | put_diagonal_spread | 2 | 1 | 100 | 684000.00 | long | ask | 329.8800 | 2.7500 | ["335","350"] | ["0.3517","0.3501"] | [] | ["XCBO"] | 335.0000 | 350.0000 | 72 | 281 | false | false | true | ||||||||||
| 01a08735-9378-7d31-aa7e-56ad76cb54d2 | GOOGL | 2026-09-09 13:27 | put_diagonal_spread | 2 | 2 | 9 | 114198.00 | long | ask | 331.2950 | 1.5000 | ["360","365"] | ["0.3838","0.3587"] | [] | ["XMIO","XPHO"] | 360.0000 | 365.0000 | 281 | 828 | false | false | true | ||||||||||
| 01a08735-9378-7d31-aa7e-569581888369 | GOOGL | 2026-09-09 13:27 | put_diagonal_spread | 2 | 1 | 8 | 101512.00 | long | ask | 331.2950 | 1.5000 | ["360","365"] | ["0.3838","0.3588"] | [] | ["XPHO"] | 360.0000 | 365.0000 | 281 | 828 | false | false | true | ||||||||||
| 01a08735-8f90-7343-b04c-38dce1e53db1 | GOOGL | 2026-09-09 13:27 | put_diagonal_spread | 2 | 1 | 10 | 126900.00 | long | ask | 331.3100 | 1.5000 | ["360","365"] | ["0.3838","0.3590"] | [] | ["XPHO"] | 360.0000 | 365.0000 | 281 | 828 | false | false | true | ||||||||||
| 01a08735-9378-7d31-aa7e-56b80a3b7997 | GOOGL | 2026-09-09 13:27 | put_diagonal_spread | 2 | 2 | 15 | 190334.00 | long | ask | 331.2900 | 1.4000 | ["360","365"] | ["0.3838","0.3587"] | [] | ["ARCO","XISX"] | 360.0000 | 365.0000 | 281 | 828 | false | false | true | ||||||||||
| 01a08735-ba88-7ca1-9eeb-d4317611925d | GOOGL | 2026-09-09 13:27 | put_diagonal_spread | 2 | 1 | 12 | 152280.00 | long | ask | 331.3076 | 1.5500 | ["360","365"] | ["0.3839","0.3588"] | [] | ["XPHO"] | 360.0000 | 365.0000 | 281 | 828 | false | false | true | ||||||||||
| 01a08b9b-c040-7282-bce3-6975b2b38ee6 | GOOGL | 2026-09-10 09:57 | put_diagonal_spread | 2 | 1 | 10 | 132480.00 | short | bid | 328.8700 | 2.2000 | ["380","390"] | ["0.3658","0.3608"] | [] | ["XCBO"] | 380.0000 | 390.0000 | 127 | 280 | false | false | true | ||||||||||
| 01a08c8f-4418-7da1-8773-25d55f6c3a0e | GOOGL | 2026-09-10 14:23 | put_diagonal_spread | 2 | 1 | 21 | 171675.00 | long | ask | 331.9572 | 3.2000 | ["370","375"] | ["1.1926","0.5159"] | [] | ["XCBO"] | 370.0000 | 375.0000 | 1 | 8 | false | false | true | ||||||||||
| 01a090e3-9690-7ea0-9971-732655d3644f | GOOGL | 2026-09-11 10:33 | put_diagonal_spread | 2 | 1 | 37 | 225996.00 | short | bid | 339.7300 | 3.0500 | ["360","370"] | ["0.3388","0.4011"] | [] | ["ARCO"] | 360.0000 | 370.0000 | 7 | 70 | false | false | true | ||||||||||
| 01a0a038-e190-7e52-b0f2-36a074d45900 | GOOGL | 2026-09-14 10:01 | put_diagonal_spread | 2 | 2 | 58 | 107010.00 | short | bid | 346.1600 | 1.0500 | ["340","342.5"] | ["0.3444","0.3021"] | [] | ["ARCO","EDGO"] | 340.0000 | 342.5000 | 11 | 46 | false | true | true | ||||||||||
| 01a0a168-5cf8-7903-85ae-212776e29d5e | GOOGL | 2026-09-14 15:32 | put_diagonal_spread | 2 | 1 | 100 | 235900.00 | long | ask | 348.1400 | 1.8500 | ["340","345"] | ["0.3403","0.3018"] | [] | ["BATO"] | 340.0000 | 345.0000 | 39 | 46 | false | true | true | ||||||||||
| 01a0a5b7-dc46-7d23-a017-194225c892f5 | GOOGL | 2026-09-15 11:38 | put_diagonal_spread | 2 | 1 | 100 | 303600.00 | long | ask | 343.4200 | 0.5500 | ["330","335"] | ["0.3392","0.3467"] | [] | ["XCBO"] | 330.0000 | 335.0000 | 66 | 94 | false | true | true | ||||||||||
| 01a0ab5d-9a7b-7801-87ee-16f20f4899cb | GOOGL | 2026-09-16 13:57 | put_diagonal_spread | 2 | 1 | 300 | 468589.00 | short | bid | 344.7300 | 0.2500 | ["340","350"] | ["0.3643","0.2941"] | [] | ["XCBO"] | 340.0000 | 350.0000 | 2 | 30 | false | false | true | ||||||||||
| 01a0ab81-fafb-75a3-ad35-ad83e0398195 | GOOGL | 2026-09-16 14:36 | put_diagonal_spread | 2 | 1 | 100 | 298500.00 | unknown | — | 344.0100 | 1.1000 | ["325","330"] | ["0.3275","0.3350"] | [] | ["BATO"] | 325.0000 | 330.0000 | 93 | 121 | false | true | true | true | false | ||||||||
| 01a0af94-7dcb-7c12-a334-9040c5ee750e | GOOGL | 2026-09-17 09:35 | put_diagonal_spread | 2 | 1 | 77 | 234080.00 | unknown | — | 346.5000 | 1.8000 | ["320","325"] | ["0.3443","0.3302"] | [] | ["SPHR"] | 320.0000 | 325.0000 | 120 | 155 | false | true | true | true | false | ||||||||
| 01a0af9d-d854-7093-badc-79a34dd588f3 | GOOGL | 2026-09-17 09:45 | put_diagonal_spread | 2 | 2 | 20 | 217240.00 | unknown | — | 345.2372 | 5.5375 | ["375","410"] | ["0.3388","2.1565"] | [] | ["XISX"] | 375.0000 | 410.0000 | 1 | 155 | true | false | true | true | false | ||||||||
| 01a0afa2-d993-7871-b170-10aa03b68507 | GOOGL | 2026-09-17 09:51 | put_diagonal_spread | 2 | 1 | 20 | 216700.00 | long | bid | 344.5500 | 5.7000 | ["375","405"] | ["0.3428","2.2597"] | [] | ["XISX"] | 375.0000 | 405.0000 | 1 | 211 | false | false | true | ||||||||||
| 01a0b072-23fa-7d11-9016-0fd0d564dcb7 | GOOGL | 2026-09-17 13:37 | put_diagonal_spread | 2 | 1 | 100 | 331500.00 | unknown | — | 345.2700 | 0.6000 | ["315","320"] | ["0.3459","0.3448"] | [] | ["XISX"] | 315.0000 | 320.0000 | 155 | 183 | false | true | true | true | false | ||||||||
| 01a0b4e4-4318-7823-a164-f3c343896b03 | GOOGL | 2026-09-18 10:20 | put_diagonal_spread | 2 | 5 | 28 | 197644.00 | unknown | bid | 350.2400 | 2.3071 | ["360","400"] | ["0.6737","0.3524"] | [] | ["EMLD","MCRY","XISX","XPHO"] | 360.0000 | 400.0000 | 0 | 182 | false | false | true | ||||||||||
| 01a0b4e9-add0-7cb1-89f1-4723be8123c1 | GOOGL | 2026-09-18 10:26 | put_diagonal_spread | 2 | 3 | 190 | 823594.00 | long | ask | 350.4450 | 1.5500 | ["360","365"] | ["0.2974","0.3463"] | [] | ["ARCO","EDGO","XPHO"] | 360.0000 | 365.0000 | 28 | 63 | false | false | true | ||||||||||
| 01a0b574-afbf-7aa1-b7d3-4b67baeb836d | GOOGL | 2026-09-18 12:58 | put_diagonal_spread | 2 | 1 | 36 | 115848.00 | long | ask | 349.8700 | 0.4500 | ["350","360"] | ["0.3488","0.2875"] | [] | ["XCBO"] | 350.0000 | 360.0000 | 12 | 63 | false | false | true | ||||||||||
| 01a0c47e-48ee-7dd2-92ce-5dc8fedf5404 | GOOGL | 2026-09-21 11:03 | put_diagonal_spread | 2 | 3 | 282 | 168776.00 | long | bid | 354.5400 | 0.3500 | ["290","320"] | ["0.3748","0.3656"] | [] | ["EDGO","XCBO","XISX"] | 290.0000 | 320.0000 | 39 | 60 | false | true | true | ||||||||||
| 01a0c489-fd07-7ea1-8129-eb96ff60def9 | GOOGL | 2026-09-21 11:16 | put_diagonal_spread | 2 | 1 | 36 | 119340.00 | long | ask | 355.2217 | 0.8000 | ["345","350"] | ["0.3501","0.3371"] | [] | ["XMIO"] | 345.0000 | 350.0000 | 60 | 88 | false | true | true | ||||||||||
| 01a0c49a-0e4f-7cd2-99f1-a1d284902201 | GOOGL | 2026-09-21 11:33 | put_diagonal_spread | 2 | 1 | 36 | 134352.00 | short | bid | 356.2300 | 0.7500 | ["345","350"] | ["0.3372","0.3299"] | [] | ["XPHO"] | 345.0000 | 350.0000 | 88 | 116 | false | true | true | ||||||||||
| 01a0c4e0-2b87-75c3-bd8d-f0a942e127c3 | GOOGL | 2026-09-21 12:50 | put_diagonal_spread | 2 | 1 | 49 | 212072.00 | unknown | ask | 355.3400 | 0.2200 | ["350","390"] | ["0.4174","0.3433"] | [] | ["XPHO"] | 350.0000 | 390.0000 | 0 | 88 | false | false | true | ||||||||||
| 01a0c548-1ce6-7a41-8a6b-5f6114a4a9d9 | GOOGL | 2026-09-21 14:43 | put_diagonal_spread | 2 | 1 | 20 | 135584.00 | unknown | bid | 355.1500 | 2.4500 | ["300","310"] | ["0.3758","0.3746"] | [] | ["XMIO"] | 300.0000 | 310.0000 | 816 | 851 | false | true | true | ||||||||||
| 01a0c573-0546-7831-9ab7-5e59cb44c1fa | GOOGL | 2026-09-21 15:30 | put_diagonal_spread | 2 | 1 | 600 | 246000.00 | long | ask | 356.3800 | 0.3600 | ["285","332.5"] | ["0.3615","0.3771"] | [] | ["XPHO"] | 285.0000 | 332.5000 | 4 | 116 | false | true | true | ||||||||||
| 01a0c966-1167-7f01-9a08-bb1ab137f04a | GOOGL | 2026-09-22 09:55 | put_diagonal_spread | 2 | 1 | 20 | 161900.00 | long | ask | 361.1200 | 3.4500 | ["370","430"] | ["0.4269","0.3691"] | [] | ["XISX"] | 370.0000 | 430.0000 | 1 | 87 | false | false | true | ||||||||||
| 01a0c9ef-afdf-7b30-8291-2a3de16a9672 | GOOGL | 2026-09-22 12:25 | put_diagonal_spread | 2 | 1 | 98 | 340550.00 | short | bid | 352.6950 | 0.5500 | ["350","355"] | ["0.3564","0.3688"] | [] | ["XISX"] | 350.0000 | 355.0000 | 38 | 59 | false | false | true | ||||||||||
| 01a0ca42-b9ae-7c82-9820-c4634bf85e4b | GOOGL | 2026-09-22 13:56 | put_diagonal_spread | 2 | 1 | 93 | 331173.00 | long | ask | 353.5000 | 0.5500 | ["345","350"] | ["0.3485","0.3614"] | [] | ["XISX"] | 345.0000 | 350.0000 | 59 | 87 | false | true | true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:33:08Z"} |
| 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-09T17:27:59Z"} |
| 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-09T17:27:59Z"} |
| 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-09T17:27:59Z"} |
| 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-09T17:27:59Z"} |
| 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-09T17:27:59Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T13:57:28Z"} |
| 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:23:24Z"} |
| 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-11T14:34:07Z"} |
| 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-14T14:01:29Z"} |
| 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-14T19:32:46Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:38:35Z"} |
| 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-16T17:57:20Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:36:58Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:35:39Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:46:04Z"} |
| 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:51:24Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:38:08Z"} |
| 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-18T14:21:08Z"} |
| 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:27:03Z"} |
| 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-18T16:59:18Z"} |
| 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-21T15:03:39Z"} |
| 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:16:19Z"} |
| 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-21T15:34:16Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:50:41Z"} |
| 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-21T18:43:57Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:30:46Z"} |
| 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-22T13:55:17Z"} |
| 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-22T16:25:53Z"} |
| 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:56:26Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |