PREVIEW / stock_daily / 2005-08-31
file: by_date/stock_daily/2005/2005-08-31.parquet size: 141 KB rows: 4,193 symbols: 2,641
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-31 | AAPL | Stock | 1.6736 | 1.6796 | 1.6525 | 1.6746 | 402956400.0 |
| 2005-08-31 | MSFT | Stock | 27.17 | 27.44 | 27.04 | 27.38 | 65210200.0 |
| 2005-08-31 | NVDA | Stock | 0.2495 | 0.2588 | 0.2487 | 0.2557 | 906804000.0 |
| 2005-08-31 | AMZN | Stock | 2.122 | 2.1405 | 2.102 | 2.135 | 67384000.0 |
| 2005-08-31 | CL | Stock | 26.205 | 26.295 | 26.0 | 26.25 | 3578600.0 |
| 2005-08-31 | A | Stock | 22.9041 | 23.0472 | 22.711 | 23.0043 | 3016185.0 |
| 2005-08-31 | AABA-DELISTED | Stock | 33.2299995422363 | 33.3899993896484 | 32.9900016784668 | 33.3199996948242 | 13035500.0 |
| 2005-08-31 | AACC-DELISTED | Stock | 28.9 | 29.14 | 28.2501 | 28.83 | 249892.0 |
| 2005-08-31 | AACQ-DELISTED | Stock | 5.1 | 5.1 | 5.1 | 5.1 | 10000.0 |
| 2005-08-31 | AACQU-DELISTED | Stock | 6.0 | 6.05 | 6.0 | 6.05 | 5500.0 |
| 2005-08-31 | AACQW-DELISTED | Stock | 0.47 | 0.52 | 0.47 | 0.52 | 241000.0 |
| 2005-08-31 | AAI-DELISTED | Stock | 10.12 | 10.39 | 9.93 | 10.33 | 691700.0 |
| 2005-08-31 | AAIC-DELISTED | Stock | 228.2 | 234.2 | 228.2 | 234.0 | 1109100.0 |
| 2005-08-31 | AAME | Stock | 2.85 | 2.85 | 2.85 | 2.85 | 500.0 |
| 2005-08-31 | AAON | Stock | 2.3401 | 2.3862 | 2.3401 | 2.3862 | 139725.0 |
| 2005-08-31 | AAP | Stock | 40.6267 | 41.0533 | 40.14 | 40.62 | 1607400.0 |
| 2005-08-31 | AATI-DELISTED | Stock | 12.88 | 13.05 | 12.8 | 12.9 | 38000.0 |
| 2005-08-31 | AAV-DELISTED | Stock | 16.55 | 16.71 | 16.32 | 16.55 | 56300.0 |
| 2005-08-31 | AAXN-DELISTED | Stock | 8.65999984741211 | 8.77000045776367 | 8.52000045776367 | 8.64999961853027 | 1037400.0 |
| 2005-08-31 | ABAX-DELISTED | Stock | 11.31 | 11.47 | 11.0 | 11.47 | 89947.0 |
| 2005-08-31 | ABB-DELISTED | Stock | 7.18 | 7.3 | 7.14 | 7.3 | 1807200.0 |
| 2005-08-31 | ABBC-DELISTED | Stock | 12.85 | 12.85 | 12.57 | 12.7 | 3000.0 |
| 2005-08-31 | ABC-DELISTED | Stock | 18.6 | 18.75 | 18.52 | 18.67 | 3377200.0 |
| 2005-08-31 | ABCB | Stock | 17.4589 | 18.0425 | 17.3131 | 18.0425 | 25909.0 |
| 2005-08-31 | ABCO-DELISTED | Stock | 25.86 | 26.4 | 25.71 | 26.16 | 105361.0 |
| 2005-08-31 | ABCW-DELISTED | Stock | 29.61 | 30.5 | 29.61 | 30.44 | 43250.0 |
| 2005-08-31 | ABD-DELISTED | Stock | 25.72 | 26.19 | 25.6 | 26.15 | 1007670.0 |
| 2005-08-31 | ABE-DELISTED | Stock | 10.57 | 10.57 | 10.48 | 10.48 | 14600.0 |
| 2005-08-31 | ABFS-DELISTED | Stock | 33.41 | 33.69 | 32.75 | 33.61 | 288044.0 |
| 2005-08-31 | ABG | Stock | 17.12 | 17.12 | 16.81 | 17.06 | 51100.0 |
| 2005-08-31 | ABK-DELISTED | Stock | 68.02 | 68.58 | 67.3 | 68.54 | 878000.0 |
| 2005-08-31 | ABM | Stock | 19.35 | 19.9 | 19.29 | 19.83 | 118100.0 |
| 2005-08-31 | ABMD-DELISTED | Stock | 9.48 | 10.03 | 9.31 | 10.0 | 77477.0 |
| 2005-08-31 | ABP-DELISTED | Stock | 4.52 | 4.69 | 4.45 | 4.69 | 346000.0 |
| 2005-08-31 | ABR | Stock | 27.99 | 28.69 | 27.99 | 28.44 | 111300.0 |
| 2005-08-31 | ABT | Stock | 21.519 | 21.6726 | 21.4231 | 21.6534 | 9665486.0 |
| 2005-08-31 | ABTL-DELISTED | Stock | 23.88 | 25.22 | 23.73 | 25.02 | 42517.0 |
| 2005-08-31 | ABV-DELISTED | Stock | 31.5 | 32.19 | 31.36 | 32.1 | 257800.0 |
| 2005-08-31 | ABVA-DELISTED | Stock | 16.51 | 16.58 | 16.35 | 16.35 | 11080.0 |
| 2005-08-31 | ABX-DELISTED | Stock | 25.75 | 26.26 | 25.57 | 26.21 | 1817203.0 |
| 2005-08-31 | ACAD | Stock | 9.4 | 9.57 | 9.38 | 9.57 | 45000.0 |
| 2005-08-31 | ACAP-DELISTED | Stock | 43.93 | 44.45 | 43.84 | 44.26 | 88100.0 |
| 2005-08-31 | ACAS-DELISTED | Stock | 36.92 | 37.8 | 36.88 | 37.74 | 588878.0 |
| 2005-08-31 | ACAT-DELISTED | Stock | 20.81 | 21.646 | 20.71 | 21.56 | 72461.0 |
| 2005-08-31 | ACC-DELISTED | Stock | 23.38 | 23.57 | 23.27 | 23.57 | 159626.0 |
| 2005-08-31 | ACCL-DELISTED | Stock | 5.3 | 5.45 | 5.3 | 5.45 | 41288.0 |
| 2005-08-31 | ACCO | Stock | 25.77 | 26.25 | 25.65 | 26.1 | 1145600.0 |
| 2005-08-31 | ACE-DELISTED | Stock | 44.06 | 44.45 | 43.49 | 44.4 | 1365926.0 |
| 2005-08-31 | ACF-DELISTED | Stock | 24.99 | 25.03 | 24.72 | 24.94 | 1207100.0 |
| 2005-08-31 | ACFC-DELISTED | Stock | 72.4 | 72.96 | 72.2 | 72.96 | 2108.0 |
> showing 50 of 4,193 rows — these rows as CSV