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 |
|---|
| 01a0c96a-d427-75a2-a3cb-f0d336924e23 | CVX | 2026-09-22 10:00 | call_diagonal_spread | 2 | 2 | 54 | 322326.00 | short | ask | 202.9300 | 1.5500 | ["175","200"] | ["0.2376","0.2177"] | [] | ["ARCO","XPHO"] | 175.0000 | 200.0000 | 115 | 486 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T14:00:16Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c96a-d427-75a2-a3cb-f0c88384f6f3 | CVX | 2026-09-22 10:00 | call_diagonal_spread | 2 | 2 | 54 | 316818.00 | short | ask | 202.9300 | 4.6500 | ["175","200"] | ["0.2096","0.2117"] | [] | ["EDGO","XISX"] | 175.0000 | 200.0000 | 115 | 486 | false | false | true | ||||||||||
| 01a0c964-4477-7863-b7f8-d4873b22e242 | CVX | 2026-09-22 09:53 | call_vertical_spread | 2 | 3 | 153 | 101441.00 | long | ask | 202.5600 | 0.7300 | ["202.5","205"] | ["0.2805","0.2785"] | ["203.65"] | ["AMXO","C2OX","XMIO"] | 202.5000 | 205.0000 | 10 | 10 | false | false | false | ||||||||||
| 01a0c94f-9b67-7601-b1b2-5736d5ddf86b | CVX | 2026-09-22 09:30 | call_vertical_spread | 2 | 1 | 20 | 114280.00 | long | ask | 201.4000 | 10.5000 | ["210","220"] | ["0.2042","0.2096"] | ["213.80"] | ["XISX"] | 210.0000 | 220.0000 | 815 | 815 | false | true | false | ||||||||||
| 01a0c50a-f0bf-7e30-a3c2-22ee8a6021d1 | CVX | 2026-09-21 13:37 | call_calendar | 2 | 1 | 20 | 163240.00 | long | ask | 204.3900 | 4.3000 | ["170"] | ["0.2313"] | [] | ["XISX"] | 170.0000 | 170.0000 | 179 | 269 | false | false | true | false | |||||||||
| 01a0b5a9-5067-7ab0-ba77-186b04251a7a | CVX | 2026-09-18 13:56 | call_diagonal_spread | 2 | 3 | 44 | 151838.00 | short | bid | 210.8300 | 0.7398 | ["210","230"] | ["0.2546","0.2334"] | [] | ["AMXO","ARCO","XISX"] | 210.0000 | 230.0000 | 119 | 490 | false | false | true | ||||||||||
| 01a0b592-74d7-7442-a5df-11cfbffde21b | CVX | 2026-09-18 13:31 | call_diagonal_spread | 2 | 1 | 688 | 500176.00 | short | bid | 210.8800 | 0.5200 | ["210","220"] | ["0.4483","0.2644"] | [] | ["EDGO"] | 210.0000 | 220.0000 | 0 | 63 | false | false | true | ||||||||||
| 01a0b4df-0357-7bf3-97c4-c921a0d9b5a1 | CVX | 2026-09-18 10:15 | strangle | 2 | 1 | 40 | 100080.00 | short | bid | 210.8750 | 1.7500 | ["190","215"] | ["3.0005","0.5037"] | ["189.98","215.02"] | ["XPHO"] | 190.0000 | 215.0000 | 0 | 0 | false | false | false | true | |||||||||
| 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 | ||||||||
| 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 | mlet | |||||||
| 01a0a085-09a8-7183-8ba3-d76e3f0c5698 | CVX | 2026-09-14 11:24 | call_diagonal_spread | 2 | 2 | 493 | 124192.00 | long | ask | 214.7250 | 0.3680 | ["240","250"] | ["0.4428","0.2691"] | [] | ["XBOX","XISX"] | 240.0000 | 250.0000 | 4 | 95 | false | true | true | ||||||||||
| 01a0a076-f048-7461-8419-d043e28e1b8a | CVX | 2026-09-14 11:09 | call_diagonal_spread | 2 | 1 | 17 | 137105.00 | long | ask | 214.3950 | 4.8000 | ["180","190"] | ["0.2857","0.2324"] | [] | ["XPHO"] | 180.0000 | 190.0000 | 123 | 494 | false | false | true | ||||||||||
| 01a0a036-ce50-7242-8f4b-5e7db4be574d | CVX | 2026-09-14 09:58 | call_vertical_spread | 2 | 1 | 22 | 114774.00 | short | bid | 216.1600 | 1.7500 | ["180","220"] | ["0.2600","0.2603"] | ["207.23"] | ["AMXO"] | 180.0000 | 220.0000 | 123 | 123 | false | false | false | ||||||||||
| 01a0a036-2e28-7251-a7e7-1ac8459b81ba | CVX | 2026-09-14 09:58 | call_vertical_spread | 2 | 1 | 50 | 260450.00 | short | bid | 216.0100 | 2.3000 | ["180","220"] | ["0.2654","0.2608"] | ["207.25"] | ["AMXO"] | 180.0000 | 220.0000 | 123 | 123 | false | false | false | ||||||||||
| 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 | ||||||||
| 01a08c26-50e8-7aa1-8d3f-c5b2a5c8f36d | CVX | 2026-09-10 12:28 | put_vertical_spread | 2 | 1 | 200 | 143400.00 | long | ask | 213.5650 | 0.3200 | ["200","210"] | ["0.2700","0.2688"] | ["206.89"] | ["MCRY"] | 200.0000 | 210.0000 | 36 | 36 | false | true | false | ||||||||||
| 01a08bdf-d208-7e51-8a39-177e68dcd3b4 | CVX | 2026-09-10 11:11 | call_diagonal_spread | 2 | 1 | 25 | 122575.00 | long | ask | 212.7300 | 2.5500 | ["190","195"] | ["0.2957","0.2458"] | [] | ["XMIO"] | 190.0000 | 195.0000 | 36 | 127 | false | false | true | ||||||||||
| 01a08b87-e250-7582-8a57-f52b05f2ca62 | CVX | 2026-09-10 09:35 | call_diagonal_spread | 2 | 2 | 34 | 246092.00 | short | ask | 215.4800 | 4.7500 | ["190","195"] | ["0.2354","0.2160"] | [] | ["XMIO"] | 190.0000 | 195.0000 | 280 | 372 | false | false | true | ||||||||||
| 01a0871c-9508-7fd3-aa96-28698cf16b96 | CVX | 2026-09-09 12:59 | put_diagonal_spread | 2 | 2 | 68 | 256247.00 | short | bid | 212.8200 | 1.6000 | ["190","200"] | ["0.3195","0.3083"] | [] | ["C2OX","EDGO"] | 190.0000 | 200.0000 | 499 | 828 | false | true | true | ||||||||||
| 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-bfb5-72f1-9676-b04fff7e8715 | CVX | 2026-09-04 14:30 | strangle | 2 | 1 | 120 | 120360.00 | short | bid | 208.6300 | 1.7800 | ["200","210"] | ["2.6291","0.5818"] | ["199.97","210.03"] | ["XISX"] | 200.0000 | 210.0000 | 0 | 0 | false | false | false | true | |||||||||
| 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 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:00:16Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:53:06Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:30:44Z"} |
| 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-21T17:37:02Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:56:46Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:31: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-18T14:15:12Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| 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-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 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:24:31Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:09:20Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T13:59:03Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T13:58:23Z"} |
| 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 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T16:28:48Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:12:05Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T13:35:42Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:00:13Z"} |
| 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-09T13:45:51Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| 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 |
| 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 |