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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 01a090c4-23c9-7802-bc8f-ac3380b8b231 | GLD | 2026-09-11 09:59 | call_calendar | 2 | 1 | 350 | 668500.00 | short | bid | 403.4100 | 0.4800 | ["430"] | ["0.2800"] | [] | ["AMXO"] | 430.0000 | 430.0000 | 7 | 161 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T13:59:31Z"} | 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 |
| 01a08caf-b0e0-7de2-9664-997a8c918e30 | GLD | 2026-09-10 14:58 | other | 8 | 1 | 858 | 10918536.00 | unknown | — | 397.1400 | 10.0500 | ["423","424","425","426","427","428","475","575"] | ["0.7344","0.7780","0.8000","0.8347","0.8853","0.8869","0.7005","0.7961"] | [] | ["XBOX"] | 423.0000 | 575.0000 | 1 | 36 | true | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:58:51Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08caf-a141-7b13-a746-dacb1aefdd0a | GLD | 2026-09-10 14:58 | put_vertical_spread | 2 | 1 | 148 | 941280.00 | unknown | — | 397.1400 | 1.9500 | ["427","430"] | ["0.8853","0.9515"] | [] | ["XBOX"] | 427.0000 | 430.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:58:51Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c22-e5e8-7013-a277-e1a848811b00 | GLD | 2026-09-10 12:24 | other | 2 | 1 | 600 | 620400.00 | unknown | — | 399.7700 | 0.6500 | ["450","570"] | ["0.2550","0.3068"] | [] | ["XPHO"] | 450.0000 | 570.0000 | 190 | 190 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:24:50Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bdd-8430-7221-b35c-6cc3cc83cb98 | GLD | 2026-09-10 11:09 | put_condor | 4 | 5 | 17500 | 11740000.00 | unknown | — | 399.5800 | 0.4500 | ["390","393","395","400"] | ["0.4050","0.4114","0.4088","0.4020"] | [] | ["AMXO"] | 390.0000 | 400.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:09:17Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bab-ba18-7ca0-b113-86f15de02dac | GLD | 2026-09-10 10:14 | other | 2 | 1 | 500 | 709750.00 | unknown | — | 399.7650 | 0.6000 | ["390","410"] | ["0.2510","0.3046"] | [] | ["AMXO"] | 390.0000 | 410.0000 | 8 | 36 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:15:03Z"} | 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 |
| 01a08767-a3e0-7422-8443-ef1bf486bb10 | GLD | 2026-09-09 14:21 | put_vertical_spread | 2 | 1 | 35000 | 8785000.00 | unknown | — | 405.1795 | 0.1200 | ["393","400"] | ["0.3471","0.3387"] | [] | ["AMXO"] | 393.0000 | 400.0000 | 2 | 2 | true | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:22:36Z"} | 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 |
| 01a08275-5800-7db1-960f-4aa2228595ec | GLD | 2026-09-08 15:18 | other | 3 | 1 | 45 | 1206900.00 | unknown | — | 400.6050 | 6.5000 | ["475","575","635"] | ["0.4774","0.6096","1.5484"] | [] | ["XBOX"] | 475.0000 | 635.0000 | 10 | 38 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:19:15Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0825e-41d8-7e03-8073-b1e0b8b1d371 | GLD | 2026-09-08 14:53 | straddle | 2 | 1 | 650 | 4628000.00 | short | bid | 400.3756 | 1.2500 | ["425"] | ["0.2472"] | ["353.80","496.20"] | ["XPHO"] | 425.0000 | 425.0000 | 282 | 282 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:53:38Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 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 |
| 01a06deb-8866-72f2-8020-2690b127aa2b | GLD | 2026-09-04 15:35 | other | 4 | 3 | 1100 | 665800.00 | unknown | — | 406.8650 | 0.4000 | ["410","415","425","430"] | ["0.2311","0.2336","0.2504","0.2685"] | [] | ["AMXO"] | 410.0000 | 430.0000 | 7 | 7 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:36:12Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dd5-e93d-7bd2-b669-5b5de048c4dd | GLD | 2026-09-04 15:12 | other | 2 | 1 | 15 | 599550.00 | unknown | — | 406.1100 | 3.4500 | ["575","635"] | ["0.6896","1.2777"] | [] | ["XBOX"] | 575.0000 | 635.0000 | 14 | 42 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:12:20Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dd3-fd0d-7d72-9f82-b1efb7804e71 | GLD | 2026-09-04 15:10 | other | 3 | 1 | 150 | 3870600.00 | unknown | — | 405.8200 | 7.7500 | ["475","575","635"] | ["0.4416","0.6167","1.2147"] | [] | ["XPHO"] | 475.0000 | 635.0000 | 14 | 42 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:10:24Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |