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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5ae-6918-7770-8601-0a55985d6a2b | BABA | 2026-09-18 14:01 | call_ladder | 3 | 2 | 400 | 165600.00 | unknown | bid | 113.2200 | 0.4000 | ["112","116","128"] | ["0.4845","0.5078","0.5644"] | ["112.10","119.90","136.10"] | ["AMXO"] | 112.0000 | 128.0000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:01:49Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0f2-8343-7213-b50b-58ac0c12284e | BABA | 2026-09-17 15:57 | ratio_risk_reversal | 2 | 1 | 1186 | 3738965.00 | unknown | — | 108.6400 | 2.1500 | ["110","150"] | ["0.4576","0.4402"] | [] | ["XBOX"] | 110.0000 | 150.0000 | 491 | 491 | false | false | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:58:06Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0b5-a923-7190-bdae-f28d132712e4 | BABA | 2026-09-17 14:51 | other | 6 | 1 | 4176 | 13419360.00 | unknown | — | 108.4250 | 8.6000 | ["117","120","121","125","130","175"] | ["1.5370","1.4722","2.0543","2.0491","2.4482","0.8988"] | [] | ["XBOX"] | 117.0000 | 175.0000 | 1 | 64 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:51:58Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0b5-8dcb-7c82-b041-f7ee5c26f8bf | BABA | 2026-09-17 14:51 | other | 4 | 1 | 902 | 9465804.00 | unknown | — | 108.4195 | 6.4500 | ["118","170","180"] | ["1.3331","3.1160","0.6386"] | [] | ["XBOX"] | 118.0000 | 180.0000 | 1 | 120 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:51:58Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0b5-7273-7d41-ab45-c9494692423c | BABA | 2026-09-17 14:51 | other | 4 | 1 | 8510 | 44053800.00 | unknown | — | 108.4150 | 5.2000 | ["120","130","135","140"] | ["1.4632","2.4381","3.2695","3.6445"] | [] | ["XBOX"] | 120.0000 | 140.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:51:19Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0b5-14b3-7211-818f-e7b243f37f7c | BABA | 2026-09-17 14:50 | other | 7 | 1 | 1784 | 13431936.00 | unknown | — | 108.3900 | 9.7000 | ["117","118","125","130","145","150","180"] | ["1.5177","1.3097","1.6896","2.4125","3.6386","4.2942","0.7881"] | [] | ["XBOX"] | 117.0000 | 180.0000 | 1 | 92 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:51:19Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a06c-1308-7452-ae0e-562551075ec2 | BABA | 2026-09-14 10:57 | other | 2 | 2 | 1000 | 4208000.00 | unknown | — | 108.9700 | 1.3000 | ["110","150"] | ["0.4468","0.4850"] | [] | ["AMXO"] | 110.0000 | 150.0000 | 459 | 494 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:57:33Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091ea-7770-7972-ba58-b7fb60009a43 | BABA | 2026-09-11 15:20 | other | 3 | 1 | 1130 | 8086528.00 | unknown | — | 109.6900 | 3.3500 | ["140","145","150"] | ["1.2376","1.3010","1.4957"] | [] | ["XBOX"] | 140.0000 | 150.0000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:21:18Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091ea-63e8-7012-9be8-ce1221100885 | BABA | 2026-09-11 15:20 | put_vertical_spread | 2 | 1 | 177 | 1582380.00 | unknown | — | 109.6900 | 2.5500 | ["140","170"] | ["1.2379","1.9526"] | [] | ["XBOX"] | 140.0000 | 170.0000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:21:18Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cb1-1840-79b0-af84-7722152d2b85 | BABA | 2026-09-10 15:00 | other | 3 | 1 | 1955 | 15921350.00 | unknown | — | 108.8400 | 4.1500 | ["135","150","180"] | ["0.8403","1.3619","0.7191"] | [] | ["XBOX"] | 135.0000 | 180.0000 | 8 | 127 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:00:20Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08cb0-f518-7322-a45c-e22e4649f0dd | BABA | 2026-09-10 15:00 | other | 4 | 1 | 4632 | 18747040.00 | unknown | — | 108.8400 | 4.0000 | ["118","124","135","180"] | ["0.9922","1.6033","0.8746","0.7729"] | [] | ["XBOX"] | 118.0000 | 180.0000 | 1 | 99 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:00:20Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08cb0-e961-7892-9035-056a4ea14f64 | BABA | 2026-09-10 14:59 | other | 3 | 1 | 128 | 826520.00 | unknown | — | 108.8400 | 4.1500 | ["135","145","150"] | ["0.8170","1.2717","1.0012"] | [] | ["XBOX"] | 135.0000 | 150.0000 | 8 | 22 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:00:20Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08cb0-0ab8-7e33-914c-3e79fc6ff1f6 | BABA | 2026-09-10 14:59 | other | 7 | 1 | 1017 | 5122170.00 | unknown | — | 109.0000 | 7.0000 | ["119","120","122","129","135","170"] | ["1.3478","1.4844","1.4455","2.9393","1.0099","1.5135"] | [] | ["XBOX"] | 119.0000 | 170.0000 | 1 | 71 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:59:46Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08724-9bb8-7821-998a-8d6118859658 | BABA | 2026-09-09 13:08 | put_vertical_spread | 2 | 1 | 600 | 192000.00 | unknown | — | 110.0838 | 0.1900 | ["105","110"] | ["0.3780","0.3690"] | [] | ["XBOX"] | 105.0000 | 110.0000 | 9 | 9 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:09:27Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |