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 |
|---|
| 01a0b61a-1780-7960-b9d6-df98fcf17eac | STUB | 2026-09-18 15:59 | put_vertical_spread | 2 | 1 | 100 | 116600.00 | long | ask | 5.9350 | 0.9000 | ["11.5","12"] | ["259.6701","273.1384"] | ["0","11.5"] | ["XCBO"] | 11.5000 | 12.0000 | 0 | 0 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:59:18Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5ff-ffcf-7471-9d80-41c9cc1fbea0 | STUB | 2026-09-18 15:30 | call_vertical_spread | 2 | 1 | 230 | 103500.00 | unknown | — | 5.9550 | 0.4000 | ["3.5","4"] | ["47.0584","37.0522"] | [] | ["XCBO"] | 3.5000 | 4.0000 | 0 | 0 | false | false | false | true | false | ||||||||
| 01a0b5ed-b81f-7aa1-bbcd-77d9fb0e3a02 | STUB | 2026-09-18 15:10 | put_vertical_spread | 2 | 1 | 220 | 252780.00 | long | ask | 5.9750 | 0.5000 | ["11.5","12"] | ["41.9966","43.9726"] | ["11.51"] | ["XISX"] | 11.5000 | 12.0000 | 0 | 0 | true | false | false | ||||||||||
| 01a0b5ed-1fc7-7e30-b88f-63cd078417e2 | STUB | 2026-09-18 15:10 | put_vertical_spread | 2 | 1 | 188 | 216012.00 | long | ask | 5.9750 | 0.5000 | ["11.5","12"] | ["41.7150","43.6778"] | ["11.51"] | ["XISX"] | 11.5000 | 12.0000 | 0 | 0 | true | false | false | ||||||||||
| 01a0b5eb-5aa7-7e62-b169-d858177292d4 | STUB | 2026-09-18 15:08 | call_vertical_spread | 2 | 1 | 250 | 138500.00 | unknown | bid | 5.9550 | 0.7000 | ["3","3.5"] | ["3.3978","2.7401"] | ["6.02"] | ["XCBO"] | 3.0000 | 3.5000 | 7 | 7 | false | false | false | ||||||||||
| 01a0b5e0-69df-7910-8309-21cd32108c47 | STUB | 2026-09-18 14:56 | call_vertical_spread | 2 | 1 | 249 | 113793.00 | long | ask | 5.9850 | 0.3500 | ["3.5","4"] | ["32.0913","26.5932"] | ["3.99"] | ["XISX"] | 3.5000 | 4.0000 | 0 | 0 | true | false | false | ||||||||||
| 01a0b5dd-a2f0-7962-8c0c-34e0a2aff45b | STUB | 2026-09-18 14:53 | call_vertical_spread | 2 | 1 | 249 | 162597.00 | long | ask | 5.9850 | 0.3500 | ["2.5","3"] | ["42.6667","36.9218"] | ["2.99"] | ["XISX"] | 2.5000 | 3.0000 | 0 | 0 | false | false | false | ||||||||||
| 01a0b5dc-6688-7e42-9648-728e587023d7 | STUB | 2026-09-18 14:51 | call_vertical_spread | 2 | 1 | 249 | 162597.00 | long | ask | 5.9850 | 0.3500 | ["2.5","3"] | ["42.2365","36.5495"] | ["2.99"] | ["XISX"] | 2.5000 | 3.0000 | 0 | 0 | true | false | false | ||||||||||
| 01a0b06d-befb-7fd1-b375-7024c6beacc6 | STUB | 2026-09-17 13:32 | put_vertical_spread | 2 | 1 | 250 | 232500.00 | unknown | — | 5.9300 | 0.6000 | ["10","11"] | ["6.7186","7.5804"] | [] | ["XCBO"] | 10.0000 | 11.0000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a0b06c-dc6b-7e80-931e-0236541758fb | STUB | 2026-09-17 13:31 | call_vertical_spread | 2 | 1 | 250 | 160000.00 | unknown | — | 5.9250 | 0.6000 | ["2.5","3"] | ["9.0916","7.3511"] | [] | ["XCBO"] | 2.5000 | 3.0000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a0b068-b5eb-7433-a898-8daa09051106 | STUB | 2026-09-17 13:27 | put_vertical_spread | 2 | 1 | 136 | 126344.00 | long | ask | 5.9250 | 0.8000 | ["10","11"] | ["6.6308","7.2677"] | ["10.01"] | ["XISX"] | 10.0000 | 11.0000 | 1 | 1 | false | false | false | ||||||||||
| 01a0b065-2f93-7623-8fbe-d075cc73636e | STUB | 2026-09-17 13:23 | call_vertical_spread | 2 | 1 | 249 | 159111.00 | unknown | — | 5.8960 | 0.7000 | ["2.5","3"] | ["10.1103","8.5766"] | [] | ["XISX"] | 2.5000 | 3.0000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a0b01e-9d2b-7c63-bb11-ad45bdadc24d | STUB | 2026-09-17 12:06 | put_vertical_spread | 2 | 1 | 310 | 407340.00 | short | bid | 5.8150 | 0.9000 | ["12","12.5"] | ["9.5845","9.9531"] | ["0","12"] | ["XCBO"] | 12.0000 | 12.5000 | 1 | 1 | false | false | false | ||||||||||
| 01a0b01a-72c3-7443-a9d3-a0143324e33d | STUB | 2026-09-17 12:01 | put_vertical_spread | 2 | 1 | 222 | 290154.00 | long | ask | 5.8086 | 0.7000 | ["12","12.5"] | ["8.9388","9.0889"] | ["12.01"] | ["XISX"] | 12.0000 | 12.5000 | 1 | 1 | false | false | false | ||||||||||
| 01a0b019-da6b-7a62-bf56-720ea2a70233 | STUB | 2026-09-17 12:01 | put_vertical_spread | 2 | 1 | 88 | 115016.00 | long | ask | 5.8050 | 0.7000 | ["12","12.5"] | ["8.8741","9.0184"] | ["12.01"] | ["XISX"] | 12.0000 | 12.5000 | 1 | 1 | false | false | false | ||||||||||
| 01a0a680-a69e-7861-81c6-c9a9c02b2247 | STUB | 2026-09-15 15:17 | put_vertical_spread | 2 | 1 | 88 | 122320.00 | short | bid | 5.8888 | 1.0000 | ["12.5","13"] | ["5.1984","5.3935"] | ["0","12.5"] | ["XMIO"] | 12.5000 | 13.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a0a680-5496-7673-bb93-04aa5956b07a | STUB | 2026-09-15 15:17 | put_vertical_spread | 2 | 1 | 88 | 122408.00 | short | bid | 5.8888 | 1.0000 | ["12.5","13"] | ["5.3137","5.3935"] | ["12.51"] | ["XMIO"] | 12.5000 | 13.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a086d2-5d09-7fa0-8e9e-f6bd2ea3efa2 | STUB | 2026-09-09 11:38 | put_vertical_spread | 2 | 1 | 88 | 165440.00 | unknown | — | 6.0950 | 0.4000 | ["15","16"] | ["7.2755","7.6510"] | [] | ["XMIO"] | 15.0000 | 16.0000 | 2 | 2 | false | false | false | true | false | ||||||||
| 01a086d1-e008-7d12-a625-fa33f55292ce | STUB | 2026-09-09 11:38 | put_vertical_spread | 2 | 1 | 88 | 165000.00 | long | ask | 6.0950 | 0.9000 | ["15","16"] | ["8.4928","8.8965"] | ["15.01"] | ["XMIO"] | 15.0000 | 16.0000 | 2 | 2 | true | false | false | ||||||||||
| 01a08684-19e1-74a1-9f50-2f74bcbc0978 | STUB | 2026-09-09 10:13 | put_vertical_spread | 2 | 1 | 177 | 254880.00 | unknown | — | 6.1250 | 0.6000 | ["13","13.5"] | ["6.0883","6.3123"] | [] | ["XCBO"] | 13.0000 | 13.5000 | 2 | 2 | false | false | false | true | false | ||||||||
| 01a08683-b069-7a62-ba77-4381f8baf031 | STUB | 2026-09-09 10:12 | put_vertical_spread | 2 | 1 | 176 | 285120.00 | unknown | — | 6.1250 | 0.6000 | ["14","14.5"] | ["7.2314","7.4463"] | [] | ["XCBO"] | 14.0000 | 14.5000 | 2 | 2 | false | false | false | true | false | ||||||||
| 01a08682-b280-7360-8968-396e9bd0a3b4 | STUB | 2026-09-09 10:11 | put_vertical_spread | 2 | 1 | 88 | 126280.00 | long | ask | 6.1250 | 0.7000 | ["13","13.5"] | ["5.7486","5.7661"] | ["13.01"] | ["XMIO"] | 13.0000 | 13.5000 | 2 | 2 | false | false | false | ||||||||||
| 01a0867f-ad10-7cb2-b8a8-d64f79aa356f | STUB | 2026-09-09 10:08 | put_vertical_spread | 2 | 1 | 88 | 142120.00 | long | ask | 6.0950 | 0.7000 | ["14","14.5"] | ["6.8670","7.0757"] | ["14.01"] | ["XMIO"] | 14.0000 | 14.5000 | 2 | 2 | false | false | false | ||||||||||
| 01a0867e-5938-7b90-adf3-69e03066a313 | STUB | 2026-09-09 10:07 | put_vertical_spread | 2 | 1 | 88 | 126456.00 | long | ask | 6.0800 | 0.7000 | ["13","13.5"] | ["4.9615","4.7588"] | ["13.01"] | ["XCBO"] | 13.0000 | 13.5000 | 2 | 2 | true | false | false | ||||||||||
| 01a0867c-e238-7a10-b08a-339ebf87b323 | STUB | 2026-09-09 10:05 | put_vertical_spread | 2 | 1 | 88 | 142296.00 | long | ask | 6.0900 | 1.1000 | ["14","14.5"] | ["8.0085","8.2329"] | ["14.01"] | ["XCBO"] | 14.0000 | 14.5000 | 2 | 2 | true | false | false | ||||||||||
| 01a06de3-665d-7022-b137-a97c97c0c6f5 | STUB | 2026-09-04 15:26 | put_vertical_spread | 2 | 1 | 188 | 287452.00 | unknown | — | 6.6200 | 1.3000 | ["14","14.5"] | ["44.3298","41.9302"] | [] | ["XISX"] | 14.0000 | 14.5000 | 0 | 0 | false | false | false | true | false | ||||||||
| 01a06dd4-d3e5-7b50-8692-6d0443a927a1 | STUB | 2026-09-04 15:10 | put_vertical_spread | 2 | 1 | 248 | 379192.00 | unknown | — | 6.6250 | 1.3000 | ["14","14.5"] | ["37.6264","36.2958"] | [] | ["XISX"] | 14.0000 | 14.5000 | 0 | 0 | true | false | false | true | false |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:30:55Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:11:00Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:10:30Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:08:27Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:56:32Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:53:16Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:51:54Z"} |
| 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-17T17:32:57Z"} |
| 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-17T17:32:13Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:27:48Z"} |
| 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-17T17:24:06Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:06:56Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:02:05Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:01:25Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:17:45Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:17:45Z"} |
| 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-09T15:38:49Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:38:49Z"} |
| 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-09T14:13:45Z"} |
| 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-09T14:13:12Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:12:08Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:08:29Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:07:10Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:05:41Z"} |
| 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-04T19:27:06Z"} |
| 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-04T19:11:00Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |