Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
367,592 rowsCSV — whole table, not this view
Sources in this table
uw_multileg367,592 rowsexportable
| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | true | 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 |
| 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 | true | 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 |
| 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 | true | 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 |
| 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 | true | 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 |
| 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 | true | 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 |
| 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 | mlet | 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 |
| 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 | true | 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 |
| 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 | mlet | 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 |
| 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 | mlet | 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 |
| 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 | true | 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 |
| 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 | true | 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 |
| 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 | true | 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 |
| 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 | true | 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 |
| 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 | true | 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 |
| 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 | true | 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 |
| 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 | true | 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 |
| 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 | true | 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 |