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 |
|---|
| 01a0c57e-f00e-7c93-8951-f299fe2a7883 | VIX | 2026-09-21 15:43 | call_ratio_spread | 2 | 2 | 900 | 91080.00 | long | ask | 14.8500 | 0.0700 | ["25","60"] | ["1.5065","1.9016"] | ["25.75","111.37"] | ["XCBO"] | 25.0000 | 60.0000 | 58 | 58 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:44:08Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 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 | ||||||||||
| 01a0b09a-ba9b-7833-a7a1-5ab6d784ef75 | VIX | 2026-09-17 14:22 | call_ratio_spread | 2 | 2 | 1300 | 128830.00 | long | ask | 15.5400 | 0.0900 | ["18.5","40"] | ["1.2864","1.6354"] | ["44.66"] | ["XCBO"] | 18.5000 | 40.0000 | 62 | 62 | 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 | ||||||||
| 01a0abcf-674b-7b40-a34d-2e29da0a9ed1 | VIX | 2026-09-16 16:01 | call_ratio_spread | 2 | 1 | 5000 | 293300.00 | long | ask | 17.5800 | 0.0900 | ["18.5","50"] | ["1.0752","1.8871"] | ["19.01","56.35"] | ["XCBO"] | 18.5000 | 50.0000 | 35 | 35 | false | true | false | ||||||||||
| 01a0ab28-07a3-78d0-80e6-7a0e388efd9c | VIX | 2026-09-16 12:58 | call_ratio_spread | 2 | 2 | 3500 | 740600.00 | long | ask | 16.7800 | 0.1100 | ["24","27"] | ["1.2470","1.3069"] | ["32.26"] | ["XCBO"] | 24.0000 | 27.0000 | 63 | 63 | false | true | false | ||||||||||
| 01a0ab17-bfab-7c91-bf8f-26de86ebdcc0 | VIX | 2026-09-16 12:40 | call_ratio_spread | 2 | 1 | 10000 | 930000.00 | long | ask | 16.7900 | 0.0700 | ["24","27"] | ["1.3695","1.4692"] | ["28.44"] | ["XCBO"] | 24.0000 | 27.0000 | 35 | 35 | 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 | ||||||||
| 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 | ||||||||
| 01a0a5c3-1f16-7e91-8d2b-986fc8416272 | VIX | 2026-09-15 11:50 | call_ratio_spread | 2 | 1 | 3000 | 424080.00 | long | ask | 17.6200 | 0.1100 | ["19","42.5"] | ["1.0126","1.5002"] | ["19.54","53.30"] | ["XCBO"] | 19.0000 | 42.5000 | 64 | 64 | 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 | ||||||||
| 01a0a070-2600-7ad3-b86d-32182b87c1cf | VIX | 2026-09-14 11:01 | call_ratio_spread | 2 | 1 | 5500 | 260100.00 | long | ask | 17.5500 | 0.0800 | ["25","65"] | ["1.3182","2.0333"] | ["25.43","82.70"] | ["XCBO"] | 25.0000 | 65.0000 | 37 | 37 | false | true | false | ||||||||||
| 01a090bc-e838-7233-bb94-8eaea6094c60 | VIX | 2026-09-11 09:51 | call_ratio_spread | 2 | 2 | 20000 | 1863400.00 | long | ask | 16.1500 | 0.1100 | ["21","29"] | ["1.3515","1.5788"] | ["30.88"] | ["XCBO"] | 21.0000 | 29.0000 | 40 | 40 | false | true | false | ||||||||||
| 01a08c63-88c8-7da0-9ff1-fbb8d580f481 | VIX | 2026-09-10 13:35 | call_ratio_spread | 2 | 2 | 3750 | 729000.00 | long | ask | 17.4300 | 0.1000 | ["22","25"] | ["1.2270","1.3192"] | ["30.04"] | ["XCBO"] | 22.0000 | 25.0000 | 41 | 41 | false | true | false | ||||||||||
| 01a08c51-9708-7091-a6c2-22379c4d85a6 | VIX | 2026-09-10 13:15 | call_ratio_spread | 2 | 3 | 1300 | 340860.00 | long | ask | 17.2800 | 0.1100 | ["19","22"] | ["1.1490","1.2381"] | ["27.00"] | ["XCBO"] | 19.0000 | 22.0000 | 41 | 41 | false | true | false | ||||||||||
| 01a086fe-9558-7531-992f-26edd6066477 | VIX | 2026-09-09 12:27 | call_ratio_spread | 2 | 2 | 2127 | 352763.00 | long | ask | 16.5200 | 0.0900 | ["22","27"] | ["1.3108","1.4480"] | ["34.67"] | ["XCBO"] | 22.0000 | 27.0000 | 42 | 42 | false | true | false | ||||||||||
| 01a08161-8e70-75a3-a25a-899fc06e04bd | VIX | 2026-09-08 10:17 | call_ratio_spread | 2 | 2 | 19800 | 447200.00 | long | ask | 15.6400 | 0.0500 | ["20","25"] | ["1.6244","1.9970"] | ["26.76"] | ["XCBO"] | 20.0000 | 25.0000 | 8 | 8 | false | true | false | ||||||||||
| 01a06de1-149e-7293-a187-6dd527a81ce0 | VIX | 2026-09-04 15:24 | call_ratio_spread | 2 | 2 | 6500 | 731500.00 | long | ask | 14.3200 | 0.0600 | ["25","60"] | ["1.4703","1.7853"] | ["25.77","102.49"] | ["XCBO"] | 25.0000 | 60.0000 | 75 | 75 | false | true | false | ||||||||||
| 01a06d97-6555-7620-b2a0-0415a7a44157 | VIX | 2026-09-04 14:03 | call_ratio_spread | 2 | 2 | 2500 | 245000.00 | long | ask | 14.2100 | 0.0900 | ["22","45"] | ["1.5216","1.8708"] | ["22.67","78.50"] | ["XCBO"] | 22.0000 | 45.0000 | 47 | 47 | false | true | false | ||||||||||
| 01a06d24-8716-7e52-97c3-fcc4a7da2b70 | VIX | 2026-09-04 11:58 | call_ratio_spread | 2 | 2 | 2000 | 91200.00 | long | ask | 14.0900 | 0.0600 | ["17","24"] | ["1.3806","1.8573"] | ["17.26","34.11"] | ["XCBO"] | 17.0000 | 24.0000 | 12 | 12 | false | true | false |
| 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 |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:22:16Z"} |
| 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 |
| false |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T20:01:40Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:59:37Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:41:30Z"} |
| 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-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 |
| false |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:50:43Z"} |
| 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 |
| false |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:01:58Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T13:51:46Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:35:32Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:16:43Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:27:33Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:17:38Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:24:53Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:04:12Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mfsl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T15:58:25Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |