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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 01a0b049-52c3-73c1-93f6-0d4179da48a1 | GLD | 2026-09-17 12:53 | call_diagonal_spread | 2 | 1 | 50 | 190650.00 | unknown | — | 399.5800 | 0.5000 | ["390","405"] | ["0.2384","0.2301"] | [] | ["XPHO"] | 390.0000 | 405.0000 | 29 | 120 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:53:27Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b040-59e3-7490-a537-7184166cd800 | GLD | 2026-09-17 12:43 | call_diagonal_spread | 2 | 1 | 96 | 271392.00 | unknown | — | 399.4600 | 0.3500 | ["395","405"] | ["0.2410","0.2307"] | [] | ["ARCO"] | 395.0000 | 405.0000 | 29 | 64 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:44:00Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b00c-a39b-7bc3-9e1e-3a7664d7193a | GLD | 2026-09-17 11:46 | call_diagonal_spread | 2 | 2 | 30 | 132450.00 | unknown | — | 400.1200 | 0.6300 | ["380","420"] | ["0.2402","0.2336"] | [] | ["SPHR","XCBO"] | 380.0000 | 420.0000 | 13 | 183 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:47:21Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0af9e-a75b-7451-af71-0efb585dcca1 | GLD | 2026-09-17 09:46 | call_diagonal_spread | 2 | 5 | 370 | 176860.00 | unknown | — | 399.9750 | 0.2200 | ["405","420"] | ["0.2774","0.2405"] | [] | ["AMXO","MCRY","XBOX","XISX","XPHO"] | 405.0000 | 420.0000 | 1 | 29 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:46:52Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aaf9-fe7b-76a1-9f7c-332c7eb9dcdc | GLD | 2026-09-16 12:08 | call_diagonal_spread | 2 | 2 | 330 | 128320.00 | unknown | — | 398.7100 | 0.2300 | ["400","440"] | ["0.4499","0.2814"] | [] | ["EDGO","XBOX"] | 400.0000 | 440.0000 | 1 | 30 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:09:09Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a58f-16c6-7972-81cb-67eef901e8c7 | GLD | 2026-09-15 10:53 | call_diagonal_spread | 2 | 1 | 10 | 136360.00 | unknown | — | 392.1496 | 1.7800 | ["300","430"] | ["0.3022","0.2739"] | [] | ["XISX"] | 300.0000 | 430.0000 | 31 | 822 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:53:50Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a556-76ae-7841-a147-a1004c4d82d9 | GLD | 2026-09-15 09:51 | call_diagonal_spread | 2 | 1 | 1216 | 294880.00 | unknown | — | 393.7891 | 0.0700 | ["400","440"] | ["0.3687","0.2792"] | [] | ["MCRY"] | 400.0000 | 440.0000 | 2 | 31 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:51:40Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a08bca-a428-7a32-b2ae-a8a0ab0ae632 | GLD | 2026-09-10 10:48 | call_diagonal_spread | 2 | 1 | 30 | 109110.00 | unknown | — | 399.2300 | 0.4500 | ["400","405"] | ["0.2474","0.2549"] | [] | ["BATO"] | 400.0000 | 405.0000 | 36 | 127 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:49:09Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08257-c5b1-7543-84a1-dae1de44b475 | GLD | 2026-09-08 14:46 | call_diagonal_spread | 2 | 1 | 53 | 251644.00 | unknown | — | 402.0200 | 0.3800 | ["370","403"] | ["0.2508","0.2651"] | [] | ["XISX"] | 370.0000 | 403.0000 | 1 | 129 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:46:42Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |