core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg570,195 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric |
|---|
| 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 |
|---|
| 01a0edad-15f6-7332-9b69-d7b739707625 | AGQ | 2026-09-29 10:58 | put_diagonal_spread | 2 | 1 | 95 | 236170.00 | long | ask | 69.0300 | 3.6000 | ["75","80"] | ["0.7897","1.3946"] | [] | ["XPHO"] | 75.0000 | 80.0000 | 3 | 80 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-29T14:59:16Z"} | 2026-09-29 | 2026-09-29 17:15 | 2026-09-29 17:15 |
| 01a0ed72-6e57-71a1-bb07-40a13922c320 | AGQ | 2026-09-29 09:54 | put_diagonal_spread | 2 | 1 | 50 | 188000.00 | long | ask | 68.4200 | 4.6000 | ["84","86"] | ["0.8602","1.2243"] | [] | ["BATO"] | 84.0000 | 86.0000 | 10 | 52 | false | false | |||||||||||
| 01a0d8e8-11b7-7e11-9e9b-01a2961b7f32 | AGQ | 2026-09-25 10:11 | call_diagonal_spread | 2 | 1 | 80 | 367520.00 | long | ask | 74.8734 | 4.6500 | ["35","100"] | ["0.7718","0.8540"] | [] | ["XCBO"] | 35.0000 | 100.0000 | 56 | 265 | true | false | |||||||||||
| 01a0cfd7-9aa7-7aa1-8dd1-eda1a871e8d1 | AGQ | 2026-09-23 15:56 | call_vertical_spread | 2 | 1 | 40 | 193760.00 | long | ask | 76.5200 | 9.9000 | ["80","130"] | ["0.8284","0.8965"] | ["88.60"] | ["XMIO"] | 80.0000 | 130.0000 | 485 | 485 | false | true | |||||||||||
| 01a0c447-a88f-7282-9843-1579a3b2ff83 | AGQ | 2026-09-21 10:03 | put_calendar | 2 | 1 | 41 | 734966.00 | long | bid | 80.5600 | 6.7000 | ["150"] | ["1.0534"] | [] | ["XMIO"] | 150.0000 | 150.0000 | 634 | 816 | false | false | |||||||||||
| 01a0afd5-66fb-71a2-837a-32b0949ca0e1 | AGQ | 2026-09-17 10:46 | put_vertical_spread | 2 | 1 | 5 | 417395.00 | long | ask | 80.2150 | 2.2000 | ["495","500"] | ["13.2539","13.0620"] | ["495.03"] | ["XISX"] | 495.0000 | 500.0000 | 1 | 1 | false | false | |||||||||||
| 01a0afd0-7943-7c10-8d85-5ffd2d3d6cb3 | AGQ | 2026-09-17 10:41 | put_vertical_spread | 2 | 1 | 5 | 417400.00 | long | ask | 80.2038 | 2.2000 | ["495","500"] | ["13.1636","13.0520"] | ["495.02"] | ["XPHO"] | 495.0000 | 500.0000 | 1 | 1 | false | false | |||||||||||
| 01a0afab-5573-7272-9ddc-7d2134cb6be3 | AGQ | 2026-09-17 10:00 | call_diagonal_spread | 2 | 1 | 150 | 211350.00 | long | ask | 79.7400 | 1.7000 | ["74","77"] | ["1.3148","0.8366"] | [] | ["XISX"] | 74.0000 | 77.0000 | 1 | 22 | false | false | |||||||||||
| 01a0a130-a740-7af0-85ec-7f95f0579884 | AGQ | 2026-09-14 14:31 | put_vertical_spread | 2 | 1 | 3 | 295566.00 | long | ask | 75.0800 | 3.8000 | ["565","570"] | ["8.0225","8.0080"] | ["565.02"] | ["XCBO"] | 565.0000 | 570.0000 | 4 | 4 | false | false | |||||||||||
| 01a08bb6-b2b1-7da1-a2e0-df9cb6db799b | AGQ | 2026-09-10 10:26 | call_diagonal_spread | 2 | 1 | 20 | 149380.00 | long | ask | 77.5800 | 7.4000 | ["50","100"] | ["0.8590","0.9207"] | [] | ["XMIO"] | 50.0000 | 100.0000 | 498 | 827 | false | false | |||||||||||
| 01a086c3-ab50-75b3-b735-d635d9360985 | AGQ | 2026-09-09 11:22 | put_calendar | 2 | 1 | 7 | 126266.00 | long | bid | 83.1311 | 6.8000 | ["150"] | ["1.0625"] | [] | ["XCBO"] | 150.0000 | 150.0000 | 646 | 828 | false | false | |||||||||||
| 01a086c3-5561-7a70-885c-c1ada19bd613 | AGQ | 2026-09-09 11:22 | put_calendar | 2 | 1 | 13 | 234377.00 | long | bid | 83.1200 | 7.0000 | ["150"] | ["1.0613"] | [] | ["XCBO"] | 150.0000 | 150.0000 | 646 | 828 | false | false | |||||||||||
| 01a086c3-2e50-7271-87c0-1ae9d4acebf7 | AGQ | 2026-09-09 11:22 | put_calendar | 2 | 1 | 22 | 396594.00 | long | bid | 83.2000 | 7.0000 | ["150"] | ["1.0617"] | [] | ["BATO"] | 150.0000 | 150.0000 | 646 | 828 | false | false | |||||||||||
| 01a0867f-8dd0-7810-8805-8f1f7e15c35d | AGQ | 2026-09-09 10:08 | put_calendar | 2 | 1 | 46 | 825056.00 | long | bid | 86.0150 | 4.3000 | ["150"] | ["1.0728"] | [] | ["XMIO"] | 150.0000 | 150.0000 | 646 | 828 | false | false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T13:55:21Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T14:11:23Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:57:06Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:03:49Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:46:32Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:41:39Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:00:35Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T18:32:40Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:26:49Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:22:56Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:22:35Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:22:35Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:08:29Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |