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 |
|---|
| 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 |
|---|
| 01a06e09-a36d-72a1-be8f-e2840690d46b | TLT | 2026-09-04 16:08 | put_vertical_spread | 2 | 1 | 2000 | 1720000.00 | long | ask | 82.1900 | 0.2500 | ["86","87"] | ["0.1676","0.2001"] | ["0","86"] | ["XPHO"] | 86.0000 | 87.0000 | 14 | 14 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T20:11:23Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a0876a-4b91-7782-ab7c-edbe74d940bf | TLT | 2026-09-09 14:24 | put_vertical_spread | 2 | 1 | 4616 | 7108640.00 | unknown | — | 81.7599 | 0.2000 | ["87","92"] | ["0.2171","0.3770"] | [] | ["XBOX"] | 87.0000 | 92.0000 | 9 | 9 | false | false | false | true | false | ||||||||
| 01a08b88-e808-7732-8726-6fc17a3bf6a0 | TLT | 2026-09-10 09:36 | put_vertical_spread | 2 | 3 | 419 | 166758.00 | short | bid | 80.9850 | 0.0600 | ["81","82"] | ["0.1409","0.1421"] | ["81.48"] | ["AMXO","XCBO","XISX"] | 81.0000 | 82.0000 | 71 | 71 | false | false | false | ||||||||||
| 01a08ca9-4458-7b41-b8ed-0fa27baf0830 | TLT | 2026-09-10 14:51 | put_vertical_spread | 2 | 1 | 16000 | 6616000.00 | short | bid | 80.8000 | 0.0500 | ["80","81"] | ["0.1539","0.1546"] | ["80.54"] | ["XPHO"] | 80.0000 | 81.0000 | 99 | 99 | false | false | false | ||||||||||
| 01a090fb-e538-7621-a67d-942e41c38318 | TLT | 2026-09-11 11:00 | put_vertical_spread | 2 | 3 | 160 | 308640.00 | long | ask | 81.1600 | 0.9500 | ["80","95"] | ["0.1851","0.2445"] | ["85.16"] | ["ARCO","XPHO"] | 80.0000 | 95.0000 | 826 | 826 | false | false | false | ||||||||||
| 01a090fb-e538-7621-a67d-941045b93498 | TLT | 2026-09-11 11:00 | put_vertical_spread | 2 | 1 | 76 | 146832.00 | unknown | — | 81.1600 | 0.8000 | ["80","95"] | ["0.1857","0.2446"] | [] | ["XISX"] | 80.0000 | 95.0000 | 826 | 826 | false | false | false | true | false | ||||||||
| 01a0a02f-5058-75c2-aed9-d0b0ecf6feea | TLT | 2026-09-14 09:50 | put_vertical_spread | 2 | 6 | 175 | 124948.00 | unknown | — | 80.7550 | 0.1200 | ["80","85"] | ["0.1496","0.1728"] | [] | ["EMLD","MCRY","XBOX","XISX","XMIO","XPHO"] | 80.0000 | 85.0000 | 123 | 123 | false | false | false | true | false | ||||||||
| 01a0a141-9b18-7eb1-a6ca-b08bf33543f4 | TLT | 2026-09-14 14:50 | put_vertical_spread | 2 | 1 | 490 | 111230.00 | short | bid | 81.1750 | 0.0200 | ["80","82"] | ["0.1335","0.1368"] | ["81.07"] | ["XPHO"] | 80.0000 | 82.0000 | 32 | 32 | false | false | false | ||||||||||
| 01a0a569-00c6-7ad3-ae8f-c5f18b85dc63 | TLT | 2026-09-15 10:11 | put_vertical_spread | 2 | 1 | 350 | 321300.00 | short | bid | 80.5850 | 0.2500 | ["80","82"] | ["0.1798","0.1840"] | ["81.04"] | ["SPHR"] | 80.0000 | 82.0000 | 493 | 493 | false | false | false | ||||||||||
| 01a0a570-ec1e-74d0-ba68-f56363fde841 | TLT | 2026-09-15 10:20 | put_vertical_spread | 2 | 1 | 500 | 546500.00 | unknown | — | 80.6499 | 0.8500 | ["81","83"] | ["0.1859","0.1897"] | [] | ["SPHR"] | 81.0000 | 83.0000 | 640 | 640 | false | false | false | true | false | ||||||||
| 01a0a578-8956-73a1-9b26-17388b0c8da1 | TLT | 2026-09-15 10:28 | put_vertical_spread | 2 | 3 | 388 | 134246.00 | short | bid | 80.6050 | 0.0200 | ["80","81"] | ["0.1506","0.1509"] | ["80.54"] | ["AMXO","XCBO","XISX"] | 80.0000 | 81.0000 | 66 | 66 | false | false | false | ||||||||||
| 01a0a5c6-47ae-71c3-a1c6-f014ec3bec59 | TLT | 2026-09-15 11:53 | put_vertical_spread | 2 | 2 | 485 | 102335.00 | short | bid | 80.7950 | 0.0300 | ["80","81"] | ["0.1400","0.1392"] | ["80.57"] | ["XBOX","XISX"] | 80.0000 | 81.0000 | 31 | 31 | false | false | false | ||||||||||
| 01a0ab08-fa6b-7140-be32-71364fb9e1fc | TLT | 2026-09-16 12:24 | put_vertical_spread | 2 | 1 | 150 | 214500.00 | long | ask | 81.0850 | 2.8000 | ["79","89"] | ["0.1858","0.2156"] | ["83.50"] | ["ARCO"] | 79.0000 | 89.0000 | 856 | 856 | true | false | false | ||||||||||
| 01a0ab08-fa6b-7140-be32-714d905d9d56 | TLT | 2026-09-16 12:24 | put_vertical_spread | 2 | 1 | 150 | 222600.00 | unknown | — | 81.0850 | 0.6500 | ["78","90"] | ["0.1869","0.2223"] | [] | ["ARCO"] | 78.0000 | 90.0000 | 856 | 856 | true | false | false | true | false | ||||||||
| 01a0ab09-11db-7d01-9df8-9977c508c98a | TLT | 2026-09-16 12:24 | put_vertical_spread | 2 | 1 | 150 | 222900.00 | short | bid | 81.0850 | 0.6500 | ["78","90"] | ["0.1879","0.2219"] | ["83.46"] | ["XISX"] | 78.0000 | 90.0000 | 856 | 856 | false | false | false | ||||||||||
| 01a0ab09-294b-7a21-ad6b-038d81c02ac8 | TLT | 2026-09-16 12:24 | put_vertical_spread | 2 | 1 | 150 | 217650.00 | short | bid | 81.0800 | 1.1500 | ["79","89"] | ["0.1889","0.2172"] | ["83.55"] | ["XISX"] | 79.0000 | 89.0000 | 856 | 856 | false | false | false | ||||||||||
| 01a0ab09-3503-7ff3-b68d-2b10736f8739 | TLT | 2026-09-16 12:25 | put_vertical_spread | 2 | 1 | 250 | 425000.00 | long | ask | 81.0800 | 3.8000 | ["82","89"] | ["0.2075","0.2296"] | ["84.84"] | ["ARCO"] | 82.0000 | 89.0000 | 856 | 856 | false | false | false | ||||||||||
| 01a0ab09-505a-7e71-83c3-b5e46a21dd6b | TLT | 2026-09-16 12:25 | put_vertical_spread | 2 | 1 | 250 | 407750.00 | unknown | — | 81.0750 | 2.0000 | ["82","89"] | ["0.2002","0.2219"] | [] | ["AMXO"] | 82.0000 | 89.0000 | 856 | 856 | false | false | false | true | false | ||||||||
| 01a0afa8-c14a-7b21-b308-a077d91d4c32 | TLT | 2026-09-17 09:57 | put_vertical_spread | 2 | 4 | 5000 | 990648.00 | short | bid | 81.5800 | 0.0293 | ["75","80"] | ["0.1519","0.1456"] | ["78.90"] | ["XISX"] | 75.0000 | 80.0000 | 120 | 120 | false | true | false | ||||||||||
| 01a0afbd-f6fa-7b21-964e-21e090201daa | TLT | 2026-09-17 10:20 | put_vertical_spread | 2 | 1 | 80 | 154960.00 | unknown | — | 81.6100 | 0.9500 | ["85","93"] | ["0.1968","0.2330"] | [] | ["ARCO"] | 85.0000 | 93.0000 | 820 | 820 | false | false | false | true | false | ||||||||
| 01a0afbe-357b-7040-b0d9-7874fae98945 | TLT | 2026-09-17 10:21 | put_vertical_spread | 2 | 2 | 198 | 406296.00 | long | ask | 81.6059 | 0.9000 | ["84","95"] | ["0.1938","0.2454"] | ["87.17"] | ["ARCO","XCBO"] | 84.0000 | 95.0000 | 820 | 820 | false | false | false | ||||||||||
| 01a0afbe-3963-7000-bb21-dfa06a52fd5b | TLT | 2026-09-17 10:21 | put_vertical_spread | 2 | 1 | 99 | 194535.00 | long | ask | 81.6059 | 0.9000 | ["84","94"] | ["0.1937","0.2390"] | ["87.03"] | ["ARCO"] | 84.0000 | 94.0000 | 820 | 820 | false | false | false | ||||||||||
| 01a0afbe-58a3-7291-9ae9-fffe9a7bf958 | TLT | 2026-09-17 10:21 | put_vertical_spread | 2 | 1 | 99 | 194733.00 | long | ask | 81.6101 | 0.9500 | ["84","94"] | ["0.1944","0.2388"] | ["87.07"] | ["AMXO"] | 84.0000 | 94.0000 | 820 | 820 | false | false | false | ||||||||||
| 01a0afdd-cf52-7cc2-88e2-9503e0811766 | TLT | 2026-09-17 10:55 | put_vertical_spread | 2 | 2 | 50 | 102775.00 | long | ask | 81.5200 | 0.8250 | ["84","95"] | ["0.1930","0.2454"] | ["87.12"] | ["ARCO","XPHO"] | 84.0000 | 95.0000 | 820 | 820 | false | false | false | ||||||||||
| 01a0b0a3-461b-7bd1-8e16-5f748a3475ed | TLT | 2026-09-17 14:31 | put_vertical_spread | 2 | 1 | 4748 | 2193576.00 | unknown | — | 81.6450 | 0.1800 | ["83","85"] | ["0.2360","0.4909"] | [] | ["XBOX"] | 83.0000 | 85.0000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a0b0a3-7113-7b11-8577-d32a7dacb044 | TLT | 2026-09-17 14:31 | put_vertical_spread | 2 | 1 | 758 | 538180.00 | unknown | — | 81.6500 | 0.1800 | ["83.5","87"] | ["0.2894","0.7168"] | [] | ["XBOX"] | 83.5000 | 87.0000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a0b4f2-9327-7a23-9e89-43fe594eb8c3 | TLT | 2026-09-18 10:36 | put_vertical_spread | 2 | 2 | 30000 | 1290000.00 | unknown | ask | 81.1700 | 0.0200 | ["77","79"] | ["0.1422","0.1294"] | ["78.57"] | ["AMXO"] | 77.0000 | 79.0000 | 28 | 28 | false | true | false | ||||||||||
| 01a0ca50-a046-7ed2-97da-922cf784c2f6 | TLT | 2026-09-22 14:11 | put_vertical_spread | 2 | 1 | 250 | 210000.00 | unknown | bid | 81.8250 | 0.9000 | ["81","82"] | ["0.1717","0.1727"] | ["77.30"] | ["XBOX"] | 81.0000 | 82.0000 | 633 | 633 | false | false | false |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T18:25:12Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T13:36:39Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:51:56Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:00:45Z"} |
| 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:00:45Z"} |
| 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-14T13:51:00Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T18:50:58Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:11:58Z"} |
| 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 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:29:06Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:54:09Z"} |
| 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-16T16:25: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-16T16:25:43Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:25:43Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:25:43Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:25: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-16T16:25:43Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:58:01Z"} |
| 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:21:16Z"} |
| 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-17T14:21:16Z"} |
| 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-17T14:21:16Z"} |
| 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-17T14:21:33Z"} |
| 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-17T14:56: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:31:45Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:36:47Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:11:57Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |