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 |
|---|
| 01a0b627-5a07-7980-884d-19d3899ddb4c | QQQ | 2026-09-18 16:13 | synthetic | 2 | 2 | 180 | 29520.00 | long | ask | 722.6300 | 0.1300 | ["721"] | ["0.2879"] | ["722.60"] | ["AMXO"] | 721.0000 | 721.0000 | 0 | 0 | false | false | false | false | true | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b613-1a70-7953-8d32-da42ca77e27d | QQQ | 2026-09-18 15:51 | synthetic | 2 | 2 | 950 | 77900.00 | long | ask | 720.0200 | 0.0200 | ["720"] | ["0.3640"] | ["720.10"] | ["AMXO"] | 720.0000 | 720.0000 | 0 | 0 | false | false | false | false | |||||||||
| 01a0b527-530f-7ba3-bf53-7fcb4dbd86a9 | QQQ | 2026-09-18 11:34 | synthetic | 2 | 1 | 995 | 698490.00 | long | ask | 716.8600 | 0.2900 | ["710"] | ["0.2508"] | ["716.90"] | ["AMXO"] | 710.0000 | 710.0000 | 0 | 0 | false | false | false | false | |||||||||
| 01a0b4db-6978-7aa0-900e-225977a2bff5 | QQQ | 2026-09-18 10:11 | synthetic | 2 | 2 | 800 | 283200.00 | short | ask | 717.3100 | 0.0500 | ["720"] | ["0.1863"] | ["717.20"] | ["AMXO"] | 720.0000 | 720.0000 | 0 | 0 | false | false | false | false | |||||||||
| 01a0b4b6-bebf-76e0-b43f-5168c2cab629 | QQQ | 2026-09-18 09:31 | synthetic | 2 | 2 | 800 | 393600.00 | short | bid | 719.1500 | 0.1800 | ["715"] | ["0.2160"] | ["718.80"] | ["AMXO"] | 715.0000 | 715.0000 | 0 | 0 | false | false | false | false | |||||||||
| 01a0affa-b5c3-7dc2-a596-32afc45b9b5e | QQQ | 2026-09-17 11:27 | synthetic | 2 | 2 | 600 | 4710000.00 | long | ask | 715.7525 | 0.7800 | ["670"] | ["0.2384"] | ["722.50"] | ["AMXO"] | 670.0000 | 670.0000 | 92 | 92 | false | false | false | false | |||||||||
| 01a0abc4-535b-7d13-a88d-9807ab7bfa66 | QQQ | 2026-09-16 15:49 | synthetic | 2 | 2 | 750 | 8853750.00 | short | ask | 704.1700 | 3.5100 | ["780"] | ["0.2201"] | ["722.07"] | ["AMXO"] | 780.0000 | 780.0000 | 274 | 274 | false | false | false | false | |||||||||
| 01a0aba6-01a3-7712-9477-1f0794fc85b6 | QQQ | 2026-09-16 15:16 | synthetic | 2 | 1 | 100 | 358500.00 | long | ask | 701.4200 | 0.2500 | ["690"] | ["0.2148"] | ["704.25"] | ["AMXO"] | 690.0000 | 690.0000 | 30 | 30 | false | false | false | false | |||||||||
| 01a0a6ae-f9fe-7af2-aadc-e5552796de7f | QQQ | 2026-09-15 16:07 | synthetic | 2 | 2 | 500 | 1820500.00 | long | ask | 705.2000 | 0.4400 | ["670"] | ["0.3520"] | ["705.59"] | ["AMXO"] | 670.0000 | 670.0000 | 3 | 3 | false | false | false | false | |||||||||
| 01a0a675-0dde-74d0-8f8c-1d4cad65b262 | QQQ | 2026-09-15 15:04 | synthetic | 2 | 1 | 750 | 4387500.00 | short | ask | 704.7501 | 0.3700 | ["720"] | ["0.2044"] | ["711.32"] | ["XPHO"] | 720.0000 | 720.0000 | 94 | 94 | false | false | false | false | |||||||||
| 01a0a123-ab08-77d1-b06b-b57b21fd4136 | QQQ | 2026-09-14 14:17 | synthetic | 2 | 1 | 500 | 585500.00 | long | bid | 712.2900 | 0.0900 | ["715"] | ["0.1937"] | ["712.73"] | ["XPHO"] | 715.0000 | 715.0000 | 4 | 4 | false | false | false | false | |||||||||
| 01a09121-c488-72c1-8b34-b919eb735018 | QQQ | 2026-09-11 11:41 | synthetic | 2 | 1 | 50 | 141050.00 | long | ask | 716.9600 | 0.3000 | ["718"] | ["0.1779"] | ["718.49"] | ["AMXO"] | 718.0000 | 718.0000 | 28 | 28 | false | false | false | false | |||||||||
| 01a08bc6-c7e0-7b40-905c-2280f016bfc2 | QQQ | 2026-09-10 10:44 | synthetic | 2 | 2 | 300 | 1654800.00 | long | ask | 710.9750 | 0.3600 | ["705"] | ["0.2193"] | ["716.02"] | ["AMXO"] | 705.0000 | 705.0000 | 71 | 71 | false | false | false | false | |||||||||
| 01a06e0c-4f05-71a2-9af0-9271f1b30d70 | QQQ | 2026-09-04 16:11 | synthetic | 2 | 1 | 1000 | 184000.00 | long | bid | 718.2954 | 0.3400 | ["720"] | ["0.3760"] | ["718.18"] | ["AMXO"] | 720.0000 | 720.0000 | 0 | 0 | false | false | false | false |
| mlft |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:51:55Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:34:36Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:11:25Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:31:15Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:27:42Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:49:28Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:16:17Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T20:08:49Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:04:43Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T18:18:16Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:41:55Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:44:29Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |