PREVIEW / stock_daily / 2009-08-31
file: by_date/stock_daily/2009/2009-08-31.parquet size: 185 KB rows: 5,830 symbols: 3,474
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-08-31 | AAPL | Stock | 6.0057 | 6.0304 | 5.9464 | 6.0075 | 311337600.0 |
| 2009-08-31 | MSFT | Stock | 24.57 | 24.85 | 24.29 | 24.65 | 49592800.0 |
| 2009-08-31 | NVDA | Stock | 0.364 | 0.3658 | 0.3582 | 0.363 | 431796000.0 |
| 2009-08-31 | AMZN | Stock | 4.0965 | 4.0975 | 4.0175 | 4.0595 | 105276000.0 |
| 2009-08-31 | TLT | Stock | 96.36 | 96.86 | 95.76 | 96.6 | 2899866.0 |
| 2009-08-31 | ES | Stock | 23.94 | 24.05 | 23.74 | 23.79 | 913600.0 |
| 2009-08-31 | CL | Stock | 36.23 | 36.64 | 36.18 | 36.35 | 3920800.0 |
| 2009-08-31 | A | Stock | 18.2046 | 18.412 | 18.1044 | 18.3691 | 7138887.0 |
| 2009-08-31 | AABA-DELISTED | Stock | 14.72 | 14.8 | 14.56 | 14.61 | 15223216.0 |
| 2009-08-31 | AACC-DELISTED | Stock | 7.5 | 7.55 | 7.13 | 7.28 | 56523.0 |
| 2009-08-31 | AACG | Stock | 7.2 | 7.55 | 7.11 | 7.11 | 1700.0 |
| 2009-08-31 | AAI-DELISTED | Stock | 6.65 | 6.68 | 6.54 | 6.65 | 1249015.0 |
| 2009-08-31 | AAIC-DELISTED | Stock | 10.8 | 11.4 | 10.0 | 10.4 | 1056833.0 |
| 2009-08-31 | AAME | Stock | 0.81 | 0.81 | 0.78 | 0.78 | 1100.0 |
| 2009-08-31 | AAON | Stock | 4.1699 | 4.2568 | 4.1165 | 4.1244 | 412594.0 |
| 2009-08-31 | AAP | Stock | 42.75 | 42.75 | 42.04 | 42.3 | 1962300.0 |
| 2009-08-31 | AATI-DELISTED | Stock | 4.47 | 4.59 | 4.4 | 4.51 | 156149.0 |
| 2009-08-31 | AAU-DELISTED | Stock | 0.65 | 0.65 | 0.6301 | 0.64 | 23075.0 |
| 2009-08-31 | AAUAF-DELISTED | Stock | 0.65 | 0.65 | 0.6301 | 0.64 | 23575.0 |
| 2009-08-31 | AAV-DELISTED | Stock | 5.65 | 5.7 | 5.51 | 5.68 | 1088947.0 |
| 2009-08-31 | AAWW-DELISTED | Stock | 25.09 | 25.26 | 24.48 | 24.94 | 238683.0 |
| 2009-08-31 | AAXJ | Stock | 48.24 | 48.26 | 47.83 | 48.26 | 113037.0 |
| 2009-08-31 | AAXN-DELISTED | Stock | 4.65 | 4.69 | 4.51 | 4.54 | 474682.0 |
| 2009-08-31 | AB | Stock | 22.35 | 22.7 | 22.0 | 22.69 | 466100.0 |
| 2009-08-31 | ABAX-DELISTED | Stock | 27.17 | 27.41 | 26.31 | 26.6 | 223058.0 |
| 2009-08-31 | ABB-DELISTED | Stock | 19.18 | 19.215 | 19.04 | 19.18 | 2765364.0 |
| 2009-08-31 | ABBC-DELISTED | Stock | 8.19 | 8.29 | 8.01 | 8.08 | 193366.0 |
| 2009-08-31 | ABBNY-DELISTED | Stock | 19.18 | 19.215 | 19.04 | 19.17 | 2943422.0 |
| 2009-08-31 | ABC-DELISTED | Stock | 21.12 | 21.47 | 21.08 | 21.32 | 2108904.0 |
| 2009-08-31 | ABCB | Stock | 6.5167 | 6.5459 | 6.2152 | 6.2735 | 55416.0 |
| 2009-08-31 | ABCO-DELISTED | Stock | 13.155 | 13.295 | 12.895 | 13.215 | 127360.0 |
| 2009-08-31 | ABCW-DELISTED | Stock | 1.32 | 1.3505 | 1.2489 | 1.32 | 55300.0 |
| 2009-08-31 | ABD-DELISTED | Stock | 5.74 | 5.74 | 5.5701 | 5.6 | 280560.0 |
| 2009-08-31 | ABE-DELISTED | Stock | 16.13 | 16.63 | 15.85 | 16.14 | 10177.0 |
| 2009-08-31 | ABEO | Stock | 4075.0 | 4987.5 | 4062.5 | 4762.5 | 93.0 |
| 2009-08-31 | ABFS-DELISTED | Stock | 31.41 | 32.3495 | 31.05 | 31.9 | 473031.0 |
| 2009-08-31 | ABG | Stock | 13.29 | 13.38 | 12.37 | 12.5 | 331000.0 |
| 2009-08-31 | ABII-DELISTED | Stock | 27.28 | 27.5 | 26.47 | 26.87 | 46880.0 |
| 2009-08-31 | ABK-DELISTED | Stock | 1.56 | 1.88 | 1.51 | 1.75 | 50247360.0 |
| 2009-08-31 | ABM | Stock | 22.49 | 22.77 | 22.25 | 22.43 | 196800.0 |
| 2009-08-31 | ABMD-DELISTED | Stock | 8.33 | 8.48 | 8.24 | 8.28 | 216013.0 |
| 2009-08-31 | ABR | Stock | 2.06 | 2.06 | 1.85 | 1.94 | 192800.0 |
| 2009-08-31 | ABT | Stock | 21.9604 | 22.2003 | 21.6006 | 21.7014 | 20529596.0 |
| 2009-08-31 | ABTL-DELISTED | Stock | 2.75 | 3.1 | 2.75 | 3.05 | 11980.0 |
| 2009-08-31 | ABV-DELISTED | Stock | 74.34 | 74.68 | 73.89 | 74.46 | 435601.0 |
| 2009-08-31 | ABVA-DELISTED | Stock | 2.85 | 2.85 | 2.85 | 2.85 | 103.0 |
| 2009-08-31 | ABVT-DELISTED | Stock | 92.87 | 93.79 | 91.27 | 91.61 | 137794.0 |
| 2009-08-31 | ABX-DELISTED | Stock | 34.57 | 34.96 | 34.37 | 34.69 | 4768212.0 |
| 2009-08-31 | ACAD | Stock | 5.86 | 5.99 | 5.8 | 5.84 | 976900.0 |
| 2009-08-31 | ACAP-DELISTED | Stock | 30.97 | 31.26 | 29.66 | 29.84 | 80928.0 |
> showing 50 of 5,830 rows — these rows as CSV