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 |
|---|
| 01a0c99d-4e07-7dc2-9610-becc0205df42 | FXI | 2026-09-22 10:55 | other | 8 | 8 | 4920 | 2878682.00 | unknown | ask | 35.0200 | 5.2500 | ["30","34","35","36","38","39"] | ["0.3168","0.2095","0.2076","0.2123","0.2252","0.2245"] | [] | ["ARCO"] | 30.0000 | 39.0000 | 24 | 178 | false | false | true | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T14:55:55Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c57b-69b7-7ad2-b730-103c0d35d46d | FXI | 2026-09-21 15:39 | put_diagonal_spread | 2 | 1 | 19295 | 2059090.00 | unknown | — | 34.9250 | 0.1400 | ["34","35"] | ["0.2240","0.2235"] | [] | ["SPHR"] | 34.0000 | 35.0000 | 9 | 39 | false | false | true | true | false | ||||||||
| 01a0b4be-2d17-7662-8910-d69503a50688 | FXI | 2026-09-18 09:39 | put_diagonal_spread | 2 | 3 | 411 | 401147.00 | unknown | bid | 34.2400 | 0.8473 | ["38","40"] | ["0.2940","0.3287"] | [] | ["BATO","C2OX","XMIO"] | 38.0000 | 40.0000 | 28 | 91 | false | false | true | ||||||||||
| 01a0b0ec-0eeb-7640-a22f-9c455f7be352 | FXI | 2026-09-17 15:50 | put_diagonal_spread | 2 | 2 | 5846 | 192644.00 | unknown | — | 34.1750 | 1.1000 | ["27","28"] | ["0.2685","0.2592"] | [] | ["AMXO"] | 27.0000 | 28.0000 | 92 | 183 | false | true | true | true | false | ||||||||
| 01a0b0a3-943b-7f31-9754-56665ff4e960 | FXI | 2026-09-17 14:31 | put_ladder | 3 | 1 | 5000 | 4816000.00 | unknown | — | 34.2150 | 0.5000 | ["38","39","40"] | ["1.3155","1.5611","1.8294"] | [] | ["XBOX"] | 38.0000 | 40.0000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a0b0a2-7ee3-7781-80a7-7c8cce9cdd6e | FXI | 2026-09-17 14:30 | put_vertical_spread | 2 | 1 | 1005 | 735660.00 | unknown | — | 34.2100 | 0.5200 | ["35.5","40"] | ["0.7420","2.0350"] | [] | ["XBOX"] | 35.5000 | 40.0000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a0b0a2-6b5b-70e0-97a3-a6359fecf966 | FXI | 2026-09-17 14:30 | other | 4 | 1 | 15000 | 8332600.00 | unknown | — | 34.2100 | 4.7500 | ["36","38","40"] | ["0.6440","1.2953","2.5467"] | [] | ["XBOX"] | 36.0000 | 40.0000 | 1 | 29 | false | false | true | true | false | mlft | |||||||
| 01a0b019-cacb-76f0-8c32-193a88b52597 | FXI | 2026-09-17 12:01 | put_diagonal_spread | 2 | 1 | 1000 | 213000.00 | unknown | — | 34.2450 | 0.4500 | ["32","34"] | ["0.2455","0.2148"] | [] | ["ARCO"] | 32.0000 | 34.0000 | 64 | 183 | false | true | true | true | false | ||||||||
| 01a0a583-6696-7920-80ef-f4066f90cafd | FXI | 2026-09-15 10:40 | other | 2 | 1 | 1000 | 505000.00 | unknown | — | 34.4050 | 0.6400 | ["34","35"] | ["0.2082","0.2417"] | [] | ["AMXO"] | 34.0000 | 35.0000 | 94 | 275 | false | false | true | true | true | mlct | |||||||
| 01a0a570-c126-7943-b8fb-107c8e33befc | FXI | 2026-09-15 10:20 | other | 3 | 1 | 44570 | 3743880.00 | unknown | — | 34.4600 | 0.3700 | ["31","38","40"] | ["0.2478","0.2027","0.8970"] | [] | ["XPHO"] | 31.0000 | 40.0000 | 3 | 94 | false | true | true | true | true | mlat | |||||||
| 01a0a0e3-8140-7081-8a6e-097219b604cb | FXI | 2026-09-14 13:07 | call_vertical_spread | 2 | 1 | 10000 | 265000.00 | unknown | — | 34.9450 | 0.1400 | ["36","37"] | ["0.1879","0.2038"] | [] | ["XPHO"] | 36.0000 | 37.0000 | 16 | 16 | false | true | false | true | false | ||||||||
| 01a0a0c0-f198-7e31-a781-3224ef4259ee | FXI | 2026-09-14 12:29 | call_calendar | 2 | 1 | 1000 | 102000.00 | unknown | — | 34.9050 | 0.2100 | ["35"] | ["0.1925"] | [] | ["AMXO"] | 35.0000 | 35.0000 | 11 | 18 | false | true | true | false | false | mlft | |||||||
| 01a091e3-e7c0-7e11-977f-2a32cc84e6cc | FXI | 2026-09-11 15:13 | other | 3 | 1 | 9480 | 7563600.00 | unknown | — | 34.4850 | 0.7000 | ["38","39","40"] | ["0.5238","0.5487","0.6373"] | [] | ["XBOX"] | 38.0000 | 40.0000 | 7 | 7 | false | false | false | true | false | mlft | |||||||
| 01a0910f-de81-73c2-8d06-b3b79bf47ce9 | FXI | 2026-09-11 11:22 | strangle | 2 | 1 | 5000 | 2040000.00 | unknown | — | 34.5600 | 0.4500 | ["38","40"] | ["0.2641","0.2122"] | [] | ["ARCO"] | 38.0000 | 40.0000 | 98 | 98 | false | false | false | true | true | mlct | |||||||
| 01a08ca6-a090-7770-8bd7-ecebfcc5d7ff | FXI | 2026-09-10 14:48 | put_vertical_spread | 2 | 1 | 5326 | 4473840.00 | unknown | — | 34.3750 | 0.4100 | ["37","40"] | ["0.3939","0.6774"] | [] | ["XBOX"] | 37.0000 | 40.0000 | 8 | 8 | false | false | false | true | false | ||||||||
| 01a08ca6-8538-7500-bde4-7195e7807d23 | FXI | 2026-09-10 14:48 | other | 4 | 1 | 15000 | 13040832.00 | unknown | — | 34.3750 | 0.9400 | ["36","37","38","39"] | ["0.7419","0.4138","0.4701","0.5822"] | [] | ["XBOX"] | 36.0000 | 39.0000 | 1 | 8 | false | false | true | true | false | ||||||||
| 01a08ca0-3408-7930-a1ca-d9438211a5bf | FXI | 2026-09-10 14:41 | put_vertical_spread | 2 | 1 | 24460 | 20546400.00 | unknown | — | 34.3650 | 0.6000 | ["38","39"] | ["0.4838","0.5765"] | [] | ["XBOX"] | 38.0000 | 39.0000 | 8 | 8 | true | false | false | true | false | ||||||||
| 01a086f9-f5c0-7ff0-9884-2f2dd956bea8 | FXI | 2026-09-09 12:22 | other | 2 | 1 | 1000 | 409000.00 | unknown | — | 34.6050 | 0.7100 | ["34","36"] | ["0.2503","0.2030"] | [] | ["ARCO"] | 34.0000 | 36.0000 | 72 | 281 | false | false | true | true | false | mlct | |||||||
| 01a086c3-b708-7331-843e-53b4cbed4d7e | FXI | 2026-09-09 11:22 | strangle | 2 | 1 | 4000 | 136000.00 | unknown | — | 34.6200 | 0.0900 | ["34","35.5"] | ["0.2055","0.2063"] | [] | ["AMXO"] | 34.0000 | 35.5000 | 9 | 9 | false | true | false | true | true | mlct | |||||||
| 01a08678-b7d0-7640-ac7c-ebaef5976d57 | FXI | 2026-09-09 10:00 | call_vertical_spread | 2 | 1 | 15000 | 525000.00 | unknown | — | 34.7500 | 0.2100 | ["36","37"] | ["0.2016","0.2095"] | [] | ["AMXO"] | 36.0000 | 37.0000 | 21 | 21 | true | true | false | true | false | ||||||||
| 01a0826d-16b8-7070-9755-8584dccae71d | FXI | 2026-09-08 15:09 | put_vertical_spread | 2 | 1 | 2980 | 2711800.00 | unknown | — | 35.0550 | 0.5500 | ["39","40"] | ["0.4990","0.5840"] | [] | ["XBOX"] | 39.0000 | 40.0000 | 10 | 10 | false | false | false | true | false | ||||||||
| 01a0818c-9de0-7d43-a04b-5a54a2a36dfc | FXI | 2026-09-08 11:04 | strangle | 2 | 1 | 5000 | 2200000.00 | unknown | — | 35.0850 | 0.9400 | ["39","41"] | ["0.2482","0.2236"] | [] | ["SPHR"] | 39.0000 | 41.0000 | 101 | 101 | false | false | false | true | true | mlct | |||||||
| 01a0817e-9038-7482-ac91-6e594504367f | FXI | 2026-09-08 10:49 | other | 2 | 1 | 19294 | 2238104.00 | unknown | — | 35.0850 | 0.2400 | ["35","36"] | ["0.1893","0.2030"] | [] | ["ARCO"] | 35.0000 | 36.0000 | 22 | 38 | false | true | true | true | true | mlct | |||||||
| 01a08178-3739-7703-94a7-bde9195db077 | FXI | 2026-09-08 10:42 | strangle | 2 | 1 | 5000 | 2200000.00 | unknown | — | 35.0999 | 0.9400 | ["39","41"] | ["0.2501","0.2232"] | [] | ["SPHR"] | 39.0000 | 41.0000 | 101 | 101 | false | false | false | true | true | mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:39:54Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:39:19Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:51:05Z"} |
| 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-17T18:31:45Z"} |
| 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-17T18:30:58Z"} |
| 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-17T18:30:58Z"} |
| 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:01:25Z"} |
| 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-15T14:41:00Z"} |
| 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:20:40Z"} |
| 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-14T17:07:39Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:30:09Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:13:47Z"} |
| 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-11T15:22:12Z"} |
| 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-10T18:49:12Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:49:12Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:42:12Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:22:02Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:22:56Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:01:02Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:10:18Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:04:36Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:49:40Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:42:14Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |