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 |
| 01a0b523-8667-7491-bcf0-66032ba2025a | QQQ | 2026-09-18 11:29 | put_butterfly_spread | 3 | 3 | 83037 | 13341278.00 | long | ask | 717.2900 | 0.0300 | ["665","690","705"] | ["0.2712","0.2041","0.1733"] | ["682.72","704.56"] | ["AMXO"] | 665.0000 | 705.0000 | 7 | 7 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:30:10Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0aba8-d063-73c3-89fb-c4a2e5150674 | SMH | 2026-09-16 15:19 | put_butterfly_spread | 3 | 4 | 450 | 742600.00 | long | ask | 541.3500 | 1.6000 | ["480","500","520"] | ["0.4000","0.3741","0.3583"] | ["516.37"] | ["AMXO"] | 480.0000 | 520.0000 | 30 | 30 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:19:22Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a628-3dcd-7541-a78c-4ccfa4607047 | IWM | 2026-09-15 13:40 | put_butterfly_spread | 3 | 2 | 1000 | 259000.00 | long | ask | 285.2100 | 0.0800 | ["260","270","280"] | ["0.3068","0.2574","0.2175"] | ["261.06","278.94"] | ["AMXO"] | 260.0000 | 280.0000 | 15 | 15 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:40:58Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a08ca4-3f30-7401-9593-b13619ddc3fd | ORCL | 2026-09-10 14:46 | put_butterfly_spread | 3 | 1 | 300 | 243600.00 | long | ask | 155.1050 | 0.3400 | ["130","140","150"] | ["1.0356","1.0704","1.1217"] | ["131.80","148.20"] | ["SPHR"] | 130.0000 | 150.0000 | 8 | 8 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:46:12Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08137-5da8-7ec2-97f8-a9bf62163171 | SNDK | 2026-09-08 09:31 | put_butterfly_spread | 3 | 1 | 100 | 145500.00 | long | ask | 1782.1700 | 2.1500 | ["1350","1430","1510"] | ["0.9357","0.8641","0.8568"] | ["1355.10","1504.90"] | ["SPHR"] | 1350.0000 | 1510.0000 | 10 | 10 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:31:35Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |