core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg600,173 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 |
|---|
| 01a0f28c-fae7-7182-ae41-b1c419db50ac | CIFR | 2026-09-30 09:41 | other | 4 | 2 | 305 | 241560.00 | unknown | bid | 15.8650 | 2.0300 | ["17","18.5"] | ["1.0662","1.5303"] | [] | ["BATO"] | 17.0000 | 18.5000 | 2 | 9 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-30T13:42:03Z"} | 2026-09-30 | 2026-09-30 17:15 | 2026-09-30 17:15 |
| 01a0d9ca-865f-7f33-9c00-029ed79fc560 | CIFR | 2026-09-25 14:18 | other | 4 | 1 | 2542 | 674901.00 | unknown | — | 17.6295 | 0.2400 | ["20","21","25","26"] | ["0.9817","0.9538","0.9933","1.0574"] | [] | ["SPHR"] | 20.0000 | 26.0000 | 21 | 84 | false | true | true | true | |||||||||
| 01a0d9c6-e896-7a03-87ce-a096be0cf415 | CIFR | 2026-09-25 14:14 | other | 4 | 1 | 2340 | 318240.00 | unknown | — | 17.6930 | 0.1300 | ["18","19"] | ["1.5012","2.2228"] | [] | ["XPHO"] | 18.0000 | 19.0000 | 0 | 7 | false | true | true | true | false | ||||||||
| 01a0d9c1-7226-7ac1-8002-7212e1be2454 | CIFR | 2026-09-25 14:08 | other | 4 | 3 | 472 | 124560.00 | unknown | — | 17.6362 | 0.1900 | ["20","21","25","26"] | ["0.9878","0.9627","0.9813","1.0153"] | [] | ["ARCO","EDGO","XISX"] | 20.0000 | 26.0000 | 21 | 84 | false | true | true | true | |||||||||
| 01a0d9c1-2407-7633-b901-77162d35d52b | CIFR | 2026-09-25 14:08 | other | 4 | 7 | 650 | 172025.00 | unknown | ask | 17.6400 | 0.1900 | ["20","21","25","26"] | ["0.9865","0.9632","0.9822","1.0229"] | [] | ["ARCO","EMLD","MCRY","XBOX","XCBO","XISX","XPHO"] | 20.0000 | 26.0000 | 21 | 84 | false | true | |||||||||||
| 01a0d9bd-a57e-7e33-9da1-e48be3f993a4 | CIFR | 2026-09-25 14:04 | other | 4 | 1 | 500 | 134000.00 | unknown | — | 17.6450 | 0.2900 | ["20","21","25","26"] | ["0.9972","0.9653","0.9883","1.0229"] | [] | ["XMIO"] | 20.0000 | 26.0000 | 21 | 84 | false | true | true | true | |||||||||
| 01a0d8d8-df16-7c72-a551-087bb6312e9a | CIFR | 2026-09-25 09:54 | other | 4 | 1 | 1742 | 135876.00 | unknown | — | 18.0400 | 0.2100 | ["19","19.5","20","20.5"] | ["1.8798","0.9782","2.0145","0.9877"] | [] | ["XPHO"] | 19.0000 | 20.5000 | 0 | 7 | false | true | true | true | |||||||||
| 01a0d3a9-111f-7d40-b808-6ecbf16f1736 | CIFR | 2026-09-24 09:44 | other | 4 | 2 | 375 | 101720.00 | unknown | bid | 18.1215 | 1.6600 | ["15.5","17","17.5"] | ["1.0188","1.0083","1.1120"] | [] | ["C2OX","XISX"] | 15.5000 | 17.5000 | 1 | 36 | false | true | |||||||||||
| 01a0c44c-ffbf-7093-9202-fa107d38c661 | CIFR | 2026-09-21 10:09 | other | 4 | 1 | 11036 | 2759000.00 | unknown | — | 18.7200 | 0.2600 | ["14.5","15.5","18","19"] | ["1.2443","1.1923","1.0222","1.0182"] | [] | ["XCBO"] | 14.5000 | 19.0000 | 4 | 11 | false | false | true | true | |||||||||
| 01a0b584-019f-78f1-9d5a-c0488b445cc8 | CIFR | 2026-09-18 13:15 | other | 4 | 1 | 1724 | 298252.00 | unknown | ask | 17.7450 | 0.4300 | ["17","17.5","19","20"] | ["2.3238","1.1712","0.9194","0.9688"] | [] | ["XCBO"] | 17.0000 | 20.0000 | 0 | 7 | false | false | |||||||||||
| 01a0b4e6-cb87-70e2-af15-64a55a1743ab | CIFR | 2026-09-18 10:23 | other | 4 | 1 | 2053 | 420865.00 | unknown | — | 17.2850 | 0.3300 | ["16.5","17.5","18","19"] | ["2.0157","1.6805","0.9649","0.9724"] | [] | ["XCBO"] | 16.5000 | 19.0000 | 0 | 7 | false | false | true | true | |||||||||
| 01a0a153-e2c9-7992-aaf9-75e9f2758dc8 | CIFR | 2026-09-14 15:10 | other | 3 | 1 | 50 | 115000.00 | unknown | — | 15.8100 | 1.8500 | ["10","15","35"] | ["0.9427","0.9100","0.9029"] | [] | ["XBOX"] | 10.0000 | 35.0000 | 459 | 858 | false | false | true | true | |||||||||
| 01a09185-8b80-7e43-b1dc-88f13834a132 | CIFR | 2026-09-11 13:30 | other | 2 | 1 | 333 | 772227.00 | unknown | — | 17.3750 | 2.6000 | ["5","8"] | ["1.6904","0.9540"] | [] | ["BATO"] | 5.0000 | 8.0000 | 126 | 497 | false | false | true | true | false | ||||||||
| 01a090d2-e908-76d0-a574-8aa7ae372a34 | CIFR | 2026-09-11 10:15 | other | 2 | 1 | 1952 | 175680.00 | unknown | — | 17.1350 | 0.1300 | ["17","19"] | ["1.0026","1.0747"] | [] | ["XISX"] | 17.0000 | 19.0000 | 7 | 7 | false | false | false | true | false | ||||||||
| 01a08cb2-54a8-75a0-b0fe-ed123450f4db | CIFR | 2026-09-10 15:01 | other | 6 | 1 | 452 | 573608.00 | unknown | — | 15.9200 | 3.1500 | ["20","20.5","21","21.5","22","22.5"] | ["3.0814","4.0753","4.3341","4.5821","4.8000","5.0498"] | [] | ["XBOX"] | 20.0000 | 22.5000 | 1 | 1 | false | false | false | true | |||||||||
| 01a08c93-fb20-7cf3-9be7-d2ab45134bb5 | CIFR | 2026-09-10 14:28 | other | 4 | 1 | 100 | 141800.00 | unknown | — | 16.0200 | 1.7300 | ["10","12","26","30"] | ["1.1233","0.7163","1.0008","1.0570"] | [] | ["SPHR"] | 10.0000 | 30.0000 | 99 | 127 | false | false | true | true | |||||||||
| 01a08ba3-55a9-72a0-a87b-3d9c4606e9a0 | CIFR | 2026-09-10 10:05 | other | 4 | 1 | 2090 | 202730.00 | unknown | — | 15.5301 | 0.1200 | ["16.5","17.5","18.5","19.5"] | ["1.0433","1.0801","1.8040","2.2354"] | [] | ["XPHO"] | 16.5000 | 19.5000 | 1 | 8 | false | true | true | true | |||||||||
| 01a08277-5ba0-7f60-9263-14703e52f71f | CIFR | 2026-09-08 15:20 | other | 2 | 1 | 420 | 208320.00 | unknown | — | 18.9500 | 0.2200 | ["18","22"] | ["1.0049","1.0560"] | [] | ["EDGO"] | 18.0000 | 22.0000 | 24 | 73 | false | false | true | true | false | ||||||||
| 01a08260-4960-70b0-8a1e-da8bc6f26817 | CIFR | 2026-09-08 14:55 | other | 2 | 1 | 1994 | 327016.00 | unknown | — | 19.1750 | 0.4900 | ["25","34"] | ["1.0598","1.0719"] | [] | ["ARCO"] | 25.0000 | 34.0000 | 73 | 73 | false | true | false | true | false | ||||||||
| 01a08227-a948-7f82-88ef-20c618f08781 | CIFR | 2026-09-08 13:53 | other | 2 | 2 | 2000 | 223200.00 | unknown | — | 19.4199 | 0.1516 | ["20.5","23"] | ["1.0374","1.0901"] | [] | ["XCBO"] | 20.5000 | 23.0000 | 10 | 10 | false | true | 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 | ||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T18:19:05Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T18:15:02Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T18:09:07Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T18:08:28Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T18:04:45Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T13:54:55Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T13:44:49Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:09:56Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:15:31Z"} |
| 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:23:44Z"} |
| 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-14T19:11:02Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T17:31:08Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:15:57Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:01:41Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:28:24Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:05:32Z"} |
| 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-08T19:21:17Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:55:53Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:54:02Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlft |
| 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 |
| mlet |
| 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 |
| mlft |
| 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 |
| mlet |
| 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 |
| mlat |
| 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 |