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 |
|---|
| 01a0f3da-953f-75c2-8963-9d5975cbf852 | TLT | 2026-09-30 15:46 | other | 4 | 1 | 40 | 114320.00 | unknown | bid | 77.6900 | 0.5500 | ["81","84","85","88"] | ["0.2063","0.3484","0.3839","0.3743"] | [] | ["XISX"] | 81.0000 | 88.0000 | 16 | 30 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-30T19:46:37Z"} | 2026-09-30 | 2026-09-30 17:15 | 2026-09-30 17:15 |
| 01a0f345-b3f7-7702-adde-d5570ab3ddcd | TLT | 2026-09-30 13:03 | other | 2 | 2 | 500 | 193000.00 | unknown | bid | 77.7050 | 0.1000 | ["75","80"] | ["0.1848","0.1153"] | [] | ["ARCO"] | 75.0000 | 80.0000 | 142 | 170 | false | true | true | true | |||||||||
| 01a0f301-fc08-7de2-a56b-2740aee09cb8 | TLT | 2026-09-30 11:49 | other | 4 | 4 | 500 | 602212.00 | unknown | bid | 77.7300 | 0.6300 | ["76","83"] | ["0.5747","0.1459"] | [] | ["ARCO","XBOX","XISX","XPHO"] | 76.0000 | 83.0000 | 0 | 478 | false | false | true | true | |||||||||
| 01a0f2ee-6c37-78e0-8a0b-5db0ad75b2d3 | TLT | 2026-09-30 11:28 | other | 4 | 4 | 500 | 605470.00 | unknown | bid | 77.7350 | 0.4900 | ["76","83"] | ["0.5158","0.1460"] | [] | ["ARCO","MCRY","XBOX","XPHO"] | 76.0000 | 83.0000 | 0 | 478 | false | false | true | true | |||||||||
| 01a0f2eb-3017-7422-a21f-5b920bd4122a | TLT | 2026-09-30 11:24 | other | 4 | 1 | 93 | 112065.00 | unknown | bid | 77.7199 | 0.7700 | ["76","83"] | ["0.6473","0.1461"] | [] | ["ARCO"] | 76.0000 | 83.0000 | 0 | 478 | false | false | true | true | |||||||||
| 01a0f2eb-2c2f-7620-8351-f0d8d5860631 | TLT | 2026-09-30 11:24 | other | 4 | 1 | 377 | 454285.00 | unknown | bid | 77.7199 | 0.7700 | ["76","83"] | ["0.6473","0.1461"] | [] | ["ARCO"] | 76.0000 | 83.0000 | 0 | 478 | false | false | true | true | |||||||||
| 01a0f2e0-23f7-76a1-91c3-68d3eabb8571 | TLT | 2026-09-30 11:12 | other | 3 | 1 | 61 | 117242.00 | unknown | bid | 77.7600 | 0.7000 | ["78","86"] | ["0.1180","0.2270"] | ["77.09"] | ["XBOX"] | 78.0000 | 86.0000 | 478 | 478 | false | false | false | true | |||||||||
| 01a0f2bc-6788-7b42-8770-cc88a73a2cdf | TLT | 2026-09-30 10:33 | other | 3 | 2 | 1000 | 177000.00 | unknown | bid | 77.8650 | 0.0600 | ["72","79","84"] | ["0.1976","0.1927","0.1519"] | ["66.66","77.34"] | ["AMXO"] | 72.0000 | 84.0000 | 51 | 51 | false | false | false | true | |||||||||
| 01a0eea5-1a27-7a40-b881-db40e837e28b | TLT | 2026-09-29 15:29 | other | 3 | 1 | 666 | 281052.00 | unknown | bid | 78.1550 | 0.1400 | ["79","80"] | ["0.1791","0.2238"] | [] | ["XMIO"] | 79.0000 | 80.0000 | 1 | 31 | false | false | true | true | |||||||||
| 01a0ee61-c7c7-77f2-a8a6-6f3dba1687b9 | TLT | 2026-09-29 14:16 | other | 3 | 1 | 250 | 108250.00 | unknown | bid | 78.0500 | 0.1300 | ["79","80"] | ["0.1793","0.2120"] | [] | ["XCBO"] | 79.0000 | 80.0000 | 1 | 31 | false | false | true | true | |||||||||
| 01a0edf0-6857-7762-b1eb-3d7a2c3435e3 | TLT | 2026-09-29 12:12 | other | 3 | 1 | 4200 | 669200.00 | unknown | bid | 77.9850 | 0.0500 | ["79","84","86"] | ["0.1381","0.1460","0.1402"] | [] | ["AMXO"] | 79.0000 | 86.0000 | 52 | 80 | false | true | true | true | |||||||||
| 01a0ed98-70cf-77c3-9ad4-abef9639ec4a | TLT | 2026-09-29 10:36 | other | 4 | 1 | 308 | 418264.00 | unknown | bid | 78.3050 | 0.2200 | ["77","88"] | ["0.2026","0.1585"] | [] | ["XCBO"] | 77.0000 | 88.0000 | 1 | 479 | false | false | true | true | |||||||||
| 01a0ed90-3b3e-7f13-bc69-7f7ea1845a19 | TLT | 2026-09-29 10:27 | other | 4 | 2 | 200 | 271900.00 | unknown | bid | 78.3850 | 0.4800 | ["77","88"] | ["0.2459","0.1576"] | [] | ["XCBO","XISX"] | 77.0000 | 88.0000 | 1 | 479 | false | false | true | true | |||||||||
| 01a0ed88-924f-73d0-89ae-96299e68254b | TLT | 2026-09-29 10:19 | other | 4 | 1 | 100 | 135800.00 | unknown | bid | 78.3350 | 0.2500 | ["77","88"] | ["0.2559","0.1574"] | [] | ["XCBO"] | 77.0000 | 88.0000 | 1 | 479 | false | false | true | true | |||||||||
| 01a0e982-4867-7040-9f0a-c4ffa6003990 | TLT | 2026-09-28 15:33 | other | 4 | 1 | 300 | 134240.00 | unknown | bid | 78.5300 | 0.1700 | ["77","79","79.5","80.5"] | ["0.2206","0.2444","0.2650","0.3300"] | ["77.69"] | ["XCBO"] | 77.0000 | 80.5000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0e92d-6dbf-7763-9019-d5d68f758596 | TLT | 2026-09-28 14:01 | other | 4 | 1 | 204 | 232356.00 | unknown | bid | 78.5950 | 0.4500 | ["78","86"] | ["0.3398","0.1456"] | [] | ["ARCO"] | 78.0000 | 86.0000 | 0 | 480 | false | false | true | true | |||||||||
| 01a0e8f8-0daf-73e1-aa07-d0571d286f49 | TLT | 2026-09-28 13:02 | other | 4 | 4 | 499 | 560383.00 | unknown | bid | 78.4150 | 0.6400 | ["78","86"] | ["0.2330","0.1454"] | [] | ["ARCO","EMLD","XBOX","XPHO"] | 78.0000 | 86.0000 | 0 | 480 | false | false | true | true | |||||||||
| 01a0e8f7-c75f-71a2-8fe2-ccd84f858589 | TLT | 2026-09-28 13:02 | other | 4 | 1 | 100 | 146000.00 | unknown | bid | 78.4099 | 3.2300 | ["75","83","90","93"] | ["0.1427","0.0661","0.0781","0.0984"] | [] | ["XISX"] | 75.0000 | 93.0000 | 480 | 844 | false | false | true | true | |||||||||
| 01a0e8ee-1acf-7370-8a3c-1791bbfa5cc6 | TLT | 2026-09-28 12:51 | other | 4 | 1 | 132 | 149028.00 | unknown | bid | 78.4000 | 0.5800 | ["78","86"] | ["0.2441","0.1464"] | [] | ["ARCO"] | 78.0000 | 86.0000 | 0 | 480 | false | false | true | true | |||||||||
| 01a0e8ee-16e7-7e82-ac02-6b805e7abfc7 | TLT | 2026-09-28 12:51 | other | 4 | 1 | 326 | 368054.00 | unknown | bid | 78.4000 | 0.5800 | ["78","86"] | ["0.2441","0.1464"] | [] | ["ARCO"] | 78.0000 | 86.0000 | 0 | 480 | false | false | true | true | |||||||||
| 01a0e889-8c9f-7f62-86f4-bf045e1ce569 | TLT | 2026-09-28 11:02 | other | 4 | 2 | 148 | 167462.00 | unknown | bid | 78.3061 | 0.6500 | ["78","86"] | ["0.2094","0.1475"] | [] | ["ARCO","XCBO"] | 78.0000 | 86.0000 | 0 | 480 | false | false | true | true | |||||||||
| 01a0da10-3a1f-79d3-88d2-ec481ba55888 | TLT | 2026-09-25 15:34 | other | 4 | 1 | 750 | 194100.00 | unknown | bid | 79.2550 | 0.1200 | ["78.5","79","80","81"] | ["0.8480","0.1696","0.9093","0.1881"] | [] | ["XISX"] | 78.5000 | 81.0000 | 0 | 14 | false | false | true | true | |||||||||
| 01a0da0e-4a07-7d42-908a-e262b965d113 | TLT | 2026-09-25 15:32 | other | 4 | 1 | 740 | 343670.00 | unknown | bid | 79.2400 | 0.2200 | ["79","79.5","81"] | ["0.1683","0.5124","1.0235"] | [] | ["XISX"] | 79.0000 | 81.0000 | 0 | 12 | false | false | true | true | |||||||||
| 01a0d95f-ce0f-7ae0-9332-6343fe33b7fa | TLT | 2026-09-25 12:22 | other | 6 | 1 | 3657 | 1070225.00 | unknown | bid | 79.2250 | 0.1100 | ["74","75","76","79","80"] | ["0.1834","0.1750","0.1742","0.2599","0.1538"] | [] | ["EDGO"] | 74.0000 | 80.0000 | 0 | 84 | false | false | true | true | |||||||||
| 01a0d935-1c5f-74e1-b99a-500e70c794d8 | TLT | 2026-09-25 11:35 | other | 3 | 1 | 12500 | 7935000.00 | unknown | bid | 79.0850 | 0.1100 | ["75","79"] | ["0.1786","0.1386"] | [] | ["AMXO"] | 75.0000 | 79.0000 | 112 | 357 | true | false | true | true | |||||||||
| 01a0d904-a237-7772-95dc-65103a287832 | TLT | 2026-09-25 10:42 | other | 2 | 7 | 500 | 296436.00 | unknown | bid | 78.9000 | 0.0800 | ["78","80"] | ["0.1031","0.1891"] | [] | ["ARCO","BATO","C2OX","EDGO","EMLD","SPHR","XPHO"] | 78.0000 | 80.0000 | 84 | 112 | false | false | true | true | |||||||||
| 01a0d8ed-3def-7001-bdac-419a05ba09bd | TLT | 2026-09-25 10:16 | other | 4 | 1 | 10000 | 3340000.00 | unknown | bid | 79.0000 | 0.1100 | ["75","78","79","81"] | ["0.2004","0.1849","0.1577","0.1443"] | [] | ["AMXO"] | 75.0000 | 81.0000 | 5 | 14 | false | false | true | true | |||||||||
| 01a0d4b6-79df-7571-b1e4-79b7200b5b9e | TLT | 2026-09-24 14:38 | other | 4 | 1 | 5232 | 2155308.00 | unknown | bid | 79.7300 | 0.3800 | ["81.5","82","82.5"] | ["0.3172","0.3964","0.3844"] | [] | ["XBOX"] | 81.5000 | 82.5000 | 1 | 4 | false | false | true | true | |||||||||
| 01a0d4b5-e187-7563-8025-701067feaa26 | TLT | 2026-09-24 14:38 | other | 4 | 1 | 3872 | 2023296.00 | unknown | bid | 79.6787 | 0.3800 | ["81.5","83","85"] | ["0.2713","0.2180","0.3186"] | [] | ["XBOX"] | 81.5000 | 85.0000 | 1 | 6 | false | false | true | true | |||||||||
| 01a0d46b-5b66-7a91-917c-de852b101464 | TLT | 2026-09-24 13:16 | other | 4 | 3 | 108 | 158306.00 | unknown | bid | 79.9850 | 2.1500 | ["77","78"] | ["0.1903","0.1933"] | [] | ["EDGO","MCRY"] | 77.0000 | 78.0000 | 813 | 848 | false | true | true | true | |||||||||
| 01a0d3fe-3217-7351-9c2d-3b35bd7521d3 | TLT | 2026-09-24 11:17 | other | 3 | 1 | 10000 | 2885000.00 | unknown | bid | 79.8400 | 0.1300 | ["77","83"] | ["0.1582","0.1458"] | ["73.89","80.11","85.89"] | ["AMXO"] | 77.0000 | 83.0000 | 57 | 57 | false | false | false | true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-30T17:04:10Z"} |
| 2026-09-30 |
| 2026-09-30 17:15 |
| 2026-09-30 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-30T15:49:47Z"} |
| 2026-09-30 |
| 2026-09-30 17:15 |
| 2026-09-30 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-30T15:28:46Z"} |
| 2026-09-30 |
| 2026-09-30 17:15 |
| 2026-09-30 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-30T15:25:04Z"} |
| 2026-09-30 |
| 2026-09-30 17:15 |
| 2026-09-30 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-30T15:25:04Z"} |
| 2026-09-30 |
| 2026-09-30 17:15 |
| 2026-09-30 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-30T15:12:51Z"} |
| 2026-09-30 |
| 2026-09-30 17:15 |
| 2026-09-30 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-30T14:34:10Z"} |
| 2026-09-30 |
| 2026-09-30 17:15 |
| 2026-09-30 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T19:29:52Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T18:16:46Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T16:12:35Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T14:36:48Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T14:27:46Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T14:19:27Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T19:33:57Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T18:01:41Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T17:03:30Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T17:02:30Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T16:52:00Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T16:52:00Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T15:02:35Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T19:35:11Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T19:32:47Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T16:22:25Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T15:35:40Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T14:42:42Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T14:17:06Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:39:01Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:38:39Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T17:16:50Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:17:45Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |