PREVIEW / stock_daily / 2008-03-20
file: by_date/stock_daily/2008/2008-03-20.parquet size: 181 KB rows: 5,651 symbols: 3,420
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 |
|---|---|---|---|---|---|---|---|
| 2008-03-20 | AAPL | Stock | 4.6829 | 4.7604 | 4.6136 | 4.7596 | 908787600.0 |
| 2008-03-20 | MSFT | Stock | 28.74 | 29.22 | 28.59 | 29.18 | 60170200.0 |
| 2008-03-20 | NVDA | Stock | 0.4468 | 0.464 | 0.4388 | 0.463 | 633460000.0 |
| 2008-03-20 | AMZN | Stock | 3.5085 | 3.6745 | 3.469 | 3.6595 | 228214000.0 |
| 2008-03-20 | TLT | Stock | 97.0 | 97.75 | 96.87 | 97.181 | 3905865.0 |
| 2008-03-20 | CL | Stock | 38.69 | 38.83 | 38.425 | 38.75 | 5673000.0 |
| 2008-03-20 | A | Stock | 21.123 | 21.2661 | 20.7582 | 21.216 | 6058233.0 |
| 2008-03-20 | AABA-DELISTED | Stock | 27.36 | 27.91 | 26.98 | 27.73 | 29309728.0 |
| 2008-03-20 | AACC-DELISTED | Stock | 9.03 | 9.22 | 8.95 | 9.13 | 305031.0 |
| 2008-03-20 | AACG | Stock | 10.14 | 10.75 | 9.35 | 9.54 | 20200.0 |
| 2008-03-20 | AAI-DELISTED | Stock | 6.34 | 6.34 | 5.94 | 6.09 | 2876120.0 |
| 2008-03-20 | AAIC-DELISTED | Stock | 36.4 | 40.8 | 34.2 | 40.0 | 3652775.0 |
| 2008-03-20 | AAON | Stock | 3.5951 | 3.7551 | 3.5378 | 3.7254 | 1290937.0 |
| 2008-03-20 | AAP | Stock | 33.08 | 34.4 | 33.05 | 34.16 | 1357400.0 |
| 2008-03-20 | AATI-DELISTED | Stock | 6.1 | 6.17 | 5.91 | 6.01 | 1280886.0 |
| 2008-03-20 | AAU-DELISTED | Stock | 2.39 | 2.41 | 2.26 | 2.3 | 80200.0 |
| 2008-03-20 | AAUAF-DELISTED | Stock | 2.39 | 2.41 | 2.26 | 2.3 | 81200.0 |
| 2008-03-20 | AAV-DELISTED | Stock | 10.67 | 10.87 | 10.36 | 10.55 | 846991.0 |
| 2008-03-20 | AAWW-DELISTED | Stock | 51.82 | 53.2 | 51.38 | 52.88 | 335426.0 |
| 2008-03-20 | AAXN-DELISTED | Stock | 9.84 | 9.84 | 9.37 | 9.64 | 1830517.0 |
| 2008-03-20 | AB | Stock | 59.76 | 64.81 | 59.7 | 64.44 | 428700.0 |
| 2008-03-20 | ABAX-DELISTED | Stock | 23.8 | 23.8 | 20.86 | 20.89 | 1338794.0 |
| 2008-03-20 | ABB-DELISTED | Stock | 23.99 | 24.29 | 23.7 | 24.24 | 5160598.0 |
| 2008-03-20 | ABBC-DELISTED | Stock | 10.19 | 10.3 | 10.0 | 10.19 | 164421.0 |
| 2008-03-20 | ABBNY-DELISTED | Stock | 23.99 | 24.29 | 23.7 | 24.21 | 5357598.0 |
| 2008-03-20 | ABC-DELISTED | Stock | 20.97 | 20.97 | 20.32 | 20.7 | 3873632.0 |
| 2008-03-20 | ABCB | Stock | 15.2705 | 16.0486 | 14.648 | 16.0292 | 289725.0 |
| 2008-03-20 | ABCO-DELISTED | Stock | 27.15 | 27.28 | 26.19 | 27.17 | 726018.0 |
| 2008-03-20 | ABCW-DELISTED | Stock | 18.53 | 19.591 | 18.28 | 19.46 | 314860.0 |
| 2008-03-20 | ABD-DELISTED | Stock | 13.84 | 14.21 | 13.41 | 14.08 | 1226900.0 |
| 2008-03-20 | ABE-DELISTED | Stock | 20.91 | 21.56 | 20.54 | 21.5 | 24320.0 |
| 2008-03-20 | ABEO | Stock | 2000.0 | 2000.0 | 1625.0 | 1812.5 | 28.0 |
| 2008-03-20 | ABFS-DELISTED | Stock | 31.18 | 33.74 | 30.97 | 33.46 | 1258201.0 |
| 2008-03-20 | ABG | Stock | 14.03 | 14.83 | 13.98 | 14.73 | 573100.0 |
| 2008-03-20 | ABII-DELISTED | Stock | 60.93 | 61.21 | 58.67 | 61.05 | 29415.0 |
| 2008-03-20 | ABK-DELISTED | Stock | 5.85 | 6.85 | 5.65 | 6.8 | 14723852.0 |
| 2008-03-20 | ABM | Stock | 20.94 | 21.43 | 20.51 | 21.35 | 609500.0 |
| 2008-03-20 | ABMD-DELISTED | Stock | 13.71 | 13.81 | 13.29 | 13.46 | 502541.0 |
| 2008-03-20 | ABP-DELISTED | Stock | 3.15 | 3.29 | 3.12 | 3.22 | 176955.0 |
| 2008-03-20 | ABR | Stock | 16.25 | 16.93 | 16.15 | 16.76 | 412700.0 |
| 2008-03-20 | ABT | Stock | 26.2355 | 26.7632 | 26.1155 | 26.7057 | 25449145.0 |
| 2008-03-20 | ABTL-DELISTED | Stock | 10.142 | 10.142 | 9.603 | 9.75 | 17228.0 |
| 2008-03-20 | ABV-DELISTED | Stock | 77.84 | 77.84 | 74.97 | 76.95 | 745994.0 |
| 2008-03-20 | ABVA-DELISTED | Stock | 5.1 | 5.1 | 4.98 | 5.1 | 57085.0 |
| 2008-03-20 | ABVT-DELISTED | Stock | 70.0 | 70.0 | 70.0 | 70.0 | 100.0 |
| 2008-03-20 | ABX-DELISTED | Stock | 43.59 | 43.68 | 41.54 | 42.09 | 24329648.0 |
| 2008-03-20 | ACAD | Stock | 8.39 | 9.07 | 8.3 | 9.0 | 776100.0 |
| 2008-03-20 | ACAP-DELISTED | Stock | 45.86 | 47.24 | 45.71 | 47.11 | 177962.0 |
| 2008-03-20 | ACAS-DELISTED | Stock | 35.37 | 36.45 | 34.97 | 36.38 | 2892813.0 |
| 2008-03-20 | ACAT-DELISTED | Stock | 7.57 | 7.67 | 7.33 | 7.56 | 275552.0 |
> showing 50 of 5,651 rows — these rows as CSV