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 | |||||||||||
| 01a0d4d6-65bf-7361-bdc6-3818c43a066b | AGQ | 2026-09-24 15:13 | put_ladder | 5 | 1 | 34 | 164956.00 | unknown | ask | 74.7800 | 7.8000 | ["89","90","91","92","95"] | ["3.2353","2.1440","2.6249","3.4012","4.1938"] | ["71.11"] | ["XBOX"] | 89.0000 | 95.0000 | 1 | 1 | false | 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 | |||||||||||
| 01a0cfc6-ae9e-7cf1-8520-1939dd791675 | AGQ | 2026-09-23 15:38 | put_calendar | 2 | 1 | 91 | 300664.00 | short | ask | 76.4135 | 2.4000 | ["90"] | ["0.7601"] | [] | ["XCBO"] | 90.0000 | 90.0000 | 23 | 58 | false | false | true | ||||||||||
| 01a0cfc6-ae9e-7cf1-8520-1926fd15eef4 | AGQ | 2026-09-23 15:38 | put_calendar | 2 | 3 | 109 | 356430.00 | short | ask | 76.4200 | 3.0000 | ["90"] | ["0.7404"] | [] | ["ARCO","EMLD","SPHR"] | 90.0000 | 90.0000 | 23 | 58 | false | false | |||||||||||
| 01a0c9e9-bc6f-7443-8862-18e7a5fc8a2b | AGQ | 2026-09-22 12:18 | call_calendar | 2 | 1 | 69 | 143658.00 | short | ask | 79.8300 | 2.0000 | ["70"] | ["0.9335"] | [] | ["XCBO"] | 70.0000 | 70.0000 | 3 | 10 | false | false | true | ||||||||||
| 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 | |||||||||||
| 01a0a688-0d26-7a43-a0e2-d8e05fa950b0 | AGQ | 2026-09-15 15:25 | put_calendar | 2 | 1 | 6 | 125184.00 | short | ask | 75.3351 | 4.7000 | ["173"] | ["1.1176"] | [] | ["XMIO"] | 173.0000 | 173.0000 | 122 | 493 | 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 |
| 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 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:13:40Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 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-23T19:38:29Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:38:29Z"} |
| 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-22T16:19:03Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 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 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:26:12Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| 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 |