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 |
|---|
| 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 |
|---|
| 01a0c9ce-2206-7041-9a25-a9f08de262d9 | ETHA | 2026-09-22 11:48 | call_vertical_spread | 2 | 1 | 500 | 126000.00 | short | bid | 20.7501 | 0.0500 | ["20","21"] | ["0.5101","0.5185"] | ["20.50"] | ["EDGO"] | 20.0000 | 21.0000 | 24 | 24 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T15:48:56Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c4d4-1d97-7fe0-a848-722e9b9941e4 | ETHA | 2026-09-21 12:37 | straddle | 2 | 2 | 200 | 314600.00 | short | bid | 20.8176 | 0.5000 | ["23"] | ["0.6493"] | ["7.27","38.73"] | ["AMXO","XISX"] | 23.0000 | 23.0000 | 851 | 851 | true | false | false | false | true | ||||||||
| 01a0c44c-4056-73b1-8cb5-df52294e0764 | ETHA | 2026-09-21 10:08 | call_vertical_spread | 2 | 2 | 500 | 103000.00 | short | bid | 20.4650 | 0.0700 | ["20","22"] | ["0.5368","0.5662"] | ["20.76"] | ["XISX"] | 20.0000 | 22.0000 | 25 | 25 | false | false | false | true | |||||||||
| 01a0b5ec-e148-71a3-95cd-1dd5b9c0d0fe | ETHA | 2026-09-18 15:09 | call_vertical_spread | 2 | 1 | 805 | 191590.00 | short | bid | 19.8000 | 0.0800 | ["24","35"] | ["0.5586","0.6088"] | ["25.32"] | ["MCRY"] | 24.0000 | 35.0000 | 182 | 182 | false | true | false | true | |||||||||
| 01a0b5d4-a23f-7811-baa9-130d006b8a8d | ETHA | 2026-09-18 14:43 | call_vertical_spread | 2 | 4 | 2318 | 257298.00 | short | bid | 19.7250 | 0.1109 | ["40","50"] | ["0.6138","0.6596"] | ["40.27"] | ["ARCO","EMLD","SPHR","XPHO"] | 40.0000 | 50.0000 | 272 | 272 | false | true | false | true | |||||||||
| 01a0b5ba-86a7-74b2-b987-5fb0a9834df3 | ETHA | 2026-09-18 14:14 | call_vertical_spread | 2 | 1 | 160 | 180320.00 | short | bid | 19.6639 | 0.4500 | ["14","17"] | ["0.5816","0.5604"] | ["16.05"] | ["XMIO"] | 14.0000 | 17.0000 | 182 | 182 | false | false | false | true | |||||||||
| 01a0b577-1120-7e43-a94c-9bdd64818edd | ETHA | 2026-09-18 13:01 | straddle | 2 | 1 | 25000 | 10625000.00 | short | bid | 19.5800 | 0.1900 | ["20"] | ["0.5427"] | ["15.75","24.25"] | ["AMXO"] | 20.0000 | 20.0000 | 91 | 91 | true | false | false | false | true | ||||||||
| 01a0b4ce-9067-75d0-90fa-f219bc4d6133 | ETHA | 2026-09-18 09:57 | straddle | 2 | 1 | 1000 | 465000.00 | short | bid | 19.2650 | 0.1200 | ["19"] | ["0.5371"] | ["14.35","23.65"] | ["XCBO"] | 19.0000 | 19.0000 | 119 | 119 | false | false | false | false | true | ||||||||
| 01a0b4ce-2307-7570-8369-c42ac519f856 | ETHA | 2026-09-18 09:56 | synthetic | 2 | 2 | 1000 | 1053026.00 | short | bid | 19.2800 | 0.6500 | ["20"] | ["0.6106"] | ["20.41"] | ["XMIO"] | 20.0000 | 20.0000 | 490 | 490 | false | false | false | false | true | ||||||||
| 01a091fa-1b58-7f43-8e15-331028650434 | ETHA | 2026-09-11 15:37 | put_diagonal_spread | 2 | 6 | 282 | 118534.00 | short | bid | 19.2101 | 0.1800 | ["20","22"] | ["0.5504","0.5485"] | [] | ["ARCO","BATO","C2OX","EDGO","XCBO","XISX"] | 20.0000 | 22.0000 | 7 | 35 | false | false | true | true | |||||||||
| 01a091fa-1b58-7f43-8e15-330f20608102 | ETHA | 2026-09-11 15:37 | put_diagonal_spread | 2 | 6 | 291 | 122144.00 | short | bid | 19.2100 | 0.1800 | ["20","22"] | ["0.5471","0.5468"] | [] | ["AMXO","EMLD","MCRY","XBOX","XMIO","XPHO"] | 20.0000 | 22.0000 | 7 | 35 | false | false | true | true | |||||||||
| 01a091fa-1b58-7f43-8e15-32eee2cff972 | ETHA | 2026-09-11 15:37 | put_diagonal_spread | 2 | 7 | 286 | 120006.00 | short | bid | 19.2100 | 0.1800 | ["20","22"] | ["0.5517","0.5438"] | [] | ["AMXO","ARCO","EMLD","MCRY","XBOX","XMIO","XPHO"] | 20.0000 | 22.0000 | 7 | 35 | false | false | true | true | |||||||||
| 01a091b6-9631-7203-a1cf-586d5e210d25 | ETHA | 2026-09-11 14:24 | call_vertical_spread | 2 | 1 | 200 | 185200.00 | short | bid | 19.2050 | 0.5000 | ["25","30"] | ["0.6352","0.6398"] | ["26"] | ["ARCO"] | 25.0000 | 30.0000 | 644 | 644 | false | true | false | true | |||||||||
| 01a090f9-e580-7321-8d88-031aae900b37 | ETHA | 2026-09-11 10:58 | call_diagonal_spread | 2 | 2 | 1000 | 301000.00 | short | ask | 19.6950 | 0.1700 | ["18","20"] | ["0.5293","0.5487"] | [] | ["XCBO"] | 18.0000 | 20.0000 | 7 | 35 | false | false | true | true | |||||||||
| 01a090f9-1678-7542-af7a-c49698a441e5 | ETHA | 2026-09-11 10:57 | call_diagonal_spread | 2 | 1 | 600 | 112800.00 | short | ask | 19.6750 | 0.1400 | ["18.5","19.5"] | ["1.2671","0.5552"] | [] | ["XCBO"] | 18.5000 | 19.5000 | 0 | 7 | false | false | true | true | |||||||||
| 01a090cd-2860-7471-a378-a13940774bb8 | ETHA | 2026-09-11 10:09 | call_vertical_spread | 2 | 4 | 362 | 110618.00 | short | bid | 19.7200 | 0.0886 | ["18","22"] | ["0.5637","0.5901"] | ["19.73"] | ["AMXO","XCBO","XMIO","XPHO"] | 18.0000 | 22.0000 | 35 | 35 | false | false | false | true | |||||||||
| 01a06ddc-9ffd-7380-872c-96ae267f5b60 | ETHA | 2026-09-04 15:19 | call_vertical_spread | 2 | 1 | 250 | 103750.00 | short | bid | 18.5350 | 0.1200 | ["15","22"] | ["0.5488","0.5387"] | ["18.43"] | ["XISX"] | 15.0000 | 22.0000 | 42 | 42 | false | false | false | true | |||||||||
| 01a06d70-1ea5-76a2-ab3a-6b5407fc8a96 | ETHA | 2026-09-04 13:20 | call_calendar | 2 | 1 | 3311 | 1367443.00 | short | bid | 18.5001 | 0.0500 | ["16.5"] | ["0.7228"] | [] | ["C2OX"] | 16.5000 | 16.5000 | 0 | 14 | false | false | true | false | false | ||||||||
| 01a06d6f-5b55-7912-8185-f97c003ae1b1 | ETHA | 2026-09-04 13:20 | call_calendar | 2 | 1 | 400 | 165200.00 | short | bid | 18.5000 | 0.0600 | ["16.5"] | ["0.8198"] | [] | ["C2OX"] | 16.5000 | 16.5000 | 0 | 14 | false | false | true | false | false |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:37:24Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:08:55Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:10:00Z"} |
| 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-18T18:43:51Z"} |
| 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-18T18:15:13Z"} |
| 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-18T17:01:53Z"} |
| 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-18T13:57:16Z"} |
| 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-18T13:56:43Z"} |
| 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-11T19:38:09Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:38:09Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:38:09Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:24:58Z"} |
| 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:58:15Z"} |
| 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:57:18Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:09:34Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:19:37Z"} |
| 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-04T17:21:32Z"} |
| 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-04T17:20:09Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |