PREVIEW / stock_daily / 2005-08-24
file: by_date/stock_daily/2005/2005-08-24.parquet size: 139 KB rows: 4,175 symbols: 2,627
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-24 | AAPL | Stock | 1.6286 | 1.6829 | 1.6282 | 1.6346 | 572070800.0 |
| 2005-08-24 | MSFT | Stock | 26.84 | 27.16 | 26.78 | 26.81 | 63645000.0 |
| 2005-08-24 | NVDA | Stock | 0.2413 | 0.2482 | 0.2402 | 0.2431 | 514620000.0 |
| 2005-08-24 | AMZN | Stock | 2.166 | 2.166 | 2.1135 | 2.1185 | 117438000.0 |
| 2005-08-24 | CL | Stock | 26.48 | 26.635 | 26.12 | 26.325 | 5822000.0 |
| 2005-08-24 | A | Stock | 21.4592 | 22.0029 | 21.4592 | 21.5665 | 6360481.0 |
| 2005-08-24 | AABA-DELISTED | Stock | 32.9199981689453 | 33.6800003051758 | 32.8800010681152 | 33.4700012207031 | 23249500.0 |
| 2005-08-24 | AACC-DELISTED | Stock | 28.17 | 30.04 | 28.17 | 28.72 | 205970.0 |
| 2005-08-24 | AACQ-DELISTED | Stock | 5.1 | 5.1 | 5.1 | 5.1 | 2000.0 |
| 2005-08-24 | AACQW-DELISTED | Stock | 0.48 | 0.48 | 0.48 | 0.48 | 5000.0 |
| 2005-08-24 | AAI-DELISTED | Stock | 10.81 | 10.97 | 10.59 | 10.63 | 790800.0 |
| 2005-08-24 | AAIC-DELISTED | Stock | 234.8 | 239.6 | 234.4 | 234.6 | 810000.0 |
| 2005-08-24 | AAME | Stock | 3.01 | 3.01 | 3.0 | 3.0 | 2100.0 |
| 2005-08-24 | AAON | Stock | 2.3164 | 2.3401 | 2.3045 | 2.3243 | 354628.0 |
| 2005-08-24 | AAP | Stock | 41.4267 | 41.9933 | 41.34 | 41.54 | 1589100.0 |
| 2005-08-24 | AATI-DELISTED | Stock | 12.45 | 12.88 | 12.38 | 12.88 | 190889.0 |
| 2005-08-24 | AAV-DELISTED | Stock | 16.3 | 16.3 | 16.08 | 16.3 | 110900.0 |
| 2005-08-24 | AAXN-DELISTED | Stock | 9.14000034332275 | 9.14000034332275 | 8.97999954223633 | 8.97999954223633 | 1254800.0 |
| 2005-08-24 | ABAX-DELISTED | Stock | 10.94 | 11.175 | 10.87 | 10.92 | 54018.0 |
| 2005-08-24 | ABB-DELISTED | Stock | 7.09 | 7.16 | 7.04 | 7.07 | 495200.0 |
| 2005-08-24 | ABBC-DELISTED | Stock | 12.71 | 12.8 | 12.71 | 12.8 | 9550.0 |
| 2005-08-24 | ABC-DELISTED | Stock | 17.62 | 17.8 | 17.49 | 17.58 | 3629200.0 |
| 2005-08-24 | ABCB | Stock | 18.1787 | 18.3343 | 18.0328 | 18.0328 | 3496.0 |
| 2005-08-24 | ABCO-DELISTED | Stock | 25.42 | 25.69 | 25.31 | 25.4 | 230001.0 |
| 2005-08-24 | ABCW-DELISTED | Stock | 30.03 | 30.25 | 29.56 | 29.63 | 55630.0 |
| 2005-08-24 | ABD-DELISTED | Stock | 24.59 | 25.19 | 24.51 | 24.64 | 1330590.0 |
| 2005-08-24 | ABE-DELISTED | Stock | 10.43 | 10.43 | 10.21 | 10.27 | 27300.0 |
| 2005-08-24 | ABFS-DELISTED | Stock | 33.7 | 34.48 | 33.64 | 34.0 | 246466.0 |
| 2005-08-24 | ABG | Stock | 17.73 | 17.84 | 17.48 | 17.48 | 22200.0 |
| 2005-08-24 | ABK-DELISTED | Stock | 68.05 | 68.55 | 68.02 | 68.15 | 712200.0 |
| 2005-08-24 | ABM | Stock | 19.22 | 19.76 | 19.18 | 19.18 | 121500.0 |
| 2005-08-24 | ABMD-DELISTED | Stock | 9.37 | 9.58 | 9.32 | 9.39 | 54772.0 |
| 2005-08-24 | ABP-DELISTED | Stock | 4.54 | 4.59 | 4.4 | 4.56 | 279500.0 |
| 2005-08-24 | ABR | Stock | 27.26 | 27.83 | 27.17 | 27.61 | 346500.0 |
| 2005-08-24 | ABT | Stock | 21.8069 | 22.018 | 21.4471 | 21.5526 | 7470821.0 |
| 2005-08-24 | ABTL-DELISTED | Stock | 23.1 | 23.5 | 22.1 | 23.05 | 25395.0 |
| 2005-08-24 | ABV-DELISTED | Stock | 31.6 | 31.68 | 31.01 | 31.21 | 318900.0 |
| 2005-08-24 | ABVA-DELISTED | Stock | 17.06 | 17.06 | 16.93 | 16.93 | 725.0 |
| 2005-08-24 | ABVT-DELISTED | Stock | 25.0 | 25.0 | 25.0 | 25.0 | 200.0 |
| 2005-08-24 | ABX-DELISTED | Stock | 26.27 | 26.52 | 25.52 | 25.55 | 2799400.0 |
| 2005-08-24 | ACAD | Stock | 9.26 | 9.52 | 9.26 | 9.46 | 56400.0 |
| 2005-08-24 | ACAP-DELISTED | Stock | 44.27 | 44.8 | 43.91 | 44.1 | 49227.0 |
| 2005-08-24 | ACAS-DELISTED | Stock | 38.39 | 38.47 | 37.45 | 37.51 | 708258.0 |
| 2005-08-24 | ACAT-DELISTED | Stock | 20.76 | 21.51 | 20.76 | 21.15 | 52211.0 |
| 2005-08-24 | ACC-DELISTED | Stock | 23.95 | 24.05 | 23.8 | 23.81 | 138600.0 |
| 2005-08-24 | ACCL-DELISTED | Stock | 5.33 | 5.36 | 5.26 | 5.35 | 59792.0 |
| 2005-08-24 | ACCO | Stock | 24.8 | 25.4 | 24.64 | 24.64 | 1372900.0 |
| 2005-08-24 | ACE-DELISTED | Stock | 45.16 | 45.44 | 44.56 | 44.64 | 495400.0 |
| 2005-08-24 | ACF-DELISTED | Stock | 25.53 | 25.95 | 25.41 | 25.63 | 1332800.0 |
| 2005-08-24 | ACFC-DELISTED | Stock | 71.48 | 72.96 | 71.48 | 72.04 | 5911.0 |
> showing 50 of 4,175 rows — these rows as CSV