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 | 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 |
|---|
| 01a08236-3bc0-7963-83d8-1a3403d60e8b | WDC | 2026-09-08 14:09 | risk_reversal | 2 | 1 | 8 | 31480.00 | long | ask | 487.6100 | 2.8000 | ["300","750"] | ["0.7570","0.7854"] | ["766.61"] | ["XMIO"] | 300.0000 | 750.0000 | 129 | 129 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:10:16Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08689-9438-7b90-a612-16a63afba74c | WDC | 2026-09-09 10:19 | risk_reversal | 3 | 1 | 2 | 38304.00 | long | ask | 486.5500 | 23.2500 | ["280","550","800"] | ["0.7574","0.7580","0.7624"] | ["578.60"] | ["XCBO"] | 280.0000 | 800.0000 | 281 | 281 | false | true | false | true | |||||||||
| 01a08bc4-56e0-7482-8367-6dff6227b9b9 | WDC | 2026-09-10 10:41 | risk_reversal | 2 | 1 | 5 | 68440.00 | short | bid | 467.2500 | 4.8000 | ["420","550"] | ["0.7218","0.7267"] | ["557.42"] | ["XCBO"] | 420.0000 | 550.0000 | 190 | 190 | false | true | false | true | |||||||||
| 01a091b3-c770-79e3-bb6e-2ee7038ccc09 | WDC | 2026-09-11 14:21 | risk_reversal | 2 | 1 | 11 | 183491.00 | long | ask | 450.0600 | 11.0000 | ["350","720"] | ["0.7288","0.7263"] | ["735.33"] | ["C2OX"] | 350.0000 | 720.0000 | 497 | 497 | false | true | false | true | |||||||||
| 01a091b3-c770-79e3-bb6e-2ed9d071ba38 | WDC | 2026-09-11 14:21 | risk_reversal | 2 | 1 | 10 | 166810.00 | long | ask | 450.0600 | 11.0000 | ["350","720"] | ["0.7288","0.7263"] | ["735.33"] | ["C2OX"] | 350.0000 | 720.0000 | 497 | 497 | false | true | false | true | |||||||||
| 01a0a0b8-5a60-74e1-9abe-336168a4a1e1 | WDC | 2026-09-14 12:20 | risk_reversal | 2 | 1 | 9 | 137160.00 | long | ask | 428.6600 | 13.2000 | ["340","730"] | ["0.7058","0.7306"] | ["734.50"] | ["BATO"] | 340.0000 | 730.0000 | 494 | 494 | false | true | false | true | |||||||||
| 01a0a5e4-dbce-7753-a048-f8f94746d736 | WDC | 2026-09-15 12:27 | risk_reversal | 3 | 1 | 2 | 31392.00 | short | ask | 412.8950 | 11.0700 | ["450","530"] | ["0.8029","1.2479"] | ["450.66"] | ["XCBO"] | 450.0000 | 530.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0aa7c-fa94-75a3-82af-681edb17f86b | WDC | 2026-09-16 09:51 | risk_reversal | 2 | 1 | 5 | 59310.00 | long | bid | 427.7947 | 9.0500 | ["420","550"] | ["0.6785","0.6805"] | ["395.42"] | ["XCBO"] | 420.0000 | 550.0000 | 184 | 184 | false | true | false | true | |||||||||
| 01a0aab7-6f6b-7892-89a7-0afa5efaf9ba | WDC | 2026-09-16 10:55 | risk_reversal | 2 | 1 | 10 | 172340.00 | short | bid | 425.6700 | 10.8500 | ["360","650"] | ["0.7224","0.7092"] | ["653.00"] | ["MCRY"] | 360.0000 | 650.0000 | 492 | 492 | false | true | false | true | |||||||||
| 01a0aab7-6f6b-7892-89a7-0ae4f9303631 | WDC | 2026-09-16 10:55 | risk_reversal | 2 | 1 | 5 | 84150.00 | short | bid | 425.6700 | 4.4500 | ["360","650"] | ["0.7094","0.6989"] | ["653.00"] | ["XBOX"] | 360.0000 | 650.0000 | 492 | 492 | false | true | false | true | |||||||||
| 01a0ab2b-286b-78d1-915d-562827532d7c | WDC | 2026-09-16 13:02 | risk_reversal | 2 | 1 | 20 | 194220.00 | long | bid | 426.0000 | 3.9000 | ["430","540"] | ["0.6771","0.6768"] | ["397.63"] | ["C2OX"] | 430.0000 | 540.0000 | 121 | 121 | false | false | false | true | |||||||||
| 01a0ab2c-0afb-7fb3-9d63-a1d1f9d31528 | WDC | 2026-09-16 13:03 | risk_reversal | 2 | 1 | 4 | 42008.00 | long | bid | 425.7800 | 4.8000 | ["430","510"] | ["0.6800","0.6812"] | ["404.80"] | ["C2OX"] | 430.0000 | 510.0000 | 121 | 121 | false | false | false | true | |||||||||
| 01a0ab2c-0afb-7fb3-9d63-a1c5d9646cd3 | WDC | 2026-09-16 13:03 | risk_reversal | 2 | 1 | 20 | 210600.00 | short | ask | 425.7800 | 4.4000 | ["430","510"] | ["0.6814","0.6826"] | ["404.80"] | ["C2OX"] | 430.0000 | 510.0000 | 121 | 121 | false | false | false | true | |||||||||
| 01a0ab2c-ddeb-7a23-8251-2eb4507713af | WDC | 2026-09-16 13:03 | risk_reversal | 2 | 1 | 5 | 49420.00 | short | ask | 425.8600 | 3.6500 | ["450","600"] | ["0.6808","0.6822"] | ["395"] | ["C2OX"] | 450.0000 | 600.0000 | 121 | 121 | false | false | false | true | |||||||||
| 01a0ab2d-f72b-7a03-8201-9b4d825f8f80 | WDC | 2026-09-16 13:05 | risk_reversal | 2 | 2 | 10 | 96085.00 | short | ask | 426.1104 | 5.3500 | ["470","850"] | ["0.6863","0.7442"] | ["386.20"] | ["AMXO","C2OX"] | 470.0000 | 850.0000 | 121 | 121 | false | false | false | true | |||||||||
| 01a0ab2e-7bfb-7d73-abf9-085e3f905a31 | WDC | 2026-09-16 13:05 | risk_reversal | 2 | 1 | 15 | 144795.00 | short | ask | 425.9850 | 5.0000 | ["470","850"] | ["0.6901","0.7446"] | ["385.77"] | ["C2OX"] | 470.0000 | 850.0000 | 121 | 121 | false | false | false | true | |||||||||
| 01a0ab8d-60f3-7912-b4bd-7a27303f9a8a | WDC | 2026-09-16 14:49 | risk_reversal | 3 | 1 | 1040 | 8798400.00 | short | ask | 423.4800 | 9.4500 | ["340","420","510"] | ["0.6837","0.7131","0.7222"] | ["410.50"] | ["XBOX"] | 340.0000 | 510.0000 | 65 | 65 | true | true | false | true | |||||||||
| 01a0c43b-4897-7450-b9f0-8f24a6b56145 | WDC | 2026-09-21 09:50 | risk_reversal | 2 | 1 | 10 | 119750.00 | long | ask | 445.8000 | 16.0000 | ["420","550"] | ["0.6294","0.7427"] | ["552.25"] | ["SPHR"] | 420.0000 | 550.0000 | 179 | 179 | false | true | false | true | |||||||||
| 01a0ca21-2fbf-7ff3-a639-0111a1797bc1 | WDC | 2026-09-22 13:19 | risk_reversal | 2 | 1 | 11 | 212124.00 | short | bid | 456.3400 | 26.5000 | ["370","840"] | ["0.7238","0.7297"] | ["844.00"] | ["XCBO"] | 370.0000 | 840.0000 | 633 | 633 | false | true | false | true | |||||||||
| 01a0d4cb-a3d7-7b61-b0a0-b6cbfb79c645 | WDC | 2026-09-24 15:01 | risk_reversal | 2 | 4 | 4 | 49667.00 | long | bid | 454.7750 | 6.1625 | ["420","550"] | ["0.6941","0.7209"] | ["419.14"] | ["ARCO","EMLD","SPHR"] | 420.0000 | 550.0000 | 176 | 176 | false | true | false | true |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:19:30Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:41:37Z"} |
| 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-11T18:21:20Z"} |
| 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-11T18:21:20Z"} |
| 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-14T16:20:47Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:27:23Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:51:53Z"} |
| 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:56:19Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:56:19Z"} |
| 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-16T17:02:17Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:03:24Z"} |
| 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-16T17:03:24Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:04:28Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:05:34Z"} |
| 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-16T17:06:44Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:49:52Z"} |
| 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-21T13:50:15Z"} |
| 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:19:36Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:02:01Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |