PREVIEW / stock_daily / 2004-09-02
file: by_date/stock_daily/2004/2004-09-02.parquet size: 127 KB rows: 3,794 symbols: 2,360
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-09-02 | AAPL | Stock | 0.6339 | 0.6395 | 0.622 | 0.6368 | 406324800.0 |
| 2004-09-02 | MSFT | Stock | 27.4 | 27.68 | 27.35 | 27.62 | 42161700.0 |
| 2004-09-02 | NVDA | Stock | 0.1063 | 0.111 | 0.1053 | 0.1102 | 770088000.0 |
| 2004-09-02 | AMZN | Stock | 1.902 | 1.982 | 1.8955 | 1.959 | 114446000.0 |
| 2004-09-02 | CL | Stock | 27.25 | 27.53 | 27.14 | 27.455 | 2601400.0 |
| 2004-09-02 | A | Stock | 14.8069 | 15.2361 | 14.5708 | 15.1645 | 2676471.0 |
| 2004-09-02 | AABA-DELISTED | Stock | 28.7000007629395 | 30.1599998474121 | 28.6599998474121 | 29.8400001525879 | 17247700.0 |
| 2004-09-02 | AACC-DELISTED | Stock | 17.61 | 17.94 | 17.35 | 17.44 | 25752.0 |
| 2004-09-02 | AAI-DELISTED | Stock | 12.1 | 12.39 | 12.09 | 12.32 | 837800.0 |
| 2004-09-02 | AAIC-DELISTED | Stock | 374.8 | 379.2 | 370.8 | 376.6 | 992800.0 |
| 2004-09-02 | AAME | Stock | 3.02 | 3.02 | 3.02 | 3.02 | 100.0 |
| 2004-09-02 | AAON | Stock | 2.2268 | 2.3006 | 2.1794 | 2.2927 | 55434.0 |
| 2004-09-02 | AAP | Stock | 24.8933 | 24.8933 | 24.6467 | 24.74 | 1478100.0 |
| 2004-09-02 | AAV-DELISTED | Stock | 15.39 | 15.41 | 15.05 | 15.39 | 10900.0 |
| 2004-09-02 | AAXN-DELISTED | Stock | 13.875 | 16.1049995422363 | 13.789999961853 | 15.8199996948242 | 32422600.0 |
| 2004-09-02 | ABAX-DELISTED | Stock | 14.85 | 15.15 | 14.85 | 15.13 | 54264.0 |
| 2004-09-02 | ABB-DELISTED | Stock | 5.78 | 5.85 | 5.75 | 5.83 | 81000.0 |
| 2004-09-02 | ABC-DELISTED | Stock | 13.86 | 14.17 | 13.8 | 14.14 | 8039200.0 |
| 2004-09-02 | ABCB | Stock | 14.5896 | 14.7517 | 14.3302 | 14.5896 | 9377.0 |
| 2004-09-02 | ABCO-DELISTED | Stock | 15.995 | 16.165 | 15.955 | 16.125 | 90666.0 |
| 2004-09-02 | ABCW-DELISTED | Stock | 25.44 | 25.96 | 25.3 | 25.95 | 21660.0 |
| 2004-09-02 | ABE-DELISTED | Stock | 7.78 | 7.78 | 7.7 | 7.75 | 14800.0 |
| 2004-09-02 | ABFS-DELISTED | Stock | 34.2 | 35.23 | 34.0 | 35.15 | 283062.0 |
| 2004-09-02 | ABG | Stock | 13.33 | 14.0 | 13.33 | 13.8 | 41800.0 |
| 2004-09-02 | ABK-DELISTED | Stock | 75.3 | 76.36 | 74.95 | 76.35 | 214100.0 |
| 2004-09-02 | ABM | Stock | 18.25 | 18.77 | 18.25 | 18.73 | 88100.0 |
| 2004-09-02 | ABMD-DELISTED | Stock | 10.12 | 10.5 | 9.85 | 10.43 | 42373.0 |
| 2004-09-02 | ABP-DELISTED | Stock | 1.6 | 1.68 | 1.58 | 1.63 | 46800.0 |
| 2004-09-02 | ABR | Stock | 20.8 | 20.8 | 20.7 | 20.75 | 30100.0 |
| 2004-09-02 | ABT | Stock | 20.1804 | 20.5402 | 20.1804 | 20.4395 | 6629012.0 |
| 2004-09-02 | ABTL-DELISTED | Stock | 35.0 | 35.45 | 34.55 | 35.4 | 25700.0 |
| 2004-09-02 | ABV-DELISTED | Stock | 21.5 | 21.5 | 21.41 | 21.45 | 402500.0 |
| 2004-09-02 | ABVA-DELISTED | Stock | 15.21 | 15.3 | 15.17 | 15.29 | 1001.0 |
| 2004-09-02 | ABX-DELISTED | Stock | 20.2 | 20.2 | 19.87 | 19.98 | 1154100.0 |
| 2004-09-02 | ACAD | Stock | 6.94 | 7.09 | 6.5 | 6.95 | 7800.0 |
| 2004-09-02 | ACAP-DELISTED | Stock | 27.03 | 27.8 | 27.03 | 27.7 | 63380.0 |
| 2004-09-02 | ACAS-DELISTED | Stock | 31.65 | 32.0 | 31.41 | 31.61 | 360700.0 |
| 2004-09-02 | ACAT-DELISTED | Stock | 26.6 | 26.6 | 26.04 | 26.54 | 42972.0 |
| 2004-09-02 | ACC-DELISTED | Stock | 17.8 | 18.09 | 17.8 | 17.92 | 98600.0 |
| 2004-09-02 | ACCL-DELISTED | Stock | 6.16 | 6.32 | 5.97 | 6.24 | 89660.0 |
| 2004-09-02 | ACE-DELISTED | Stock | 37.5 | 38.46 | 37.1 | 38.43 | 2239882.0 |
| 2004-09-02 | ACF-DELISTED | Stock | 20.7 | 20.93 | 20.32 | 20.74 | 1044900.0 |
| 2004-09-02 | ACG-DELISTED | Stock | 8.1 | 8.12 | 8.08 | 8.11 | 394900.0 |
| 2004-09-02 | ACGL | Stock | 4.0967 | 4.3178 | 4.0967 | 4.3144 | 2214000.0 |
| 2004-09-02 | ACGN-DELISTED | Stock | 634.6712 | 646.0 | 623.3288 | 634.6712 | 84400.0 |
| 2004-09-02 | ACH | Stock | 16.0667 | 16.9667 | 16.0667 | 16.9667 | 186600.0 |
| 2004-09-02 | ACH-DELISTED | Stock | 12.25 | 12.545 | 12.25 | 12.53 | 196400.0 |
| 2004-09-02 | ACLS | Stock | 31.24 | 31.6 | 30.76 | 31.32 | 240175.0 |
| 2004-09-02 | ACO-DELISTED | Stock | 17.05 | 17.17 | 16.84 | 17.09 | 79400.0 |
| 2004-09-02 | ACPW-DELISTED | Stock | 14.65 | 14.75 | 13.0 | 14.7 | 42930.0 |
> showing 50 of 3,794 rows — these rows as CSV