core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg677,480 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric |
|---|
| 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 |
|---|
| 01a0f868-a10f-79b1-bd48-1a9b6f48c01a | ZS | 2026-10-01 12:59 | other | 3 | 1 | 40 | 179040.00 | unknown | ask | 198.8750 | 4.0500 | ["180","205"] | ["0.8895","0.6330"] | [] | ["XMIO"] | 180.0000 | 205.0000 | 1 | 8 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-10-01T17:00:19Z"} | 2026-10-01 | 2026-10-01 17:15 | 2026-10-01 17:15 |
| 01a0f319-f4bf-7780-bbc4-02b7a7e6ef20 | ZS | 2026-09-30 12:15 | other | 4 | 2 | 100 | 142700.00 | unknown | — | 202.0450 | 1.6200 | ["205","210"] | ["0.6130","0.6145"] | [] | ["XISX"] | 205.0000 | 210.0000 | 2 | 9 | false | true | true | true | false | ||||||||
| 01a0d903-8cdf-74d2-8041-6a07feb6b34c | ZS | 2026-09-25 10:41 | other | 4 | 3 | 160 | 109655.00 | unknown | ask | 195.2650 | 1.3200 | ["175","180","185"] | ["0.5589","0.5576","0.8679"] | [] | ["C2OX","XISX"] | 175.0000 | 185.0000 | 0 | 21 | false | true | |||||||||||
| 01a0d902-2966-70a2-b945-7aff2b9bea97 | ZS | 2026-09-25 10:39 | other | 6 | 3 | 20 | 232430.00 | unknown | — | 195.7850 | 8.0500 | ["180","190","195","197.5","200"] | ["0.6103","0.5627","0.5656","0.5572","0.5599"] | [] | ["XISX","XMIO","XPHO"] | 180.0000 | 200.0000 | 7 | 630 | false | false | true | true | |||||||||
| 01a0d463-a2d7-7e62-a33e-9c6eeb9eafe1 | ZS | 2026-09-24 13:08 | other | 6 | 2 | 5 | 125746.00 | unknown | bid | 215.1850 | 17.0000 | ["190","210","220","240"] | ["0.6128","0.6139","0.6201","0.6086"] | [] | ["C2OX","XMIO"] | 190.0000 | 240.0000 | 176 | 631 | false | false | |||||||||||
| 01a0cf34-26e7-7991-b42c-75f65b63d3f9 | ZS | 2026-09-23 12:58 | other | 3 | 1 | 10 | 174584.00 | unknown | ask | 211.5600 | 7.2500 | ["155","190","290"] | ["0.6073","0.6105","0.5964"] | [] | ["XMIO"] | 155.0000 | 290.0000 | 114 | 485 | false | false | |||||||||||
| 01a0cefd-923e-7052-a5b9-39c5e8662439 | ZS | 2026-09-23 11:58 | other | 3 | 1 | 96 | 343584.00 | unknown | — | 214.0000 | 2.4000 | ["200","220","270"] | ["0.5619","0.5688","0.5864"] | [] | ["C2OX"] | 200.0000 | 270.0000 | 23 | 58 | false | false | true | true | |||||||||
| 01a0cefd-923e-7052-a5b9-39bb8113b1f8 | ZS | 2026-09-23 11:58 | other | 3 | 2 | 204 | 729912.00 | unknown | bid | 214.0000 | 2.4000 | ["200","220","270"] | ["0.5608","0.5694","0.5857"] | [] | ["AMXO","ARCO"] | 200.0000 | 270.0000 | 23 | 58 | false | false | |||||||||||
| 01a0c573-8dff-7970-9f3c-f5ccd4e4c63c | ZS | 2026-09-21 15:31 | other | 3 | 1 | 10 | 103361.00 | unknown | ask | 205.9002 | 4.7000 | ["155","250","260"] | ["0.6011","0.5957","0.5949"] | [] | ["XMIO"] | 155.0000 | 260.0000 | 116 | 487 | false | false | |||||||||||
| 01a0c480-dd17-7be1-9851-36b79ff2e378 | ZS | 2026-09-21 11:06 | other | 4 | 1 | 10 | 151940.00 | unknown | bid | 204.9850 | 10.5500 | ["165","167.5","170"] | ["1.0420","0.8873","0.7000"] | [] | ["XMIO"] | 165.0000 | 170.0000 | 4 | 11 | false | false | |||||||||||
| 01a0c46d-689f-7273-8b2b-98e8ba3d4f12 | ZS | 2026-09-21 10:44 | other | 4 | 6 | 21 | 181538.00 | unknown | bid | 204.7500 | 0.4738 | ["220","230"] | ["0.5754","0.5771"] | ["208.73"] | ["ARCO","EMLD","MCRY","XPHO"] | 220.0000 | 230.0000 | 151 | 151 | false | false | |||||||||||
| 01a0b59c-542f-79b2-bc3b-f82c86d6df47 | ZS | 2026-09-18 13:41 | other | 3 | 2 | 10 | 235920.00 | unknown | bid | 198.2429 | 13.3500 | ["150","280"] | ["0.6055","0.5776"] | [] | ["XMIO"] | 150.0000 | 280.0000 | 637 | 854 | false | false | |||||||||||
| 01a0a5f3-434d-70b1-a622-07630e8b75a1 | ZS | 2026-09-15 12:42 | other | 4 | 1 | 100 | 129600.00 | unknown | — | 194.0500 | 1.5800 | ["205","210"] | ["0.6826","0.6891"] | [] | ["XPHO"] | 205.0000 | 210.0000 | 3 | 17 | false | true | true | true | false | ||||||||
| 01a0a179-77e1-7350-b041-a1e81bfdc3c1 | ZS | 2026-09-14 15:51 | other | 3 | 1 | 10 | 159080.00 | unknown | — | 192.9450 | 10.8500 | ["150","170","240"] | ["0.6154","0.6101","0.5902"] | [] | ["XMIO"] | 150.0000 | 240.0000 | 18 | 641 | false | false | true | true | |||||||||
| 01a0a0c1-4f58-7461-9575-d8e19dc886ac | ZS | 2026-09-14 12:30 | other | 4 | 1 | 40 | 273840.00 | unknown | — | 188.8100 | 4.0000 | ["190","200","210"] | ["0.5556","0.5881","0.6193"] | [] | ["XMIO"] | 190.0000 | 210.0000 | 67 | 95 | false | true | true | true | |||||||||
| 01a0a079-22c8-75c0-b225-0640d7343df5 | ZS | 2026-09-14 11:11 | other | 3 | 3 | 10 | 121915.00 | unknown | — | 188.0900 | 7.5000 | ["105","190"] | ["0.6362","0.5921"] | [] | ["XPHO"] | 105.0000 | 190.0000 | 95 | 276 | false | false | true | true | false | ||||||||
| 01a08c9d-9bf9-79f3-b4da-d8657c9f98e3 | ZS | 2026-09-10 14:38 | other | 7 | 1 | 600 | 10834136.00 | unknown | — | 162.4300 | 18.2500 | ["182.5","185","187.5","190","220","290","320"] | ["1.5693","1.7438","1.9894","2.0467","1.2887","2.1664","0.7526"] | [] | ["XBOX"] | 182.5000 | 320.0000 | 1 | 99 | true | false | true | true |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-30T16:16:28Z"} |
| 2026-09-30 |
| 2026-09-30 17:15 |
| 2026-09-30 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T14:41:25Z"} |
| 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-25T14:39:52Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T17:08:41Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:58:48Z"} |
| 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-23T15:59:20Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:59:20Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:31:41Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:06:31Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:45:13Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:42:21Z"} |
| 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-15T16:43:54Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:51:29Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:30:51Z"} |
| 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-14T15:11:36Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:39:30Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |