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 |
|---|
| 01a0c9a8-081f-7ee1-842a-21d54c594888 | CVX | 2026-09-22 11:07 | call_condor | 4 | 1 | 2519 | 415635.00 | unknown | — | 204.0600 | 0.1900 | ["207.5","210","215","220"] | ["0.3113","0.3131","0.3439","0.3487"] | [] | ["XCBO"] | 207.5000 | 220.0000 | 3 | 3 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T15:07:16Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0b0bf-ee0b-7af2-8004-77141c8957b4 | CVX | 2026-09-17 15:02 | call_diagonal_spread | 2 | 2 | 120 | 333400.00 | unknown | — | 211.3200 | 0.9500 | ["195","200"] | ["0.8002","0.2785"] | [] | ["XISX"] | 195.0000 | 200.0000 | 1 | 29 | false | false | true | true | false | ||||||||
| 01a0afce-1bcb-7851-9347-9d33f540e028 | CVX | 2026-09-17 10:38 | other | 4 | 1 | 2482 | 650284.00 | unknown | — | 210.6750 | 0.4000 | ["215","217.5","220","222.5"] | ["0.2738","0.3956","0.2800","0.4823"] | [] | ["AMXO"] | 215.0000 | 222.5000 | 1 | 8 | false | true | true | true | false | ||||||||
| 01a0aa8b-a863-7012-bee5-9beb1c16ce41 | CVX | 2026-09-16 10:07 | call_calendar | 2 | 1 | 20 | 190580.00 | unknown | — | 213.5900 | 4.7000 | ["170"] | ["0.2652"] | [] | ["XCBO"] | 170.0000 | 170.0000 | 121 | 184 | false | false | true | false | false | mlat | |||||||
| 01a0a6a6-d026-75a2-b8c8-e21e6c70207d | CVX | 2026-09-15 15:59 | straddle | 2 | 1 | 7000 | 10983000.00 | unknown | — | 217.4900 | 0.7000 | ["210"] | ["0.2864"] | [] | ["AMXO"] | 210.0000 | 210.0000 | 31 | 31 | false | false | false | false | true | mlct | |||||||
| 01a0a600-148e-7b50-8b86-482c85146a6b | CVX | 2026-09-15 12:56 | call_calendar | 2 | 1 | 16 | 128368.00 | unknown | — | 216.2100 | 2.7500 | ["210"] | ["0.1960"] | [] | ["XPHO"] | 210.0000 | 210.0000 | 822 | 857 | false | false | true | false | false | mlet | |||||||
| 01a0a5fd-6cde-7700-91e0-233d4b475515 | CVX | 2026-09-15 12:54 | call_calendar | 2 | 1 | 140 | 665400.00 | unknown | — | 216.2400 | 1.8000 | ["200"] | ["0.2570"] | [] | ["XISX"] | 200.0000 | 200.0000 | 122 | 185 | false | false | true | false | false | ||||||||
| 01a0a0d4-c7b9-7f10-9a93-683b9e1cba61 | CVX | 2026-09-14 12:51 | other | 2 | 1 | 160 | 318874.00 | unknown | — | 213.8500 | 0.9300 | ["190","220"] | ["0.4783","0.3071"] | [] | ["XBOX"] | 190.0000 | 220.0000 | 4 | 186 | false | false | true | true | false | mlft | |||||||
| 01a0a0b7-9af8-7c80-ad64-7573b30d8fd3 | CVX | 2026-09-14 12:19 | other | 4 | 1 | 23 | 362664.00 | unknown | — | 214.6900 | 10.5000 | ["160","170","250","270"] | ["0.0955","0.1994","0.2474","0.2463"] | [] | ["XCBO"] | 160.0000 | 270.0000 | 494 | 823 | false | false | true | true | false | ||||||||
| 01a0a0b7-9af8-7c80-ad64-75658075b829 | CVX | 2026-09-14 12:19 | other | 4 | 2 | 77 | 803616.00 | unknown | — | 214.6900 | 10.5000 | ["160","170","250","270"] | ["0.0955","0.1994","0.2474","0.2463"] | [] | ["XCBO"] | 160.0000 | 270.0000 | 494 | 823 | false | false | true | true | false | ||||||||
| 01a0a0b7-9af8-7c80-ad64-7556a4943b26 | CVX | 2026-09-14 12:19 | other | 2 | 1 | 55 | 410520.00 | unknown | — | 214.6900 | 6.1500 | ["170","270"] | ["0.1994","0.2463"] | [] | ["XCBO"] | 170.0000 | 270.0000 | 494 | 823 | false | false | true | true | false | mfsl | |||||||
| 01a0920b-f5a8-7193-82fa-de04ec6e1061 | CVX | 2026-09-11 15:57 | call_vertical_spread | 2 | 1 | 13 | 104910.00 | unknown | — | 213.8100 | 5.4000 | ["160","200"] | ["0.3428","0.2856"] | [] | ["XBOX"] | 160.0000 | 200.0000 | 126 | 126 | false | false | false | true | false | ||||||||
| 01a0913d-33f8-70d3-86c9-259d921b28e2 | CVX | 2026-09-11 12:11 | other | 2 | 4 | 22 | 134428.00 | unknown | — | 213.9300 | 5.1000 | ["175","210"] | ["0.1726","0.2249"] | [] | ["ARCO","EMLD","SPHR","XBOX"] | 175.0000 | 210.0000 | 371 | 371 | false | false | false | true | false | ||||||||
| 01a090f4-6740-77a3-8d88-442872bd4874 | CVX | 2026-09-11 10:52 | other | 2 | 1 | 434 | 171435.00 | unknown | — | 213.3000 | 0.5200 | ["210","235"] | ["0.4714","0.2603"] | [] | ["AMXO"] | 210.0000 | 235.0000 | 0 | 28 | false | false | true | true | false | mlat | |||||||
| 01a090e6-1731-72e2-8b11-83fc415e6dd4 | CVX | 2026-09-11 10:36 | other | 4 | 1 | 2486 | 631444.00 | unknown | — | 214.4050 | 0.4300 | ["217.5","222.5"] | ["0.2930","0.5155"] | [] | ["XPHO"] | 217.5000 | 222.5000 | 0 | 7 | false | true | true | true | false | mlat | |||||||
| 01a08ba8-8d98-7f73-952a-cdac5b2f76e5 | CVX | 2026-09-10 10:11 | other | 4 | 1 | 100 | 107500.00 | unknown | — | 212.4999 | 4.6200 | ["200","230"] | ["0.2763","0.2522"] | [] | ["XBOX"] | 200.0000 | 230.0000 | 43 | 50 | false | true | true | true | true | mlat | |||||||
| 01a0866a-cd50-7e92-af12-093adeb91851 | CVX | 2026-09-09 09:45 | call_vertical_spread | 2 | 1 | 30 | 201900.00 | unknown | — | 215.1000 | 6.4000 | ["180","185"] | ["0.4216","0.2773"] | [] | ["XMIO"] | 180.0000 | 185.0000 | 44 | 44 | false | false | false | true | false | ||||||||
| 01a06daf-6dad-7ed2-b33c-42bd98d5bb5a | CVX | 2026-09-04 14:30 | other | 2 | 1 | 12 | 110676.00 | unknown | — | 208.6750 | 4.6500 | ["160","170"] | ["0.3404","0.2385"] | [] | ["XMIO"] | 160.0000 | 170.0000 | 77 | 133 | false | false | true | true | false | mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:03:06Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:38:55Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:08:05Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:59:14Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:57:07Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:54:06Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:51:56Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:20:08Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:20:08Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:20:08Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:57:30Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T16:11:51Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:52:12Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:36:57Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:11:36Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:45:51Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:30:29Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |