PREVIEW / stock_daily / 2005-08-23
file: by_date/stock_daily/2005/2005-08-23.parquet size: 140 KB rows: 4,184 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-08-23 | AAPL | Stock | 1.6375 | 1.6464 | 1.6186 | 1.6336 | 295604400.0 |
| 2005-08-23 | MSFT | Stock | 26.84 | 27.07 | 26.74 | 26.87 | 48296700.0 |
| 2005-08-23 | NVDA | Stock | 0.2411 | 0.2442 | 0.2402 | 0.2429 | 254460000.0 |
| 2005-08-23 | AMZN | Stock | 2.187 | 2.1985 | 2.161 | 2.171 | 70354000.0 |
| 2005-08-23 | CL | Stock | 26.225 | 26.62 | 26.2 | 26.505 | 4036000.0 |
| 2005-08-23 | A | Stock | 21.8884 | 22.0029 | 21.6381 | 21.6381 | 9969418.0 |
| 2005-08-23 | AABA-DELISTED | Stock | 33.2900009155273 | 33.3300018310547 | 32.6500015258789 | 33.1100006103516 | 16912700.0 |
| 2005-08-23 | AACC-DELISTED | Stock | 28.42 | 28.479 | 27.89 | 28.07 | 156357.0 |
| 2005-08-23 | AACQ-DELISTED | Stock | 5.1 | 5.1 | 5.1 | 5.1 | 88100.0 |
| 2005-08-23 | AACQU-DELISTED | Stock | 6.05 | 6.05 | 6.0 | 6.0 | 4000.0 |
| 2005-08-23 | AACQW-DELISTED | Stock | 0.49 | 0.49 | 0.49 | 0.49 | 10000.0 |
| 2005-08-23 | AAI-DELISTED | Stock | 10.86 | 11.0 | 10.8 | 10.94 | 705200.0 |
| 2005-08-23 | AAIC-DELISTED | Stock | 234.0 | 240.0 | 232.6 | 234.8 | 1209900.0 |
| 2005-08-23 | AAME | Stock | 3.0 | 3.05 | 3.0 | 3.01 | 2700.0 |
| 2005-08-23 | AAON | Stock | 2.2887 | 2.3309 | 2.2756 | 2.3032 | 202753.0 |
| 2005-08-23 | AAP | Stock | 42.1867 | 42.5267 | 40.9067 | 41.4 | 2444250.0 |
| 2005-08-23 | AATI-DELISTED | Stock | 12.6 | 12.88 | 12.312 | 12.75 | 166698.0 |
| 2005-08-23 | AAV-DELISTED | Stock | 16.07 | 16.19 | 15.99 | 16.07 | 50200.0 |
| 2005-08-23 | AAXN-DELISTED | Stock | 9.22000026702881 | 9.60000038146973 | 9.0600004196167 | 9.09000015258789 | 2235200.0 |
| 2005-08-23 | ABAX-DELISTED | Stock | 10.98 | 11.18 | 10.83 | 11.03 | 73110.0 |
| 2005-08-23 | ABB-DELISTED | Stock | 7.16 | 7.2 | 7.12 | 7.16 | 476900.0 |
| 2005-08-23 | ABBC-DELISTED | Stock | 12.74 | 12.8 | 12.73 | 12.75 | 42300.0 |
| 2005-08-23 | ABC-DELISTED | Stock | 18.14 | 18.2 | 17.66 | 17.67 | 3611200.0 |
| 2005-08-23 | ABCB | Stock | 18.1008 | 18.1885 | 17.9842 | 18.1689 | 2365.0 |
| 2005-08-23 | ABCO-DELISTED | Stock | 25.95 | 25.95 | 25.16 | 25.6 | 138518.0 |
| 2005-08-23 | ABCW-DELISTED | Stock | 30.19 | 30.25 | 29.77 | 30.12 | 46510.0 |
| 2005-08-23 | ABD-DELISTED | Stock | 26.9 | 27.0 | 25.54 | 25.95 | 1025840.0 |
| 2005-08-23 | ABE-DELISTED | Stock | 10.53 | 10.53 | 10.4 | 10.45 | 7000.0 |
| 2005-08-23 | ABFS-DELISTED | Stock | 34.3 | 34.36 | 33.47 | 33.78 | 401286.0 |
| 2005-08-23 | ABG | Stock | 17.98 | 17.99 | 17.61 | 17.74 | 70900.0 |
| 2005-08-23 | ABK-DELISTED | Stock | 67.74 | 68.28 | 67.74 | 68.11 | 782200.0 |
| 2005-08-23 | ABM | Stock | 19.34 | 19.37 | 19.09 | 19.23 | 90200.0 |
| 2005-08-23 | ABMD-DELISTED | Stock | 9.55 | 9.59 | 9.31 | 9.4 | 50827.0 |
| 2005-08-23 | ABP-DELISTED | Stock | 4.43 | 4.5 | 4.37 | 4.44 | 333400.0 |
| 2005-08-23 | ABR | Stock | 27.27 | 27.53 | 27.2 | 27.32 | 106400.0 |
| 2005-08-23 | ABT | Stock | 21.9988 | 22.0468 | 21.9173 | 21.9269 | 5760108.0 |
| 2005-08-23 | ABTL-DELISTED | Stock | 21.55 | 23.25 | 21.45 | 22.95 | 48846.0 |
| 2005-08-23 | ABV-DELISTED | Stock | 31.9 | 31.96 | 31.5 | 31.72 | 446100.0 |
| 2005-08-23 | ABVA-DELISTED | Stock | 16.25 | 16.3 | 16.25 | 16.3 | 1801.0 |
| 2005-08-23 | ABX-DELISTED | Stock | 26.51 | 26.74 | 26.18 | 26.22 | 1126500.0 |
| 2005-08-23 | ACAD | Stock | 9.23 | 9.3 | 9.0 | 9.27 | 23200.0 |
| 2005-08-23 | ACAP-DELISTED | Stock | 44.56 | 44.6 | 43.95 | 44.27 | 41986.0 |
| 2005-08-23 | ACAS-DELISTED | Stock | 38.24 | 38.82 | 38.2 | 38.75 | 935810.0 |
| 2005-08-23 | ACAT-DELISTED | Stock | 21.1 | 21.1 | 20.68 | 20.86 | 127086.0 |
| 2005-08-23 | ACC-DELISTED | Stock | 23.9 | 23.9 | 23.59 | 23.8 | 178467.0 |
| 2005-08-23 | ACCL-DELISTED | Stock | 5.35 | 5.39 | 5.15 | 5.3 | 85467.0 |
| 2005-08-23 | ACCO | Stock | 26.9 | 27.0 | 25.54 | 25.95 | 1037700.0 |
| 2005-08-23 | ACE-DELISTED | Stock | 45.23 | 45.55 | 45.1 | 45.16 | 383100.0 |
| 2005-08-23 | ACF-DELISTED | Stock | 25.55 | 26.15 | 25.55 | 25.65 | 3285400.0 |
| 2005-08-23 | ACFC-DELISTED | Stock | 71.43 | 72.09 | 71.43 | 71.74 | 1990.0 |
> showing 50 of 4,184 rows — these rows as CSV