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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c4d8-e827-7cb1-985a-a580f4f5fd86 | EWZ | 2026-09-21 12:42 | call_diagonal_spread | 2 | 2 | 3000 | 435000.00 | short | ask | 37.9299 | 0.0500 | ["41","45"] | ["0.4486","0.4426"] | [] | ["AMXO"] | 41.0000 | 45.0000 | 25 | 60 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:42:44Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b065-3f33-7181-99ad-63868e5c8d88 | EWZ | 2026-09-17 13:23 | call_diagonal_spread | 2 | 2 | 4000 | 568000.00 | short | bid | 37.7004 | 0.0400 | ["41","45"] | ["0.4275","0.4359"] | [] | ["AMXO"] | 41.0000 | 45.0000 | 29 | 64 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:24:06Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afde-d123-7f13-ac6f-a9fc0dc2c801 | EWZ | 2026-09-17 10:56 | call_diagonal_spread | 2 | 2 | 10000 | 850000.00 | unknown | — | 37.5450 | 0.1700 | ["40","42"] | ["0.4565","0.4188"] | [] | ["ARCO"] | 40.0000 | 42.0000 | 22 | 29 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:57:01Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a669-369e-7820-b4c7-c7e3107b5cad | EWZ | 2026-09-15 14:51 | call_diagonal_spread | 2 | 2 | 5000 | 795000.00 | short | ask | 37.8450 | 0.0600 | ["41","45"] | ["0.4287","0.4377"] | [] | ["AMXO"] | 41.0000 | 45.0000 | 31 | 66 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:52:23Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a09112-2870-7e93-988d-86844891f87e | EWZ | 2026-09-11 11:24 | call_diagonal_spread | 2 | 3 | 8000 | 1492000.00 | short | ask | 38.3450 | 0.0600 | ["41","45"] | ["0.4001","0.4282"] | [] | ["ARCO"] | 41.0000 | 45.0000 | 35 | 70 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:24:52Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08292-7520-7393-baf9-d66c2abc26f2 | EWZ | 2026-09-08 15:50 | call_diagonal_spread | 2 | 2 | 438 | 114756.00 | long | ask | 38.5900 | 0.0986 | ["38","40"] | ["0.3191","0.4011"] | [] | ["XPHO"] | 38.0000 | 40.0000 | 10 | 38 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:50:59Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08205-1d88-70d1-8d59-c68045f7deda | EWZ | 2026-09-08 13:16 | call_diagonal_spread | 2 | 1 | 150 | 162450.00 | short | bid | 38.5895 | 0.8500 | ["35","40"] | ["0.2643","0.3219"] | [] | ["SPHR"] | 35.0000 | 40.0000 | 192 | 500 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:16:16Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0815b-d1b0-7b62-82bc-3826f157dff8 | EWZ | 2026-09-08 10:11 | call_diagonal_spread | 2 | 1 | 1500 | 433500.00 | long | ask | 39.0500 | 0.0800 | ["42","43"] | ["0.3880","0.3940"] | [] | ["XMIO"] | 42.0000 | 43.0000 | 38 | 101 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:11:24Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |