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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b50e-aa8f-7891-8fc7-bb4e22f0c3d2 | APP | 2026-09-18 11:07 | call_butterfly_spread | 3 | 1 | 10 | 186320.00 | long | ask | 314.3800 | 22.1000 | ["300","400","500"] | ["0.6763","0.6650","0.6648"] | ["310.32","489.68"] | ["XMIO"] | 300.0000 | 500.0000 | 637 | 637 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:07:27Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b50e-a6a8-78d2-b793-32108ad2f598 | APP | 2026-09-18 11:07 | call_butterfly_spread | 3 | 1 | 10 | 186360.00 | long | ask | 314.3800 | 22.1000 | ["300","400","500"] | ["0.6773","0.6651","0.6642"] | ["310.32","489.68"] | ["XCBO"] | 300.0000 | 500.0000 | 637 | 637 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:07:27Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b50e-1620-7ae1-94ce-1c1ab84f56ac | APP | 2026-09-18 11:06 | call_butterfly_spread | 3 | 1 | 10 | 186360.00 | long | ask | 314.2375 | 23.1000 | ["300","400","500"] | ["0.6780","0.6657","0.6646"] | ["310.32","489.68"] | ["XCBO"] | 300.0000 | 500.0000 | 637 | 637 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:06:33Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4f4-8b0f-7692-8f88-5e876e8ce3d3 | APP | 2026-09-18 10:38 | call_butterfly_spread | 3 | 1 | 4 | 107588.00 | long | ask | 316.4400 | 16.3000 | ["190","340","490"] | ["0.7008","0.6790","0.6703"] | ["211.78","468.22"] | ["XCBO"] | 190.0000 | 490.0000 | 854 | 854 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:39:05Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4f3-69ff-7c33-9879-48ee1c2aa8b2 | APP | 2026-09-18 10:37 | call_butterfly_spread | 3 | 1 | 4 | 107584.00 | long | ask | 316.6900 | 16.3000 | ["190","340","490"] | ["0.6987","0.6779","0.6695"] | ["211.80","468.20"] | ["XCBO"] | 190.0000 | 490.0000 | 854 | 854 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:37:39Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4f3-17f7-7350-b0ab-e9a178f8ba4d | APP | 2026-09-18 10:37 | call_butterfly_spread | 3 | 1 | 4 | 107586.00 | long | ask | 316.3900 | 16.3000 | ["190","340","490"] | ["0.7014","0.6791","0.6705"] | ["211.85","468.15"] | ["XCBO"] | 190.0000 | 490.0000 | 854 | 854 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:37:13Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4f3-0088-7c51-93e9-58d2d092e759 | APP | 2026-09-18 10:36 | call_butterfly_spread | 3 | 1 | 4 | 107586.00 | long | ask | 316.3900 | 16.3000 | ["190","340","490"] | ["0.7014","0.6791","0.6705"] | ["211.85","468.15"] | ["XCBO"] | 190.0000 | 490.0000 | 854 | 854 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:37:13Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4de-e7ff-7893-a377-14a3733e8f39 | APP | 2026-09-18 10:14 | call_butterfly_spread | 3 | 1 | 4 | 107428.00 | long | ask | 317.7600 | 25.7000 | ["190","340","490"] | ["0.7214","0.6876","0.6756"] | ["212.70","467.30"] | ["XCBO"] | 190.0000 | 490.0000 | 819 | 819 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:15:12Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4de-a97f-7523-9841-779a2b34948b | APP | 2026-09-18 10:14 | call_butterfly_spread | 3 | 1 | 4 | 107428.00 | long | ask | 317.8400 | 25.7000 | ["190","340","490"] | ["0.7208","0.6873","0.6753"] | ["212.70","467.30"] | ["XCBO"] | 190.0000 | 490.0000 | 819 | 819 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:14:56Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4db-dea7-7033-98db-528606c563d9 | APP | 2026-09-18 10:11 | call_butterfly_spread | 3 | 1 | 4 | 107352.00 | long | ask | 317.6700 | 26.5000 | ["190","340","490"] | ["0.7193","0.6876","0.6762"] | ["212.60","467.40"] | ["XCBO"] | 190.0000 | 490.0000 | 819 | 819 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:11:45Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4db-dac0-7630-bc53-36e9e69d7734 | APP | 2026-09-18 10:11 | call_butterfly_spread | 3 | 1 | 4 | 107352.00 | long | ask | 317.6750 | 26.5000 | ["190","340","490"] | ["0.7192","0.6876","0.6762"] | ["212.60","467.40"] | ["XCBO"] | 190.0000 | 490.0000 | 819 | 819 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:11:45Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4db-dac0-7630-bc53-36d33e8d7732 | APP | 2026-09-18 10:11 | call_butterfly_spread | 3 | 1 | 4 | 107352.00 | long | ask | 317.6750 | 26.5000 | ["190","340","490"] | ["0.7192","0.6876","0.6762"] | ["212.60","467.40"] | ["XCBO"] | 190.0000 | 490.0000 | 819 | 819 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:11:45Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4db-c34f-7e52-aadd-103494a02654 | APP | 2026-09-18 10:11 | call_butterfly_spread | 3 | 1 | 4 | 107352.00 | long | ask | 317.7000 | 26.5000 | ["190","340","490"] | ["0.7190","0.6875","0.6761"] | ["212.60","467.40"] | ["XCBO"] | 190.0000 | 490.0000 | 819 | 819 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:11:45Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4db-c34f-7e52-aadd-102c044e317c | APP | 2026-09-18 10:11 | call_butterfly_spread | 3 | 1 | 4 | 107352.00 | long | ask | 317.7000 | 26.5000 | ["190","340","490"] | ["0.7190","0.6875","0.6761"] | ["212.60","467.40"] | ["XCBO"] | 190.0000 | 490.0000 | 819 | 819 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:11:45Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4db-b798-7472-a5e5-5e2aef9a841b | APP | 2026-09-18 10:11 | call_butterfly_spread | 3 | 1 | 4 | 107352.00 | long | ask | 317.6800 | 26.5000 | ["190","340","490"] | ["0.7192","0.6875","0.6761"] | ["212.60","467.40"] | ["XCBO"] | 190.0000 | 490.0000 | 819 | 819 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:11:45Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4da-6f77-7563-802c-67c703ee699e | APP | 2026-09-18 10:10 | call_butterfly_spread | 3 | 1 | 10 | 267360.00 | long | ask | 317.2300 | 30.2000 | ["190","340","490"] | ["0.7124","0.6864","0.6779"] | ["212.60","467.40"] | ["XCBO"] | 190.0000 | 490.0000 | 819 | 819 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:10:11Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4da-6f77-7563-802c-67bdf2f3bfd2 | APP | 2026-09-18 10:10 | call_butterfly_spread | 3 | 1 | 10 | 267360.00 | long | ask | 317.2300 | 30.2000 | ["190","340","490"] | ["0.7124","0.6864","0.6779"] | ["212.60","467.40"] | ["XCBO"] | 190.0000 | 490.0000 | 819 | 819 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:10:11Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4da-6f77-7563-802c-67a1083e838b | APP | 2026-09-18 10:10 | call_butterfly_spread | 3 | 1 | 10 | 267360.00 | long | ask | 317.2300 | 30.2000 | ["190","340","490"] | ["0.7124","0.6864","0.6779"] | ["212.60","467.40"] | ["XCBO"] | 190.0000 | 490.0000 | 819 | 819 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:10:11Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d9-94b8-7a81-8eb8-106e24c99962 | APP | 2026-09-18 10:09 | call_butterfly_spread | 3 | 1 | 20 | 534720.00 | long | ask | 317.6100 | 30.2000 | ["190","340","490"] | ["0.7092","0.6847","0.6767"] | ["212.60","467.40"] | ["XCBO"] | 190.0000 | 490.0000 | 819 | 819 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:09:16Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d8-e8d7-7730-9b96-e761a4c96ffe | APP | 2026-09-18 10:08 | call_butterfly_spread | 3 | 1 | 10 | 267330.00 | short | bid | 317.3625 | 30.2000 | ["190","340","490"] | ["0.7095","0.6865","0.6770"] | ["212.10","467.90"] | ["XCBO"] | 190.0000 | 490.0000 | 819 | 819 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:08:42Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |