PREVIEW / stock_daily / 2009-08-28
file: by_date/stock_daily/2009/2009-08-28.parquet size: 184 KB rows: 5,825 symbols: 3,478
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-28 | AAPL | Stock | 6.1525 | 6.1604 | 6.0189 | 6.0732 | 453700800.0 |
| 2009-08-28 | MSFT | Stock | 25.07 | 25.49 | 24.61 | 24.68 | 55808000.0 |
| 2009-08-28 | NVDA | Stock | 0.3598 | 0.3758 | 0.3592 | 0.3682 | 883992000.0 |
| 2009-08-28 | AMZN | Stock | 4.239 | 4.2495 | 4.1285 | 4.138 | 92414000.0 |
| 2009-08-28 | TLT | Stock | 95.44 | 96.5101 | 95.31 | 96.51 | 2072461.0 |
| 2009-08-28 | ES | Stock | 24.29 | 24.32 | 23.79 | 24.03 | 1086100.0 |
| 2009-08-28 | CL | Stock | 36.595 | 36.855 | 36.335 | 36.38 | 3375000.0 |
| 2009-08-28 | A | Stock | 18.3619 | 18.6338 | 18.3333 | 18.4764 | 5549361.0 |
| 2009-08-28 | AABA-DELISTED | Stock | 14.98 | 15.08 | 14.7999 | 14.84 | 32560535.0 |
| 2009-08-28 | AACC-DELISTED | Stock | 8.32 | 8.32 | 7.38 | 7.59 | 74704.0 |
| 2009-08-28 | AACG | Stock | 7.25 | 7.4 | 7.25 | 7.31 | 2700.0 |
| 2009-08-28 | AAI-DELISTED | Stock | 6.76 | 6.96 | 6.64 | 6.68 | 1001902.0 |
| 2009-08-28 | AAIC-DELISTED | Stock | 12.2 | 12.4 | 10.202 | 10.8 | 4968120.0 |
| 2009-08-28 | AAME | Stock | 0.83 | 0.83 | 0.83 | 0.83 | 900.0 |
| 2009-08-28 | AAON | Stock | 4.3299 | 4.3299 | 4.1679 | 4.1956 | 486506.0 |
| 2009-08-28 | AAP | Stock | 43.03 | 43.3 | 42.57 | 43.12 | 1307600.0 |
| 2009-08-28 | AATI-DELISTED | Stock | 4.53 | 4.74 | 4.49 | 4.5 | 278572.0 |
| 2009-08-28 | AAU-DELISTED | Stock | 0.65 | 0.66 | 0.6301 | 0.66 | 31050.0 |
| 2009-08-28 | AAUAF-DELISTED | Stock | 0.65 | 0.66 | 0.6301 | 0.66 | 33950.0 |
| 2009-08-28 | AAV-DELISTED | Stock | 5.82 | 5.86 | 5.76 | 5.8 | 575905.0 |
| 2009-08-28 | AAWW-DELISTED | Stock | 24.43 | 25.26 | 24.09 | 25.14 | 291662.0 |
| 2009-08-28 | AAXJ | Stock | 49.52 | 49.52 | 48.72 | 49.07 | 83314.0 |
| 2009-08-28 | AAXN-DELISTED | Stock | 4.78 | 4.83 | 4.66 | 4.7 | 527347.0 |
| 2009-08-28 | AB | Stock | 22.2 | 22.5 | 22.08 | 22.46 | 633600.0 |
| 2009-08-28 | ABAX-DELISTED | Stock | 27.88 | 27.88 | 27.01 | 27.25 | 198965.0 |
| 2009-08-28 | ABB-DELISTED | Stock | 19.63 | 19.66 | 19.36 | 19.49 | 2739389.0 |
| 2009-08-28 | ABBC-DELISTED | Stock | 8.47 | 8.47 | 8.1 | 8.15 | 48289.0 |
| 2009-08-28 | ABBNY-DELISTED | Stock | 19.62 | 19.66 | 19.36 | 19.49 | 2763562.0 |
| 2009-08-28 | ABC-DELISTED | Stock | 21.28 | 21.28 | 21.09 | 21.2 | 2505655.0 |
| 2009-08-28 | ABCB | Stock | 6.5459 | 6.6431 | 6.3319 | 6.6139 | 27554.0 |
| 2009-08-28 | ABCO-DELISTED | Stock | 13.417 | 13.452 | 13.118 | 13.268 | 128417.0 |
| 2009-08-28 | ABCW-DELISTED | Stock | 1.28 | 1.2898 | 1.2702 | 1.28 | 54920.0 |
| 2009-08-28 | ABD-DELISTED | Stock | 5.9 | 5.97 | 5.63 | 5.76 | 231760.0 |
| 2009-08-28 | ABE-DELISTED | Stock | 16.38 | 16.56 | 16.38 | 16.51 | 10708.0 |
| 2009-08-28 | ABEO | Stock | 4087.5 | 4125.0 | 4000.0 | 4087.5 | 12.0 |
| 2009-08-28 | ABFS-DELISTED | Stock | 31.85 | 32.97 | 31.35 | 31.61 | 445087.0 |
| 2009-08-28 | ABG | Stock | 13.38 | 13.67 | 13.25 | 13.32 | 265300.0 |
| 2009-08-28 | ABII-DELISTED | Stock | 27.42 | 28.0 | 27.0 | 27.6 | 22575.0 |
| 2009-08-28 | ABK-DELISTED | Stock | 1.97 | 1.99 | 1.59 | 1.72 | 93560045.0 |
| 2009-08-28 | ABM | Stock | 23.13 | 23.13 | 22.46 | 22.61 | 113600.0 |
| 2009-08-28 | ABMD-DELISTED | Stock | 8.78 | 8.78 | 8.31 | 8.42 | 143156.0 |
| 2009-08-28 | ABR | Stock | 2.03 | 2.24 | 2.0 | 2.06 | 655600.0 |
| 2009-08-28 | ABT | Stock | 22.3779 | 22.3827 | 21.9221 | 22.0324 | 13094831.0 |
| 2009-08-28 | ABTL-DELISTED | Stock | 2.9 | 3.157 | 2.9 | 3.1 | 9171.0 |
| 2009-08-28 | ABV-DELISTED | Stock | 76.07 | 76.49 | 74.82 | 75.13 | 281595.0 |
| 2009-08-28 | ABVA-DELISTED | Stock | 2.7775 | 2.7775 | 2.35 | 2.7585 | 4925.0 |
| 2009-08-28 | ABVT-DELISTED | Stock | 94.2 | 94.56 | 92.71 | 94.35 | 101136.0 |
| 2009-08-28 | ABX-DELISTED | Stock | 35.22 | 35.57 | 34.79 | 35.45 | 7231075.0 |
| 2009-08-28 | ACAD | Stock | 6.13 | 6.14 | 5.91 | 5.98 | 987000.0 |
| 2009-08-28 | ACAP-DELISTED | Stock | 32.15 | 32.47 | 31.09 | 31.25 | 37268.0 |
> showing 50 of 5,825 rows — these rows as CSV