core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg473,794 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 |
|---|
| 01a0d454-a2fe-7e12-82a4-a4d7c984af85 | USO | 2026-09-24 12:51 | other | 4 | 2 | 50 | 340647.00 | unknown | ask | 150.7050 | 7.6000 | ["115.5","116","117.5","118"] | ["3.1295","3.2035","2.8379","2.8122"] | ["117.99"] | ["XCBO","XISX"] | 115.5000 | 118.0000 | 1 | 1 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T16:52:13Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0d3b7-93f7-78c1-8815-d6fffdb26238 | USO | 2026-09-24 10:00 | other | 2 | 1 | 2495 | 285927.00 | unknown | ask | 151.5400 | 0.4000 | ["140","150"] | ["0.5338","0.5906"] | [] | ["BATO"] | 140.0000 | 150.0000 | 1 | 6 | false | false | true | true | |||||||||
| 01a0d3a7-30a7-7b63-9abd-e0cafc3a8644 | USO | 2026-09-24 09:42 | other | 2 | 2 | 1935 | 253482.00 | unknown | ask | 151.8800 | 0.2600 | ["141","150"] | ["0.5382","0.6022"] | [] | ["BATO","SPHR"] | 141.0000 | 150.0000 | 1 | 6 | false | false | true | true | |||||||||
| 01a0cf8a-49af-7fe2-bd79-c7af3571c392 | USO | 2026-09-23 14:32 | other | 5 | 1 | 499 | 268501.00 | unknown | ask | 148.7650 | 0.8000 | ["147","149","150","152","155"] | ["0.5700","0.5563","0.5542","0.9520","1.3831"] | [] | ["XISX"] | 147.0000 | 155.0000 | 0 | 2 | false | false | true | true | |||||||||
| 01a0caaf-a868-7203-bc44-4f354fa50a0d | USO | 2026-09-22 15:55 | other | 3 | 1 | 364 | 177996.00 | unknown | ask | 143.8600 | 0.4500 | ["138","142","157"] | ["0.6441","0.6397","0.5586"] | [] | ["XBOX"] | 138.0000 | 157.0000 | 3 | 10 | false | true | true | true | |||||||||
| 01a0c4da-b12e-7f81-b7a6-519268f7c317 | USO | 2026-09-21 12:44 | other | 2 | 4 | 227 | 250721.00 | unknown | ask | 146.8950 | 0.6562 | ["150","165"] | ["0.5852","0.4940"] | [] | ["ARCO","EMLD","SPHR","XPHO"] | 150.0000 | 165.0000 | 4 | 60 | false | false | true | true | |||||||||
| 01a0c4a9-b620-70a0-9e70-a7c7eac9cd13 | USO | 2026-09-21 11:50 | other | 3 | 2 | 24 | 158928.00 | unknown | ask | 147.6500 | 6.1800 | ["100","200","275"] | ["0.4844","0.5062","4.4397"] | [] | ["XISX","XPHO"] | 100.0000 | 275.0000 | 2 | 361 | false | false | true | true | |||||||||
| 01a0c48a-2be7-7f83-916e-a2d9a50afbbe | USO | 2026-09-21 11:16 | other | 2 | 3 | 292 | 113810.00 | unknown | ask | 148.0772 | 0.2200 | ["150","155"] | ["0.6007","0.4931"] | [] | ["BATO","C2OX","EDGO"] | 150.0000 | 155.0000 | 2 | 9 | false | false | true | true | |||||||||
| 01a0c469-edff-7b62-bcc0-70578281ee66 | USO | 2026-09-21 10:41 | other | 4 | 1 | 10 | 151220.00 | unknown | ask | 147.4001 | 7.7500 | ["95","100","140","145"] | ["0.3691","0.3698","0.4796","0.4671"] | [] | ["XISX"] | 95.0000 | 145.0000 | 25 | 816 | false | false | true | true | |||||||||
| 01a0b60f-3a3f-75f3-8350-bf7072ea618b | USO | 2026-09-18 15:47 | other | 4 | 1 | 5 | 113510.00 | unknown | ask | 153.7800 | 7.2500 | ["95","100"] | ["0.9558","0.5655"] | [] | ["AMXO"] | 95.0000 | 100.0000 | 28 | 91 | false | false | true | true | |||||||||
| 01a0b5e3-a5ff-7cd3-9821-5bab4e8ea29c | USO | 2026-09-18 14:59 | other | 4 | 1 | 7 | 145824.00 | unknown | ask | 153.5100 | 6.5500 | ["100","105"] | ["11.9856","10.5735"] | [] | ["EMLD"] | 100.0000 | 105.0000 | 0 | 91 | false | false | true | true | |||||||||
| 01a0b507-4407-7360-becd-84410a52ecf9 | USO | 2026-09-18 10:59 | other | 4 | 3 | 20 | 408100.00 | unknown | ask | 155.9700 | 16.6500 | ["133","137"] | ["0.3693","0.3750"] | [] | ["AMXO"] | 133.0000 | 137.0000 | 819 | 854 | false | false | true | true | |||||||||
| 01a0b4fb-97bf-7d43-aeda-5a0ebd1e74f6 | USO | 2026-09-18 10:46 | other | 4 | 1 | 43 | 961007.00 | unknown | ask | 156.6700 | 17.6500 | ["126","127"] | ["0.3693","0.3696"] | [] | ["XCBO"] | 126.0000 | 127.0000 | 819 | 854 | false | false | true | true | |||||||||
| 01a0b4f7-9c38-74c3-934f-27b65fb14d09 | USO | 2026-09-18 10:41 | other | 4 | 1 | 44 | 135454.00 | unknown | ask | 156.9500 | 3.9800 | ["140","141","147","150"] | ["0.4589","0.4471","0.5416","0.8686"] | [] | ["XCBO"] | 140.0000 | 150.0000 | 0 | 182 | false | false | true | true | |||||||||
| 01a0b4f7-9c37-7983-a783-12d3a7956cf4 | USO | 2026-09-18 10:41 | other | 4 | 4 | 56 | 171764.00 | unknown | ask | 156.9500 | 3.9800 | ["140","141","147","150"] | ["0.4555","0.4503","0.5118","0.9235"] | [] | ["ARCO","EMLD","SPHR"] | 140.0000 | 150.0000 | 0 | 182 | false | false | true | true | |||||||||
| 01a0b4f6-c177-7402-ad44-d1dc80e9ad07 | USO | 2026-09-18 10:41 | other | 4 | 2 | 34 | 104210.00 | unknown | ask | 156.9271 | 4.0000 | ["140","141","147","150"] | ["0.4554","0.4507","0.5082","0.9197"] | [] | ["EMLD","SPHR"] | 140.0000 | 150.0000 | 0 | 182 | false | false | true | true | |||||||||
| 01a0b4f6-c177-7402-ad44-d1ca4649eaf7 | USO | 2026-09-18 10:41 | other | 4 | 3 | 44 | 135432.00 | unknown | ask | 156.9271 | 4.0000 | ["140","141","147","150"] | ["0.4594","0.4478","0.5384","0.8649"] | [] | ["BATO","C2OX","EDGO"] | 140.0000 | 150.0000 | 0 | 182 | false | false | true | true | |||||||||
| 01a0b4f6-2537-7542-9ac2-5a2c95a34213 | USO | 2026-09-18 10:40 | other | 4 | 1 | 20 | 470360.00 | unknown | ask | 156.7804 | 17.7000 | ["120","121"] | ["0.3570","0.3627"] | [] | ["XCBO"] | 120.0000 | 121.0000 | 819 | 854 | false | false | true | true | |||||||||
| 01a0b4eb-d498-7342-b0b7-37a5131bdf57 | USO | 2026-09-18 10:29 | other | 4 | 1 | 600 | 687000.00 | unknown | ask | 157.3800 | 1.1500 | ["152","157","159","164"] | ["1.2965","0.6589","0.4411","0.4683"] | [] | ["EDGO"] | 152.0000 | 164.0000 | 0 | 7 | false | false | true | true | |||||||||
| 01a0b4da-6f77-7563-802c-66e48e95fca1 | USO | 2026-09-18 10:10 | other | 4 | 3 | 70 | 177165.00 | unknown | ask | 156.5600 | 5.9629 | ["165","235","270","305"] | ["0.4284","0.4553","7.4893","0.4725"] | [] | ["EDGO","XCBO","XISX"] | 165.0000 | 305.0000 | 0 | 364 | false | true | true | true | |||||||||
| 01a0b4c5-2257-79d1-96b3-b637a0a12a79 | USO | 2026-09-18 09:46 | other | 4 | 1 | 60 | 175380.00 | unknown | ask | 157.1914 | 5.4100 | ["143","145"] | ["1.5197","1.0043"] | [] | ["XISX"] | 143.0000 | 145.0000 | 0 | 7 | false | false | true | true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:00:30Z"} |
| 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-24T13:42:27Z"} |
| 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-23T18:32:38Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:55:05Z"} |
| 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-21T16:44:23Z"} |
| 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-21T15:50:50Z"} |
| 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-21T15:16:42Z"} |
| 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-21T14:41:29Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:47:39Z"} |
| 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-18T19:00:06Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:59:10Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:46:22Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:42:17Z"} |
| 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:42:17Z"} |
| 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:41:04Z"} |
| 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:41:04Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:40:35Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:29:27Z"} |
| 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:10:11Z"} |
| 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:47:01Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |