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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c58f-ff3f-7ff0-8954-08c4e6c1b52a | SPY | 2026-09-21 16:02 | call_condor | 4 | 1 | 50 | 33450.00 | short | bid | 773.3000 | 0.0500 | ["772","773","774","775"] | ["0.1040","0.1035","0.1034","0.1030"] | ["772.19","774.81"] | ["MCRY"] | 772.0000 | 775.0000 | 1 | 1 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T20:03:33Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c540-877f-7370-a22f-9c67b5d67c82 | SPY | 2026-09-21 14:35 | call_condor | 4 | 1 | 6 | 29436.00 | unknown | — | 773.6900 | 0.2200 | ["770","780","800","820"] | ["0.1425","0.1348","0.1238","0.1188"] | [] | ["C2OX"] | 770.0000 | 820.0000 | 60 | 60 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:35:38Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c45c-ce9f-7233-bd34-a8f23fa647c4 | SPY | 2026-09-21 10:26 | call_condor | 4 | 1 | 15 | 69405.00 | long | ask | 769.1100 | 0.2800 | ["769","774","776","781"] | ["0.1314","0.1266","0.1250","0.1212"] | ["769.55","780.45"] | ["XISX"] | 769.0000 | 781.0000 | 39 | 39 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:27:02Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c438-2bb7-7ac0-8e32-869b4da49c56 | SPY | 2026-09-21 09:46 | call_condor | 4 | 1 | 50 | 94200.00 | long | ask | 767.1400 | 0.0400 | ["761","762","763","764"] | ["0.1293","0.1234","0.1220","0.1214"] | ["761.06","763.94"] | ["XISX"] | 761.0000 | 764.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:46:51Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c42d-a84f-7a83-8b01-a53936aaabcb | SPY | 2026-09-21 09:35 | call_condor | 4 | 1 | 50 | 191800.00 | long | bid | 766.4938 | 0.5200 | ["762","766","771","777"] | ["0.1270","0.1218","0.1165","0.1112"] | ["775.14"] | ["XMIO"] | 762.0000 | 777.0000 | 25 | 25 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:35:23Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b625-2b6f-7d93-a5cf-bfeed37d5044 | SPY | 2026-09-18 16:11 | call_condor | 4 | 1 | 50 | 42900.00 | unknown | — | 762.9500 | 0.0800 | ["761","762","763","764"] | ["0.0646","0.0637","0.0612","0.0597"] | [] | ["XISX"] | 761.0000 | 764.0000 | 3 | 3 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T20:11:46Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4b6-0955-7431-88be-0f6133ff5ad1 | SPY | 2026-09-18 09:30 | call_condor | 4 | 1 | 146 | 26718.00 | short | bid | 761.4500 | 0.1000 | ["762","764","765","767"] | ["0.1628","0.1587","0.1608","0.1565"] | ["762.49","766.51"] | ["XISX"] | 762.0000 | 767.0000 | 0 | 0 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:30:21Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0f3-2753-7391-aee9-7aca379d7593 | SPY | 2026-09-17 15:58 | call_condor | 4 | 1 | 380 | 1431080.00 | short | bid | 762.9900 | 1.5300 | ["754","755","756","757"] | ["0.0910","0.0939","0.0897","0.0913"] | ["754.02","756.98"] | ["MCRY"] | 754.0000 | 757.0000 | 8 | 8 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:58:50Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0e1-702b-7020-8f3b-c390223a8568 | SPY | 2026-09-17 15:39 | call_condor | 4 | 1 | 50 | 188700.00 | unknown | — | 762.9910 | 0.3300 | ["754","755","756","757"] | ["0.0899","0.0920","0.0926","0.0932"] | [] | ["MCRY"] | 754.0000 | 757.0000 | 8 | 8 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:39:23Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0af93-ed43-7381-9e3e-c90a34c2ce0e | SPY | 2026-09-17 09:35 | call_condor | 4 | 1 | 50 | 189100.00 | unknown | — | 761.4000 | 0.7300 | ["754","762","769","779"] | ["0.1255","0.1171","0.1113","0.1048"] | [] | ["XMIO"] | 754.0000 | 779.0000 | 29 | 29 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:35:10Z"} | 2026-09-17 | 2026-09-17 17:27 | 2026-09-17 17:27 |
| 01a0abcd-34cb-71a2-9721-4d3896b70705 | SPY | 2026-09-16 15:59 | call_condor | 4 | 1 | 50 | 197350.00 | short | ask | 753.9100 | 0.5200 | ["751","754","764","769"] | ["0.1360","0.1322","0.1222","0.1176"] | ["767.13"] | ["XCBO"] | 751.0000 | 769.0000 | 30 | 30 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:59:16Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab8a-c8e3-7891-beb4-a55dcc2ff604 | SPY | 2026-09-16 14:46 | call_condor | 4 | 1 | 50 | 77050.00 | unknown | — | 758.8700 | 0.2100 | ["753","756","763","766"] | ["0.1673","0.1606","0.1484","0.1439"] | [] | ["AMXO"] | 753.0000 | 766.0000 | 2 | 2 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:46:54Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a576-d7be-7b52-9bf4-ca1fb133f9bd | SPY | 2026-09-15 10:27 | call_condor | 4 | 1 | 3 | 36807.00 | unknown | — | 757.6000 | 0.6400 | ["750","755","760","765"] | ["0.1482","0.1451","0.1421","0.1393"] | [] | ["XISX"] | 750.0000 | 765.0000 | 122 | 122 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:27:11Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a17c-c3a1-7130-96f3-cd9341db0915 | SPY | 2026-09-14 15:55 | call_condor | 4 | 1 | 30 | 121590.00 | unknown | — | 760.9500 | 0.5100 | ["754","755","756","757"] | ["0.1246","0.1238","0.1223","0.1216"] | [] | ["XISX"] | 754.0000 | 757.0000 | 11 | 11 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:55:05Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a02a-a8f0-75e1-8bbd-b77592d481a9 | SPY | 2026-09-14 09:45 | call_condor | 4 | 1 | 10 | 30030.00 | unknown | — | 759.5800 | 0.1900 | ["761","766","776","780"] | ["0.1290","0.1240","0.1152","0.1131"] | [] | ["AMXO"] | 761.0000 | 780.0000 | 32 | 32 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:45:44Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0920d-5921-79b3-b892-af3e3752f664 | SPY | 2026-09-11 15:59 | call_condor | 4 | 1 | 8 | 45800.00 | unknown | — | 764.4001 | 0.2700 | ["775","790","805","820"] | ["0.1340","0.1266","0.1211","0.1173"] | [] | ["XISX"] | 775.0000 | 820.0000 | 126 | 126 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:59:16Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09128-40b0-71f0-ab74-b2aa20af1b67 | SPY | 2026-09-11 11:48 | call_condor | 4 | 1 | 14 | 66878.00 | unknown | — | 765.8650 | 0.1800 | ["775","780","815","825"] | ["0.1338","0.1307","0.1170","0.1152"] | [] | ["C2OX"] | 775.0000 | 825.0000 | 98 | 98 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:49:01Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09128-38e0-7b80-98ac-9604e6b3d1a9 | SPY | 2026-09-11 11:48 | call_condor | 4 | 3 | 11 | 52547.00 | long | ask | 765.8500 | 0.1900 | ["775","780","815","825"] | ["0.1338","0.1308","0.1171","0.1153"] | ["775.97","819.03"] | ["BATO","C2OX","EDGO"] | 775.0000 | 825.0000 | 98 | 98 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:49:01Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08ccc-7bf8-7223-ad29-1ae4c528521e | SPY | 2026-09-10 15:30 | call_condor | 4 | 1 | 5 | 34235.00 | unknown | — | 757.5900 | 3.9000 | ["739","743","744","749"] | ["0.1841","0.1775","0.1751","0.1643"] | [] | ["XISX"] | 739.0000 | 749.0000 | 8 | 8 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:30:34Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c13-6140-7120-a406-4c8a1116419d | SPY | 2026-09-10 12:07 | call_condor | 4 | 1 | 40 | 45400.00 | unknown | — | 758.2400 | 0.0700 | ["815","820","835","840"] | ["0.1232","0.1219","0.1197","0.1194"] | [] | ["EDGO"] | 815.0000 | 840.0000 | 99 | 99 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:08:08Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bf7-bf08-7d02-9f44-1419d8e4ec54 | SPY | 2026-09-10 11:37 | call_condor | 4 | 1 | 5 | 31860.00 | short | bid | 759.9100 | 5.1300 | ["735","740","755","760"] | ["0.1610","0.1524","0.1477","0.1365"] | ["736.34","758.66"] | ["XMIO"] | 735.0000 | 760.0000 | 8 | 8 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:37:56Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b8b-9f58-78c1-bb37-ddb510ba2119 | SPY | 2026-09-10 09:39 | call_condor | 4 | 1 | 5 | 48605.00 | unknown | — | 758.1800 | 1.0000 | ["790","800","850","860"] | ["0.1577","0.1535","0.1383","0.1365"] | [] | ["XMIO"] | 790.0000 | 860.0000 | 293 | 293 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:39:49Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b85-3e88-70e0-bbe0-043288dc84a6 | SPY | 2026-09-10 09:32 | call_condor | 4 | 1 | 34 | 36040.00 | short | bid | 757.9900 | 0.1000 | ["757","767","777","787"] | ["0.1469","0.1296","0.1177","0.1186"] | ["761.40","782.60"] | ["XMIO"] | 757.0000 | 787.0000 | 8 | 8 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:32:48Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a086ec-41f0-7d41-9d71-54f99b5c1ada | SPY | 2026-09-09 12:07 | call_condor | 4 | 1 | 50 | 82850.00 | long | ask | 762.1500 | 0.0900 | ["810","815","830","835"] | ["0.1225","0.1214","0.1193","0.1191"] | ["810.57","834.43"] | ["XMIO"] | 810.0000 | 835.0000 | 100 | 100 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:07:07Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08693-6008-7ab2-bd4e-16fcb2b78d3f | SPY | 2026-09-09 10:29 | call_condor | 4 | 1 | 4 | 27368.00 | unknown | — | 763.9400 | 1.1200 | ["748","749","750","751"] | ["0.1527","0.1508","0.1492","0.1468"] | [] | ["XPHO"] | 748.0000 | 751.0000 | 9 | 9 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:30:09Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a06d39-8615-7562-87cf-a2c497a13dfa | SPY | 2026-09-04 12:21 | call_condor | 4 | 1 | 21 | 118083.00 | unknown | — | 771.0400 | 0.1400 | ["775","780","815","825"] | ["0.1297","0.1271","0.1150","0.1134"] | [] | ["C2OX"] | 775.0000 | 825.0000 | 105 | 105 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:21:24Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d2d-be75-7cd2-aff6-79dcfdbc930f | SPY | 2026-09-04 12:08 | call_condor | 4 | 1 | 100 | 217900.00 | long | ask | 770.3800 | 0.1000 | ["770","775","780","790"] | ["0.0965","0.0937","0.0915","0.0887"] | ["770.01","784.99"] | ["XMIO"] | 770.0000 | 790.0000 | 26 | 26 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:08:43Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |