PREVIEW / stock_daily / 2025-07-28
file: by_date/stock_daily/2025/2025-07-28.parquet size: 247 KB rows: 7,167 symbols: 304
schema
date DATE symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| date | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2025-07-28 | AAPL | Stock | 214.03 | 214.845 | 213.06 | 214.05 | 37785330.0 |
| 2025-07-28 | MSFT | Stock | 514.08 | 515.0 | 510.12 | 512.5 | 14297742.0 |
| 2025-07-28 | NVDA | Stock | 174.02 | 177.0 | 173.97 | 176.75 | 139701637.0 |
| 2025-07-28 | AMZN | Stock | 233.35 | 234.29 | 232.25 | 232.79 | 27254543.0 |
| 2025-07-28 | GOOGL | Stock | 193.65 | 194.05 | 190.84 | 192.58 | 38139504.0 |
| 2025-07-28 | META | Stock | 715.2 | 724.7352 | 712.68 | 717.63 | 8691097.0 |
| 2025-07-28 | TSLA | Stock | 318.45 | 330.49 | 315.69 | 325.59 | 112512484.0 |
| 2025-07-28 | TLT | Stock | 85.99 | 86.2 | 85.83 | 85.87 | 26812463.0 |
| 2025-07-28 | ES | Stock | 66.48 | 66.57 | 64.98 | 65.18 | 1708785.0 |
| 2025-07-28 | CL | Stock | 87.8 | 87.88 | 86.37 | 86.47 | 4823145.0 |
| 2025-07-28 | A | Stock | 119.41 | 120.77 | 118.72 | 119.54 | 1679052.0 |
| 2025-07-28 | AA | Stock | 30.8 | 31.32 | 30.17 | 30.68 | 5904686.0 |
| 2025-07-28 | AACBR | Stock | 0.2396 | 0.24 | 0.2396 | 0.2399 | 10864.0 |
| 2025-07-28 | AACBU | Stock | 10.3 | 10.33 | 10.3 | 10.33 | 902.0 |
| 2025-07-28 | AACG | Stock | 1.04 | 1.1504 | 1.02 | 1.13 | 143526.0 |
| 2025-07-28 | AACI | Stock | 10.07 | 10.075 | 10.06 | 10.075 | 37100.0 |
| 2025-07-28 | AACIU | Stock | 10.14 | 10.14 | 10.14 | 10.14 | 831.0 |
| 2025-07-28 | AACIW | Stock | 0.274 | 0.2838 | 0.21 | 0.26 | 1728.0 |
| 2025-07-28 | AACT | Stock | 11.43 | 11.44 | 11.41 | 11.41 | 142359.0 |
| 2025-07-28 | AAGR-DELISTED | Stock | 0.01 | 0.01 | 0.01 | 0.01 | 100.0 |
| 2025-07-28 | AAL | Stock | 11.5 | 11.63 | 11.4 | 11.58 | 70053202.0 |
| 2025-07-28 | AAM | Stock | 10.442 | 10.442 | 10.442 | 10.442 | 559.0 |
| 2025-07-28 | AAME | Stock | 2.27 | 2.3068 | 2.17 | 2.18 | 5337.0 |
| 2025-07-28 | AAMI | Stock | 39.75 | 40.25 | 39.65 | 39.86 | 191434.0 |
| 2025-07-28 | AAOI | Stock | 27.51 | 27.59 | 24.76 | 25.22 | 5486251.0 |
| 2025-07-28 | AAON | Stock | 84.0 | 84.3 | 82.21 | 83.08 | 1151069.0 |
| 2025-07-28 | AAP | Stock | 58.13 | 58.8055 | 56.47 | 57.5 | 1935407.0 |
| 2025-07-28 | AAPG | Stock | 39.79 | 39.8 | 38.7027 | 39.27 | 9883.0 |
| 2025-07-28 | AARD | Stock | 14.72 | 15.01 | 13.32 | 13.58 | 34585.0 |
| 2025-07-28 | AAT | Stock | 20.3 | 20.378 | 19.93 | 19.93 | 240027.0 |
| 2025-07-28 | AATC | Stock | 7.41 | 7.618 | 7.41 | 7.42 | 530.0 |
| 2025-07-28 | AAUC | Stock | 13.29 | 13.3 | 12.94 | 12.99 | 86627.0 |
| 2025-07-28 | AAXJ | Stock | 85.17 | 85.31 | 84.915 | 85.02 | 314962.0 |
| 2025-07-28 | AB | Stock | 42.95 | 42.965 | 42.25 | 42.39 | 189430.0 |
| 2025-07-28 | ABAT | Stock | 3.03 | 3.13 | 2.76 | 2.88 | 8076006.0 |
| 2025-07-28 | ABBV | Stock | 191.21 | 191.21 | 187.64 | 188.52 | 3775983.0 |
| 2025-07-28 | ABCB | Stock | 66.1 | 66.9 | 65.95 | 66.4 | 700021.0 |
| 2025-07-28 | ABCL | Stock | 5.15 | 5.1868 | 4.8912 | 4.92 | 4113265.0 |
| 2025-07-28 | ABEO | Stock | 6.56 | 6.68 | 6.45 | 6.62 | 586484.0 |
| 2025-07-28 | ABEV | Stock | 2.35 | 2.36 | 2.29 | 2.3 | 28623049.0 |
| 2025-07-28 | ABG | Stock | 237.47 | 238.0 | 226.15 | 229.2 | 479947.0 |
| 2025-07-28 | ABI | Stock | 25.095 | 25.095 | 25.095 | 25.095 | 5.0 |
| 2025-07-28 | ABLLW | Stock | 1.16 | 1.18 | 1.16 | 1.18 | 9978.0 |
| 2025-07-28 | ABLV | Stock | 1.115 | 1.12 | 1.0633 | 1.065 | 4542.0 |
| 2025-07-28 | ABM | Stock | 47.35 | 47.66 | 47.07 | 47.11 | 365122.0 |
| 2025-07-28 | ABNB | Stock | 141.3 | 143.3 | 141.0201 | 142.16 | 2808005.0 |
| 2025-07-28 | ABOS | Stock | 1.6 | 1.6195 | 1.44 | 1.46 | 268164.0 |
| 2025-07-28 | ABPWW | Stock | 0.0589 | 0.0737 | 0.0511 | 0.0512 | 426930.0 |
| 2025-07-28 | ABR | Stock | 12.08 | 12.08 | 11.77 | 11.78 | 1985295.0 |
| 2025-07-28 | ABR.D | Stock | 17.83 | 17.9 | 17.681 | 17.7552 | 23473.0 |
> showing 50 of 7,167 rows — these rows as CSV