core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
Simplify Analyticsuw_multileg403,968 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 |
|---|
| 01a0c531-359f-7603-a794-612386af7c16 | AVGO | 2026-09-21 14:18 | call_butterfly_spread | 3 | 1 | 100 | 224450.00 | unknown | ask | 361.0500 | 0.5500 | ["370","400","430"] | ["0.3876","0.3912","0.4027"] | ["401.60"] | ["XMIO"] | 370.0000 | 430.0000 | 60 | 60 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:19:12Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4fb-8b57-71e3-b3ce-c8a802153691 | AVGO | 2026-09-21 13:20 | call_butterfly_spread | 3 | 1 | 16 | 36696.00 | long | ask | 359.4800 | 0.8000 | ["365","370","375"] | ["0.3620","0.3621","0.3630"] | ["365.27","374.73"] | ["XCBO"] | 365.0000 | 375.0000 | 32 | 32 | false | true | false | ||||||||||
| 01a0c43f-f3e7-7020-8fc3-ee382686579a | AVGO | 2026-09-21 09:55 | call_butterfly_spread | 3 | 1 | 16 | 27640.00 | short | bid | 356.1795 | 0.6500 | ["380","400","420"] | ["0.3772","0.3803","0.3865"] | ["381.95","418.05"] | ["XCBO"] | 380.0000 | 420.0000 | 60 | 60 | false | true | false | ||||||||||
| 01a0b4e6-8d07-7012-90de-d48a2d9c1d1b | AVGO | 2026-09-18 10:23 | call_butterfly_spread | 3 | 1 | 16 | 34424.00 | short | bid | 359.7800 | 1.3000 | ["370","450","490"] | ["0.4071","0.4183","0.4306"] | ["386.35"] | ["MCRY"] | 370.0000 | 490.0000 | 91 | 91 | false | true | false | ||||||||||
| 01a0aff9-94b3-7302-98f1-aeea9d097966 | AVGO | 2026-09-17 11:26 | call_butterfly_spread | 3 | 1 | 10 | 36715.00 | long | ask | 350.3300 | 0.9000 | ["350","360","370"] | ["0.3644","0.3644","0.3652"] | ["350.75","369.25"] | ["XCBO"] | 350.0000 | 370.0000 | 64 | 64 | false | false | false | ||||||||||
| 01a0afd3-d4a3-7d43-9ee1-1e2d79ccd17a | AVGO | 2026-09-17 10:44 | call_butterfly_spread | 3 | 1 | 10 | 35850.00 | short | bid | 349.1100 | 1.3500 | ["350","360","370"] | ["0.3680","0.3668","0.3670"] | ["350.78","369.22"] | ["XMIO"] | 350.0000 | 370.0000 | 64 | 64 | false | true | false | ||||||||||
| 01a0afc2-2d1b-78c0-ba78-ad67bcf527e7 | AVGO | 2026-09-17 10:25 | call_butterfly_spread | 3 | 1 | 20 | 25910.00 | unknown | — | 349.5855 | 0.7200 | ["400","450","500"] | ["0.4128","0.4233","0.4403"] | [] | ["XMIO"] | 400.0000 | 500.0000 | 92 | 92 | false | true | false | true | false | ||||||||
| 01a0a022-6b90-7801-906b-f7acdd66fc4f | AVGO | 2026-09-14 09:36 | call_butterfly_spread | 3 | 1 | 20 | 44120.00 | long | ask | 346.7950 | 1.9000 | ["360","440","480"] | ["0.4276","0.4436","0.4586"] | ["375.44"] | ["XMIO"] | 360.0000 | 480.0000 | 95 | 95 | false | true | false | ||||||||||
| 01a090ce-16a8-7aa1-b954-02691d1e0c3e | AVGO | 2026-09-11 10:10 | call_butterfly_spread | 3 | 1 | 20 | 99240.00 | short | bid | 362.5000 | 2.5000 | ["410","430","450"] | ["0.4357","0.4350","0.4348"] | ["411","449"] | ["XMIO"] | 410.0000 | 450.0000 | 189 | 189 | false | true | false | ||||||||||
| 01a081ec-78f0-7c41-a8b9-32bb6600e024 | AVGO | 2026-09-08 12:49 | call_butterfly_spread | 3 | 1 | 20 | 73470.00 | short | bid | 366.3700 | 2.8000 | ["345","355","357.5"] | ["0.4396","0.4180","0.4078"] | ["350.87"] | ["XMIO"] | 345.0000 | 357.5000 | 10 | 10 | false | false | false |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:20:17Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:55:30Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:23:23Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:26:24Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:45:13Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:25:51Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T13:36:45Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:10:31Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:49:47Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |