core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg473,794 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 |
|---|
| 01a0d4fb-79ef-79e0-9e7c-f6ed69d328ea | TLT | 2026-09-24 15:54 | call_vertical_spread | 2 | 1 | 200 | 110200.00 | unknown | bid | 79.4450 | 0.1800 | ["76.5","77"] | ["0.1995","0.1839"] | ["79.50"] | ["XCBO"] | 76.5000 | 77.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T19:54:21Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0d4fb-27e7-76e1-9495-2c7d59084d24 | TLT | 2026-09-24 15:53 | call_vertical_spread | 2 | 1 | 200 | 110200.00 | unknown | bid | 79.4450 | 0.1800 | ["76.5","77"] | ["0.1995","0.1839"] | ["79.50"] | ["XCBO"] | 76.5000 | 77.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0d4fb-0c8f-7b03-ac74-6ec121881b72 | TLT | 2026-09-24 15:53 | call_vertical_spread | 2 | 1 | 200 | 110200.00 | unknown | bid | 79.4450 | 0.1800 | ["76.5","77"] | ["0.1995","0.1839"] | ["79.50"] | ["XCBO"] | 76.5000 | 77.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0d4fa-f137-78f1-80a5-388611284fd7 | TLT | 2026-09-24 15:53 | call_vertical_spread | 2 | 1 | 200 | 110200.00 | unknown | bid | 79.4450 | 0.1800 | ["76.5","77"] | ["0.1995","0.1839"] | ["79.50"] | ["XCBO"] | 76.5000 | 77.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0d4f4-abbf-74c2-9319-9e60db4de706 | TLT | 2026-09-24 15:46 | call_vertical_spread | 2 | 1 | 200 | 110800.00 | unknown | bid | 79.4587 | 0.2100 | ["76.5","77"] | ["0.2098","0.1801"] | ["79.52"] | ["XCBO"] | 76.5000 | 77.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0d4f4-944f-7070-8a05-55641cd07462 | TLT | 2026-09-24 15:46 | call_vertical_spread | 2 | 1 | 200 | 110800.00 | unknown | bid | 79.4550 | 0.2100 | ["76.5","77"] | ["0.2147","0.1845"] | ["79.52"] | ["XCBO"] | 76.5000 | 77.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0d4f4-7cdf-7900-bcca-65096894f9cb | TLT | 2026-09-24 15:46 | call_vertical_spread | 2 | 1 | 200 | 110800.00 | unknown | bid | 79.4550 | 0.2100 | ["76.5","77"] | ["0.2147","0.1845"] | ["79.52"] | ["XCBO"] | 76.5000 | 77.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0d4f3-d8cf-7732-ae26-57f93f3eeecd | TLT | 2026-09-24 15:45 | call_vertical_spread | 2 | 1 | 200 | 110800.00 | unknown | bid | 79.4700 | 0.2100 | ["76.5","77"] | ["0.1920","0.1641"] | ["79.52"] | ["XCBO"] | 76.5000 | 77.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0d4cc-f7af-7c21-805b-3c85fc7b3f1c | TLT | 2026-09-24 15:03 | call_vertical_spread | 2 | 1 | 200 | 115600.00 | unknown | bid | 79.5800 | 0.1900 | ["76.5","77"] | ["0.2146","0.1853"] | ["79.64"] | ["XCBO"] | 76.5000 | 77.0000 | 4 | 4 | false | false | false | 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 | |||||||||
| 01a0d453-6a7f-7f41-8522-a4c034c86fdb | TLT | 2026-09-24 12:50 | iron_condor | 4 | 1 | 398 | 160394.00 | unknown | bid | 79.9950 | 0.0800 | ["77","78","84","85"] | ["0.1585","0.1587","0.1022","0.1062"] | ["76.06"] | ["XCBO"] | 77.0000 | 85.0000 | 113 | 113 | false | true | false | 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 | |||||||||
| 01a0d3a5-c177-7822-86c5-1702f538246a | TLT | 2026-09-24 09:40 | call_ladder | 3 | 1 | 12000 | 595000.00 | unknown | bid | 80.4200 | 0.0300 | ["85","90","92"] | ["0.1032","0.1272","0.1389"] | ["85.85"] | ["XMIO"] | 85.0000 | 92.0000 | 98 | 98 | false | true | false | true | |||||||||
| 01a0cfda-9077-7eb2-bd5f-311f64c00482 | TLT | 2026-09-23 16:00 | call_calendar | 2 | 1 | 9500 | 157500.00 | unknown | bid | 80.4650 | 0.0200 | ["82"] | ["0.1466"] | [] | ["XCBO"] | 82.0000 | 82.0000 | 2 | 9 | false | true | true | false | |||||||||
| 01a0cfa4-133f-70a0-a73a-20154784ea3c | TLT | 2026-09-23 15:00 | iron_condor | 4 | 1 | 307 | 143983.00 | unknown | bid | 80.3800 | 0.0500 | ["80","81"] | ["0.1246","0.1266"] | ["81.84"] | ["AMXO"] | 80.0000 | 81.0000 | 30 | 30 | false | false | false | true | |||||||||
| 01a0cfa0-718f-7871-b160-fbc4c783cba0 | TLT | 2026-09-23 14:56 | iron_condor | 4 | 1 | 315 | 148995.00 | unknown | bid | 80.3100 | 0.0700 | ["80","81"] | ["0.1259","0.1279"] | ["79.44"] | ["C2OX"] | 80.0000 | 81.0000 | 30 | 30 | false | false | false | true | |||||||||
| 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 | true | |||||||||
| 01a0ca48-c876-7132-8010-0dab09e2d1a0 | TLT | 2026-09-22 14:02 | call_diagonal_spread | 2 | 1 | 175 | 220150.00 | unknown | bid | 81.7762 | 0.2600 | ["70","82"] | ["0.1162","0.1181"] | [] | ["XISX"] | 70.0000 | 82.0000 | 3 | 486 | false | false | true | true | |||||||||
| 01a0c9b9-8c7f-7f42-82ac-3d20e1c4cd3d | TLT | 2026-09-22 11:26 | call_diagonal_spread | 2 | 1 | 164 | 205164.00 | unknown | bid | 81.6990 | 0.2600 | ["70","82"] | ["0.1111","0.1219"] | [] | ["BATO"] | 70.0000 | 82.0000 | 3 | 486 | false | false | true | true | |||||||||
| 01a0c46b-c2bf-7dd2-95ee-53e39d887c38 | TLT | 2026-09-21 10:43 | call_vertical_spread | 2 | 2 | 156 | 111072.00 | unknown | bid | 81.7150 | 0.2000 | ["82","85"] | ["0.1154","0.0476"] | ["87.06"] | ["C2OX","XISX"] | 82.0000 | 85.0000 | 487 | 487 | false | true | false | ||||||||||
| 01a0b61a-bf78-7562-909f-62590a6c3e75 | TLT | 2026-09-18 15:59 | call_diagonal_spread | 2 | 1 | 4500 | 184500.00 | unknown | bid | 81.2200 | 0.0400 | ["81","82"] | ["12.5908","0.1000"] | [] | ["XCBO"] | 81.0000 | 82.0000 | 0 | 7 | false | false | true | true | |||||||||
| 01a0b4bd-bfb8-7b70-9643-0dd08e7ffa6c | TLT | 2026-09-18 09:38 | call_vertical_spread | 2 | 1 | 100 | 121800.00 | unknown | bid | 81.3740 | 4.1100 | ["77","90"] | ["0.1269","0.0618"] | ["89.18"] | ["ARCO"] | 77.0000 | 90.0000 | 854 | 854 | false | false | false | true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:53:58Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:53:58Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:53:31Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:46:46Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:46:46Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:46:46Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:45:47Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:03:40Z"} |
| 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: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 |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:50:30Z"} |
| 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 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T13:41:03Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T20:01:30Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:01:07Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T18:56:41Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| 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 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:02:49Z"} |
| 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:26:48Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:43:20Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T20:00:17Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:39:02Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |