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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b599-a4af-7b13-8e97-d399d35d41c0 | META | 2026-09-18 13:38 | call_diagonal_spread | 2 | 1 | 500 | 7746500.00 | long | ask | 670.6100 | 4.0500 | ["625","670"] | ["0.4380","0.4229"] | [] | ["SPHR"] | 625.0000 | 670.0000 | 63 | 154 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:39:27Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b556-3ec8-7260-9720-4fcde920c71d | META | 2026-09-18 12:25 | call_diagonal_spread | 2 | 1 | 135 | 741960.00 | long | ask | 669.6200 | 1.4500 | ["660","670"] | ["0.3882","0.3821"] | [] | ["XBOX"] | 660.0000 | 670.0000 | 14 | 28 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:25:23Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b555-d937-7103-87f0-909827eb69ef | META | 2026-09-18 12:24 | call_diagonal_spread | 2 | 1 | 225 | 1106775.00 | unknown | ask | 670.0250 | 0.9500 | ["660","670"] | ["0.3901","0.3782"] | [] | ["XBOX"] | 660.0000 | 670.0000 | 7 | 28 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:25:11Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4e5-48d0-7cb0-a6f2-aba5d50130f8 | META | 2026-09-18 10:21 | call_diagonal_spread | 2 | 1 | 60 | 596400.00 | long | ask | 673.7000 | 1.7000 | ["720","740"] | ["0.4043","0.4208"] | [] | ["SPHR"] | 720.0000 | 740.0000 | 119 | 154 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:22:14Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0abcb-b5fb-7790-a4a6-1b0bacb8db09 | META | 2026-09-16 15:57 | call_diagonal_spread | 2 | 1 | 50 | 77900.00 | long | ask | 672.7100 | 1.0500 | ["677.5","680"] | ["0.3623","0.4698"] | [] | ["SPHR"] | 677.5000 | 680.0000 | 2 | 5 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:57:32Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab56-10cb-7790-9aea-f64f23e93ee1 | META | 2026-09-16 13:48 | call_diagonal_spread | 2 | 2 | 25 | 70250.00 | short | ask | 674.8550 | 1.1500 | ["665","685"] | ["0.4900","0.3975"] | [] | ["AMXO"] | 665.0000 | 685.0000 | 2 | 9 | false | false | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:49:10Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a08c41-8d90-7bf1-b5a8-3b715a57e0b9 | META | 2026-09-10 12:58 | call_diagonal_spread | 2 | 1 | 126 | 457380.00 | short | ask | 652.1100 | 0.6000 | ["632.5","652.5"] | ["0.5164","0.4008"] | [] | ["SPHR"] | 632.5000 | 652.5000 | 1 | 8 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:58:59Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bae-90a8-7d61-a3fd-86058b2aa296 | META | 2026-09-10 10:17 | call_diagonal_spread | 2 | 1 | 110 | 674960.00 | short | bid | 651.8950 | 0.9000 | ["620","625"] | ["0.3845","0.6252"] | [] | ["AMXO"] | 620.0000 | 625.0000 | 1 | 4 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:18:13Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |