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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b589-06c7-7460-8965-bdda2ceafbbb | GLD | 2026-09-18 13:20 | call_ratio_spread | 2 | 10 | 126 | 150276.00 | unknown | ask | 401.9900 | 0.6000 | ["450","470"] | ["0.2428","0.2498"] | ["452","560.00"] | ["ARCO","C2OX","EDGO","EMLD","SPHR","XBOX","XCBO","XISX","XMIO","XPHO"] | 450.0000 | 470.0000 | 119 | 119 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:21:12Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b57f-4e80-7ff1-a9c7-f30512b3d0b0 | GLD | 2026-09-18 13:10 | call_ratio_spread | 2 | 11 | 132 | 157780.00 | unknown | ask | 402.1900 | 0.6500 | ["450","470"] | ["0.2423","0.2494"] | ["452","560.00"] | ["ARCO","C2OX","EDGO","EMLD","MCRY","SPHR","XBOX","XCBO","XISX","XMIO","XPHO"] | 450.0000 | 470.0000 | 119 | 119 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:10:55Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b57d-98ff-7781-948e-576df2b87e03 | GLD | 2026-09-18 13:08 | call_ratio_spread | 2 | 11 | 150 | 178814.00 | unknown | ask | 402.1500 | 0.6500 | ["450","470"] | ["0.2423","0.2491"] | ["452.02","559.90"] | ["ARCO","C2OX","EDGO","EMLD","MCRY","SPHR","XBOX","XCBO","XISX","XMIO","XPHO"] | 450.0000 | 470.0000 | 119 | 119 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:08:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b57b-e380-71f2-8ab2-0c19d7bda391 | GLD | 2026-09-18 13:06 | call_ratio_spread | 2 | 1 | 540 | 297000.00 | unknown | bid | 402.1100 | 0.2900 | ["480","500"] | ["0.2544","0.2646"] | ["488.25"] | ["EDGO"] | 480.0000 | 500.0000 | 119 | 119 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:06:37Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b57b-d3df-7402-bf60-26747da68931 | GLD | 2026-09-18 13:06 | call_ratio_spread | 2 | 3 | 198 | 109590.00 | unknown | ask | 402.1200 | 0.2900 | ["480","500"] | ["0.2548","0.2650"] | ["488.30"] | ["AMXO","BATO","C2OX"] | 480.0000 | 500.0000 | 119 | 119 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:06:37Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b57b-d3df-7402-bf60-26658248b277 | GLD | 2026-09-18 13:06 | call_ratio_spread | 2 | 3 | 684 | 377340.00 | unknown | — | 402.1200 | 0.2900 | ["480","500"] | ["0.2546","0.2648"] | [] | ["EDGO","XCBO","XISX"] | 480.0000 | 500.0000 | 119 | 119 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:06:37Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b578-0f07-7640-9efd-7f8da61dfb88 | GLD | 2026-09-18 13:02 | call_ratio_spread | 2 | 11 | 132 | 156892.00 | unknown | ask | 401.7950 | 0.5000 | ["450","470"] | ["0.2432","0.2500"] | ["452.00","560.00"] | ["ARCO","C2OX","EDGO","EMLD","MCRY","SPHR","XBOX","XCBO","XISX","XMIO","XPHO"] | 450.0000 | 470.0000 | 119 | 119 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:02:35Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b577-95ef-7d03-bea5-f3e866d88294 | GLD | 2026-09-18 13:01 | call_ratio_spread | 2 | 12 | 150 | 177892.00 | unknown | ask | 401.9600 | 0.5000 | ["450","470"] | ["0.2424","0.2493"] | ["452","560.00"] | ["ARCO","C2OX","EDGO","EMLD","MCRY","SPHR","XBOX","XCBO","XISX","XMIO","XPHO"] | 450.0000 | 470.0000 | 119 | 119 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:01:53Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b571-ae37-7303-9a89-bc52cdaedeca | GLD | 2026-09-18 12:55 | call_ratio_spread | 2 | 11 | 132 | 156390.00 | unknown | ask | 401.7100 | 0.4000 | ["450","470"] | ["0.2432","0.2500"] | ["452","560.00"] | ["ARCO","C2OX","EDGO","EMLD","MCRY","SPHR","XBOX","XCBO","XISX","XMIO","XPHO"] | 450.0000 | 470.0000 | 119 | 119 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:56:01Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b56a-0d17-7541-9f4c-45471ee7d9a9 | GLD | 2026-09-18 12:46 | call_ratio_spread | 2 | 1 | 102 | 120870.00 | unknown | — | 401.3300 | 0.3500 | ["450","470"] | ["0.2444","0.2513"] | [] | ["MCRY"] | 450.0000 | 470.0000 | 119 | 119 | false | true | false | true | false | mlet | 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 |
| 01a0b56a-0d17-7541-9f4c-453a998125a1 | GLD | 2026-09-18 12:46 | call_ratio_spread | 2 | 7 | 96 | 113916.00 | unknown | ask | 401.3300 | 0.3500 | ["450","470"] | ["0.2445","0.2514"] | ["451.98","560.10"] | ["ARCO","EDGO","MCRY","XBOX","XCBO","XMIO","XPHO"] | 450.0000 | 470.0000 | 119 | 119 | false | true | false | true | false | mlet | 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 |
| 01a0b563-db28-7ab0-a0d3-092a04da6daf | GLD | 2026-09-18 12:40 | call_ratio_spread | 2 | 4 | 84 | 100572.00 | unknown | bid | 401.5900 | 0.2500 | ["450","470"] | ["0.2444","0.2515"] | ["464.37"] | ["EDGO","XBOX","XCBO","XISX"] | 450.0000 | 470.0000 | 119 | 119 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:40:19Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0afc8-5b22-7190-8e4e-393e9f03645a | GLD | 2026-09-17 10:32 | call_ratio_spread | 2 | 2 | 30 | 109644.00 | unknown | — | 399.9701 | 0.9750 | ["375","410"] | ["0.2466","0.2464"] | [] | ["MCRY","XISX"] | 375.0000 | 410.0000 | 120 | 120 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:32:34Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0af95-605b-7c01-acc8-120a80856277 | GLD | 2026-09-17 09:36 | call_ratio_spread | 2 | 4 | 72 | 237816.00 | unknown | — | 400.4800 | 0.7000 | ["395","405"] | ["0.2424","0.2431"] | [] | ["AMXO"] | 395.0000 | 405.0000 | 105 | 105 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:36:48Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0af95-605b-7c01-acc8-11f1ae4e18e4 | GLD | 2026-09-17 09:36 | call_ratio_spread | 2 | 6 | 96 | 327168.00 | unknown | — | 400.4800 | 0.7000 | ["395","405"] | ["0.2432","0.2435"] | [] | ["AMXO","XPHO"] | 395.0000 | 405.0000 | 105 | 105 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:36:48Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a58b-bf4d-7ba0-8e9a-0b097988de63 | GLD | 2026-09-15 10:49 | call_ratio_spread | 2 | 1 | 22000 | 12551000.00 | unknown | — | 392.2400 | 0.2800 | ["440","490"] | ["0.2670","0.2931"] | [] | ["AMXO"] | 440.0000 | 490.0000 | 94 | 94 | true | true | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:49:53Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |