PREVIEW / stock_daily / 2004-10-14
file: by_date/stock_daily/2004/2004-10-14.parquet size: 128 KB rows: 3,814 symbols: 2,372
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 |
|---|---|---|---|---|---|---|---|
| 2004-10-14 | AAPL | Stock | 0.7713 | 0.817 | 0.7598 | 0.8032 | 2768427200.0 |
| 2004-10-14 | MSFT | Stock | 28.04 | 28.16 | 27.8 | 27.8 | 41548700.0 |
| 2004-10-14 | NVDA | Stock | 0.1197 | 0.1197 | 0.1142 | 0.115 | 513264000.0 |
| 2004-10-14 | AMZN | Stock | 1.9725 | 1.9775 | 1.9365 | 1.955 | 180524000.0 |
| 2004-10-14 | CL | Stock | 21.85 | 21.85 | 21.61 | 21.725 | 6559600.0 |
| 2004-10-14 | A | Stock | 16.0443 | 16.0873 | 15.7082 | 15.8369 | 3488290.0 |
| 2004-10-14 | AABA-DELISTED | Stock | 34.9799995422363 | 35.1500015258789 | 34.2200012207031 | 34.9599990844727 | 22861600.0 |
| 2004-10-14 | AACC-DELISTED | Stock | 17.73 | 17.96 | 17.56 | 17.56 | 13100.0 |
| 2004-10-14 | AAI-DELISTED | Stock | 10.24 | 10.49 | 10.14 | 10.26 | 994400.0 |
| 2004-10-14 | AAIC-DELISTED | Stock | 392.2 | 394.0 | 385.4 | 385.8 | 1039800.0 |
| 2004-10-14 | AAME | Stock | 3.0 | 3.0 | 2.93 | 3.0 | 35500.0 |
| 2004-10-14 | AAON | Stock | 2.2466 | 2.2637 | 2.2137 | 2.215 | 41006.0 |
| 2004-10-14 | AAP | Stock | 23.0 | 23.0067 | 22.5267 | 22.5733 | 983850.0 |
| 2004-10-14 | AAV-DELISTED | Stock | 16.88 | 16.97 | 16.75 | 16.88 | 9900.0 |
| 2004-10-14 | AAXN-DELISTED | Stock | 18.8500003814697 | 19.125 | 18.6650009155273 | 18.7250003814697 | 3202800.0 |
| 2004-10-14 | ABAX-DELISTED | Stock | 12.58 | 12.6 | 11.61 | 12.25 | 207256.0 |
| 2004-10-14 | ABB-DELISTED | Stock | 6.13 | 6.13 | 6.01 | 6.1 | 161700.0 |
| 2004-10-14 | ABC-DELISTED | Stock | 13.19 | 13.3 | 13.18 | 13.19 | 4269200.0 |
| 2004-10-14 | ABCB | Stock | 16.0972 | 16.0972 | 15.927 | 15.927 | 20110.0 |
| 2004-10-14 | ABCO-DELISTED | Stock | 15.559 | 15.611 | 15.246 | 15.461 | 128711.0 |
| 2004-10-14 | ABCW-DELISTED | Stock | 26.16 | 26.18 | 25.72 | 25.76 | 58180.0 |
| 2004-10-14 | ABE-DELISTED | Stock | 8.1 | 8.14 | 7.96 | 8.03 | 9800.0 |
| 2004-10-14 | ABFS-DELISTED | Stock | 36.87 | 37.75 | 36.8 | 37.22 | 301133.0 |
| 2004-10-14 | ABG | Stock | 13.01 | 13.12 | 12.8 | 12.87 | 123000.0 |
| 2004-10-14 | ABK-DELISTED | Stock | 78.15 | 78.43 | 76.24 | 77.21 | 776400.0 |
| 2004-10-14 | ABM | Stock | 20.01 | 20.26 | 19.81 | 19.81 | 89600.0 |
| 2004-10-14 | ABMD-DELISTED | Stock | 9.3 | 9.48 | 9.1 | 9.15 | 285831.0 |
| 2004-10-14 | ABP-DELISTED | Stock | 2.18 | 2.2 | 2.1 | 2.13 | 86800.0 |
| 2004-10-14 | ABR | Stock | 21.58 | 21.6 | 21.22 | 21.39 | 17000.0 |
| 2004-10-14 | ABT | Stock | 19.8397 | 19.9741 | 19.6718 | 19.6766 | 7755315.0 |
| 2004-10-14 | ABTL-DELISTED | Stock | 47.3 | 48.05 | 47.15 | 47.15 | 109400.0 |
| 2004-10-14 | ABV-DELISTED | Stock | 23.55 | 23.75 | 23.45 | 23.51 | 346600.0 |
| 2004-10-14 | ABVA-DELISTED | Stock | 14.9 | 15.23 | 14.9 | 15.23 | 615.0 |
| 2004-10-14 | ABVT-DELISTED | Stock | 24.0 | 24.0 | 24.0 | 24.0 | 200.0 |
| 2004-10-14 | ABX-DELISTED | Stock | 20.57 | 20.73 | 20.37 | 20.38 | 1332764.0 |
| 2004-10-14 | ACAD | Stock | 7.34 | 7.75 | 7.26 | 7.75 | 4400.0 |
| 2004-10-14 | ACAP-DELISTED | Stock | 31.97 | 32.0 | 31.22 | 31.33 | 52549.0 |
| 2004-10-14 | ACAS-DELISTED | Stock | 31.56 | 31.59 | 30.65 | 30.69 | 615989.0 |
| 2004-10-14 | ACAT-DELISTED | Stock | 25.46 | 25.69 | 25.41 | 25.49 | 108906.0 |
| 2004-10-14 | ACC-DELISTED | Stock | 19.56 | 19.63 | 19.5 | 19.56 | 93858.0 |
| 2004-10-14 | ACCL-DELISTED | Stock | 5.98 | 6.06 | 5.8 | 5.82 | 70930.0 |
| 2004-10-14 | ACE-DELISTED | Stock | 40.11 | 40.14 | 35.65 | 36.47 | 7384500.0 |
| 2004-10-14 | ACF-DELISTED | Stock | 20.75 | 20.76 | 19.73 | 19.9 | 3487200.0 |
| 2004-10-14 | ACFC-DELISTED | Stock | 63.27 | 63.27 | 62.24 | 62.5 | 20271.0 |
| 2004-10-14 | ACG-DELISTED | Stock | 8.12 | 8.13 | 8.11 | 8.13 | 275500.0 |
| 2004-10-14 | ACGL | Stock | 4.1667 | 4.1867 | 4.0011 | 4.0089 | 2254500.0 |
| 2004-10-14 | ACGN-DELISTED | Stock | 623.3288 | 646.0 | 612.0 | 623.3288 | 92000.0 |
| 2004-10-14 | ACH | Stock | 16.4 | 16.62 | 16.2267 | 16.2267 | 169050.0 |
| 2004-10-14 | ACH-DELISTED | Stock | 14.625 | 14.982 | 14.625 | 14.667 | 590405.0 |
| 2004-10-14 | ACLS | Stock | 32.04 | 32.4 | 30.44 | 30.56 | 316925.0 |
> showing 50 of 3,814 rows — these rows as CSV