PREVIEW / stock_daily / 2005-09-20
file: by_date/stock_daily/2005/2005-09-20.parquet size: 140 KB rows: 4,176 symbols: 2,625
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-09-20 | AAPL | Stock | 1.8925 | 1.9218 | 1.89 | 1.8996 | 819828800.0 |
| 2005-09-20 | MSFT | Stock | 26.07 | 26.22 | 25.69 | 25.84 | 61043400.0 |
| 2005-09-20 | NVDA | Stock | 0.2752 | 0.2816 | 0.2749 | 0.2785 | 522192000.0 |
| 2005-09-20 | AMZN | Stock | 2.1325 | 2.1505 | 2.0885 | 2.0935 | 69440000.0 |
| 2005-09-20 | CL | Stock | 26.405 | 26.525 | 26.195 | 26.295 | 3128000.0 |
| 2005-09-20 | A | Stock | 24.1917 | 24.6423 | 24.1917 | 24.3419 | 5504765.0 |
| 2005-09-20 | AABA-DELISTED | Stock | 32.8800010681152 | 33.1100006103516 | 32.3600006103516 | 32.6399993896484 | 14578900.0 |
| 2005-09-20 | AACC-DELISTED | Stock | 30.08 | 30.2 | 29.6 | 29.65 | 109944.0 |
| 2005-09-20 | AACQ-DELISTED | Stock | 5.1 | 5.1 | 5.1 | 5.1 | 22800.0 |
| 2005-09-20 | AACQU-DELISTED | Stock | 6.3 | 6.3 | 6.3 | 6.3 | 12000.0 |
| 2005-09-20 | AACQW-DELISTED | Stock | 0.62 | 0.62 | 0.61 | 0.62 | 85000.0 |
| 2005-09-20 | AAI-DELISTED | Stock | 10.53 | 10.93 | 10.32 | 10.38 | 1129900.0 |
| 2005-09-20 | AAIC-DELISTED | Stock | 222.2 | 232.0 | 222.2 | 227.0 | 1545600.0 |
| 2005-09-20 | AAME | Stock | 2.66 | 3.0 | 2.66 | 3.0 | 700.0 |
| 2005-09-20 | AAON | Stock | 2.3849 | 2.3849 | 2.3282 | 2.348 | 75178.0 |
| 2005-09-20 | AAP | Stock | 39.4333 | 39.9867 | 38.7067 | 38.88 | 609150.0 |
| 2005-09-20 | AATI-DELISTED | Stock | 12.52 | 12.7 | 12.3 | 12.42 | 85136.0 |
| 2005-09-20 | AAV-DELISTED | Stock | 18.02 | 18.09 | 17.84 | 18.02 | 36700.0 |
| 2005-09-20 | AAXN-DELISTED | Stock | 7.55000019073486 | 7.65000009536743 | 7.3899998664856 | 7.42000007629395 | 1584200.0 |
| 2005-09-20 | ABAX-DELISTED | Stock | 12.89 | 13.11 | 12.76 | 13.0 | 98932.0 |
| 2005-09-20 | ABB-DELISTED | Stock | 7.31 | 7.35 | 7.22 | 7.23 | 474000.0 |
| 2005-09-20 | ABBC-DELISTED | Stock | 12.67 | 12.67 | 12.47 | 12.59 | 5733.0 |
| 2005-09-20 | ABC-DELISTED | Stock | 19.44 | 19.69 | 19.4 | 19.48 | 3283200.0 |
| 2005-09-20 | ABCB | Stock | 17.9842 | 18.2371 | 17.566 | 17.741 | 17787.0 |
| 2005-09-20 | ABCO-DELISTED | Stock | 26.32 | 26.37 | 24.99 | 25.48 | 309478.0 |
| 2005-09-20 | ABCW-DELISTED | Stock | 30.01 | 30.27 | 29.62 | 29.62 | 68660.0 |
| 2005-09-20 | ABD-DELISTED | Stock | 28.14 | 28.14 | 27.54 | 27.62 | 471900.0 |
| 2005-09-20 | ABE-DELISTED | Stock | 10.96 | 10.99 | 10.94 | 10.95 | 16800.0 |
| 2005-09-20 | ABFS-DELISTED | Stock | 32.65 | 33.19 | 32.35 | 32.44 | 286047.0 |
| 2005-09-20 | ABG | Stock | 17.28 | 17.73 | 17.12 | 17.24 | 81700.0 |
| 2005-09-20 | ABK-DELISTED | Stock | 70.3 | 70.68 | 68.86 | 69.01 | 576700.0 |
| 2005-09-20 | ABM | Stock | 20.75 | 20.9 | 20.57 | 20.75 | 194600.0 |
| 2005-09-20 | ABMD-DELISTED | Stock | 10.48 | 10.7 | 10.3 | 10.33 | 33155.0 |
| 2005-09-20 | ABP-DELISTED | Stock | 5.55 | 5.6 | 5.17 | 5.2 | 923600.0 |
| 2005-09-20 | ABR | Stock | 28.9 | 29.05 | 28.12 | 28.36 | 159600.0 |
| 2005-09-20 | ABT | Stock | 20.7801 | 20.9912 | 20.6602 | 20.6746 | 8488745.0 |
| 2005-09-20 | ABTL-DELISTED | Stock | 25.05 | 25.4 | 25.0 | 25.15 | 34892.0 |
| 2005-09-20 | ABV-DELISTED | Stock | 35.35 | 35.52 | 34.76 | 35.11 | 245600.0 |
| 2005-09-20 | ABVA-DELISTED | Stock | 16.2 | 16.49 | 16.2 | 16.2 | 7350.0 |
| 2005-09-20 | ABX-DELISTED | Stock | 28.85 | 29.18 | 28.2 | 28.32 | 3051400.0 |
| 2005-09-20 | ACAD | Stock | 11.14 | 11.31 | 11.14 | 11.31 | 129400.0 |
| 2005-09-20 | ACAP-DELISTED | Stock | 46.66 | 47.0 | 46.15 | 46.61 | 68935.0 |
| 2005-09-20 | ACAS-DELISTED | Stock | 37.18 | 37.35 | 37.03 | 37.05 | 696290.0 |
| 2005-09-20 | ACAT-DELISTED | Stock | 20.96 | 21.08 | 19.97 | 20.03 | 509191.0 |
| 2005-09-20 | ACC-DELISTED | Stock | 23.0 | 23.15 | 22.65 | 22.78 | 102400.0 |
| 2005-09-20 | ACCL-DELISTED | Stock | 6.23 | 6.49 | 6.1 | 6.47 | 123602.0 |
| 2005-09-20 | ACCO | Stock | 28.14 | 28.14 | 27.54 | 27.62 | 474600.0 |
| 2005-09-20 | ACE-DELISTED | Stock | 46.12 | 46.78 | 45.64 | 45.7 | 1108716.0 |
| 2005-09-20 | ACF-DELISTED | Stock | 24.9 | 25.07 | 24.67 | 24.86 | 1065100.0 |
| 2005-09-20 | ACFC-DELISTED | Stock | 70.61 | 71.53 | 70.51 | 71.48 | 952.0 |
> showing 50 of 4,176 rows — these rows as CSV