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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c57f-171f-7c91-92c8-f88e349fa331 | AMZN | 2026-09-21 15:43 | put_diagonal_spread | 2 | 1 | 18 | 54144.00 | unknown | bid | 258.7100 | 0.5000 | ["260","270"] | ["0.3756","0.3011"] | [] | ["XCBO"] | 260.0000 | 270.0000 | 25 | 60 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:44:08Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c463-8947-70d0-8af7-8c7abfd73d11 | AMZN | 2026-09-21 10:34 | put_diagonal_spread | 2 | 1 | 2 | 31724.00 | long | ask | 255.9750 | 4.3000 | ["330","335"] | ["0.3915","0.3941"] | [] | ["XCBO"] | 330.0000 | 335.0000 | 179 | 298 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:34:11Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b590-d2e0-7ac1-aca6-4359864c8898 | AMZN | 2026-09-18 13:29 | put_diagonal_spread | 2 | 1 | 30 | 187800.00 | short | bid | 253.0972 | 1.5500 | ["250","255"] | ["0.3657","0.3597"] | [] | ["XCBO"] | 250.0000 | 255.0000 | 364 | 455 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:29:57Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0abb7-4783-7471-9345-67fe77a9c6d0 | AMZN | 2026-09-16 15:35 | put_diagonal_spread | 2 | 1 | 75 | 334875.00 | long | ask | 245.3450 | 1.3000 | ["265","270"] | ["6.2930","0.7411"] | [] | ["XMIO"] | 265.0000 | 270.0000 | 0 | 2 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:35:14Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aab6-080b-7ea2-84b0-f1ceddb14ac3 | AMZN | 2026-09-16 10:54 | put_diagonal_spread | 2 | 1 | 60 | 82440.00 | unknown | — | 246.8900 | 0.5500 | ["235","245"] | ["0.3880","0.3050"] | [] | ["XMIO"] | 235.0000 | 245.0000 | 23 | 44 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:54:36Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa72-484b-79e3-b0b6-9e41f236bb5e | AMZN | 2026-09-16 09:40 | put_diagonal_spread | 2 | 1 | 50 | 104550.00 | long | ask | 247.1850 | 1.0500 | ["255","257.5"] | ["0.3077","0.9398"] | [] | ["AMXO"] | 255.0000 | 257.5000 | 0 | 14 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:40:20Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a5b0-23b6-7272-8db1-504e4df5c1e6 | AMZN | 2026-09-15 11:29 | put_diagonal_spread | 2 | 1 | 14 | 26866.00 | unknown | — | 248.9400 | 0.4000 | ["255","260"] | ["0.3051","0.4777"] | [] | ["XCBO"] | 255.0000 | 260.0000 | 1 | 8 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:30:06Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5ab-a35e-74f1-89a4-8793c3dc9987 | AMZN | 2026-09-15 11:24 | put_diagonal_spread | 2 | 1 | 1590 | 1871430.00 | unknown | — | 248.8200 | 0.2500 | ["220","250"] | ["0.3906","0.3074"] | [] | ["XCBO"] | 220.0000 | 250.0000 | 17 | 66 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:24:49Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a586-19fe-7092-bfe7-0f6a7a7ecff4 | AMZN | 2026-09-15 10:43 | put_diagonal_spread | 2 | 1 | 4860 | 3280502.00 | short | bid | 248.8750 | 0.2500 | ["215","240"] | ["0.3925","0.3164"] | [] | ["XCBO"] | 215.0000 | 240.0000 | 17 | 66 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:43:43Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a580-8836-7112-95eb-c39e61884ea2 | AMZN | 2026-09-15 10:37 | put_diagonal_spread | 2 | 1 | 165 | 165495.00 | unknown | — | 249.2500 | 0.2500 | ["245","250"] | ["0.3074","0.3492"] | [] | ["XBOX"] | 245.0000 | 250.0000 | 3 | 31 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:37:49Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a580-8836-7112-95eb-c38d0688d859 | AMZN | 2026-09-15 10:37 | put_diagonal_spread | 2 | 1 | 195 | 195585.00 | unknown | — | 249.2500 | 0.2500 | ["245","250"] | ["0.3074","0.3492"] | [] | ["XBOX"] | 245.0000 | 250.0000 | 3 | 31 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:37:49Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a580-844e-77e1-8c1f-2c89c918b127 | AMZN | 2026-09-15 10:37 | put_diagonal_spread | 2 | 1 | 195 | 195585.00 | unknown | — | 249.2500 | 0.2500 | ["245","250"] | ["0.3074","0.3492"] | [] | ["XBOX"] | 245.0000 | 250.0000 | 3 | 31 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:37:49Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a580-844e-77e1-8c1f-2c7845ece54c | AMZN | 2026-09-15 10:37 | put_diagonal_spread | 2 | 1 | 195 | 195585.00 | unknown | — | 249.2500 | 0.2500 | ["245","250"] | ["0.3074","0.3492"] | [] | ["XBOX"] | 245.0000 | 250.0000 | 3 | 31 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:37:49Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a579-aa66-7ad1-943e-f26d786dc9c0 | AMZN | 2026-09-15 10:30 | put_diagonal_spread | 2 | 1 | 3645 | 1786054.00 | short | bid | 249.6350 | 0.2400 | ["220","240"] | ["0.4013","0.3288"] | [] | ["XCBO"] | 220.0000 | 240.0000 | 10 | 45 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:30:12Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a577-4136-7121-840d-ac120eb85ebb | AMZN | 2026-09-15 10:27 | put_diagonal_spread | 2 | 1 | 40 | 83594.00 | short | bid | 249.8200 | 0.4500 | ["220","230"] | ["0.3641","0.3522"] | [] | ["XBOX"] | 220.0000 | 230.0000 | 122 | 185 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:27:49Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a12c-0b90-7471-bdc9-dd4a45703613 | AMZN | 2026-09-14 14:26 | put_diagonal_spread | 2 | 1 | 33 | 98769.00 | short | bid | 255.1700 | 0.4000 | ["255","270"] | ["0.3679","0.3381"] | [] | ["XCBO"] | 255.0000 | 270.0000 | 4 | 67 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:27:00Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09112-e3f0-7801-8c1f-cd40c07a4394 | AMZN | 2026-09-11 11:25 | put_diagonal_spread | 2 | 1 | 70 | 49420.00 | unknown | — | 256.2600 | 0.1500 | ["245","250"] | ["0.3060","0.3037"] | [] | ["XMIO"] | 245.0000 | 250.0000 | 7 | 35 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:25:47Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cb2-48f0-7f10-b7d8-dddd45fd539c | AMZN | 2026-09-10 15:01 | put_diagonal_spread | 2 | 1 | 8 | 37864.00 | short | bid | 251.7214 | 1.8500 | ["270","275"] | ["0.3654","0.2894"] | [] | ["XCBO"] | 270.0000 | 275.0000 | 15 | 50 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:01:41Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b88-2c89-7970-90b4-517072e4ff80 | AMZN | 2026-09-10 09:35 | put_diagonal_spread | 2 | 1 | 21 | 34293.00 | long | bid | 251.2650 | 0.4000 | ["245","250"] | ["0.3196","0.3152"] | [] | ["XCBO"] | 245.0000 | 250.0000 | 36 | 43 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:35:56Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08780-0611-74e2-8647-c98d328a4441 | AMZN | 2026-09-09 14:48 | put_diagonal_spread | 2 | 1 | 100 | 218100.00 | unknown | — | 252.5700 | 0.6500 | ["260","265"] | ["0.3048","0.3813"] | [] | ["XMIO"] | 260.0000 | 265.0000 | 2 | 9 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:48:48Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |