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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b617-8357-7480-9c87-37582d547ecd | QQQ | 2026-09-18 15:56 | call_diagonal_spread | 2 | 1 | 88 | 40832.00 | short | bid | 721.0000 | 0.1200 | ["719","720"] | ["0.7139","0.0737"] | [] | ["SPHR"] | 719.0000 | 720.0000 | 0 | 3 | false | false | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:56:28Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b612-b0f8-7421-8617-65e629495d4a | XLV | 2026-09-18 15:51 | call_diagonal_spread | 2 | 1 | 5 | 68800.00 | unknown | ask | 168.5850 | 4.2000 | ["90","110"] | ["0.8741","1.4075"] | [] | ["XPHO"] | 90.0000 | 110.0000 | 7 | 21 | false | false | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:51:20Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b612-a53f-7d83-8365-d23d2cc83620 | XLV | 2026-09-18 15:51 | call_diagonal_spread | 2 | 1 | 5 | 31830.00 | unknown | ask | 168.6100 | 4.3500 | ["120","154"] | ["0.8215","0.3397"] | [] | ["XPHO"] | 120.0000 | 154.0000 | 14 | 28 | false | false | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:51:20Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b612-9d6f-7561-a9c3-39d1f8d69249 | XLV | 2026-09-18 15:51 | call_diagonal_spread | 2 | 1 | 10 | 72320.00 | unknown | ask | 168.5900 | 2.8500 | ["115","150"] | ["1.6004","0.4183"] | [] | ["XPHO"] | 115.0000 | 150.0000 | 7 | 14 | false | false | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:51:20Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5ed-75b7-7db2-b089-e7f43471ecf8 | INTC | 2026-09-18 15:10 | call_diagonal_spread | 2 | 1 | 380 | 66500.00 | short | bid | 106.9400 | 0.1000 | ["110","118"] | ["1.8632","0.6290"] | [] | ["XBOX"] | 110.0000 | 118.0000 | 0 | 14 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:11:00Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d9-deef-78e1-b9fe-4e01a5914714 | MSFT | 2026-09-18 10:09 | call_diagonal_spread | 2 | 1 | 20 | 38640.00 | unknown | ask | 492.8850 | 1.8300 | ["620","680"] | ["0.2869","0.3074"] | [] | ["AMXO"] | 620.0000 | 680.0000 | 91 | 364 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:09:35Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d0-3260-7990-9dd6-d1078c1197b0 | AAPL | 2026-09-18 09:58 | call_diagonal_spread | 2 | 1 | 96 | 49152.00 | short | bid | 335.1130 | 0.4900 | ["335","340"] | ["0.1930","0.2055"] | [] | ["SPHR"] | 335.0000 | 340.0000 | 3 | 10 | false | false | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:59:06Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0afcb-a2fb-7780-b95d-38f6ae9a53cc | SPCX | 2026-09-17 10:35 | call_diagonal_spread | 2 | 1 | 71 | 35642.00 | short | bid | 154.7200 | 0.0800 | ["155","175"] | ["0.7266","0.5204"] | [] | ["SPHR"] | 155.0000 | 175.0000 | 1 | 29 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:36:12Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 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 |
| 01a0aa6c-9743-7653-8273-a01f2dce7459 | INTC | 2026-09-16 09:33 | call_diagonal_spread | 2 | 1 | 109 | 61040.00 | short | bid | 102.4000 | 0.2100 | ["103","115"] | ["0.8670","0.6385"] | [] | ["SPHR"] | 103.0000 | 115.0000 | 2 | 30 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:34:16Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a667-f266-7853-a848-b2b86ce389d4 | GOOG | 2026-09-15 14:50 | call_diagonal_spread | 2 | 1 | 40 | 26400.00 | short | bid | 340.6200 | 0.3300 | ["360","400"] | ["0.3850","0.3334"] | [] | ["AMXO"] | 360.0000 | 400.0000 | 3 | 94 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:50:47Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a172-9df8-7bd3-80a3-8381204c0499 | MSFT | 2026-09-14 15:43 | call_diagonal_spread | 2 | 2 | 300 | 27000.00 | short | bid | 507.0150 | 0.1400 | ["507.5","520"] | ["0.5469","0.2680"] | [] | ["AMXO"] | 507.5000 | 520.0000 | 0 | 2 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:44:25Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a05d-49e0-7192-a2db-3596eb4ec8ca | CRWD | 2026-09-14 10:41 | call_diagonal_spread | 2 | 1 | 76 | 81320.00 | short | ask | 231.6800 | 0.8000 | ["250","265"] | ["0.5836","0.5690"] | [] | ["SPHR"] | 250.0000 | 265.0000 | 18 | 32 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:41:29Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a02e-0068-7c30-afaa-168b3ece5c29 | AMZN | 2026-09-14 09:49 | call_diagonal_spread | 2 | 1 | 50 | 78150.00 | long | ask | 253.7850 | 0.3400 | ["255","265"] | ["0.4285","0.3609"] | [] | ["SPHR"] | 255.0000 | 265.0000 | 0 | 95 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:49:31Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a090ea-7848-7f61-affb-127f2807b51d | AAPL | 2026-09-11 10:41 | call_diagonal_spread | 2 | 1 | 50 | 76700.00 | short | bid | 334.8600 | 0.4000 | ["327.5","330"] | ["0.5224","0.2689"] | [] | ["SPHR"] | 327.5000 | 330.0000 | 0 | 7 | false | false | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:41:37Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cc6-1f10-7262-b4cd-b73d54bcc849 | NVDA | 2026-09-10 15:23 | call_diagonal_spread | 2 | 1 | 90 | 91350.00 | unknown | — | 218.2410 | 0.2000 | ["220","230"] | ["0.3322","0.3363"] | [] | ["XBOX"] | 220.0000 | 230.0000 | 15 | 36 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:23:52Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08cbe-7a08-7d81-8410-cd40b0dae145 | SMH | 2026-09-10 15:14 | call_diagonal_spread | 2 | 2 | 21 | 62916.00 | long | bid | 561.2400 | 4.9500 | ["547.5","550"] | ["0.5467","0.3176"] | [] | ["AMXO"] | 547.5000 | 550.0000 | 1 | 4 | false | false | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:15:20Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a086e1-35d0-78e2-a1ee-98097dfbf186 | XLE | 2026-09-09 11:54 | call_diagonal_spread | 2 | 1 | 88 | 85800.00 | short | ask | 65.2397 | 0.3500 | ["60","65"] | ["0.2720","0.2388"] | [] | ["SPHR"] | 60.0000 | 65.0000 | 21 | 128 | false | false | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:55:31Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086a0-ecc9-7240-8fe9-801c1474370d | INTC | 2026-09-09 10:44 | call_diagonal_spread | 2 | 1 | 90 | 87300.00 | short | ask | 105.9050 | 0.2000 | ["101","102"] | ["1.0947","0.7384"] | [] | ["SPHR"] | 101.0000 | 102.0000 | 0 | 2 | false | false | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:44:47Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a081c7-b6c9-7143-adf6-ba67c59bcd4b | SPCX | 2026-09-08 12:09 | call_diagonal_spread | 2 | 1 | 50 | 49500.00 | short | ask | 153.4850 | 0.5000 | ["155","175"] | ["0.5751","0.5414"] | [] | ["SPHR"] | 155.0000 | 175.0000 | 10 | 45 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:09:31Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08136-a618-7693-b516-418bd84300dd | AMZN | 2026-09-08 09:30 | call_diagonal_spread | 2 | 1 | 50 | 53750.00 | long | ask | 255.5400 | 3.5000 | ["270","275"] | ["0.3331","0.3166"] | [] | ["SPHR"] | 270.0000 | 275.0000 | 38 | 45 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:30:19Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |