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 |
|---|
| 01a0c99c-a60f-79d2-93fc-30385fad7dd3 | VIX | 2026-09-22 10:54 | put_vertical_spread | 2 | 1 | 12352 | 889344.00 | long | ask | 14.4300 | 0.0900 | ["14","16"] | ["0.1232","0.5599"] | ["15.46"] | ["XCBO"] | 14.0000 | 16.0000 | 57 | 57 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T14:54:40Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c963-c38f-7d83-8cad-8a4c489e334c | VIX | 2026-09-22 09:52 | put_vertical_spread | 2 | 1 | 20 | 228820.00 | long | ask | 14.6500 | 0.8000 | ["50","100"] | ["1.8549","2.1996"] | ["50.29"] | ["XCBO"] | 50.0000 | 100.0000 | 29 | 29 | false | false | false | ||||||||||
| 01a0c4a4-89e7-7842-80f6-d6d931976190 | VIX | 2026-09-21 11:45 | put_vertical_spread | 2 | 1 | 50 | 165800.00 | long | ask | 14.8900 | 0.2000 | ["29","40"] | ["1.1531","1.3867"] | ["29.44"] | ["XCBO"] | 29.0000 | 40.0000 | 58 | 58 | false | false | false | ||||||||||
| 01a0b5ad-923f-7f52-aee1-500cb56c8f23 | VIX | 2026-09-18 14:00 | put_vertical_spread | 2 | 1 | 50 | 59900.00 | long | ask | 15.2600 | 0.2500 | ["23","25"] | ["0.6427","0.6811"] | ["23.40"] | ["XCBO"] | 23.0000 | 25.0000 | 180 | 180 | false | false | false | ||||||||||
| 01a0b5a8-8547-72c1-bb28-8f000b3077de | VIX | 2026-09-18 13:55 | put_vertical_spread | 2 | 1 | 50 | 48200.00 | long | ask | 15.2500 | 0.2500 | ["22","23"] | ["0.6648","0.6870"] | ["22.20"] | ["XCBO"] | 22.0000 | 23.0000 | 152 | 152 | false | false | false | ||||||||||
| 01a0b5a7-a69f-7783-8315-7be71aca03b2 | VIX | 2026-09-18 13:54 | put_vertical_spread | 2 | 1 | 45 | 96525.00 | long | ask | 15.2500 | 0.3000 | ["29","30"] | ["0.8000","0.8155"] | ["29.09"] | ["XCBO"] | 29.0000 | 30.0000 | 152 | 152 | false | false | false | ||||||||||
| 01a0b5a7-9ae7-7281-8e97-6acce5d400b8 | VIX | 2026-09-18 13:54 | put_vertical_spread | 2 | 1 | 50 | 72500.00 | long | ask | 15.2500 | 0.3000 | ["25","26"] | ["0.7290","0.7485"] | ["25.14"] | ["XCBO"] | 25.0000 | 26.0000 | 152 | 152 | false | false | false | ||||||||||
| 01a0b5a2-2477-72c2-8a3a-c6358cdb8bf3 | VIX | 2026-09-18 13:48 | put_vertical_spread | 2 | 1 | 45 | 44370.00 | long | ask | 15.2600 | 0.3000 | ["22","23"] | ["0.7126","0.7423"] | ["22.18"] | ["XCBO"] | 22.0000 | 23.0000 | 124 | 124 | false | false | false | ||||||||||
| 01a0b5a1-af47-7e52-be8f-7bd7f24159f8 | VIX | 2026-09-18 13:47 | put_vertical_spread | 2 | 1 | 45 | 66690.00 | long | ask | 15.2600 | 0.2500 | ["25","26"] | ["0.7904","0.8116"] | ["25.12"] | ["XCBO"] | 25.0000 | 26.0000 | 124 | 124 | false | false | false | ||||||||||
| 01a0b59b-331f-75d1-bfc0-6840458390dc | VIX | 2026-09-18 13:40 | put_vertical_spread | 2 | 1 | 45 | 103410.00 | long | ask | 15.2800 | 0.2500 | ["29","30"] | ["0.9967","1.0168"] | ["29.06"] | ["XCBO"] | 29.0000 | 30.0000 | 89 | 89 | false | false | false | ||||||||||
| 01a0b59a-ba07-7d03-903d-63e855ebe5ab | VIX | 2026-09-18 13:40 | put_vertical_spread | 2 | 1 | 50 | 65550.00 | long | ask | 15.2800 | 0.2000 | ["23","25"] | ["0.8512","0.9060"] | ["23.29"] | ["XCBO"] | 23.0000 | 25.0000 | 89 | 89 | false | false | false | ||||||||||
| 01a0b593-3827-7192-9f19-5fcfc6ccdb1a | VIX | 2026-09-18 13:31 | put_vertical_spread | 2 | 1 | 50 | 79100.00 | long | ask | 15.3800 | 0.2000 | ["25","26"] | ["1.0155","1.0455"] | ["25.08"] | ["XCBO"] | 25.0000 | 26.0000 | 61 | 61 | false | false | false | ||||||||||
| 01a0b593-0d2f-70a3-8e42-63cf3a5e615d | VIX | 2026-09-18 13:31 | put_vertical_spread | 2 | 1 | 45 | 104670.00 | long | ask | 15.3800 | 0.2000 | ["29","30"] | ["1.1339","1.1615"] | ["29.04"] | ["XCBO"] | 29.0000 | 30.0000 | 61 | 61 | false | false | false | ||||||||||
| 01a0b592-ab87-7dc0-8671-12d58eb796fb | VIX | 2026-09-18 13:31 | put_vertical_spread | 2 | 1 | 50 | 65800.00 | long | ask | 15.3800 | 0.2000 | ["23","25"] | ["0.9424","1.0154"] | ["23.24"] | ["XCBO"] | 23.0000 | 25.0000 | 61 | 61 | false | false | false | ||||||||||
| 01a0b563-94d8-7ce0-9c49-d47f3a8df6cd | VIX | 2026-09-18 12:39 | put_vertical_spread | 2 | 1 | 500 | 285500.00 | long | ask | 15.4400 | 0.1500 | ["18","21"] | ["0.7008","0.8595"] | ["18.71"] | ["XCBO"] | 18.0000 | 21.0000 | 61 | 61 | false | false | false | ||||||||||
| 01a0b561-0497-70a1-bf4c-880302ec55f3 | VIX | 2026-09-18 12:37 | put_vertical_spread | 2 | 1 | 500 | 285500.00 | long | ask | 15.4300 | 0.1500 | ["18","21"] | ["0.7019","0.8603"] | ["18.71"] | ["XCBO"] | 18.0000 | 21.0000 | 61 | 61 | false | false | false | ||||||||||
| 01a0b560-452f-7913-bd7b-c61fd8378197 | VIX | 2026-09-18 12:36 | put_vertical_spread | 2 | 1 | 200 | 114200.00 | long | ask | 15.4100 | 0.1500 | ["18","21"] | ["0.7017","0.8602"] | ["18.71"] | ["XCBO"] | 18.0000 | 21.0000 | 61 | 61 | false | false | false | ||||||||||
| 01a0b55f-00f7-7d52-8544-f169cb7ec2c9 | VIX | 2026-09-18 12:34 | put_vertical_spread | 2 | 1 | 300 | 171300.00 | long | ask | 15.4000 | 0.1500 | ["18","21"] | ["0.6999","0.8605"] | ["18.71"] | ["XCBO"] | 18.0000 | 21.0000 | 61 | 61 | false | false | false | ||||||||||
| 01a0b522-ee0f-7520-a929-f1896d3544b7 | VIX | 2026-09-18 11:29 | put_vertical_spread | 2 | 1 | 300 | 288300.00 | long | ask | 15.2200 | 0.3000 | ["22","23"] | ["0.6236","0.6419"] | ["22.21"] | ["XCBO"] | 22.0000 | 23.0000 | 180 | 180 | false | false | false | ||||||||||
| 01a0b522-49ff-7d60-b8ef-f9d699a9c71d | VIX | 2026-09-18 11:28 | put_vertical_spread | 2 | 1 | 200 | 192200.00 | long | ask | 15.2200 | 0.3000 | ["22","23"] | ["0.6236","0.6419"] | ["22.21"] | ["XCBO"] | 22.0000 | 23.0000 | 180 | 180 | false | false | false | ||||||||||
| 01a0b4ee-ed8f-7012-98d4-d7254fc54052 | VIX | 2026-09-18 10:32 | put_vertical_spread | 2 | 1 | 80 | 105840.00 | long | ask | 15.4300 | 0.2500 | ["23","25"] | ["1.0619","1.1670"] | ["23.15"] | ["XCBO"] | 23.0000 | 25.0000 | 33 | 33 | false | false | false | ||||||||||
| 01a0b4e8-b3cf-74c0-9dce-e186047f8199 | VIX | 2026-09-18 10:25 | put_vertical_spread | 2 | 1 | 100 | 114200.00 | long | ask | 15.5100 | 0.2000 | ["22","24"] | ["1.0160","1.1214"] | ["22.18"] | ["XCBO"] | 22.0000 | 24.0000 | 33 | 33 | false | false | false | ||||||||||
| 01a0b058-5a6b-76a2-8ccb-a0e37ab069e8 | VIX | 2026-09-17 13:09 | put_vertical_spread | 2 | 1 | 15 | 170595.00 | long | ask | 15.5900 | 0.6000 | ["50","100"] | ["1.8020","2.1107"] | ["50.35"] | ["XCBO"] | 50.0000 | 100.0000 | 34 | 34 | false | false | false | ||||||||||
| 01a0aa80-8ca3-7bb2-b567-572e553e81fc | VIX | 2026-09-16 09:55 | put_vertical_spread | 2 | 1 | 20 | 226880.00 | long | ask | 16.7500 | 7.3700 | ["50","100"] | ["1.8946","4.3474"] | ["50.28"] | ["XCBO"] | 50.0000 | 100.0000 | 28 | 28 | false | false | false | ||||||||||
| 01a0a6a5-2276-77e3-8dd2-3caaed5edbb8 | VIX | 2026-09-15 15:57 | put_vertical_spread | 2 | 1 | 173 | 52246.00 | long | ask | 17.4400 | 0.1400 | ["17","19"] | ["0.4950","0.5793"] | ["17.64"] | ["XCBO"] | 17.0000 | 19.0000 | 36 | 36 | false | false | false | ||||||||||
| 01a0a6a4-b8fe-7020-b7e3-df89da5a1908 | VIX | 2026-09-15 15:56 | put_vertical_spread | 2 | 1 | 107 | 36701.00 | long | ask | 17.4300 | 0.1600 | ["17","19.5"] | ["0.4979","0.5947"] | ["17.75"] | ["XCBO"] | 17.0000 | 19.5000 | 36 | 36 | false | false | false | ||||||||||
| 01a0a68e-5a6d-74f3-acd3-393e5b82b5bc | VIX | 2026-09-15 15:32 | put_vertical_spread | 2 | 1 | 173 | 59858.00 | long | ask | 17.4900 | 0.1000 | ["17","19.5"] | ["0.5138","0.6255"] | ["17.74"] | ["XCBO"] | 17.0000 | 19.5000 | 36 | 36 | false | false | false | ||||||||||
| 01a0a68e-27a6-7e12-b548-e9d9e3c24be6 | VIX | 2026-09-15 15:32 | put_vertical_spread | 2 | 1 | 173 | 53111.00 | long | ask | 17.4900 | 0.1000 | ["17","19"] | ["0.5138","0.6091"] | ["17.63"] | ["XCBO"] | 17.0000 | 19.0000 | 36 | 36 | false | false | false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:52:43Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:45:28Z"} |
| 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-18T18:00:52Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:55:22Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| tracked |
| 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 |
| false |
| mlet |
| tracked |
| 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 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:48:19Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:48:19Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:40:59Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:40:12Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:32:20Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:32:20Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:31:41Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:40:19Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:37:09Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:36:24Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:35:18Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:29:41Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:28:38Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:32:55Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:25:46Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:09:55Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:55:50Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:57:23Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:57:00Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:32:31Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:32:31Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |