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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c429-7616-7ea1-969b-ff9644993853 | ADI | 2026-09-21 09:30 | call_frontspread | 2 | 1 | 14 | 185704.00 | long | bid | 374.3200 | 8.6000 | ["420","480"] | ["0.3774","0.3792"] | ["701.00"] | ["XMIO"] | 420.0000 | 480.0000 | 851 | 851 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:30:58Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b0cf-43d3-7a40-a077-da1e44450332 | ADI | 2026-09-17 15:19 | put_vertical_spread | 2 | 1 | 783 | 880875.00 | long | ask | 362.2200 | 3.4000 | ["357.5","372.5"] | ["0.3692","0.5953"] | ["363.29"] | ["AMXO"] | 357.5000 | 372.5000 | 1 | 1 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:19:39Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab8b-f993-79f2-84f3-365f9c170efa | ADI | 2026-09-16 14:47 | call_diagonal_spread | 2 | 1 | 30 | 104970.00 | long | ask | 361.1550 | 3.7000 | ["350","380"] | ["0.5634","0.3865"] | [] | ["C2OX"] | 350.0000 | 380.0000 | 2 | 93 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:47:59Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab8b-f5ab-7be3-ab9b-056034e71bfa | ADI | 2026-09-16 14:47 | call_diagonal_spread | 2 | 3 | 45 | 155715.00 | long | ask | 361.1550 | 3.5000 | ["350","380"] | ["0.5358","0.3839"] | [] | ["C2OX","XBOX"] | 350.0000 | 380.0000 | 2 | 93 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:47:59Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab8b-e223-70b1-815f-f652555bf444 | ADI | 2026-09-16 14:47 | call_diagonal_spread | 2 | 1 | 30 | 104640.00 | long | ask | 361.4000 | 4.3000 | ["350","380"] | ["0.5304","0.3843"] | [] | ["C2OX"] | 350.0000 | 380.0000 | 2 | 93 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:47:59Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab5a-d38b-7103-9dfa-e2f135660979 | ADI | 2026-09-16 13:54 | call_diagonal_spread | 2 | 1 | 30 | 121470.00 | long | ask | 365.9800 | 2.3000 | ["350","380"] | ["0.5266","0.3792"] | [] | ["C2OX"] | 350.0000 | 380.0000 | 2 | 93 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:54:13Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab5a-c3eb-78c0-8fca-1655851f75b6 | ADI | 2026-09-16 13:54 | call_diagonal_spread | 2 | 1 | 30 | 121650.00 | long | ask | 365.9400 | 2.2000 | ["350","380"] | ["0.5383","0.3799"] | [] | ["C2OX"] | 350.0000 | 380.0000 | 2 | 93 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:54:13Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab5a-0c53-7e91-8a03-1988e67e77db | ADI | 2026-09-16 13:53 | call_diagonal_spread | 2 | 1 | 30 | 121320.00 | long | ask | 365.7550 | 3.0000 | ["350","380"] | ["0.5524","0.3807"] | [] | ["C2OX"] | 350.0000 | 380.0000 | 2 | 93 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:53:29Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab58-8d83-76a3-ae10-a588920c0805 | ADI | 2026-09-16 13:51 | call_diagonal_spread | 2 | 1 | 30 | 121680.00 | long | ask | 365.6900 | 3.4000 | ["350","380"] | ["0.5717","0.3819"] | [] | ["C2OX"] | 350.0000 | 380.0000 | 2 | 93 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:51:53Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab57-705b-7543-a0aa-572755f67e6e | ADI | 2026-09-16 13:50 | call_diagonal_spread | 2 | 2 | 30 | 121410.00 | long | ask | 365.6400 | 3.8000 | ["350","380"] | ["0.5590","0.3826"] | [] | ["C2OX"] | 350.0000 | 380.0000 | 2 | 93 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:51:01Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab57-6c73-72c0-8da7-8d9ce950de92 | ADI | 2026-09-16 13:50 | call_diagonal_spread | 2 | 1 | 30 | 121410.00 | long | ask | 365.6400 | 3.8000 | ["350","380"] | ["0.5590","0.3826"] | [] | ["C2OX"] | 350.0000 | 380.0000 | 2 | 93 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:51:01Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab56-dbeb-7621-b0f4-dfb6d7954c12 | ADI | 2026-09-16 13:49 | call_diagonal_spread | 2 | 2 | 60 | 242250.00 | long | ask | 365.6850 | 3.9000 | ["350","380"] | ["0.5422","0.3819"] | [] | ["ARCO","C2OX"] | 350.0000 | 380.0000 | 2 | 93 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:50:04Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab56-d41b-79c3-88f4-68f90f21ee08 | ADI | 2026-09-16 13:49 | call_diagonal_spread | 2 | 1 | 30 | 121230.00 | long | ask | 365.6850 | 3.9000 | ["350","380"] | ["0.5474","0.3819"] | [] | ["C2OX"] | 350.0000 | 380.0000 | 2 | 93 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:50:04Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab56-d41b-79c3-88f4-68eb92903109 | ADI | 2026-09-16 13:49 | call_diagonal_spread | 2 | 1 | 30 | 121050.00 | long | ask | 365.6850 | 3.9000 | ["350","380"] | ["0.5370","0.3819"] | [] | ["ARCO"] | 350.0000 | 380.0000 | 2 | 93 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:50:04Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab56-d41b-79c3-88f4-68d8256d3f57 | ADI | 2026-09-16 13:49 | call_diagonal_spread | 2 | 2 | 60 | 242250.00 | long | ask | 365.6850 | 3.9000 | ["350","380"] | ["0.5413","0.3819"] | [] | ["ARCO","C2OX"] | 350.0000 | 380.0000 | 2 | 93 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:50:04Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aaf3-6313-7f91-80f7-c0b27213c655 | ADI | 2026-09-16 12:01 | call_diagonal_spread | 2 | 3 | 2750 | 10989000.00 | long | ask | 365.1500 | 2.6338 | ["350","380"] | ["0.5570","0.3834"] | [] | ["XCBO"] | 350.0000 | 380.0000 | 2 | 93 | false | false | true | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:01:39Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a65b-e85e-7582-bcbd-bfca9b309e95 | ADI | 2026-09-15 14:37 | call_diagonal_spread | 2 | 1 | 31 | 314030.00 | long | ask | 361.0000 | 4.8000 | ["450","490"] | ["0.3982","0.3954"] | [] | ["XMIO"] | 450.0000 | 490.0000 | 493 | 857 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:37:58Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a65b-01e6-7353-a998-7ed6df03bc82 | ADI | 2026-09-15 14:36 | call_diagonal_spread | 2 | 1 | 27 | 273240.00 | long | ask | 361.1050 | 5.6000 | ["450","490"] | ["0.3971","0.3954"] | [] | ["XMIO"] | 450.0000 | 490.0000 | 493 | 857 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:36:15Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a658-c796-7d10-814e-3646d076a2f1 | ADI | 2026-09-15 14:33 | call_diagonal_spread | 2 | 2 | 51 | 638673.00 | long | ask | 361.2500 | 4.6000 | ["390","470"] | ["0.3996","0.3951"] | [] | ["ARCO","XISX"] | 390.0000 | 470.0000 | 493 | 857 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:34:19Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a658-c796-7d10-814e-363bec3860f0 | ADI | 2026-09-15 14:33 | call_diagonal_spread | 2 | 2 | 28 | 350650.00 | long | ask | 361.2500 | 4.6000 | ["390","470"] | ["0.3996","0.3951"] | [] | ["ARCO","XISX"] | 390.0000 | 470.0000 | 493 | 857 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:34:19Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0821b-5121-7281-8fbb-2f99c33e4c50 | ADI | 2026-09-08 13:40 | call_diagonal_spread | 2 | 1 | 32 | 285120.00 | long | ask | 362.7700 | 4.7000 | ["320","360"] | ["0.5300","0.3833"] | [] | ["XISX"] | 320.0000 | 360.0000 | 10 | 192 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:40:44Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06d44-01ad-7b00-991c-01c7567733e0 | ADI | 2026-09-04 12:32 | call_diagonal_spread_bearish | 2 | 3 | 19 | 310986.00 | long | ask | 361.7850 | 4.9000 | ["300","340"] | ["0.3907","0.3926"] | [] | ["AMXO","XCBO","XISX"] | 300.0000 | 340.0000 | 196 | 504 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:32:51Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d43-9065-79b3-86fe-229f186cad8f | ADI | 2026-09-04 12:32 | call_diagonal_spread_bearish | 2 | 2 | 11 | 180026.00 | long | ask | 361.9300 | 4.9000 | ["300","340"] | ["0.3890","0.3919"] | [] | ["XCBO"] | 300.0000 | 340.0000 | 196 | 504 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:32:18Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |