PREVIEW / stock_daily / 2005-08-25
file: by_date/stock_daily/2005/2005-08-25.parquet size: 139 KB rows: 4,156 symbols: 2,612
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 |
|---|---|---|---|---|---|---|---|
| 2005-08-25 | AAPL | Stock | 1.6471 | 1.6604 | 1.6361 | 1.645 | 276253600.0 |
| 2005-08-25 | MSFT | Stock | 26.9 | 27.09 | 26.85 | 27.03 | 39306300.0 |
| 2005-08-25 | NVDA | Stock | 0.2442 | 0.2461 | 0.2421 | 0.2447 | 296484000.0 |
| 2005-08-25 | AMZN | Stock | 2.127 | 2.14 | 2.104 | 2.1155 | 61844000.0 |
| 2005-08-25 | CL | Stock | 26.295 | 26.315 | 26.175 | 26.235 | 2413200.0 |
| 2005-08-25 | A | Stock | 21.495 | 22.2318 | 21.4235 | 22.0315 | 7599668.0 |
| 2005-08-25 | AABA-DELISTED | Stock | 33.5400009155273 | 33.6199989318848 | 33.2000007629395 | 33.4799995422363 | 12564900.0 |
| 2005-08-25 | AACC-DELISTED | Stock | 28.79 | 29.95 | 28.69 | 28.88 | 176245.0 |
| 2005-08-25 | AACQW-DELISTED | Stock | 0.5 | 0.5 | 0.5 | 0.5 | 5000.0 |
| 2005-08-25 | AAI-DELISTED | Stock | 10.68 | 10.9 | 10.6 | 10.7 | 510900.0 |
| 2005-08-25 | AAIC-DELISTED | Stock | 235.0 | 237.0 | 231.2 | 233.8 | 687800.0 |
| 2005-08-25 | AAME | Stock | 3.01 | 3.01 | 3.0 | 3.0 | 1400.0 |
| 2005-08-25 | AAON | Stock | 2.344 | 2.4533 | 2.344 | 2.4244 | 279450.0 |
| 2005-08-25 | AAP | Stock | 41.54 | 41.8333 | 41.2933 | 41.4 | 1118250.0 |
| 2005-08-25 | AATI-DELISTED | Stock | 12.9 | 12.9 | 12.5 | 12.6 | 59957.0 |
| 2005-08-25 | AAV-DELISTED | Stock | 16.26 | 16.37 | 15.45 | 16.26 | 28800.0 |
| 2005-08-25 | AAXN-DELISTED | Stock | 9.0600004196167 | 9.0600004196167 | 8.76000022888184 | 8.85000038146973 | 1080000.0 |
| 2005-08-25 | ABAX-DELISTED | Stock | 10.9 | 11.03 | 10.9 | 11.0 | 125678.0 |
| 2005-08-25 | ABB-DELISTED | Stock | 7.11 | 7.15 | 7.08 | 7.13 | 536400.0 |
| 2005-08-25 | ABBC-DELISTED | Stock | 12.71 | 12.85 | 12.71 | 12.85 | 11741.0 |
| 2005-08-25 | ABC-DELISTED | Stock | 17.7 | 18.25 | 17.7 | 18.18 | 3532000.0 |
| 2005-08-25 | ABCB | Stock | 18.1397 | 18.1397 | 17.8967 | 18.0036 | 4010.0 |
| 2005-08-25 | ABCO-DELISTED | Stock | 25.45 | 25.92 | 25.45 | 25.79 | 124306.0 |
| 2005-08-25 | ABCW-DELISTED | Stock | 29.61 | 29.92 | 29.38 | 29.9 | 166830.0 |
| 2005-08-25 | ABD-DELISTED | Stock | 23.9 | 24.23 | 23.8 | 23.8 | 1869300.0 |
| 2005-08-25 | ABE-DELISTED | Stock | 10.25 | 10.35 | 10.25 | 10.27 | 6200.0 |
| 2005-08-25 | ABFS-DELISTED | Stock | 33.91 | 34.28 | 33.91 | 34.08 | 167460.0 |
| 2005-08-25 | ABG | Stock | 17.49 | 17.59 | 17.25 | 17.4 | 61800.0 |
| 2005-08-25 | ABK-DELISTED | Stock | 68.17 | 68.45 | 68.06 | 68.3 | 620300.0 |
| 2005-08-25 | ABM | Stock | 19.2 | 19.72 | 19.11 | 19.65 | 110000.0 |
| 2005-08-25 | ABMD-DELISTED | Stock | 9.4 | 9.69 | 9.33 | 9.46 | 57595.0 |
| 2005-08-25 | ABP-DELISTED | Stock | 4.56 | 4.56 | 4.35 | 4.39 | 247000.0 |
| 2005-08-25 | ABR | Stock | 27.39 | 28.3 | 27.39 | 28.04 | 319000.0 |
| 2005-08-25 | ABT | Stock | 21.543 | 21.8549 | 21.5142 | 21.6438 | 7062109.0 |
| 2005-08-25 | ABTL-DELISTED | Stock | 22.91 | 23.3 | 22.46 | 23.2 | 16905.0 |
| 2005-08-25 | ABV-DELISTED | Stock | 31.58 | 31.76 | 31.18 | 31.73 | 183400.0 |
| 2005-08-25 | ABVA-DELISTED | Stock | 16.99 | 16.99 | 16.65 | 16.76 | 17700.0 |
| 2005-08-25 | ABX-DELISTED | Stock | 25.9 | 26.22 | 25.74 | 26.09 | 2663200.0 |
| 2005-08-25 | ACAD | Stock | 9.45 | 9.75 | 9.3 | 9.55 | 94500.0 |
| 2005-08-25 | ACAP-DELISTED | Stock | 44.15 | 44.59 | 44.15 | 44.5 | 42032.0 |
| 2005-08-25 | ACAS-DELISTED | Stock | 37.61 | 38.2 | 37.55 | 37.95 | 430380.0 |
| 2005-08-25 | ACAT-DELISTED | Stock | 21.06 | 21.68 | 21.06 | 21.56 | 66308.0 |
| 2005-08-25 | ACC-DELISTED | Stock | 23.85 | 24.0 | 23.82 | 23.87 | 76800.0 |
| 2005-08-25 | ACCL-DELISTED | Stock | 5.25 | 5.39 | 5.17 | 5.35 | 63510.0 |
| 2005-08-25 | ACCO | Stock | 23.9 | 24.23 | 23.8 | 23.8 | 1869300.0 |
| 2005-08-25 | ACE-DELISTED | Stock | 44.81 | 44.88 | 44.53 | 44.73 | 433400.0 |
| 2005-08-25 | ACF-DELISTED | Stock | 25.8 | 25.87 | 25.52 | 25.63 | 831200.0 |
| 2005-08-25 | ACFC-DELISTED | Stock | 71.73 | 73.93 | 71.73 | 73.52 | 3819.0 |
| 2005-08-25 | ACG-DELISTED | Stock | 8.28 | 8.33 | 8.28 | 8.33 | 277900.0 |
| 2005-08-25 | ACGL | Stock | 5.1389 | 5.1667 | 5.1356 | 5.1522 | 305100.0 |
> showing 50 of 4,156 rows — these rows as CSV