PREVIEW / stock_daily / 2005-07-08
file: by_date/stock_daily/2005/2005-07-08.parquet size: 137 KB rows: 4,130 symbols: 2,595
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-07-08 | AAPL | Stock | 1.3525 | 1.3671 | 1.3382 | 1.3661 | 290735200.0 |
| 2005-07-08 | MSFT | Stock | 24.64 | 25.12 | 24.63 | 25.09 | 56104000.0 |
| 2005-07-08 | NVDA | Stock | 0.233 | 0.2352 | 0.23 | 0.2345 | 408132000.0 |
| 2005-07-08 | AMZN | Stock | 1.7055 | 1.7375 | 1.6925 | 1.737 | 85140000.0 |
| 2005-07-08 | CL | Stock | 25.06 | 25.24 | 24.89 | 25.23 | 3800200.0 |
| 2005-07-08 | A | Stock | 17.1316 | 17.475 | 17.0959 | 17.4106 | 3375611.0 |
| 2005-07-08 | AABA-DELISTED | Stock | 34.7700004577637 | 34.8699989318848 | 34.25 | 34.6199989318848 | 15515400.0 |
| 2005-07-08 | AACC-DELISTED | Stock | 25.46 | 25.68 | 25.22 | 25.49 | 81617.0 |
| 2005-07-08 | AACQU-DELISTED | Stock | 6.0 | 6.0 | 6.0 | 6.0 | 1000.0 |
| 2005-07-08 | AAI-DELISTED | Stock | 9.01 | 9.44 | 8.96 | 9.38 | 1228100.0 |
| 2005-07-08 | AAIC-DELISTED | Stock | 298.6 | 302.4 | 296.2 | 300.2 | 1169100.0 |
| 2005-07-08 | AAME | Stock | 3.0 | 3.06 | 3.0 | 3.0 | 21000.0 |
| 2005-07-08 | AAON | Stock | 2.4362 | 2.4968 | 2.423 | 2.4928 | 284766.0 |
| 2005-07-08 | AAP | Stock | 42.6267 | 42.9667 | 42.5667 | 42.8467 | 610650.0 |
| 2005-07-08 | AAV-DELISTED | Stock | 14.5 | 14.65 | 14.42 | 14.5 | 70400.0 |
| 2005-07-08 | AAXN-DELISTED | Stock | 9.92000007629395 | 10.3000001907349 | 9.85000038146973 | 10.1999998092651 | 2703900.0 |
| 2005-07-08 | ABAX-DELISTED | Stock | 11.06 | 11.21 | 10.93 | 11.13 | 81970.0 |
| 2005-07-08 | ABB-DELISTED | Stock | 6.37 | 6.47 | 6.37 | 6.45 | 1761200.0 |
| 2005-07-08 | ABBC-DELISTED | Stock | 12.12 | 12.12 | 11.95 | 11.97 | 13354.0 |
| 2005-07-08 | ABC-DELISTED | Stock | 17.53 | 17.72 | 17.4 | 17.7 | 4019836.0 |
| 2005-07-08 | ABCB | Stock | 17.9939 | 18.4802 | 17.6632 | 18.4218 | 16347.0 |
| 2005-07-08 | ABCO-DELISTED | Stock | 23.87 | 24.4 | 23.71 | 24.04 | 210991.0 |
| 2005-07-08 | ABCW-DELISTED | Stock | 30.01 | 31.2 | 30.01 | 31.0 | 47112.0 |
| 2005-07-08 | ABE-DELISTED | Stock | 10.05 | 10.05 | 9.96 | 9.96 | 9000.0 |
| 2005-07-08 | ABFS-DELISTED | Stock | 34.04 | 35.25 | 33.82 | 34.93 | 387796.0 |
| 2005-07-08 | ABG | Stock | 16.01 | 16.25 | 15.97 | 16.1 | 116500.0 |
| 2005-07-08 | ABK-DELISTED | Stock | 69.37 | 69.45 | 68.87 | 69.07 | 850100.0 |
| 2005-07-08 | ABM | Stock | 19.75 | 19.99 | 19.74 | 19.86 | 248200.0 |
| 2005-07-08 | ABMD-DELISTED | Stock | 8.908 | 10.15 | 8.9 | 9.32 | 162931.0 |
| 2005-07-08 | ABP-DELISTED | Stock | 3.03 | 3.16 | 3.0 | 3.01 | 440000.0 |
| 2005-07-08 | ABR | Stock | 29.5 | 30.99 | 29.43 | 30.5 | 131000.0 |
| 2005-07-08 | ABT | Stock | 23.5006 | 23.7309 | 23.4142 | 23.6781 | 6682368.0 |
| 2005-07-08 | ABTL-DELISTED | Stock | 23.33 | 23.43 | 22.67 | 22.92 | 49321.0 |
| 2005-07-08 | ABV-DELISTED | Stock | 31.41 | 31.8 | 30.96 | 31.29 | 234000.0 |
| 2005-07-08 | ABVA-DELISTED | Stock | 16.08 | 16.08 | 16.01 | 16.04 | 400.0 |
| 2005-07-08 | ABX-DELISTED | Stock | 24.62 | 24.89 | 24.46 | 24.55 | 810200.0 |
| 2005-07-08 | ACAD | Stock | 8.0 | 9.0 | 8.0 | 9.0 | 21500.0 |
| 2005-07-08 | ACAP-DELISTED | Stock | 37.0 | 38.91 | 37.0 | 38.52 | 82264.0 |
| 2005-07-08 | ACAS-DELISTED | Stock | 37.1 | 37.14 | 36.38 | 36.8 | 764491.0 |
| 2005-07-08 | ACAT-DELISTED | Stock | 20.15 | 20.24 | 19.96 | 20.18 | 145067.0 |
| 2005-07-08 | ACC-DELISTED | Stock | 23.0 | 24.05 | 23.0 | 23.69 | 133900.0 |
| 2005-07-08 | ACCL-DELISTED | Stock | 5.0 | 5.25 | 4.88 | 5.25 | 161282.0 |
| 2005-07-08 | ACE-DELISTED | Stock | 45.16 | 45.57 | 44.7 | 45.39 | 799900.0 |
| 2005-07-08 | ACF-DELISTED | Stock | 26.0 | 26.43 | 25.75 | 26.23 | 848200.0 |
| 2005-07-08 | ACFC-DELISTED | Stock | 62.5 | 62.76 | 62.3 | 62.65 | 2023.0 |
| 2005-07-08 | ACG-DELISTED | Stock | 8.32 | 8.33 | 8.27 | 8.29 | 318800.0 |
| 2005-07-08 | ACGL | Stock | 4.9733 | 4.9733 | 4.9289 | 4.9389 | 982800.0 |
| 2005-07-08 | ACGN-DELISTED | Stock | 578.0 | 612.0 | 578.0 | 612.0 | 138800.0 |
| 2005-07-08 | ACH | Stock | 21.7267 | 21.9933 | 21.46 | 21.8267 | 182700.0 |
| 2005-07-08 | ACH-DELISTED | Stock | 13.375 | 13.651 | 13.375 | 13.573 | 167600.0 |
> showing 50 of 4,130 rows — these rows as CSV