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 | 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 |
|---|
| 01a0c98e-9097-7273-8903-98ff13246016 | SMH | 2026-09-22 10:39 | synthetic | 2 | 1 | 9 | 98892.00 | long | ask | 602.1000 | 4.1000 | ["545"] | ["0.3793"] | ["608.48"] | ["ARCO"] | 545.0000 | 545.0000 | 115 | 115 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T14:39:47Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c986-f35f-7eb2-8323-213c214f3010 | SMH | 2026-09-22 10:30 | synthetic | 2 | 1 | 10 | 110800.00 | long | ask | 602.2156 | 3.4000 | ["545"] | ["0.3832"] | ["608.58"] | ["ARCO"] | 545.0000 | 545.0000 | 115 | 115 | false | false | false | false | |||||||||
| 01a0c580-3fff-71a3-99ec-6b4349cf05fe | SMH | 2026-09-21 15:45 | synthetic | 2 | 1 | 22 | 36450.00 | long | bid | 597.8200 | 0.5000 | ["600"] | ["0.3299"] | ["598.21"] | ["EDGO"] | 600.0000 | 600.0000 | 4 | 4 | false | false | false | false | |||||||||
| 01a0c476-f9d7-7a23-bf8d-d29625e8da73 | SMH | 2026-09-21 10:55 | synthetic | 2 | 1 | 6 | 33930.00 | long | ask | 586.9800 | 0.5000 | ["545"] | ["0.3679"] | ["588.61"] | ["AMXO"] | 545.0000 | 545.0000 | 25 | 25 | false | false | false | false | |||||||||
| 01a0afb5-d8db-7aa2-bbb8-351abc90eabf | SMH | 2026-09-17 10:12 | synthetic | 2 | 2 | 33 | 465630.00 | long | bid | 559.8700 | 4.7000 | ["580"] | ["0.3678"] | ["576.65"] | ["MCRY","SPHR"] | 580.0000 | 580.0000 | 273 | 273 | false | false | false | false | |||||||||
| 01a0afb5-9a5b-7fe2-9ae1-dec98a0711df | SMH | 2026-09-17 10:11 | synthetic | 2 | 3 | 50 | 705500.00 | long | bid | 559.6700 | 4.7000 | ["580"] | ["0.3678"] | ["576.65"] | ["C2OX","MCRY","SPHR"] | 580.0000 | 580.0000 | 273 | 273 | false | false | false | false | |||||||||
| 01a0ab19-270b-7730-b505-85f024be2f7d | SMH | 2026-09-16 12:42 | synthetic | 2 | 4 | 7 | 54824.00 | short | bid | 550.7401 | 0.9000 | ["555"] | ["0.3540"] | ["556.66"] | ["ARCO","EDGO","XCBO","XPHO"] | 555.0000 | 555.0000 | 93 | 93 | false | false | false | false | |||||||||
| 01a0a022-2d10-7c33-af14-8a4c897d73a8 | SMH | 2026-09-14 09:36 | synthetic | 2 | 1 | 154 | 1406328.00 | short | ask | 538.0900 | 3.5500 | ["545"] | ["0.3673"] | ["544.04"] | ["ARCO"] | 545.0000 | 545.0000 | 123 | 123 | false | false | false | false | |||||||||
| 01a0a022-15a1-72e3-872a-46c486a81453 | SMH | 2026-09-14 09:36 | synthetic | 2 | 1 | 11 | 100452.00 | short | bid | 538.2800 | 2.0500 | ["545"] | ["0.3672"] | ["545.42"] | ["ARCO"] | 545.0000 | 545.0000 | 123 | 123 | false | false | false | false | |||||||||
| 01a090fe-8ce8-7a32-bd76-ab76a8ab0c2f | SMH | 2026-09-11 11:03 | synthetic | 2 | 1 | 5 | 25355.00 | short | ask | 569.1200 | 2.9000 | ["572.5"] | ["0.3288"] | ["571.37"] | ["AMXO"] | 572.5000 | 572.5000 | 42 | 42 | false | false | false | false | |||||||||
| 01a090e7-1130-7780-ad36-0c1108753ede | SMH | 2026-09-11 10:37 | synthetic | 2 | 2 | 18 | 150300.00 | long | ask | 568.4850 | 0.7000 | ["565"] | ["0.3573"] | ["574.77"] | ["AMXO","ARCO"] | 565.0000 | 565.0000 | 98 | 98 | false | false | false | false | |||||||||
| 01a090e6-d699-75c0-a955-cbaad0f27059 | SMH | 2026-09-11 10:37 | synthetic | 2 | 1 | 8 | 66864.00 | long | ask | 568.7000 | 0.7500 | ["565"] | ["0.3575"] | ["575.18"] | ["AMXO"] | 565.0000 | 565.0000 | 98 | 98 | false | false | false | false | |||||||||
| 01a08ba9-7fc8-7cf3-9f04-9f881c265802 | SMH | 2026-09-10 10:12 | synthetic | 2 | 1 | 11 | 94930.00 | long | ask | 559.9300 | 1.0000 | ["565"] | ["0.3705"] | ["566.36"] | ["ARCO"] | 565.0000 | 565.0000 | 99 | 99 | false | false | false | false | |||||||||
| 01a08ba0-1988-7253-9aae-70b0ca3eec1c | SMH | 2026-09-10 10:01 | synthetic | 2 | 1 | 25 | 214475.00 | long | bid | 559.4080 | 3.0500 | ["565"] | ["0.3684"] | ["564.85"] | ["ARCO"] | 565.0000 | 565.0000 | 99 | 99 | false | false | false | false | |||||||||
| 01a0870d-00c1-7fb1-8e3a-b158849839d9 | SMH | 2026-09-09 12:42 | synthetic | 2 | 1 | 10 | 159350.00 | short | ask | 574.5700 | 3.3000 | ["630"] | ["0.3799"] | ["589.95"] | ["XBOX"] | 630.0000 | 630.0000 | 281 | 281 | false | false | false | false | |||||||||
| 01a081ec-32a0-73a3-a223-5f7b94898320 | SMH | 2026-09-08 12:48 | synthetic | 2 | 1 | 4 | 37092.00 | short | ask | 575.0000 | 4.5500 | ["590"] | ["0.3810"] | ["581.61"] | ["ARCO"] | 590.0000 | 590.0000 | 101 | 101 | false | false | false | false | |||||||||
| 01a081eb-f420-77e1-9447-c4de1980cafd | SMH | 2026-09-08 12:48 | synthetic | 2 | 1 | 4 | 37060.00 | long | ask | 575.2200 | 4.0000 | ["565"] | ["0.3861"] | ["581.81"] | ["ARCO"] | 565.0000 | 565.0000 | 101 | 101 | false | false | false | false | |||||||||
| 01a081e9-e4c9-7071-a5dc-28ef71917238 | SMH | 2026-09-08 12:46 | synthetic | 2 | 2 | 18 | 165420.00 | short | bid | 574.5600 | 3.2000 | ["580"] | ["0.3820"] | ["580.61"] | ["ARCO","XBOX"] | 580.0000 | 580.0000 | 101 | 101 | false | false | false | false | |||||||||
| 01a081e8-f298-7880-9df8-da6639e22593 | SMH | 2026-09-08 12:45 | synthetic | 2 | 1 | 9 | 82710.00 | short | bid | 574.7450 | 3.5000 | ["580"] | ["0.3820"] | ["580.40"] | ["XBOX"] | 580.0000 | 580.0000 | 101 | 101 | false | false | false | false | |||||||||
| 01a081e3-fd10-7ee1-86ea-1d82955f289e | SMH | 2026-09-08 12:39 | synthetic | 2 | 2 | 19 | 103341.00 | short | ask | 575.0500 | 1.6000 | ["580"] | ["0.3665"] | ["577.32"] | ["ARCO","XBOX"] | 580.0000 | 580.0000 | 38 | 38 | false | false | false | false | |||||||||
| 01a081e3-f928-7251-a3a1-2c15d943c9a9 | SMH | 2026-09-08 12:39 | synthetic | 2 | 1 | 9 | 48942.00 | long | bid | 575.0500 | 2.0500 | ["580"] | ["0.3664"] | ["577.84"] | ["ARCO"] | 580.0000 | 580.0000 | 38 | 38 | false | false | false | false | |||||||||
| 01a081e3-f928-7251-a3a1-2c0b45aa24ff | SMH | 2026-09-08 12:39 | synthetic | 2 | 2 | 6 | 32628.00 | long | bid | 575.0500 | 2.0500 | ["580"] | ["0.3664"] | ["577.84"] | ["C2OX","XCBO"] | 580.0000 | 580.0000 | 38 | 38 | false | false | false | false | |||||||||
| 01a081e3-f928-7251-a3a1-2bf623874e6d | SMH | 2026-09-08 12:39 | synthetic | 2 | 1 | 11 | 59818.00 | short | ask | 575.0500 | 2.0500 | ["580"] | ["0.3664"] | ["576.88"] | ["XBOX"] | 580.0000 | 580.0000 | 38 | 38 | false | false | false | false | |||||||||
| 01a081d2-6140-7ce3-9498-4a8ad0e878b0 | SMH | 2026-09-08 12:20 | synthetic | 2 | 2 | 10 | 54500.00 | short | ask | 576.3900 | 1.6500 | ["580"] | ["0.3670"] | ["578.25"] | ["C2OX","XBOX"] | 580.0000 | 580.0000 | 38 | 38 | false | false | false | false | |||||||||
| 01a06dff-d3b5-7841-b1f1-9c5dbcddf3a2 | SMH | 2026-09-04 15:57 | synthetic | 2 | 1 | 9 | 80190.00 | long | bid | 567.3200 | 1.0500 | ["580"] | ["0.3639"] | ["573.70"] | ["C2OX"] | 580.0000 | 580.0000 | 105 | 105 | false | false | false | false | |||||||||
| 01a06dff-914d-7620-88d0-af8e6651e374 | SMH | 2026-09-04 15:57 | synthetic | 2 | 1 | 10 | 89100.00 | long | bid | 567.4750 | 0.6000 | ["580"] | ["0.3639"] | ["573.88"] | ["C2OX"] | 580.0000 | 580.0000 | 105 | 105 | false | false | false | false | |||||||||
| 01a06dfe-d5cd-74c0-800d-f0669ca40222 | SMH | 2026-09-04 15:56 | synthetic | 2 | 1 | 5 | 44275.00 | long | bid | 567.4600 | 0.4000 | ["580"] | ["0.3616"] | ["573.81"] | ["C2OX"] | 580.0000 | 580.0000 | 105 | 105 | false | false | false | false | |||||||||
| 01a06dfe-7fdd-7cd3-ace4-631e90c34c72 | SMH | 2026-09-04 15:56 | synthetic | 2 | 1 | 9 | 79560.00 | long | bid | 567.3900 | 1.1000 | ["580"] | ["0.3610"] | ["573.80"] | ["C2OX"] | 580.0000 | 580.0000 | 105 | 105 | false | false | false | false | |||||||||
| 01a06dfe-415d-7410-a52a-d4817ff333b0 | SMH | 2026-09-04 15:56 | synthetic | 2 | 1 | 8 | 70560.00 | long | bid | 567.3600 | 1.7500 | ["580"] | ["0.3602"] | ["573.60"] | ["C2OX"] | 580.0000 | 580.0000 | 105 | 105 | false | false | false | false | |||||||||
| 01a06d79-a80d-7893-bd2b-be7e495cc314 | SMH | 2026-09-04 13:31 | synthetic | 2 | 4 | 5 | 54569.00 | short | ask | 564.2250 | 2.1400 | ["630"] | ["0.3475"] | ["571.15"] | ["EMLD","SPHR","XBOX"] | 630.0000 | 630.0000 | 133 | 133 | false | false | false | false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:31:10Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:45:28Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:55:25Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:12:24Z"} |
| 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-17T14:12:02Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:42:39Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T13:36:27Z"} |
| 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-14T13:36:27Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:03:15Z"} |
| 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:37:50Z"} |
| 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-11T14:37:21Z"} |
| 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-10T14:12:26Z"} |
| 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:02:13Z"} |
| 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-09T16:43:08Z"} |
| 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-08T16:48:57Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:48:57Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:46:34Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:45:39Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:40:08Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:40:08Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:40:08Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:40:08Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:21:09Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:58:06Z"} |
| 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-04T19:57:47Z"} |
| 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-04T19:57:05Z"} |
| 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-04T19:56:44Z"} |
| 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-04T19:56:18Z"} |
| 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-04T17:31:38Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |