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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b4c3-6cd8-7521-8364-ff84e68c5d5f | EWY | 2026-09-18 09:44 | call_vertical_spread | 2 | 1 | 14 | 105798.00 | short | bid | 180.0500 | 1.4500 | ["140","145"] | ["0.8574","0.7767"] | ["144.97"] | ["XCBO"] | 140.0000 | 145.0000 | 7 | 7 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:45:07Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0ab97-d0d3-7640-b417-13ae3a36e010 | EWY | 2026-09-16 15:00 | call_vertical_spread | 2 | 1 | 336 | 108528.00 | short | bid | 176.0500 | 2.2300 | ["220","250"] | ["0.4588","0.4700"] | ["221.83"] | ["XCBO"] | 220.0000 | 250.0000 | 65 | 65 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:01:09Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a042-efc8-7f10-a85e-130312c26a02 | EWY | 2026-09-14 10:12 | put_vertical_spread | 2 | 1 | 400 | 156800.00 | short | bid | 178.5000 | 0.9200 | ["170","175"] | ["0.5918","0.5630"] | ["173.70"] | ["XPHO"] | 170.0000 | 175.0000 | 4 | 4 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:12:21Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09143-3708-7fd3-b5de-d5f5fb6ce906 | EWY | 2026-09-11 12:18 | strangle | 2 | 1 | 100 | 358100.00 | short | bid | 188.8400 | 2.5500 | ["190","195"] | ["0.5340","0.4440"] | ["154.19","230.81"] | ["XMIO"] | 190.0000 | 195.0000 | 98 | 98 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:18:39Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09143-0059-7123-84d8-44e9076372ff | EWY | 2026-09-11 12:18 | strangle | 2 | 1 | 87 | 311547.00 | short | bid | 188.8400 | 2.5500 | ["190","195"] | ["0.5325","0.4455"] | ["154.19","230.81"] | ["XMIO"] | 190.0000 | 195.0000 | 98 | 98 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:18:39Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0913f-4738-7633-a137-176f60dfba7b | EWY | 2026-09-11 12:13 | call_vertical_spread | 2 | 1 | 6 | 104034.00 | short | bid | 188.9500 | 1.6500 | ["100","105"] | ["2.0473","1.9139"] | ["104.99"] | ["XMIO"] | 100.0000 | 105.0000 | 7 | 7 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:14:10Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09107-d3e8-7e42-9e54-d7fc74a781cd | EWY | 2026-09-11 11:13 | strangle | 2 | 1 | 150 | 540150.00 | short | bid | 188.7500 | 2.1500 | ["190","195"] | ["0.5348","0.4485"] | ["153.99","231.01"] | ["XMIO"] | 190.0000 | 195.0000 | 98 | 98 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:13:27Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090ed-81a0-7cb3-93ac-4c7a3427b31a | EWY | 2026-09-11 10:44 | strangle | 2 | 1 | 200 | 720400.00 | short | bid | 188.2500 | 2.6000 | ["190","195"] | ["0.5374","0.4470"] | ["153.98","231.02"] | ["XMIO"] | 190.0000 | 195.0000 | 98 | 98 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:45:02Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090ea-8bd0-7502-80dc-6f2ea2f51321 | EWY | 2026-09-11 10:41 | strangle | 2 | 1 | 112 | 405415.00 | short | bid | 188.4400 | 2.5500 | ["190","195"] | ["0.5422","0.4466"] | ["153.80","231.20"] | ["XMIO"] | 190.0000 | 195.0000 | 98 | 98 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:41:37Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08ca2-7628-7cd1-9abf-00374251a20c | EWY | 2026-09-10 14:44 | call_vertical_spread | 2 | 1 | 199 | 1678565.00 | short | bid | 183.2300 | 4.4000 | ["141","142"] | ["2.9108","2.8579"] | ["141.99"] | ["XISX"] | 141.0000 | 142.0000 | 1 | 1 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:44:40Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a087cd-6a90-7080-903e-f69a66041be1 | EWY | 2026-09-09 16:12 | call_vertical_spread | 2 | 1 | 88 | 759792.00 | short | bid | 190.9700 | 5.7500 | ["147.5","148"] | ["2.6553","2.5295"] | ["148"] | ["XMIO"] | 147.5000 | 148.0000 | 2 | 2 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08158-4770-7982-867e-7ad9a77db01b | EWY | 2026-09-08 10:07 | call_vertical_spread | 2 | 1 | 125 | 153674.00 | short | bid | 190.6600 | 1.8500 | ["185","190"] | ["0.6311","0.6084"] | ["188.18"] | ["XCBO"] | 185.0000 | 190.0000 | 3 | 3 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:07:36Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |