core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg541,738 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | direction |
|---|
| 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 |
|---|
| 01a08c0d-d749-7d50-a950-a8c2eb968786 | XBI | 2026-09-10 12:01 | put_vertical_spread | 2 | 2 | 195 | 245505.00 | long | ask | 157.0000 | 0.7200 | ["135","155"] | ["0.3321","0.3130"] | ["148.71"] | ["MCRY","XISX"] | 135.0000 | 155.0000 | 127 | 127 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:02:36Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c0b-a0e0-77d0-934b-1b8c5ed4c8ba | XBI | 2026-09-10 11:59 | put_vertical_spread | 2 | 1 | 87 | 109011.00 | unknown | — | 157.1700 | 0.6700 | ["135","155"] | ["0.3329","0.3135"] | [] | ["XCBO"] | 135.0000 | 155.0000 | 127 | 127 | false | true | false | true | false | ||||||||
| 01a08bf0-1de8-7a70-a57a-210d3ba694b1 | XBI | 2026-09-10 11:29 | put_diagonal_spread | 2 | 2 | 500 | 377000.00 | short | ask | 156.9800 | 2.3252 | ["156","163"] | ["0.3020","0.5422"] | [] | ["XMIO"] | 156.0000 | 163.0000 | 1 | 8 | false | false | true | ||||||||||
| 01a08b9a-aae8-7301-8ecb-802bcef05866 | XBI | 2026-09-10 09:56 | put_vertical_spread | 2 | 4 | 273 | 161421.00 | long | ask | 157.4600 | 0.4300 | ["155","159"] | ["0.3450","0.3325"] | ["157.19"] | ["C2OX","EDGO","XCBO","XISX"] | 155.0000 | 159.0000 | 8 | 8 | false | false | |||||||||||
| 01a08b97-43d0-7f73-a274-29f743590468 | XBI | 2026-09-10 09:52 | other | 4 | 1 | 150 | 799900.00 | unknown | — | 157.2100 | 9.0000 | ["133","140","143","150"] | ["0.8812","0.6488","0.2947","0.2822"] | [] | ["SPHR"] | 133.0000 | 150.0000 | 8 | 36 | false | false | true | true | false | ||||||||
| 01a08b8d-9b28-7eb1-80fc-9bb9f6ad077b | XBI | 2026-09-10 09:41 | put_vertical_spread | 2 | 1 | 250 | 187000.00 | short | bid | 156.9600 | 1.2500 | ["157","159"] | ["0.3513","0.3460"] | ["157.94"] | ["XMIO"] | 157.0000 | 159.0000 | 8 | 8 | false | false | false | ||||||||||
| 01a08722-78d8-7961-a29e-9f6951f376fc | XBI | 2026-09-09 13:06 | call_vertical_spread | 2 | 1 | 55 | 176000.00 | long | ask | 160.5100 | 1.9500 | ["143","150"] | ["0.3095","0.3047"] | ["148.78"] | ["XPHO"] | 143.0000 | 150.0000 | 37 | 37 | false | false | false | ||||||||||
| 01a08699-3c08-7ff3-a479-1e5697f2e7c6 | XBI | 2026-09-09 10:36 | put_vertical_spread | 2 | 5 | 516 | 171828.00 | short | bid | 160.4700 | 0.3100 | ["159","161"] | ["0.4045","0.3837"] | ["160.17"] | ["ARCO","BATO","EMLD","XBOX","XISX"] | 159.0000 | 161.0000 | 2 | 2 | false | false | |||||||||||
| 01a08296-41c8-7f43-a643-ff52e8fe0cba | XBI | 2026-09-08 15:54 | put_vertical_spread | 2 | 4 | 347 | 128278.00 | unknown | — | 161.9250 | 0.3600 | ["161","162"] | ["0.3565","0.3508"] | [] | ["ARCO","EDGO","XCBO","XISX"] | 161.0000 | 162.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a08296-41c8-7f43-a643-ff4d6b2a1458 | XBI | 2026-09-08 15:54 | put_vertical_spread | 2 | 5 | 356 | 133596.00 | short | bid | 161.9250 | 0.3693 | ["161","162"] | ["0.3619","0.3550"] | ["161.57"] | ["EMLD","MCRY","XBOX","XMIO","XPHO"] | 161.0000 | 162.0000 | 3 | 3 | false | false | |||||||||||
| 01a081d1-0d68-7641-bd11-140fbe171c1a | XBI | 2026-09-08 12:19 | other | 2 | 1 | 511 | 429002.00 | unknown | — | 162.7800 | 2.3000 | ["160","167"] | ["0.3363","0.3227"] | [] | ["AMXO"] | 160.0000 | 167.0000 | 10 | 38 | false | false | true | true | false | ||||||||
| 01a06db2-c13d-75e2-9044-0c2897c1fe1b | XBI | 2026-09-04 14:33 | other | 2 | 1 | 9 | 108900.00 | unknown | — | 163.7750 | 4.8000 | ["105","110"] | ["0.4731","0.3180"] | [] | ["XCBO"] | 105.0000 | 110.0000 | 133 | 469 | false | false | true | true | false |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:59:33Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:29:52Z"} |
| 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-10T13:56:10Z"} |
| 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-10T13:52:30Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T13:42:01Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:07:08Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:36:25Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:54:42Z"} |
| 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-08T19:54:42Z"} |
| 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-08T16:19:52Z"} |
| 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-04T18:34:19Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |