PREVIEW / stock_daily / 2006-01-05
file: by_date/stock_daily/2006/2006-01-05.parquet size: 145 KB rows: 4,317 symbols: 2,726
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-01-05 | AAPL | Stock | 2.6725 | 2.675 | 2.6339 | 2.6564 | 449422400.0 |
| 2006-01-05 | MSFT | Stock | 26.96 | 27.13 | 26.91 | 26.99 | 48245500.0 |
| 2006-01-05 | NVDA | Stock | 0.3275 | 0.3354 | 0.3269 | 0.3348 | 646092000.0 |
| 2006-01-05 | AMZN | Stock | 2.358 | 2.41 | 2.3555 | 2.3825 | 108344000.0 |
| 2006-01-05 | CL | Stock | 27.855 | 27.97 | 27.35 | 27.365 | 3866400.0 |
| 2006-01-05 | A | Stock | 23.927 | 24.6567 | 23.927 | 24.6567 | 4835402.0 |
| 2006-01-05 | AABA-DELISTED | Stock | 40.9300003051758 | 41.7299995422363 | 40.8499984741211 | 41.5299987792969 | 12829100.0 |
| 2006-01-05 | AACC-DELISTED | Stock | 22.31 | 22.95 | 22.07 | 22.9 | 125931.0 |
| 2006-01-05 | AACQ-DELISTED | Stock | 5.2 | 5.2 | 5.2 | 5.2 | 1000.0 |
| 2006-01-05 | AACQU-DELISTED | Stock | 6.13 | 6.13 | 6.13 | 6.13 | 1000.0 |
| 2006-01-05 | AACQW-DELISTED | Stock | 0.52 | 0.52 | 0.51 | 0.51 | 12000.0 |
| 2006-01-05 | AAI-DELISTED | Stock | 16.75 | 16.75 | 16.09 | 16.43 | 1602200.0 |
| 2006-01-05 | AAIC-DELISTED | Stock | 207.2 | 213.2 | 206.0 | 211.4 | 975600.0 |
| 2006-01-05 | AAME | Stock | 2.7 | 2.7 | 2.66 | 2.66 | 6200.0 |
| 2006-01-05 | AAON | Stock | 2.3954 | 2.4033 | 2.3427 | 2.3993 | 91884.0 |
| 2006-01-05 | AAP | Stock | 43.84 | 44.19 | 43.75 | 44.04 | 944600.0 |
| 2006-01-05 | AATI-DELISTED | Stock | 14.04 | 14.1 | 13.89 | 14.04 | 55905.0 |
| 2006-01-05 | AAU-DELISTED | Stock | 2.38 | 2.38 | 2.25 | 2.34 | 121200.0 |
| 2006-01-05 | AAUAF-DELISTED | Stock | 2.38 | 2.38 | 2.25 | 2.34 | 121200.0 |
| 2006-01-05 | AAV-DELISTED | Stock | 19.15 | 19.15 | 18.55 | 18.789 | 325300.0 |
| 2006-01-05 | AAWW-DELISTED | Stock | 45.0 | 45.0 | 44.5 | 44.5 | 87900.0 |
| 2006-01-05 | AAXN-DELISTED | Stock | 7.26000022888184 | 7.42000007629395 | 7.19999980926514 | 7.23999977111816 | 1373100.0 |
| 2006-01-05 | ABAX-DELISTED | Stock | 17.7 | 17.71 | 17.3799 | 17.71 | 135327.0 |
| 2006-01-05 | ABB-DELISTED | Stock | 10.61 | 10.65 | 10.51 | 10.54 | 3183400.0 |
| 2006-01-05 | ABBC-DELISTED | Stock | 13.65 | 13.65 | 13.26 | 13.65 | 30728.0 |
| 2006-01-05 | ABC-DELISTED | Stock | 21.0 | 21.02 | 20.65 | 20.74 | 2788400.0 |
| 2006-01-05 | ABCB | Stock | 19.5696 | 19.589 | 19.3847 | 19.5696 | 5038.0 |
| 2006-01-05 | ABCO-DELISTED | Stock | 24.34 | 24.55 | 23.69 | 23.78 | 225598.0 |
| 2006-01-05 | ABCW-DELISTED | Stock | 31.42 | 31.42 | 31.02 | 31.15 | 35950.0 |
| 2006-01-05 | ABD-DELISTED | Stock | 24.05 | 24.48 | 23.92 | 24.3 | 296210.0 |
| 2006-01-05 | ABE-DELISTED | Stock | 12.22 | 12.33 | 12.15 | 12.33 | 14500.0 |
| 2006-01-05 | ABFS-DELISTED | Stock | 44.1 | 44.63 | 43.91 | 44.52 | 178827.0 |
| 2006-01-05 | ABG | Stock | 16.86 | 17.0 | 16.63 | 16.67 | 42300.0 |
| 2006-01-05 | ABK-DELISTED | Stock | 78.9 | 79.19 | 78.15 | 78.25 | 397900.0 |
| 2006-01-05 | ABM | Stock | 19.71 | 20.1 | 19.71 | 19.89 | 126700.0 |
| 2006-01-05 | ABMD-DELISTED | Stock | 9.74 | 9.76 | 9.41 | 9.55 | 50811.0 |
| 2006-01-05 | ABP-DELISTED | Stock | 5.51 | 5.84 | 5.41 | 5.82 | 742500.0 |
| 2006-01-05 | ABR | Stock | 26.56 | 26.75 | 26.33 | 26.56 | 64400.0 |
| 2006-01-05 | ABT | Stock | 19.0481 | 19.4127 | 19.0241 | 19.2496 | 11570029.0 |
| 2006-01-05 | ABTL-DELISTED | Stock | 24.4 | 25.25 | 24.05 | 25.2 | 11924.0 |
| 2006-01-05 | ABV-DELISTED | Stock | 40.0 | 40.5 | 39.8 | 40.5 | 727200.0 |
| 2006-01-05 | ABVA-DELISTED | Stock | 16.031 | 16.031 | 16.031 | 16.031 | 498.0 |
| 2006-01-05 | ABX-DELISTED | Stock | 28.84 | 29.31 | 28.75 | 29.24 | 5455600.0 |
| 2006-01-05 | ACAD | Stock | 10.05 | 10.06 | 9.96 | 10.01 | 38900.0 |
| 2006-01-05 | ACAP-DELISTED | Stock | 46.6 | 46.76 | 45.9 | 46.1 | 49463.0 |
| 2006-01-05 | ACAS-DELISTED | Stock | 36.7 | 36.86 | 36.44 | 36.67 | 965702.0 |
| 2006-01-05 | ACAT-DELISTED | Stock | 21.1 | 21.88 | 20.93 | 21.88 | 121609.0 |
| 2006-01-05 | ACC-DELISTED | Stock | 24.7 | 24.84 | 24.3 | 24.83 | 123692.0 |
| 2006-01-05 | ACCL-DELISTED | Stock | 7.66 | 7.79 | 7.55 | 7.63 | 71317.0 |
| 2006-01-05 | ACCO | Stock | 24.05 | 24.48 | 23.92 | 24.3 | 294800.0 |
> showing 50 of 4,317 rows — these rows as CSV