Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
367,592 rowsCSV — whole table, not this view
Sources in this table
uw_multileg367,592 rowsexportable
| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c586-5e67-7c13-bfcb-72115c9bbfe7 | SPY | 2026-09-21 15:51 | call_vertical_spread | 2 | 1 | 100 | 40900.00 | unknown | bid | 773.8200 | 0.0500 | ["798","809"] | ["0.1094","0.1088"] | ["802.09"] | ["XCBO"] | 798.0000 | 809.0000 | 32 | 32 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:52:06Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c580-8267-7a01-905a-c6f938f42615 | SPY | 2026-09-21 15:45 | call_vertical_spread | 2 | 1 | 200 | 74200.00 | short | bid | 774.4350 | 0.0300 | ["799","814"] | ["0.1095","0.1104"] | ["800.87"] | ["XCBO"] | 799.0000 | 814.0000 | 32 | 32 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:45:28Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c57d-07c7-70d3-8883-8c002c716954 | SPY | 2026-09-21 15:41 | call_vertical_spread | 2 | 1 | 200 | 66000.00 | long | ask | 774.4601 | 0.0300 | ["795","810"] | ["0.1089","0.1099"] | ["796.86"] | ["XCBO"] | 795.0000 | 810.0000 | 25 | 25 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:41:56Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c48d-a687-79a3-b080-a71bea2fcba2 | SPY | 2026-09-21 11:20 | put_ratio_spread | 2 | 2 | 750 | 1471200.00 | long | bid | 770.1100 | 0.0900 | ["715","725"] | ["0.1913","0.1851"] | ["713.11"] | ["XCBO"] | 715.0000 | 725.0000 | 179 | 179 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:20:20Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0afb2-3efb-70e0-a166-d0d2da01ec7f | SPY | 2026-09-17 10:08 | other | 5 | 1 | 900 | 217300.00 | unknown | — | 760.1650 | 0.1100 | ["640","670","690","740","750"] | ["0.3138","0.3091","0.2665","0.1622","0.1502"] | [] | ["XCBO"] | 640.0000 | 750.0000 | 13 | 29 | false | true | true | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:08:13Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afb2-3efb-70e0-a166-d0cbf067faf3 | SPY | 2026-09-17 10:08 | other | 4 | 1 | 450 | 194900.00 | unknown | — | 760.1650 | 0.0500 | ["640","690","710","740"] | ["0.3770","0.2322","0.2224","0.1664"] | [] | ["XCBO"] | 640.0000 | 740.0000 | 13 | 29 | false | true | true | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:08:13Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a17c-c3a1-7130-96f3-cc7d03d2a67d | SPY | 2026-09-14 15:55 | other | 4 | 1 | 80 | 28683.00 | unknown | — | 761.0200 | 0.2800 | ["325","540","700","720"] | ["0.4378","0.2793","0.2033","0.2101"] | [] | ["XCBO"] | 325.0000 | 720.0000 | 186 | 494 | false | true | true | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:55:05Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a16e-9e88-7b12-9c67-01cafeb3da47 | SPY | 2026-09-14 15:39 | put_ratio_spread | 2 | 1 | 130 | 66950.00 | long | bid | 761.6400 | 0.0568 | ["710","746"] | ["0.2267","0.1652"] | ["742.11"] | ["XCBO"] | 710.0000 | 746.0000 | 18 | 18 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:39:58Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a168-ca58-7590-903b-ccaacd60fcb1 | SPY | 2026-09-14 15:33 | put_ratio_spread | 2 | 1 | 130 | 66690.00 | long | bid | 761.7750 | 0.0500 | ["710","746"] | ["0.2271","0.1654"] | ["742.13"] | ["XCBO"] | 710.0000 | 746.0000 | 18 | 18 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:33:27Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a163-82c8-77f0-affa-833f965c30ca | SPY | 2026-09-14 15:27 | put_ratio_spread | 2 | 2 | 130 | 67015.00 | long | bid | 761.7700 | 0.0484 | ["710","746"] | ["0.2275","0.1658"] | ["742.12"] | ["XCBO"] | 710.0000 | 746.0000 | 18 | 18 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:27:37Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a15d-9340-7b53-8377-83b28aa4da9b | SPY | 2026-09-14 15:20 | other | 2 | 2 | 130 | 66495.00 | unknown | — | 761.8150 | 0.0400 | ["710","746"] | ["0.2268","0.1655"] | [] | ["XCBO"] | 710.0000 | 746.0000 | 18 | 18 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:21:04Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091fb-6b48-7551-b38f-18b516339b75 | SPY | 2026-09-11 15:39 | other | 2 | 1 | 525 | 163602.00 | unknown | — | 764.9300 | 0.0300 | ["710","746"] | ["0.2148","0.1580"] | [] | ["XCBO"] | 710.0000 | 746.0000 | 21 | 21 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:39:50Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091f5-e920-7bf3-9868-111c467f2d2a | SPY | 2026-09-11 15:33 | put_frontspread | 2 | 2 | 525 | 163602.00 | long | ask | 764.9900 | 0.0400 | ["710","746"] | ["0.2149","0.1583"] | ["675.81","744.32"] | ["XCBO"] | 710.0000 | 746.0000 | 21 | 21 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:33:27Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091f0-4ba0-7a31-bbd7-db36609d8038 | SPY | 2026-09-11 15:27 | put_frontspread | 2 | 1 | 525 | 161767.00 | long | ask | 765.1764 | 0.0400 | ["710","746"] | ["0.2150","0.1581"] | ["675.78","744.35"] | ["XCBO"] | 710.0000 | 746.0000 | 21 | 21 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:27:33Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091ea-38f0-76e3-bb49-10a0abf66cb3 | SPY | 2026-09-11 15:20 | put_frontspread | 2 | 2 | 525 | 163601.00 | long | ask | 764.9500 | 0.0300 | ["710","746"] | ["0.2144","0.1585"] | ["675.85","744.28"] | ["XCBO"] | 710.0000 | 746.0000 | 21 | 21 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:20:43Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08ce7-9578-70e0-8825-293c3d4be973 | SPY | 2026-09-10 15:59 | other | 3 | 2 | 1450 | 1388142.00 | unknown | — | 757.7100 | 0.1000 | ["710","746","750"] | ["0.2246","0.1728","0.1705"] | [] | ["XCBO"] | 710.0000 | 750.0000 | 15 | 22 | false | true | true | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:59:56Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ce4-45d0-7a90-8a5e-7f99e1039b56 | SPY | 2026-09-10 15:56 | other | 3 | 2 | 1450 | 1479254.00 | unknown | — | 757.8900 | 0.1300 | ["710","746","750"] | ["0.2249","0.1728","0.1698"] | [] | ["XCBO"] | 710.0000 | 750.0000 | 15 | 22 | false | true | true | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:56:04Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ce0-4660-72d1-aa1e-cb8006f66e28 | SPY | 2026-09-10 15:51 | other | 3 | 2 | 1450 | 1381640.00 | unknown | — | 757.7900 | 0.1125 | ["710","746","750"] | ["0.2249","0.1719","0.1689"] | [] | ["XCBO"] | 710.0000 | 750.0000 | 15 | 22 | false | true | true | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:52:00Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08222-dad0-77e1-8436-5b8bb028fc11 | SPY | 2026-09-08 13:48 | put_frontspread | 2 | 1 | 165 | 139953.00 | long | ask | 767.5400 | 0.0800 | ["710","760"] | ["0.1955","0.1525"] | ["694.23"] | ["XCBO"] | 710.0000 | 760.0000 | 73 | 73 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:48:39Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |