PREVIEW / stock_daily / 2025-07-31
file: by_date/stock_daily/2025/2025-07-31.parquet size: 247 KB rows: 7,158 symbols: 301
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-31 | AAPL | Stock | 208.49 | 209.84 | 207.16 | 207.57 | 77380994.0 |
| 2025-07-31 | MSFT | Stock | 555.225 | 555.45 | 531.9 | 533.5 | 51542889.0 |
| 2025-07-31 | NVDA | Stock | 182.9 | 183.3 | 175.93 | 177.87 | 220857949.0 |
| 2025-07-31 | AMZN | Stock | 235.77 | 236.53 | 231.4 | 234.11 | 100510232.0 |
| 2025-07-31 | GOOGL | Stock | 195.71 | 195.99 | 191.09 | 191.9 | 51329163.0 |
| 2025-07-31 | META | Stock | 775.2 | 784.75 | 765.51 | 773.44 | 38750204.0 |
| 2025-07-31 | TSLA | Stock | 319.605 | 321.37 | 306.1 | 308.27 | 85066712.0 |
| 2025-07-31 | TLT | Stock | 87.13 | 87.41 | 86.84 | 86.92 | 49814080.0 |
| 2025-07-31 | ES | Stock | 65.51 | 66.3 | 65.51 | 66.1 | 4534206.0 |
| 2025-07-31 | CL | Stock | 85.53 | 85.645 | 83.53 | 83.85 | 9557337.0 |
| 2025-07-31 | A | Stock | 116.57 | 118.34 | 114.47 | 114.81 | 2339448.0 |
| 2025-07-31 | AA | Stock | 29.87 | 30.685 | 29.66 | 29.97 | 4797246.0 |
| 2025-07-31 | AACG | Stock | 1.75 | 2.3 | 1.74 | 2.22 | 942914.0 |
| 2025-07-31 | AACI | Stock | 10.07 | 10.07 | 10.07 | 10.07 | 5354.0 |
| 2025-07-31 | AACIW | Stock | 0.26 | 0.26 | 0.26 | 0.26 | 209.0 |
| 2025-07-31 | AACT | Stock | 11.4 | 11.4372 | 11.4 | 11.4 | 193731.0 |
| 2025-07-31 | AAGR-DELISTED | Stock | 0.01 | 0.01 | 0.01 | 0.01 | 100.0 |
| 2025-07-31 | AAGRW | Stock | 0.0 | 0.0 | 0.0 | 0.0 | 300.0 |
| 2025-07-31 | AAL | Stock | 11.47 | 11.64 | 11.36 | 11.49 | 84668792.0 |
| 2025-07-31 | AAM | Stock | 10.451 | 10.455 | 10.45 | 10.455 | 25945.0 |
| 2025-07-31 | AAME | Stock | 2.29 | 2.3 | 2.23 | 2.285 | 6500.0 |
| 2025-07-31 | AAMI | Stock | 40.0 | 42.63 | 39.2 | 41.79 | 540114.0 |
| 2025-07-31 | AAOI | Stock | 23.78 | 24.53 | 22.86 | 22.87 | 5351358.0 |
| 2025-07-31 | AAON | Stock | 81.54 | 84.0 | 80.8567 | 83.5 | 1718302.0 |
| 2025-07-31 | AAP | Stock | 55.46 | 55.85 | 52.91 | 53.07 | 1934302.0 |
| 2025-07-31 | AAPG | Stock | 37.0 | 37.0 | 36.75 | 37.0 | 2893.0 |
| 2025-07-31 | AARD | Stock | 12.62 | 12.88 | 12.01 | 12.01 | 31497.0 |
| 2025-07-31 | AAT | Stock | 18.8 | 19.055 | 18.64 | 19.03 | 699700.0 |
| 2025-07-31 | AATC | Stock | 7.42 | 7.69 | 7.42 | 7.555 | 1981.0 |
| 2025-07-31 | AAUC | Stock | 12.68 | 12.92 | 12.665 | 12.89 | 18145.0 |
| 2025-07-31 | AAXJ | Stock | 84.2 | 84.2 | 83.57 | 83.71 | 2430642.0 |
| 2025-07-31 | AB | Stock | 41.35 | 41.9434 | 40.69 | 40.79 | 208882.0 |
| 2025-07-31 | ABAT | Stock | 2.2 | 2.32 | 2.16 | 2.17 | 3506626.0 |
| 2025-07-31 | ABBV | Stock | 197.06 | 198.8256 | 187.62 | 189.02 | 10341965.0 |
| 2025-07-31 | ABCB | Stock | 68.03 | 68.94 | 67.495 | 68.35 | 794042.0 |
| 2025-07-31 | ABCL | Stock | 4.54 | 4.6398 | 4.42 | 4.47 | 4699435.0 |
| 2025-07-31 | ABEO | Stock | 6.73 | 6.9282 | 6.35 | 6.37 | 649789.0 |
| 2025-07-31 | ABEV | Stock | 2.16 | 2.22 | 2.15 | 2.18 | 71449445.0 |
| 2025-07-31 | ABG | Stock | 220.85 | 226.36 | 220.85 | 222.12 | 223796.0 |
| 2025-07-31 | ABLLW | Stock | 1.1201 | 1.14 | 1.11 | 1.11 | 7384.0 |
| 2025-07-31 | ABLV | Stock | 0.98 | 1.06 | 0.98 | 1.0 | 4612.0 |
| 2025-07-31 | ABM | Stock | 46.16 | 46.53 | 45.92 | 46.13 | 342145.0 |
| 2025-07-31 | ABNB | Stock | 134.75 | 135.8 | 132.12 | 132.41 | 3873565.0 |
| 2025-07-31 | ABOS | Stock | 1.45 | 1.49 | 1.39 | 1.4 | 154755.0 |
| 2025-07-31 | ABPWW | Stock | 0.0546 | 0.0546 | 0.0511 | 0.0511 | 8914.0 |
| 2025-07-31 | ABR | Stock | 11.42 | 11.465 | 11.0932 | 11.16 | 4560141.0 |
| 2025-07-31 | ABR.D | Stock | 17.95 | 18.2 | 17.88 | 18.2 | 24796.0 |
| 2025-07-31 | ABR.E | Stock | 17.75 | 17.96 | 17.6 | 17.78 | 32860.0 |
| 2025-07-31 | ABR.F | Stock | 21.56 | 21.925 | 21.395 | 21.5 | 36139.0 |
| 2025-07-31 | ABSI | Stock | 2.92 | 3.0 | 2.81 | 2.83 | 4867058.0 |
> showing 50 of 7,158 rows — these rows as CSV