core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg508,354 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 |
|---|
| 01a0a0b5-7430-7572-9d95-06f10d07fefe | META | 2026-09-14 12:17 | synthetic | 2 | 1 | 2 | 25080.00 | short | bid | 661.4800 | 1.3500 | ["630"] | ["0.4074"] | ["669.50"] | ["XBOX"] | 630.0000 | 630.0000 | 123 | 123 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:17:21Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0b4-4f38-7e20-bb6b-cf838570b5d7 | META | 2026-09-14 12:16 | synthetic | 2 | 2 | 2 | 25070.00 | short | bid | 661.1200 | 1.4000 | ["630"] | ["0.4076"] | ["669.25"] | ["XBOX"] | 630.0000 | 630.0000 | 123 | 123 | false | false | false | false | true | ||||||||
| 01a0a0b3-ed90-7a20-8088-8990be600eb5 | META | 2026-09-14 12:15 | synthetic | 2 | 1 | 2 | 25050.00 | short | bid | 660.6337 | 1.9500 | ["630"] | ["0.4077"] | ["668.75"] | ["XBOX"] | 630.0000 | 630.0000 | 123 | 123 | false | false | false | false | true | ||||||||
| 01a0a0b3-7c48-7152-b034-211db66c3628 | META | 2026-09-14 12:15 | synthetic | 2 | 2 | 25 | 312700.00 | short | bid | 660.1600 | 2.2500 | ["630"] | ["0.4076"] | ["667.76"] | ["XBOX","XMIO"] | 630.0000 | 630.0000 | 123 | 123 | false | false | false | false | true | ||||||||
| 01a0a0ae-2130-7491-aa66-eff8e990410b | META | 2026-09-14 12:09 | synthetic | 2 | 2 | 20 | 248740.00 | short | bid | 658.1500 | 1.7000 | ["630"] | ["0.4071"] | ["666.82"] | ["C2OX","XBOX"] | 630.0000 | 630.0000 | 123 | 123 | false | false | false | false | true | ||||||||
| 01a0a0ae-1960-7763-a519-b4713c93909e | META | 2026-09-14 12:09 | synthetic | 2 | 2 | 50 | 621700.00 | unknown | — | 658.0000 | 2.2500 | ["630"] | ["0.4073"] | [] | ["ARCO","XBOX"] | 630.0000 | 630.0000 | 123 | 123 | false | false | false | false | true | mlet | |||||||
| 01a0a0aa-7b98-7c13-ba6a-d4602122a9f9 | META | 2026-09-14 12:05 | synthetic | 2 | 1 | 60 | 148260.00 | short | bid | 659.6000 | 0.9000 | ["650"] | ["0.4279"] | ["659.67"] | ["XPHO"] | 650.0000 | 650.0000 | 4 | 4 | false | false | false | false | true | ||||||||
| 01a0a073-db38-7240-b96d-3e3b3b633663 | META | 2026-09-14 11:05 | synthetic | 2 | 2 | 3 | 47102.00 | long | ask | 653.0400 | 3.1000 | ["605"] | ["0.4192"] | ["666.50"] | ["C2OX","SPHR"] | 605.0000 | 605.0000 | 186 | 186 | false | false | false | false | true | ||||||||
| 01a09205-d358-7930-a4a6-d69e377cb316 | META | 2026-09-11 15:50 | synthetic | 2 | 1 | 10 | 63620.00 | long | ask | 647.0400 | 2.0000 | ["615"] | ["0.3676"] | ["649.12"] | ["XMIO"] | 615.0000 | 615.0000 | 35 | 35 | false | false | false | false | true | ||||||||
| 01a09126-e120-7490-96fd-bbd0048dfe48 | META | 2026-09-11 11:47 | synthetic | 2 | 1 | 25 | 311625.00 | short | bid | 652.1107 | 1.9000 | ["630"] | ["0.4088"] | ["660.25"] | ["XBOX"] | 630.0000 | 630.0000 | 126 | 126 | false | false | false | false | true | ||||||||
| 01a090ea-9b70-71f0-b85d-35424ff7daaf | META | 2026-09-11 10:41 | synthetic | 2 | 2 | 25 | 314375.00 | short | bid | 653.4242 | 2.0500 | ["630"] | ["0.4115"] | ["661.59"] | ["XBOX","XMIO"] | 630.0000 | 630.0000 | 126 | 126 | false | false | false | false | true | ||||||||
| 01a090b9-1b90-70d0-9f9c-d09c93968b54 | META | 2026-09-11 09:47 | synthetic | 2 | 3 | 18 | 54666.00 | short | ask | 659.9799 | 0.3472 | ["670"] | ["0.4003"] | ["660.39"] | ["MCRY","XISX","XPHO"] | 670.0000 | 670.0000 | 7 | 7 | false | false | false | false | true | ||||||||
| 01a08cb7-ea58-7d31-81a6-15622edbb84b | META | 2026-09-10 15:07 | synthetic | 2 | 1 | 6 | 47599.00 | unknown | — | 645.1100 | 5.6100 | ["570"] | ["0.4233"] | [] | ["XCBO"] | 570.0000 | 570.0000 | 15 | 15 | false | false | false | false | true | mlat | |||||||
| 01a08c22-7888-73f1-ba98-6c3652cbe7be | META | 2026-09-10 12:24 | synthetic | 2 | 1 | 10 | 126700.00 | short | bid | 651.0250 | 1.4500 | ["650"] | ["0.4169"] | ["660.00"] | ["XPHO"] | 650.0000 | 650.0000 | 127 | 127 | false | false | false | false | true | ||||||||
| 01a08ba4-95f8-7dc0-9d0b-645594b5921d | META | 2026-09-10 10:06 | synthetic | 2 | 2 | 27 | 46143.00 | long | ask | 644.4550 | 0.3000 | ["635"] | ["0.5702"] | ["644.73"] | ["SPHR","XPHO"] | 635.0000 | 635.0000 | 1 | 1 | false | false | false | false | true | ||||||||
| 01a08b8b-2640-7c43-b0a3-fc09c3229eac | META | 2026-09-10 09:39 | synthetic | 2 | 1 | 3 | 35805.00 | long | bid | 658.1598 | 2.2500 | ["675"] | ["0.4333"] | ["664.77"] | ["XISX"] | 675.0000 | 675.0000 | 99 | 99 | false | false | false | false | true | ||||||||
| 01a0869f-f6b0-7e51-9e72-6fcac3a0bf03 | META | 2026-09-09 10:43 | synthetic | 2 | 1 | 6 | 54720.00 | long | bid | 645.4100 | 1.7000 | ["700"] | ["0.4187"] | ["699.80"] | ["XISX"] | 700.0000 | 700.0000 | 128 | 128 | false | false | false | false | true | ||||||||
| 01a0868a-24c0-74a2-9bd6-39ed03fd93ae | META | 2026-09-09 10:19 | synthetic | 2 | 4 | 21 | 75285.00 | long | ask | 646.1000 | 0.3500 | ["620"] | ["0.4047"] | ["646.72"] | ["EMLD","XISX","XPHO"] | 620.0000 | 620.0000 | 7 | 7 | false | false | false | false | true | ||||||||
| 01a08665-52f8-7ed2-b145-bef9dbfbfbed | META | 2026-09-09 09:39 | synthetic | 2 | 4 | 2 | 31640.00 | long | ask | 647.1850 | 5.4000 | ["610"] | ["0.4280"] | ["660.00"] | ["C2OX","SPHR"] | 610.0000 | 610.0000 | 191 | 191 | false | false | false | false | true | ||||||||
| 01a081fd-5558-7b63-b2f6-5dd6f2f39ee5 | META | 2026-09-08 13:07 | synthetic | 2 | 2 | 20 | 40040.00 | unknown | — | 618.3491 | 0.3500 | ["625"] | ["0.4301"] | [] | ["XISX"] | 625.0000 | 625.0000 | 3 | 3 | false | false | false | false | true | mlet | |||||||
| 01a06dd3-1695-7063-84f2-63408f28be72 | META | 2026-09-04 15:09 | synthetic | 2 | 1 | 10 | 58850.00 | short | bid | 614.8901 | 0.8000 | ["615"] | ["0.3548"] | ["617.43"] | ["XMIO"] | 615.0000 | 615.0000 | 42 | 42 | false | false | false | false | true |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:16:19Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:15:52Z"} |
| 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-14T16:15:14Z"} |
| 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-14T16:09:30Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:09:30Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:05:30Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:05:43Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:51:00Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:47:44Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:41:37Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T13:47:36Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:07:57Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T16:24:50Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:07:05Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T13:39:12Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:43:47Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:19:58Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:40:00Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:08:18Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:09:09Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |