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 | 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 |
|---|
| 01a0d500-d506-7041-b2bc-1ff5a8f2af32 | IWM | 2026-09-24 15:59 | synthetic | 2 | 1 | 15 | 26460.00 | long | ask | 281.6600 | 0.1700 | ["280"] | ["0.1975"] | ["283.38"] | ["C2OX"] | 280.0000 | 280.0000 | 57 | 57 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T20:00:03Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0d4fe-7f5f-7b92-914e-a3ba8bbbcdbb | IWM | 2026-09-24 15:57 | synthetic | 2 | 2 | 24 | 42336.00 | long | ask | 281.7650 | 0.1300 | ["280"] | ["0.1973"] | ["283.44"] | ["C2OX","EDGO"] | 280.0000 | 280.0000 | 57 | 57 | false | false | false | false | |||||||||
| 01a0d4fc-cdc6-77b3-a282-2800e82ea00a | IWM | 2026-09-24 15:55 | synthetic | 2 | 1 | 16 | 28224.00 | long | ask | 281.6950 | 0.1400 | ["280"] | ["0.1974"] | ["283.40"] | ["C2OX"] | 280.0000 | 280.0000 | 57 | 57 | false | false | false | false | |||||||||
| 01a0ca1b-f3e7-79e0-bf75-4f4543029bef | IWM | 2026-09-22 13:13 | synthetic | 2 | 2 | 13 | 26520.00 | long | bid | 286.8926 | 0.0400 | ["290"] | ["0.1825"] | ["288.96"] | ["XISX","XPHO"] | 290.0000 | 290.0000 | 87 | 87 | false | false | false | false | |||||||||
| 01a0ca1b-f3e7-79e0-bf75-4f3a16d57143 | IWM | 2026-09-22 13:13 | synthetic | 2 | 2 | 17 | 34680.00 | long | bid | 286.8926 | 0.0600 | ["290"] | ["0.1825"] | ["288.96"] | ["XISX","XPHO"] | 290.0000 | 290.0000 | 87 | 87 | false | false | false | false | |||||||||
| 01a0b60e-4427-7420-88fc-0f5b9061c2aa | IWM | 2026-09-18 15:46 | synthetic | 2 | 2 | 478 | 55926.00 | short | ask | 283.8250 | 0.0800 | ["285"] | ["0.4754"] | ["283.85"] | ["AMXO"] | 285.0000 | 285.0000 | 0 | 0 | false | false | false | false | |||||||||
| 01a0b5cf-81c0-71b3-92a7-55073b061d68 | IWM | 2026-09-18 14:37 | synthetic | 2 | 2 | 478 | 76002.00 | short | ask | 283.4550 | 0.1200 | ["285"] | ["0.2735"] | ["283.45"] | ["AMXO"] | 285.0000 | 285.0000 | 0 | 0 | false | false | false | false | |||||||||
| 01a0b5b1-4f47-7601-9509-d821616266f8 | IWM | 2026-09-18 14:04 | synthetic | 2 | 1 | 10 | 51020.00 | long | ask | 283.4450 | 7.0800 | ["280"] | ["0.2294"] | ["279.04"] | ["XCBO"] | 280.0000 | 280.0000 | 854 | 854 | false | false | false | false | |||||||||
| 01a0b5ae-3e1f-7331-9f07-9af54a3e07b0 | IWM | 2026-09-18 14:01 | synthetic | 2 | 2 | 24 | 122508.00 | long | ask | 283.4600 | 7.6700 | ["280"] | ["0.2295"] | ["278.96"] | ["EDGO","XMIO"] | 280.0000 | 280.0000 | 854 | 854 | false | false | false | false | |||||||||
| 01a0b555-3910-7ac3-b163-035e05010eb5 | IWM | 2026-09-18 12:24 | synthetic | 2 | 1 | 250 | 61000.00 | short | ask | 282.5900 | 0.1200 | ["285"] | ["0.2281"] | ["282.60"] | ["AMXO"] | 285.0000 | 285.0000 | 0 | 0 | false | false | false | false | |||||||||
| 01a0b4b7-a538-7963-9446-a6c8148ff129 | IWM | 2026-09-18 09:32 | synthetic | 2 | 1 | 10000 | 1410000.00 | long | bid | 284.6400 | 0.0400 | ["285"] | ["0.2238"] | ["284.67"] | ["AMXO"] | 285.0000 | 285.0000 | 0 | 0 | false | false | false | false | |||||||||
| 01a0afef-bd2a-70a0-9dea-04d38f5193ba | IWM | 2026-09-17 11:15 | synthetic | 2 | 1 | 317 | 1689610.00 | long | bid | 286.9300 | 2.0400 | ["300"] | ["0.2099"] | ["298.54"] | ["XPHO"] | 300.0000 | 300.0000 | 456 | 456 | false | false | false | false | |||||||||
| 01a0ab90-4723-7c93-934f-ce3be3c415a2 | IWM | 2026-09-16 14:52 | synthetic | 2 | 2 | 335 | 138355.00 | short | ask | 284.4500 | 0.0400 | ["285"] | ["0.2445"] | ["284.58"] | ["C2OX","EDGO"] | 285.0000 | 285.0000 | 2 | 2 | false | false | false | false | |||||||||
| 01a0a64f-0b65-7571-8f02-b7d931a1f21e | IWM | 2026-09-15 14:23 | synthetic | 2 | 2 | 14 | 67368.00 | short | ask | 285.6100 | 0.6400 | ["305"] | ["0.2081"] | ["294.76"] | ["ARCO","XISX"] | 305.0000 | 305.0000 | 367 | 367 | false | false | false | ||||||||||
| 01a090ce-9f60-73d2-82c2-13c08aa3a31f | IWM | 2026-09-11 10:10 | synthetic | 2 | 1 | 500 | 2745000.00 | short | ask | 289.3800 | 2.8600 | ["300"] | ["0.2061"] | ["299.32"] | ["XBOX"] | 300.0000 | 300.0000 | 462 | 462 | false | false | false | false | |||||||||
| 01a086f3-a0a8-7171-89e2-6cd9244908d0 | IWM | 2026-09-09 12:15 | synthetic | 2 | 1 | 51 | 37893.00 | long | ask | 290.8200 | 0.1000 | ["290"] | ["0.2029"] | ["290.37"] | ["C2OX"] | 290.0000 | 290.0000 | 9 | 9 | false | false | false | false | |||||||||
| 01a06d5a-1dd5-7700-8cec-2c210dee6b3b | IWM | 2026-09-04 12:56 | synthetic | 2 | 2 | 70 | 50680.00 | short | bid | 295.7700 | 0.0400 | ["295"] | ["0.1556"] | ["295.34"] | ["XISX","XPHO"] | 295.0000 | 295.0000 | 14 | 14 | false | false | false | false | |||||||||
| 01a06d5a-0e35-7353-8ce6-9d147a68af13 | IWM | 2026-09-04 12:56 | synthetic | 2 | 2 | 43 | 31132.00 | short | bid | 295.7700 | 0.0400 | ["295"] | ["0.1556"] | ["295.34"] | ["XPHO"] | 295.0000 | 295.0000 | 14 | 14 | false | false | false | false | |||||||||
| 01a06d59-e725-7920-9d24-e070260290bb | IWM | 2026-09-04 12:56 | synthetic | 2 | 1 | 75 | 54300.00 | short | bid | 295.7700 | 0.1300 | ["295"] | ["0.1556"] | ["295.34"] | ["XISX"] | 295.0000 | 295.0000 | 14 | 14 | false | false | false | false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:57:25Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:55:37Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:14:32Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:14:32Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlft |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:46:28Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlft |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:38:05Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:05:06Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:01:49Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlft |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:24:25Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:32:08Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:15:31Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:52:35Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:23:39Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:10:54Z"} |
| 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-09T16:15:46Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:56:58Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:56:58Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:56:58Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |