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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c531-fcd7-7351-8e16-1ab1dd8d7c6e | SOXX | 2026-09-21 14:19 | call_frontspread | 2 | 1 | 2520 | 7452000.00 | long | bid | 557.6200 | 2.8000 | ["550","585"] | ["0.3661","0.3608"] | ["560.60","646.00"] | ["AMXO"] | 550.0000 | 585.0000 | 25 | 25 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:19:52Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0ab70-18db-73f2-90a9-99eba2bcf988 | FPS | 2026-09-16 14:17 | call_frontspread | 2 | 1 | 1800 | 993000.00 | long | bid | 35.8850 | 0.4500 | ["35","37.5"] | ["0.7238","0.7585"] | ["36.38"] | ["AMXO"] | 35.0000 | 37.5000 | 30 | 30 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:17:23Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa88-50eb-7782-abfa-9fcbbcc6ea48 | UMC | 2026-09-16 10:04 | call_frontspread | 2 | 1 | 1350 | 388800.00 | long | bid | 22.6550 | 0.4000 | ["22","23"] | ["0.5768","0.6037"] | ["0","22","26.43"] | ["SPHR"] | 22.0000 | 23.0000 | 30 | 30 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:04:34Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a5f0-fd46-7b31-b10f-1ed2473958a6 | IBIT | 2026-09-15 12:40 | call_frontspread | 2 | 2 | 233 | 174190.00 | long | bid | 43.1822 | 0.3000 | ["36","37"] | ["1.1480","1.0821"] | ["43.26"] | ["AMXO"] | 36.0000 | 37.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:40:52Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a564-9bc6-71b3-b914-9f409ee34637 | DHT | 2026-09-15 10:07 | call_frontspread | 2 | 1 | 1986 | 317760.00 | long | bid | 22.7300 | 0.1500 | ["23","24"] | ["0.4688","0.5225"] | ["23.70"] | ["XBOX"] | 23.0000 | 24.0000 | 31 | 31 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:07:18Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a091b8-5380-7ac3-a722-a97ba86d8659 | DINO | 2026-09-11 14:26 | call_frontspread | 2 | 1 | 952 | 308380.00 | long | bid | 109.2700 | 0.4500 | ["110","115"] | ["0.4645","0.5192"] | ["111.76"] | ["XPHO"] | 110.0000 | 115.0000 | 7 | 7 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:26:33Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09198-a239-7933-91b7-63484eb3e53f | OSCR | 2026-09-11 13:51 | call_frontspread | 2 | 1 | 10000 | 1450000.00 | long | bid | 33.3000 | 0.4200 | ["34","36"] | ["0.7053","0.8000"] | ["34.39","50.50"] | ["XPHO"] | 34.0000 | 36.0000 | 7 | 7 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:52:12Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09141-4ec0-7761-92c0-169c3c34d4fa | LQD | 2026-09-11 12:16 | call_frontspread | 2 | 3 | 1000 | 120000.00 | long | bid | 104.5400 | 0.2800 | ["106","107"] | ["0.0362","0.0411"] | ["109.03"] | ["AMXO"] | 106.0000 | 107.0000 | 126 | 126 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:16:18Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08667-6638-7cc2-b855-2dbbff37b488 | CIFR | 2026-09-09 09:41 | call_frontspread | 2 | 1 | 5000 | 473000.00 | long | bid | 18.1200 | 0.1800 | ["18","20"] | ["1.3252","1.5077"] | ["18.59"] | ["SPHR"] | 18.0000 | 20.0000 | 2 | 2 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:42:13Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08277-2cc1-7232-bf02-7b4f670c1ca7 | CIFR | 2026-09-08 15:20 | call_frontspread | 2 | 1 | 6500 | 1476000.00 | long | bid | 18.9800 | 0.2100 | ["17","20"] | ["1.1385","1.2898"] | ["18.97"] | ["SPHR"] | 17.0000 | 20.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:21:17Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081af-1231-7002-9a4c-b3482be48495 | INTC | 2026-09-08 11:42 | call_frontspread | 2 | 1 | 2000 | 5211250.00 | long | bid | 104.4300 | 0.3500 | ["90","110"] | ["0.7018","0.7265"] | ["94.30","144.54"] | ["SPHR"] | 90.0000 | 110.0000 | 73 | 73 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:42:24Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06de8-aded-7ec1-a2f3-384227094808 | SYF | 2026-09-04 15:32 | call_frontspread | 2 | 1 | 1188 | 629640.00 | long | bid | 79.9200 | 1.5000 | ["80","82.5"] | ["0.2927","0.3094"] | ["81.3"] | ["SPHR"] | 80.0000 | 82.5000 | 42 | 42 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:32:48Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |