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 |
|---|
| 01a08c48-a9e0-7312-96b1-25c319894b60 | PCG | 2026-09-10 13:06 | call_vertical_spread | 2 | 1 | 1000 | 203000.00 | long | ask | 14.2950 | 0.2800 | ["15","20"] | ["0.6086","0.6291"] | ["16.11"] | ["XISX"] | 15.0000 | 20.0000 | 99 | 99 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:06:28Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c48-a210-7561-84ca-54c33b5e8ec3 | PCG | 2026-09-10 13:06 | call_vertical_spread | 2 | 1 | 1000 | 203999.00 | long | ask | 14.2950 | 0.2800 | ["15","20"] | ["0.6086","0.6338"] | ["16.10"] | ["XISX"] | 15.0000 | 20.0000 | 99 | 99 | false | true | false | ||||||||||
| 01a08c48-9a40-7251-a808-087ce82b158c | PCG | 2026-09-10 13:06 | call_vertical_spread | 2 | 1 | 1000 | 203000.00 | long | ask | 14.2950 | 0.2800 | ["15","20"] | ["0.6052","0.6338"] | ["16.09"] | ["XISX"] | 15.0000 | 20.0000 | 99 | 99 | false | true | false | ||||||||||
| 01a08c48-8e88-7573-b1a4-06ae4b4dfc83 | PCG | 2026-09-10 13:05 | call_vertical_spread | 2 | 1 | 1000 | 203000.00 | long | ask | 14.2950 | 0.2800 | ["15","20"] | ["0.6052","0.6338"] | ["16.09"] | ["XISX"] | 15.0000 | 20.0000 | 99 | 99 | false | true | false | ||||||||||
| 01a08c48-6778-7ec1-a802-dc8c5e0a363b | PCG | 2026-09-10 13:05 | call_vertical_spread | 2 | 1 | 1000 | 204998.00 | long | ask | 14.3001 | 0.2700 | ["15","20"] | ["0.6077","0.6380"] | ["16.09"] | ["XISX"] | 15.0000 | 20.0000 | 99 | 99 | false | true | false | ||||||||||
| 01a08c03-c910-72a2-a2f8-ed4a96b596d8 | PCG | 2026-09-10 11:50 | call_vertical_spread | 2 | 1 | 1000 | 211000.00 | long | ask | 14.2350 | 0.3800 | ["15","20"] | ["0.6291","0.6584"] | ["16.09"] | ["XISX"] | 15.0000 | 20.0000 | 99 | 99 | false | true | false | ||||||||||
| 01a08c03-b589-7932-a9f2-379ac2de0c07 | PCG | 2026-09-10 11:50 | call_vertical_spread | 2 | 1 | 1000 | 210001.00 | unknown | — | 14.2300 | 0.3400 | ["15","20"] | ["0.6266","0.6589"] | [] | ["XISX"] | 15.0000 | 20.0000 | 99 | 99 | false | true | false | true | false | ||||||||
| 01a08c03-a9d0-7902-83a7-d7f628b335f2 | PCG | 2026-09-10 11:50 | call_vertical_spread | 2 | 1 | 1000 | 210001.00 | unknown | — | 14.2300 | 0.3400 | ["15","20"] | ["0.6266","0.6589"] | [] | ["XISX"] | 15.0000 | 20.0000 | 99 | 99 | false | true | false | true | false | ||||||||
| 01a08c03-9a30-7591-8ba6-f0c073cade83 | PCG | 2026-09-10 11:50 | call_vertical_spread | 2 | 1 | 1000 | 209000.00 | unknown | — | 14.2100 | 0.3300 | ["15","20"] | ["0.6267","0.6608"] | [] | ["XISX"] | 15.0000 | 20.0000 | 99 | 99 | false | true | false | true | false | ||||||||
| 01a08c03-8a90-79e3-8916-2ba3f80104d5 | PCG | 2026-09-10 11:50 | call_vertical_spread | 2 | 1 | 1000 | 211000.00 | unknown | — | 14.2100 | 0.3400 | ["15","20"] | ["0.6301","0.6655"] | [] | ["XISX"] | 15.0000 | 20.0000 | 99 | 99 | false | true | false | true | false | ||||||||
| 01a08c03-30b8-7092-ad76-72e2b85bb0d9 | PCG | 2026-09-10 11:50 | call_vertical_spread | 2 | 1 | 1000 | 211000.00 | unknown | — | 14.2040 | 0.3400 | ["15","20"] | ["0.6311","0.6661"] | [] | ["XISX"] | 15.0000 | 20.0000 | 99 | 99 | false | true | false | true | false | ||||||||
| 01a08c03-1d30-73e0-9120-c300db312b27 | PCG | 2026-09-10 11:50 | call_vertical_spread | 2 | 1 | 1000 | 210001.00 | unknown | — | 14.2040 | 0.3400 | ["15","20"] | ["0.6278","0.6661"] | [] | ["XISX"] | 15.0000 | 20.0000 | 99 | 99 | false | true | false | true | false | ||||||||
| 01a08c02-e298-7f22-9246-f7c733db9353 | PCG | 2026-09-10 11:49 | call_vertical_spread | 2 | 1 | 1000 | 209002.00 | unknown | — | 14.1950 | 0.3400 | ["15","20"] | ["0.6259","0.6670"] | [] | ["XISX"] | 15.0000 | 20.0000 | 99 | 99 | false | true | false | true | false | ||||||||
| 01a08c02-cb28-7890-9e25-51adda151341 | PCG | 2026-09-10 11:49 | call_vertical_spread | 2 | 1 | 1000 | 205000.00 | long | ask | 14.1950 | 0.3400 | ["15","20"] | ["0.6191","0.6577"] | ["16.05"] | ["XISX"] | 15.0000 | 20.0000 | 99 | 99 | false | true | false | ||||||||||
| 01a08c02-bb89-7583-9b2e-568ec16a6237 | PCG | 2026-09-10 11:49 | call_vertical_spread | 2 | 1 | 1000 | 209002.00 | unknown | — | 14.1950 | 0.3400 | ["15","20"] | ["0.6259","0.6670"] | [] | ["XISX"] | 15.0000 | 20.0000 | 99 | 99 | false | true | false | true | false | ||||||||
| 01a08bf4-ffe8-7ae0-a27a-80650b4411b8 | PCG | 2026-09-10 11:34 | other | 4 | 1 | 634 | 105561.00 | unknown | — | 14.1688 | 0.4400 | ["14","15","20"] | ["0.4977","0.6202","0.6485"] | [] | ["XMIO"] | 14.0000 | 20.0000 | 8 | 99 | false | false | true | true | true | mlat | |||||||
| 01a08bab-c9b8-78b1-be65-7bf855f22260 | PCG | 2026-09-10 10:14 | call_ratio_spread | 2 | 1 | 2000 | 261000.00 | long | ask | 14.2650 | 0.2400 | ["15","20"] | ["0.6340","0.6461"] | ["15.65","24.35"] | ["XISX"] | 15.0000 | 20.0000 | 99 | 99 | false | true | false | ||||||||||
| 01a08bab-aa79-7e91-8778-25f3d1f52e6a | PCG | 2026-09-10 10:14 | call_ratio_spread | 2 | 1 | 2000 | 260000.00 | long | ask | 14.2650 | 0.2400 | ["15","20"] | ["0.6307","0.6461"] | ["15.64","24.36"] | ["XISX"] | 15.0000 | 20.0000 | 99 | 99 | false | true | false | ||||||||||
| 01a08bab-9ec0-7361-8afc-4ca893f90f86 | PCG | 2026-09-10 10:14 | call_ratio_spread | 2 | 1 | 2000 | 265995.00 | long | ask | 14.2650 | 0.2400 | ["15","20"] | ["0.6307","0.6600"] | ["15.58","24.42"] | ["XISX"] | 15.0000 | 20.0000 | 99 | 99 | false | true | false | ||||||||||
| 01a08bab-7f80-7af0-84e4-ac75a08feca8 | PCG | 2026-09-10 10:14 | call_ratio_spread | 2 | 1 | 2000 | 264996.00 | long | ask | 14.2619 | 0.2400 | ["15","20"] | ["0.6278","0.6603"] | ["15.57","24.43"] | ["XISX"] | 15.0000 | 20.0000 | 99 | 99 | false | true | false | ||||||||||
| 01a08bab-5488-7a32-81c5-2e941b6521fc | PCG | 2026-09-10 10:14 | call_ratio_spread | 2 | 1 | 2000 | 263997.00 | long | ask | 14.2790 | 0.2400 | ["15","20"] | ["0.6215","0.6586"] | ["15.56","24.44"] | ["XISX"] | 15.0000 | 20.0000 | 99 | 99 | false | true | false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:06:28Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:06:28Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:06:28Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:06:28Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:51:34Z"} |
| 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-10T15:50:48Z"} |
| 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-10T15:50:48Z"} |
| 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-10T15:50:48Z"} |
| 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-10T15:50:48Z"} |
| 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-10T15:50:48Z"} |
| 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-10T15:50:48Z"} |
| 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-10T15:49:58Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:49:58Z"} |
| 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-10T15:49:58Z"} |
| 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-10T15:35:13Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:15:03Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:14:38Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:14:38Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:14:38Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:14:38Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |