PREVIEW / stock_daily / 2005-10-28
file: by_date/stock_daily/2005/2005-10-28.parquet size: 140 KB rows: 4,197 symbols: 2,637
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-10-28 | AAPL | Stock | 2.0014 | 2.0154 | 1.9346 | 1.9454 | 769787200.0 |
| 2005-10-28 | MSFT | Stock | 25.1 | 25.6 | 25.1 | 25.53 | 106559300.0 |
| 2005-10-28 | NVDA | Stock | 0.2627 | 0.2707 | 0.2562 | 0.2702 | 464640000.0 |
| 2005-10-28 | AMZN | Stock | 1.9775 | 1.9825 | 1.936 | 1.9475 | 123184000.0 |
| 2005-10-28 | CL | Stock | 26.14 | 26.57 | 26.115 | 26.57 | 4725600.0 |
| 2005-10-28 | A | Stock | 21.917 | 22.2103 | 21.4378 | 22.1745 | 3328219.0 |
| 2005-10-28 | AABA-DELISTED | Stock | 35.6199989318848 | 35.9199981689453 | 35.25 | 35.5800018310547 | 14123800.0 |
| 2005-10-28 | AACC-DELISTED | Stock | 26.22 | 26.5 | 26.06 | 26.3 | 158594.0 |
| 2005-10-28 | AACQ-DELISTED | Stock | 5.16 | 5.16 | 5.16 | 5.16 | 5000.0 |
| 2005-10-28 | AAI-DELISTED | Stock | 14.2 | 14.8 | 14.2 | 14.39 | 2623600.0 |
| 2005-10-28 | AAIC-DELISTED | Stock | 173.8 | 176.6 | 170.0 | 171.0 | 1943300.0 |
| 2005-10-28 | AAME | Stock | 2.58 | 2.99 | 2.58 | 2.99 | 5200.0 |
| 2005-10-28 | AAON | Stock | 2.1676 | 2.1873 | 2.1347 | 2.1426 | 102516.0 |
| 2005-10-28 | AAP | Stock | 35.95 | 36.84 | 35.89 | 36.59 | 863600.0 |
| 2005-10-28 | AATI-DELISTED | Stock | 12.35 | 12.35 | 10.75 | 11.32 | 429088.0 |
| 2005-10-28 | AAV-DELISTED | Stock | 16.73 | 16.75 | 16.47 | 16.73 | 9900.0 |
| 2005-10-28 | AAXN-DELISTED | Stock | 6.30999994277954 | 6.36999988555908 | 6.03999996185303 | 6.1399998664856 | 1975700.0 |
| 2005-10-28 | ABAX-DELISTED | Stock | 16.8 | 16.98 | 16.68 | 16.8 | 380618.0 |
| 2005-10-28 | ABB-DELISTED | Stock | 7.35 | 7.59 | 7.35 | 7.58 | 1743300.0 |
| 2005-10-28 | ABBC-DELISTED | Stock | 12.09 | 12.15 | 12.0 | 12.0 | 3400.0 |
| 2005-10-28 | ABC-DELISTED | Stock | 18.41 | 18.84 | 18.4 | 18.84 | 6233523.0 |
| 2005-10-28 | ABCB | Stock | 17.8869 | 18.344 | 17.809 | 18.3343 | 6477.0 |
| 2005-10-28 | ABCO-DELISTED | Stock | 22.88 | 23.65 | 22.84 | 23.51 | 212423.0 |
| 2005-10-28 | ABCW-DELISTED | Stock | 30.77 | 31.35 | 30.55 | 31.22 | 69830.0 |
| 2005-10-28 | ABD-DELISTED | Stock | 24.4 | 24.43 | 24.14 | 24.18 | 375500.0 |
| 2005-10-28 | ABE-DELISTED | Stock | 10.61 | 10.8 | 10.61 | 10.8 | 12000.0 |
| 2005-10-28 | ABFS-DELISTED | Stock | 36.6 | 38.03 | 36.42 | 37.97 | 351390.0 |
| 2005-10-28 | ABG | Stock | 16.06 | 16.97 | 16.06 | 16.65 | 94700.0 |
| 2005-10-28 | ABK-DELISTED | Stock | 68.45 | 69.75 | 68.11 | 69.35 | 856600.0 |
| 2005-10-28 | ABM | Stock | 19.38 | 19.66 | 19.3 | 19.49 | 94900.0 |
| 2005-10-28 | ABMD-DELISTED | Stock | 8.18 | 8.4 | 8.041 | 8.2 | 106672.0 |
| 2005-10-28 | ABP-DELISTED | Stock | 5.8 | 6.0 | 5.56 | 5.93 | 895000.0 |
| 2005-10-28 | ABR | Stock | 26.88 | 26.89 | 26.39 | 26.45 | 108900.0 |
| 2005-10-28 | ABT | Stock | 20.3627 | 20.5354 | 20.1852 | 20.5114 | 7414131.0 |
| 2005-10-28 | ABTL-DELISTED | Stock | 21.42 | 21.73 | 21.12 | 21.63 | 65903.0 |
| 2005-10-28 | ABV-DELISTED | Stock | 34.9 | 35.24 | 34.77 | 34.92 | 198100.0 |
| 2005-10-28 | ABVA-DELISTED | Stock | 16.64 | 16.76 | 16.64 | 16.76 | 400.0 |
| 2005-10-28 | ABVT-DELISTED | Stock | 25.0 | 25.0 | 24.98 | 24.98 | 151900.0 |
| 2005-10-28 | ABX-DELISTED | Stock | 26.47 | 27.45 | 26.47 | 27.2 | 2770400.0 |
| 2005-10-28 | ACAD | Stock | 10.75 | 10.79 | 10.3 | 10.5 | 26000.0 |
| 2005-10-28 | ACAP-DELISTED | Stock | 42.37 | 42.37 | 41.42 | 41.83 | 81513.0 |
| 2005-10-28 | ACAS-DELISTED | Stock | 36.88 | 37.22 | 36.68 | 37.22 | 644496.0 |
| 2005-10-28 | ACAT-DELISTED | Stock | 18.56 | 18.74 | 18.41 | 18.54 | 34757.0 |
| 2005-10-28 | ACC-DELISTED | Stock | 23.85 | 24.35 | 23.73 | 24.22 | 96100.0 |
| 2005-10-28 | ACCL-DELISTED | Stock | 6.38 | 6.58 | 6.35 | 6.52 | 50180.0 |
| 2005-10-28 | ACCO | Stock | 24.4 | 24.43 | 24.14 | 24.18 | 375900.0 |
| 2005-10-28 | ACE-DELISTED | Stock | 50.58 | 51.59 | 50.38 | 51.57 | 2470712.0 |
| 2005-10-28 | ACF-DELISTED | Stock | 21.8 | 22.25 | 21.54 | 22.15 | 1892000.0 |
| 2005-10-28 | ACFC-DELISTED | Stock | 70.2 | 71.17 | 70.15 | 70.66 | 1687.0 |
| 2005-10-28 | ACG-DELISTED | Stock | 8.27 | 8.27 | 8.21 | 8.25 | 331100.0 |
> showing 50 of 4,197 rows — these rows as CSV