core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg600,173 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 |
|---|
| 01a0e8bd-a48f-70b0-bf70-af73d74d1541 | IGV | 2026-09-28 11:58 | strangle | 2 | 1 | 220 | 189200.00 | short | bid | 105.2700 | 0.4500 | ["100","110"] | ["0.3372","0.3208"] | ["91.40","118.60"] | ["MCRY"] | 100.0000 | 110.0000 | 81 | 81 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-28T15:59:14Z"} | 2026-09-28 | 2026-09-28 17:15 | 2026-09-28 17:15 |
| 01a0e8bc-44ff-7601-939b-97275b6822ad | IGV | 2026-09-28 11:57 | strangle | 2 | 1 | 127 | 109220.00 | short | bid | 105.2800 | 0.4000 | ["100","110"] | ["0.3368","0.3211"] | ["91.40","118.60"] | ["ARCO"] | 100.0000 | 110.0000 | 81 | 81 | false | true | false | true | |||||||||
| 01a0e851-b7a7-7e81-854d-896b96c2e015 | IGV | 2026-09-28 10:01 | put_vertical_spread | 2 | 1 | 157 | 105975.00 | unknown | bid | 104.9200 | 0.9400 | ["90","100"] | ["0.3531","0.3359"] | ["93.25"] | ["XISX"] | 90.0000 | 100.0000 | 109 | 109 | false | true | false | ||||||||||
| 01a0d9d4-0fc7-7e63-8079-706ddd6bdd20 | IGV | 2026-09-25 14:29 | call_diagonal_spread | 2 | 1 | 2000 | 1472000.00 | short | ask | 106.6200 | 0.5500 | ["103","104"] | ["1.9887","0.3413"] | [] | ["XISX"] | 103.0000 | 104.0000 | 0 | 7 | false | false | true | ||||||||||
| 01a0ceea-4ca6-7d33-b30f-3868403276e7 | IGV | 2026-09-23 11:37 | call_vertical_spread | 2 | 2 | 100 | 140600.00 | unknown | bid | 108.2500 | 0.7000 | ["105","112"] | ["0.3089","0.3113"] | ["115.53"] | ["MCRY","XMIO"] | 105.0000 | 112.0000 | 86 | 86 | false | false | false | ||||||||||
| 01a0c9d6-ec07-7421-b05b-40bdb62467ce | IGV | 2026-09-22 11:58 | put_vertical_spread | 2 | 1 | 250 | 133500.00 | long | ask | 105.8700 | 0.3300 | ["94","104"] | ["0.3335","0.3144"] | ["101.16"] | ["XISX"] | 94.0000 | 104.0000 | 59 | 59 | false | true | false | ||||||||||
| 01a0b5c0-c44f-7d83-9531-a320514d104f | IGV | 2026-09-18 14:21 | call_vertical_spread | 2 | 1 | 25 | 134000.00 | long | ask | 104.5000 | 3.9000 | ["75","80"] | ["0.9299","0.7947"] | ["79.96"] | ["XISX"] | 75.0000 | 80.0000 | 21 | 21 | false | false | false | ||||||||||
| 01a0b5c0-6e5f-7ca3-841f-a29aa220b9f6 | IGV | 2026-09-18 14:21 | call_vertical_spread | 2 | 1 | 28 | 150080.00 | long | ask | 104.5000 | 4.0000 | ["75","80"] | ["0.9299","0.8100"] | ["79.96"] | ["XISX"] | 75.0000 | 80.0000 | 21 | 21 | false | false | false | ||||||||||
| 01a0b4b5-d84b-7893-b7ed-9edc8f62dba8 | IGV | 2026-09-18 09:30 | call_diagonal_spread | 2 | 1 | 2000 | 1508000.00 | unknown | bid | 106.2400 | 1.9500 | ["102","103"] | ["1.7707","0.2066"] | [] | ["XCBO"] | 102.0000 | 103.0000 | 0 | 7 | false | false | true | ||||||||||
| 01a0b087-de7b-7893-a533-d9a8d5b0665e | IGV | 2026-09-17 14:01 | call_vertical_spread | 2 | 1 | 62 | 275280.00 | long | ask | 105.7534 | 1.1000 | ["83","84"] | ["2.5926","2.5985"] | ["83.98"] | ["XMIO"] | 83.0000 | 84.0000 | 1 | 1 | false | false | false | ||||||||||
| 01a0afd9-8993-7ce1-834f-444c5e5b7137 | IGV | 2026-09-17 10:51 | other | 3 | 1 | 1694 | 298264.00 | unknown | — | 106.0700 | 0.6400 | ["103","104","105"] | ["0.3257","0.4165","0.4131"] | [] | ["ARCO"] | 103.0000 | 105.0000 | 1 | 15 | false | true | true | true | false | mlet | |||||||
| 01a0afd9-3b73-7cb1-81ae-0742d06bb162 | IGV | 2026-09-17 10:50 | other | 3 | 1 | 763 | 133748.00 | unknown | — | 106.0700 | 0.6400 | ["103","104","105"] | ["0.3231","0.4259","0.4181"] | [] | ["EDGO"] | 103.0000 | 105.0000 | 1 | 15 | false | true | true | true | false | mlet | |||||||
| 01a0aae8-d3f3-7650-b531-7620adf43c11 | IGV | 2026-09-16 11:49 | call_vertical_spread | 2 | 1 | 30 | 227670.00 | long | ask | 105.4800 | 2.8000 | ["65","70"] | ["1.4118","1.2723"] | ["69.97"] | ["XMIO"] | 65.0000 | 70.0000 | 16 | 16 | false | false | false | ||||||||||
| 01a0a694-ea1e-7e62-94e0-a47aa517d11f | IGV | 2026-09-15 15:39 | call_vertical_spread | 2 | 1 | 1275 | 466650.00 | unknown | — | 105.7500 | 0.1950 | ["108","117"] | ["0.3094","0.3066"] | [] | ["XISX"] | 108.0000 | 117.0000 | 31 | 31 | true | true | false | true | false | ||||||||
| 01a0a60a-e22e-7ff0-96f0-02697cef8443 | IGV | 2026-09-15 13:08 | call_vertical_spread | 2 | 1 | 25 | 199325.00 | unknown | — | 106.7500 | 3.5000 | ["65","70"] | ["1.1385","1.0005"] | [] | ["XBOX"] | 65.0000 | 70.0000 | 24 | 24 | false | false | false | true | false | ||||||||
| 01a0917b-4e68-7b12-ba18-6ad18655a97e | IGV | 2026-09-11 13:19 | call_diagonal_spread | 2 | 2 | 829 | 117718.00 | short | bid | 101.7000 | 0.2800 | ["102","105"] | ["0.2703","0.8678"] | [] | ["BATO"] | 102.0000 | 105.0000 | 0 | 7 | false | true | true | ||||||||||
| 01a0817f-5770-7c11-9288-f3e35c097f93 | IGV | 2026-09-08 10:49 | put_frontspread | 2 | 1 | 3000 | 238434.00 | long | ask | 102.4750 | 0.7600 | ["93","97"] | ["0.3271","0.3226"] | ["85.87","96.57"] | ["EDGO"] | 93.0000 | 97.0000 | 17 | 17 | true | true | false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T15:57:44Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T14:01:11Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T18:29:18Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:38:18Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:58:55Z"} |
| 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-18T18:22:08Z"} |
| 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-18T18:21:39Z"} |
| 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-18T13:30:05Z"} |
| 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-17T18:02:00Z"} |
| 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-17T14:51:22Z"} |
| 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-17T14:50: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-16T15:49:43Z"} |
| 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:39:56Z"} |
| 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-15T17:09:31Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T17:20:04Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:50:12Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |