PREVIEW / stock_daily / 2005-09-12
file: by_date/stock_daily/2005/2005-09-12.parquet size: 140 KB rows: 4,177 symbols: 2,628
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-12 | AAPL | Stock | 1.825 | 1.8439 | 1.8064 | 1.8357 | 452796400.0 |
| 2005-09-12 | MSFT | Stock | 26.62 | 26.75 | 26.52 | 26.61 | 40550500.0 |
| 2005-09-12 | NVDA | Stock | 0.2685 | 0.2693 | 0.2642 | 0.2673 | 556584000.0 |
| 2005-09-12 | AMZN | Stock | 2.136 | 2.248 | 2.1345 | 2.225 | 175588000.0 |
| 2005-09-12 | CL | Stock | 26.625 | 26.685 | 26.455 | 26.55 | 2329000.0 |
| 2005-09-12 | A | Stock | 23.4478 | 23.927 | 23.3548 | 23.834 | 6997829.0 |
| 2005-09-12 | AABA-DELISTED | Stock | 33.4199981689453 | 34.3400001525879 | 33.4099998474121 | 33.9099998474121 | 18580300.0 |
| 2005-09-12 | AACC-DELISTED | Stock | 30.42 | 31.19 | 30.29 | 30.8 | 147624.0 |
| 2005-09-12 | AACQ-DELISTED | Stock | 5.11 | 5.15 | 5.09 | 5.15 | 13500.0 |
| 2005-09-12 | AACQU-DELISTED | Stock | 6.25 | 6.25 | 6.25 | 6.25 | 1000.0 |
| 2005-09-12 | AACQW-DELISTED | Stock | 0.64 | 0.64 | 0.64 | 0.64 | 14000.0 |
| 2005-09-12 | AAI-DELISTED | Stock | 10.31 | 10.98 | 10.3 | 10.88 | 1293300.0 |
| 2005-09-12 | AAIC-DELISTED | Stock | 234.0 | 237.2 | 232.22 | 232.6 | 578400.0 |
| 2005-09-12 | AAON | Stock | 2.3704 | 2.3704 | 2.348 | 2.3625 | 44044.0 |
| 2005-09-12 | AAP | Stock | 40.5667 | 42.08 | 40.5667 | 41.6533 | 1220250.0 |
| 2005-09-12 | AATI-DELISTED | Stock | 13.45 | 13.65 | 13.15 | 13.5 | 145626.0 |
| 2005-09-12 | AAV-DELISTED | Stock | 17.07 | 17.2 | 16.92 | 17.07 | 52500.0 |
| 2005-09-12 | AAXN-DELISTED | Stock | 8.1899995803833 | 8.1899995803833 | 7.84000015258789 | 7.86999988555908 | 3075200.0 |
| 2005-09-12 | ABAX-DELISTED | Stock | 12.7 | 13.45 | 12.68 | 13.18 | 162501.0 |
| 2005-09-12 | ABB-DELISTED | Stock | 7.44 | 7.46 | 7.39 | 7.44 | 595400.0 |
| 2005-09-12 | ABBC-DELISTED | Stock | 12.88 | 13.0 | 12.8 | 13.0 | 16913.0 |
| 2005-09-12 | ABC-DELISTED | Stock | 18.68 | 18.95 | 18.62 | 18.81 | 2980400.0 |
| 2005-09-12 | ABCB | Stock | 19.4139 | 19.4529 | 18.8693 | 19.4529 | 17273.0 |
| 2005-09-12 | ABCO-DELISTED | Stock | 26.02 | 26.28 | 25.92 | 26.06 | 142330.0 |
| 2005-09-12 | ABCW-DELISTED | Stock | 30.92 | 31.44 | 30.51 | 31.28 | 27060.0 |
| 2005-09-12 | ABD-DELISTED | Stock | 26.25 | 27.0 | 26.25 | 26.9 | 404920.0 |
| 2005-09-12 | ABE-DELISTED | Stock | 10.87 | 10.88 | 10.83 | 10.83 | 22400.0 |
| 2005-09-12 | ABFS-DELISTED | Stock | 33.54 | 33.83 | 33.29 | 33.33 | 275794.0 |
| 2005-09-12 | ABG | Stock | 17.37 | 18.0 | 17.31 | 17.8 | 130600.0 |
| 2005-09-12 | ABK-DELISTED | Stock | 67.46 | 68.61 | 67.14 | 68.44 | 791900.0 |
| 2005-09-12 | ABM | Stock | 20.56 | 21.43 | 20.4 | 21.35 | 425100.0 |
| 2005-09-12 | ABMD-DELISTED | Stock | 10.41 | 10.6 | 10.22 | 10.54 | 72663.0 |
| 2005-09-12 | ABP-DELISTED | Stock | 4.5 | 4.62 | 4.48 | 4.59 | 160200.0 |
| 2005-09-12 | ABR | Stock | 28.29 | 28.99 | 28.21 | 28.84 | 115500.0 |
| 2005-09-12 | ABT | Stock | 21.6918 | 22.1668 | 21.543 | 21.7014 | 7581284.0 |
| 2005-09-12 | ABTL-DELISTED | Stock | 24.83 | 25.82 | 24.38 | 25.72 | 45405.0 |
| 2005-09-12 | ABV-DELISTED | Stock | 35.5 | 35.78 | 35.18 | 35.68 | 228100.0 |
| 2005-09-12 | ABVA-DELISTED | Stock | 16.5 | 16.5 | 16.2 | 16.2 | 680.0 |
| 2005-09-12 | ABX-DELISTED | Stock | 27.84 | 27.85 | 27.5099 | 27.81 | 2262086.0 |
| 2005-09-12 | ACAD | Stock | 11.08 | 11.14 | 10.98 | 11.04 | 126200.0 |
| 2005-09-12 | ACAP-DELISTED | Stock | 44.84 | 45.3 | 44.84 | 44.98 | 17496.0 |
| 2005-09-12 | ACAS-DELISTED | Stock | 37.67 | 37.94 | 37.47 | 37.75 | 480914.0 |
| 2005-09-12 | ACAT-DELISTED | Stock | 20.97 | 21.77 | 20.76 | 21.33 | 50865.0 |
| 2005-09-12 | ACC-DELISTED | Stock | 23.02 | 23.51 | 23.0 | 23.39 | 48200.0 |
| 2005-09-12 | ACCL-DELISTED | Stock | 5.69 | 6.05 | 5.65 | 5.9701 | 152169.0 |
| 2005-09-12 | ACCO | Stock | 26.2 | 26.95 | 26.2 | 26.95 | 405500.0 |
| 2005-09-12 | ACE-DELISTED | Stock | 43.96 | 44.91 | 43.76 | 44.85 | 1625200.0 |
| 2005-09-12 | ACF-DELISTED | Stock | 25.25 | 25.75 | 25.15 | 25.4 | 1116000.0 |
| 2005-09-12 | ACFC-DELISTED | Stock | 73.67 | 73.67 | 72.7 | 72.7 | 894.0 |
| 2005-09-12 | ACG-DELISTED | Stock | 8.33 | 8.33 | 8.31 | 8.32 | 278600.0 |
> showing 50 of 4,177 rows — these rows as CSV