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 | 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 |
|---|
| 01a08191-1668-7db1-b69b-4d3c4109122d | CIFR | 2026-09-08 11:09 | call_diagonal_spread | 2 | 1 | 1000 | 155000.00 | unknown | — | 18.6800 | 0.1000 | ["18.5","20.5"] | ["1.1961","1.0579"] | [] | ["XISX"] | 18.5000 | 20.5000 | 3 | 10 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:09:46Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0818c-bd21-7961-85b9-2ab390066868 | CIFR | 2026-09-08 11:04 | call_vertical_spread | 2 | 2 | 1000 | 598738.00 | short | bid | 18.6500 | 0.4400 | ["15.5","16.5"] | ["1.0541","1.0609"] | ["16.28"] | ["BATO","XISX"] | 15.5000 | 16.5000 | 10 | 10 | false | false | |||||||||||
| 01a08182-35d0-7973-93f8-680eceb14d26 | CIFR | 2026-09-08 10:53 | call_vertical_spread | 2 | 1 | 800 | 167200.00 | unknown | — | 18.6900 | 0.1600 | ["18.5","20.5"] | ["1.0547","1.0904"] | [] | ["XISX"] | 18.5000 | 20.5000 | 10 | 10 | false | false | false | true | false | ||||||||
| 01a0817e-78c9-79f1-8377-fdae688265d1 | CIFR | 2026-09-08 10:49 | put_calendar | 2 | 1 | 92 | 126040.00 | short | bid | 18.4950 | 0.9500 | ["24"] | ["1.1051"] | [] | ["XISX"] | 24.0000 | 24.0000 | 38 | 73 | false | false | true | ||||||||||
| 01a0817a-e2d0-7440-8999-86c60af4e323 | CIFR | 2026-09-08 10:45 | call_diagonal_spread | 2 | 1 | 411 | 133164.00 | unknown | — | 18.4150 | 0.3300 | ["20","25"] | ["1.0362","1.0651"] | [] | ["XMIO"] | 20.0000 | 25.0000 | 31 | 73 | false | true | true | true | false | ||||||||
| 01a08161-fbd0-7901-92ce-a7d41a690944 | CIFR | 2026-09-08 10:17 | call_diagonal_spread | 2 | 1 | 357 | 135660.00 | short | bid | 18.4650 | 0.3100 | ["20","26"] | ["1.0386","1.0293"] | [] | ["XMIO"] | 20.0000 | 26.0000 | 38 | 101 | false | true | true | ||||||||||
| 01a08155-3649-78b0-aa68-578dafe06ab9 | CIFR | 2026-09-08 10:03 | call_vertical_spread | 2 | 1 | 820 | 209920.00 | unknown | — | 18.3765 | 0.2100 | ["18","19"] | ["1.0700","1.0965"] | [] | ["XISX"] | 18.0000 | 19.0000 | 10 | 10 | false | false | false | true | false | ||||||||
| 01a0814f-98c8-7c62-af99-e47e6d923567 | CIFR | 2026-09-08 09:57 | other | 2 | 1 | 5000 | 587500.00 | unknown | — | 18.1050 | 0.1300 | ["18","19"] | ["1.3697","1.3192"] | [] | ["SPHR"] | 18.0000 | 19.0000 | 3 | 3 | false | false | false | true | false | ||||||||
| 01a08149-99a1-7893-ba04-68ca45aeb871 | CIFR | 2026-09-08 09:51 | call_backspread | 2 | 1 | 1710 | 220590.00 | unknown | — | 17.9100 | 0.1700 | ["17","18.5"] | ["1.2692","1.3399"] | [] | ["XISX"] | 17.0000 | 18.5000 | 3 | 3 | false | false | false | true | false | ||||||||
| 01a08149-3be0-7672-a906-efd038a44684 | CIFR | 2026-09-08 09:50 | call_backspread | 2 | 1 | 906 | 133182.00 | unknown | — | 17.9000 | 0.2300 | ["17","18"] | ["1.2462","1.3201"] | [] | ["XISX"] | 17.0000 | 18.0000 | 3 | 3 | false | false | false | true | false | ||||||||
| 01a08148-bee0-79a0-a60a-ca8846432b1a | CIFR | 2026-09-08 09:50 | other | 2 | 8 | 942 | 138985.00 | unknown | — | 17.9100 | 0.2086 | ["17","18"] | ["1.3225","1.2817"] | [] | ["AMXO","ARCO","EMLD","XCBO","XMIO","XPHO"] | 17.0000 | 18.0000 | 3 | 3 | false | false | false | true | false | ||||||||
| 01a08142-c788-7013-9f96-05a2af1a1e70 | CIFR | 2026-09-08 09:43 | call_vertical_spread | 2 | 1 | 640 | 322560.00 | short | bid | 17.8400 | 0.4600 | ["15","16.5"] | ["1.0186","1.0327"] | ["16.1"] | ["XCBO"] | 15.0000 | 16.5000 | 10 | 10 | false | false | false | ||||||||||
| 01a06df6-bf7d-7ad0-8487-4df93bf57294 | CIFR | 2026-09-04 15:48 | other | 3 | 1 | 3750 | 1532500.00 | unknown | — | 17.7850 | 0.4300 | ["15","22","28"] | ["0.9668","1.0243","1.0430"] | [] | ["XBOX"] | 15.0000 | 28.0000 | 77 | 77 | false | true | false | true | true | ||||||||
| 01a06df0-379d-71e1-9296-4a002d4efec4 | CIFR | 2026-09-04 15:40 | other | 2 | 4 | 388 | 101256.00 | unknown | — | 17.7250 | 0.3200 | ["20","35"] | ["0.9628","0.9819"] | [] | ["ARCO","C2OX","EDGO","XCBO"] | 20.0000 | 35.0000 | 133 | 133 | false | true | false | true | false | ||||||||
| 01a06d9f-cdad-79d0-a32c-48bf02319811 | CIFR | 2026-09-04 14:13 | call_vertical_spread | 2 | 1 | 556 | 123432.00 | short | bid | 17.6700 | 0.1300 | ["17.5","18.5"] | ["0.8822","0.9017"] | ["17.9"] | ["XISX"] | 17.5000 | 18.5000 | 14 | 14 | false | false | false | ||||||||||
| 01a06d9d-d5c5-7022-ae31-7776afad6022 | CIFR | 2026-09-04 14:10 | call_vertical_spread | 2 | 1 | 1163 | 307032.00 | unknown | — | 17.6701 | 0.1200 | ["17","18"] | ["0.8654","0.8887"] | [] | ["XISX"] | 17.0000 | 18.0000 | 14 | 14 | false | false | false | true | false | ||||||||
| 01a06d99-c2cd-79f3-9407-8e3e278bd7ad | CIFR | 2026-09-04 14:06 | call_vertical_spread | 2 | 1 | 4312 | 616616.00 | short | bid | 17.6400 | 0.1100 | ["17.5","18.5"] | ["0.8469","0.8925"] | ["17.87"] | ["SPHR"] | 17.5000 | 18.5000 | 7 | 7 | false | false | false | ||||||||||
| 01a06d2d-2235-7c12-8ca2-bb4c63712164 | CIFR | 2026-09-04 12:07 | call_vertical_spread | 2 | 2 | 4044 | 246684.00 | unknown | — | 17.6750 | 0.0700 | ["20","24"] | ["0.9105","1.0325"] | [] | ["AMXO"] | 20.0000 | 24.0000 | 14 | 14 | false | true | false | true | false | ||||||||
| 01a06d2c-85f5-7e93-9206-b9153cd0db87 | CIFR | 2026-09-04 12:07 | other | 4 | 1 | 2133 | 494856.00 | unknown | — | 17.7100 | 0.3500 | ["16.5","17.5","18.5","19.5"] | ["1.8726","1.0303","0.8747","0.8806"] | [] | ["XCBO"] | 16.5000 | 19.5000 | 0 | 7 | false | false | true | true | false | ||||||||
| 01a06d27-32ad-72a0-92e1-5b03d9b19057 | CIFR | 2026-09-04 12:01 | strangle | 2 | 2 | 464 | 147088.00 | long | ask | 17.7050 | 0.0200 | ["17","20"] | ["0.9119","0.9281"] | ["13.83","23.17"] | ["ARCO","C2OX"] | 17.0000 | 20.0000 | 42 | 42 | false | true | false | ||||||||||
| 01a06d27-1b3d-7560-9ba6-5bc57d19e925 | CIFR | 2026-09-04 12:01 | strangle | 2 | 11 | 337 | 106829.00 | long | ask | 17.7050 | 0.0595 | ["17","20"] | ["0.9119","0.9281"] | ["13.83","23.17"] | ["AMXO","BATO","EMLD","XBOX","XCBO","XISX","XPHO"] | 17.0000 | 20.0000 | 42 | 42 | false | true |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:04:48Z"} |
| 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:53:21Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| 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 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:45:29Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:18:06Z"} |
| 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-08T14:04:12Z"} |
| 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:58:09Z"} |
| 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:51:17Z"} |
| 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:50:59Z"} |
| 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:50:22Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:43:53Z"} |
| 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-04T19:48:12Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:41:10Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:13:45Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:11:24Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:06:53Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:08:12Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:07:39Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:01:34Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| true |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:01:34Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |