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 |
|---|
| 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 |
|---|
| 01a0d8e4-73f0-76b3-934c-0a3acd19cfda | BIDU | 2026-09-25 10:07 | put_calendar | 2 | 1 | 84 | 294000.00 | short | ask | 87.5250 | 6.7500 | ["105"] | ["0.6775"] | [] | ["XISX"] | 105.0000 | 105.0000 | 14 | 42 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T14:07:30Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d8d5-d5bf-7420-a1e2-f41dc68f4e51 | BIDU | 2026-09-25 09:51 | put_calendar | 2 | 1 | 70 | 119700.00 | short | ask | 87.7400 | 2.7000 | ["96"] | ["1.5448"] | [] | ["XCBO"] | 96.0000 | 96.0000 | 0 | 7 | false | false | |||||||||||
| 01a0d4ba-0037-7bb1-890c-dc6056c3ada4 | BIDU | 2026-09-24 14:42 | other | 6 | 1 | 1461 | 3831522.00 | unknown | ask | 88.1060 | 10.9500 | ["94","95","96","98","150","165"] | ["1.4945","1.1910","1.4147","2.4920","0.6270","0.7604"] | [] | ["XBOX"] | 94.0000 | 165.0000 | 1 | 266 | false | false | |||||||||||
| 01a0ce84-f73f-78f1-b18c-320b791ca27d | BIDU | 2026-09-23 09:46 | put_vertical_spread | 2 | 1 | 22 | 107096.00 | long | ask | 89.5850 | 2.7500 | ["85","130"] | ["0.4397","0.5148"] | ["96.62"] | ["XCBO"] | 85.0000 | 130.0000 | 177 | 177 | false | false | |||||||||||
| 01a0ca6e-bb4f-70d1-841f-010d77675261 | BIDU | 2026-09-22 14:44 | put_diagonal_spread | 2 | 1 | 1000 | 1289000.00 | unknown | ask | 92.3100 | 0.8500 | ["80","100"] | ["0.4465","0.4581"] | [] | ["SPHR"] | 80.0000 | 100.0000 | 87 | 268 | false | false | |||||||||||
| 01a0b4eb-8a5f-7d62-a0ab-48c0bc23413f | BIDU | 2026-09-18 10:28 | call_calendar | 2 | 1 | 60 | 128160.00 | unknown | ask | 90.2300 | 3.8000 | ["80"] | ["1.6668"] | [] | ["XISX"] | 80.0000 | 80.0000 | 0 | 14 | false | false | |||||||||||
| 01a0afa5-276b-7621-932e-791c960e2b1d | BIDU | 2026-09-17 09:53 | call_condor | 4 | 1 | 15 | 128850.00 | long | ask | 89.4900 | 5.6000 | ["100","105","115","120"] | ["0.4552","0.4617","0.4469","0.4567"] | ["100.50","119.50"] | ["XCBO"] | 100.0000 | 120.0000 | 855 | 855 | false | true | |||||||||||
| 01a0aa89-df5b-7a90-aba8-ebcf3a321ee8 | BIDU | 2026-09-16 10:05 | put_diagonal_spread | 2 | 1 | 35 | 126385.00 | long | ask | 88.9011 | 1.5000 | ["100","105"] | ["0.4592","0.4654"] | [] | ["XCBO"] | 100.0000 | 105.0000 | 121 | 184 | false | false | |||||||||||
| 01a0a68e-335d-7eb3-a68a-ad5b9c01d6ac | BIDU | 2026-09-15 15:32 | put_calendar | 2 | 3 | 384 | 447301.00 | long | ask | 90.6400 | 0.7000 | ["96"] | ["0.4759"] | [] | ["ARCO","C2OX","XISX"] | 96.0000 | 96.0000 | 3 | 10 | false | false | |||||||||||
| 01a0a67e-b29e-7153-b1dc-0f00a130bb00 | BIDU | 2026-09-15 15:15 | put_calendar | 2 | 2 | 444 | 515040.00 | long | ask | 90.5801 | 0.9000 | ["96"] | ["0.4285"] | [] | ["C2OX","EDGO"] | 96.0000 | 96.0000 | 3 | 10 | false | false | |||||||||||
| 01a0a5e6-3776-7930-a7d7-4e0605804047 | BIDU | 2026-09-15 12:28 | put_calendar | 2 | 1 | 699 | 959028.00 | long | ask | 90.4925 | 0.9500 | ["97"] | ["0.4998"] | [] | ["XMIO"] | 97.0000 | 97.0000 | 3 | 10 | false | false | |||||||||||
| 01a0a576-d3d6-75c2-a360-412ce23e147f | BIDU | 2026-09-15 10:27 | call_vertical_spread | 2 | 1 | 145 | 158775.00 | long | ask | 90.7500 | 1.1000 | ["110","115"] | ["0.4579","0.4596"] | ["111.05"] | ["XMIO"] | 110.0000 | 115.0000 | 185 | 185 | false | true | |||||||||||
| 01a0a54f-23ae-7ae1-a5b0-47873659ddce | BIDU | 2026-09-15 09:43 | put_calendar | 2 | 1 | 40 | 235000.00 | long | ask | 91.6000 | 3.1000 | ["120"] | ["0.5425"] | [] | ["XISX"] | 120.0000 | 120.0000 | 66 | 94 | false | false | |||||||||||
| 01a08c0c-8370-7d93-bf11-f4290b9f8e6d | BIDU | 2026-09-10 12:00 | call_diagonal_spread | 2 | 3 | 156 | 181194.00 | long | ask | 90.8050 | 1.1500 | ["88","90"] | ["0.3997","0.3940"] | [] | ["AMXO","ARCO","XCBO"] | 88.0000 | 90.0000 | 29 | 50 | false | false | |||||||||||
| 01a08239-1639-7970-91fb-d7af2e1f74b4 | BIDU | 2026-09-08 14:12 | call_vertical_spread | 2 | 1 | 310 | 183520.00 | long | ask | 92.0950 | 0.5400 | ["100","125"] | ["0.4650","0.5059"] | ["103.80"] | ["XMIO"] | 100.0000 | 125.0000 | 73 | 73 | false | true | |||||||||||
| 01a0820d-1499-7913-a102-3d0568d56186 | BIDU | 2026-09-08 13:24 | call_vertical_spread | 2 | 1 | 1031 | 603135.00 | long | ask | 92.2400 | 0.4200 | ["100","125"] | ["0.4607","0.4962"] | ["103.85"] | ["XPHO"] | 100.0000 | 125.0000 | 73 | 73 | true | true | |||||||||||
| 01a0814c-8f71-7343-8cbb-01baae9e82a5 | BIDU | 2026-09-08 09:54 | call_vertical_spread | 2 | 1 | 110 | 106590.00 | long | ask | 91.3300 | 0.6500 | ["105","110"] | ["0.4521","0.4554"] | ["106.15"] | ["BATO"] | 105.0000 | 110.0000 | 129 | 129 | false | true | |||||||||||
| 01a0814a-d608-78c0-834c-a29cb8983a19 | BIDU | 2026-09-08 09:52 | call_vertical_spread | 2 | 1 | 78 | 205842.00 | long | ask | 91.4000 | 1.2000 | ["95","100"] | ["0.4522","0.4521"] | ["96.89"] | ["XMIO"] | 95.0000 | 100.0000 | 282 | 282 | false | true |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T13:51:43Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:43:24Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T13:47:02Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:44:25Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:29:05Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:54:03Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:06:07Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:32:31Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:15:35Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:29:00Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:27:11Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T13:43:54Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| 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 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:13:09Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:25:27Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:54:31Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:52:48Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |