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-bd3f-7e92-84ba-ce6bf242e37f | BIDU | 2026-09-22 14:59 | put_diagonal_spread | 2 | 1 | 1000 | 1214500.00 | unknown | bid | 92.3703 | 0.8500 | ["80","110"] | ["0.4454","0.4551"] | [] | ["XBOX"] | 80.0000 | 110.0000 | 178 | 268 | false | false | true | true | false | mlft | 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 |
| 01a0b599-6247-7712-b9c2-2aac414d74a3 | BIDU | 2026-09-18 13:38 | straddle | 2 | 4 | 154 | 352814.00 | short | bid | 90.0550 | 0.6500 | ["95"] | ["0.4440"] | ["72.09","117.91"] | ["ARCO","EMLD","SPHR","XBOX"] | 95.0000 | 95.0000 | 182 | 182 | false | false | false | false | true | ||||||||
| 01a0b51d-ecd0-7552-9824-ba6aedd461bd | BIDU | 2026-09-18 11:23 | put_calendar | 2 | 7 | 558 | 199622.00 | unknown | bid | 89.8500 | 0.3829 | ["91"] | ["0.3417"] | [] | ["AMXO","ARCO","XISX","XPHO"] | 91.0000 | 91.0000 | 0 | 7 | false | false | true | false | false | ||||||||
| 01a0b51d-a67f-72c1-b058-cd7ee1bf480b | BIDU | 2026-09-18 11:23 | put_calendar | 2 | 3 | 313 | 113703.00 | long | bid | 89.8600 | 0.3200 | ["91"] | ["0.4145"] | [] | ["C2OX","EDGO","XMIO"] | 91.0000 | 91.0000 | 0 | 7 | false | false | true | false | false | ||||||||
| 01a0b518-7277-7320-af41-5dbcdae95743 | BIDU | 2026-09-18 11:17 | put_calendar | 2 | 5 | 587 | 213387.00 | long | bid | 89.8620 | 0.4439 | ["91"] | ["0.4154"] | [] | ["AMXO","ARCO","XISX","XMIO","XPHO"] | 91.0000 | 91.0000 | 0 | 7 | false | false | true | false | false | ||||||||
| 01a0b4f8-1937-7f83-a39f-980db4f1d5e5 | BIDU | 2026-09-18 10:42 | call_diagonal_spread | 2 | 1 | 35 | 104790.00 | short | bid | 90.2350 | 1.0500 | ["120","125"] | ["0.4582","0.4599"] | [] | ["XCBO"] | 120.0000 | 125.0000 | 490 | 854 | false | true | true | true | |||||||||
| 01a0aae1-d6e3-7e53-8147-b1403dd8b2c0 | BIDU | 2026-09-16 11:41 | put_vertical_spread | 2 | 1 | 18 | 135420.00 | short | bid | 89.4700 | 2.1500 | ["110","140"] | ["0.4797","0.5793"] | ["113.30"] | ["XISX"] | 110.0000 | 140.0000 | 184 | 184 | false | false | false | true | |||||||||
| 01a0a68e-2f76-7643-8c04-1605000a4711 | BIDU | 2026-09-15 15:32 | put_calendar | 2 | 1 | 354 | 413472.00 | long | bid | 90.6400 | 0.7500 | ["96"] | ["0.4836"] | [] | ["XMIO"] | 96.0000 | 96.0000 | 3 | 10 | false | false | true | false | false | ||||||||
| 01a0a594-71de-7fd0-9e5e-ee7aac9c0230 | BIDU | 2026-09-15 10:59 | call_diagonal_spread | 2 | 1 | 50 | 146700.00 | long | bid | 90.2700 | 1.4000 | ["90","100"] | ["0.4557","0.4580"] | [] | ["XMIO"] | 90.0000 | 100.0000 | 275 | 367 | false | false | true | true | false | ||||||||
| 01a0a0fd-d388-7b72-93b4-2b4ae19343df | BIDU | 2026-09-14 13:36 | call_calendar | 2 | 1 | 200 | 202000.00 | short | bid | 92.5400 | 0.5000 | ["95"] | ["0.4406"] | [] | ["XMIO"] | 95.0000 | 95.0000 | 32 | 67 | false | true | true | false | false | ||||||||
| 01a0a0fd-0868-7080-aaa9-b7ead0903550 | BIDU | 2026-09-14 13:35 | call_calendar | 2 | 1 | 200 | 202200.00 | short | bid | 92.5800 | 0.5500 | ["95"] | ["0.4394"] | [] | ["XISX"] | 95.0000 | 95.0000 | 32 | 67 | false | true | true | false | false | ||||||||
| 01a0a08b-6a78-7152-bd17-3f5e31a1dda9 | BIDU | 2026-09-14 11:31 | call_calendar | 2 | 1 | 55 | 266090.00 | short | bid | 92.0750 | 1.4500 | ["70"] | ["0.4648"] | [] | ["ARCO"] | 70.0000 | 70.0000 | 95 | 123 | false | false | true | false | false | ||||||||
| 01a0a08b-6690-71b2-b6f5-cf02e0c2a140 | BIDU | 2026-09-14 11:31 | call_calendar | 2 | 2 | 50 | 241900.00 | short | bid | 92.0750 | 1.4500 | ["70"] | ["0.4644"] | [] | ["ARCO","XISX"] | 70.0000 | 70.0000 | 95 | 123 | false | false | true | false | false | ||||||||
| 01a09184-5eb8-7bc3-b9a0-622c2b752111 | BIDU | 2026-09-11 13:29 | put_vertical_spread | 2 | 1 | 80 | 106720.00 | short | bid | 91.7700 | 1.0000 | ["97","98"] | ["0.4170","0.4250"] | ["97.18"] | ["XCBO"] | 97.0000 | 98.0000 | 14 | 14 | false | false | false | true | |||||||||
| 01a08cdf-e0d0-7492-b2bc-ac32519a1324 | BIDU | 2026-09-10 15:51 | put_calendar | 2 | 1 | 115 | 126270.00 | short | bid | 90.7300 | 0.9000 | ["96"] | ["0.4801"] | [] | ["XCBO"] | 96.0000 | 96.0000 | 1 | 8 | false | false | true | false | false | ||||||||
| 01a08cdf-d901-79f0-9107-dd73cee39db1 | BIDU | 2026-09-10 15:51 | put_calendar | 2 | 3 | 723 | 792649.00 | short | bid | 90.7300 | 0.9500 | ["96"] | ["0.4613"] | [] | ["C2OX","XCBO","XISX"] | 96.0000 | 96.0000 | 1 | 8 | false | false | true | false | false | ||||||||
| 01a08cdf-d901-79f0-9107-dd56baf57b24 | BIDU | 2026-09-10 15:51 | put_calendar | 2 | 4 | 967 | 1053560.00 | short | bid | 90.7300 | 1.0343 | ["96"] | ["0.5337"] | [] | ["AMXO","ARCO","XMIO","XPHO"] | 96.0000 | 96.0000 | 1 | 8 | false | false | true | false | false | ||||||||
| 01a08cdf-d518-7501-a66f-1af531790ab2 | BIDU | 2026-09-10 15:51 | put_calendar | 2 | 1 | 167 | 182030.00 | short | bid | 90.7300 | 1.1000 | ["96"] | ["0.6389"] | [] | ["XPHO"] | 96.0000 | 96.0000 | 1 | 8 | false | false | true | false | false | ||||||||
| 01a08bde-ef79-78f0-8bef-7a464d3fdecd | BIDU | 2026-09-10 11:10 | risk_reversal | 2 | 4 | 100 | 164200.00 | long | bid | 90.9200 | 0.9000 | ["90","110"] | ["0.4413","0.4617"] | ["86.21"] | ["ARCO","MCRY","XBOX","XCBO"] | 90.0000 | 110.0000 | 190 | 190 | false | true | false | true | |||||||||
| 01a08bd6-cd70-75f2-b546-6cef0ca65c5e | BIDU | 2026-09-10 11:01 | strangle | 2 | 4 | 69 | 113160.00 | short | bid | 90.9650 | 0.9000 | ["90","110"] | ["0.4447","0.4574"] | ["73.60","126.40"] | ["ARCO","EDGO","XBOX","XPHO"] | 90.0000 | 110.0000 | 190 | 190 | false | true | false | true | |||||||||
| 01a08bd2-8f80-7b53-996a-0af0551865fe | BIDU | 2026-09-10 10:57 | put_calendar | 2 | 1 | 699 | 910100.00 | short | bid | 91.0750 | 2.3500 | ["97"] | ["0.8196"] | [] | ["XMIO"] | 97.0000 | 97.0000 | 1 | 8 | false | false | true | false | false | ||||||||
| 01a08ba1-afc8-7973-b89c-400d8df21700 | BIDU | 2026-09-10 10:03 | call_vertical_spread | 2 | 7 | 42 | 103996.00 | short | bid | 90.1200 | 1.2500 | ["95","100"] | ["0.4553","0.4552"] | ["96.81"] | ["AMXO","ARCO","EMLD","MCRY","XBOX","XMIO","XPHO"] | 95.0000 | 100.0000 | 280 | 280 | false | true | false | true | |||||||||
| 01a08b8f-3550-7dd3-8f76-2f21e32ee293 | BIDU | 2026-09-10 09:43 | call_vertical_spread | 2 | 1 | 110 | 126280.00 | short | bid | 89.9300 | 2.1500 | ["100","105"] | ["0.4660","0.4614"] | ["101.50"] | ["XMIO"] | 100.0000 | 105.0000 | 127 | 127 | false | true | false | true | |||||||||
| 01a08238-eb40-7623-bbc9-017bad4a2ce2 | BIDU | 2026-09-08 14:12 | call_vertical_spread | 2 | 3 | 190 | 112298.00 | short | bid | 92.0150 | 0.5400 | ["100","125"] | ["0.4651","0.5096"] | ["103.75"] | ["AMXO","XMIO","XPHO"] | 100.0000 | 125.0000 | 73 | 73 | false | true | false | true | |||||||||
| 01a08213-8508-76c0-acbc-605bc6204844 | BIDU | 2026-09-08 13:31 | call_vertical_spread | 2 | 1 | 500 | 290500.00 | short | bid | 92.0250 | 0.4700 | ["100","125"] | ["0.4617","0.5031"] | ["103.75"] | ["XMIO"] | 100.0000 | 125.0000 | 73 | 73 | false | true | false | true | |||||||||
| 01a0813d-06e1-7660-8507-106616881423 | BIDU | 2026-09-08 09:37 | call_calendar | 2 | 1 | 135 | 122310.00 | short | bid | 91.1400 | 2.1000 | ["115"] | ["0.4691"] | [] | ["XMIO"] | 115.0000 | 115.0000 | 129 | 192 | false | true | true | false | false | ||||||||
| 01a06df7-1185-71d2-98fd-62e415def4b6 | BIDU | 2026-09-04 15:48 | call_vertical_spread | 2 | 1 | 943 | 258382.00 | short | bid | 99.3350 | 0.1900 | ["100","105"] | ["0.4277","0.4514"] | ["101.40"] | ["ARCO"] | 100.0000 | 105.0000 | 7 | 7 | false | true | false | true |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:38:44Z"} |
| 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-18T15:23:50Z"} |
| 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-18T15:23:50Z"} |
| 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-18T15:18:08Z"} |
| 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-18T14:42:38Z"} |
| 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-16T15:42:10Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| 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 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:59:33Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:36:34Z"} |
| 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-14T17:35:39Z"} |
| 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-14T15:31:41Z"} |
| 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-14T15:31:41Z"} |
| 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-11T17:30:02Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:51:33Z"} |
| 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-10T19:51:33Z"} |
| 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-10T19:51:33Z"} |
| 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-10T19:51:33Z"} |
| 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-10T15:11:16Z"} |
| 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-10T15:02:15Z"} |
| 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-10T14:57:20Z"} |
| 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-10T14:03:44Z"} |
| 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-10T13:43:44Z"} |
| 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-08T18:13:09Z"} |
| 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-08T17:31:50Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:37:49Z"} |
| 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-04T19:48:38Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |