PREVIEW / stock_daily / 2005-08-19
file: by_date/stock_daily/2005/2005-08-19.parquet size: 139 KB rows: 4,163 symbols: 2,607
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-19 | AAPL | Stock | 1.6529 | 1.6679 | 1.6346 | 1.6368 | 376569200.0 |
| 2005-08-19 | MSFT | Stock | 26.85 | 26.91 | 26.7 | 26.72 | 36043500.0 |
| 2005-08-19 | NVDA | Stock | 0.2455 | 0.2462 | 0.2426 | 0.2433 | 422232000.0 |
| 2005-08-19 | AMZN | Stock | 2.18 | 2.1885 | 2.1665 | 2.186 | 66478000.0 |
| 2005-08-19 | CL | Stock | 26.35 | 26.35 | 26.06 | 26.06 | 3379600.0 |
| 2005-08-19 | A | Stock | 22.103 | 22.1459 | 21.8956 | 21.9242 | 4095860.0 |
| 2005-08-19 | AABA-DELISTED | Stock | 34.3899993896484 | 34.4700012207031 | 33.9799995422363 | 34.0 | 12810400.0 |
| 2005-08-19 | AACC-DELISTED | Stock | 28.25 | 28.25 | 27.89 | 27.94 | 62001.0 |
| 2005-08-19 | AAI-DELISTED | Stock | 10.83 | 10.97 | 10.58 | 10.6 | 820900.0 |
| 2005-08-19 | AAIC-DELISTED | Stock | 239.8 | 240.6 | 228.0 | 228.6 | 2555500.0 |
| 2005-08-19 | AAME | Stock | 2.83 | 3.03 | 2.83 | 3.0 | 23400.0 |
| 2005-08-19 | AAON | Stock | 2.2519 | 2.3374 | 2.2519 | 2.2979 | 107831.0 |
| 2005-08-19 | AAP | Stock | 42.5667 | 42.9933 | 42.4 | 42.7667 | 1757100.0 |
| 2005-08-19 | AATI-DELISTED | Stock | 13.0 | 13.0 | 12.5 | 13.0 | 77888.0 |
| 2005-08-19 | AAV-DELISTED | Stock | 15.71 | 15.75 | 15.19 | 15.71 | 39100.0 |
| 2005-08-19 | AAXN-DELISTED | Stock | 9.30000019073486 | 9.4399995803833 | 9.01000022888184 | 9.03999996185303 | 1806700.0 |
| 2005-08-19 | ABAX-DELISTED | Stock | 10.94 | 11.16 | 10.84 | 10.89 | 31064.0 |
| 2005-08-19 | ABB-DELISTED | Stock | 7.06 | 7.1 | 7.05 | 7.09 | 725400.0 |
| 2005-08-19 | ABBC-DELISTED | Stock | 12.55 | 12.69 | 12.55 | 12.61 | 8495.0 |
| 2005-08-19 | ABC-DELISTED | Stock | 18.23 | 18.24 | 17.96 | 17.99 | 2190000.0 |
| 2005-08-19 | ABCB | Stock | 17.9064 | 18.2565 | 17.9064 | 18.0814 | 10281.0 |
| 2005-08-19 | ABCO-DELISTED | Stock | 25.31 | 25.64 | 24.9 | 25.57 | 117570.0 |
| 2005-08-19 | ABCW-DELISTED | Stock | 29.92 | 30.89 | 29.92 | 30.12 | 67440.0 |
| 2005-08-19 | ABD-DELISTED | Stock | 25.9 | 26.89 | 25.9 | 26.75 | 1120400.0 |
| 2005-08-19 | ABE-DELISTED | Stock | 10.58 | 10.58 | 10.42 | 10.53 | 5000.0 |
| 2005-08-19 | ABFS-DELISTED | Stock | 34.37 | 34.6 | 34.13 | 34.45 | 139470.0 |
| 2005-08-19 | ABG | Stock | 17.56 | 17.65 | 17.41 | 17.53 | 25000.0 |
| 2005-08-19 | ABK-DELISTED | Stock | 67.52 | 67.92 | 67.23 | 67.48 | 709600.0 |
| 2005-08-19 | ABM | Stock | 18.9 | 19.21 | 18.76 | 19.13 | 90300.0 |
| 2005-08-19 | ABMD-DELISTED | Stock | 9.55 | 9.6 | 9.39 | 9.47 | 76618.0 |
| 2005-08-19 | ABP-DELISTED | Stock | 3.9 | 4.1 | 3.87 | 4.07 | 310500.0 |
| 2005-08-19 | ABR | Stock | 27.17 | 27.19 | 26.92 | 27.1 | 46000.0 |
| 2005-08-19 | ABT | Stock | 22.1812 | 22.2291 | 21.9652 | 21.9892 | 5114214.0 |
| 2005-08-19 | ABTL-DELISTED | Stock | 21.25 | 21.85 | 21.05 | 21.55 | 26385.0 |
| 2005-08-19 | ABV-DELISTED | Stock | 32.25 | 32.31 | 30.85 | 31.49 | 361500.0 |
| 2005-08-19 | ABVA-DELISTED | Stock | 16.6 | 16.6 | 16.3 | 16.3 | 1000.0 |
| 2005-08-19 | ABX-DELISTED | Stock | 26.27 | 26.36 | 26.0 | 26.27 | 1424581.0 |
| 2005-08-19 | ACAD | Stock | 8.54 | 9.03 | 8.54 | 8.88 | 39500.0 |
| 2005-08-19 | ACAP-DELISTED | Stock | 44.5 | 44.5 | 43.85 | 44.01 | 91253.0 |
| 2005-08-19 | ACAS-DELISTED | Stock | 36.96 | 37.76 | 36.93 | 37.62 | 591545.0 |
| 2005-08-19 | ACAT-DELISTED | Stock | 20.84 | 21.24 | 20.81 | 21.05 | 39515.0 |
| 2005-08-19 | ACC-DELISTED | Stock | 24.09 | 24.44 | 23.9 | 23.94 | 87142.0 |
| 2005-08-19 | ACCL-DELISTED | Stock | 5.4 | 5.4 | 5.25 | 5.31 | 42388.0 |
| 2005-08-19 | ACCO | Stock | 25.9 | 26.89 | 25.9 | 26.75 | 1122600.0 |
| 2005-08-19 | ACE-DELISTED | Stock | 45.02 | 45.28 | 44.83 | 45.13 | 573800.0 |
| 2005-08-19 | ACF-DELISTED | Stock | 25.19 | 25.27 | 24.97 | 25.1 | 744500.0 |
| 2005-08-19 | ACFC-DELISTED | Stock | 71.12 | 71.43 | 71.12 | 71.43 | 8465.0 |
| 2005-08-19 | ACG-DELISTED | Stock | 8.31 | 8.33 | 8.28 | 8.31 | 272800.0 |
| 2005-08-19 | ACGL | Stock | 5.1089 | 5.1144 | 5.0589 | 5.1 | 685800.0 |
| 2005-08-19 | ACGN-DELISTED | Stock | 532.6712 | 544.0 | 521.3288 | 532.6712 | 36200.0 |
> showing 50 of 4,163 rows — these rows as CSV