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 |
|---|
| 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 |
|---|
| 01a0caaa-f92f-7f20-8f13-b315686cf1fc | XLF | 2026-09-22 15:49 | strangle | 2 | 1 | 8394 | 822612.00 | long | ask | 54.9050 | 0.0700 | ["54","56"] | ["0.1673","0.1543"] | ["53.02","56.98"] | ["XPHO"] | 54.0000 | 56.0000 | 24 | 24 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T19:50:08Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0ca8b-1907-7661-bb71-2dd40afc29f5 | XLF | 2026-09-22 15:15 | put_diagonal_spread | 2 | 1 | 2869 | 215175.00 | long | ask | 54.8950 | 0.1600 | ["55","55.5"] | ["0.1749","0.1942"] | [] | ["XPHO"] | 55.0000 | 55.5000 | 0 | 1 | false | false | |||||||||||
| 01a0ca5a-a2c7-7a70-a4a1-9e809a9e8de6 | XLF | 2026-09-22 14:22 | other | 6 | 7 | 2927 | 3585552.00 | unknown | ask | 54.9000 | 1.9500 | ["50","54","55","57","61"] | ["0.2037","0.1847","0.1692","0.1407","0.1825"] | [] | ["AMXO"] | 50.0000 | 61.0000 | 24 | 178 | false | false | |||||||||||
| 01a0c9f4-43bf-7f42-8031-1d3477fa2487 | XLF | 2026-09-22 12:30 | put_vertical_spread | 2 | 1 | 10000 | 840000.00 | unknown | ask | 54.9050 | 0.1800 | ["55","55.5"] | ["0.3385","0.5251"] | ["54.83"] | ["AMXO"] | 55.0000 | 55.5000 | 0 | 0 | false | false | |||||||||||
| 01a0c9d1-2f47-71d2-bdf0-4ba057231fe2 | XLF | 2026-09-22 11:52 | strangle | 2 | 1 | 500 | 45750.00 | short | bid | 54.6499 | 0.0600 | ["51","55"] | ["0.2097","0.1597"] | ["50.08","55.92"] | ["XPHO"] | 51.0000 | 55.0000 | 24 | 24 | false | true | |||||||||||
| 01a0b5d3-8ce8-73d2-89a6-aecec467e3ab | XLF | 2026-09-18 14:42 | other | 4 | 4 | 12500 | 14887500.00 | unknown | ask | 55.8850 | 0.3300 | ["50"] | ["2.4658"] | [] | ["AMXO"] | 50.0000 | 50.0000 | 0 | 28 | false | false | true | ||||||||||
| 01a0b555-48b0-7583-8fd2-2ce20d9ffff4 | XLF | 2026-09-18 12:24 | risk_reversal | 2 | 1 | 700 | 123200.00 | long | bid | 55.7350 | 0.0800 | ["54","59"] | ["0.1834","0.1513"] | ["53.66"] | ["AMXO"] | 54.0000 | 59.0000 | 91 | 91 | false | true | |||||||||||
| 01a0b4e3-54cf-7383-8fcc-289ce85df0ad | XLF | 2026-09-18 10:19 | other | 3 | 2 | 12400 | 541334.00 | unknown | bid | 55.7800 | 0.0722 | ["54","57","61"] | ["0.1832","0.1317","0.1544"] | ["53.64"] | ["AMXO"] | 54.0000 | 61.0000 | 28 | 28 | false | true | |||||||||||
| 01a0abc7-c243-7993-bb51-a814a8e98068 | XLF | 2026-09-16 15:53 | put_diagonal_spread | 2 | 1 | 10000 | 150000.00 | long | ask | 55.8850 | 0.0600 | ["55","55.5"] | ["0.2692","1.6420"] | [] | ["SPHR"] | 55.0000 | 55.5000 | 0 | 2 | false | true | |||||||||||
| 01a0abab-7fe3-74c3-9207-c25672df42fc | XLF | 2026-09-16 15:22 | other | 4 | 5 | 7500 | 8523750.00 | unknown | — | 55.4850 | 0.4400 | ["50"] | ["0.4908"] | [] | ["AMXO"] | 50.0000 | 50.0000 | 2 | 30 | false | false | true | false | true | ||||||||
| 01a0aa7c-e70c-7510-b4d4-c2e8dda01528 | XLF | 2026-09-16 09:51 | put_ratio_spread | 2 | 1 | 8000 | 352000.00 | unknown | — | 56.5100 | 0.1400 | ["56.5","57"] | ["0.3448","0.4685"] | [] | ["SPHR"] | 56.5000 | 57.0000 | 0 | 0 | false | false | false | true | |||||||||
| 01a0a685-4635-7c92-9e84-425ddd53682c | XLF | 2026-09-15 15:22 | put_diagonal_spread | 2 | 2 | 1086 | 94435.00 | unknown | — | 56.8900 | 0.1400 | ["55.5","57"] | ["0.2004","0.2052"] | [] | ["AMXO"] | 55.5000 | 57.0000 | 3 | 17 | false | false | true | true | |||||||||
| 01a0a672-8186-7d02-8d63-c7a4980f2d67 | XLF | 2026-09-15 15:01 | synthetic | 2 | 1 | 1240 | 262880.00 | short | ask | 56.8343 | 0.1500 | ["57"] | ["0.1605"] | ["56.72"] | ["XBOX"] | 57.0000 | 57.0000 | 31 | 31 | false | false | false | ||||||||||
| 01a0a645-0116-73d0-b3b6-69db1f6d5256 | XLF | 2026-09-15 14:12 | other | 4 | 1 | 820 | 195000.00 | unknown | — | 56.6600 | 0.2200 | ["57","58"] | ["0.2072","0.2330"] | [] | ["XBOX"] | 57.0000 | 58.0000 | 3 | 3 | false | false | false | true | true | ||||||||
| 01a091b8-e7f0-70b1-8481-3afa16f2c838 | XLF | 2026-09-11 14:26 | other | 3 | 3 | 1125 | 157750.00 | unknown | — | 57.2700 | 0.1400 | ["56","58"] | ["0.1732","0.1692"] | [] | ["AMXO"] | 56.0000 | 58.0000 | 7 | 35 | false | false | true | true | false | ||||||||
| 01a08c4f-4d18-7ed0-830e-d2feeb819a49 | XLF | 2026-09-10 13:13 | strangle | 2 | 1 | 700 | 120400.00 | short | bid | 56.8400 | 0.0900 | ["53","61"] | ["0.1979","0.1521"] | ["51.28","62.72"] | ["XPHO"] | 53.0000 | 61.0000 | 127 | 127 | false | true | |||||||||||
| 01a0878f-8ea1-7d32-a34b-4d03706d86ba | XLF | 2026-09-09 15:05 | other | 2 | 2 | 1200 | 81000.00 | unknown | — | 57.1450 | 0.0700 | ["48","53"] | ["0.2548","0.1970"] | [] | ["AMXO"] | 48.0000 | 53.0000 | 100 | 128 | false | true | true | true | false | ||||||||
| 01a08691-8f30-7ba0-95d9-fd4775f25ec9 | XLF | 2026-09-09 10:27 | other | 2 | 1 | 58700 | 1096600.00 | unknown | — | 57.2250 | 0.1100 | ["60.5","62"] | ["0.1551","0.1550"] | [] | ["SPHR"] | 60.5000 | 62.0000 | 23 | 100 | false | true | true | true | false | ||||||||
| 01a08229-5ec9-7232-90e7-11a3d49207b0 | XLF | 2026-09-08 13:55 | put_vertical_spread | 2 | 1 | 1000 | 176000.00 | long | ask | 57.5450 | 0.1100 | ["53","57"] | ["0.2010","0.1770"] | ["56.06"] | ["SPHR"] | 53.0000 | 57.0000 | 73 | 73 | false | true | |||||||||||
| 01a08208-80b8-7f91-92bf-b9034f5c2989 | XLF | 2026-09-08 13:19 | put_vertical_spread | 2 | 1 | 1853 | 598519.00 | unknown | — | 57.5101 | 0.2700 | ["46","51"] | ["0.2504","0.2305"] | [] | ["SPHR"] | 46.0000 | 51.0000 | 465 | 465 | false | true | false | true |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:15:17Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:22:22Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:30:54Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| true |
| mlft |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:52:45Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:42:16Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:24:25Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:20:10Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:53:11Z"} |
| 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-16T19:22:22Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:51:53Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlft |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:22:46Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:02:08Z"} |
| 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-15T18:12:19Z"} |
| 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-11T18:27:23Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:13:39Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:05:47Z"} |
| 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:28:23Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:55:47Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:19:51Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |