core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg508,354 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 |
|---|
| 01a0da23-aaaf-7a42-b7a7-a774ed9afbc1 | BE | 2026-09-25 15:56 | other | 4 | 2 | 20 | 162620.00 | unknown | bid | 290.0500 | 3.8500 | ["220","230","300","320"] | ["0.7904","0.7794","0.8398","0.8412"] | [] | ["XISX","XPHO"] | 220.0000 | 320.0000 | 28 | 84 | false | true | true | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T19:56:16Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d954-ece7-7841-973d-c4e9441966b6 | BE | 2026-09-25 12:10 | other | 4 | 1 | 30 | 207630.00 | unknown | bid | 292.1300 | 4.9500 | ["270","280","290"] | ["0.7740","0.7805","0.7860"] | [] | ["XISX"] | 270.0000 | 290.0000 | 21 | 28 | false | true | true | true | |||||||||
| 01a0d8c3-381f-7ab0-b869-5e2bec7ae2dd | BE | 2026-09-25 09:31 | other | 6 | 3 | 58 | 1044012.00 | unknown | bid | 269.5100 | 10.4707 | ["170","190","255","257.5","260","262.5"] | ["1.2402","0.8416","1.3981","1.0072","1.3632","1.1951"] | [] | ["XISX"] | 170.0000 | 262.5000 | 0 | 21 | false | false | true | true | |||||||||
| 01a0d4bd-6366-7e22-9ab9-718ab351e81b | BE | 2026-09-24 14:46 | other | 4 | 1 | 70 | 605800.00 | unknown | bid | 264.4500 | 11.4500 | ["300","302.5","320","322.5"] | ["2.0830","1.9556","2.5491","1.7346"] | ["266.10"] | ["XBOX"] | 300.0000 | 322.5000 | 1 | 1 | false | false | false | true | |||||||||
| 01a0d474-870f-74a3-b197-736336d8a1fd | BE | 2026-09-24 13:26 | other | 4 | 2 | 160 | 204640.00 | unknown | bid | 265.7400 | 2.4400 | ["275","280","285","290"] | ["0.9151","0.9132","0.7978","0.8004"] | [] | ["XCBO","XMIO"] | 275.0000 | 290.0000 | 1 | 8 | false | true | true | true | |||||||||
| 01a0ce90-0747-7543-827f-90133b861e9a | BE | 2026-09-23 09:58 | other | 3 | 3 | 30 | 155740.00 | unknown | bid | 278.3200 | 6.4500 | ["200","280","400"] | ["0.8190","0.8120","0.8273"] | ["197.76","522.24"] | ["BATO","C2OX","EDGO"] | 200.0000 | 400.0000 | 114 | 114 | false | true | false | true | |||||||||
| 01a0c9ca-5176-7172-a0b9-7ccbe0336e50 | BE | 2026-09-22 11:44 | other | 4 | 1 | 3 | 110583.00 | unknown | bid | 279.4500 | 9.1500 | ["150","190","290","350"] | ["0.8687","0.9333","0.7962","0.8647"] | [] | ["EMLD"] | 150.0000 | 350.0000 | 24 | 486 | false | false | true | true | |||||||||
| 01a0c9c8-6547-7aa0-b8a6-efff15c157f3 | BE | 2026-09-22 11:42 | other | 3 | 1 | 56 | 112672.00 | unknown | bid | 279.8800 | 1.6100 | ["170","230","310"] | ["0.9363","0.8703","0.8068"] | [] | ["EDGO"] | 170.0000 | 310.0000 | 17 | 38 | false | true | true | true | |||||||||
| 01a0c9a7-8736-7201-a818-93cd81408ec8 | BE | 2026-09-22 11:06 | other | 3 | 1 | 10 | 145830.00 | unknown | bid | 277.6000 | 8.8500 | ["200","280","350"] | ["0.8421","0.8450","0.8446"] | ["362.04"] | ["XISX"] | 200.0000 | 350.0000 | 206 | 206 | false | true | false | true | |||||||||
| 01a0c99f-1327-7b92-aed3-1fd95729f183 | BE | 2026-09-22 10:57 | other | 5 | 3 | 15 | 129850.00 | unknown | bid | 277.0000 | 10.1800 | ["220","235","240","250","300"] | ["0.9238","1.0223","0.9576","0.9538","0.8613"] | [] | ["XISX","XMIO","XPHO"] | 220.0000 | 300.0000 | 3 | 206 | false | false | true | true | |||||||||
| 01a0c990-599f-7fb2-bcfe-ed34176fd088 | BE | 2026-09-22 10:41 | other | 3 | 1 | 20 | 111030.00 | unknown | bid | 281.1950 | 4.8000 | ["200","280","400"] | ["0.8291","0.8386","0.8400"] | ["363.25"] | ["BATO"] | 200.0000 | 400.0000 | 115 | 115 | false | false | false | true | |||||||||
| 01a0c438-ac9f-7782-92b9-34ae1b627c8f | BE | 2026-09-21 09:47 | other | 4 | 1 | 20 | 501760.00 | unknown | bid | 274.0772 | 11.2500 | ["250","260","340"] | ["0.8000","0.8686","0.8654"] | [] | ["XCBO"] | 250.0000 | 340.0000 | 4 | 487 | false | false | true | true | |||||||||
| 01a0b4f8-f3f8-7b63-86d2-c8687d69bb32 | BE | 2026-09-18 10:43 | other | 4 | 1 | 20 | 124300.00 | unknown | bid | 271.6500 | 4.1000 | ["250","270","275"] | ["1.5046","1.3813","0.7690"] | [] | ["XMIO"] | 250.0000 | 275.0000 | 0 | 7 | false | false | true | true | |||||||||
| 01a0b4c2-c4df-7a13-b572-8eee7f500bef | BE | 2026-09-18 09:44 | other | 4 | 1 | 15 | 106050.00 | unknown | bid | 277.6750 | 9.8500 | ["262.5","265"] | ["1.1917","1.2931"] | [] | ["XPHO"] | 262.5000 | 265.0000 | 0 | 7 | false | false | true | true | |||||||||
| 01a0b4b5-d84c-7502-94a1-8d5fbc60c6b2 | BE | 2026-09-18 09:30 | other | 3 | 2 | 18 | 177863.00 | unknown | bid | 284.5500 | 9.4500 | ["220","250","290"] | ["0.8404","0.8714","0.8731"] | [] | ["XISX"] | 220.0000 | 290.0000 | 28 | 63 | false | false | true | true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T16:10:32Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T13:31:07Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:46:58Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T17:26:48Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T13:59:02Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:45:15Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:43:04Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:06:39Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:57:45Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:41:14Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:47:36Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:43:41Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:44:33Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:30:04Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |