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 |
|---|
| 01a0ca0d-78df-7662-91fc-d968f85ce84d | VIX | 2026-09-22 12:57 | straddle | 2 | 1 | 351 | 155844.00 | long | ask | 14.2800 | 0.1700 | ["17"] | ["1.0321"] | ["12.56","21.44"] | ["XCBO"] | 17.0000 | 17.0000 | 85 | 85 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T16:58:31Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0ca0d-616f-74f3-9a49-6ee40a63880f | VIX | 2026-09-22 12:57 | straddle | 2 | 1 | 573 | 254412.00 | long | ask | 14.2800 | 0.1600 | ["17"] | ["1.0321"] | ["12.56","21.44"] | ["XCBO"] | 17.0000 | 17.0000 | 85 | 85 | false | false | false | false | |||||||||
| 01a0ca0d-4617-7f03-a9cc-d4e486e232ac | VIX | 2026-09-22 12:57 | straddle | 2 | 1 | 377 | 167388.00 | long | ask | 14.2800 | 0.1600 | ["17"] | ["1.0321"] | ["12.56","21.44"] | ["XCBO"] | 17.0000 | 17.0000 | 85 | 85 | false | false | false | false | |||||||||
| 01a0ca0d-328f-7cd1-aef5-3c2f884e7baf | VIX | 2026-09-22 12:57 | straddle | 2 | 2 | 573 | 254412.00 | long | ask | 14.2800 | 0.1600 | ["17"] | ["1.0321"] | ["12.56","21.44"] | ["XCBO"] | 17.0000 | 17.0000 | 85 | 85 | false | false | false | false | |||||||||
| 01a0ca0d-0b7e-7a40-9ac8-33802b51a35f | VIX | 2026-09-22 12:57 | straddle | 2 | 1 | 1000 | 444000.00 | long | ask | 14.2800 | 0.1600 | ["17"] | ["1.0321"] | ["12.56","21.44"] | ["XCBO"] | 17.0000 | 17.0000 | 85 | 85 | false | false | false | false | |||||||||
| 01a0ca0c-c52f-7d81-9a05-7cf67229493a | VIX | 2026-09-22 12:57 | straddle | 2 | 2 | 1000 | 443801.00 | long | ask | 14.2800 | 0.1600 | ["17"] | ["1.0320"] | ["12.56","21.44"] | ["XCBO"] | 17.0000 | 17.0000 | 85 | 85 | false | false | false | false | |||||||||
| 01a0ca04-83e7-7730-a81c-9af3952beb17 | VIX | 2026-09-22 12:48 | straddle | 2 | 1 | 4000 | 988000.00 | long | ask | 14.2500 | 0.0800 | ["17"] | ["1.0583"] | ["14.53","19.47"] | ["XCBO"] | 17.0000 | 17.0000 | 29 | 29 | false | false | false | false | |||||||||
| 01a0ca04-83e7-7730-a81c-9ae805029194 | VIX | 2026-09-22 12:48 | straddle | 2 | 1 | 200 | 49400.00 | long | ask | 14.2500 | 0.0800 | ["17"] | ["1.0583"] | ["14.53","19.47"] | ["XCBO"] | 17.0000 | 17.0000 | 29 | 29 | false | false | false | false | |||||||||
| 01a0ca04-83e7-7730-a81c-9ad5220484c6 | VIX | 2026-09-22 12:48 | straddle | 2 | 1 | 1000 | 247000.00 | long | ask | 14.2500 | 0.0800 | ["17"] | ["1.0583"] | ["14.53","19.47"] | ["XCBO"] | 17.0000 | 17.0000 | 29 | 29 | false | false | false | false | |||||||||
| 01a0ca04-83e7-7730-a81c-9acdfbd232db | VIX | 2026-09-22 12:48 | straddle | 2 | 1 | 1000 | 247000.00 | long | ask | 14.2500 | 0.0800 | ["17"] | ["1.0583"] | ["14.53","19.47"] | ["XCBO"] | 17.0000 | 17.0000 | 29 | 29 | false | false | false | false | |||||||||
| 01a0ca04-83e7-7730-a81c-9abad22b7f56 | VIX | 2026-09-22 12:48 | straddle | 2 | 1 | 10000 | 2470000.00 | long | ask | 14.2500 | 0.0800 | ["17"] | ["1.0583"] | ["14.53","19.47"] | ["XCBO"] | 17.0000 | 17.0000 | 29 | 29 | false | false | false | false | |||||||||
| 01a0ca04-83e7-7730-a81c-9aabc72f1327 | VIX | 2026-09-22 12:48 | straddle | 2 | 3 | 3500 | 864500.00 | long | ask | 14.2500 | 0.0800 | ["17"] | ["1.0583"] | ["14.53","19.47"] | ["XCBO"] | 17.0000 | 17.0000 | 29 | 29 | false | false | false | false | |||||||||
| 01a0ca04-494f-7c62-95d9-c7990ddde723 | VIX | 2026-09-22 12:47 | straddle | 2 | 1 | 300 | 74100.00 | long | ask | 14.2500 | 0.0600 | ["17"] | ["1.0583"] | ["14.53","19.47"] | ["XCBO"] | 17.0000 | 17.0000 | 29 | 29 | false | false | false | false | |||||||||
| 01a0c950-04df-7132-9fe7-20660630fa39 | VIX | 2026-09-22 09:30 | straddle | 2 | 1 | 150 | 53550.00 | long | ask | 14.6700 | 0.1700 | ["19"] | ["1.1680"] | ["15.43","22.57"] | ["XCBO"] | 19.0000 | 19.0000 | 29 | 29 | false | false | false | false | |||||||||
| 01a0aba9-41ab-7f73-bbf8-6add2dadc368 | VIX | 2026-09-16 15:19 | straddle | 2 | 1 | 161 | 72450.00 | long | ask | 18.5500 | 0.1000 | ["20"] | ["0.9214"] | ["15.50","24.50"] | ["XCBO"] | 20.0000 | 20.0000 | 35 | 35 | false | false | false | false | |||||||||
| 01a0aba9-41ab-7f73-bbf8-6ac874e62843 | VIX | 2026-09-16 15:19 | straddle | 2 | 1 | 739 | 332550.00 | long | ask | 18.5500 | 0.1000 | ["20"] | ["0.9214"] | ["15.50","24.50"] | ["XCBO"] | 20.0000 | 20.0000 | 35 | 35 | false | false | false | false | |||||||||
| 01a0aba4-09bb-7ed2-b1c9-e6350fd55047 | VIX | 2026-09-16 15:14 | straddle | 2 | 1 | 774 | 345978.00 | long | ask | 18.3200 | 0.1200 | ["20"] | ["0.9089"] | ["15.53","24.47"] | ["XCBO"] | 20.0000 | 20.0000 | 35 | 35 | false | false | false | false | |||||||||
| 01a0ab3b-e1ab-7431-a0bc-93ba24c764e3 | VIX | 2026-09-16 13:20 | straddle | 2 | 2 | 117 | 56277.00 | long | ask | 16.8400 | 0.1200 | ["19"] | ["0.7550"] | ["14.19","23.81"] | ["XCBO"] | 19.0000 | 19.0000 | 63 | 63 | false | false | false | false | |||||||||
| 01a0ab3b-e1ab-7431-a0bc-93a6d91ddf65 | VIX | 2026-09-16 13:20 | straddle | 2 | 2 | 180 | 86580.00 | long | ask | 16.8400 | 0.1200 | ["19"] | ["0.7550"] | ["14.19","23.81"] | ["XCBO"] | 19.0000 | 19.0000 | 63 | 63 | false | false | false | false | |||||||||
| 01a0ab33-5dfb-7b60-af44-409b3f940856 | VIX | 2026-09-16 13:11 | straddle | 2 | 1 | 90 | 43200.00 | long | ask | 16.8700 | 0.1200 | ["19"] | ["0.7554"] | ["14.20","23.80"] | ["XCBO"] | 19.0000 | 19.0000 | 63 | 63 | false | false | false | false | |||||||||
| 01a0ab33-562b-7773-9110-089a0b1afd17 | VIX | 2026-09-16 13:11 | straddle | 2 | 1 | 90 | 43200.00 | long | ask | 16.8700 | 0.1200 | ["19"] | ["0.7554"] | ["14.20","23.80"] | ["XCBO"] | 19.0000 | 19.0000 | 63 | 63 | false | false | false | false | |||||||||
| 01a0ab33-080b-79c1-830c-755ef664be8e | VIX | 2026-09-16 13:10 | straddle | 2 | 2 | 180 | 86400.00 | long | ask | 16.8700 | 0.1200 | ["19"] | ["0.7554"] | ["14.20","23.80"] | ["XCBO"] | 19.0000 | 19.0000 | 63 | 63 | false | false | false | false | |||||||||
| 01a0ab32-8b0b-7962-9603-7b3593dde63b | VIX | 2026-09-16 13:10 | straddle | 2 | 1 | 90 | 43200.00 | long | ask | 16.8700 | 0.1200 | ["19"] | ["0.7554"] | ["14.20","23.80"] | ["XCBO"] | 19.0000 | 19.0000 | 63 | 63 | false | false | false | false | |||||||||
| 01a0a556-d086-7fa0-bba9-0906e95a1f8d | VIX | 2026-09-15 09:52 | straddle | 2 | 1 | 150 | 79500.00 | long | ask | 17.0700 | 0.1400 | ["20"] | ["0.7630"] | ["14.70","25.30"] | ["XCBO"] | 20.0000 | 20.0000 | 64 | 64 | false | false | false | false | |||||||||
| 01a0a152-5840-7e01-9b28-03854049e770 | VIX | 2026-09-14 15:08 | straddle | 2 | 1 | 200 | 174400.00 | long | ask | 16.8700 | 0.1400 | ["25"] | ["1.1194"] | ["16.28","33.72"] | ["XCBO"] | 25.0000 | 25.0000 | 65 | 65 | false | false | false | false | |||||||||
| 01a091f7-b228-7443-8d18-5fcfab9d8d4f | VIX | 2026-09-11 15:35 | straddle | 2 | 1 | 900 | 411300.00 | long | ask | 15.9200 | 0.1500 | ["20"] | ["1.0839"] | ["15.43","24.57"] | ["XCBO"] | 20.0000 | 20.0000 | 40 | 40 | false | false | false | false | |||||||||
| 01a08cb2-1df8-7072-805d-85322fa0047d | VIX | 2026-09-10 15:01 | straddle | 2 | 1 | 1000 | 245000.00 | long | ask | 17.9100 | 0.0900 | ["19"] | ["1.2143"] | ["16.55","21.45"] | ["XCBO"] | 19.0000 | 19.0000 | 6 | 6 | false | false | false | false | |||||||||
| 01a08c3c-9bf0-7832-a3cb-76117c816b00 | VIX | 2026-09-10 12:52 | straddle | 2 | 1 | 250 | 48500.00 | long | ask | 17.3500 | 0.1000 | ["18"] | ["1.0332"] | ["16.06","19.94"] | ["XCBO"] | 18.0000 | 18.0000 | 6 | 6 | false | false | false | false | |||||||||
| 01a08b89-d650-7ad1-a104-b374ce0cf126 | VIX | 2026-09-10 09:37 | straddle | 2 | 1 | 250 | 48500.00 | long | ask | 17.7200 | 0.0800 | ["18"] | ["1.0564"] | ["16.06","19.94"] | ["XCBO"] | 18.0000 | 18.0000 | 6 | 6 | false | false | false | false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:58:31Z"} |
| 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-22T16:57:47Z"} |
| 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-22T16:57:47Z"} |
| 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-22T16:57:47Z"} |
| 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-22T16:57:47Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:48:29Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mfsl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:48:29Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:48:29Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:48:29Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:48:29Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:48:29Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mfsl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:48:29Z"} |
| 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:31:03Z"} |
| 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-16T19:19:50Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:19:50Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:14:11Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:21:03Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:21:03Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:11:10Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:11:10Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:11:10Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:11:10Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T13:52:07Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:08:57Z"} |
| 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-11T19:35:36Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:01:41Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T16:53:28Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T13:37:44Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |