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 |
|---|
| 01a06df6-521d-7963-b87b-47d735f639bf | UAL | 2026-09-04 15:47 | call_vertical_spread | 2 | 1 | 10 | 143120.00 | short | bid | 111.5300 | 5.8000 | ["30","50"] | ["1.6155","0.9345"] | ["49.70"] | ["XCBO"] | 30.0000 | 50.0000 | 105 | 105 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:47:46Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a086a5-6168-7301-86da-db3b559b941f | UAL | 2026-09-09 10:49 | other | 3 | 1 | 15 | 244430.00 | unknown | — | 107.2600 | 11.5000 | ["25","27.5","28"] | ["0.9565","0.7930","1.0650"] | [] | ["MCRY"] | 25.0000 | 28.0000 | 100 | 464 | false | false | true | true | false | ||||||||
| 01a0911f-a590-71c2-aa94-1f55d9471455 | UAL | 2026-09-11 11:39 | call_vertical_spread | 2 | 1 | 802 | 289870.00 | long | ask | 109.8650 | 0.5800 | ["120","135"] | ["0.4716","0.4752"] | ["122.23"] | ["XPHO"] | 120.0000 | 135.0000 | 35 | 35 | false | true | |||||||||||
| 01a0919b-e240-7a50-957e-2963c515a0d6 | UAL | 2026-09-11 13:55 | call_diagonal_spread | 2 | 1 | 45 | 140040.00 | long | ask | 109.6650 | 4.0500 | ["110","135"] | ["0.4862","0.4391"] | [] | ["BATO"] | 110.0000 | 135.0000 | 126 | 497 | false | true | |||||||||||
| 01a0a54d-a0f6-7033-94f5-c58d5bb721e4 | UAL | 2026-09-15 09:42 | call_vertical_spread | 2 | 1 | 31404 | 8165040.00 | long | ask | 107.9200 | 0.7800 | ["120","135"] | ["0.4889","0.4688"] | ["121.86"] | ["SPHR"] | 120.0000 | 135.0000 | 31 | 31 | true | true | |||||||||||
| 01a0a62b-5e96-7240-b241-b0acecaab9d3 | UAL | 2026-09-15 13:44 | strangle | 2 | 2 | 500 | 722500.00 | short | bid | 106.1550 | 0.7000 | ["100","120"] | ["0.4746","0.4556"] | ["85.55","134.45"] | ["ARCO"] | 100.0000 | 120.0000 | 122 | 122 | false | true | |||||||||||
| 01a0a641-01a6-7e93-bc84-023d2382d52d | UAL | 2026-09-15 14:07 | call_diagonal_spread | 2 | 1 | 23 | 158953.00 | unknown | — | 106.7000 | 4.9500 | ["90","105"] | ["0.4879","0.4706"] | [] | ["XCBO"] | 90.0000 | 105.0000 | 493 | 857 | false | false | true | true | |||||||||
| 01a0ab1d-a37b-7d90-b37c-eefa8306ce39 | UAL | 2026-09-16 12:47 | straddle | 2 | 1 | 20 | 108700.00 | long | ask | 106.1800 | 2.3500 | ["85"] | ["0.4872"] | ["30.65","139.35"] | ["XCBO"] | 85.0000 | 85.0000 | 730 | 730 | false | false | false | ||||||||||
| 01a0ab22-6a23-7341-b336-3972ba276943 | UAL | 2026-09-16 12:52 | straddle | 2 | 1 | 25 | 136375.00 | short | bid | 106.2150 | 1.6500 | ["85"] | ["0.4893"] | ["30.45","139.55"] | ["AMXO"] | 85.0000 | 85.0000 | 730 | 730 | false | false | false | ||||||||||
| 01a0ab32-ecb3-7103-8e62-565c1dd62e3d | UAL | 2026-09-16 13:10 | straddle | 2 | 1 | 20 | 109700.00 | short | bid | 106.6600 | 1.5000 | ["85"] | ["0.4898"] | ["30.15","139.85"] | ["AMXO"] | 85.0000 | 85.0000 | 730 | 730 | false | false | false | ||||||||||
| 01a0b0a6-66e3-79a3-98bb-6c4474ada3ec | UAL | 2026-09-17 14:34 | other | 4 | 1 | 228 | 659820.00 | unknown | — | 107.6600 | 8.3000 | ["119","120","125","130"] | ["1.7506","1.2854","2.3022","2.6768"] | [] | ["XBOX"] | 119.0000 | 130.0000 | 1 | 1 | false | false | false | true | |||||||||
| 01a0b0f4-253b-7c62-92d6-90f5ee4f9405 | UAL | 2026-09-17 15:59 | call_vertical_spread | 2 | 2 | 265 | 119721.00 | unknown | — | 107.6200 | 0.3300 | ["115","125"] | ["0.5004","0.4874"] | [] | ["ARCO","XBOX"] | 115.0000 | 125.0000 | 29 | 29 | false | true | false | true | |||||||||
| 01a0b0f4-2923-7231-af95-4af661d321be | UAL | 2026-09-17 15:59 | call_vertical_spread | 2 | 3 | 242 | 110352.00 | long | ask | 107.6200 | 0.3000 | ["115","125"] | ["0.5027","0.4897"] | ["117.20"] | ["ARCO","MCRY","XPHO"] | 115.0000 | 125.0000 | 29 | 29 | false | true | |||||||||||
| 01a0b4be-5040-74c1-8c96-3a9899f3462b | UAL | 2026-09-18 09:39 | call_calendar | 2 | 1 | 14 | 177198.00 | short | ask | 107.3550 | 4.1500 | ["45"] | ["8.5059"] | [] | ["XPHO"] | 45.0000 | 45.0000 | 0 | 182 | false | false | true | ||||||||||
| 01a0b4d1-e00f-7240-a8b9-a3d14a3cf38d | UAL | 2026-09-18 10:00 | synthetic | 2 | 7 | 222 | 229704.00 | long | ask | 107.3650 | 0.7734 | ["106"] | ["0.5037"] | ["107.75"] | ["ARCO","EMLD","XISX","XMIO","XPHO"] | 106.0000 | 106.0000 | 21 | 21 | false | false | |||||||||||
| 01a0b57f-13e7-71a2-97e4-2b6c5d939614 | UAL | 2026-09-18 13:09 | call_vertical_spread | 2 | 2 | 1000 | 450000.00 | long | ask | 108.4400 | 0.4800 | ["115","130"] | ["0.5182","0.4971"] | ["118"] | ["ARCO"] | 115.0000 | 130.0000 | 28 | 28 | false | true | |||||||||||
| 01a0b5bd-edbf-79f0-a79d-79dd9b4b9516 | UAL | 2026-09-18 14:18 | call_vertical_spread | 2 | 1 | 50 | 185700.00 | long | ask | 108.4800 | 1.4500 | ["95","110"] | ["0.4795","0.4627"] | ["103.22"] | ["XCBO"] | 95.0000 | 110.0000 | 182 | 182 | false | false | |||||||||||
| 01a0b60e-8a77-7823-aab6-592b7052c454 | UAL | 2026-09-18 15:46 | call_vertical_spread | 2 | 1 | 261 | 130500.00 | long | ask | 109.2300 | 0.4100 | ["115","130"] | ["0.5204","0.5099"] | ["118.16"] | ["XMIO"] | 115.0000 | 130.0000 | 28 | 28 | false | true | |||||||||||
| 01a0c518-101e-7453-bb83-581ad0ebd566 | UAL | 2026-09-21 13:51 | call_vertical_spread | 2 | 1 | 600 | 730800.00 | short | bid | 113.2000 | 0.6000 | ["110","119"] | ["0.5345","0.5318"] | ["114.06"] | ["EDGO"] | 110.0000 | 119.0000 | 25 | 25 | false | false | |||||||||||
| 01a0c58a-dad7-7c72-a73d-613cbb5374de | UAL | 2026-09-21 15:56 | call_diagonal_spread | 2 | 1 | 1200 | 1016100.00 | unknown | bid | 114.3650 | 1.6000 | ["115","120"] | ["0.5360","0.5431"] | [] | ["AMXO"] | 115.0000 | 120.0000 | 18 | 25 | false | true | |||||||||||
| 01a0c58c-a3df-7ad0-8ba5-579b97334f64 | UAL | 2026-09-21 15:58 | call_ratio_spread | 2 | 1 | 155 | 125395.00 | unknown | ask | 114.3900 | 2.6500 | ["118","120"] | ["0.5325","0.5388"] | ["123.69"] | ["AMXO"] | 118.0000 | 120.0000 | 25 | 25 | false | true | |||||||||||
| 01a0c968-20be-77c2-9710-4670f0b77c3a | UAL | 2026-09-22 09:57 | call_vertical_spread | 2 | 3 | 172 | 114436.00 | short | bid | 117.2800 | 0.8357 | ["120","135"] | ["0.5292","0.5298"] | ["123.9"] | ["ARCO","XBOX","XISX"] | 120.0000 | 135.0000 | 24 | 24 | false | true | |||||||||||
| 01a0c978-41a7-7041-84cd-26e9df0a8651 | UAL | 2026-09-22 10:14 | call_vertical_spread | 2 | 1 | 200 | 221800.00 | long | ask | 116.8800 | 3.0000 | ["117","121"] | ["0.5300","0.5266"] | ["118.75"] | ["EDGO"] | 117.0000 | 121.0000 | 24 | 24 | false | true | |||||||||||
| 01a0c993-573e-7182-bad4-089593cd0ef2 | UAL | 2026-09-22 10:44 | call_vertical_spread | 2 | 1 | 500 | 257500.00 | unknown | bid | 115.1000 | 0.8200 | ["120","135"] | ["0.5146","0.5238"] | ["125.15"] | ["XBOX"] | 120.0000 | 135.0000 | 24 | 24 | false | true | |||||||||||
| 01a0c9f5-e1ce-7c63-89d6-198d8184b36d | UAL | 2026-09-22 12:32 | straddle | 2 | 1 | 1000 | 7603000.00 | long | ask | 114.6200 | 3.9000 | ["40"] | ["1.1885"] | ["116.03"] | ["AMXO"] | 40.0000 | 40.0000 | 87 | 87 | false | false | false | ||||||||||
| 01a0ca79-ea96-78f0-8034-e160ffbcae21 | UAL | 2026-09-22 14:56 | put_vertical_spread | 2 | 2 | 190 | 216790.00 | long | ask | 115.3650 | 0.9900 | ["109","119"] | ["0.5310","0.5252"] | ["114.24"] | ["ARCO","EMLD"] | 109.0000 | 119.0000 | 24 | 24 | true | false |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:50:02Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:39:28Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T17:55:35Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T13:42:10Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:44:58Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:08:21Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:47:57Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:52:33Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:11:10Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:34:59Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:59:43Z"} |
| 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-17T19:59:56Z"} |
| 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-18T13:39:39Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:00:48Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:10:12Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:18:41Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:46:48Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:51:39Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:56:53Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:58:59Z"} |
| 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-22T13:57:37Z"} |
| 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-22T14:15:10Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:44:55Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:32:39Z"} |
| 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-22T18:56:28Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |