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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b0b2-70eb-7633-a87a-42fad483af71 | BAC | 2026-09-17 14:47 | call_diagonal_spread | 2 | 1 | 3000 | 248000.00 | unknown | — | 58.2150 | 0.0300 | ["60","65"] | ["0.2503","0.9061"] | [] | ["AMXO"] | 60.0000 | 65.0000 | 1 | 29 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:48:13Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a2-57d3-7930-96c7-512ac7a8b214 | BAC | 2026-09-17 14:30 | other | 6 | 1 | 1784 | 1918208.00 | unknown | — | 58.2950 | 1.3600 | ["60","62","63"] | ["0.5209","0.4906","0.8758"] | [] | ["XBOX"] | 60.0000 | 63.0000 | 1 | 15 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:30:58Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a2-444b-7152-bc27-a2f73b671aa3 | BAC | 2026-09-17 14:30 | other | 6 | 1 | 5370 | 3306600.00 | unknown | — | 58.2950 | 1.3300 | ["60","61","63","65","67.5"] | ["0.4764","0.7233","0.4830","1.5374","0.3861"] | [] | ["XBOX"] | 60.0000 | 67.5000 | 1 | 29 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:30:18Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a2-2cdb-72d2-b4b6-bd39b7b13760 | BAC | 2026-09-17 14:30 | put_vertical_spread | 2 | 1 | 7846 | 4786060.00 | unknown | — | 58.2950 | 0.3600 | ["60","62.5"] | ["0.4918","0.9309"] | [] | ["XBOX"] | 60.0000 | 62.5000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:30:18Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aba6-ec03-7f12-81ac-9bd7529c99ad | BAC | 2026-09-16 15:17 | call_ratio_spread | 2 | 2 | 2000 | 466000.00 | unknown | — | 57.3750 | 0.2400 | ["60","65"] | ["0.2531","0.2449"] | [] | ["ARCO"] | 60.0000 | 65.0000 | 121 | 121 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:17:35Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a62c-6c1e-7a02-9ef7-38b7e9db5e93 | BAC | 2026-09-15 13:45 | put_vertical_spread | 2 | 2 | 500 | 204500.00 | unknown | — | 59.5650 | 0.0600 | ["55","57.5"] | ["0.2822","0.2718"] | [] | ["AMXO"] | 55.0000 | 57.5000 | 122 | 122 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:45:55Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5a2-a2ae-76c1-a6c1-2b9afd6d0d3c | BAC | 2026-09-15 11:14 | put_vertical_spread | 2 | 1 | 840 | 756840.00 | unknown | — | 59.1550 | 0.2100 | ["52.5","65"] | ["0.2865","0.2644"] | [] | ["AMXO"] | 52.5000 | 65.0000 | 185 | 185 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:15:13Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a168-e5b0-7490-9ef4-35579a8d66fe | BAC | 2026-09-14 15:33 | other | 2 | 1 | 53300 | 26969800.00 | unknown | — | 59.1200 | 0.1500 | ["55","60"] | ["0.2840","0.2624"] | [] | ["XPHO"] | 55.0000 | 60.0000 | 95 | 123 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:33:27Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a147-b598-7022-936d-87e440fbabe9 | BAC | 2026-09-14 14:57 | call_vertical_spread | 2 | 1 | 600 | 378600.00 | unknown | — | 59.1350 | 0.3900 | ["55","70"] | ["0.2582","0.2445"] | [] | ["XBOX"] | 55.0000 | 70.0000 | 95 | 95 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:57:43Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a103-7cc0-7371-b167-225a2802018b | BAC | 2026-09-14 13:42 | other | 2 | 1 | 750 | 489000.00 | unknown | — | 59.9700 | 0.6100 | ["61","65"] | ["0.2143","0.6086"] | [] | ["XBOX"] | 61.0000 | 65.0000 | 4 | 18 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:42:51Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09154-32b0-7880-ae2f-6dcfb6161a6b | BAC | 2026-09-11 12:36 | strangle | 2 | 1 | 315 | 423675.00 | long | ask | 62.8100 | 0.8000 | ["55","70"] | ["0.3038","0.2339"] | ["41.55","83.45"] | ["XPHO"] | 55.0000 | 70.0000 | 826 | 826 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:36:52Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cb3-f2b8-75a1-bb6e-acdca0dcdac1 | BAC | 2026-09-10 15:03 | other | 3 | 1 | 140 | 113880.00 | unknown | — | 62.2801 | 0.9100 | ["65","67","70"] | ["0.6942","0.3579","0.5136"] | [] | ["XBOX"] | 65.0000 | 70.0000 | 1 | 8 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:03:29Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |