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 |
|---|
| 01a0ca66-9947-74f2-b368-a60178b48d24 | NET | 2026-09-22 14:35 | call_diagonal_spread | 2 | 1 | 13 | 211926.00 | long | ask | 354.5500 | 5.0500 | ["360","380"] | ["0.6394","0.6326"] | [] | ["XMIO"] | 360.0000 | 380.0000 | 268 | 360 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T18:35:25Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0ca5e-b9a6-7130-85b6-1beb743598f3 | NET | 2026-09-22 14:26 | call_diagonal_spread | 2 | 1 | 20 | 209580.00 | short | ask | 355.0400 | 5.7500 | ["350","430"] | ["0.6262","0.6331"] | [] | ["XMIO"] | 350.0000 | 430.0000 | 115 | 241 | false | false | true | ||||||||||
| 01a0c9d4-ec4f-7e21-afcf-8fab29abd6a9 | NET | 2026-09-22 11:56 | call_diagonal_spread | 2 | 1 | 10 | 151100.00 | short | ask | 349.8700 | 2.6500 | ["290","370"] | ["0.6595","0.6333"] | [] | ["XISX"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9d4-dcaf-7281-a408-fc3cbd5a27f4 | NET | 2026-09-22 11:56 | call_diagonal_spread | 2 | 1 | 14 | 210784.00 | short | ask | 349.8700 | 3.9500 | ["290","370"] | ["0.6541","0.6309"] | [] | ["BATO"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9d4-cd0e-78b0-95c4-bc3274b3def9 | NET | 2026-09-22 11:55 | call_diagonal_spread | 2 | 1 | 14 | 211043.00 | short | ask | 350.0300 | 3.7000 | ["290","370"] | ["0.6532","0.6310"] | [] | ["XPHO"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9d4-b987-7c51-b6b0-a0040cf074de | NET | 2026-09-22 11:55 | call_diagonal_spread | 2 | 1 | 14 | 210966.00 | short | ask | 350.2350 | 3.6500 | ["290","370"] | ["0.6495","0.6298"] | [] | ["XISX"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9d4-a9e6-7bc0-a155-ab7e58e4177c | NET | 2026-09-22 11:55 | call_diagonal_spread | 2 | 1 | 14 | 210868.00 | short | ask | 350.2350 | 3.6500 | ["290","370"] | ["0.6490","0.6293"] | [] | ["XMIO"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9d4-965f-7c01-911e-c76ab436de77 | NET | 2026-09-22 11:55 | call_diagonal_spread | 2 | 1 | 14 | 210882.00 | short | ask | 350.2300 | 3.6500 | ["290","370"] | ["0.6491","0.6295"] | [] | ["XMIO"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9d4-86bf-7e81-a078-2bb3278f6112 | NET | 2026-09-22 11:55 | call_diagonal_spread | 2 | 1 | 14 | 210924.00 | short | ask | 350.2300 | 3.6500 | ["290","370"] | ["0.6495","0.6295"] | [] | ["BATO"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9d4-7337-7463-9793-e31029e7ec7e | NET | 2026-09-22 11:55 | call_diagonal_spread | 2 | 1 | 14 | 210966.00 | short | ask | 350.2300 | 3.6500 | ["290","370"] | ["0.6496","0.6298"] | [] | ["XISX"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9d4-6397-7ef0-81e9-f31d41811bc5 | NET | 2026-09-22 11:55 | call_diagonal_spread | 2 | 1 | 14 | 210966.00 | short | ask | 350.2300 | 3.6500 | ["290","370"] | ["0.6495","0.6298"] | [] | ["XPHO"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9d4-53f7-7181-9d96-5b4e84806a9b | NET | 2026-09-22 11:55 | call_diagonal_spread | 2 | 1 | 14 | 210966.00 | short | ask | 350.2300 | 3.6500 | ["290","370"] | ["0.6495","0.6298"] | [] | ["XPHO"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9d4-4456-7ed1-a7d1-4b7a397f32f0 | NET | 2026-09-22 11:55 | call_diagonal_spread | 2 | 1 | 14 | 210868.00 | short | ask | 350.2300 | 3.6500 | ["290","370"] | ["0.6485","0.6296"] | [] | ["XMIO"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9d4-34b7-7df2-b5fa-8128365adf9d | NET | 2026-09-22 11:55 | call_diagonal_spread | 2 | 1 | 14 | 210966.00 | short | ask | 350.2300 | 3.6500 | ["290","370"] | ["0.6487","0.6301"] | [] | ["XISX"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9d4-2516-74c3-9e20-c02c82d358f8 | NET | 2026-09-22 11:55 | call_diagonal_spread | 2 | 1 | 14 | 210896.00 | short | ask | 350.2300 | 3.5500 | ["290","370"] | ["0.6493","0.6295"] | [] | ["BATO"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9d4-1577-74f0-83d1-a8fc40d4ec7f | NET | 2026-09-22 11:55 | call_diagonal_spread | 2 | 1 | 14 | 211960.00 | short | ask | 350.2300 | 2.6500 | ["290","370"] | ["0.6569","0.6327"] | [] | ["XISX"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9d4-01ef-7831-b3aa-bf846f7605b1 | NET | 2026-09-22 11:55 | call_diagonal_spread | 2 | 2 | 14 | 211960.00 | short | ask | 350.1950 | 5.2000 | ["290","370"] | ["0.6564","0.6333"] | [] | ["XMIO"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9d3-f24e-7fe0-9431-a466219eec98 | NET | 2026-09-22 11:55 | call_diagonal_spread | 2 | 1 | 14 | 212016.00 | short | ask | 350.1950 | 5.2000 | ["290","370"] | ["0.6566","0.6336"] | [] | ["XPHO"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9d3-4a57-7ae0-b2c9-1c3a2e0afb92 | NET | 2026-09-22 11:54 | call_diagonal_spread | 2 | 1 | 14 | 212548.00 | short | ask | 350.4150 | 6.1500 | ["290","370"] | ["0.6562","0.6344"] | [] | ["BATO"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9c2-3b27-7922-a9e5-cc69e777387d | NET | 2026-09-22 11:35 | call_diagonal_spread | 2 | 1 | 14 | 214508.00 | short | ask | 351.5050 | 2.8500 | ["290","370"] | ["0.6541","0.6345"] | [] | ["XMIO"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c9bf-ca27-7cc3-8f89-a501991609fc | NET | 2026-09-22 11:33 | call_diagonal_spread | 2 | 1 | 8 | 122272.00 | short | ask | 351.2700 | 3.8500 | ["290","370"] | ["0.6520","0.6349"] | [] | ["BATO"] | 290.0000 | 370.0000 | 87 | 268 | false | false | true | ||||||||||
| 01a0c57c-f056-7763-b2dd-8cc1f2b7cd72 | NET | 2026-09-21 15:41 | call_diagonal_spread | 2 | 2 | 12 | 123480.00 | long | ask | 350.1100 | 3.6000 | ["350","370"] | ["0.6249","0.6417"] | [] | ["EMLD","SPHR"] | 350.0000 | 370.0000 | 116 | 151 | false | false | true | ||||||||||
| 01a0c4bf-60ff-7e41-a73f-fe492111cc36 | NET | 2026-09-21 12:14 | call_diagonal_spread | 2 | 1 | 50 | 589300.00 | long | ask | 346.2400 | 5.3500 | ["370","490"] | ["0.6349","0.6140"] | [] | ["XCBO"] | 370.0000 | 490.0000 | 179 | 487 | false | true | true | ||||||||||
| 01a0c49b-bfe7-7480-a268-09407b60a95a | NET | 2026-09-21 11:35 | call_diagonal_spread | 2 | 1 | 50 | 951700.00 | long | ask | 345.4750 | 6.6500 | ["380","480"] | ["0.6216","0.6102"] | [] | ["XCBO"] | 380.0000 | 480.0000 | 487 | 816 | false | true | true | ||||||||||
| 01a0c47d-3b67-7440-8b91-a63e9d0f9a79 | NET | 2026-09-21 11:02 | call_diagonal_spread | 2 | 1 | 79 | 189442.00 | long | ask | 344.0800 | 3.6500 | ["340","350"] | ["0.6758","0.6105"] | [] | ["EDGO"] | 340.0000 | 350.0000 | 4 | 11 | false | false | true | ||||||||||
| 01a0c452-dbbf-7a22-af59-b2d9daf860c4 | NET | 2026-09-21 10:15 | call_diagonal_spread | 2 | 2 | 112 | 112728.00 | unknown | ask | 338.3700 | 1.0634 | ["350","400"] | ["0.6194","0.6655"] | [] | ["EDGO"] | 350.0000 | 400.0000 | 11 | 25 | false | true | true | ||||||||||
| 01a0c452-bc7f-73c1-a728-cb863aeefcd3 | NET | 2026-09-21 10:15 | call_diagonal_spread | 2 | 2 | 180 | 181979.00 | unknown | ask | 339.0000 | 1.2300 | ["350","400"] | ["0.6121","0.6629"] | [] | ["AMXO","ARCO"] | 350.0000 | 400.0000 | 11 | 25 | false | true | true | ||||||||||
| 01a0c452-bc7f-73c1-a728-cb71ff116f54 | NET | 2026-09-21 10:15 | call_diagonal_spread | 2 | 2 | 192 | 197376.00 | unknown | ask | 339.0000 | 1.2300 | ["350","400"] | ["0.6169","0.6720"] | [] | ["C2OX","XPHO"] | 350.0000 | 400.0000 | 11 | 25 | false | true | true | ||||||||||
| 01a0b599-6247-7712-b9c2-2906e49cf28b | NET | 2026-09-18 13:38 | call_diagonal_spread | 2 | 1 | 10 | 143897.00 | short | ask | 320.3600 | 6.2500 | ["240","270"] | ["11.2557","0.6376"] | [] | ["EDGO"] | 240.0000 | 270.0000 | 0 | 63 | false | false | true | ||||||||||
| 01a0b581-e68f-7892-b4bb-11db2de0141d | NET | 2026-09-18 13:13 | call_diagonal_spread | 2 | 1 | 15 | 239835.00 | short | ask | 318.9400 | 6.0500 | ["300","330"] | ["0.6294","0.6256"] | [] | ["XCBO"] | 300.0000 | 330.0000 | 272 | 364 | false | false | true | ||||||||||
| 01a0b4b7-8dc7-7060-93f3-d221cd45e944 | NET | 2026-09-18 09:32 | call_diagonal_spread | 2 | 3 | 16 | 357152.00 | unknown | ask | 332.1550 | 8.7375 | ["230","240"] | ["0.7042","0.6812"] | [] | ["C2OX","XBOX","XMIO"] | 230.0000 | 240.0000 | 91 | 154 | false | false | true | ||||||||||
| 01a0aa7c-c3e3-7620-8a95-547a5404ba0a | NET | 2026-09-16 09:51 | call_diagonal_spread | 2 | 1 | 9 | 201654.00 | long | ask | 331.9100 | 6.3500 | ["350","380"] | ["0.6217","0.6159"] | [] | ["XISX"] | 350.0000 | 380.0000 | 639 | 821 | false | true | true | ||||||||||
| 01a0a0ba-dee8-7312-a465-049f8e458d03 | NET | 2026-09-14 12:23 | call_diagonal_spread | 2 | 1 | 79 | 137302.00 | long | ask | 328.1500 | 1.8500 | ["330","340"] | ["0.6727","0.6038"] | [] | ["EDGO"] | 330.0000 | 340.0000 | 4 | 11 | false | true | true | ||||||||||
| 01a0a09f-b1e0-7062-abd4-57526d499fca | NET | 2026-09-14 11:53 | call_diagonal_spread | 2 | 1 | 19 | 244834.00 | short | ask | 327.0450 | 5.0000 | ["260","360"] | ["1.3650","0.6221"] | [] | ["XCBO"] | 260.0000 | 360.0000 | 4 | 276 | false | false | true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:26:42Z"} |
| 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:56:54Z"} |
| 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:56:54Z"} |
| 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:56:54Z"} |
| 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:56Z"} |
| 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:56Z"} |
| 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:56Z"} |
| 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:56Z"} |
| 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:56Z"} |
| 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:56Z"} |
| 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:56Z"} |
| 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:56Z"} |
| 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:56Z"} |
| 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:56Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:55:56Z"} |
| 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: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:36:06Z"} |
| 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:33:03Z"} |
| 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-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-21T16:14:44Z"} |
| 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-21T15:35:55Z"} |
| 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-21T15:02:15Z"} |
| 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-21T14:16:09Z"} |
| 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-21T14:15:51Z"} |
| 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-21T14:15:51Z"} |
| 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-18T17:38:44Z"} |
| 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-18T17:13:28Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:32:03Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:51:53Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:23:23Z"} |
| 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-14T15:53:57Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |