PREVIEW / stock_daily / 2009-11-12
file: by_date/stock_daily/2009/2009-11-12.parquet size: 186 KB rows: 5,848 symbols: 3,476
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 |
|---|---|---|---|---|---|---|---|
| 2009-11-12 | AAPL | Stock | 7.255 | 7.3168 | 7.1939 | 7.2139 | 363731200.0 |
| 2009-11-12 | MSFT | Stock | 29.01 | 29.49 | 29.0 | 29.36 | 55352400.0 |
| 2009-11-12 | NVDA | Stock | 0.3405 | 0.3462 | 0.3355 | 0.3365 | 505864000.0 |
| 2009-11-12 | AMZN | Stock | 6.499 | 6.6075 | 6.499 | 6.5265 | 144202000.0 |
| 2009-11-12 | TLT | Stock | 93.24 | 93.59 | 92.45 | 93.49 | 3431281.0 |
| 2009-11-12 | ES | Stock | 23.58 | 23.62 | 23.34 | 23.4 | 2697300.0 |
| 2009-11-12 | CL | Stock | 40.795 | 40.975 | 40.18 | 40.25 | 6447600.0 |
| 2009-11-12 | A | Stock | 19.7568 | 19.8069 | 19.5136 | 19.6209 | 4887688.0 |
| 2009-11-12 | AABA-DELISTED | Stock | 16.02 | 16.28 | 15.97 | 16.01 | 9846954.0 |
| 2009-11-12 | AACC-DELISTED | Stock | 5.23 | 5.39 | 5.04 | 5.11 | 94061.0 |
| 2009-11-12 | AACG | Stock | 4.2 | 4.51 | 4.2 | 4.4 | 33400.0 |
| 2009-11-12 | AAI-DELISTED | Stock | 4.66 | 4.72 | 4.49 | 4.49 | 3406989.0 |
| 2009-11-12 | AAIC-DELISTED | Stock | 13.64 | 13.64 | 13.0 | 13.01 | 27884.0 |
| 2009-11-12 | AAME | Stock | 1.25 | 1.25 | 1.25 | 1.25 | 400.0 |
| 2009-11-12 | AAON | Stock | 3.9822 | 4.0494 | 3.8835 | 3.9052 | 362475.0 |
| 2009-11-12 | AAP | Stock | 38.15 | 39.02 | 37.57 | 38.69 | 6422300.0 |
| 2009-11-12 | AATI-DELISTED | Stock | 3.12 | 3.18 | 3.05 | 3.09 | 205107.0 |
| 2009-11-12 | AAU-DELISTED | Stock | 0.69 | 0.7 | 0.68 | 0.68 | 33490.0 |
| 2009-11-12 | AAUAF-DELISTED | Stock | 0.69 | 0.7 | 0.68 | 0.68 | 36640.0 |
| 2009-11-12 | AAV-DELISTED | Stock | 6.34 | 6.36 | 5.9998 | 6.04 | 1058716.0 |
| 2009-11-12 | AAWW-DELISTED | Stock | 28.78 | 29.2 | 28.26 | 28.62 | 474452.0 |
| 2009-11-12 | AAXJ | Stock | 55.16 | 55.18 | 54.43 | 54.68 | 169576.0 |
| 2009-11-12 | AAXN-DELISTED | Stock | 4.26 | 4.29 | 4.11 | 4.11 | 541969.0 |
| 2009-11-12 | AB | Stock | 26.8 | 27.27 | 26.67 | 27.08 | 268000.0 |
| 2009-11-12 | ABAX-DELISTED | Stock | 22.89 | 23.64 | 22.53 | 22.6 | 129790.0 |
| 2009-11-12 | ABB-DELISTED | Stock | 19.86 | 19.92 | 19.45 | 19.53 | 4780404.0 |
| 2009-11-12 | ABBC-DELISTED | Stock | 6.58 | 6.62 | 6.47 | 6.56 | 67599.0 |
| 2009-11-12 | ABBNY-DELISTED | Stock | 19.86 | 19.92 | 19.45 | 19.51 | 4830847.0 |
| 2009-11-12 | ABC-DELISTED | Stock | 24.29 | 24.41 | 23.95 | 23.98 | 1987382.0 |
| 2009-11-12 | ABCB | Stock | 6.214 | 6.214 | 5.7435 | 5.8318 | 50402.0 |
| 2009-11-12 | ABCO-DELISTED | Stock | 13.195 | 13.305 | 12.755 | 12.785 | 55480.0 |
| 2009-11-12 | ABCW-DELISTED | Stock | 0.42 | 0.48 | 0.4 | 0.44 | 466330.0 |
| 2009-11-12 | ABD-DELISTED | Stock | 6.93 | 6.97 | 6.43 | 6.45 | 197720.0 |
| 2009-11-12 | ABE-DELISTED | Stock | 16.75 | 16.8 | 16.6 | 16.63 | 12800.0 |
| 2009-11-12 | ABEO | Stock | 3625.0 | 3937.5 | 3625.0 | 3937.5 | 10.0 |
| 2009-11-12 | ABFS-DELISTED | Stock | 26.06 | 26.25 | 24.97 | 25.12 | 534737.0 |
| 2009-11-12 | ABG | Stock | 10.48 | 10.53 | 9.95 | 10.08 | 418300.0 |
| 2009-11-12 | ABII-DELISTED | Stock | 34.76 | 35.681 | 34.76 | 35.24 | 35437.0 |
| 2009-11-12 | ABK-DELISTED | Stock | 0.76 | 0.8 | 0.73 | 0.74 | 17390627.0 |
| 2009-11-12 | ABM | Stock | 19.35 | 19.5 | 18.97 | 19.0 | 115300.0 |
| 2009-11-12 | ABMD-DELISTED | Stock | 9.26 | 9.41 | 8.79 | 8.83 | 498169.0 |
| 2009-11-12 | ABR | Stock | 1.97 | 1.97 | 1.92 | 1.94 | 39200.0 |
| 2009-11-12 | ABT | Stock | 25.6165 | 25.8132 | 25.4342 | 25.5398 | 9963110.0 |
| 2009-11-12 | ABTL-DELISTED | Stock | 4.1 | 4.15 | 4.0 | 4.05 | 1272.0 |
| 2009-11-12 | ABV-DELISTED | Stock | 100.64 | 100.83 | 95.88 | 96.21 | 1029955.0 |
| 2009-11-12 | ABVT-DELISTED | Stock | 53.16 | 53.99 | 53.16 | 53.74 | 154268.0 |
| 2009-11-12 | ABX-DELISTED | Stock | 42.66 | 42.98 | 41.72 | 41.9 | 9856365.0 |
| 2009-11-12 | ACAD | Stock | 1.47 | 1.51 | 1.37 | 1.39 | 459700.0 |
| 2009-11-12 | ACAP-DELISTED | Stock | 29.55 | 29.68 | 28.27 | 28.32 | 34649.0 |
| 2009-11-12 | ACAS-DELISTED | Stock | 2.92 | 2.96 | 2.76 | 2.76 | 5975670.0 |
> showing 50 of 5,848 rows — these rows as CSV