core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg473,794 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 |
|---|
| 01a0d4de-743f-70c1-a5ce-57bc9877bc0a | VIX | 2026-09-24 15:22 | call_ratio_spread | 2 | 1 | 1200 | 164400.00 | unknown | — | 15.5800 | 0.1400 | ["27","55"] | ["1.3255","1.6115"] | [] | ["XCBO"] | 27.0000 | 55.0000 | 83 | 83 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T19:23:00Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0d428-eb96-7290-9c58-a4e6cad488cc | VIX | 2026-09-24 12:04 | call_ratio_spread | 2 | 1 | 2000 | 224800.00 | unknown | ask | 16.1100 | 0.0900 | ["18","60"] | ["1.3114","2.2350"] | ["19.76"] | ["XCBO"] | 18.0000 | 60.0000 | 27 | 27 | false | true | false | ||||||||||
| 01a0d412-65f7-73a3-b036-64efe6019919 | VIX | 2026-09-24 11:39 | call_ratio_spread | 2 | 1 | 1000 | 174000.00 | unknown | bid | 16.2800 | 0.1200 | ["20","35"] | ["1.2623","1.5901"] | ["23.48"] | ["XCBO"] | 20.0000 | 35.0000 | 55 | 55 | false | true | false | ||||||||||
| 01a0d401-6a4f-7f21-a47a-a07c514f101a | VIX | 2026-09-24 11:20 | call_ratio_spread | 2 | 1 | 2000 | 144400.00 | unknown | — | 16.1600 | 0.1000 | ["18","34"] | ["1.2696","1.8389"] | [] | ["XCBO"] | 18.0000 | 34.0000 | 27 | 27 | false | true | false | true | false | ||||||||
| 01a0d3fb-8e4f-7fd2-82e3-2c2e2e705e84 | VIX | 2026-09-24 11:14 | call_ratio_spread | 2 | 2 | 6575 | 769275.00 | unknown | bid | 16.2000 | 0.0800 | ["20","30"] | ["1.3709","1.7205"] | ["21.95"] | ["XCBO"] | 20.0000 | 30.0000 | 27 | 27 | false | true | false | ||||||||||
| 01a0d3ef-e5ef-7cc2-a57a-87aede0408fd | VIX | 2026-09-24 11:01 | call_ratio_spread | 2 | 2 | 378 | 82215.00 | unknown | — | 15.9900 | 0.1100 | ["17.5","19"] | ["1.2900","1.3560"] | [] | ["XCBO"] | 17.5000 | 19.0000 | 27 | 27 | false | true | false | true | false | ||||||||
| 01a0cea1-1677-7c80-9baf-e99fe7aa404e | VIX | 2026-09-23 10:17 | call_ratio_spread | 2 | 1 | 200 | 25400.00 | unknown | bid | 14.6100 | 0.1200 | ["22","40"] | ["1.4813","1.7758"] | ["24.54"] | ["XCBO"] | 22.0000 | 40.0000 | 56 | 56 | false | true | false | ||||||||||
| 01a0ce9e-e7df-7cc3-9d28-76b8045de26b | VIX | 2026-09-23 10:15 | call_ratio_spread | 2 | 1 | 200 | 42700.00 | unknown | ask | 14.6700 | 0.0800 | ["20","35"] | ["1.4549","1.7178"] | ["22.14"] | ["XCBO"] | 20.0000 | 35.0000 | 56 | 56 | false | true | false | ||||||||||
| 01a0c550-853f-7643-854a-8a9cb8337758 | VIX | 2026-09-21 14:53 | call_ratio_spread | 2 | 1 | 700 | 68068.00 | unknown | — | 15.0200 | 0.0900 | ["18","25"] | ["1.4602","1.6133"] | [] | ["XCBO"] | 18.0000 | 25.0000 | 30 | 30 | false | true | false | true | false | ||||||||
| 01a0c49f-1f2f-7543-8eb5-47217c07e544 | VIX | 2026-09-21 11:39 | call_ratio_spread | 2 | 1 | 20000 | 2110000.00 | unknown | ask | 14.8500 | 0.0700 | ["21","30"] | ["1.5334","1.7908"] | ["22.06"] | ["XCBO"] | 21.0000 | 30.0000 | 30 | 30 | false | true | false | ||||||||||
| 01a0b533-803f-7a32-b341-7c97a58009e4 | VIX | 2026-09-18 11:47 | call_ratio_spread | 2 | 1 | 678 | 36126.00 | unknown | ask | 15.3800 | 0.0500 | ["37","50"] | ["1.8867","2.1019"] | ["37.53"] | ["XCBO"] | 37.0000 | 50.0000 | 33 | 33 | false | true | false | ||||||||||
| 01a0b0d3-b0a3-7901-95d4-5be1117f6ee1 | VIX | 2026-09-17 15:24 | call_ratio_spread | 2 | 1 | 170 | 61420.00 | unknown | — | 15.5000 | 0.1500 | ["15","16"] | ["1.5134","1.3490"] | [] | ["XCBO"] | 15.0000 | 16.0000 | 34 | 34 | false | false | false | true | false | ||||||||
| 01a0b04b-c3c3-7af3-873b-a2f366e7a345 | VIX | 2026-09-17 12:55 | call_ratio_spread | 2 | 1 | 6000 | 420150.00 | unknown | — | 15.6300 | 0.0800 | ["18","26"] | ["1.2829","1.5325"] | [] | ["XCBO"] | 18.0000 | 26.0000 | 34 | 34 | false | true | false | true | false | ||||||||
| 01a0b008-272b-7232-b71a-35a0725ce241 | VIX | 2026-09-17 11:41 | call_ratio_spread | 2 | 1 | 4000 | 568000.00 | unknown | — | 15.6900 | 0.0700 | ["22","25"] | ["1.4002","1.5152"] | [] | ["XCBO"] | 22.0000 | 25.0000 | 34 | 34 | false | true | false | true | false | ||||||||
| 01a0abc3-2e63-7521-a307-9f3917e273e1 | VIX | 2026-09-16 15:48 | call_ratio_spread | 2 | 1 | 6000 | 296008.00 | unknown | — | 17.7900 | 0.1300 | ["20","26"] | ["1.2285","1.8783"] | [] | ["XCBO"] | 20.0000 | 26.0000 | 7 | 7 | false | true | false | true | false | ||||||||
| 01a0aad2-8cd3-7ed0-8528-53363cb71dbf | VIX | 2026-09-16 11:25 | call_ratio_spread | 2 | 1 | 10000 | 617500.00 | unknown | — | 16.7100 | 0.0800 | ["19","50"] | ["1.1369","1.6870"] | [] | ["XCBO"] | 19.0000 | 50.0000 | 63 | 63 | false | true | false | true | false | ||||||||
| 01a0aac0-d1c3-7132-a619-708d6f358277 | VIX | 2026-09-16 11:05 | call_ratio_spread | 2 | 1 | 1578 | 165690.00 | unknown | — | 16.7000 | 0.0900 | ["23","34"] | ["1.3570","1.7110"] | [] | ["XCBO"] | 23.0000 | 34.0000 | 35 | 35 | false | true | false | true | false | ||||||||
| 01a0aac0-aab3-7621-a872-bdaf4bc4075e | VIX | 2026-09-16 11:05 | call_ratio_spread | 2 | 1 | 422 | 44310.00 | unknown | — | 16.7000 | 0.0900 | ["23","34"] | ["1.3570","1.7110"] | [] | ["XCBO"] | 23.0000 | 34.0000 | 35 | 35 | false | true | false | true | false | ||||||||
| 01a0a69f-59fe-79b1-900a-cbf3259cac3f | VIX | 2026-09-15 15:50 | call_ratio_spread | 2 | 1 | 2000 | 168320.00 | unknown | — | 17.4800 | 0.1100 | ["18.5","40"] | ["1.0190","1.7358"] | [] | ["XCBO"] | 18.5000 | 40.0000 | 36 | 36 | false | true | false | true | false | ||||||||
| 01a0a652-6aae-7452-ac62-2d1ec85ab97c | VIX | 2026-09-15 14:26 | call_ratio_spread | 2 | 1 | 800 | 127600.00 | unknown | — | 17.4800 | 0.1000 | ["22","40"] | ["1.0958","1.4897"] | [] | ["XCBO"] | 22.0000 | 40.0000 | 64 | 64 | false | true | false | true | false | ||||||||
| 01a0a57b-38d6-7741-b7d8-45604786d4f3 | VIX | 2026-09-15 10:31 | call_ratio_spread | 2 | 1 | 2000 | 83000.00 | unknown | — | 17.4800 | 0.0700 | ["40","55"] | ["1.7259","1.9484"] | [] | ["XCBO"] | 40.0000 | 55.0000 | 36 | 36 | false | true | false | true | false | ||||||||
| 01a0a56c-ecad-72c2-acd3-2e63f7cc1e42 | VIX | 2026-09-15 10:16 | call_ratio_spread | 2 | 1 | 1000 | 261000.00 | unknown | — | 17.4200 | 0.0900 | ["20","35"] | ["1.0620","1.3987"] | [] | ["XCBO"] | 20.0000 | 35.0000 | 64 | 64 | false | true | false | true | false | ||||||||
| 01a0a156-5f80-75c2-8810-dc494772eb07 | VIX | 2026-09-14 15:13 | call_ratio_spread | 2 | 1 | 2000 | 135640.00 | unknown | — | 16.8300 | 0.0900 | ["18.5","47.5"] | ["1.1368","1.8807"] | [] | ["XCBO"] | 18.5000 | 47.5000 | 37 | 37 | false | true | false | true | false | ||||||||
| 01a0813d-7c10-7801-9bb7-cb16015bf34d | VIX | 2026-09-08 09:38 | call_ratio_spread | 2 | 1 | 500 | 63250.00 | unknown | — | 15.4800 | 0.0900 | ["30","40"] | ["1.4640","1.6069"] | [] | ["XCBO"] | 30.0000 | 40.0000 | 71 | 71 | false | true | false | true | false |
| false |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:04:34Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:39:58Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:21:13Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:14:41Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:02:13Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:17:45Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mfsl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:15:29Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:53:02Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:39:20Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:47:27Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:24:34Z"} |
| 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-17T16:55:59Z"} |
| 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-17T15:41: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-16T19:48:27Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:25:46Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:06:40Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:05:53Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:51:26Z"} |
| 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-15T18:27:51Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:32:18Z"} |
| 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-15T14:16:14Z"} |
| 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-14T19:13:20Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:38:07Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |