PREVIEW / stock_daily / 2007-08-10
file: by_date/stock_daily/2007/2007-08-10.parquet size: 178 KB rows: 5,513 symbols: 3,319
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 |
|---|---|---|---|---|---|---|---|
| 2007-08-10 | AAPL | Stock | 4.3971 | 4.5625 | 4.2964 | 4.4643 | 1410749200.0 |
| 2007-08-10 | MSFT | Stock | 28.9 | 29.05 | 28.26 | 28.71 | 76576200.0 |
| 2007-08-10 | NVDA | Stock | 0.7058 | 0.7382 | 0.6898 | 0.7332 | 1141014000.0 |
| 2007-08-10 | AMZN | Stock | 3.6575 | 3.825 | 3.6185 | 3.739 | 181352000.0 |
| 2007-08-10 | TLT | Stock | 86.49 | 86.7 | 85.98 | 86.08 | 1496400.0 |
| 2007-08-10 | CL | Stock | 32.95 | 33.675 | 32.845 | 33.475 | 7152000.0 |
| 2007-08-10 | A | Stock | 26.1803 | 26.1803 | 25.2361 | 25.5722 | 4841973.0 |
| 2007-08-10 | AABA-DELISTED | Stock | 23.93 | 24.22 | 23.52 | 23.98 | 21744081.0 |
| 2007-08-10 | AACC-DELISTED | Stock | 8.71 | 9.44 | 8.63 | 8.81 | 920194.0 |
| 2007-08-10 | AAI-DELISTED | Stock | 10.84 | 11.07 | 10.55 | 10.74 | 3189600.0 |
| 2007-08-10 | AAIC-DELISTED | Stock | 95.4 | 100.2 | 92.2 | 96.0 | 4827600.0 |
| 2007-08-10 | AAME | Stock | 3.17 | 3.17 | 2.76 | 3.05 | 9500.0 |
| 2007-08-10 | AAON | Stock | 4.21 | 4.3365 | 3.9625 | 4.243 | 757856.0 |
| 2007-08-10 | AAP | Stock | 29.9 | 32.07 | 29.51 | 31.8 | 6230600.0 |
| 2007-08-10 | AATI-DELISTED | Stock | 8.09 | 8.98 | 7.91 | 8.92 | 575125.0 |
| 2007-08-10 | AAU-DELISTED | Stock | 2.56 | 2.62 | 2.5 | 2.53 | 93900.0 |
| 2007-08-10 | AAUAF-DELISTED | Stock | 2.56 | 2.62 | 2.5 | 2.53 | 91700.0 |
| 2007-08-10 | AAV-DELISTED | Stock | 12.0 | 12.0 | 11.8 | 11.98 | 654300.0 |
| 2007-08-10 | AAWW-DELISTED | Stock | 51.14 | 53.88 | 50.01 | 52.31 | 400826.0 |
| 2007-08-10 | AAXN-DELISTED | Stock | 15.57 | 16.18 | 15.3 | 15.4 | 3604183.0 |
| 2007-08-10 | AB | Stock | 81.5 | 83.78 | 79.97 | 83.05 | 679900.0 |
| 2007-08-10 | ABAX-DELISTED | Stock | 21.65 | 21.78 | 20.0 | 20.65 | 368685.0 |
| 2007-08-10 | ABB-DELISTED | Stock | 22.26 | 22.75 | 21.78 | 22.46 | 6076400.0 |
| 2007-08-10 | ABBC-DELISTED | Stock | 9.02 | 9.29 | 8.76 | 9.0 | 89511.0 |
| 2007-08-10 | ABBNY-DELISTED | Stock | 22.26 | 23.38 | 21.78 | 22.5 | 6331500.0 |
| 2007-08-10 | ABC-DELISTED | Stock | 22.02 | 23.02 | 21.56 | 22.76 | 5935400.0 |
| 2007-08-10 | ABCB | Stock | 19.4139 | 21.3981 | 19.2486 | 20.6687 | 69501.0 |
| 2007-08-10 | ABCO-DELISTED | Stock | 29.72 | 29.94 | 26.92 | 29.21 | 696651.0 |
| 2007-08-10 | ABCW-DELISTED | Stock | 22.69 | 24.41 | 22.66 | 24.32 | 148570.0 |
| 2007-08-10 | ABD-DELISTED | Stock | 24.4 | 24.63 | 22.49 | 22.64 | 1378940.0 |
| 2007-08-10 | ABE-DELISTED | Stock | 19.64 | 19.8199 | 18.5 | 19.7 | 89600.0 |
| 2007-08-10 | ABEO | Stock | 4375.0 | 4675.0 | 4187.5 | 4612.5 | 9.0 |
| 2007-08-10 | ABFS-DELISTED | Stock | 35.1 | 37.94 | 34.51 | 36.39 | 677831.0 |
| 2007-08-10 | ABG | Stock | 19.88 | 22.2 | 19.57 | 20.87 | 1034000.0 |
| 2007-08-10 | ABK-DELISTED | Stock | 67.72 | 69.34 | 63.01 | 66.06 | 5926300.0 |
| 2007-08-10 | ABM | Stock | 20.45 | 24.75 | 20.45 | 22.96 | 918500.0 |
| 2007-08-10 | ABMD-DELISTED | Stock | 13.04 | 13.37 | 11.48 | 11.52 | 854590.0 |
| 2007-08-10 | ABP-DELISTED | Stock | 3.7 | 3.84 | 3.63 | 3.74 | 216600.0 |
| 2007-08-10 | ABR | Stock | 19.27 | 20.19 | 18.24 | 18.47 | 586400.0 |
| 2007-08-10 | ABT | Stock | 26.3314 | 26.6289 | 25.2999 | 26.4946 | 15974573.0 |
| 2007-08-10 | ABTL-DELISTED | Stock | 13.0 | 13.4 | 12.4 | 13.25 | 68666.0 |
| 2007-08-10 | ABV-DELISTED | Stock | 64.38 | 67.2 | 63.18 | 66.24 | 751800.0 |
| 2007-08-10 | ABVA-DELISTED | Stock | 9.89 | 10.14 | 9.85 | 9.878 | 50232.0 |
| 2007-08-10 | ABVT-DELISTED | Stock | 80.0 | 99.0 | 76.0 | 83.0 | 2754.0 |
| 2007-08-10 | ABX-DELISTED | Stock | 33.93 | 35.0 | 33.65 | 34.26 | 7157000.0 |
| 2007-08-10 | ACAD | Stock | 16.11 | 16.46 | 14.12 | 16.4 | 910900.0 |
| 2007-08-10 | ACAP-DELISTED | Stock | 31.5 | 36.24 | 31.25 | 36.04 | 199816.0 |
| 2007-08-10 | ACAS-DELISTED | Stock | 42.01 | 42.01 | 40.37 | 40.69 | 3848382.0 |
| 2007-08-10 | ACAT-DELISTED | Stock | 16.73 | 17.73 | 16.41 | 17.35 | 238154.0 |
| 2007-08-10 | ACC-DELISTED | Stock | 26.3 | 27.7 | 25.99 | 26.85 | 182800.0 |
> showing 50 of 5,513 rows — these rows as CSV