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 |
|---|
| 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 |
|---|
| 01a0815c-c3e1-74d2-ab01-5d5254f9df42 | AAOI | 2026-09-08 10:12 | call_diagonal_spread | 2 | 1 | 11 | 111914.00 | short | bid | 112.5400 | 2.3000 | ["90","100"] | ["0.9816","0.9772"] | [] | ["XCBO"] | 90.0000 | 100.0000 | 282 | 500 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:12:29Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08170-b170-7b20-90e3-cbd38af400d3 | AAOI | 2026-09-08 10:33 | put_diagonal_spread | 2 | 1 | 32 | 113120.00 | short | bid | 115.6500 | 4.3000 | ["115","135"] | ["1.0390","0.9690"] | [] | ["SPHR"] | 115.0000 | 135.0000 | 10 | 45 | false | false | true | true | |||||||||
| 01a0817e-1720-7820-a1d8-16f1f9114091 | AAOI | 2026-09-08 10:48 | put_vertical_spread | 2 | 2 | 40 | 128182.00 | short | bid | 115.9500 | 1.3000 | ["95","110"] | ["0.9909","0.9945"] | ["102.49"] | ["MCRY","XMIO"] | 95.0000 | 110.0000 | 101 | 101 | false | true | false | true | |||||||||
| 01a081e6-9909-74a2-b9da-36e4ca777730 | AAOI | 2026-09-08 12:42 | put_calendar | 2 | 1 | 20 | 129860.00 | short | bid | 114.2800 | 3.8000 | ["145"] | ["1.0278"] | [] | ["XPHO"] | 145.0000 | 145.0000 | 10 | 24 | false | false | true | false | |||||||||
| 01a0827b-4b70-7b11-be29-1695d7b85329 | AAOI | 2026-09-08 15:25 | put_diagonal_spread | 2 | 1 | 40 | 168440.00 | short | bid | 112.7850 | 4.6000 | ["130","132"] | ["0.9121","0.8972"] | [] | ["XCBO"] | 130.0000 | 132.0000 | 10 | 24 | false | false | true | true | |||||||||
| 01a08c8d-4079-7540-8672-d17e0b2de92b | AAOI | 2026-09-10 14:20 | put_diagonal_spread | 2 | 5 | 49 | 115060.00 | short | bid | 103.8900 | 3.2857 | ["101","115"] | ["0.9039","1.5888"] | [] | ["EMLD","SPHR","XBOX","XPHO"] | 101.0000 | 115.0000 | 1 | 50 | false | false | true | true | |||||||||
| 01a09207-5611-7511-8bf2-4fd577a2ee15 | AAOI | 2026-09-11 15:52 | iron_butterfly | 4 | 1 | 88 | 106128.00 | short | ask | 105.7000 | 2.5500 | ["96","105","114"] | ["0.7538","0.7884","0.8129"] | ["98.68","111.32"] | ["XCBO"] | 96.0000 | 114.0000 | 7 | 7 | false | false | false | true | |||||||||
| 01a0a038-aec8-7692-a5b7-f375d10bf51c | AAOI | 2026-09-14 10:01 | call_diagonal_spread | 2 | 1 | 51 | 529431.00 | short | bid | 98.0300 | 5.8000 | ["100","105"] | ["0.9751","1.0061"] | [] | ["XISX"] | 100.0000 | 105.0000 | 641 | 858 | false | true | true | true | |||||||||
| 01a0a088-a770-7d43-8bbb-019138992e43 | AAOI | 2026-09-14 11:28 | call_vertical_spread | 2 | 1 | 50 | 313000.00 | short | bid | 98.1300 | 2.8000 | ["130","350"] | ["0.9884","0.9960"] | ["152.10"] | ["XMIO"] | 130.0000 | 350.0000 | 641 | 641 | false | true | false | true | |||||||||
| 01a0a626-da56-7270-bef9-708d6bf4bc69 | AAOI | 2026-09-15 13:39 | call_vertical_spread | 2 | 1 | 91 | 1216124.00 | short | bid | 95.7300 | 3.5000 | ["29","30"] | ["7.5905","7.3875"] | ["30"] | ["XCBO"] | 29.0000 | 30.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0b083-94d3-7a22-86b2-f8f5d5afcd7c | AAOI | 2026-09-17 13:56 | call_vertical_spread | 2 | 1 | 13 | 161590.00 | short | bid | 98.1200 | 4.4000 | ["36","37"] | ["10.8775","10.6810"] | ["36.98"] | ["XMIO"] | 36.0000 | 37.0000 | 1 | 1 | false | false | false | true | |||||||||
| 01a0b4de-4007-7fb3-82d6-a9e57a61e3ae | AAOI | 2026-09-18 10:14 | call_vertical_spread | 2 | 1 | 40 | 512160.00 | short | bid | 99.2800 | 3.1000 | ["35","36"] | ["20.1329","19.6252"] | ["36"] | ["XCBO"] | 35.0000 | 36.0000 | 0 | 0 | false | false | false | true | |||||||||
| 01a0b509-d447-7aa3-a675-df0a8ddeaafd | AAOI | 2026-09-18 11:01 | call_diagonal_spread | 2 | 2 | 50 | 410250.00 | short | bid | 100.3400 | 4.0000 | ["100","200"] | ["0.9611","0.9730"] | [] | ["MCRY"] | 100.0000 | 200.0000 | 490 | 854 | false | false | true | true | |||||||||
| 01a0b512-fc07-7662-b5c7-2a6d294b25fa | AAOI | 2026-09-18 11:11 | call_vertical_spread | 2 | 1 | 188 | 3005932.00 | short | bid | 100.6500 | 3.2000 | ["20","21"] | ["39.8179","37.4151"] | ["20.99"] | ["XISX"] | 20.0000 | 21.0000 | 0 | 0 | false | false | false | true | |||||||||
| 01a0b51a-899f-7b33-b8d8-d20a68c5771f | AAOI | 2026-09-18 11:20 | call_vertical_spread | 2 | 1 | 188 | 2748372.00 | short | bid | 100.5700 | 3.0000 | ["27","28"] | ["20.4828","20.7838"] | ["27.99"] | ["XISX"] | 27.0000 | 28.0000 | 0 | 0 | false | false | false | true | |||||||||
| 01a0b541-91cf-7d32-b42d-97511b133e53 | AAOI | 2026-09-18 12:02 | call_vertical_spread | 2 | 1 | 600 | 1200000.00 | short | bid | 101.0500 | 3.2000 | ["90","92"] | ["5.0901","4.4071"] | ["91.98"] | ["XMIO"] | 90.0000 | 92.0000 | 0 | 0 | false | false | false | true | |||||||||
| 01a0c474-fe07-73d1-93d0-485d9725a653 | AAOI | 2026-09-21 10:53 | call_vertical_spread | 2 | 1 | 88 | 328064.00 | short | bid | 107.1700 | 3.6000 | ["88","89"] | ["1.5709","1.4531"] | ["88.98"] | ["XCBO"] | 88.0000 | 89.0000 | 4 | 4 | true | false | false | true | |||||||||
| 01a0c49c-7396-7d93-be7e-c5d4b2da0654 | AAOI | 2026-09-21 11:36 | call_vertical_spread | 2 | 1 | 196 | 936684.00 | short | bid | 109.2700 | 3.2000 | ["85","86"] | ["1.1630","1.1347"] | ["85.99"] | ["XCBO"] | 85.0000 | 86.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0c4c1-c25f-7b20-8b03-0aed07e64b49 | AAOI | 2026-09-21 12:17 | call_vertical_spread | 2 | 1 | 88 | 361944.00 | short | bid | 109.0000 | 2.5000 | ["88","89"] | ["0.8443","0.8419"] | ["88.99"] | ["XCBO"] | 88.0000 | 89.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0c4c4-eaf7-7292-a8d5-59837cd50d29 | AAOI | 2026-09-21 12:20 | call_vertical_spread | 2 | 1 | 50 | 207450.00 | short | bid | 109.1450 | 2.6000 | ["88","89"] | ["0.9622","0.9394"] | ["88.99"] | ["XCBO"] | 88.0000 | 89.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0c4cd-3bdf-74a0-94a8-4503e11f116b | AAOI | 2026-09-21 12:29 | call_vertical_spread | 2 | 1 | 25 | 102225.00 | short | bid | 108.6000 | 2.2000 | ["88","89"] | ["1.2610","1.2139"] | ["88.99"] | ["XCBO"] | 88.0000 | 89.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0c4cd-7676-7970-b175-531c1b4446d4 | AAOI | 2026-09-21 12:29 | call_vertical_spread | 2 | 1 | 25 | 102225.00 | short | bid | 108.6450 | 2.2000 | ["88","89"] | ["1.2216","1.1766"] | ["88.99"] | ["XCBO"] | 88.0000 | 89.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0ca26-f836-7981-bf21-308897c19eb8 | AAOI | 2026-09-22 13:25 | call_vertical_spread | 2 | 1 | 88 | 350152.00 | short | bid | 106.5000 | 2.6000 | ["86","87"] | ["1.6365","1.6422"] | ["86.99"] | ["XCBO"] | 86.0000 | 87.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0ca41-13cf-70e2-8503-27905bf09d9d | AAOI | 2026-09-22 13:54 | strangle | 2 | 1 | 250 | 808503.00 | short | bid | 107.3400 | 1.3000 | ["95","120"] | ["0.9121","0.9312"] | ["62.66","152.34"] | ["EDGO"] | 95.0000 | 120.0000 | 115 | 115 | false | true | false | true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:34:05Z"} |
| 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-08T14:49:04Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:43:17Z"} |
| 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-08T19:25:40Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:21:45Z"} |
| 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-11T19:52:34Z"} |
| 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-14T14:01:12Z"} |
| 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-14T15:28:47Z"} |
| 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-15T17:40:08Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:57:08Z"} |
| 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-18T14:14:22Z"} |
| 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-18T15:02:07Z"} |
| 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-18T15:12:14Z"} |
| 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-18T15:20: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-18T16:03:25Z"} |
| 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-21T14:53:34Z"} |
| 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-21T15:36:32Z"} |
| 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-21T16:17:35Z"} |
| 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-21T16:20:46Z"} |
| 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-21T16:29:40Z"} |
| 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-21T16:30:08Z"} |
| 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-22T17:26:25Z"} |
| 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-22T17:54:19Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |