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 | directiontext |
|---|
| 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 |
|---|
| 01a0cab7-459e-7d51-b6bc-451535f9f312 | VIX | 2026-09-22 16:03 | ratio_risk_reversal | 2 | 1 | 15000 | 2779350.00 | short | ask | 14.2700 | 0.1200 | ["17.5","20"] | ["0.7097","1.5150"] | ["17.37"] | ["XCBO"] | 17.5000 | 20.0000 | 29 | 29 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T20:04:14Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0caae-6817-7ae2-8bb6-824a5a45ec20 | VIX | 2026-09-22 15:53 | ratio_risk_reversal | 2 | 1 | 500 | 138000.00 | short | bid | 14.2600 | 0.2300 | ["17","18"] | ["0.6279","1.3928"] | ["16.90"] | ["XCBO"] | 17.0000 | 18.0000 | 85 | 85 | false | false | false | true | |||||||||
| 01a0c9a0-4ba7-7c23-a658-67e38fc0b68f | VIX | 2026-09-22 10:58 | strangle | 2 | 2 | 8500 | 1300500.00 | short | bid | 14.4100 | 0.0900 | ["16.5","20"] | ["0.5710","1.5075"] | ["14.97","21.53"] | ["XCBO"] | 16.5000 | 20.0000 | 29 | 29 | false | false | false | true | |||||||||
| 01a0c973-5fa6-7093-88d4-89432c8573bd | VIX | 2026-09-22 10:09 | ratio_risk_reversal | 2 | 1 | 1500 | 67710.00 | short | bid | 14.4500 | 0.1200 | ["15.5","17.5"] | ["0.4822","1.4947"] | ["17.68"] | ["XCBO"] | 15.5000 | 17.5000 | 29 | 29 | false | false | false | true | |||||||||
| 01a0c585-e167-7a50-8f3f-7d3e16427b76 | VIX | 2026-09-21 15:51 | ratio_risk_reversal | 2 | 1 | 10000 | 1451500.00 | short | ask | 14.8200 | 0.1200 | ["18","21"] | ["0.7418","1.5324"] | ["21.43"] | ["XCBO"] | 18.0000 | 21.0000 | 30 | 30 | false | false | false | true | |||||||||
| 01a0c550-853f-7643-854a-8a8ee770bcc5 | VIX | 2026-09-21 14:53 | ratio_risk_reversal | 2 | 1 | 700 | 113568.00 | short | ask | 15.0200 | 0.1000 | ["18","19"] | ["0.7373","1.4550"] | ["19.90"] | ["XCBO"] | 18.0000 | 19.0000 | 30 | 30 | false | false | false | true | |||||||||
| 01a0c51c-4a26-76c0-843b-6b161f117d20 | VIX | 2026-09-21 13:55 | ratio_risk_reversal | 2 | 1 | 2000 | 179600.00 | short | ask | 15.0500 | 0.0800 | ["18","24"] | ["0.7438","1.5607"] | ["24.40"] | ["XCBO"] | 18.0000 | 24.0000 | 30 | 30 | false | false | false | true | |||||||||
| 01a0c4ec-a6d7-7640-b930-9383b63ef51d | VIX | 2026-09-21 13:03 | strangle | 2 | 2 | 5000 | 965000.00 | short | bid | 14.9800 | 0.0900 | ["17","20"] | ["0.6481","1.4723"] | ["15.07","21.93"] | ["XCBO"] | 17.0000 | 20.0000 | 30 | 30 | false | false | false | true | |||||||||
| 01a0b616-568f-7432-b342-f6ded9fd10b4 | VIX | 2026-09-18 15:55 | strangle | 2 | 1 | 25000 | 4275000.00 | short | bid | 14.8600 | 0.0800 | ["16","27"] | ["0.5735","1.5290"] | ["14.29","28.71"] | ["XCBO"] | 16.0000 | 27.0000 | 61 | 61 | false | false | false | true | |||||||||
| 01a0b5a7-7f8f-7361-a5bf-f0144a8b9df6 | VIX | 2026-09-18 13:54 | straddle | 2 | 1 | 3000 | 882000.00 | short | bid | 15.2500 | 0.1000 | ["17.5"] | ["1.0481"] | ["14.56","20.44"] | ["XCBO"] | 17.5000 | 17.5000 | 33 | 33 | false | false | false | false | |||||||||
| 01a0aff8-d54b-7651-98b2-065214b9b937 | VIX | 2026-09-17 11:25 | ratio_risk_reversal | 2 | 1 | 1400 | 68460.00 | short | bid | 15.8500 | 0.0700 | ["15.5","18"] | ["0.2166","1.2578"] | ["18.06"] | ["XCBO"] | 15.5000 | 18.0000 | 34 | 34 | false | true | false | true | |||||||||
| 01a0afb7-a1e3-7523-9d9f-706397fa81b6 | VIX | 2026-09-17 10:13 | straddle | 2 | 2 | 3400 | 1200200.00 | short | bid | 15.9100 | 0.1000 | ["18.5"] | ["1.0180"] | ["14.97","22.03"] | ["XCBO"] | 18.5000 | 18.5000 | 34 | 34 | false | false | false | false | |||||||||
| 01a0afa8-8a9b-7f03-8047-1e00865b59f5 | VIX | 2026-09-17 09:57 | straddle | 2 | 1 | 500 | 177500.00 | short | bid | 15.7700 | 0.1300 | ["18.5"] | ["1.0370"] | ["14.95","22.05"] | ["XCBO"] | 18.5000 | 18.5000 | 34 | 34 | false | false | false | false | |||||||||
| 01a0ab03-35db-7560-8f1f-57d50a836fc6 | VIX | 2026-09-16 12:18 | ratio_risk_reversal | 2 | 1 | 1500 | 63900.00 | short | bid | 16.8000 | 0.0900 | ["15.5","18.5"] | ["0.3718","1.1511"] | ["15.43"] | ["XCBO"] | 15.5000 | 18.5000 | 35 | 35 | false | true | false | true | |||||||||
| 01a0a69e-f856-78c2-beab-e8b2a75de32e | VIX | 2026-09-15 15:50 | ratio_risk_reversal | 2 | 1 | 2000 | 326320.00 | short | ask | 17.4800 | 0.1200 | ["18.5","22"] | ["0.5847","1.1786"] | ["22.75"] | ["XCBO"] | 18.5000 | 22.0000 | 36 | 36 | false | false | false | true | |||||||||
| 01a0a693-b586-72c3-8886-0780d5e3b86d | VIX | 2026-09-15 15:38 | ratio_risk_reversal | 2 | 1 | 500 | 33000.00 | short | ask | 17.4700 | 0.1100 | ["19","55"] | ["0.5312","1.6485"] | ["55.18"] | ["XCBO"] | 19.0000 | 55.0000 | 64 | 64 | false | false | false | true | |||||||||
| 01a0a569-feae-7d80-a4d5-6803a067c87f | VIX | 2026-09-15 10:12 | risk_reversal | 2 | 1 | 1657 | 427506.00 | short | bid | 17.3700 | 0.1000 | ["17","19"] | ["0.5007","1.0645"] | ["19.84"] | ["XCBO"] | 17.0000 | 19.0000 | 36 | 36 | false | true | false | true | |||||||||
| 01a0a567-d016-7ef1-bced-bff865ddf585 | VIX | 2026-09-15 10:10 | risk_reversal | 2 | 1 | 2500 | 645000.00 | short | bid | 17.2200 | 0.1000 | ["17","19"] | ["0.4713","1.0967"] | ["19.84"] | ["XCBO"] | 17.0000 | 19.0000 | 36 | 36 | false | true | false | true | |||||||||
| 01a0a566-4976-7883-9ade-f0734ef0d560 | VIX | 2026-09-15 10:08 | strangle | 2 | 1 | 200 | 51600.00 | short | bid | 17.1600 | 0.0900 | ["17","19"] | ["0.4544","1.1142"] | ["14.42","21.58"] | ["XCBO"] | 17.0000 | 19.0000 | 36 | 36 | false | true | false | true | |||||||||
| 01a0a564-ce8e-71d2-9175-e57e631cc59b | VIX | 2026-09-15 10:07 | strangle | 2 | 1 | 2500 | 645000.00 | short | bid | 17.1400 | 0.0900 | ["17","19"] | ["0.4550","1.1138"] | ["14.42","21.58"] | ["XCBO"] | 17.0000 | 19.0000 | 36 | 36 | false | true | false | true | |||||||||
| 01a09132-e358-7d90-8747-14da3655705c | VIX | 2026-09-11 12:00 | strangle | 2 | 1 | 5150 | 437750.00 | short | bid | 15.7100 | 0.1000 | ["16.5","18"] | ["0.7790","1.4091"] | ["15.65","18.85"] | ["XCBO"] | 16.5000 | 18.0000 | 5 | 5 | false | false | false | true | |||||||||
| 01a08cac-2a88-7810-aa32-d4efa35a535c | VIX | 2026-09-10 14:54 | ratio_risk_reversal | 2 | 1 | 2000 | 216520.00 | short | ask | 17.6600 | 0.1000 | ["18","19"] | ["0.8834","1.3633"] | ["19.36"] | ["XCBO"] | 18.0000 | 19.0000 | 6 | 6 | false | false | false | true | |||||||||
| 01a08bbe-3c61-7322-be7e-e80b22c115ee | VIX | 2026-09-10 10:34 | ratio_risk_reversal | 2 | 1 | 3000 | 720900.00 | short | ask | 17.4000 | 0.1100 | ["19","25"] | ["0.5150","1.3183"] | ["18.58"] | ["XCBO"] | 19.0000 | 25.0000 | 41 | 41 | false | false | false | true | |||||||||
| 01a08bbd-7910-7d83-a29a-e8f10d9ebf3d | VIX | 2026-09-10 10:34 | ratio_risk_reversal | 2 | 1 | 9500 | 2282850.00 | short | ask | 17.4100 | 0.1100 | ["19","25"] | ["0.5180","1.3169"] | ["18.58"] | ["XCBO"] | 19.0000 | 25.0000 | 41 | 41 | false | false | false | true | |||||||||
| 01a08774-6198-7292-b23b-856fb857e386 | VIX | 2026-09-09 14:35 | strangle | 2 | 1 | 6771 | 1997445.00 | short | bid | 16.2300 | 0.1000 | ["18","21"] | ["0.7375","1.3003"] | ["15.05","23.95"] | ["XCBO"] | 18.0000 | 21.0000 | 42 | 42 | false | false | false | true | |||||||||
| 01a086b2-a7d8-7582-8f3f-3e34f75726b0 | VIX | 2026-09-09 11:04 | ratio_risk_reversal | 2 | 1 | 150 | 34200.00 | short | ask | 16.2300 | 0.1200 | ["19","30"] | ["0.7423","1.3993"] | ["18.88"] | ["XCBO"] | 19.0000 | 30.0000 | 70 | 70 | false | false | false | true | |||||||||
| 01a086b2-2309-7662-bb8e-440bd5f584e7 | VIX | 2026-09-09 11:03 | ratio_risk_reversal | 2 | 1 | 250 | 57000.00 | short | ask | 16.2400 | 0.1200 | ["19","30"] | ["0.7423","1.3982"] | ["18.88"] | ["XCBO"] | 19.0000 | 30.0000 | 70 | 70 | false | false | false | true | |||||||||
| 01a0868e-1c61-75e3-9316-73f9c5b9a2fe | VIX | 2026-09-09 10:24 | straddle | 2 | 2 | 200 | 108000.00 | short | bid | 16.2600 | 0.1600 | ["19"] | ["0.6483"] | ["13.60","24.40"] | ["XCBO"] | 19.0000 | 19.0000 | 98 | 98 | false | false | false | false |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:53:58Z"} |
| 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-22T14:58:50Z"} |
| 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-22T14:09:44Z"} |
| 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-21T19:51:19Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mfsl |
| market_whale |
| 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 |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:56:11Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:04:30Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:55:20Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:54:37Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mfsl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:25:25Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:14:01Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:57:40Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mfsl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:18:49Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:50:52Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mfsl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:38:20Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:13:18Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:10:53Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mfsl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:09:12Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:07:44Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T16:00:24Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:54:48Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:35:06Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:34:32Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T18:35:59Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mfsl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:04:28Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mfsl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:03:57Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:24:29Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |