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 |
|---|
| 01a0d4b6-d3b7-7243-b9ac-f41c1bd98f2e | MSTR | 2026-09-24 14:39 | put_calendar | 2 | 2 | 64 | 134592.00 | short | bid | 162.5000 | 0.7000 | ["167.5"] | ["0.6853"] | [] | ["AMXO","XISX"] | 167.5000 | 167.5000 | 8 | 15 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T18:39:13Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0d425-3a47-78b3-9a86-8bbf7c68523b | MSTR | 2026-09-24 12:00 | put_calendar | 2 | 1 | 40 | 116560.00 | short | bid | 161.8000 | 0.5500 | ["172.5"] | ["0.7111"] | [] | ["XPHO"] | 172.5000 | 172.5000 | 8 | 15 | false | false | true | false | |||||||||
| 01a0b535-3d8f-7b60-a600-2b2b78ca464f | MSTR | 2026-09-18 11:49 | put_calendar | 2 | 3 | 57 | 158403.00 | unknown | bid | 148.3450 | 0.2500 | ["145"] | ["0.7045"] | [] | ["XPHO"] | 145.0000 | 145.0000 | 28 | 91 | false | true | true | false | |||||||||
| 01a0af8f-7c93-7950-ad77-3c5842de4c72 | MSTR | 2026-09-17 09:30 | put_calendar | 2 | 3 | 133 | 236258.00 | short | bid | 129.9000 | 6.7000 | ["40"] | ["0.9665"] | [] | ["ARCO","MCRY"] | 40.0000 | 40.0000 | 820 | 855 | false | true | true | false | |||||||||
| 01a0abbe-6f8b-7001-8049-d4c460daf1b7 | MSTR | 2026-09-16 15:42 | put_calendar | 2 | 1 | 25 | 112000.00 | short | bid | 124.7100 | 1.5500 | ["145"] | ["0.9005"] | [] | ["XCBO"] | 145.0000 | 145.0000 | 2 | 37 | false | false | true | false | |||||||||
| 01a0abbd-eabb-7b70-8e40-6686ac896b31 | MSTR | 2026-09-16 15:42 | put_calendar | 2 | 1 | 25 | 110250.00 | short | bid | 124.5200 | 1.2500 | ["145"] | ["0.7757"] | [] | ["XCBO"] | 145.0000 | 145.0000 | 2 | 30 | false | false | true | false | |||||||||
| 01a0abbc-5863-7c13-a46b-f8b037592fe9 | MSTR | 2026-09-16 15:40 | put_calendar | 2 | 1 | 20 | 125440.00 | short | bid | 124.6000 | 1.8000 | ["155"] | ["1.0597"] | [] | ["MCRY"] | 155.0000 | 155.0000 | 2 | 30 | false | false | true | false | |||||||||
| 01a0ab9e-1e1b-7ab0-8fab-3037a187a5d9 | MSTR | 2026-09-16 15:07 | put_calendar | 2 | 1 | 32 | 170560.00 | short | bid | 125.0959 | 2.3000 | ["150"] | ["0.7824"] | [] | ["XPHO"] | 150.0000 | 150.0000 | 16 | 23 | false | false | true | false | |||||||||
| 01a0aaa9-c753-7873-b676-5abdcfd20b75 | MSTR | 2026-09-16 10:40 | put_calendar | 2 | 1 | 25 | 101600.00 | short | bid | 126.7401 | 0.8000 | ["145"] | ["0.9190"] | [] | ["XCBO"] | 145.0000 | 145.0000 | 2 | 30 | false | false | true | false | |||||||||
| 01a0aaa8-4c6b-7a12-91e2-200043de3735 | MSTR | 2026-09-16 10:39 | put_calendar | 2 | 1 | 25 | 148025.00 | short | bid | 126.7250 | 2.0500 | ["155"] | ["1.1341"] | [] | ["XCBO"] | 155.0000 | 155.0000 | 2 | 37 | false | false | true | false | |||||||||
| 01a0aaa8-1d8b-7eb0-acf5-8c60e1386082 | MSTR | 2026-09-16 10:38 | put_calendar | 2 | 1 | 23 | 133929.00 | short | bid | 126.8680 | 1.7000 | ["155"] | ["1.1266"] | [] | ["XCBO"] | 155.0000 | 155.0000 | 2 | 30 | false | false | true | false | |||||||||
| 01a0a582-be9e-7882-b361-60e0bbac73c8 | MSTR | 2026-09-15 10:40 | put_calendar | 2 | 1 | 67 | 143112.00 | short | bid | 129.2700 | 2.2000 | ["50"] | ["0.8721"] | [] | ["MCRY"] | 50.0000 | 50.0000 | 822 | 857 | false | true | true | false | |||||||||
| 01a0a582-a72e-7623-88e2-59639b77e9ac | MSTR | 2026-09-15 10:39 | put_calendar | 2 | 2 | 137 | 292632.00 | short | bid | 129.3800 | 2.2000 | ["50"] | ["0.8724"] | [] | ["EMLD","XMIO"] | 50.0000 | 50.0000 | 822 | 857 | false | true | true | false | |||||||||
| 01a0a542-c3b8-76f0-b4a7-2c431293fdc0 | MSTR | 2026-09-15 09:30 | put_calendar | 2 | 1 | 79 | 197579.00 | short | bid | 131.5500 | 3.0500 | ["55"] | ["0.8703"] | [] | ["XCBO"] | 55.0000 | 55.0000 | 822 | 857 | false | true | true | false | |||||||||
| 01a091ec-2cf0-7113-a0e9-376f28f0dd0b | MSTR | 2026-09-11 15:22 | put_calendar | 2 | 1 | 120 | 237840.00 | long | bid | 131.0800 | 0.5500 | ["140"] | ["2.5161"] | [] | ["XMIO"] | 140.0000 | 140.0000 | 0 | 7 | false | false | true | false | |||||||||
| 01a08cc1-e8f0-7901-8261-7ce4a14827f8 | MSTR | 2026-09-10 15:18 | put_calendar | 2 | 1 | 20 | 105020.00 | short | bid | 129.6800 | 0.8500 | ["155"] | ["0.8291"] | [] | ["XCBO"] | 155.0000 | 155.0000 | 8 | 15 | false | false | true | false | |||||||||
| 01a08b89-a770-7540-8c18-fd9f875cf1c6 | MSTR | 2026-09-10 09:37 | put_calendar | 2 | 1 | 50 | 276000.00 | short | bid | 129.0150 | 2.1000 | ["155"] | ["0.7793"] | [] | ["XMIO"] | 155.0000 | 155.0000 | 15 | 22 | false | false | true | false | |||||||||
| 01a087bc-ebe8-75a2-8a55-141a7049be92 | MSTR | 2026-09-09 15:54 | put_calendar | 2 | 1 | 50 | 327600.00 | long | bid | 133.3200 | 1.0500 | ["160"] | ["0.8350"] | [] | ["AMXO"] | 160.0000 | 160.0000 | 9 | 100 | false | false | true | false | |||||||||
| 01a0874b-3688-7e62-b7ec-57f1f7f9455d | MSTR | 2026-09-09 13:50 | put_calendar | 2 | 1 | 8 | 287928.00 | short | bid | 134.8300 | 2.8500 | ["310"] | ["0.8883"] | [] | ["XCBO"] | 310.0000 | 310.0000 | 281 | 373 | false | false | true | false | |||||||||
| 01a0827c-64b0-7903-80de-0bd27fe531f8 | MSTR | 2026-09-08 15:26 | put_calendar | 2 | 1 | 4 | 142700.00 | short | bid | 136.6000 | 6.5000 | ["310"] | ["0.9170"] | [] | ["ARCO"] | 310.0000 | 310.0000 | 282 | 374 | false | false | true | false | |||||||||
| 01a08249-f2a0-76d3-a073-3d95efca7b0b | MSTR | 2026-09-08 14:31 | put_calendar | 2 | 1 | 5 | 179935.00 | short | bid | 137.4900 | 6.7000 | ["300"] | ["0.9179"] | [] | ["EDGO"] | 300.0000 | 300.0000 | 647 | 829 | false | false | true | false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:00:11Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:49:35Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:30:06Z"} |
| 2026-09-17 |
| 2026-09-17 17:27 |
| 2026-09-17 17:27 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:43:10Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:42:41Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:40:54Z"} |
| 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-16T19:07:42Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:40:50Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:39:13Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:39:13Z"} |
| 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-15T14:40:10Z"} |
| 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-15T14:40:10Z"} |
| 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-15T13:30:07Z"} |
| 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-11T19:23:07Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:19:06Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T13:37:31Z"} |
| 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-09T19:55:00Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:51:00Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:26:27Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:31:18Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |