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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a08182-1691-73d3-a028-5a53ab97c9cf | AMZN | 2026-09-08 10:52 | call_frontspread | 2 | 3 | 1095 | 139207.00 | long | bid | 256.7669 | 0.0200 | ["265","267.5"] | ["0.3655","0.3768"] | ["265.33"] | ["EDGO","XCBO","XISX"] | 265.0000 | 267.5000 | 3 | 3 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:53:21Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081ad-3d70-7f11-ad7d-8e23d0f71764 | AMZN | 2026-09-08 11:40 | call_frontspread | 2 | 1 | 20 | 61542.00 | long | bid | 256.9800 | 0.5000 | ["255","270"] | ["0.3726","0.3703"] | ["262.21"] | ["XCBO"] | 255.0000 | 270.0000 | 73 | 73 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:40:08Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a090d2-4cc8-7f33-88f3-266a176f1efd | AMZN | 2026-09-11 10:14 | call_frontspread | 2 | 7 | 38 | 26580.00 | long | bid | 256.2200 | 0.5200 | ["250","255"] | ["0.7437","0.3408"] | ["255.72"] | ["ARCO","BATO","C2OX","EDGO","EMLD","SPHR","XBOX"] | 250.0000 | 255.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:15:10Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0a12c-3a70-7a01-a7c1-6a47a6710ab9 | AMZN | 2026-09-14 14:27 | call_frontspread | 2 | 2 | 8 | 40551.00 | long | bid | 255.1901 | 1.2500 | ["270","350"] | ["0.3704","0.3667"] | ["286.78","539.66"] | ["ARCO","EDGO"] | 270.0000 | 350.0000 | 459 | 459 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:27:46Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0af9e-6cc4-7022-ad08-f6c69dea56c1 | AMZN | 2026-09-17 09:46 | call_frontspread | 2 | 3 | 18 | 25317.00 | long | bid | 249.7150 | 0.4000 | ["280","300"] | ["0.3430","0.3426"] | ["283.15","384.25"] | ["EMLD","XMIO","XPHO"] | 280.0000 | 300.0000 | 120 | 120 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:46:35Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0af9e-6cc4-7022-ad08-f68e78e2a304 | AMZN | 2026-09-17 09:46 | call_frontspread | 2 | 3 | 18 | 25334.00 | long | bid | 249.7150 | 0.4000 | ["280","300"] | ["0.3431","0.3428"] | ["283.15","384.27"] | ["EMLD","XCBO","XISX"] | 280.0000 | 300.0000 | 120 | 120 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:46:35Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0af9f-ff1b-7d02-9a98-08acf155dd34 | AMZN | 2026-09-17 09:48 | call_frontspread | 2 | 1 | 18 | 25446.00 | long | bid | 249.8700 | 0.4000 | ["280","300"] | ["0.3427","0.3427"] | ["283.14","384.30"] | ["EDGO"] | 280.0000 | 300.0000 | 120 | 120 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:48:13Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afa0-6894-7512-b4d2-e91f8526be0a | AMZN | 2026-09-17 09:48 | call_frontspread | 2 | 1 | 18 | 25266.00 | long | bid | 249.6600 | 0.4500 | ["280","300"] | ["0.3430","0.3427"] | ["283.14","384.30"] | ["EDGO"] | 280.0000 | 300.0000 | 120 | 120 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:48:46Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afa0-6894-7512-b4d2-e8f4d12658e4 | AMZN | 2026-09-17 09:48 | call_frontspread | 2 | 1 | 18 | 25302.00 | long | bid | 249.6600 | 0.5000 | ["280","300"] | ["0.3432","0.3429"] | ["283.14","384.30"] | ["EDGO"] | 280.0000 | 300.0000 | 120 | 120 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:48:46Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afa0-6894-7512-b4d2-e8ddf3b95aa6 | AMZN | 2026-09-17 09:48 | call_frontspread | 2 | 1 | 18 | 25302.00 | long | bid | 249.6600 | 0.5000 | ["280","300"] | ["0.3432","0.3429"] | ["283.14","384.30"] | ["EDGO"] | 280.0000 | 300.0000 | 120 | 120 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:48:46Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afa0-6894-7512-b4d2-e8b900572ed1 | AMZN | 2026-09-17 09:48 | call_frontspread | 2 | 1 | 18 | 25302.00 | long | bid | 249.6600 | 0.5000 | ["280","300"] | ["0.3432","0.3429"] | ["283.14","384.30"] | ["EDGO"] | 280.0000 | 300.0000 | 120 | 120 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:48:46Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afa0-6894-7512-b4d2-e945ceb1c988 | AMZN | 2026-09-17 09:48 | call_frontspread | 2 | 1 | 18 | 25245.00 | long | bid | 249.6600 | 0.4500 | ["280","300"] | ["0.3427","0.3427"] | ["283.13","384.37"] | ["EDGO"] | 280.0000 | 300.0000 | 120 | 120 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:48:46Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afa0-6894-7512-b4d2-e93137180af8 | AMZN | 2026-09-17 09:48 | call_frontspread | 2 | 5 | 36 | 50372.00 | long | bid | 249.6600 | 0.4500 | ["280","300"] | ["0.3424","0.3421"] | ["283.14","384.30"] | ["EMLD","XBOX","XISX","XMIO","XPHO"] | 280.0000 | 300.0000 | 120 | 120 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:48:46Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afd8-455b-7472-b353-37dfd0f5fbea | AMZN | 2026-09-17 10:49 | call_frontspread | 2 | 3 | 18 | 26950.00 | long | bid | 251.5200 | 0.5500 | ["280","300"] | ["0.3427","0.3423"] | ["283.28","383.60"] | ["EDGO","EMLD","XBOX"] | 280.0000 | 300.0000 | 120 | 120 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:49:52Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |