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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c542-19d6-75e2-bc1f-3e4f18bd8870 | ASTS | 2026-09-21 14:37 | put_condor | 4 | 1 | 32 | 482720.00 | unknown | bid | 61.7250 | 2.4500 | ["80","90","100","110"] | ["0.8057","0.8243","0.8451","0.8605"] | ["57.29"] | ["XBOX"] | 80.0000 | 110.0000 | 179 | 179 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:37:40Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c513-93af-7683-a331-4a02694ec2aa | ASTS | 2026-09-21 13:46 | put_calendar | 2 | 3 | 424 | 379480.00 | short | bid | 61.8600 | 0.5000 | ["65"] | ["0.7572"] | [] | ["EMLD","MCRY","XISX"] | 65.0000 | 65.0000 | 4 | 11 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:46:35Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c513-93af-7683-a331-49f30ba54d0b | ASTS | 2026-09-21 13:46 | put_calendar | 2 | 3 | 576 | 515520.00 | short | bid | 61.8600 | 0.5000 | ["65"] | ["0.7572"] | [] | ["ARCO","EMLD","SPHR"] | 65.0000 | 65.0000 | 4 | 11 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:46:35Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c469-980f-71b1-8c5f-59ebe7ee7da4 | ASTS | 2026-09-21 10:40 | other | 4 | 3 | 104 | 360004.00 | unknown | bid | 61.9002 | 2.8900 | ["60","67","80"] | ["0.7364","0.8215","1.1564"] | [] | ["ARCO","EMLD","SPHR"] | 60.0000 | 80.0000 | 4 | 11 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:40:50Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b611-39f8-7a83-92a5-bc3e6990b55d | ASTS | 2026-09-18 15:49 | call_diagonal_spread | 2 | 1 | 110 | 250008.00 | unknown | bid | 58.6699 | 0.7700 | ["60","80"] | ["0.8220","0.8371"] | [] | ["EDGO"] | 60.0000 | 80.0000 | 63 | 490 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:49:46Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b610-6ed7-7411-951c-910886605764 | ASTS | 2026-09-18 15:48 | call_diagonal_spread | 2 | 1 | 100 | 227280.00 | unknown | bid | 58.5300 | 0.6400 | ["60","80"] | ["0.8257","0.8481"] | [] | ["EDGO"] | 60.0000 | 80.0000 | 63 | 490 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:48:59Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b610-5b4f-7ba1-8931-c10396a4c233 | ASTS | 2026-09-18 15:48 | call_diagonal_spread | 2 | 1 | 100 | 227280.00 | unknown | bid | 58.5500 | 0.6400 | ["60","80"] | ["0.8252","0.8475"] | [] | ["EDGO"] | 60.0000 | 80.0000 | 63 | 490 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:48:59Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b58a-fac7-7733-99bb-5ff2bad586ab | ASTS | 2026-09-18 13:22 | straddle | 2 | 1 | 36 | 105804.00 | short | bid | 58.2650 | 0.6000 | ["70"] | ["0.8027"] | ["40.61","99.39"] | ["ARCO"] | 70.0000 | 70.0000 | 182 | 182 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:23:25Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b573-3ca7-7d12-a69f-4e199758529f | ASTS | 2026-09-18 12:57 | straddle | 2 | 3 | 116 | 106720.00 | short | bid | 58.6700 | 0.2500 | ["60"] | ["0.7003"] | ["50.80","69.20"] | ["ARCO","EMLD","SPHR"] | 60.0000 | 60.0000 | 28 | 28 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:57:16Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b571-063f-7b51-acef-06b9d5588f97 | ASTS | 2026-09-18 12:54 | call_vertical_spread | 2 | 1 | 500 | 442500.00 | short | bid | 58.7350 | 1.0500 | ["54","56"] | ["0.6262","0.6175"] | ["55.55"] | ["BATO"] | 54.0000 | 56.0000 | 7 | 7 | true | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:54:39Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b511-3ad0-77b2-909a-c92d33880a7d | ASTS | 2026-09-18 11:09 | other | 4 | 1 | 10 | 122234.00 | unknown | bid | 58.6250 | 5.2500 | ["70","80","100","105"] | ["0.7446","0.7791","0.9284","0.9436"] | [] | ["C2OX"] | 70.0000 | 105.0000 | 28 | 35 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:10:19Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0aff3-2443-70f0-83b6-199c12ea4243 | ASTS | 2026-09-17 11:19 | put_calendar | 2 | 2 | 239 | 383834.00 | short | bid | 62.3900 | 0.3500 | ["65"] | ["0.7636"] | [] | ["AMXO","XPHO"] | 65.0000 | 65.0000 | 29 | 64 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:19:13Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a601-31b6-7fa2-9e69-47ec0cad2855 | ASTS | 2026-09-15 12:58 | put_diagonal_spread | 2 | 2 | 128 | 1501056.00 | long | bid | 60.2750 | 1.7500 | ["30","170"] | ["0.8545","1.0479"] | [] | ["XISX","XPHO"] | 30.0000 | 170.0000 | 458 | 549 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:58:51Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5b8-5176-7ce1-b2a3-e655d0e28242 | ASTS | 2026-09-15 11:38 | put_calendar | 2 | 1 | 1000 | 2827000.00 | long | bid | 57.9700 | 1.0000 | ["70"] | ["1.2553"] | [] | ["BATO"] | 70.0000 | 70.0000 | 3 | 66 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:38:35Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5b4-946e-7513-a6cc-a55cc7dc8bb6 | ASTS | 2026-09-15 11:34 | put_calendar | 2 | 1 | 20 | 108420.00 | long | bid | 57.9425 | 1.7000 | ["85"] | ["1.3404"] | [] | ["XMIO"] | 85.0000 | 85.0000 | 3 | 31 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:34:48Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a575-e1a5-7083-ba41-b14590351390 | ASTS | 2026-09-15 10:25 | put_calendar | 2 | 6 | 398 | 527182.00 | short | bid | 58.9400 | 0.6712 | ["65"] | ["0.8145"] | [] | ["ARCO","EMLD","MCRY","XBOX","XISX","XPHO"] | 65.0000 | 65.0000 | 3 | 10 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:26:29Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a575-8bb6-7561-8ebd-eaaa1a71ecce | ASTS | 2026-09-15 10:25 | put_calendar | 2 | 4 | 380 | 498486.00 | short | bid | 59.0500 | 0.8500 | ["65"] | ["0.8288"] | [] | ["ARCO","EMLD","SPHR","XBOX"] | 65.0000 | 65.0000 | 3 | 10 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:25:54Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a064-9ce1-7690-90d2-7c3242d8d788 | ASTS | 2026-09-14 10:49 | put_calendar | 2 | 1 | 49 | 112504.00 | short | bid | 59.5665 | 0.8000 | ["40"] | ["0.8583"] | [] | ["XISX"] | 40.0000 | 40.0000 | 550 | 858 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:49:02Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a090d8-20f8-7851-95b7-429a0a158ec5 | ASTS | 2026-09-11 10:21 | call_frontspread | 2 | 1 | 140 | 187495.00 | long | bid | 60.7900 | 1.0500 | ["165","190"] | ["0.8657","0.8675"] | ["267.51"] | ["BATO"] | 165.0000 | 190.0000 | 497 | 497 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:21:41Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c8c-4678-7541-bd23-82103edf3165 | ASTS | 2026-09-10 14:19 | call_vertical_spread | 2 | 1 | 55 | 289410.00 | short | bid | 61.5800 | 1.0000 | ["80","90"] | ["0.8729","0.8714"] | ["81.90"] | ["BATO"] | 80.0000 | 90.0000 | 827 | 827 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:20:09Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c04-a3d0-79f3-b668-84f3febb85d7 | ASTS | 2026-09-10 11:51 | call_vertical_spread | 2 | 1 | 36 | 106308.00 | short | bid | 62.4400 | 0.6000 | ["115","130"] | ["0.8657","0.8702"] | ["116.75"] | ["BATO"] | 115.0000 | 130.0000 | 554 | 554 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:52:19Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08692-0848-7120-aaf0-f647c474195d | ASTS | 2026-09-09 10:28 | put_calendar | 2 | 1 | 50 | 143800.00 | long | bid | 63.8400 | 0.8000 | ["70"] | ["0.8424"] | [] | ["XMIO"] | 70.0000 | 70.0000 | 72 | 128 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:28:50Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0867d-c4c8-76b3-9729-2a74e705129e | ASTS | 2026-09-09 10:06 | call_vertical_spread | 2 | 4 | 174 | 538500.00 | short | bid | 64.8300 | 1.4000 | ["110","120"] | ["0.8674","0.8693"] | ["111.40"] | ["ARCO","EMLD","SPHR","XBOX"] | 110.0000 | 120.0000 | 499 | 499 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:06:27Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08252-5af8-77c0-88cb-08b47d2325fe | ASTS | 2026-09-08 14:40 | call_diagonal_spread | 2 | 1 | 40 | 138800.00 | short | bid | 66.4550 | 0.3500 | ["65","100"] | ["0.8384","0.8592"] | [] | ["XISX"] | 65.0000 | 100.0000 | 192 | 465 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:41:05Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081ff-a718-7ba3-9ad5-c5468f783d66 | ASTS | 2026-09-08 13:10 | risk_reversal | 2 | 4 | 72 | 383160.00 | long | bid | 66.5150 | 1.1500 | ["65","105"] | ["0.8820","0.8593"] | ["63.75"] | ["XCBO","XISX","XMIO","XPHO"] | 65.0000 | 105.0000 | 829 | 829 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:10:42Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |