PREVIEW / stock_daily / 2005-08-10
file: by_date/stock_daily/2005/2005-08-10.parquet size: 139 KB rows: 4,144 symbols: 2,598
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-10 | AAPL | Stock | 1.5714 | 1.5854 | 1.5468 | 1.5493 | 360945200.0 |
| 2005-08-10 | MSFT | Stock | 27.41 | 27.5 | 26.85 | 26.95 | 62818800.0 |
| 2005-08-10 | NVDA | Stock | 0.2367 | 0.2378 | 0.2297 | 0.2322 | 440556000.0 |
| 2005-08-10 | AMZN | Stock | 2.2695 | 2.2785 | 2.2295 | 2.238 | 198424000.0 |
| 2005-08-10 | CL | Stock | 26.485 | 26.62 | 26.185 | 26.375 | 3381800.0 |
| 2005-08-10 | A | Stock | 18.3977 | 18.4835 | 18.0114 | 18.0973 | 1918056.0 |
| 2005-08-10 | AABA-DELISTED | Stock | 34.2799987792969 | 34.7700004577637 | 34.0 | 34.189998626709 | 18047900.0 |
| 2005-08-10 | AACC-DELISTED | Stock | 27.73 | 27.73 | 27.3 | 27.62 | 347862.0 |
| 2005-08-10 | AACQU-DELISTED | Stock | 5.9 | 5.9 | 5.9 | 5.9 | 300.0 |
| 2005-08-10 | AAI-DELISTED | Stock | 11.14 | 11.57 | 11.02 | 11.15 | 1282000.0 |
| 2005-08-10 | AAIC-DELISTED | Stock | 252.0 | 258.8 | 252.0 | 252.8 | 1273800.0 |
| 2005-08-10 | AAON | Stock | 2.2031 | 2.2387 | 2.1412 | 2.1794 | 444234.0 |
| 2005-08-10 | AAP | Stock | 45.7333 | 47.1533 | 45.7333 | 46.3733 | 1558650.0 |
| 2005-08-10 | AATI-DELISTED | Stock | 11.53 | 11.75 | 11.25 | 11.55 | 311387.0 |
| 2005-08-10 | AAV-DELISTED | Stock | 15.49 | 16.38 | 15.18 | 15.49 | 67300.0 |
| 2005-08-10 | AAXN-DELISTED | Stock | 8.85000038146973 | 8.89999961853027 | 8.52000045776367 | 8.60000038146973 | 1357900.0 |
| 2005-08-10 | ABAX-DELISTED | Stock | 11.62 | 11.77 | 11.1 | 11.26 | 216849.0 |
| 2005-08-10 | ABB-DELISTED | Stock | 7.27 | 7.34 | 7.24 | 7.25 | 868600.0 |
| 2005-08-10 | ABBC-DELISTED | Stock | 12.79 | 12.8 | 12.71 | 12.73 | 27179.0 |
| 2005-08-10 | ABC-DELISTED | Stock | 18.26 | 18.34 | 18.05 | 18.1 | 3162000.0 |
| 2005-08-10 | ABCB | Stock | 18.5289 | 18.5969 | 18.4315 | 18.4413 | 18095.0 |
| 2005-08-10 | ABCO-DELISTED | Stock | 26.09 | 26.56 | 25.28 | 25.37 | 295897.0 |
| 2005-08-10 | ABCW-DELISTED | Stock | 30.97 | 31.15 | 30.0 | 30.27 | 52480.0 |
| 2005-08-10 | ABE-DELISTED | Stock | 10.5 | 10.65 | 10.5 | 10.58 | 22600.0 |
| 2005-08-10 | ABFS-DELISTED | Stock | 34.23 | 35.39 | 34.001 | 34.31 | 231958.0 |
| 2005-08-10 | ABG | Stock | 18.06 | 18.06 | 17.57 | 17.87 | 111900.0 |
| 2005-08-10 | ABK-DELISTED | Stock | 69.85 | 70.4 | 69.57 | 69.66 | 669300.0 |
| 2005-08-10 | ABM | Stock | 19.64 | 19.74 | 19.28 | 19.4 | 95200.0 |
| 2005-08-10 | ABMD-DELISTED | Stock | 10.0 | 10.17 | 9.951 | 10.01 | 129334.0 |
| 2005-08-10 | ABP-DELISTED | Stock | 4.68 | 4.73 | 4.41 | 4.53 | 625400.0 |
| 2005-08-10 | ABR | Stock | 27.25 | 27.95 | 27.25 | 27.55 | 271300.0 |
| 2005-08-10 | ABT | Stock | 22.4978 | 22.637 | 22.2915 | 22.3587 | 6458524.0 |
| 2005-08-10 | ABTL-DELISTED | Stock | 22.98 | 23.52 | 21.23 | 23.17 | 163742.0 |
| 2005-08-10 | ABV-DELISTED | Stock | 33.24 | 33.74 | 32.95 | 33.0 | 368700.0 |
| 2005-08-10 | ABVA-DELISTED | Stock | 16.3 | 16.4 | 16.25 | 16.4 | 7696.0 |
| 2005-08-10 | ABVT-DELISTED | Stock | 25.0 | 25.0 | 25.0 | 25.0 | 1000.0 |
| 2005-08-10 | ABX-DELISTED | Stock | 26.32 | 26.65 | 26.16 | 26.44 | 1550200.0 |
| 2005-08-10 | ACAD | Stock | 9.0 | 9.0 | 8.68 | 8.69 | 21000.0 |
| 2005-08-10 | ACAP-DELISTED | Stock | 40.3 | 40.89 | 40.18 | 40.59 | 76127.0 |
| 2005-08-10 | ACAS-DELISTED | Stock | 38.6 | 39.23 | 38.48 | 38.75 | 532007.0 |
| 2005-08-10 | ACAT-DELISTED | Stock | 20.72 | 21.3999 | 20.45 | 20.65 | 77256.0 |
| 2005-08-10 | ACC-DELISTED | Stock | 24.15 | 24.27 | 23.95 | 24.02 | 103900.0 |
| 2005-08-10 | ACCL-DELISTED | Stock | 5.48 | 5.59 | 5.37 | 5.44 | 83244.0 |
| 2005-08-10 | ACE-DELISTED | Stock | 45.95 | 46.11 | 45.28 | 45.4 | 571900.0 |
| 2005-08-10 | ACF-DELISTED | Stock | 25.55 | 25.56 | 24.59 | 24.97 | 2306600.0 |
| 2005-08-10 | ACFC-DELISTED | Stock | 69.44 | 70.15 | 68.16 | 68.16 | 2914.0 |
| 2005-08-10 | ACG-DELISTED | Stock | 8.24 | 8.24 | 8.21 | 8.21 | 352700.0 |
| 2005-08-10 | ACGL | Stock | 5.1256 | 5.1256 | 5.0856 | 5.1056 | 544500.0 |
| 2005-08-10 | ACGN-DELISTED | Stock | 555.3288 | 555.3288 | 521.3288 | 544.0 | 55300.0 |
| 2005-08-10 | ACH | Stock | 19.5267 | 19.7 | 19.16 | 19.4267 | 218100.0 |
> showing 50 of 4,144 rows — these rows as CSV