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 |
|---|
| 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 |
|---|
| 01a08bce-0370-7300-97a0-b109bc3a6969 | TLT | 2026-09-10 10:52 | synthetic | 2 | 2 | 584 | 327624.00 | long | ask | 81.0850 | 0.0600 | ["81"] | ["0.1169"] | ["81.15"] | ["AMXO"] | 81.0000 | 81.0000 | 190 | 190 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:52:25Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bce-0370-7300-97a0-b0fadf9f30db | TLT | 2026-09-10 10:52 | synthetic | 2 | 2 | 238 | 133518.00 | long | ask | 81.0850 | 0.0600 | ["81"] | ["0.1169"] | ["81.15"] | ["AMXO"] | 81.0000 | 81.0000 | 190 | 190 | false | false | false | false | |||||||||
| 01a08bcf-0928-7202-b4df-e80dea45c8df | TLT | 2026-09-10 10:53 | synthetic | 2 | 1 | 425 | 238425.00 | long | ask | 81.0850 | 0.0700 | ["81"] | ["0.1169"] | ["81.15"] | ["C2OX"] | 81.0000 | 81.0000 | 190 | 190 | false | false | false | false | |||||||||
| 01a08bcf-0928-7202-b4df-e7f2e03a54ee | TLT | 2026-09-10 10:53 | synthetic | 2 | 2 | 561 | 314721.00 | long | ask | 81.0850 | 0.0700 | ["81"] | ["0.1169"] | ["81.15"] | ["C2OX"] | 81.0000 | 81.0000 | 190 | 190 | false | false | false | false | |||||||||
| 01a08bd0-12c8-7542-8ddc-adcfc32295c0 | TLT | 2026-09-10 10:54 | synthetic | 2 | 2 | 366 | 204960.00 | long | ask | 81.0750 | 0.0700 | ["81"] | ["0.1167"] | ["81.16"] | ["BATO"] | 81.0000 | 81.0000 | 190 | 190 | false | false | false | false | |||||||||
| 01a08bd0-9b80-7503-8d38-f9b26060790b | TLT | 2026-09-10 10:54 | synthetic | 2 | 1 | 562 | 314720.00 | long | ask | 81.0700 | 0.0600 | ["81"] | ["0.1168"] | ["81.16"] | ["C2OX"] | 81.0000 | 81.0000 | 190 | 190 | false | false | false | false | |||||||||
| 01a08bd0-9b80-7503-8d38-f9a851b605e0 | TLT | 2026-09-10 10:54 | synthetic | 2 | 2 | 395 | 221200.00 | long | ask | 81.0700 | 0.0600 | ["81"] | ["0.1168"] | ["81.16"] | ["C2OX"] | 81.0000 | 81.0000 | 190 | 190 | 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 | |||||||||
| 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 | |||||||||
| 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-d3c3-7562-88fa-8e84ea15de3c | TLT | 2026-09-17 11:21 | synthetic | 2 | 1 | 250 | 133750.00 | long | ask | 81.7050 | 0.0600 | ["81"] | ["0.1072"] | ["81.63"] | ["XCBO"] | 81.0000 | 81.0000 | 183 | 183 | false | false | false | false | |||||||||
| 01a0aff6-7003-7453-9c90-8f16237d9fe5 | TLT | 2026-09-17 11:22 | synthetic | 2 | 1 | 250 | 133500.00 | long | ask | 81.6850 | 0.0500 | ["81"] | ["0.1072"] | ["81.62"] | ["XMIO"] | 81.0000 | 81.0000 | 183 | 183 | false | false | false | false | |||||||||
| 01a0aff6-b26b-7861-aca1-13bdd3cd6cff | TLT | 2026-09-17 11:22 | synthetic | 2 | 1 | 250 | 133500.00 | long | ask | 81.6870 | 0.0500 | ["81"] | ["0.1072"] | ["81.62"] | ["XMIO"] | 81.0000 | 81.0000 | 183 | 183 | false | false | false | false | |||||||||
| 01a0aff6-fca3-7971-9d58-97f25a572dbc | TLT | 2026-09-17 11:23 | synthetic | 2 | 1 | 500 | 267000.00 | long | ask | 81.6750 | 0.0600 | ["81"] | ["0.1073"] | ["81.62"] | ["XMIO"] | 81.0000 | 81.0000 | 183 | 183 | false | false | false | false | |||||||||
| 01a0aff7-102b-7691-b2d7-8e5280173787 | TLT | 2026-09-17 11:23 | synthetic | 2 | 1 | 500 | 267000.00 | long | ask | 81.6800 | 0.0500 | ["81"] | ["0.1072"] | ["81.62"] | ["XMIO"] | 81.0000 | 81.0000 | 183 | 183 | 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 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:52:25Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:53:45Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:53:45Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:54:29Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:55:10Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:55:10Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 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 |
| 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 |
| 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 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:22:02Z"} |
| 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-17T15:22:46Z"} |
| 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-17T15:23:30Z"} |
| 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-17T15:23:30Z"} |
| 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-17T15:23:30Z"} |
| 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-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 |