PREVIEW / stock_daily / 2005-07-29
file: by_date/stock_daily/2005/2005-07-29.parquet size: 138 KB rows: 4,136 symbols: 2,591
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-29 | AAPL | Stock | 1.5557 | 1.585 | 1.5093 | 1.5232 | 562080400.0 |
| 2005-07-29 | MSFT | Stock | 25.78 | 26.0 | 25.59 | 25.61 | 59524400.0 |
| 2005-07-29 | NVDA | Stock | 0.2263 | 0.2287 | 0.2237 | 0.2255 | 351660000.0 |
| 2005-07-29 | AMZN | Stock | 2.2655 | 2.2875 | 2.2305 | 2.2575 | 209836000.0 |
| 2005-07-29 | CL | Stock | 26.7 | 26.74 | 26.45 | 26.47 | 4439000.0 |
| 2005-07-29 | A | Stock | 18.8269 | 18.9413 | 18.691 | 18.7697 | 1333412.0 |
| 2005-07-29 | AABA-DELISTED | Stock | 34.0099983215332 | 34.060001373291 | 33.3400001525879 | 33.3400001525879 | 16236100.0 |
| 2005-07-29 | AACC-DELISTED | Stock | 26.32 | 28.22 | 26.3 | 27.34 | 403965.0 |
| 2005-07-29 | AAI-DELISTED | Stock | 11.35 | 11.49 | 11.25 | 11.43 | 963900.0 |
| 2005-07-29 | AAIC-DELISTED | Stock | 286.0 | 286.0 | 276.6 | 281.2 | 877400.0 |
| 2005-07-29 | AAON | Stock | 2.5284 | 2.5508 | 2.5284 | 2.5284 | 179972.0 |
| 2005-07-29 | AAP | Stock | 46.02 | 46.3067 | 45.7733 | 45.9733 | 1069050.0 |
| 2005-07-29 | AAV-DELISTED | Stock | 14.87 | 14.94 | 14.76 | 14.87 | 32300.0 |
| 2005-07-29 | AAXN-DELISTED | Stock | 10.039999961853 | 10.039999961853 | 9.71000003814697 | 9.72000026702881 | 1203500.0 |
| 2005-07-29 | ABAX-DELISTED | Stock | 12.0 | 12.75 | 11.54 | 12.52 | 330059.0 |
| 2005-07-29 | ABB-DELISTED | Stock | 6.86 | 6.89 | 6.81 | 6.82 | 2160800.0 |
| 2005-07-29 | ABBC-DELISTED | Stock | 12.5 | 12.65 | 12.41 | 12.51 | 19300.0 |
| 2005-07-29 | ABC-DELISTED | Stock | 17.92 | 17.97 | 17.84 | 17.95 | 2323200.0 |
| 2005-07-29 | ABCB | Stock | 19.3653 | 19.4529 | 19.3069 | 19.4529 | 9664.0 |
| 2005-07-29 | ABCO-DELISTED | Stock | 25.17 | 26.32 | 25.17 | 26.05 | 442933.0 |
| 2005-07-29 | ABCW-DELISTED | Stock | 32.13 | 33.13 | 31.83 | 32.01 | 62843.0 |
| 2005-07-29 | ABE-DELISTED | Stock | 10.49 | 10.49 | 10.36 | 10.46 | 12300.0 |
| 2005-07-29 | ABFS-DELISTED | Stock | 35.0 | 35.15 | 33.98 | 34.33 | 335043.0 |
| 2005-07-29 | ABG | Stock | 17.1 | 17.19 | 16.9 | 16.99 | 161800.0 |
| 2005-07-29 | ABK-DELISTED | Stock | 71.77 | 72.47 | 71.77 | 71.85 | 472600.0 |
| 2005-07-29 | ABM | Stock | 19.8 | 19.92 | 19.51 | 19.6 | 139500.0 |
| 2005-07-29 | ABMD-DELISTED | Stock | 9.82 | 9.95 | 9.65 | 9.66 | 36677.0 |
| 2005-07-29 | ABP-DELISTED | Stock | 4.45 | 4.59 | 4.35 | 4.56 | 620900.0 |
| 2005-07-29 | ABR | Stock | 30.75 | 31.07 | 30.68 | 30.8 | 67800.0 |
| 2005-07-29 | ABT | Stock | 22.4738 | 22.589 | 22.3347 | 22.3731 | 7504168.0 |
| 2005-07-29 | ABTL-DELISTED | Stock | 25.98 | 26.47 | 25.23 | 26.47 | 36085.0 |
| 2005-07-29 | ABV-DELISTED | Stock | 31.25 | 31.56 | 31.12 | 31.12 | 186200.0 |
| 2005-07-29 | ABVA-DELISTED | Stock | 16.4 | 16.9 | 16.4 | 16.75 | 6800.0 |
| 2005-07-29 | ABX-DELISTED | Stock | 24.68 | 24.8 | 24.49 | 24.51 | 1366654.0 |
| 2005-07-29 | ACAD | Stock | 9.58 | 9.77 | 9.41 | 9.55 | 60100.0 |
| 2005-07-29 | ACAP-DELISTED | Stock | 39.11 | 39.99 | 39.11 | 39.97 | 46393.0 |
| 2005-07-29 | ACAS-DELISTED | Stock | 37.86 | 37.86 | 37.51 | 37.63 | 411591.0 |
| 2005-07-29 | ACAT-DELISTED | Stock | 21.8 | 22.4 | 21.66 | 21.82 | 72131.0 |
| 2005-07-29 | ACC-DELISTED | Stock | 25.0 | 25.15 | 24.95 | 25.05 | 145400.0 |
| 2005-07-29 | ACCL-DELISTED | Stock | 5.48 | 5.59 | 5.45 | 5.52 | 75752.0 |
| 2005-07-29 | ACE-DELISTED | Stock | 46.63 | 46.89 | 46.18 | 46.22 | 988572.0 |
| 2005-07-29 | ACF-DELISTED | Stock | 26.9 | 27.01 | 26.61 | 26.69 | 604500.0 |
| 2005-07-29 | ACFC-DELISTED | Stock | 70.82 | 71.12 | 70.41 | 70.41 | 989.0 |
| 2005-07-29 | ACG-DELISTED | Stock | 8.36 | 8.37 | 8.33 | 8.35 | 310700.0 |
| 2005-07-29 | ACGL | Stock | 5.0889 | 5.1556 | 5.0433 | 5.1111 | 1489500.0 |
| 2005-07-29 | ACGN-DELISTED | Stock | 566.6712 | 589.3288 | 532.6712 | 578.0 | 186100.0 |
| 2005-07-29 | ACH | Stock | 19.8133 | 20.0667 | 19.64 | 19.76 | 160950.0 |
| 2005-07-29 | ACH-DELISTED | Stock | 14.533 | 14.613 | 14.5 | 14.535 | 116800.0 |
| 2005-07-29 | ACLS | Stock | 27.56 | 28.12 | 27.12 | 27.64 | 148675.0 |
| 2005-07-29 | ACO-DELISTED | Stock | 19.6 | 19.91 | 19.59 | 19.78 | 91300.0 |
> showing 50 of 4,136 rows — these rows as CSV