core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg677,480 rows| 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 |
|---|
| 01a0fe2e-a040-7922-9d5d-4491fe36351a | TLT | 2026-10-02 15:54 | synthetic | 2 | 1 | 800 | 104800.00 | long | bid | 77.3650 | 0.0400 | ["78"] | ["0.1428"] | ["77.45"] | ["XPHO"] | 78.0000 | 78.0000 | 7 | 7 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-10-02T19:54:37Z"} | 2026-10-02 | 2026-10-02 17:15 | 2026-10-02 17:15 |
| 01a0f338-1796-77f2-a5bb-939c12ac8514 | TLT | 2026-09-30 12:48 | synthetic | 2 | 2 | 800 | 242000.00 | long | bid | 77.6650 | 0.0550 | ["78"] | ["0.1702"] | ["77.66"] | ["AMXO"] | 78.0000 | 78.0000 | 30 | 30 | false | false | false | false | |||||||||
| 01a0ee61-ac6f-70e3-83d0-34e2379e43fb | TLT | 2026-09-29 14:16 | synthetic | 2 | 1 | 7000 | 2002000.00 | long | bid | 78.0450 | 0.0700 | ["80"] | ["0.1795"] | ["77.90"] | ["AMXO"] | 80.0000 | 80.0000 | 17 | 17 | false | false | false | false | |||||||||
| 01a0edd7-6217-74c0-bc47-f571638a73f5 | TLT | 2026-09-29 11:45 | synthetic | 2 | 1 | 525 | 546000.00 | long | bid | 78.0278 | 0.8000 | ["80"] | ["0.1142"] | ["78.58"] | ["XPHO"] | 80.0000 | 80.0000 | 626 | 626 | false | false | false | false | |||||||||
| 01a0d90c-00ef-74a1-9e22-b81b5449f2ae | TLT | 2026-09-25 10:50 | synthetic | 2 | 5 | 206 | 105884.00 | short | bid | 78.8900 | 0.0307 | ["78"] | ["0.1418"] | ["78.66"] | ["ARCO","BATO","C2OX","EMLD"] | 78.0000 | 78.0000 | 112 | 112 | false | false | false | false | |||||||||
| 01a0b019-9803-7792-978d-e39d7c112506 | TLT | 2026-09-17 12:01 | synthetic | 2 | 1 | 198 | 105732.00 | short | bid | 81.6800 | 0.0200 | ["81"] | ["0.1071"] | ["81.58"] | ["XISX"] | 81.0000 | 81.0000 | 183 | 183 | false | false | false | false | |||||||||
| 01a0b019-9803-7792-978d-e3893c6396a5 | TLT | 2026-09-17 12:01 | synthetic | 2 | 1 | 218 | 116412.00 | short | bid | 81.6800 | 0.0405 | ["81"] | ["0.1071"] | ["81.58"] | ["XISX"] | 81.0000 | 81.0000 | 183 | 183 | false | false | false | false | |||||||||
| 01a0aff5-1843-79e1-b4a5-2ad6a0bfd222 | TLT | 2026-09-17 11:21 | synthetic | 2 | 1 | 331 | 176754.00 | short | bid | 81.7200 | 0.0900 | ["81"] | ["0.1067"] | ["81.62"] | ["AMXO"] | 81.0000 | 81.0000 | 183 | 183 | false | false | false | false | |||||||||
| 01a0aff5-00d2-7d30-aa3d-029e29970588 | TLT | 2026-09-17 11:21 | synthetic | 2 | 1 | 401 | 214134.00 | short | bid | 81.7200 | 0.0900 | ["81"] | ["0.1067"] | ["81.62"] | ["XCBO"] | 81.0000 | 81.0000 | 183 | 183 | false | false | false | false | |||||||||
| 01a0a037-dfc1-7643-9abd-6034acaee4c0 | TLT | 2026-09-14 10:00 | synthetic | 2 | 1 | 426 | 385100.00 | long | bid | 80.7350 | 0.2200 | ["89"] | ["0.1673"] | ["80.58"] | ["XMIO"] | 89.0000 | 89.0000 | 123 | 123 | false | false | false | false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-30T16:49:37Z"} |
| 2026-09-30 |
| 2026-09-30 17:15 |
| 2026-09-30 17:15 |
| mlct |
| 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 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T15:45:39Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T14:51:14Z"} |
| 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-17T16:01:25Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mesl |
| 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 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:21:15Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:21:15Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:00:10Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |