Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
312,778 rowsCSV — whole table, not this view
Sources in this table
uw_multileg312,778 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a06dc8-e535-7242-995c-ab61ef8dd31f | SNOW | 2026-09-04 14:57 | call_calendar | 2 | 1 | 15 | 186255.00 | long | ask | 340.0800 | 9.5000 | ["280"] | ["4.7453"] | [] | ["EDGO"] | 280.0000 | 280.0000 | 0 | 42 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:58:23Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a0813d-4948-7b03-89a5-a057fca85fcf | SNOW | 2026-09-08 09:37 | call_calendar | 2 | 1 | 44 | 298012.00 | short | ask | 338.6450 | 9.4500 | ["360"] | ["0.5054"] | [] | ["XMIO"] | 360.0000 | 360.0000 | 101 | 164 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:38:07Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08191-dda0-7c10-a25d-595cf987f720 | SNOW | 2026-09-08 11:10 | call_calendar | 2 | 2 | 4 | 110300.00 | short | bid | 337.4700 | 5.5500 | ["200"] | ["1.3668"] | [] | ["XCBO"] | 200.0000 | 200.0000 | 10 | 38 | false | false | true | false | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:10:17Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08237-b2c0-7b23-8ac1-eb95b86041f5 | SNOW | 2026-09-08 14:11 | call_calendar | 2 | 1 | 7 | 248640.00 | long | ask | 338.8200 | 10.6000 | ["175"] | ["0.6263"] | [] | ["XISX"] | 175.0000 | 175.0000 | 282 | 374 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:12:16Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0826e-0118-7193-a1eb-333acf031502 | SNOW | 2026-09-08 15:10 | call_calendar | 2 | 1 | 2 | 109442.00 | short | ask | 338.2150 | 12.1500 | ["70"] | ["0.9523"] | [] | ["ARCO"] | 70.0000 | 70.0000 | 129 | 829 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:10:57Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08277-2109-7ef3-9c41-b1422f4e9885 | SNOW | 2026-09-08 15:20 | call_calendar | 2 | 1 | 10 | 535020.00 | long | bid | 336.2850 | 10.6500 | ["75"] | ["1.5336"] | [] | ["ARCO"] | 75.0000 | 75.0000 | 38 | 829 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:21:17Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08277-2cc0-74a2-b208-668e7dc0fcd5 | SNOW | 2026-09-08 15:20 | call_calendar | 2 | 1 | 10 | 534780.00 | long | ask | 336.2850 | 9.3500 | ["75"] | ["1.4867"] | [] | ["XPHO"] | 75.0000 | 75.0000 | 38 | 829 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:21:17Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08288-5748-7f41-a187-fc711df7fd32 | SNOW | 2026-09-08 15:39 | call_calendar | 2 | 1 | 3 | 155217.00 | short | bid | 336.8450 | 11.0500 | ["85"] | ["2.3531"] | [] | ["XMIO"] | 85.0000 | 85.0000 | 10 | 829 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:40:07Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08288-6301-7ae0-b449-294b37368be4 | SNOW | 2026-09-08 15:39 | call_calendar | 2 | 1 | 3 | 155139.00 | short | bid | 336.8450 | 11.0500 | ["85"] | ["2.2457"] | [] | ["XPHO"] | 85.0000 | 85.0000 | 10 | 829 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:40:07Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0828b-b690-75e1-a592-b24ffea1c6c4 | SNOW | 2026-09-08 15:43 | call_calendar | 2 | 1 | 10 | 549700.00 | long | bid | 337.3550 | 8.0000 | ["65"] | ["2.5663"] | [] | ["XMIO"] | 65.0000 | 65.0000 | 10 | 465 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:43:36Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08789-29e9-7b72-b225-6f50e885e3b7 | SNOW | 2026-09-09 14:58 | call_calendar | 2 | 1 | 2 | 108290.00 | short | bid | 333.2800 | 8.3000 | ["65"] | ["2.2118"] | [] | ["ARCO"] | 65.0000 | 65.0000 | 9 | 499 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:59:01Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08789-2600-7392-8cdb-a7bebecffc64 | SNOW | 2026-09-09 14:58 | call_calendar | 2 | 1 | 2 | 108254.00 | short | bid | 333.2400 | 7.9500 | ["65"] | ["1.9380"] | [] | ["AMXO"] | 65.0000 | 65.0000 | 9 | 499 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:59:01Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a09193-9d10-7b73-9323-634c49841d7d | SNOW | 2026-09-11 13:46 | call_calendar | 2 | 3 | 3 | 100042.00 | short | ask | 325.4050 | 11.2167 | ["170"] | ["0.6936"] | [] | ["SPHR","XBOX"] | 170.0000 | 170.0000 | 189 | 279 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:46:31Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0a088-74a8-7802-9d22-e07a9b661632 | SNOW | 2026-09-14 11:28 | call_calendar | 2 | 1 | 4 | 100760.00 | long | ask | 333.3850 | 7.6000 | ["210"] | ["1.3758"] | [] | ["XMIO"] | 210.0000 | 210.0000 | 4 | 95 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:28:13Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0aaee-755b-71f0-b709-9a4000132b33 | SNOW | 2026-09-16 11:55 | call_calendar | 2 | 2 | 5 | 129809.00 | short | ask | 334.5650 | 7.6500 | ["210"] | ["2.0288"] | [] | ["XCBO","XISX"] | 210.0000 | 210.0000 | 2 | 156 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:56:33Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0afbe-6073-7623-b522-daa7115462ea | SNOW | 2026-09-17 10:21 | call_calendar | 2 | 1 | 4 | 129284.00 | unknown | — | 341.3850 | 6.7000 | ["180"] | ["3.1160"] | [] | ["EMLD"] | 180.0000 | 180.0000 | 1 | 29 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:21:33Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afdc-064b-7552-a682-2ff8962ec265 | SNOW | 2026-09-17 10:53 | call_calendar | 2 | 1 | 5 | 163450.00 | unknown | — | 343.9800 | 12.2000 | ["180"] | ["4.5321"] | [] | ["XMIO"] | 180.0000 | 180.0000 | 1 | 29 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:53:48Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0affd-3e33-7fe3-b511-174a162dd251 | SNOW | 2026-09-17 11:30 | call_calendar | 2 | 1 | 10 | 228700.00 | short | ask | 343.1800 | 8.6000 | ["230"] | ["2.6409"] | [] | ["XMIO"] | 230.0000 | 230.0000 | 1 | 64 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:30:18Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b4bb-817f-7a02-907f-efbebb2556be | SNOW | 2026-09-18 09:36 | call_calendar | 2 | 1 | 25 | 440800.00 | short | ask | 335.0000 | 11.9500 | ["250"] | ["3.5070"] | [] | ["XMIO"] | 250.0000 | 250.0000 | 0 | 63 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:36:28Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4e8-b3cf-74c0-9dce-e3407a2a1794 | SNOW | 2026-09-18 10:25 | call_calendar | 2 | 1 | 4 | 123608.00 | short | bid | 333.2900 | 12.3500 | ["180"] | ["7.1809"] | [] | ["EMLD"] | 180.0000 | 180.0000 | 0 | 28 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:25:46Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4e9-3c87-7e53-9059-fb605da954c2 | SNOW | 2026-09-18 10:26 | call_calendar | 2 | 1 | 10 | 348040.00 | short | ask | 333.1201 | 7.2000 | ["160"] | ["7.8118"] | [] | ["XMIO"] | 160.0000 | 160.0000 | 0 | 28 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:26:38Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b550-bc9f-7792-af75-b2f3488f10bf | SNOW | 2026-09-18 12:19 | call_calendar | 2 | 2 | 20 | 737636.00 | short | bid | 333.7443 | 11.5500 | ["150"] | ["10.1332"] | [] | ["SPHR","XCBO"] | 150.0000 | 150.0000 | 0 | 28 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:19:56Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b563-df0f-77f2-a599-68da75a954c7 | SNOW | 2026-09-18 12:40 | call_calendar | 2 | 1 | 6 | 187710.00 | unknown | bid | 332.7450 | 11.9500 | ["175"] | ["12.7350"] | [] | ["XBOX"] | 175.0000 | 175.0000 | 0 | 21 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:40:19Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5de-9907-71b0-a7b0-dd9cacff96d0 | SNOW | 2026-09-18 14:54 | call_calendar | 2 | 1 | 7 | 160384.00 | short | ask | 334.4200 | 10.4500 | ["220"] | ["12.6585"] | [] | ["XMIO"] | 220.0000 | 220.0000 | 0 | 28 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:54:22Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |