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 |
|---|
| 01a0cfa9-723f-7c52-8d1a-dc7c30162872 | TLT | 2026-09-23 15:06 | synthetic | 2 | 2 | 300 | 162600.00 | long | ask | 80.4150 | 0.0600 | ["80"] | ["0.1163"] | ["80.34"] | ["C2OX"] | 80.0000 | 80.0000 | 177 | 177 | false | false | false | false | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-23T19:06:47Z"} | 2026-09-23 | 2026-09-23 17:15 | 2026-09-23 17:15 |
| 01a0cfa9-723f-7c52-8d1a-dc674e00016f | TLT | 2026-09-23 15:06 | synthetic | 2 | 1 | 300 | 162600.00 | long | ask | 80.4150 | 0.0600 | ["80"] | ["0.1163"] | ["80.34"] | ["XCBO"] | 80.0000 | 80.0000 | 177 | 177 | false | false | false | false | |||||||||
| 01a0cfa7-ad1f-7b42-8508-984dfe606b41 | TLT | 2026-09-23 15:04 | synthetic | 2 | 1 | 500 | 271000.00 | long | ask | 80.3750 | 0.0400 | ["80"] | ["0.1166"] | ["80.30"] | ["XMIO"] | 80.0000 | 80.0000 | 177 | 177 | false | false | false | false | |||||||||
| 01a0cfa7-ad1f-7b42-8508-9824ef6be508 | TLT | 2026-09-23 15:04 | synthetic | 2 | 2 | 190 | 102980.00 | long | ask | 80.3750 | 0.0400 | ["80"] | ["0.1166"] | ["80.30"] | ["BATO"] | 80.0000 | 80.0000 | 177 | 177 | false | false | false | false | |||||||||
| 01a0cfa6-93df-7ac2-8c6e-63b53c1bad38 | TLT | 2026-09-23 15:03 | synthetic | 2 | 1 | 250 | 136000.00 | long | ask | 80.3799 | 0.0600 | ["80"] | ["0.1170"] | ["80.30"] | ["SPHR"] | 80.0000 | 80.0000 | 177 | 177 | false | false | false | false | |||||||||
| 01a0cfa5-6ee6-7630-8b46-e2fec9f8d083 | TLT | 2026-09-23 15:01 | synthetic | 2 | 1 | 473 | 256843.00 | long | ask | 80.3700 | 0.0600 | ["80"] | ["0.1168"] | ["80.29"] | ["XMIO"] | 80.0000 | 80.0000 | 177 | 177 | false | false | false | false | |||||||||
| 01a0cfa4-51be-77f1-8bb8-2b976665b4bc | TLT | 2026-09-23 15:00 | synthetic | 2 | 1 | 250 | 136000.00 | long | ask | 80.3899 | 0.0600 | ["80"] | ["0.1169"] | ["80.30"] | ["XMIO"] | 80.0000 | 80.0000 | 177 | 177 | false | false | false | false | |||||||||
| 01a0cfa4-4dd7-7922-85e9-52d2573fc8fd | TLT | 2026-09-23 15:00 | synthetic | 2 | 1 | 250 | 136000.00 | long | ask | 80.3899 | 0.0600 | ["80"] | ["0.1169"] | ["80.30"] | ["XPHO"] | 80.0000 | 80.0000 | 177 | 177 | 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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-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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:06:47Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:04:33Z"} |
| 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:04:33Z"} |
| 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:03:23Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:02:41Z"} |
| 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-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-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 |
| 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 |
| 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:22:02Z"} |
| 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 |
| 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 |
| 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: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:52:25Z"} |
| 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:52:25Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |