core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg541,738 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 |
|---|
| 01a0da05-a717-7fe0-b4d5-ed47ae190a57 | XLK | 2026-09-25 15:23 | call_calendar | 2 | 1 | 10 | 184980.00 | short | ask | 196.2145 | 4.2500 | ["105"] | ["0.4951"] | [] | ["XISX"] | 105.0000 | 105.0000 | 84 | 112 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T19:23:44Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0da05-2247-7aa3-aef5-a9ccb7584915 | XLK | 2026-09-25 15:22 | call_calendar | 2 | 1 | 10 | 184980.00 | short | ask | 196.2600 | 4.2500 | ["105"] | ["0.4450"] | [] | ["XISX"] | 105.0000 | 105.0000 | 84 | 112 | false | false | true | false | |||||||||
| 01a0d9d2-e6e7-7322-9d9d-f73858f44a38 | XLK | 2026-09-25 14:27 | call_calendar | 2 | 6 | 18 | 335232.00 | short | ask | 196.5400 | 4.1000 | ["120"] | ["0.3336"] | [] | ["ARCO","EMLD","MCRY","XBOX","XMIO","XPHO"] | 120.0000 | 120.0000 | 812 | 847 | false | false | true | ||||||||||
| 01a0d9d0-df5f-7061-9ae3-fef0cce60e36 | XLK | 2026-09-25 14:25 | call_calendar | 2 | 2 | 59 | 1098240.00 | unknown | ask | 196.8400 | 5.6500 | ["120"] | ["0.3256"] | [] | ["EDGO","XISX"] | 120.0000 | 120.0000 | 812 | 847 | false | false | true | false | |||||||||
| 01a0d9d0-df5f-7061-9ae3-fee25ac8f179 | XLK | 2026-09-25 14:25 | call_calendar | 2 | 2 | 14 | 260596.00 | short | ask | 196.8400 | 5.6500 | ["120"] | ["0.3256"] | [] | ["MCRY","XPHO"] | 120.0000 | 120.0000 | 812 | 847 | false | false | true | false | |||||||||
| 01a0d9d0-52bf-7770-b650-a604c0259f8d | XLK | 2026-09-25 14:25 | call_calendar | 2 | 2 | 106 | 1969904.00 | short | ask | 196.8200 | 6.2500 | ["120"] | ["0.3223"] | [] | ["EDGO","XISX"] | 120.0000 | 120.0000 | 812 | 847 | false | false | true | false | |||||||||
| 01a0d9cf-c61f-7283-8aca-a53f0a9b67b1 | XLK | 2026-09-25 14:24 | call_calendar | 2 | 4 | 55 | 1021875.00 | short | ask | 196.8400 | 6.3000 | ["120"] | ["0.3212"] | [] | ["AMXO","ARCO","MCRY","XPHO"] | 120.0000 | 120.0000 | 812 | 847 | false | false | true | false | |||||||||
| 01a0d9a5-d7be-7bf3-b954-f16a523c0e43 | XLK | 2026-09-25 13:38 | call_calendar | 2 | 1 | 9 | 25448.00 | long | ask | 196.6100 | 2.6500 | ["183"] | ["1.7800"] | [] | ["ARCO"] | 183.0000 | 183.0000 | 0 | 21 | false | false | true | false | |||||||||
| 01a0d8c2-6163-7810-86f2-b98defcc4ffb | XLK | 2026-09-25 09:30 | call_calendar | 2 | 1 | 10 | 184020.00 | short | ask | 195.3200 | 2.7000 | ["105"] | ["0.6432"] | [] | ["XISX"] | 105.0000 | 105.0000 | 84 | 112 | false | false | true | false | |||||||||
| 01a0d8c2-6163-7810-86f2-b97a51301bc6 | XLK | 2026-09-25 09:30 | call_calendar | 2 | 1 | 5 | 84685.00 | short | ask | 195.3200 | 3.2000 | ["112.5"] | ["0.5973"] | [] | ["XISX"] | 112.5000 | 112.5000 | 84 | 112 | false | false | true | false | |||||||||
| 01a0d39d-802f-7b71-b715-4dd936f46807 | XLK | 2026-09-24 09:31 | call_calendar | 2 | 1 | 5 | 79675.00 | short | ask | 192.6600 | 3.1500 | ["115"] | ["0.5800"] | [] | ["XISX"] | 115.0000 | 115.0000 | 85 | 113 | false | false | true | false | |||||||||
| 01a0cedb-067e-7763-a76c-110b9668acbd | XLK | 2026-09-23 11:20 | call_calendar | 2 | 1 | 180 | 607680.00 | short | ask | 195.1000 | 2.0500 | ["190"] | ["0.2571"] | [] | ["XCBO"] | 190.0000 | 190.0000 | 114 | 177 | false | false | true | false | |||||||||
| 01a0cedb-067e-7763-a76c-10fd66cdd9fa | XLK | 2026-09-23 11:20 | call_calendar | 2 | 1 | 20 | 68400.00 | short | ask | 195.1000 | 1.8000 | ["190"] | ["0.2620"] | [] | ["XISX"] | 190.0000 | 190.0000 | 114 | 177 | false | false | true | false | |||||||||
| 01a0ce98-11df-74e1-bfcd-6e4e92103270 | XLK | 2026-09-23 10:07 | call_calendar | 2 | 1 | 5 | 82450.00 | short | ask | 195.1400 | 3.9500 | ["115"] | ["0.6293"] | [] | ["XISX"] | 115.0000 | 115.0000 | 86 | 114 | false | false | true | false | |||||||||
| 01a0ce8c-cb27-7851-a66b-509ddbc70fa9 | XLK | 2026-09-23 09:55 | call_calendar | 2 | 1 | 10 | 185030.00 | unknown | ask | 195.3400 | 4.0500 | ["105"] | ["0.7179"] | [] | ["XCBO"] | 105.0000 | 105.0000 | 86 | 114 | false | false | true | false | |||||||||
| 01a0caad-8d57-7053-8195-5eaa86990a07 | XLK | 2026-09-22 15:52 | call_calendar | 2 | 1 | 10 | 185150.00 | short | ask | 196.5000 | 6.1000 | ["105"] | ["0.7733"] | [] | ["C2OX"] | 105.0000 | 105.0000 | 87 | 115 | false | false | true | false | |||||||||
| 01a0c94f-33d8-7193-b0b9-ac2cc2ca9b8d | XLK | 2026-09-22 09:30 | call_calendar | 2 | 1 | 4 | 81280.00 | short | ask | 194.5800 | 4.8000 | ["100"] | ["0.4422"] | [] | ["XPHO"] | 100.0000 | 100.0000 | 115 | 850 | false | false | true | false | |||||||||
| 01a0c585-83a7-7831-8005-91582b1865fa | XLK | 2026-09-21 15:50 | call_calendar | 2 | 3 | 3 | 26501.00 | short | ask | 194.8300 | 6.6500 | ["170"] | ["0.2829"] | [] | ["EDGO","XCBO","XISX"] | 170.0000 | 170.0000 | 452 | 487 | false | false | true | false | |||||||||
| 01a0c585-396f-7201-b137-fb3404b3b6ad | XLK | 2026-09-21 15:50 | call_calendar | 2 | 1 | 10 | 88420.00 | short | ask | 194.7300 | 6.8500 | ["170"] | ["0.2847"] | [] | ["XMIO"] | 170.0000 | 170.0000 | 452 | 487 | false | false | true | false | |||||||||
| 01a0b5c1-2dc8-7fa2-a46b-4b8913147fe0 | XLK | 2026-09-18 14:22 | call_calendar | 2 | 1 | 19 | 167513.00 | short | ask | 188.2750 | 1.1500 | ["145"] | ["0.4190"] | [] | ["XMIO"] | 145.0000 | 145.0000 | 28 | 63 | false | false | true | false | |||||||||
| 01a0b5a6-f6d8-7f70-b6c7-1d35b7ea06fa | XLK | 2026-09-18 13:53 | call_calendar | 2 | 3 | 14 | 260254.00 | short | ask | 188.2650 | 3.1500 | ["96.5"] | ["0.5019"] | [] | ["ARCO","EMLD","SPHR"] | 96.5000 | 96.5000 | 91 | 119 | false | false | true | false | |||||||||
| 01a0b082-77ab-7520-8286-1391bc614955 | XLK | 2026-09-17 13:55 | call_calendar | 2 | 1 | 2 | 35628.00 | short | ask | 188.0401 | 2.5000 | ["100"] | ["3.3181"] | [] | ["XMIO"] | 100.0000 | 100.0000 | 1 | 183 | false | false | true | false | |||||||||
| 01a0a110-1f20-7963-8c58-7310a146f8ac | XLK | 2026-09-14 13:56 | call_calendar | 2 | 1 | 3 | 42072.00 | short | ask | 185.5199 | 3.0000 | ["115"] | ["1.3974"] | [] | ["AMXO"] | 115.0000 | 115.0000 | 4 | 32 | false | false | true | false | |||||||||
| 01a08bac-8538-7551-9be0-add265178eaf | XLK | 2026-09-10 10:15 | call_calendar | 2 | 1 | 22 | 121528.00 | long | ask | 185.1600 | 1.8000 | ["160"] | ["0.4624"] | [] | ["XISX"] | 160.0000 | 160.0000 | 8 | 99 | false | false | true | false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T19:23:10Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T18:27:53Z"} |
| 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-25T18:26:12Z"} |
| 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-25T18:26:12Z"} |
| 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-25T18:25:37Z"} |
| 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-25T18:24:55Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T17:38:59Z"} |
| 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:30:06Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T13:30:06Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T13:31:53Z"} |
| 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-23T15:21:30Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:21:30Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:07:53Z"} |
| 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-23T13:55:39Z"} |
| 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-22T19:52:45Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:30:02Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:50:59Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:50:40Z"} |
| 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-18T18:22:37Z"} |
| 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-18T17:53:52Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:56:03Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:56:30Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:15:59Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |