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 | 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 |
|---|
| 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 | 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 |
| 01a0ca50-6996-7ae2-8aea-71e44b74b541 | NET | 2026-09-22 14:11 | call_vertical_spread | 2 | 1 | 5 | 192330.00 | long | ask | 355.0550 | 5.5000 | ["160","165"] | ["4.5973","4.5054"] | ["164.98"] | ["XCBO"] | 160.0000 | 165.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0ca2d-31f6-71a0-a63c-85319b8e936d | NET | 2026-09-22 13:32 | call_vertical_spread | 2 | 1 | 7 | 227843.00 | long | ask | 355.4300 | 6.2000 | ["190","195"] | ["3.8021","3.7668"] | ["194.99"] | ["XMIO"] | 190.0000 | 195.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0ca13-aacf-76a3-a4da-9d5a473805bb | NET | 2026-09-22 13:04 | call_vertical_spread | 2 | 1 | 3 | 117714.00 | long | ask | 354.0200 | 6.0500 | ["155","160"] | ["4.7776","4.6803"] | ["159.98"] | ["XCBO"] | 155.0000 | 160.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0c9df-739f-7f70-9927-b2821f5d99a4 | NET | 2026-09-22 12:07 | call_vertical_spread | 2 | 1 | 3 | 118683.00 | long | ask | 349.8351 | 6.8000 | ["150","155"] | ["4.2355","4.0952"] | ["154.99"] | ["XCBO"] | 150.0000 | 155.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0c9da-3baf-7790-beae-ebfa5d91cc11 | NET | 2026-09-22 12:01 | call_vertical_spread | 2 | 1 | 5 | 109515.00 | long | ask | 350.9600 | 4.7500 | ["250","260"] | ["0.6427","0.6378"] | ["257.83"] | ["AMXO"] | 250.0000 | 260.0000 | 115 | 115 | false | false | false | true | |||||||||
| 01a0c57f-3e2f-76d3-9ce3-217ed54d22b2 | NET | 2026-09-21 15:44 | call_vertical_spread | 2 | 1 | 4 | 142012.00 | long | ask | 349.7500 | 6.1500 | ["170","175"] | ["2.8522","2.7600"] | ["174.99"] | ["XCBO"] | 170.0000 | 175.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0c57a-f09f-7f32-9325-e8a7a9d9146d | NET | 2026-09-21 15:39 | call_vertical_spread | 2 | 1 | 4 | 118092.00 | long | ask | 350.3200 | 5.2500 | ["200","205"] | ["2.9180","2.7800"] | ["204.99"] | ["XCBO"] | 200.0000 | 205.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0c56c-814f-7cf3-a123-def4a872de90 | NET | 2026-09-21 15:23 | call_vertical_spread | 2 | 1 | 4 | 101184.00 | long | ask | 348.7150 | 3.9000 | ["220","225"] | ["1.8577","1.7995"] | ["224.98"] | ["XCBO"] | 220.0000 | 225.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0c54c-4366-78d2-a144-da0ce209da8c | NET | 2026-09-21 14:48 | call_vertical_spread | 2 | 1 | 6 | 186576.00 | long | ask | 348.3700 | 6.1000 | ["190","195"] | ["3.1048","3.0369"] | ["194.98"] | ["XCBO"] | 190.0000 | 195.0000 | 4 | 4 | false | 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 | 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 | 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 | 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 | 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 | true | |||||||||
| 01a0af8f-9fbb-7a03-bc86-5d7261c00bfa | NET | 2026-09-17 09:30 | call_vertical_spread | 2 | 1 | 10 | 153090.00 | long | ask | 320.0200 | 7.6500 | ["250","260"] | ["0.6950","0.6853"] | ["257.75"] | ["XCBO"] | 250.0000 | 260.0000 | 64 | 64 | false | false | false | true | |||||||||
| 01a0aa94-e3ab-7fb3-a59c-8cc6e00abc36 | NET | 2026-09-16 10:17 | call_vertical_spread | 2 | 1 | 4 | 200416.00 | long | ask | 332.9000 | 6.4500 | ["80","85"] | ["7.1680","7.0056"] | ["84.98"] | ["XCBO"] | 80.0000 | 85.0000 | 2 | 2 | false | false | false | true | |||||||||
| 01a0aa82-c30b-77c2-a20e-51092e214b49 | NET | 2026-09-16 09:58 | call_vertical_spread | 2 | 1 | 3 | 146820.00 | long | ask | 332.9500 | 6.6000 | ["85","90"] | ["9.0609","8.8511"] | ["89.98"] | ["XCBO"] | 85.0000 | 90.0000 | 2 | 2 | false | false | false | true | |||||||||
| 01a0a605-9e86-7323-af08-192e95e19f89 | NET | 2026-09-15 13:02 | call_vertical_spread | 2 | 1 | 4 | 197344.00 | long | ask | 333.8100 | 5.1000 | ["85","90"] | ["6.5090","6.2898"] | ["89.98"] | ["XCBO"] | 85.0000 | 90.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0a5f0-1ab6-76d0-a3cc-096d5689ad4c | NET | 2026-09-15 12:39 | call_vertical_spread | 2 | 1 | 3 | 120138.00 | long | ask | 332.6800 | 5.5000 | ["130","135"] | ["5.6285","3.2096"] | ["134.98"] | ["XCBO"] | 130.0000 | 135.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0a5d7-b0b6-7730-82bc-d2dc3f2f6cde | NET | 2026-09-15 12:12 | call_vertical_spread | 2 | 1 | 3 | 128154.00 | long | ask | 330.8400 | 5.9500 | ["115","120"] | ["4.7871","4.6529"] | ["119.98"] | ["XCBO"] | 115.0000 | 120.0000 | 3 | 3 | false | false | false | 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 | 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 | true | |||||||||
| 01a0a06b-f7b0-7d61-959a-4d576755e64b | NET | 2026-09-14 10:57 | call_vertical_spread | 2 | 1 | 90 | 391770.00 | long | ask | 326.0950 | 4.4500 | ["320","325"] | ["0.5751","0.5750"] | ["322.53"] | ["XCBO"] | 320.0000 | 325.0000 | 25 | 25 | false | false | false | true | |||||||||
| 01a0a044-0520-77b2-8cde-fbd3a16ffd7d | NET | 2026-09-14 10:13 | call_vertical_spread | 2 | 1 | 4 | 192576.00 | long | ask | 323.7050 | 6.8500 | ["80","85"] | ["6.4284","7.0913"] | ["84.98"] | ["XCBO"] | 80.0000 | 85.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a08733-d240-7f70-af68-9c3c7bea5456 | NET | 2026-09-09 13:25 | call_vertical_spread | 2 | 1 | 4 | 140424.00 | long | ask | 313.2250 | 4.7000 | ["135","140"] | ["5.8893","5.7584"] | ["139.98"] | ["XCBO"] | 135.0000 | 140.0000 | 2 | 2 | false | false | false | true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:11:06Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:32:45Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:04:50Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:07:58Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:02:03Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:44:08Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:39:33Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:23:56Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:48:33Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:30:12Z"} |
| 2026-09-17 |
| 2026-09-17 17:27 |
| 2026-09-17 17:27 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:18:33Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:58:16Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:03:47Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:39:48Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:13:16Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| 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 |
| 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 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:57:33Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:13:31Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:26:01Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |