PREVIEW / stock_daily / 2006-08-28
file: by_date/stock_daily/2006/2006-08-28.parquet size: 148 KB rows: 4,479 symbols: 2,816
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 |
|---|---|---|---|---|---|---|---|
| 2006-08-28 | AAPL | Stock | 2.4464 | 2.4504 | 2.3814 | 2.3921 | 738161200.0 |
| 2006-08-28 | MSFT | Stock | 25.84 | 26.0 | 25.69 | 25.95 | 34190900.0 |
| 2006-08-28 | NVDA | Stock | 0.4487 | 0.4695 | 0.4478 | 0.4565 | 764562000.0 |
| 2006-08-28 | AMZN | Stock | 1.42 | 1.45 | 1.4135 | 1.4455 | 121348000.0 |
| 2006-08-28 | CL | Stock | 29.475 | 29.535 | 29.39 | 29.445 | 2575800.0 |
| 2006-08-28 | A | Stock | 21.774 | 22.1459 | 21.7597 | 22.0315 | 2176966.0 |
| 2006-08-28 | AABA-DELISTED | Stock | 28.75 | 29.25 | 28.7000007629395 | 28.9099998474121 | 10404700.0 |
| 2006-08-28 | AACC-DELISTED | Stock | 14.82 | 14.96 | 14.76 | 14.79 | 131775.0 |
| 2006-08-28 | AACQ-DELISTED | Stock | 5.3 | 5.31 | 5.3 | 5.31 | 118000.0 |
| 2006-08-28 | AACQW-DELISTED | Stock | 0.4 | 0.4 | 0.37 | 0.38 | 69800.0 |
| 2006-08-28 | AAI-DELISTED | Stock | 11.06 | 11.44 | 11.01 | 11.34 | 1337900.0 |
| 2006-08-28 | AAIC-DELISTED | Stock | 165.2 | 166.6 | 160.8 | 165.8 | 1161500.0 |
| 2006-08-28 | AAON | Stock | 2.8984 | 3.0183 | 2.8866 | 3.0183 | 132131.0 |
| 2006-08-28 | AAP | Stock | 29.05 | 29.62 | 29.04 | 29.5 | 643200.0 |
| 2006-08-28 | AATI-DELISTED | Stock | 9.3 | 9.39 | 9.2 | 9.26 | 73642.0 |
| 2006-08-28 | AAU-DELISTED | Stock | 2.7 | 2.76 | 2.66 | 2.7 | 35100.0 |
| 2006-08-28 | AAUAF-DELISTED | Stock | 2.7 | 2.76 | 2.66 | 2.7 | 35100.0 |
| 2006-08-28 | AAV-DELISTED | Stock | 16.25 | 16.35 | 16.2 | 16.31 | 538900.0 |
| 2006-08-28 | AAWW-DELISTED | Stock | 42.88 | 43.34 | 41.86 | 42.7 | 52291.0 |
| 2006-08-28 | AAXN-DELISTED | Stock | 7.65000009536743 | 7.80999994277954 | 7.65000009536743 | 7.73999977111816 | 422000.0 |
| 2006-08-28 | AB | Stock | 65.2 | 65.99 | 65.04 | 65.96 | 155400.0 |
| 2006-08-28 | ABAX-DELISTED | Stock | 23.19 | 24.03 | 23.14 | 23.89 | 197957.0 |
| 2006-08-28 | ABB-DELISTED | Stock | 13.18 | 13.4 | 13.15 | 13.29 | 1729000.0 |
| 2006-08-28 | ABBC-DELISTED | Stock | 14.47 | 14.53 | 14.39 | 14.53 | 7516.0 |
| 2006-08-28 | ABC-DELISTED | Stock | 21.86 | 22.46 | 21.84 | 22.42 | 4706200.0 |
| 2006-08-28 | ABCB | Stock | 25.2109 | 26.3975 | 25.2109 | 26.31 | 39377.0 |
| 2006-08-28 | ABCO-DELISTED | Stock | 24.53 | 25.22 | 24.29 | 25.09 | 147438.0 |
| 2006-08-28 | ABCW-DELISTED | Stock | 28.7 | 29.03 | 28.65 | 28.89 | 16220.0 |
| 2006-08-28 | ABD-DELISTED | Stock | 21.15 | 21.44 | 21.1 | 21.29 | 88500.0 |
| 2006-08-28 | ABE-DELISTED | Stock | 13.4 | 13.4 | 13.1 | 13.29 | 6900.0 |
| 2006-08-28 | ABFS-DELISTED | Stock | 42.24 | 44.41 | 42.23 | 44.33 | 687060.0 |
| 2006-08-28 | ABG | Stock | 19.47 | 20.43 | 19.47 | 20.39 | 107500.0 |
| 2006-08-28 | ABK-DELISTED | Stock | 85.26 | 86.0 | 85.15 | 85.74 | 445800.0 |
| 2006-08-28 | ABM | Stock | 17.5 | 17.74 | 17.5 | 17.72 | 104700.0 |
| 2006-08-28 | ABMD-DELISTED | Stock | 13.31 | 13.6 | 13.17 | 13.43 | 64814.0 |
| 2006-08-28 | ABP-DELISTED | Stock | 4.18 | 4.2 | 4.07 | 4.12 | 136400.0 |
| 2006-08-28 | ABR | Stock | 24.88 | 25.25 | 24.77 | 25.0 | 100700.0 |
| 2006-08-28 | ABT | Stock | 23.5054 | 23.7165 | 23.4334 | 23.491 | 7712380.0 |
| 2006-08-28 | ABTL-DELISTED | Stock | 14.701 | 14.701 | 13.748 | 14.149 | 32846.0 |
| 2006-08-28 | ABV-DELISTED | Stock | 43.15 | 44.41 | 43.15 | 44.28 | 396100.0 |
| 2006-08-28 | ABVA-DELISTED | Stock | 16.33 | 17.0 | 16.33 | 17.0 | 4553.0 |
| 2006-08-28 | ABVT-DELISTED | Stock | 47.5 | 47.5 | 47.5 | 47.5 | 200.0 |
| 2006-08-28 | ABX-DELISTED | Stock | 32.97 | 33.11 | 32.41 | 32.57 | 2544100.0 |
| 2006-08-28 | ACAD | Stock | 8.59 | 8.62 | 8.01 | 8.05 | 163700.0 |
| 2006-08-28 | ACAP-DELISTED | Stock | 47.4 | 48.16 | 47.23 | 47.67 | 29424.0 |
| 2006-08-28 | ACAS-DELISTED | Stock | 37.98 | 38.11 | 37.67 | 38.05 | 764483.0 |
| 2006-08-28 | ACAT-DELISTED | Stock | 16.99 | 16.99 | 16.38 | 16.4 | 75100.0 |
| 2006-08-28 | ACC-DELISTED | Stock | 25.24 | 25.48 | 25.2 | 25.36 | 15800.0 |
| 2006-08-28 | ACCL-DELISTED | Stock | 5.6 | 5.61 | 5.45 | 5.6 | 64358.0 |
| 2006-08-28 | ACCO | Stock | 21.15 | 21.44 | 21.1 | 21.29 | 88500.0 |
> showing 50 of 4,479 rows — these rows as CSV