PREVIEW / stock_daily / 2005-08-18
file: by_date/stock_daily/2005/2005-08-18.parquet size: 140 KB rows: 4,166 symbols: 2,610
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-18 | AAPL | Stock | 1.6754 | 1.6786 | 1.6339 | 1.6536 | 442559600.0 |
| 2005-08-18 | MSFT | Stock | 26.89 | 27.08 | 26.8 | 26.82 | 40861900.0 |
| 2005-08-18 | NVDA | Stock | 0.2497 | 0.2509 | 0.244 | 0.2451 | 822732000.0 |
| 2005-08-18 | AMZN | Stock | 2.194 | 2.195 | 2.1755 | 2.1865 | 72086000.0 |
| 2005-08-18 | CL | Stock | 25.935 | 26.5 | 25.925 | 26.375 | 3597200.0 |
| 2005-08-18 | A | Stock | 21.9957 | 22.2103 | 21.9599 | 22.103 | 7106873.0 |
| 2005-08-18 | AABA-DELISTED | Stock | 34.1300010681152 | 34.7299995422363 | 34.1199989318848 | 34.3600006103516 | 12154200.0 |
| 2005-08-18 | AACC-DELISTED | Stock | 27.61 | 28.25 | 27.576 | 28.0 | 123391.0 |
| 2005-08-18 | AACQ-DELISTED | Stock | 5.09 | 5.15 | 5.09 | 5.09 | 22500.0 |
| 2005-08-18 | AACQU-DELISTED | Stock | 6.0 | 6.05 | 6.0 | 6.05 | 4000.0 |
| 2005-08-18 | AAI-DELISTED | Stock | 11.08 | 11.2 | 10.86 | 10.89 | 1325000.0 |
| 2005-08-18 | AAIC-DELISTED | Stock | 241.0 | 241.2 | 237.0 | 239.6 | 1641000.0 |
| 2005-08-18 | AAME | Stock | 2.77 | 2.83 | 2.77 | 2.83 | 2000.0 |
| 2005-08-18 | AAON | Stock | 2.2519 | 2.2887 | 2.2387 | 2.2769 | 243000.0 |
| 2005-08-18 | AAP | Stock | 43.6 | 43.7333 | 43.36 | 43.66 | 1378050.0 |
| 2005-08-18 | AATI-DELISTED | Stock | 13.13 | 13.15 | 12.9 | 13.0 | 286132.0 |
| 2005-08-18 | AAV-DELISTED | Stock | 15.18 | 15.3 | 15.11 | 15.18 | 72300.0 |
| 2005-08-18 | AAXN-DELISTED | Stock | 9.31999969482422 | 9.47999954223633 | 9.14999961853027 | 9.22999954223633 | 1419500.0 |
| 2005-08-18 | ABAX-DELISTED | Stock | 10.94 | 11.37 | 10.79 | 11.02 | 104385.0 |
| 2005-08-18 | ABB-DELISTED | Stock | 7.01 | 7.01 | 6.93 | 6.96 | 928300.0 |
| 2005-08-18 | ABBC-DELISTED | Stock | 12.55 | 12.58 | 12.55 | 12.58 | 11100.0 |
| 2005-08-18 | ABC-DELISTED | Stock | 18.07 | 18.22 | 18.0 | 18.17 | 1593600.0 |
| 2005-08-18 | ABCB | Stock | 17.8675 | 18.1397 | 17.7507 | 17.9064 | 26731.0 |
| 2005-08-18 | ABCO-DELISTED | Stock | 25.62 | 25.62 | 25.03 | 25.43 | 114464.0 |
| 2005-08-18 | ABCW-DELISTED | Stock | 30.0 | 30.26 | 30.0 | 30.01 | 43160.0 |
| 2005-08-18 | ABD-DELISTED | Stock | 24.3 | 26.55 | 24.25 | 26.33 | 2139580.0 |
| 2005-08-18 | ABE-DELISTED | Stock | 10.54 | 10.55 | 10.4 | 10.55 | 7400.0 |
| 2005-08-18 | ABFS-DELISTED | Stock | 34.21 | 34.47 | 33.86 | 34.37 | 113346.0 |
| 2005-08-18 | ABG | Stock | 17.58 | 17.7 | 17.15 | 17.55 | 60400.0 |
| 2005-08-18 | ABK-DELISTED | Stock | 67.9 | 67.9 | 67.21 | 67.51 | 995600.0 |
| 2005-08-18 | ABM | Stock | 18.98 | 19.09 | 18.77 | 18.94 | 123800.0 |
| 2005-08-18 | ABMD-DELISTED | Stock | 9.58 | 9.71 | 9.5 | 9.61 | 75831.0 |
| 2005-08-18 | ABP-DELISTED | Stock | 3.88 | 3.9 | 3.65 | 3.84 | 462800.0 |
| 2005-08-18 | ABR | Stock | 27.1 | 27.55 | 26.95 | 27.18 | 189600.0 |
| 2005-08-18 | ABT | Stock | 22.0468 | 22.2867 | 22.0372 | 22.0804 | 4933722.0 |
| 2005-08-18 | ABTL-DELISTED | Stock | 21.53 | 21.72 | 20.98 | 21.37 | 33298.0 |
| 2005-08-18 | ABV-DELISTED | Stock | 32.85 | 32.89 | 32.0 | 32.0 | 234100.0 |
| 2005-08-18 | ABVA-DELISTED | Stock | 16.5 | 16.52 | 16.5 | 16.5 | 2205.0 |
| 2005-08-18 | ABX-DELISTED | Stock | 26.29 | 26.44 | 26.02 | 26.29 | 2346172.0 |
| 2005-08-18 | ACAD | Stock | 8.65 | 8.73 | 8.56 | 8.56 | 85900.0 |
| 2005-08-18 | ACAP-DELISTED | Stock | 43.81 | 44.37 | 43.77 | 44.3 | 44509.0 |
| 2005-08-18 | ACAS-DELISTED | Stock | 37.0 | 37.08 | 36.55 | 36.96 | 919017.0 |
| 2005-08-18 | ACAT-DELISTED | Stock | 20.97 | 21.1 | 20.47 | 20.92 | 128348.0 |
| 2005-08-18 | ACC-DELISTED | Stock | 24.08 | 24.32 | 23.91 | 24.12 | 113107.0 |
| 2005-08-18 | ACCL-DELISTED | Stock | 5.3 | 5.39 | 5.22 | 5.37 | 64757.0 |
| 2005-08-18 | ACCO | Stock | 24.3 | 26.55 | 24.25 | 26.33 | 2172500.0 |
| 2005-08-18 | ACE-DELISTED | Stock | 44.4 | 44.92 | 44.26 | 44.6 | 572900.0 |
| 2005-08-18 | ACF-DELISTED | Stock | 25.07 | 25.29 | 24.87 | 25.11 | 954700.0 |
| 2005-08-18 | ACFC-DELISTED | Stock | 71.22 | 71.43 | 70.36 | 71.22 | 3366.0 |
| 2005-08-18 | ACG-DELISTED | Stock | 8.25 | 8.3 | 8.24 | 8.29 | 322900.0 |
> showing 50 of 4,166 rows — these rows as CSV