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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c56c-c79f-7ae3-8dfe-02fea0f5c5ac | AMZN | 2026-09-21 15:23 | call_diagonal_spread | 2 | 1 | 377 | 536471.00 | short | bid | 259.2668 | 0.5500 | ["252.5","255"] | ["1.9692","0.2967"] | [] | ["SPHR"] | 252.5000 | 255.0000 | 0 | 9 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:23:56Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c465-8130-79c1-b471-10561bf0a354 | AMZN | 2026-09-21 10:36 | call_vertical_spread | 2 | 1 | 100 | 77400.00 | short | bid | 255.7450 | 0.3800 | ["300","320"] | ["0.3517","0.3570"] | ["302.40"] | ["SPHR"] | 300.0000 | 320.0000 | 88 | 88 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:36:33Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c43c-69a7-7c72-b9c3-8b6eea28291f | AMZN | 2026-09-21 09:51 | call_diagonal_spread | 2 | 1 | 111 | 91686.00 | short | bid | 253.7500 | 0.6000 | ["250","252.5"] | ["0.5444","0.3310"] | [] | ["SPHR"] | 250.0000 | 252.5000 | 0 | 4 | false | false | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:51:38Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b527-1877-78b1-9e9f-702a694d67b4 | AMZN | 2026-09-18 11:33 | put_calendar | 2 | 1 | 900 | 617400.00 | short | bid | 252.7000 | 0.2500 | ["250"] | ["0.2848"] | [] | ["AMXO"] | 250.0000 | 250.0000 | 7 | 14 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:33:59Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b084-96a3-7752-bb22-e100aea14d42 | AMZN | 2026-09-17 13:57 | risk_reversal | 2 | 2 | 200 | 726000.00 | long | bid | 251.4700 | 0.7500 | ["235","300"] | ["0.3605","0.3552"] | ["233.10"] | ["AMXO"] | 235.0000 | 300.0000 | 273 | 273 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:58:43Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b07e-31eb-7160-b908-2bedd0a3b752 | AMZN | 2026-09-17 13:50 | risk_reversal | 2 | 2 | 600 | 2178000.00 | long | bid | 250.9600 | 0.7500 | ["235","300"] | ["0.3584","0.3576"] | ["233.10"] | ["AMXO"] | 235.0000 | 300.0000 | 273 | 273 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:51:08Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afa3-3b3b-7ec3-a8fc-bc240d883a60 | AMZN | 2026-09-17 09:51 | put_diagonal_spread | 2 | 2 | 100 | 84000.00 | short | bid | 249.5800 | 0.4800 | ["205","210"] | ["0.3764","0.3952"] | [] | ["AMXO"] | 205.0000 | 210.0000 | 64 | 155 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:52:03Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a67c-87ee-7ed0-a92d-807dce4453aa | AMZN | 2026-09-15 15:12 | straddle | 2 | 2 | 100 | 360000.00 | short | bid | 248.1350 | 0.6000 | ["250"] | ["0.3591"] | ["214","286.00"] | ["AMXO"] | 250.0000 | 250.0000 | 94 | 94 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:13:03Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a091e7-c408-7ad3-bfda-e95cd8196b9e | AMZN | 2026-09-11 15:17 | synthetic | 2 | 1 | 100 | 527000.00 | short | bid | 257.4300 | 1.0000 | ["250"] | ["0.3600"] | ["262.88"] | ["XPHO"] | 250.0000 | 250.0000 | 189 | 189 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:18:02Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08799-6629-7cd3-a2ea-c4ecbd6ff2f1 | AMZN | 2026-09-09 15:16 | put_vertical_spread | 2 | 1 | 100 | 124400.00 | short | bid | 252.1100 | 0.3700 | ["247.5","260"] | ["0.3109","0.3039"] | ["253.2"] | ["SPHR"] | 247.5000 | 260.0000 | 9 | 9 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:16:15Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08766-b1b1-7082-8cb9-690f54a5ee56 | AMZN | 2026-09-09 14:20 | straddle | 2 | 2 | 200 | 1963000.00 | short | bid | 252.1100 | 2.4000 | ["250"] | ["0.3813"] | ["151.85","348.15"] | ["AMXO"] | 250.0000 | 250.0000 | 646 | 646 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:20:54Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086d4-54f1-7402-8f58-ef7e20d7947f | AMZN | 2026-09-09 11:40 | call_vertical_spread | 2 | 1 | 124 | 35712.00 | short | bid | 251.3850 | 0.0600 | ["252.5","257.5"] | ["0.3599","0.3623"] | ["253.98"] | ["SPHR"] | 252.5000 | 257.5000 | 2 | 2 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:41:34Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a081de-d0d8-7a01-9abe-293063c7e7f3 | AMZN | 2026-09-08 12:34 | put_vertical_spread | 2 | 1 | 50 | 30700.00 | short | bid | 257.0500 | 0.2300 | ["235","240"] | ["0.3245","0.3164"] | ["239.06"] | ["SPHR"] | 235.0000 | 240.0000 | 38 | 38 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:34:56Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |