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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5a4-a517-7773-af28-4adbf79d5701 | META | 2026-09-18 13:50 | call_frontspread | 2 | 1 | 2 | 25384.00 | long | bid | 670.3800 | 4.0000 | ["600","680"] | ["0.4202","0.4167"] | ["672.50"] | ["C2OX"] | 600.0000 | 680.0000 | 91 | 91 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:51:21Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b56b-ddef-7793-9f4b-2855fcadfd43 | META | 2026-09-18 12:48 | call_frontspread | 2 | 1 | 2 | 25394.00 | long | bid | 670.5100 | 4.0000 | ["600","680"] | ["0.4193","0.4170"] | ["672.45"] | ["XCBO"] | 600.0000 | 680.0000 | 91 | 91 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:49:22Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0abcc-235b-7ab2-9e1c-928d71ef3cdd | META | 2026-09-16 15:57 | call_frontspread | 2 | 1 | 8 | 161932.00 | long | bid | 672.8100 | 4.3000 | ["650","740"] | ["0.4234","0.4234"] | ["653.67","998.98"] | ["XMIO"] | 650.0000 | 740.0000 | 366 | 366 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:58:14Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab8d-265b-7711-8d81-b5d039f67a66 | META | 2026-09-16 14:49 | call_frontspread | 2 | 1 | 13 | 124928.00 | long | bid | 682.2600 | 4.3500 | ["600","675"] | ["0.3967","0.3845"] | ["638.45","757.24"] | ["XISX"] | 600.0000 | 675.0000 | 30 | 30 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:49:15Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab8d-265b-7711-8d81-b5c68ca518d2 | META | 2026-09-16 14:49 | call_frontspread | 2 | 1 | 13 | 124882.00 | long | bid | 682.2600 | 4.3500 | ["600","675"] | ["0.3949","0.3847"] | ["638.37","757.42"] | ["XPHO"] | 600.0000 | 675.0000 | 30 | 30 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:49:15Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab8d-1e8b-7090-8070-fbc5ab033f84 | META | 2026-09-16 14:49 | call_frontspread | 2 | 1 | 13 | 125712.00 | long | bid | 682.4550 | 3.8000 | ["600","675"] | ["0.4052","0.3865"] | ["638.57","756.97"] | ["XBOX"] | 600.0000 | 675.0000 | 30 | 30 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:49:15Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab8d-1aa3-72c1-b087-f248a684b688 | META | 2026-09-16 14:49 | call_frontspread | 2 | 1 | 13 | 124964.00 | long | bid | 682.4550 | 4.3000 | ["600","675"] | ["0.3907","0.3839"] | ["638.32","757.54"] | ["MCRY"] | 600.0000 | 675.0000 | 30 | 30 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:49:15Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab8d-16bb-7992-b8a2-8f6b1aad9ca5 | META | 2026-09-16 14:49 | call_frontspread | 2 | 1 | 13 | 126043.00 | long | bid | 682.3403 | 4.4500 | ["600","675"] | ["0.4129","0.3889"] | ["638.59","756.92"] | ["EDGO"] | 600.0000 | 675.0000 | 30 | 30 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:49:15Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa91-1ed3-7e90-9d60-6bb4c65d9c8e | META | 2026-09-16 10:13 | call_frontspread | 2 | 1 | 5 | 96592.00 | long | bid | 679.2800 | 8.7000 | ["585","615"] | ["0.4350","0.4287"] | ["747.78"] | ["XMIO"] | 585.0000 | 615.0000 | 93 | 93 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:14:15Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a616-e466-7732-8208-e4ea5f99819f | META | 2026-09-15 13:21 | call_frontspread | 2 | 1 | 6 | 43696.00 | long | bid | 665.0601 | 0.5500 | ["620","670"] | ["0.3935","0.3845"] | ["664.44"] | ["XCBO"] | 620.0000 | 670.0000 | 31 | 31 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:22:30Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a090cb-b930-71c3-8655-4060ae90266e | META | 2026-09-11 10:07 | call_frontspread | 2 | 2 | 8 | 41170.00 | long | bid | 653.5400 | 1.6500 | ["900","1000"] | ["0.4332","0.4378"] | ["921.64"] | ["ARCO","BATO"] | 900.0000 | 1000.0000 | 279 | 279 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:08:04Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c8f-7eb0-7002-8e72-db0ae6b3ddf8 | META | 2026-09-10 14:23 | call_frontspread | 2 | 5 | 47 | 164221.00 | long | bid | 646.7100 | 0.6500 | ["620","640"] | ["0.5417","0.4900"] | ["639.72"] | ["ARCO","XBOX","XISX"] | 620.0000 | 640.0000 | 1 | 1 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:24:16Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c8f-7eb0-7002-8e72-dafd2b8e3ef8 | META | 2026-09-10 14:23 | call_frontspread | 2 | 2 | 13 | 46660.00 | unknown | — | 646.7100 | 0.6500 | ["620","640"] | ["0.5613","0.4966"] | [] | ["XISX","XMIO"] | 620.0000 | 640.0000 | 1 | 1 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:24:16Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c8f-7eb0-7002-8e72-dae58cdb63ce | META | 2026-09-10 14:23 | call_frontspread | 2 | 3 | 20 | 67432.00 | long | bid | 646.7100 | 0.6250 | ["620","640"] | ["0.5503","0.4974"] | ["642.46"] | ["AMXO","XMIO","XPHO"] | 620.0000 | 640.0000 | 1 | 1 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:24:16Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bed-bc88-77a2-8513-3e7782b933f3 | META | 2026-09-10 11:26 | call_frontspread | 2 | 1 | 2 | 56880.00 | long | bid | 652.4650 | 9.6000 | ["460","540"] | ["0.4685","0.4534"] | ["653.08"] | ["XCBO"] | 460.0000 | 540.0000 | 162 | 162 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:26:59Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08690-c410-7872-818c-c2e105b1033b | META | 2026-09-09 10:27 | call_frontspread | 2 | 1 | 39 | 605907.00 | long | bid | 641.4200 | 4.0500 | ["600","620"] | ["0.4178","0.4186"] | ["760.52"] | ["XMIO"] | 600.0000 | 620.0000 | 128 | 128 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:27:30Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08298-4950-7f43-96ff-aaaf8da50ac5 | META | 2026-09-08 15:56 | call_frontspread | 2 | 1 | 510 | 476575.00 | long | bid | 614.2200 | 0.2000 | ["625","627.5"] | ["0.4500","0.4541"] | ["638.64"] | ["XPHO"] | 625.0000 | 627.5000 | 3 | 3 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:56:57Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081ed-1530-7df1-990c-83ce0cb368ea | META | 2026-09-08 12:49 | call_frontspread | 2 | 1 | 8 | 102198.00 | long | bid | 618.5800 | 5.5500 | ["565","605"] | ["0.4114","0.4115"] | ["566.85","719.45"] | ["ARCO"] | 565.0000 | 605.0000 | 101 | 101 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:50:27Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081b8-1e98-7240-93e9-5bd90ebdd96a | META | 2026-09-08 11:51 | call_frontspread | 2 | 1 | 24 | 376480.00 | long | bid | 616.7750 | 4.2500 | ["555","565"] | ["0.4310","0.4300"] | ["679.24"] | ["XMIO"] | 555.0000 | 565.0000 | 73 | 73 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:52:17Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06dd7-509d-7d92-967e-1355916f8101 | META | 2026-09-04 15:13 | call_frontspread | 2 | 1 | 7 | 61132.00 | long | bid | 615.9100 | 2.4500 | ["610","630"] | ["0.4144","0.4173"] | ["611.74","739.56"] | ["XMIO"] | 610.0000 | 630.0000 | 77 | 77 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:14:13Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dd4-6a6d-7443-ad79-4218c7bb30f5 | META | 2026-09-04 15:10 | call_frontspread | 2 | 1 | 5 | 53500.00 | long | bid | 615.4350 | 3.7500 | ["580","585"] | ["0.4155","0.4149"] | ["645.00"] | ["XISX"] | 580.0000 | 585.0000 | 77 | 77 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:11:00Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dc2-884d-7660-b50e-28b7442e28f6 | META | 2026-09-04 14:50 | call_frontspread | 2 | 1 | 17 | 192505.00 | long | bid | 612.0850 | 2.8000 | ["585","610"] | ["0.4001","0.3998"] | ["585.90","722.48"] | ["XISX"] | 585.0000 | 610.0000 | 105 | 105 | false | false | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:51:15Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d7d-7c85-7991-be69-b44fefe256d9 | META | 2026-09-04 13:35 | call_frontspread | 2 | 1 | 13 | 135142.00 | long | bid | 609.0200 | 2.2500 | ["595","615"] | ["0.3974","0.3968"] | ["595.35","723.08"] | ["MCRY"] | 595.0000 | 615.0000 | 105 | 105 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:36:16Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |