PREVIEW / stock_daily / 2005-09-28
file: by_date/stock_daily/2005/2005-09-28.parquet size: 140 KB rows: 4,189 symbols: 2,638
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-09-28 | AAPL | Stock | 1.8954 | 1.8968 | 1.8068 | 1.8243 | 1125544000.0 |
| 2005-09-28 | MSFT | Stock | 25.39 | 25.87 | 25.38 | 25.67 | 71019400.0 |
| 2005-09-28 | NVDA | Stock | 0.2766 | 0.2782 | 0.2734 | 0.2774 | 353556000.0 |
| 2005-09-28 | AMZN | Stock | 2.1625 | 2.187 | 2.1495 | 2.1685 | 64794000.0 |
| 2005-09-28 | CL | Stock | 25.98 | 26.295 | 25.96 | 26.185 | 3183800.0 |
| 2005-09-28 | A | Stock | 23.9986 | 24.1202 | 23.6338 | 23.7697 | 3909227.0 |
| 2005-09-28 | AABA-DELISTED | Stock | 32.6699981689453 | 32.7999992370605 | 32.2700004577637 | 32.3499984741211 | 11622800.0 |
| 2005-09-28 | AACC-DELISTED | Stock | 29.1 | 29.322 | 28.51 | 28.7 | 61214.0 |
| 2005-09-28 | AACQW-DELISTED | Stock | 0.6 | 0.6 | 0.59 | 0.59 | 14600.0 |
| 2005-09-28 | AAI-DELISTED | Stock | 11.76 | 12.14 | 11.76 | 12.05 | 2383100.0 |
| 2005-09-28 | AAIC-DELISTED | Stock | 205.0 | 206.0 | 197.4 | 200.8 | 1605200.0 |
| 2005-09-28 | AAON | Stock | 2.3928 | 2.402 | 2.3269 | 2.3809 | 89606.0 |
| 2005-09-28 | AAP | Stock | 38.64 | 38.75 | 37.78 | 37.81 | 743000.0 |
| 2005-09-28 | AATI-DELISTED | Stock | 12.11 | 12.46 | 12.05 | 12.14 | 144666.0 |
| 2005-09-28 | AAV-DELISTED | Stock | 18.3 | 18.31 | 16.74 | 18.3 | 52600.0 |
| 2005-09-28 | AAXN-DELISTED | Stock | 6.30999994277954 | 6.36999988555908 | 5.82999992370605 | 5.88000011444092 | 6482300.0 |
| 2005-09-28 | ABAX-DELISTED | Stock | 13.1 | 13.13 | 12.89 | 13.0 | 94976.0 |
| 2005-09-28 | ABB-DELISTED | Stock | 7.23 | 7.26 | 7.2 | 7.22 | 843900.0 |
| 2005-09-28 | ABBC-DELISTED | Stock | 12.63 | 12.63 | 12.57 | 12.57 | 7400.0 |
| 2005-09-28 | ABC-DELISTED | Stock | 19.76 | 19.76 | 19.34 | 19.4 | 2880000.0 |
| 2005-09-28 | ABCB | Stock | 18.3537 | 18.4121 | 17.7604 | 17.9939 | 8636.0 |
| 2005-09-28 | ABCO-DELISTED | Stock | 25.33 | 25.64 | 25.23 | 25.29 | 220624.0 |
| 2005-09-28 | ABCW-DELISTED | Stock | 29.21 | 29.41 | 29.04 | 29.24 | 177060.0 |
| 2005-09-28 | ABD-DELISTED | Stock | 27.72 | 27.98 | 27.6 | 27.85 | 588200.0 |
| 2005-09-28 | ABE-DELISTED | Stock | 11.15 | 11.18 | 11.11 | 11.15 | 24600.0 |
| 2005-09-28 | ABFS-DELISTED | Stock | 33.32 | 33.85 | 33.32 | 33.69 | 191267.0 |
| 2005-09-28 | ABG | Stock | 16.83 | 16.97 | 16.59 | 16.76 | 52600.0 |
| 2005-09-28 | ABK-DELISTED | Stock | 70.23 | 70.91 | 70.18 | 70.73 | 510900.0 |
| 2005-09-28 | ABM | Stock | 20.7 | 20.7 | 20.23 | 20.56 | 92700.0 |
| 2005-09-28 | ABMD-DELISTED | Stock | 10.33 | 10.41 | 9.96 | 9.99 | 40170.0 |
| 2005-09-28 | ABP-DELISTED | Stock | 7.0 | 7.9 | 6.89 | 7.82 | 3301200.0 |
| 2005-09-28 | ABR | Stock | 28.33 | 28.61 | 28.26 | 28.49 | 91900.0 |
| 2005-09-28 | ABT | Stock | 20.6314 | 20.6506 | 20.0077 | 20.1228 | 15790746.0 |
| 2005-09-28 | ABTL-DELISTED | Stock | 24.92 | 25.02 | 24.43 | 24.92 | 36579.0 |
| 2005-09-28 | ABV-DELISTED | Stock | 36.2 | 37.15 | 36.2 | 36.97 | 244400.0 |
| 2005-09-28 | ABVA-DELISTED | Stock | 16.21 | 16.65 | 16.2 | 16.65 | 4804.0 |
| 2005-09-28 | ABX-DELISTED | Stock | 28.47 | 29.08 | 28.1 | 28.82 | 2977600.0 |
| 2005-09-28 | ACAD | Stock | 10.77 | 11.01 | 10.77 | 10.87 | 76300.0 |
| 2005-09-28 | ACAP-DELISTED | Stock | 49.01 | 49.43 | 48.73 | 48.92 | 125952.0 |
| 2005-09-28 | ACAS-DELISTED | Stock | 36.37 | 36.611 | 36.18 | 36.18 | 412126.0 |
| 2005-09-28 | ACAT-DELISTED | Stock | 20.1 | 20.42 | 20.08 | 20.3 | 165926.0 |
| 2005-09-28 | ACC-DELISTED | Stock | 23.0 | 23.0 | 22.65 | 22.85 | 183100.0 |
| 2005-09-28 | ACCL-DELISTED | Stock | 6.4 | 6.66 | 6.3 | 6.57 | 101355.0 |
| 2005-09-28 | ACCO | Stock | 27.72 | 27.98 | 27.6 | 27.85 | 588200.0 |
| 2005-09-28 | ACE-DELISTED | Stock | 45.66 | 45.84 | 45.34 | 45.42 | 1279577.0 |
| 2005-09-28 | ACF-DELISTED | Stock | 24.19 | 24.26 | 23.9 | 23.94 | 1174800.0 |
| 2005-09-28 | ACFC-DELISTED | Stock | 71.43 | 72.35 | 71.07 | 72.35 | 7056.0 |
| 2005-09-28 | ACG-DELISTED | Stock | 8.36 | 8.37 | 8.34 | 8.35 | 277700.0 |
| 2005-09-28 | ACGL | Stock | 5.3111 | 5.3889 | 5.3089 | 5.3867 | 1353600.0 |
| 2005-09-28 | ACGN-DELISTED | Stock | 725.3288 | 793.3288 | 725.3288 | 770.6712 | 472800.0 |
> showing 50 of 4,189 rows — these rows as CSV