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 |
|---|
| 01a0da27-3cbf-7e90-8cd4-b5c059fc3446 | SOXL | 2026-09-25 15:59 | call_butterfly_spread | 3 | 1 | 20 | 179800.00 | long | ask | 151.2900 | 9.1000 | ["130","150","180"] | ["1.1899","1.1739","1.1591"] | ["171.60"] | ["XISX"] | 130.0000 | 180.0000 | 147 | 147 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T20:00:47Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0cf89-1517-75e3-8fce-079b9270b430 | SOXL | 2026-09-23 14:30 | call_butterfly_spread | 3 | 2 | 30 | 107160.00 | short | bid | 144.9776 | 0.4000 | ["120","143","180"] | ["1.1567","1.1206","1.1186"] | ["122.32","163.68"] | ["EDGO","XCBO"] | 120.0000 | 180.0000 | 23 | 23 | false | false | |||||||||||
| 01a0cf89-112f-7b52-a1c6-99882f003f2d | SOXL | 2026-09-23 14:30 | call_butterfly_spread | 3 | 1 | 96 | 342720.00 | unknown | bid | 144.9776 | 0.4500 | ["120","143","180"] | ["1.1548","1.1199","1.1186"] | ["159.13"] | ["XCBO"] | 120.0000 | 180.0000 | 23 | 23 | false | false | |||||||||||
| 01a0cf7e-4777-7c53-8919-015eb223aac2 | SOXL | 2026-09-23 14:19 | call_butterfly_spread | 3 | 1 | 200 | 733300.00 | long | ask | 145.4500 | 0.4500 | ["120","143","180"] | ["1.1802","1.1358","1.1320"] | ["122.25","163.75"] | ["XISX"] | 120.0000 | 180.0000 | 23 | 23 | false | false | |||||||||||
| 01a0caa3-968e-74d0-9b1b-2924ba327aa3 | SOXL | 2026-09-22 15:41 | call_butterfly_spread | 3 | 1 | 30 | 140580.00 | long | ask | 151.1701 | 7.0500 | ["121","131","141"] | ["1.0506","1.0345","1.0776"] | ["122.76","139.24"] | ["BATO"] | 121.0000 | 141.0000 | 10 | 10 | false | false | |||||||||||
| 01a0ca26-7366-7012-b991-28efcf7f1447 | SOXL | 2026-09-22 13:25 | call_butterfly_spread | 3 | 1 | 94 | 110591.00 | short | bid | 147.8500 | 2.8000 | ["152","160","168"] | ["1.0598","1.0441","1.0367"] | ["152.89","167.11"] | ["XCBO"] | 152.0000 | 168.0000 | 10 | 10 | false | true | |||||||||||
| 01a0ca1f-5ee7-76d2-8861-4743e7630a15 | SOXL | 2026-09-22 13:17 | call_butterfly_spread | 3 | 1 | 94 | 180668.00 | short | bid | 148.3500 | 3.7000 | ["141","151","161"] | ["1.0866","1.0538","1.0392"] | ["142.64","159.36"] | ["XCBO"] | 141.0000 | 161.0000 | 10 | 10 | false | false | |||||||||||
| 01a0ca1d-99c6-7122-8edb-c6e1313b209e | SOXL | 2026-09-22 13:15 | call_butterfly_spread | 3 | 1 | 94 | 400769.00 | short | bid | 148.2500 | 7.6500 | ["121","131","141"] | ["1.0676","1.0823","1.0893"] | ["122.39","139.61"] | ["EDGO"] | 121.0000 | 141.0000 | 10 | 10 | false | false | |||||||||||
| 01a0c4f1-2b17-7b60-b808-11dc92ecf807 | SOXL | 2026-09-21 13:08 | call_butterfly_spread | 3 | 1 | 20 | 122600.00 | unknown | — | 140.0500 | 12.0000 | ["390","400","410"] | ["1.0713","1.0685","1.0747"] | [] | ["XMIO"] | 390.0000 | 410.0000 | 487 | 487 | false | true | false | true | |||||||||
| 01a0c451-baaf-7b21-a5e6-2d40ad2ab3e7 | SOXL | 2026-09-21 10:14 | call_butterfly_spread | 3 | 4 | 442 | 825185.00 | unknown | ask | 134.9700 | 0.5253 | ["128","129","130"] | ["1.0486","1.0597","1.0631"] | ["138.73"] | ["AMXO","ARCO"] | 128.0000 | 130.0000 | 4 | 4 | false | false | |||||||||||
| 01a0c439-dd4e-79c1-b35e-d245bed3acac | SOXL | 2026-09-21 09:48 | call_butterfly_spread | 3 | 1 | 102 | 183447.00 | short | bid | 134.5900 | 0.4500 | ["128","129","130"] | ["1.0428","1.0439","1.0340"] | [] | ["SPHR"] | 128.0000 | 130.0000 | 4 | 4 | false | false | |||||||||||
| 01a0c439-dd4e-79c1-b35e-d2383e468a38 | SOXL | 2026-09-21 09:48 | call_butterfly_spread | 3 | 1 | 212 | 390186.00 | unknown | ask | 134.5900 | 0.4500 | ["128","129","130"] | ["1.0874","1.0850","1.0722"] | ["138.20"] | ["ARCO"] | 128.0000 | 130.0000 | 4 | 4 | false | false | |||||||||||
| 01a0c439-dd4e-79c1-b35e-d212c19f0132 | SOXL | 2026-09-21 09:48 | call_butterfly_spread | 3 | 1 | 80 | 143800.00 | short | bid | 134.5900 | 0.4500 | ["128","129","130"] | ["1.0387","1.0419","1.0378"] | [] | ["XPHO"] | 128.0000 | 130.0000 | 4 | 4 | false | false | |||||||||||
| 01a08136-ad3e-7051-b7fd-2ae1610817cd | SOXL | 2026-09-08 09:30 | call_butterfly_spread | 3 | 2 | 82 | 248106.00 | long | ask | 126.5299 | 6.6000 | ["115","123","125"] | ["1.1459","1.1481","1.1557"] | ["118.50"] | ["XISX","XMIO"] | 115.0000 | 125.0000 | 17 | 17 | false | false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T18:31:11Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T18:31:11Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T18:19:49Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:42:05Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:25:29Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:18:01Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:16:23Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:09:27Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:14:49Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:48:40Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:48:40Z"} |
| 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-21T13:48:40Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:30:39Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |