core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg403,968 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | direction |
|---|
| 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 |
|---|
| 01a0cab1-a04f-72c0-a277-5f87f3ce60ea | NET | 2026-09-22 15:57 | call_diagonal_spread | 2 | 4 | 21 | 242697.00 | short | bid | 353.3800 | 6.1500 | ["360","370"] | ["0.6399","0.6339"] | [] | ["EMLD","SPHR","XMIO"] | 360.0000 | 370.0000 | 150 | 178 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T19:57:26Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0cab1-a04f-72c0-a277-5f70d2895c57 | NET | 2026-09-22 15:57 | call_diagonal_spread | 2 | 3 | 10 | 115574.00 | short | bid | 353.3800 | 6.1500 | ["360","370"] | ["0.6400","0.6339"] | [] | ["ARCO","EMLD","SPHR"] | 360.0000 | 370.0000 | 150 | 178 | false | true | true | ||||||||||
| 01a0c9d3-dec7-7473-bce5-09e40ce88725 | NET | 2026-09-22 11:54 | call_diagonal_spread | 2 | 1 | 10 | 152140.00 | long | bid | 350.2500 | 5.5000 | ["290","370"] | ["0.6629","0.6362"] | [] | ["XMIO"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9d3-cf27-75b2-a6b5-1872c205797e | NET | 2026-09-22 11:54 | call_diagonal_spread | 2 | 1 | 14 | 212996.00 | long | bid | 350.4150 | 5.5000 | ["290","370"] | ["0.6603","0.6354"] | [] | ["XCBO"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9d3-bf87-7993-813b-acade3d43d7c | NET | 2026-09-22 11:54 | call_diagonal_spread | 2 | 1 | 14 | 212940.00 | long | bid | 350.4150 | 5.5000 | ["290","370"] | ["0.6599","0.6352"] | [] | ["XISX"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9d3-3ab7-7ed2-93bd-cfb355a00394 | NET | 2026-09-22 11:54 | call_diagonal_spread | 2 | 1 | 7 | 106512.00 | long | bid | 350.4150 | 5.4500 | ["290","370"] | ["0.6605","0.6355"] | [] | ["XMIO"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9d2-f07f-7d91-abd8-3140c6cffd7a | NET | 2026-09-22 11:53 | call_diagonal_spread | 2 | 1 | 13 | 197678.00 | long | bid | 350.4400 | 5.5000 | ["290","370"] | ["0.6586","0.6352"] | [] | ["XISX"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9d2-92bf-7f91-af8b-22909db8526d | NET | 2026-09-22 11:53 | call_diagonal_spread | 2 | 1 | 7 | 106435.00 | long | bid | 350.3400 | 5.5000 | ["290","370"] | ["0.6605","0.6354"] | [] | ["XISX"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9d1-cb86-72f3-b8df-16531888a76e | NET | 2026-09-22 11:52 | call_diagonal_spread | 2 | 1 | 14 | 212940.00 | long | bid | 350.3400 | 5.5500 | ["290","370"] | ["0.6601","0.6360"] | [] | ["XCBO"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9d1-bbe7-7eb2-9084-9dc85faefe10 | NET | 2026-09-22 11:52 | call_diagonal_spread | 2 | 1 | 8 | 121696.00 | long | bid | 350.3400 | 5.5500 | ["290","370"] | ["0.6613","0.6357"] | [] | ["XMIO"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9d1-620f-7303-a4ae-2e1fc53e9a88 | NET | 2026-09-22 11:52 | call_diagonal_spread | 2 | 1 | 14 | 212898.00 | long | bid | 350.4200 | 5.6000 | ["290","370"] | ["0.6589","0.6354"] | [] | ["XCBO"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9cf-cbcf-7de2-8046-338a02cc16a5 | NET | 2026-09-22 11:50 | call_diagonal_spread | 2 | 1 | 8 | 122496.00 | long | bid | 351.0350 | 4.6500 | ["290","370"] | ["0.6614","0.6360"] | [] | ["XMIO"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9cf-7daf-7001-b5c9-855a838a3fca | NET | 2026-09-22 11:50 | call_diagonal_spread | 2 | 1 | 13 | 199290.00 | long | bid | 351.2600 | 4.3000 | ["290","370"] | ["0.6597","0.6356"] | [] | ["XMIO"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9cc-6c87-7c50-afbd-d56a45b70c80 | NET | 2026-09-22 11:46 | call_diagonal_spread | 2 | 1 | 14 | 213612.00 | long | bid | 351.2500 | 4.2000 | ["290","370"] | ["0.6525","0.6327"] | [] | ["XCBO"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9ca-f96f-7800-ac0f-59a6e8ab2c68 | NET | 2026-09-22 11:45 | call_diagonal_spread | 2 | 1 | 12 | 182880.00 | long | bid | 351.3700 | 3.1000 | ["290","370"] | ["0.6480","0.6316"] | [] | ["XISX"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9ca-3237-7f82-aba7-166feeedaab4 | NET | 2026-09-22 11:44 | call_diagonal_spread | 2 | 1 | 11 | 168300.00 | long | bid | 351.5000 | 3.4000 | ["290","370"] | ["0.6519","0.6336"] | [] | ["XMIO"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9c8-51bf-7ac2-8695-7576d9b6b367 | NET | 2026-09-22 11:42 | call_diagonal_spread | 2 | 1 | 14 | 214200.00 | long | bid | 351.4900 | 3.4000 | ["290","370"] | ["0.6511","0.6340"] | [] | ["XMIO"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9c4-2f27-7a50-ac80-bbfb1c828716 | NET | 2026-09-22 11:37 | call_diagonal_spread | 2 | 1 | 14 | 214200.00 | long | bid | 351.2300 | 2.2500 | ["290","370"] | ["0.6552","0.6354"] | [] | ["XCBO"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9c3-ecbf-7ee2-ba41-8a03ef561415 | NET | 2026-09-22 11:37 | call_diagonal_spread | 2 | 1 | 14 | 214228.00 | long | bid | 351.2300 | 2.2500 | ["290","370"] | ["0.6564","0.6350"] | [] | ["XMIO"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9c3-b9f6-7a91-b5de-9e999bd43426 | NET | 2026-09-22 11:37 | call_diagonal_spread | 2 | 1 | 14 | 213556.00 | unknown | bid | 351.3800 | 2.6000 | ["290","370"] | ["0.6492","0.6322"] | [] | ["BATO"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9c1-d1af-7123-8e24-69a6ca4508ac | NET | 2026-09-22 11:35 | call_diagonal_spread | 2 | 1 | 14 | 214452.00 | long | bid | 351.5050 | 2.9500 | ["290","370"] | ["0.6517","0.6352"] | [] | ["XMIO"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9c0-df7e-7e42-a0d5-9ce9168ad2cb | NET | 2026-09-22 11:34 | call_diagonal_spread | 2 | 1 | 14 | 214284.00 | long | bid | 351.2600 | 2.9500 | ["290","370"] | ["0.6543","0.6359"] | [] | ["XISX"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c957-406f-7a72-9fc0-40ed954ddefe | NET | 2026-09-22 09:38 | call_diagonal_spread | 2 | 2 | 12 | 130854.00 | unknown | bid | 351.0550 | 5.5000 | ["370","400"] | ["0.6360","0.6295"] | [] | ["XISX"] | 370.0000 | 400.0000 | 150 | 241 | false | true | true | ||||||||||
| 01a0c58c-2ac7-7433-94ed-37bdfc418c3a | NET | 2026-09-21 15:58 | call_diagonal_spread | 2 | 1 | 60 | 756300.00 | short | bid | 351.8200 | 6.7500 | ["450","490"] | ["0.6224","0.6112"] | [] | ["XCBO"] | 450.0000 | 490.0000 | 361 | 487 | false | true | true | ||||||||||
| 01a0c57c-f056-7763-b2dd-8cf94600b90b | NET | 2026-09-21 15:41 | call_diagonal_spread | 2 | 2 | 11 | 113181.00 | unknown | bid | 350.1100 | 2.7045 | ["350","370"] | ["0.6245","0.6419"] | [] | ["XPHO"] | 350.0000 | 370.0000 | 116 | 151 | false | false | true | ||||||||||
| 01a0c472-7d67-7493-b14a-0a28fd87d950 | NET | 2026-09-21 10:50 | call_diagonal_spread | 2 | 1 | 50 | 717150.00 | short | bid | 341.8600 | 6.0500 | ["370","490"] | ["0.6422","0.6057"] | [] | ["XMIO"] | 370.0000 | 490.0000 | 269 | 634 | false | true | true | ||||||||||
| 01a0b57d-faa7-7d73-b8c2-563890e909c4 | NET | 2026-09-18 13:08 | call_diagonal_spread | 2 | 1 | 6 | 211824.00 | short | bid | 319.2400 | 8.2000 | ["145","170"] | ["0.7943","0.6698"] | [] | ["XPHO"] | 145.0000 | 170.0000 | 91 | 490 | false | false | true | ||||||||||
| 01a0b4e8-5ddf-7710-9af7-19e40183fbdc | NET | 2026-09-18 10:25 | call_diagonal_spread | 2 | 1 | 10 | 193940.00 | unknown | bid | 315.3000 | 5.8000 | ["220","310"] | ["6.5022","0.6260"] | [] | ["XCBO"] | 220.0000 | 310.0000 | 0 | 490 | false | false | true | ||||||||||
| 01a0affd-4dd3-7e10-b0f9-3429e81af875 | NET | 2026-09-17 11:30 | call_diagonal_spread | 2 | 1 | 4 | 122632.00 | short | bid | 332.3750 | 6.8000 | ["230","270"] | ["0.6560","0.6343"] | [] | ["XCBO"] | 230.0000 | 270.0000 | 491 | 820 | false | false | true | ||||||||||
| 01a0aa9f-6ee3-7e10-a001-e3106d242618 | NET | 2026-09-16 10:29 | call_diagonal_spread | 2 | 2 | 38 | 106476.00 | short | bid | 330.8750 | 3.0500 | ["330","335"] | ["0.6118","0.5933"] | [] | ["XCBO","XPHO"] | 330.0000 | 335.0000 | 9 | 16 | false | false | true | ||||||||||
| 01a0a12d-bd28-7a63-825c-d7bd8f1cac8f | NET | 2026-09-14 14:28 | call_diagonal_spread | 2 | 1 | 9 | 140328.00 | long | bid | 333.1175 | 5.7000 | ["300","330"] | ["0.6335","0.6333"] | [] | ["XCBO"] | 300.0000 | 330.0000 | 186 | 276 | false | false | true | ||||||||||
| 01a0a047-6850-7c52-ab37-5069b0a971a2 | NET | 2026-09-14 10:17 | call_diagonal_spread | 2 | 1 | 200 | 222000.00 | long | bid | 325.7000 | 2.5000 | ["330","355"] | ["0.6620","0.5901"] | [] | ["XMIO"] | 330.0000 | 355.0000 | 4 | 11 | false | true | true | ||||||||||
| 01a08c6f-e0f0-7033-b3e0-488c49c1a67b | NET | 2026-09-10 13:48 | call_diagonal_spread | 2 | 1 | 8 | 220920.00 | long | bid | 312.9700 | 6.6500 | ["220","280"] | ["0.6533","0.6310"] | [] | ["XCBO"] | 220.0000 | 280.0000 | 498 | 827 | false | false | true | ||||||||||
| 01a0876c-a520-70d2-aa54-122333e33fa6 | NET | 2026-09-09 14:27 | call_diagonal_spread | 2 | 1 | 23 | 101039.00 | short | bid | 317.0300 | 2.6000 | ["410","420"] | ["0.6163","0.6302"] | [] | ["XISX"] | 410.0000 | 420.0000 | 128 | 163 | false | true | true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:57:26Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:55:12Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:55:12Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:55:12Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:54:28Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:54:28Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:53:35Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:52:45Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:52:45Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:52:45Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:51:05Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:50:21Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:47:30Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:46:02Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:44:30Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:43:04Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:38:09Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:38:09Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:37:31Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:35:34Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:34:17Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:39:09Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:58:18Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:41:33Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:50:39Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:09:28Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:25:22Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:30:18Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:30:02Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T18:29:13Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:17:30Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:49:10Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T18:27:54Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |