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 |
|---|
| 01a0d903-850f-7643-a320-eaa612c4c2ea | SOXL | 2026-09-25 10:41 | put_calendar | 2 | 1 | 20 | 544020.00 | short | ask | 149.5500 | 7.1000 | ["280"] | ["1.2948"] | [] | ["XPHO"] | 280.0000 | 280.0000 | 56 | 84 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T14:41:25Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d44b-bda7-7261-80b1-c4fef4cbe392 | SOXL | 2026-09-24 12:42 | put_calendar | 2 | 1 | 87 | 196620.00 | long | ask | 146.0050 | 2.0000 | ["140"] | ["1.1143"] | [] | ["XISX"] | 140.0000 | 140.0000 | 15 | 22 | false | true | true | false | |||||||||
| 01a0c9d1-b02f-7530-93cb-d2904d071f12 | SOXL | 2026-09-22 11:52 | put_calendar | 2 | 1 | 10 | 135530.00 | long | ask | 147.2601 | 4.3500 | ["200"] | ["1.2182"] | [] | ["EDGO"] | 200.0000 | 200.0000 | 59 | 87 | false | false | true | false | |||||||||
| 01a0c45c-edde-7c50-b711-02e85ea7ee98 | SOXL | 2026-09-21 10:26 | put_calendar | 2 | 1 | 22 | 108350.00 | short | ask | 136.0100 | 1.7500 | ["130"] | ["1.1985"] | [] | ["XPHO"] | 130.0000 | 130.0000 | 60 | 88 | false | true | true | false | |||||||||
| 01a0b4e0-dfe7-7881-9edd-ff1218dbd0e8 | SOXL | 2026-09-18 10:17 | put_calendar | 2 | 1 | 20 | 226640.00 | long | ask | 118.3700 | 5.2000 | ["165"] | ["1.1306"] | [] | ["MCRY"] | 165.0000 | 165.0000 | 63 | 91 | false | false | true | false | |||||||||
| 01a0b4c3-0360-7933-a8a9-9d65a74a15b9 | SOXL | 2026-09-18 09:44 | put_calendar | 2 | 1 | 9 | 120150.00 | long | ask | 119.0350 | 5.7000 | ["180"] | ["1.1541"] | [] | ["XISX"] | 180.0000 | 180.0000 | 28 | 91 | false | false | true | false | |||||||||
| 01a0aa9b-63bb-7090-887d-685eb9aac88b | SOXL | 2026-09-16 10:25 | put_calendar | 2 | 1 | 23 | 155595.00 | short | ask | 108.3150 | 3.5500 | ["140"] | ["1.5175"] | [] | ["XPHO"] | 140.0000 | 140.0000 | 2 | 30 | false | false | true | false | |||||||||
| 01a0aa97-3953-7871-8a4c-4c16a3d24f5d | SOXL | 2026-09-16 10:20 | put_calendar | 2 | 1 | 26 | 175890.00 | short | ask | 108.4553 | 3.6000 | ["140"] | ["1.6014"] | [] | ["XISX"] | 140.0000 | 140.0000 | 2 | 30 | false | false | true | false | |||||||||
| 01a0a6a2-3c45-7f90-8583-bd9c7e96917a | SOXL | 2026-09-15 15:54 | put_calendar | 2 | 1 | 25 | 254975.00 | long | ask | 102.0999 | 4.4500 | ["150"] | ["1.3904"] | [] | ["XISX"] | 150.0000 | 150.0000 | 3 | 66 | false | false | true | false | |||||||||
| 01a0a624-abbe-76d1-a34c-b0cbae2820a5 | SOXL | 2026-09-15 13:36 | put_calendar | 2 | 1 | 40 | 154880.00 | short | ask | 101.6400 | 2.2500 | ["120"] | ["1.1389"] | [] | ["XISX"] | 120.0000 | 120.0000 | 3 | 10 | false | false | true | false | |||||||||
| 01a0a618-4fad-77e0-9501-db590f82bc59 | SOXL | 2026-09-15 13:23 | put_calendar | 2 | 1 | 40 | 321640.00 | short | ask | 101.4637 | 3.2500 | ["140"] | ["1.6292"] | [] | ["XMIO"] | 140.0000 | 140.0000 | 3 | 31 | false | false | true | false | |||||||||
| 01a0a59e-8016-7492-a6cb-095625a8e2c3 | SOXL | 2026-09-15 11:10 | put_calendar | 2 | 1 | 30 | 208200.00 | short | ask | 102.5800 | 5.8000 | ["137"] | ["1.3968"] | [] | ["XPHO"] | 137.0000 | 137.0000 | 3 | 8 | true | false | true | false | |||||||||
| 01a0a59c-3a0e-7023-9b3f-e010210b583c | SOXL | 2026-09-15 11:07 | put_calendar | 2 | 1 | 30 | 249720.00 | short | ask | 102.8250 | 6.1000 | ["144"] | ["1.7989"] | [] | ["XPHO"] | 144.0000 | 144.0000 | 3 | 8 | false | false | true | false | |||||||||
| 01a0a59c-2e56-7341-a9b4-7144485a3b10 | SOXL | 2026-09-15 11:07 | put_calendar | 2 | 1 | 30 | 249720.00 | short | ask | 102.8150 | 6.1000 | ["144"] | ["1.7587"] | [] | ["AMXO"] | 144.0000 | 144.0000 | 3 | 8 | true | false | true | false | |||||||||
| 01a0a566-fd26-7040-b9d1-d3174bb1d7b2 | SOXL | 2026-09-15 10:09 | put_calendar | 2 | 1 | 17 | 136459.00 | short | ask | 105.1250 | 6.4500 | ["145"] | ["1.9158"] | [] | ["AMXO"] | 145.0000 | 145.0000 | 3 | 17 | false | false | true | false | |||||||||
| 01a0a178-0c99-71b0-84aa-e0306e7538e1 | SOXL | 2026-09-14 15:49 | put_calendar | 2 | 1 | 100 | 225700.00 | long | ask | 102.7650 | 2.2500 | ["113"] | ["8.7098"] | [] | ["XMIO"] | 113.0000 | 113.0000 | 0 | 4 | false | false | true | false | |||||||||
| 01a0a10f-8e98-76f2-9ec3-4086e9f00e63 | SOXL | 2026-09-14 13:55 | put_calendar | 2 | 2 | 8 | 106480.00 | short | ask | 104.3300 | 5.8000 | ["120"] | ["1.1974"] | [] | ["XMIO"] | 120.0000 | 120.0000 | 494 | 858 | false | false | true | false | |||||||||
| 01a0915e-7f68-7841-8f86-0dafd927a203 | SOXL | 2026-09-11 12:48 | put_calendar | 2 | 1 | 20 | 121660.00 | short | ask | 122.8365 | 5.8500 | ["150"] | ["1.0752"] | [] | ["BATO"] | 150.0000 | 150.0000 | 14 | 21 | false | false | true | false | |||||||||
| 01a08c6d-8378-7752-a379-af283bdd09db | SOXL | 2026-09-10 13:46 | put_calendar | 2 | 2 | 15 | 114400.00 | short | ask | 117.3050 | 5.2500 | ["155"] | ["2.4980"] | [] | ["ARCO","MCRY"] | 155.0000 | 155.0000 | 1 | 15 | false | false | true | false | |||||||||
| 01a08761-6a21-7951-9dc2-6e93b5be3b6c | SOXL | 2026-09-09 14:15 | put_calendar | 2 | 2 | 24 | 178198.00 | short | ask | 125.7800 | 4.8958 | ["160"] | ["1.1851"] | [] | ["ARCO","XISX"] | 160.0000 | 160.0000 | 9 | 23 | false | false | true | false | |||||||||
| 01a08674-b860-71a0-a02d-1eaad6d66124 | SOXL | 2026-09-09 09:56 | put_calendar | 2 | 1 | 49 | 160475.00 | long | ask | 126.8698 | 2.2500 | ["140"] | ["1.3554"] | [] | ["XMIO"] | 140.0000 | 140.0000 | 2 | 9 | false | false | true | false | |||||||||
| 01a06da8-0ef5-7f91-9cd8-d00c26ed8aa9 | SOXL | 2026-09-04 14:22 | put_calendar | 2 | 1 | 87 | 471453.00 | short | ask | 116.3000 | 1.4500 | ["140"] | ["1.0665"] | [] | ["XISX"] | 140.0000 | 140.0000 | 14 | 21 | false | false | true | false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:42:13Z"} |
| 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-22T15:52:45Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:27:02Z"} |
| 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-18T14:17:17Z"} |
| 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-18T13:44:33Z"} |
| 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-16T14:25:37Z"} |
| 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-16T14:20:43Z"} |
| 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-15T19:54:29Z"} |
| 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-15T17:37:56Z"} |
| 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-15T17:23:28Z"} |
| 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-15T15:10:21Z"} |
| 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-15T15:07:59Z"} |
| 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-15T15:07:59Z"} |
| 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:09:43Z"} |
| 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-14T19:50:08Z"} |
| 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:55:47Z"} |
| 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-11T16:48:33Z"} |
| 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-10T17:46:56Z"} |
| 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-09T18:15:06Z"} |
| 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-09T13:56:40Z"} |
| 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-04T18:22:41Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |