PREVIEW / stock_daily / 2005-08-16
file: by_date/stock_daily/2005/2005-08-16.parquet size: 139 KB rows: 4,165 symbols: 2,616
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-16 | AAPL | Stock | 1.6925 | 1.6964 | 1.6504 | 1.6518 | 537622400.0 |
| 2005-08-16 | MSFT | Stock | 27.03 | 27.14 | 26.7 | 26.74 | 46894600.0 |
| 2005-08-16 | NVDA | Stock | 0.2535 | 0.2557 | 0.2497 | 0.2516 | 637488000.0 |
| 2005-08-16 | AMZN | Stock | 2.245 | 2.247 | 2.21 | 2.2135 | 72502000.0 |
| 2005-08-16 | CL | Stock | 26.425 | 26.485 | 26.145 | 26.19 | 1746600.0 |
| 2005-08-16 | A | Stock | 21.1373 | 21.8026 | 21.123 | 21.8026 | 9891269.0 |
| 2005-08-16 | AABA-DELISTED | Stock | 34.5699996948242 | 34.6599998474121 | 34.2099990844727 | 34.2299995422363 | 11867100.0 |
| 2005-08-16 | AACC-DELISTED | Stock | 28.5 | 28.764 | 27.64 | 27.68 | 127830.0 |
| 2005-08-16 | AACQ-DELISTED | Stock | 5.05 | 5.05 | 5.05 | 5.05 | 3600.0 |
| 2005-08-16 | AACQU-DELISTED | Stock | 5.9 | 5.9 | 5.87 | 5.87 | 900.0 |
| 2005-08-16 | AACQW-DELISTED | Stock | 0.48 | 0.48 | 0.48 | 0.48 | 5000.0 |
| 2005-08-16 | AAI-DELISTED | Stock | 10.97 | 11.24 | 10.86 | 11.0 | 1451800.0 |
| 2005-08-16 | AAIC-DELISTED | Stock | 252.4 | 254.6 | 249.0 | 249.8 | 739500.0 |
| 2005-08-16 | AAME | Stock | 2.8 | 2.91 | 2.8 | 2.91 | 4600.0 |
| 2005-08-16 | AAON | Stock | 2.2519 | 2.2663 | 2.2229 | 2.2308 | 95681.0 |
| 2005-08-16 | AAP | Stock | 43.9067 | 43.9067 | 42.7933 | 42.9733 | 1824750.0 |
| 2005-08-16 | AATI-DELISTED | Stock | 13.0 | 13.25 | 12.75 | 12.95 | 134395.0 |
| 2005-08-16 | AAV-DELISTED | Stock | 15.6 | 15.78 | 15.52 | 15.6 | 45100.0 |
| 2005-08-16 | AAXN-DELISTED | Stock | 9.80000019073486 | 9.80000019073486 | 9.35000038146973 | 9.36999988555908 | 1685800.0 |
| 2005-08-16 | ABAX-DELISTED | Stock | 10.9 | 10.9 | 10.65 | 10.74 | 72691.0 |
| 2005-08-16 | ABB-DELISTED | Stock | 7.25 | 7.27 | 7.164 | 7.18 | 467700.0 |
| 2005-08-16 | ABBC-DELISTED | Stock | 12.6 | 12.6 | 12.5 | 12.57 | 15200.0 |
| 2005-08-16 | ABC-DELISTED | Stock | 18.21 | 18.23 | 18.1 | 18.1 | 1605200.0 |
| 2005-08-16 | ABCB | Stock | 18.0911 | 18.0911 | 17.8577 | 17.9161 | 13366.0 |
| 2005-08-16 | ABCO-DELISTED | Stock | 25.71 | 25.78 | 25.18 | 25.19 | 99776.0 |
| 2005-08-16 | ABCW-DELISTED | Stock | 30.08 | 30.33 | 30.03 | 30.04 | 108700.0 |
| 2005-08-16 | ABE-DELISTED | Stock | 10.65 | 10.73 | 10.51 | 10.51 | 10900.0 |
| 2005-08-16 | ABFS-DELISTED | Stock | 34.68 | 34.79 | 34.07 | 34.15 | 158839.0 |
| 2005-08-16 | ABG | Stock | 18.0 | 18.0 | 17.75 | 17.98 | 72500.0 |
| 2005-08-16 | ABK-DELISTED | Stock | 69.03 | 69.56 | 68.3 | 68.51 | 853800.0 |
| 2005-08-16 | ABM | Stock | 19.26 | 19.38 | 18.9 | 18.9 | 186200.0 |
| 2005-08-16 | ABMD-DELISTED | Stock | 9.86 | 9.94 | 9.65 | 9.7 | 84737.0 |
| 2005-08-16 | ABP-DELISTED | Stock | 4.59 | 4.59 | 4.4 | 4.42 | 146000.0 |
| 2005-08-16 | ABR | Stock | 27.17 | 27.23 | 26.99 | 27.13 | 80100.0 |
| 2005-08-16 | ABT | Stock | 22.4306 | 22.469 | 22.0612 | 22.0804 | 4922051.0 |
| 2005-08-16 | ABTL-DELISTED | Stock | 22.0 | 22.3 | 21.45 | 21.75 | 40076.0 |
| 2005-08-16 | ABV-DELISTED | Stock | 32.4 | 32.56 | 32.06 | 32.39 | 403300.0 |
| 2005-08-16 | ABVT-DELISTED | Stock | 25.0 | 25.0 | 25.0 | 25.0 | 800.0 |
| 2005-08-16 | ABX-DELISTED | Stock | 27.04 | 27.32 | 26.69 | 26.82 | 2146700.0 |
| 2005-08-16 | ACAD | Stock | 8.93 | 9.66 | 8.85 | 8.86 | 16600.0 |
| 2005-08-16 | ACAP-DELISTED | Stock | 42.75 | 43.85 | 42.6 | 43.52 | 97313.0 |
| 2005-08-16 | ACAS-DELISTED | Stock | 38.41 | 38.79 | 38.33 | 38.36 | 486836.0 |
| 2005-08-16 | ACAT-DELISTED | Stock | 20.55 | 21.09 | 20.55 | 20.76 | 47203.0 |
| 2005-08-16 | ACC-DELISTED | Stock | 24.14 | 24.49 | 24.05 | 24.2 | 43400.0 |
| 2005-08-16 | ACCL-DELISTED | Stock | 5.36 | 5.5 | 5.26 | 5.5 | 69733.0 |
| 2005-08-16 | ACE-DELISTED | Stock | 44.99 | 45.04 | 44.36 | 44.4 | 653882.0 |
| 2005-08-16 | ACF-DELISTED | Stock | 25.02 | 25.42 | 24.82 | 25.25 | 1266600.0 |
| 2005-08-16 | ACFC-DELISTED | Stock | 68.62 | 69.85 | 68.62 | 69.8 | 1916.0 |
| 2005-08-16 | ACG-DELISTED | Stock | 8.26 | 8.28 | 8.25 | 8.27 | 302900.0 |
| 2005-08-16 | ACGL | Stock | 5.1044 | 5.1289 | 5.0622 | 5.1022 | 398700.0 |
> showing 50 of 4,165 rows — these rows as CSV