PREVIEW / stock_daily / 2006-09-25
file: by_date/stock_daily/2006/2006-09-25.parquet size: 151 KB rows: 4,526 symbols: 2,860
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-09-25 | AAPL | Stock | 2.6361 | 2.7093 | 2.6329 | 2.7054 | 858992400.0 |
| 2006-09-25 | MSFT | Stock | 26.81 | 27.19 | 26.79 | 26.95 | 67903900.0 |
| 2006-09-25 | NVDA | Stock | 0.5043 | 0.5168 | 0.4907 | 0.5147 | 684486000.0 |
| 2006-09-25 | AMZN | Stock | 1.5525 | 1.5985 | 1.537 | 1.5895 | 132392000.0 |
| 2006-09-25 | CL | Stock | 31.05 | 31.15 | 30.885 | 31.105 | 3346800.0 |
| 2006-09-25 | A | Stock | 23.269 | 23.7268 | 23.0901 | 23.5265 | 2681644.0 |
| 2006-09-25 | AABA-DELISTED | Stock | 25.6399993896484 | 25.8700008392334 | 25.2000007629395 | 25.2900009155273 | 19992400.0 |
| 2006-09-25 | AACC-DELISTED | Stock | 15.1 | 15.1 | 14.78 | 15.0 | 176816.0 |
| 2006-09-25 | AACQ-DELISTED | Stock | 5.35 | 5.35 | 5.35 | 5.35 | 62000.0 |
| 2006-09-25 | AACQU-DELISTED | Stock | 6.1 | 6.1 | 6.1 | 6.1 | 43900.0 |
| 2006-09-25 | AACQW-DELISTED | Stock | 0.39 | 0.4 | 0.39 | 0.39 | 107000.0 |
| 2006-09-25 | AAI-DELISTED | Stock | 10.1 | 10.32 | 10.01 | 10.27 | 1770700.0 |
| 2006-09-25 | AAIC-DELISTED | Stock | 162.8 | 163.8 | 157.2 | 161.6 | 1059600.0 |
| 2006-09-25 | AAME | Stock | 2.81 | 2.81 | 2.48 | 2.48 | 1400.0 |
| 2006-09-25 | AAON | Stock | 2.8774 | 2.9998 | 2.8471 | 2.9814 | 244519.0 |
| 2006-09-25 | AAP | Stock | 33.26 | 34.09 | 33.2 | 34.0 | 1508600.0 |
| 2006-09-25 | AATI-DELISTED | Stock | 6.0 | 6.0 | 5.71 | 5.73 | 965934.0 |
| 2006-09-25 | AAU-DELISTED | Stock | 2.26 | 2.2601 | 2.18 | 2.23 | 58300.0 |
| 2006-09-25 | AAUAF-DELISTED | Stock | 2.26 | 2.2601 | 2.18 | 2.23 | 58300.0 |
| 2006-09-25 | AAV-DELISTED | Stock | 12.9 | 12.9 | 12.14 | 12.42 | 1455800.0 |
| 2006-09-25 | AAWW-DELISTED | Stock | 43.75 | 44.42 | 43.11 | 43.73 | 51240.0 |
| 2006-09-25 | AAXN-DELISTED | Stock | 7.26999998092651 | 7.51999998092651 | 7.17999982833862 | 7.44000005722046 | 832600.0 |
| 2006-09-25 | AB | Stock | 67.85 | 69.37 | 67.74 | 68.92 | 213800.0 |
| 2006-09-25 | ABAX-DELISTED | Stock | 22.27 | 22.64 | 21.8382 | 22.5 | 249092.0 |
| 2006-09-25 | ABB-DELISTED | Stock | 13.16 | 13.25 | 12.97 | 13.21 | 1348400.0 |
| 2006-09-25 | ABBC-DELISTED | Stock | 15.0 | 15.29 | 15.0 | 15.27 | 4021.0 |
| 2006-09-25 | ABC-DELISTED | Stock | 22.24 | 22.5 | 22.03 | 22.48 | 2699200.0 |
| 2006-09-25 | ABCB | Stock | 26.6115 | 27.2924 | 26.3586 | 27.2826 | 9459.0 |
| 2006-09-25 | ABCO-DELISTED | Stock | 24.68 | 25.61 | 24.67 | 25.49 | 154542.0 |
| 2006-09-25 | ABCW-DELISTED | Stock | 28.64 | 29.33 | 28.56 | 29.15 | 24630.0 |
| 2006-09-25 | ABD-DELISTED | Stock | 21.38 | 21.86 | 21.04 | 21.72 | 350030.0 |
| 2006-09-25 | ABE-DELISTED | Stock | 13.57 | 14.06 | 13.48 | 14.0 | 11100.0 |
| 2006-09-25 | ABFS-DELISTED | Stock | 43.06 | 43.43 | 42.08 | 43.12 | 357046.0 |
| 2006-09-25 | ABG | Stock | 19.69 | 20.01 | 19.5 | 19.8 | 481100.0 |
| 2006-09-25 | ABK-DELISTED | Stock | 82.35 | 83.48 | 82.06 | 83.38 | 686200.0 |
| 2006-09-25 | ABM | Stock | 18.76 | 19.07 | 18.69 | 19.01 | 359900.0 |
| 2006-09-25 | ABMD-DELISTED | Stock | 14.69 | 15.12 | 14.61 | 15.05 | 115126.0 |
| 2006-09-25 | ABP-DELISTED | Stock | 3.33 | 3.4 | 3.04 | 3.04 | 516000.0 |
| 2006-09-25 | ABR | Stock | 25.73 | 25.95 | 25.51 | 25.79 | 82600.0 |
| 2006-09-25 | ABT | Stock | 23.1647 | 23.2511 | 22.9296 | 23.0064 | 9956232.0 |
| 2006-09-25 | ABTL-DELISTED | Stock | 15.35 | 15.45 | 15.0 | 15.2 | 89380.0 |
| 2006-09-25 | ABV-DELISTED | Stock | 43.83 | 44.38 | 43.2 | 44.31 | 450800.0 |
| 2006-09-25 | ABVA-DELISTED | Stock | 16.5 | 16.74 | 16.4999 | 16.65 | 2010.0 |
| 2006-09-25 | ABX-DELISTED | Stock | 28.98 | 29.46 | 28.69 | 29.13 | 3413958.0 |
| 2006-09-25 | ACAD | Stock | 7.9 | 8.29 | 7.9 | 8.2 | 179500.0 |
| 2006-09-25 | ACAP-DELISTED | Stock | 49.24 | 50.79 | 48.88 | 50.42 | 35881.0 |
| 2006-09-25 | ACAS-DELISTED | Stock | 38.65 | 38.8 | 38.36 | 38.7 | 779411.0 |
| 2006-09-25 | ACAT-DELISTED | Stock | 16.205 | 16.806 | 16.145 | 16.695 | 45040.0 |
| 2006-09-25 | ACC-DELISTED | Stock | 25.85 | 25.9 | 25.55 | 25.73 | 152500.0 |
| 2006-09-25 | ACCL-DELISTED | Stock | 5.48 | 5.56 | 5.4 | 5.46 | 25064.0 |
> showing 50 of 4,526 rows — these rows as CSV