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 |
|---|
| 01a0ca7c-a5cf-7e92-aa08-1322bdc6e4a0 | SHOP | 2026-09-22 14:59 | call_vertical_spread | 2 | 1 | 10 | 140000.00 | short | bid | 147.7000 | 2.1000 | ["90","140"] | ["0.6152","0.5952"] | ["112.80"] | ["XISX"] | 90.0000 | 140.0000 | 815 | 815 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T18:59:44Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0ca28-4ff7-7661-942f-06591b179c42 | SHOP | 2026-09-22 13:27 | strangle | 2 | 1 | 850 | 10497500.00 | short | bid | 148.7600 | 7.6500 | ["220","230"] | ["0.6301","0.5693"] | ["96.50","353.50"] | ["XPHO"] | 220.0000 | 230.0000 | 815 | 815 | true | false | false | true | true | ||||||||
| 01a0c9c8-3a4f-7fa1-b0da-ca654fabc179 | SHOP | 2026-09-22 11:42 | call_diagonal_spread | 2 | 1 | 400 | 1087200.00 | short | bid | 147.9200 | 4.5000 | ["135","142"] | ["0.8016","0.5440"] | [] | ["EDGO"] | 135.0000 | 142.0000 | 3 | 38 | false | false | true | true | |||||||||
| 01a0c96b-e1af-7d01-9825-7311d7d44d5a | SHOP | 2026-09-22 10:01 | call_vertical_spread | 2 | 1 | 10 | 150390.00 | short | bid | 148.3000 | 4.8000 | ["80","85"] | ["0.6522","0.6439"] | ["83.77"] | ["AMXO"] | 80.0000 | 85.0000 | 360 | 360 | false | false | false | true | |||||||||
| 01a0c95a-4daf-7640-8f6d-f490f4a5f03e | SHOP | 2026-09-22 09:42 | call_diagonal_spread | 2 | 2 | 74 | 127650.00 | short | bid | 148.1950 | 1.4500 | ["141","150"] | ["0.7261","0.5445"] | [] | ["C2OX","EDGO"] | 141.0000 | 150.0000 | 3 | 31 | false | false | true | true | |||||||||
| 01a0c959-e04f-7652-8e03-cfc796dec9e2 | SHOP | 2026-09-22 09:41 | put_vertical_spread | 2 | 1 | 1980 | 108880.00 | short | bid | 148.5100 | 1.1900 | ["118","124"] | ["1.4203","1.2028"] | ["123.95"] | ["XCBO"] | 118.0000 | 124.0000 | 3 | 3 | false | true | false | true | |||||||||
| 01a0c578-5c77-72a1-92b8-60d5362a238b | SHOP | 2026-09-21 15:36 | call_diagonal_spread | 2 | 1 | 100 | 203200.00 | short | bid | 137.1184 | 1.2000 | ["137","145"] | ["0.5050","0.5795"] | [] | ["C2OX"] | 137.0000 | 145.0000 | 25 | 88 | false | false | true | true | |||||||||
| 01a0c578-5c77-72a1-92b8-60cf4cc1c0a5 | SHOP | 2026-09-21 15:36 | call_diagonal_spread | 2 | 1 | 100 | 203200.00 | short | bid | 137.1850 | 1.2000 | ["137","145"] | ["0.5025","0.5782"] | [] | ["C2OX"] | 137.0000 | 145.0000 | 25 | 88 | false | false | true | true | |||||||||
| 01a0c4be-8e0f-7353-ab1c-a1b9afeda11a | SHOP | 2026-09-21 12:13 | call_calendar | 2 | 1 | 55 | 280445.00 | short | bid | 130.6800 | 3.8000 | ["160"] | ["0.5523"] | [] | ["AMXO"] | 160.0000 | 160.0000 | 452 | 487 | false | true | true | false | false | ||||||||
| 01a0c42f-bb8f-7570-a408-bf536be6a3c4 | SHOP | 2026-09-21 09:37 | put_vertical_spread | 2 | 1 | 31 | 135036.00 | short | bid | 127.5600 | 2.1500 | ["100","105"] | ["0.5841","0.5848"] | ["102.60"] | ["XCBO"] | 100.0000 | 105.0000 | 816 | 816 | false | true | false | true | |||||||||
| 01a0b60f-a3b7-70f3-87f9-ca06a9d2aec8 | SHOP | 2026-09-18 15:47 | straddle | 2 | 1 | 50 | 317500.00 | short | bid | 127.9400 | 6.1000 | ["125"] | ["0.5653"] | ["61.50","188.50"] | ["SPHR"] | 125.0000 | 125.0000 | 490 | 490 | false | false | false | false | true | ||||||||
| 01a0b5f8-cc0f-7c90-839f-21f279c9cca6 | SHOP | 2026-09-18 15:22 | call_diagonal_spread | 2 | 1 | 19 | 181355.00 | short | bid | 127.7900 | 5.1000 | ["80","85"] | ["39.6639","0.5835"] | [] | ["XMIO"] | 80.0000 | 85.0000 | 0 | 182 | false | false | true | true | |||||||||
| 01a0b59f-f5e0-7413-8c5c-c977cd3fa134 | SHOP | 2026-09-18 13:45 | call_diagonal_spread | 2 | 1 | 23 | 178480.00 | short | bid | 127.3350 | 5.2000 | ["90","155"] | ["11.6076","0.5801"] | [] | ["ARCO"] | 90.0000 | 155.0000 | 0 | 854 | false | false | true | true | |||||||||
| 01a0afae-a903-7b62-93d0-e62700021c98 | SHOP | 2026-09-17 10:04 | put_calendar | 2 | 1 | 20 | 103900.00 | short | bid | 128.1950 | 2.1500 | ["110"] | ["0.5824"] | [] | ["XCBO"] | 110.0000 | 110.0000 | 820 | 855 | false | true | true | false | false | ||||||||
| 01a0afab-f59c-7bc3-ae2e-628540a88cb8 | SHOP | 2026-09-17 10:01 | put_calendar | 2 | 1 | 20 | 103380.00 | short | bid | 128.5100 | 3.0000 | ["110"] | ["0.5814"] | [] | ["XCBO"] | 110.0000 | 110.0000 | 820 | 855 | false | true | true | false | false | ||||||||
| 01a0afa8-0d9b-7ed1-81a1-12ebdb9d6761 | SHOP | 2026-09-17 09:56 | put_calendar | 2 | 1 | 30 | 125790.00 | short | bid | 129.0800 | 1.8000 | ["100"] | ["0.5835"] | [] | ["XCBO"] | 100.0000 | 100.0000 | 820 | 855 | false | true | true | false | false | ||||||||
| 01a0afa7-fa13-7200-bc6a-64274defd092 | SHOP | 2026-09-17 09:56 | put_calendar | 2 | 1 | 30 | 125820.00 | short | bid | 129.0800 | 1.8000 | ["100"] | ["0.5836"] | [] | ["XCBO"] | 100.0000 | 100.0000 | 820 | 855 | false | true | true | false | false | ||||||||
| 01a0afa7-e68b-76c1-8369-a0a9ca22df4b | SHOP | 2026-09-17 09:56 | put_calendar | 2 | 1 | 30 | 125700.00 | short | bid | 129.0087 | 2.3500 | ["100"] | ["0.5829"] | [] | ["XCBO"] | 100.0000 | 100.0000 | 820 | 855 | false | true | true | false | false | ||||||||
| 01a0abc1-55bb-7b62-b735-fdff70779e81 | SHOP | 2026-09-16 15:46 | call_vertical_spread | 2 | 1 | 15 | 141540.00 | short | bid | 129.5650 | 5.3000 | ["130","140"] | ["0.5938","0.5896"] | ["133.48"] | ["XMIO"] | 130.0000 | 140.0000 | 821 | 821 | false | true | false | true | |||||||||
| 01a0a585-6e1e-7061-ba3e-b191e2ee2768 | SHOP | 2026-09-15 10:42 | put_diagonal_spread | 2 | 1 | 60 | 207120.00 | short | bid | 130.7500 | 1.5500 | ["142","145"] | ["0.5375","0.5889"] | [] | ["BATO"] | 142.0000 | 145.0000 | 17 | 66 | false | false | true | true | |||||||||
| 01a0a181-0579-79c0-88ac-5c77705da8c9 | SHOP | 2026-09-14 15:59 | call_vertical_spread | 2 | 2 | 88 | 339504.00 | short | bid | 133.8200 | 5.4500 | ["110","120"] | ["1.1568","0.8189"] | ["119.80"] | ["SPHR","XMIO"] | 110.0000 | 120.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0a0a5-0cf9-7860-b2b5-22bae1ca934a | SHOP | 2026-09-14 11:59 | straddle | 2 | 1 | 425 | 767125.00 | short | bid | 133.1700 | 2.0000 | ["145"] | ["0.4726"] | ["126.95","163.05"] | ["XCBO"] | 145.0000 | 145.0000 | 32 | 32 | false | false | false | false | true | ||||||||
| 01a0a0a5-0cf9-7860-b2b5-22a525698d46 | SHOP | 2026-09-14 11:59 | straddle | 2 | 2 | 75 | 135375.00 | short | bid | 133.1700 | 2.0000 | ["145"] | ["0.4726"] | ["126.95","163.05"] | ["XCBO"] | 145.0000 | 145.0000 | 32 | 32 | false | false | false | false | true | ||||||||
| 01a091a7-2510-7093-9635-fd3e72d42dcb | SHOP | 2026-09-11 14:07 | call_diagonal_spread | 2 | 1 | 50 | 669750.00 | short | bid | 130.9100 | 5.4500 | ["65","70"] | ["3.4665","0.6189"] | [] | ["XCBO"] | 65.0000 | 70.0000 | 7 | 371 | false | false | true | true | |||||||||
| 01a08c36-d378-7861-87d4-b09d7e34cc3b | SHOP | 2026-09-10 12:46 | put_diagonal_spread | 2 | 2 | 60 | 133170.00 | short | bid | 126.6900 | 3.0500 | ["80","85"] | ["0.5917","0.5803"] | [] | ["EDGO","XISX"] | 80.0000 | 85.0000 | 463 | 827 | false | true | true | true | |||||||||
| 01a08c0c-b639-7ba3-8c81-23a9a72c9566 | SHOP | 2026-09-10 12:00 | call_diagonal_spread | 2 | 1 | 25 | 183475.00 | short | bid | 126.8350 | 2.6000 | ["120","130"] | ["0.5825","0.5819"] | [] | ["ARCO"] | 120.0000 | 130.0000 | 463 | 498 | false | false | true | true | |||||||||
| 01a08791-f7d0-7612-a242-b5d7e9bbe1fe | SHOP | 2026-09-09 15:08 | strangle | 2 | 1 | 176 | 105786.00 | short | bid | 127.3250 | 0.5400 | ["125","130"] | ["0.5148","0.5220"] | ["118.99","136.01"] | ["XISX"] | 125.0000 | 130.0000 | 9 | 9 | false | true | false | true | true | ||||||||
| 01a06dd1-c6a5-7233-9cc2-964a3df16e06 | SHOP | 2026-09-04 15:07 | call_calendar | 2 | 1 | 45 | 144720.00 | short | bid | 145.3700 | 3.5000 | ["130"] | ["4.6948"] | [] | ["XMIO"] | 130.0000 | 130.0000 | 0 | 7 | false | false | true | false | false | ||||||||
| 01a06dca-b60d-7461-81e0-3678ac42bcfb | SHOP | 2026-09-04 14:59 | call_calendar | 2 | 1 | 45 | 233550.00 | short | bid | 145.3300 | 5.7000 | ["120"] | ["6.7653"] | [] | ["SPHR"] | 120.0000 | 120.0000 | 0 | 7 | false | false | true | false | false | ||||||||
| 01a06d8d-189d-7523-90a1-cf8ec1b7634f | SHOP | 2026-09-04 13:52 | call_vertical_spread | 2 | 1 | 32 | 117280.00 | short | bid | 145.9650 | 2.0000 | ["165","200"] | ["0.5494","0.5432"] | ["174.27"] | ["AMXO"] | 165.0000 | 200.0000 | 286 | 286 | false | true | false | true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:27:16Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:42:20Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:01:40Z"} |
| 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-22T13:42:13Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:41:56Z"} |
| 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-21T19:36:46Z"} |
| 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-21T19:36:46Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:13:42Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:37:45Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:47:58Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:23:13Z"} |
| 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-18T17:46:22Z"} |
| 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-17T14:04:13Z"} |
| 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-17T14:01:22Z"} |
| 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: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: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:57:00Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:46:10Z"} |
| 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:43: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-14T19:59:58Z"} |
| 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-14T16:00:00Z"} |
| 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-14T16:00:00Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:08:06Z"} |
| 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-10T16:46:47Z"} |
| 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-10T16:00:56Z"} |
| 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:08:34Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:07:50Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:00:17Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:53:05Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |