PREVIEW / stock_daily / 2009-01-30
file: by_date/stock_daily/2009/2009-01-30.parquet size: 175 KB rows: 5,696 symbols: 3,393
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-01-30 | AAPL | Stock | 3.3071 | 3.3436 | 3.2146 | 3.2189 | 651478800.0 |
| 2009-01-30 | MSFT | Stock | 17.74 | 17.79 | 17.1 | 17.1 | 62370900.0 |
| 2009-01-30 | NVDA | Stock | 0.2055 | 0.211 | 0.1962 | 0.1988 | 506760000.0 |
| 2009-01-30 | AMZN | Stock | 2.868 | 2.987 | 2.862 | 2.941 | 795662000.0 |
| 2009-01-30 | TLT | Stock | 104.55 | 104.87 | 103.44 | 103.75 | 2630588.0 |
| 2009-01-30 | CL | Stock | 32.77 | 32.98 | 32.345 | 32.52 | 9636600.0 |
| 2009-01-30 | A | Stock | 13.3333 | 13.4549 | 12.8469 | 12.9328 | 4270890.0 |
| 2009-01-30 | AABA-DELISTED | Stock | 11.85 | 12.15 | 11.51 | 11.73 | 21239542.0 |
| 2009-01-30 | AACC-DELISTED | Stock | 4.25 | 4.56 | 4.18 | 4.18 | 54190.0 |
| 2009-01-30 | AACG | Stock | 3.55 | 3.58 | 3.28 | 3.28 | 5500.0 |
| 2009-01-30 | AAI-DELISTED | Stock | 4.51 | 4.7 | 4.07 | 4.09 | 2852636.0 |
| 2009-01-30 | AAIC-DELISTED | Stock | 3.6 | 4.0 | 3.6 | 3.6 | 176064.0 |
| 2009-01-30 | AAME | Stock | 0.97 | 0.97 | 0.96 | 0.96 | 1000.0 |
| 2009-01-30 | AAON | Stock | 3.6563 | 3.682 | 3.5556 | 3.5793 | 304762.0 |
| 2009-01-30 | AAP | Stock | 33.56 | 33.84 | 32.46 | 32.73 | 1273100.0 |
| 2009-01-30 | AATI-DELISTED | Stock | 3.32 | 3.38 | 3.0 | 3.01 | 108853.0 |
| 2009-01-30 | AAU-DELISTED | Stock | 0.78 | 0.8 | 0.75 | 0.78 | 154632.0 |
| 2009-01-30 | AAUAF-DELISTED | Stock | 0.78 | 0.8 | 0.75 | 0.78 | 156632.0 |
| 2009-01-30 | AAV-DELISTED | Stock | 4.26 | 4.31 | 4.15 | 4.22 | 550445.0 |
| 2009-01-30 | AAWW-DELISTED | Stock | 16.03 | 16.03 | 14.19 | 14.51 | 161380.0 |
| 2009-01-30 | AAXJ | Stock | 30.94 | 31.66 | 30.39 | 30.79 | 28927.0 |
| 2009-01-30 | AAXN-DELISTED | Stock | 5.24 | 5.32 | 5.06 | 5.06 | 650675.0 |
| 2009-01-30 | AB | Stock | 17.93 | 18.13 | 16.82 | 17.08 | 376400.0 |
| 2009-01-30 | ABAX-DELISTED | Stock | 14.27 | 16.99 | 14.25 | 15.82 | 832960.0 |
| 2009-01-30 | ABB-DELISTED | Stock | 13.29 | 13.29 | 12.88 | 13.02 | 4778972.0 |
| 2009-01-30 | ABBC-DELISTED | Stock | 7.5 | 7.5 | 7.0 | 7.06 | 64626.0 |
| 2009-01-30 | ABBNY-DELISTED | Stock | 13.29 | 13.29 | 12.88 | 13.05 | 4780972.0 |
| 2009-01-30 | ABC-DELISTED | Stock | 18.06 | 18.9 | 18.02 | 18.18 | 3240772.0 |
| 2009-01-30 | ABCB | Stock | 9.1818 | 9.1818 | 7.4504 | 7.4504 | 17684.0 |
| 2009-01-30 | ABCO-DELISTED | Stock | 8.975 | 9.025 | 8.675 | 8.745 | 132476.0 |
| 2009-01-30 | ABCW-DELISTED | Stock | 2.12 | 2.18 | 1.9966 | 2.02 | 131510.0 |
| 2009-01-30 | ABD-DELISTED | Stock | 1.96 | 1.96 | 1.7 | 1.92 | 294880.0 |
| 2009-01-30 | ABE-DELISTED | Stock | 12.2 | 12.33 | 11.8 | 12.33 | 41696.0 |
| 2009-01-30 | ABEO | Stock | 1025.0 | 1125.0 | 1025.0 | 1125.0 | 12.0 |
| 2009-01-30 | ABFS-DELISTED | Stock | 23.54 | 24.62 | 23.03 | 23.38 | 948096.0 |
| 2009-01-30 | ABG | Stock | 3.75 | 3.84 | 3.34 | 3.58 | 189800.0 |
| 2009-01-30 | ABII-DELISTED | Stock | 68.5 | 69.27 | 67.09 | 68.67 | 16549.0 |
| 2009-01-30 | ABK-DELISTED | Stock | 1.24 | 1.28 | 1.13 | 1.16 | 7856658.0 |
| 2009-01-30 | ABM | Stock | 15.8 | 15.91 | 14.79 | 14.85 | 598100.0 |
| 2009-01-30 | ABMD-DELISTED | Stock | 13.72 | 14.17 | 13.36 | 13.48 | 219176.0 |
| 2009-01-30 | ABR | Stock | 2.0 | 2.11 | 1.77 | 1.78 | 164700.0 |
| 2009-01-30 | ABT | Stock | 26.3986 | 26.7872 | 26.2547 | 26.6001 | 25721134.0 |
| 2009-01-30 | ABTL-DELISTED | Stock | 2.0003 | 2.0003 | 1.8002 | 1.9997 | 5431.0 |
| 2009-01-30 | ABV-DELISTED | Stock | 41.03 | 41.45 | 40.495 | 40.78 | 634780.0 |
| 2009-01-30 | ABVA-DELISTED | Stock | 1.49 | 1.49 | 0.8801 | 1.05 | 4500.0 |
| 2009-01-30 | ABVT-DELISTED | Stock | 31.0 | 33.0 | 31.0 | 33.0 | 4100.0 |
| 2009-01-30 | ABX-DELISTED | Stock | 39.49 | 39.5 | 37.18 | 37.45 | 16606860.0 |
| 2009-01-30 | ACAD | Stock | 1.03 | 1.05 | 0.99 | 1.01 | 524600.0 |
| 2009-01-30 | ACAP-DELISTED | Stock | 43.07 | 43.36 | 41.98 | 42.52 | 56799.0 |
| 2009-01-30 | ACAS-DELISTED | Stock | 3.26 | 3.45 | 2.78 | 2.84 | 6483287.0 |
> showing 50 of 5,696 rows — these rows as CSV