core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg403,968 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | direction |
|---|
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |