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 | net_side |
|---|
| 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 |
|---|
| 01a08150-e0e8-7b23-b449-cf4d25203816 | SQQQ | 2026-09-08 09:59 | put_calendar | 2 | 1 | 36 | 136620.00 | short | ask | 38.4250 | 3.8500 | ["50"] | ["0.9050"] | [] | ["XISX"] | 50.0000 | 50.0000 | 129 | 500 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:59:16Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081c5-4d98-7f21-ab66-fdfa976a2e41 | SQQQ | 2026-09-08 12:06 | other | 4 | 1 | 39 | 155259.00 | unknown | — | 37.9900 | 3.7500 | ["45","51"] | ["0.9135","2.0860"] | [] | ["XMIO"] | 45.0000 | 51.0000 | 3 | 10 | false | false | true | true | false | mlet | |||||||
| 01a081cf-09c8-7230-aa09-6b57026ca909 | SQQQ | 2026-09-08 12:17 | call_diagonal_spread | 2 | 1 | 81 | 146969.00 | short | bid | 38.1600 | 1.8500 | ["38","40"] | ["0.5940","0.6342"] | [] | ["XCBO"] | 38.0000 | 40.0000 | 192 | 500 | false | false | true | true | |||||||||
| 01a08cd6-4bb0-7520-baf9-cb1494d3417a | SQQQ | 2026-09-10 15:40 | put_vertical_spread | 2 | 1 | 250 | 139750.00 | long | ask | 39.8050 | 0.8800 | ["33.5","40.5"] | ["0.6180","0.7295"] | ["36.99"] | ["ARCO"] | 33.5000 | 40.5000 | 50 | 50 | true | false | false | true | |||||||||
| 01a09191-33e0-7fe1-b76e-baee1219e6a2 | SQQQ | 2026-09-11 13:43 | call_vertical_spread | 2 | 1 | 200 | 176000.00 | short | bid | 38.5758 | 0.5000 | ["130","135"] | ["0.8939","0.9029"] | ["130.10"] | ["XPHO"] | 130.0000 | 135.0000 | 497 | 497 | false | true | false | true | |||||||||
| 01a09193-4ef0-7b01-969b-ccd2ba908f65 | SQQQ | 2026-09-11 13:45 | call_vertical_spread | 2 | 1 | 200 | 174600.00 | short | bid | 38.5700 | 0.6500 | ["130","135"] | ["0.8920","0.9004"] | ["130.11"] | ["XMIO"] | 130.0000 | 135.0000 | 497 | 497 | false | true | false | true | |||||||||
| 01a091df-57c8-7580-ac55-22a42c7bbe13 | SQQQ | 2026-09-11 15:08 | call_vertical_spread | 2 | 1 | 200 | 181000.00 | unknown | — | 38.7600 | 0.3000 | ["130","135"] | ["0.8990","0.9075"] | [] | ["XPHO"] | 130.0000 | 135.0000 | 497 | 497 | false | true | false | true | false | mlet | |||||||
| 01a0a022-4480-70a3-ae04-b80a038a45ed | SQQQ | 2026-09-14 09:36 | call_vertical_spread | 2 | 1 | 300 | 138900.00 | unknown | — | 40.8150 | 0.2000 | ["40","45"] | ["0.5237","0.6447"] | [] | ["XISX"] | 40.0000 | 45.0000 | 32 | 32 | false | false | false | true | false | mlet | |||||||
| 01a0a104-d480-7ff1-a745-73dc8caba95b | SQQQ | 2026-09-14 13:44 | call_vertical_spread | 2 | 1 | 40 | 127000.00 | short | bid | 39.3000 | 5.2500 | ["38","45"] | ["0.6501","0.6923"] | ["39.15"] | ["BATO"] | 38.0000 | 45.0000 | 858 | 858 | true | false | false | true | |||||||||
| 01a0a5ba-31ee-77f1-80eb-b29943290067 | SQQQ | 2026-09-15 11:40 | other | 4 | 1 | 50 | 138000.00 | unknown | — | 40.5050 | 6.0800 | ["49","60","80"] | ["0.6739","0.7228","0.7985"] | [] | ["XISX"] | 49.0000 | 80.0000 | 94 | 857 | false | true | true | true | false | mlet | |||||||
| 01a0a681-1016-7a13-9aa7-0b38e7b47576 | SQQQ | 2026-09-15 15:17 | call_vertical_spread | 2 | 1 | 199 | 348847.00 | long | ask | 40.6568 | 2.3500 | ["60","65"] | ["0.7254","0.7398"] | ["60.65"] | ["XCBO"] | 60.0000 | 65.0000 | 493 | 493 | false | true | false | true | |||||||||
| 01a0afc1-237b-7712-8c04-a3406b52df41 | SQQQ | 2026-09-17 10:24 | other | 4 | 1 | 37 | 140526.00 | unknown | — | 38.6700 | 8.0000 | ["45","51"] | ["1.2645","2.9430"] | [] | ["XPHO"] | 45.0000 | 51.0000 | 1 | 15 | false | false | true | true | false | mlet | |||||||
| 01a0b046-4d53-7741-bcfe-af84210d5f1d | SQQQ | 2026-09-17 12:49 | call_vertical_spread | 2 | 1 | 162 | 134622.00 | long | ask | 38.5600 | 1.7200 | ["35","41"] | ["0.5072","0.5936"] | ["37.43"] | ["EDGO"] | 35.0000 | 41.0000 | 64 | 64 | false | false | false | true | |||||||||
| 01a0b047-b0cb-74c3-9b59-348bbf71f62a | SQQQ | 2026-09-17 12:51 | call_vertical_spread | 2 | 3 | 594 | 410751.00 | short | bid | 38.5677 | 0.5800 | ["35","45"] | ["0.4496","0.6087"] | ["38.22"] | ["EDGO","XISX","XPHO"] | 35.0000 | 45.0000 | 64 | 64 | false | false | false | true | |||||||||
| 01a0b048-165b-76e0-8805-6f0bee0a6493 | SQQQ | 2026-09-17 12:51 | call_vertical_spread | 2 | 1 | 163 | 118012.00 | unknown | — | 38.5650 | 1.2300 | ["35","45"] | ["0.4748","0.6420"] | [] | ["XPHO"] | 35.0000 | 45.0000 | 64 | 64 | false | false | false | true | false | mlet | |||||||
| 01a0b04e-7efb-7bd2-8017-0cebd0e60f28 | SQQQ | 2026-09-17 12:58 | call_vertical_spread | 2 | 1 | 368 | 301024.00 | long | ask | 38.6150 | 1.2800 | ["35","41"] | ["0.4848","0.5818"] | ["37.40"] | ["EDGO"] | 35.0000 | 41.0000 | 64 | 64 | false | false | false | true | |||||||||
| 01a0b050-e82b-72f1-b25b-06abb47d8d35 | SQQQ | 2026-09-17 13:01 | other | 4 | 3 | 72 | 197080.00 | unknown | — | 38.5299 | 4.1100 | ["26","27","38","38.5"] | ["0.4418","0.4872","0.4826","0.5257"] | [] | ["ARCO","XISX"] | 26.0000 | 38.5000 | 1 | 855 | false | false | true | true | false | mlet | |||||||
| 01a0c468-e45e-7773-aa52-24ee1765a216 | SQQQ | 2026-09-21 10:40 | call_vertical_spread | 2 | 1 | 40 | 115200.00 | unknown | — | 35.5700 | 6.4000 | ["33","38"] | ["0.6126","0.6408"] | [] | ["ARCO"] | 33.0000 | 38.0000 | 851 | 851 | false | false | false | true | false | mlet | |||||||
| 01a0c51c-ee36-7051-8b3e-d4daa57ff5b4 | SQQQ | 2026-09-21 13:56 | synthetic | 2 | 4 | 243 | 199401.00 | short | bid | 34.8750 | 0.4000 | ["34"] | ["0.6093"] | ["34.45"] | ["ARCO","EMLD","SPHR","XPHO"] | 34.0000 | 34.0000 | 88 | 88 | false | false | false | false |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:07:05Z"} |
| 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:17:08Z"} |
| 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-10T19:40:50Z"} |
| 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-11T17:44:05Z"} |
| 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-11T17:46:31Z"} |
| 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-11T19:09:12Z"} |
| 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-14T13:36:45Z"} |
| 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-14T17:44:36Z"} |
| 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-15T15:41:06Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:18:41Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:24:37Z"} |
| 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:50:00Z"} |
| 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:51:42Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:52:33Z"} |
| 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:59:04Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:01:34Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:40:07Z"} |
| 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-21T17:56:48Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |