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 |
|---|
| 01a0ca74-e56f-7ae0-b5a5-9df957f3b821 | IGV | 2026-09-22 14:50 | other | 4 | 1 | 600 | 195600.00 | unknown | — | 106.7650 | 0.9600 | ["104","109"] | ["0.3325","0.3256"] | [] | ["XISX"] | 104.0000 | 109.0000 | 3 | 10 | false | true | true | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T18:51:07Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c9f5-d616-7740-9946-bceb73746484 | IGV | 2026-09-22 12:32 | put_vertical_spread | 2 | 1 | 3000 | 306000.00 | unknown | ask | 106.0900 | 0.1400 | ["95","97"] | ["0.3352","0.3368"] | ["95.98"] | ["XBOX"] | 95.0000 | 97.0000 | 24 | 24 | false | true | false | true | |||||||||
| 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 | true | |||||||||
| 01a0c9ad-95fe-7da3-966f-c5162619daf8 | IGV | 2026-09-22 11:13 | put_vertical_spread | 2 | 3 | 500 | 265500.00 | long | ask | 105.9300 | 0.4400 | ["94","104"] | ["0.3324","0.3152"] | ["101.15"] | ["XCBO"] | 94.0000 | 104.0000 | 59 | 59 | true | true | false | true | |||||||||
| 01a0c499-432f-7832-b05e-a4aa29d8cf34 | IGV | 2026-09-21 11:32 | strangle | 2 | 1 | 850 | 403750.00 | long | ask | 106.3000 | 0.3500 | ["105","110"] | ["0.3137","0.3077"] | ["100.25","114.75"] | ["XPHO"] | 105.0000 | 110.0000 | 25 | 25 | false | true | false | true | |||||||||
| 01a0c461-898f-73f1-b9bc-69ee52f6fb5b | IGV | 2026-09-21 10:31 | put_diagonal_spread | 2 | 1 | 26000 | 20440000.00 | unknown | ask | 106.2900 | 1.6500 | ["102","103"] | ["0.3351","0.3376"] | [] | ["XPHO"] | 102.0000 | 103.0000 | 60 | 88 | false | true | true | true | |||||||||
| 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 | true | |||||||||
| 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 | true | |||||||||
| 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 | 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 | true | |||||||||
| 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 | true | |||||||||
| 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 | mlet | |||||||
| 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 | mlet | |||||||
| 01a0a60a-6cfe-7611-91cc-92b89295c2f6 | IGV | 2026-09-15 13:08 | call_vertical_spread | 2 | 1 | 25 | 195125.00 | long | ask | 106.7801 | 3.5000 | ["65","70"] | ["1.1233","1.0185"] | ["69.97"] | ["XMIO"] | 65.0000 | 70.0000 | 24 | 24 | false | false | false | true | |||||||||
| 01a0a603-681e-7eb2-bee9-a985839f7fc0 | IGV | 2026-09-15 13:00 | call_vertical_spread | 2 | 1 | 49 | 382445.00 | long | ask | 106.9300 | 3.5000 | ["65","70"] | ["1.0349","0.9501"] | ["69.97"] | ["XCBO"] | 65.0000 | 70.0000 | 24 | 24 | false | false | false | true | |||||||||
| 01a0a160-a468-71a3-b3c7-9449ec851ba9 | IGV | 2026-09-14 15:24 | strangle | 2 | 1 | 350 | 213500.00 | long | ask | 106.5800 | 0.4200 | ["106","110"] | ["0.3125","0.3114"] | ["99.90","116.10"] | ["SPHR"] | 106.0000 | 110.0000 | 32 | 32 | false | true | false | true | |||||||||
| 01a0a09c-e321-70f0-aba7-a80bf38312e4 | IGV | 2026-09-14 11:50 | call_vertical_spread | 2 | 1 | 49 | 276360.00 | long | ask | 106.1050 | 3.2000 | ["75","80"] | ["1.1230","1.0048"] | ["79.98"] | ["XMIO"] | 75.0000 | 80.0000 | 11 | 11 | false | false | false | true | |||||||||
| 01a091f3-e580-7e42-a553-afc837e4551c | IGV | 2026-09-11 15:31 | risk_reversal | 2 | 1 | 300 | 258900.00 | short | ask | 101.7900 | 0.4500 | ["100","110"] | ["0.3102","0.2960"] | ["98.35"] | ["XPHO"] | 100.0000 | 110.0000 | 98 | 98 | false | true | false | true | |||||||||
| 01a091f1-3dd0-7943-b125-0acfb8284bf7 | IGV | 2026-09-11 15:28 | strangle | 2 | 1 | 2500 | 2162500.00 | unknown | — | 101.8100 | 0.4500 | ["100","110"] | ["0.3106","0.2966"] | [] | ["AMXO"] | 100.0000 | 110.0000 | 98 | 98 | false | true | false | true | true | mlct | |||||||
| 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 | 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 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:32:39Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| 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 |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:13:36Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:33:07Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:32:08Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:08:37Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:01:18Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:24:39Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:50:52Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:31:32Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:28:42Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| 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 |
| 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 |