core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg541,738 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 |
|---|
| 01a0e89d-e3a7-7dc0-8990-e1d91a3a9e75 | TQQQ | 2026-09-28 11:24 | put_calendar | 2 | 1 | 93 | 282720.00 | unknown | — | 76.2950 | 0.5000 | ["85"] | ["0.5989"] | [] | ["BATO"] | 85.0000 | 85.0000 | 81 | 172 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-28T15:24:43Z"} | 2026-09-28 | 2026-09-28 17:15 | 2026-09-28 17:15 |
| 01a0e840-0c37-75b3-9fad-4674f135e712 | TQQQ | 2026-09-28 09:41 | put_calendar | 2 | 3 | 432 | 313200.00 | unknown | — | 77.6500 | 0.2000 | ["75"] | ["0.5822"] | [] | ["XISX","XMIO","XPHO"] | 75.0000 | 75.0000 | 25 | 32 | false | true | true | false | false | mlet | |||||||
| 01a0d4ed-a2f7-7962-9323-0e438ce9f099 | TQQQ | 2026-09-24 15:38 | put_calendar | 2 | 1 | 200 | 158800.00 | unknown | bid | 78.5450 | 0.6000 | ["82"] | ["0.5276"] | [] | ["BATO"] | 82.0000 | 82.0000 | 1 | 8 | false | false | true | false | |||||||||
| 01a0cf82-817f-7891-9427-e52f75e39856 | TQQQ | 2026-09-23 14:23 | put_calendar | 2 | 1 | 95 | 176415.00 | unknown | bid | 78.5750 | 0.7000 | ["85"] | ["0.5338"] | [] | ["XCBO"] | 85.0000 | 85.0000 | 23 | 58 | false | false | true | false | |||||||||
| 01a0b613-2627-7bc1-9d8a-b32dd9a07e07 | TQQQ | 2026-09-18 15:51 | put_calendar | 2 | 1 | 120 | 370320.00 | unknown | ask | 72.2750 | 2.5000 | ["60"] | ["0.7063"] | [] | ["SPHR"] | 60.0000 | 60.0000 | 490 | 854 | false | true | true | false | |||||||||
| 01a0b5d0-54af-7250-80eb-caaca78249bb | TQQQ | 2026-09-18 14:38 | put_calendar | 2 | 1 | 110 | 402600.00 | unknown | — | 71.6236 | 2.1000 | ["65"] | ["0.7060"] | [] | ["XMIO"] | 65.0000 | 65.0000 | 490 | 854 | false | true | true | false | false | mlet | |||||||
| 01a0afa7-bf7b-7121-ab0a-64bde61b8081 | TQQQ | 2026-09-17 09:56 | put_calendar | 2 | 1 | 16 | 128320.00 | unknown | — | 70.8250 | 1.4500 | ["110"] | ["0.6444"] | [] | ["XCBO"] | 110.0000 | 110.0000 | 120 | 183 | false | false | true | false | false | mlat | |||||||
| 01a0afa6-15b3-72e1-9a65-58d7deab4173 | TQQQ | 2026-09-17 09:54 | put_calendar | 2 | 1 | 40 | 320880.00 | unknown | — | 70.9200 | 2.1000 | ["110"] | ["0.6512"] | [] | ["XPHO"] | 110.0000 | 110.0000 | 120 | 183 | false | false | true | false | false | mlet | |||||||
| 01a0afa6-15b3-72e1-9a65-58cffbff7384 | TQQQ | 2026-09-17 09:54 | put_calendar | 2 | 1 | 40 | 320880.00 | unknown | — | 70.9200 | 2.1000 | ["110"] | ["0.6512"] | [] | ["XPHO"] | 110.0000 | 110.0000 | 120 | 183 | false | false | true | false | false | mlet | |||||||
| 01a0afa6-11cb-7522-b66f-a0cf9d0cb61c | TQQQ | 2026-09-17 09:54 | put_calendar | 2 | 1 | 40 | 320840.00 | unknown | — | 70.9200 | 2.1000 | ["110"] | ["0.6507"] | [] | ["XPHO"] | 110.0000 | 110.0000 | 120 | 183 | false | false | true | false | false | mlet | |||||||
| 01a0afa6-11cb-7522-b66f-a0b27b05e1ef | TQQQ | 2026-09-17 09:54 | put_calendar | 2 | 1 | 40 | 320880.00 | unknown | — | 70.9200 | 2.1000 | ["110"] | ["0.6512"] | [] | ["XPHO"] | 110.0000 | 110.0000 | 120 | 183 | false | false | true | false | false | mlet | |||||||
| 01a0afa6-11cb-7522-b66f-a0a915b4f4bd | TQQQ | 2026-09-17 09:54 | put_calendar | 2 | 1 | 40 | 320880.00 | unknown | — | 70.9251 | 2.1000 | ["110"] | ["0.6515"] | [] | ["XPHO"] | 110.0000 | 110.0000 | 120 | 183 | false | false | true | false | false | mlet | |||||||
| 01a0aa81-731b-7161-bcd4-a1113fb2487c | TQQQ | 2026-09-16 09:56 | put_calendar | 2 | 1 | 88 | 115104.00 | unknown | — | 69.4150 | 0.4000 | ["75"] | ["0.6105"] | [] | ["BATO"] | 75.0000 | 75.0000 | 2 | 30 | false | false | true | false | false | mlet | |||||||
| 01a0aa81-28e3-75b2-8c2f-7a4a0e346284 | TQQQ | 2026-09-16 09:56 | put_calendar | 2 | 1 | 79 | 103490.00 | unknown | — | 69.3950 | 0.4500 | ["75"] | ["0.6043"] | [] | ["XISX"] | 75.0000 | 75.0000 | 2 | 30 | false | false | true | false | false | mlet | |||||||
| 01a0aa74-a1db-70d2-9dc0-616872e91812 | TQQQ | 2026-09-16 09:42 | put_calendar | 2 | 1 | 83 | 113793.00 | unknown | — | 69.0300 | 0.6500 | ["75"] | ["0.6193"] | [] | ["XISX"] | 75.0000 | 75.0000 | 2 | 30 | false | false | true | false | false | mlet | |||||||
| 01a0aa74-9df3-7be1-b6d7-50df131b5fc6 | TQQQ | 2026-09-16 09:42 | put_calendar | 2 | 1 | 83 | 113793.00 | unknown | — | 69.0300 | 0.6500 | ["75"] | ["0.6193"] | [] | ["XISX"] | 75.0000 | 75.0000 | 2 | 30 | false | false | true | false | false | mlet | |||||||
| 01a0aa74-9df3-7be1-b6d7-50ce7f6eead7 | TQQQ | 2026-09-16 09:42 | put_calendar | 2 | 1 | 83 | 113793.00 | unknown | — | 69.0300 | 0.6500 | ["75"] | ["0.6193"] | [] | ["XISX"] | 75.0000 | 75.0000 | 2 | 30 | false | false | true | false | false | mlet | |||||||
| 01a0aa74-9df3-7be1-b6d7-50ba7e02e827 | TQQQ | 2026-09-16 09:42 | put_calendar | 2 | 1 | 83 | 113793.00 | unknown | — | 69.0300 | 0.6500 | ["75"] | ["0.6193"] | [] | ["XISX"] | 75.0000 | 75.0000 | 2 | 30 | false | false | true | false | false | mlet | |||||||
| 01a0aa74-9df3-7be1-b6d7-50a0f3bd4b86 | TQQQ | 2026-09-16 09:42 | put_calendar | 2 | 1 | 83 | 113793.00 | unknown | — | 69.0300 | 0.6500 | ["75"] | ["0.6193"] | [] | ["XISX"] | 75.0000 | 75.0000 | 2 | 30 | false | false | true | false | false | mlet | |||||||
| 01a0aa73-b77b-7593-91b3-a6b4cacd9873 | TQQQ | 2026-09-16 09:41 | put_calendar | 2 | 1 | 78 | 107094.00 | unknown | — | 69.0400 | 0.6500 | ["75"] | ["0.6406"] | [] | ["XMIO"] | 75.0000 | 75.0000 | 2 | 30 | false | false | true | false | false | mlet | |||||||
| 01a0aa72-7efb-7610-9443-a0186741b9d1 | TQQQ | 2026-09-16 09:40 | put_calendar | 2 | 1 | 540 | 747900.00 | unknown | — | 68.8900 | 0.4000 | ["75"] | ["0.5780"] | [] | ["XISX"] | 75.0000 | 75.0000 | 2 | 30 | false | false | true | false | false | mlet | |||||||
| 01a0a630-735e-7d22-a6d6-c852786cc6b2 | TQQQ | 2026-09-15 13:49 | put_calendar | 2 | 1 | 204 | 107100.00 | unknown | — | 67.9100 | 0.1200 | ["67"] | ["0.6065"] | [] | ["C2OX"] | 67.0000 | 67.0000 | 10 | 17 | false | true | true | false | false | mesl | |||||||
| 01a0a5f2-0ace-7412-ba0b-b634b4042541 | TQQQ | 2026-09-15 12:41 | put_calendar | 2 | 1 | 102 | 210120.00 | unknown | — | 68.1400 | 0.3500 | ["78"] | ["0.6195"] | [] | ["XCBO"] | 78.0000 | 78.0000 | 3 | 31 | false | false | true | false | false | mlat | |||||||
| 01a08ca5-aa78-7141-b515-332d910ace58 | TQQQ | 2026-09-10 14:47 | put_calendar | 2 | 1 | 81 | 100197.00 | unknown | — | 69.4150 | 1.1500 | ["75.5"] | ["0.8694"] | [] | ["BATO"] | 75.5000 | 75.5000 | 1 | 8 | false | false | true | false | false | mlet | |||||||
| 01a087ae-70e0-74e0-85e1-b1ccffcaf520 | TQQQ | 2026-09-09 15:39 | put_calendar | 2 | 1 | 80 | 106240.00 | unknown | — | 71.4700 | 0.8000 | ["78"] | ["0.4711"] | [] | ["XISX"] | 78.0000 | 78.0000 | 5 | 7 | false | false | true | false | false | mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T13:41:51Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:39:22Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T18:24:37Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlft |
| market_whale |
| 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 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:38:46Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:57:00Z"} |
| 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-17T13:54:58Z"} |
| 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-17T13:54:58Z"} |
| 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-17T13:54:58Z"} |
| 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-17T13:54:58Z"} |
| 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-17T13:54:58Z"} |
| 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-16T13:56:50Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:56:50Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:42:55Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:42:55Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:42:55Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:42:55Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:42:55Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:41:59Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:40:43Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:50:10Z"} |
| 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-15T16:41:54Z"} |
| 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-10T18:47:55Z"} |
| 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-09T19:39:14Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |