Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
312,778 rowsCSV — whole table, not this view
Sources in this table
uw_multileg312,778 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b621-f337-7442-9c75-8848efa0124d | GLD | 2026-09-18 16:07 | put_butterfly_spread | 3 | 1 | 50 | 991000.00 | unknown | ask | 401.4245 | 7.1500 | ["465","470","575"] | ["0.3298","0.3813","0.7765"] | ["401.87","557.51"] | ["XPHO"] | 465.0000 | 575.0000 | 28 | 28 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T20:08:35Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b56a-3427-7d11-8169-eda5d8db0f4e | GLD | 2026-09-18 12:47 | other | 4 | 2 | 1000 | 2183000.00 | unknown | ask | 401.3000 | 1.1000 | ["390","395","410","420"] | ["0.2317","0.2130","0.2185","0.2363"] | [] | ["AMXO"] | 390.0000 | 420.0000 | 28 | 63 | false | true | true | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:47:15Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b552-81c0-7260-b38e-098e1581c4d3 | GLD | 2026-09-18 12:21 | strangle | 2 | 1 | 50 | 129250.00 | long | ask | 400.3700 | 0.5500 | ["400","430"] | ["0.2340","0.2378"] | ["374.15","455.85"] | ["AMXO"] | 400.0000 | 430.0000 | 91 | 91 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:21:23Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b54c-ec0f-7192-8270-1bef0037cd64 | GLD | 2026-09-18 12:15 | strangle | 2 | 1 | 200 | 517000.00 | long | ask | 399.8100 | 0.4000 | ["400","430"] | ["0.2330","0.2380"] | ["374.15","455.85"] | ["AMXO"] | 400.0000 | 430.0000 | 91 | 91 | false | false | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:15:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4df-e9d0-7180-8b56-ef0e8b44ede0 | GLD | 2026-09-18 10:16 | call_diagonal_spread | 2 | 1 | 1000 | 1106000.00 | unknown | ask | 399.0500 | 0.3300 | ["400","425"] | ["0.2348","0.2414"] | [] | ["XPHO"] | 400.0000 | 425.0000 | 0 | 91 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:16:13Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b023-3cc3-71e0-8a5d-969ce4bc83e1 | GLD | 2026-09-17 12:11 | synthetic | 2 | 1 | 1000 | 645000.00 | long | ask | 400.3948 | 0.2900 | ["395"] | ["0.2709"] | ["400.65"] | ["AMXO"] | 395.0000 | 395.0000 | 1 | 1 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:12:03Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aaea-c7f3-7d10-b3b5-0a402f9913f5 | GLD | 2026-09-16 11:51 | put_vertical_spread | 2 | 1 | 500 | 272500.00 | long | ask | 399.0300 | 0.1300 | ["385","400"] | ["0.3832","0.3776"] | ["395.63"] | ["XPHO"] | 385.0000 | 400.0000 | 2 | 2 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:52:17Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aadd-4ad3-7831-9fec-b8eb27d19ace | GLD | 2026-09-16 11:37 | put_frontspread | 2 | 1 | 1600 | 370800.00 | long | ask | 398.9700 | 0.1000 | ["395","397"] | ["0.7131","0.7321"] | ["390.11","396.63"] | ["SPHR"] | 395.0000 | 397.0000 | 0 | 0 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:37:28Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aabd-e3c3-7593-beef-4afb7ec8328c | GLD | 2026-09-16 11:02 | call_vertical_spread | 2 | 1 | 200 | 158400.00 | long | ask | 399.0500 | 0.3600 | ["420","430"] | ["0.2619","0.2694"] | ["421.80"] | ["SPHR"] | 420.0000 | 430.0000 | 30 | 30 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:03:21Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aaaf-8fcb-7493-8e12-6511dfdba665 | GLD | 2026-09-16 10:47 | call_vertical_spread | 2 | 2 | 55358 | 50929360.00 | long | ask | 398.6100 | 0.3500 | ["450","485"] | ["0.2650","0.2804"] | ["453.70"] | ["AMXO"] | 450.0000 | 485.0000 | 93 | 93 | true | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:47:11Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a545-118e-7920-b0cb-9b71f045e0e8 | GLD | 2026-09-15 09:32 | call_vertical_spread | 2 | 1 | 3018 | 3425430.00 | long | ask | 393.0899 | 0.4500 | ["450","485"] | ["0.2645","0.2800"] | ["453.85"] | ["XBOX"] | 450.0000 | 485.0000 | 122 | 122 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:32:49Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a0eb-c670-7433-9934-fb2b65eda49c | GLD | 2026-09-14 13:16 | call_calendar | 2 | 1 | 180 | 272700.00 | short | ask | 395.3300 | 0.4000 | ["410"] | ["0.2492"] | [] | ["SPHR"] | 410.0000 | 410.0000 | 32 | 46 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:17:19Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a08d-1440-7a70-90a7-1526b3660d0d | GLD | 2026-09-14 11:33 | straddle | 2 | 1 | 200 | 473000.00 | long | ask | 393.3100 | 0.5000 | ["400"] | ["0.2488"] | ["376.35","423.65"] | ["XPHO"] | 400.0000 | 400.0000 | 32 | 32 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:33:38Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a08c-7031-79d1-b513-d58a4ebfa34f | GLD | 2026-09-14 11:32 | straddle | 2 | 1 | 1300 | 3074500.00 | long | ask | 393.2000 | 0.7500 | ["400"] | ["0.2487"] | ["376.35","423.65"] | ["XPHO"] | 400.0000 | 400.0000 | 32 | 32 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:32:31Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a090e0-eee0-7c53-a674-4c79ad724905 | GLD | 2026-09-11 10:30 | call_vertical_spread | 2 | 1 | 750 | 841500.00 | long | ask | 400.9300 | 0.4700 | ["430","480"] | ["0.2636","0.2941"] | ["436.50"] | ["XPHO"] | 430.0000 | 480.0000 | 70 | 70 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:30:57Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090bc-4fe0-79f2-aa06-796ff3f84da8 | GLD | 2026-09-11 09:50 | call_vertical_spread | 2 | 1 | 1500 | 703500.00 | long | ask | 402.6650 | 0.2000 | ["410","420"] | ["0.2788","0.2925"] | ["412.03"] | ["XPHO"] | 410.0000 | 420.0000 | 7 | 7 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T13:50:56Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cb5-0428-71d2-9b50-c0cd35de4225 | GLD | 2026-09-10 15:04 | call_diagonal_spread | 2 | 1 | 700 | 497700.00 | long | ask | 395.7000 | 0.4000 | ["415","419"] | ["0.3099","0.2719"] | [] | ["XPHO"] | 415.0000 | 419.0000 | 8 | 36 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:04:52Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0879f-22e8-7d30-b45a-20d5a813d1b8 | GLD | 2026-09-09 15:22 | call_diagonal_spread | 2 | 1 | 700 | 790300.00 | long | ask | 403.6300 | 0.5000 | ["415","419"] | ["0.3017","0.2612"] | [] | ["XPHO"] | 415.0000 | 419.0000 | 9 | 37 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:22:50Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086b4-5970-7ea1-bf26-5bd5df3216ab | GLD | 2026-09-09 11:05 | call_vertical_spread | 2 | 1 | 100 | 277900.00 | long | ask | 401.9700 | 1.4000 | ["405","430"] | ["0.2574","0.2633"] | ["413.95"] | ["SPHR"] | 405.0000 | 430.0000 | 72 | 72 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:06:20Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0825a-a7f8-74b3-bf31-7137c2cbcad6 | GLD | 2026-09-08 14:49 | call_diagonal_spread | 2 | 1 | 700 | 661500.00 | long | ask | 400.3800 | 0.4900 | ["415","419"] | ["0.2893","0.2587"] | [] | ["XPHO"] | 415.0000 | 419.0000 | 10 | 38 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:49:49Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081da-d168-77a2-8a9e-234e045f0b9c | GLD | 2026-09-08 12:29 | call_condor | 4 | 1 | 100 | 455900.00 | long | ask | 402.9200 | 0.9500 | ["397","399","402","405"] | ["0.2487","0.2435","0.2442","0.2510"] | ["397.15","403.85"] | ["SPHR"] | 397.0000 | 405.0000 | 22 | 22 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:30:01Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |