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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b61a-1780-7960-b9d6-df98fcf17eac | STUB | 2026-09-18 15:59 | put_vertical_spread | 2 | 1 | 100 | 116600.00 | long | ask | 5.9350 | 0.9000 | ["11.5","12"] | ["259.6701","273.1384"] | ["0","11.5"] | ["XCBO"] | 11.5000 | 12.0000 | 0 | 0 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:59:18Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5ed-b81f-7aa1-bbcd-77d9fb0e3a02 | STUB | 2026-09-18 15:10 | put_vertical_spread | 2 | 1 | 220 | 252780.00 | long | ask | 5.9750 | 0.5000 | ["11.5","12"] | ["41.9966","43.9726"] | ["11.51"] | ["XISX"] | 11.5000 | 12.0000 | 0 | 0 | true | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:11:00Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5ed-1fc7-7e30-b88f-63cd078417e2 | STUB | 2026-09-18 15:10 | put_vertical_spread | 2 | 1 | 188 | 216012.00 | long | ask | 5.9750 | 0.5000 | ["11.5","12"] | ["41.7150","43.6778"] | ["11.51"] | ["XISX"] | 11.5000 | 12.0000 | 0 | 0 | true | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:10:30Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5e0-69df-7910-8309-21cd32108c47 | STUB | 2026-09-18 14:56 | call_vertical_spread | 2 | 1 | 249 | 113793.00 | long | ask | 5.9850 | 0.3500 | ["3.5","4"] | ["32.0913","26.5932"] | ["3.99"] | ["XISX"] | 3.5000 | 4.0000 | 0 | 0 | true | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:56:32Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5dd-a2f0-7962-8c0c-34e0a2aff45b | STUB | 2026-09-18 14:53 | call_vertical_spread | 2 | 1 | 249 | 162597.00 | long | ask | 5.9850 | 0.3500 | ["2.5","3"] | ["42.6667","36.9218"] | ["2.99"] | ["XISX"] | 2.5000 | 3.0000 | 0 | 0 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:53:16Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5dc-6688-7e42-9648-728e587023d7 | STUB | 2026-09-18 14:51 | call_vertical_spread | 2 | 1 | 249 | 162597.00 | long | ask | 5.9850 | 0.3500 | ["2.5","3"] | ["42.2365","36.5495"] | ["2.99"] | ["XISX"] | 2.5000 | 3.0000 | 0 | 0 | true | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:51:54Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b068-b5eb-7433-a898-8daa09051106 | STUB | 2026-09-17 13:27 | put_vertical_spread | 2 | 1 | 136 | 126344.00 | long | ask | 5.9250 | 0.8000 | ["10","11"] | ["6.6308","7.2677"] | ["10.01"] | ["XISX"] | 10.0000 | 11.0000 | 1 | 1 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:27:48Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b01a-72c3-7443-a9d3-a0143324e33d | STUB | 2026-09-17 12:01 | put_vertical_spread | 2 | 1 | 222 | 290154.00 | long | ask | 5.8086 | 0.7000 | ["12","12.5"] | ["8.9388","9.0889"] | ["12.01"] | ["XISX"] | 12.0000 | 12.5000 | 1 | 1 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:02:05Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b019-da6b-7a62-bf56-720ea2a70233 | STUB | 2026-09-17 12:01 | put_vertical_spread | 2 | 1 | 88 | 115016.00 | long | ask | 5.8050 | 0.7000 | ["12","12.5"] | ["8.8741","9.0184"] | ["12.01"] | ["XISX"] | 12.0000 | 12.5000 | 1 | 1 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:01:25Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a086d1-e008-7d12-a625-fa33f55292ce | STUB | 2026-09-09 11:38 | put_vertical_spread | 2 | 1 | 88 | 165000.00 | long | ask | 6.0950 | 0.9000 | ["15","16"] | ["8.4928","8.8965"] | ["15.01"] | ["XMIO"] | 15.0000 | 16.0000 | 2 | 2 | true | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:38:49Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08682-b280-7360-8968-396e9bd0a3b4 | STUB | 2026-09-09 10:11 | put_vertical_spread | 2 | 1 | 88 | 126280.00 | long | ask | 6.1250 | 0.7000 | ["13","13.5"] | ["5.7486","5.7661"] | ["13.01"] | ["XMIO"] | 13.0000 | 13.5000 | 2 | 2 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:12:08Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0867f-ad10-7cb2-b8a8-d64f79aa356f | STUB | 2026-09-09 10:08 | put_vertical_spread | 2 | 1 | 88 | 142120.00 | long | ask | 6.0950 | 0.7000 | ["14","14.5"] | ["6.8670","7.0757"] | ["14.01"] | ["XMIO"] | 14.0000 | 14.5000 | 2 | 2 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:08:29Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0867e-5938-7b90-adf3-69e03066a313 | STUB | 2026-09-09 10:07 | put_vertical_spread | 2 | 1 | 88 | 126456.00 | long | ask | 6.0800 | 0.7000 | ["13","13.5"] | ["4.9615","4.7588"] | ["13.01"] | ["XCBO"] | 13.0000 | 13.5000 | 2 | 2 | true | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:07:10Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0867c-e238-7a10-b08a-339ebf87b323 | STUB | 2026-09-09 10:05 | put_vertical_spread | 2 | 1 | 88 | 142296.00 | long | ask | 6.0900 | 1.1000 | ["14","14.5"] | ["8.0085","8.2329"] | ["14.01"] | ["XCBO"] | 14.0000 | 14.5000 | 2 | 2 | true | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:05:41Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |