PREVIEW / stock_daily / 2009-08-03
file: by_date/stock_daily/2009/2009-08-03.parquet size: 183 KB rows: 5,804 symbols: 3,451
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-03 | AAPL | Stock | 5.9004 | 5.9514 | 5.8882 | 5.9439 | 394240000.0 |
| 2009-08-03 | MSFT | Stock | 23.82 | 23.86 | 23.5 | 23.83 | 46902900.0 |
| 2009-08-03 | NVDA | Stock | 0.331 | 0.3358 | 0.3248 | 0.332 | 471900000.0 |
| 2009-08-03 | AMZN | Stock | 4.328 | 4.41 | 4.328 | 4.372 | 133260000.0 |
| 2009-08-03 | TLT | Stock | 93.81 | 93.87 | 92.61 | 93.06 | 4030110.0 |
| 2009-08-03 | ES | Stock | 23.19 | 23.31 | 22.93 | 23.29 | 1952500.0 |
| 2009-08-03 | CL | Stock | 36.32 | 36.32 | 35.72 | 36.065 | 9429600.0 |
| 2009-08-03 | A | Stock | 16.8884 | 17.1745 | 16.7954 | 17.1316 | 3866029.0 |
| 2009-08-03 | AABA-DELISTED | Stock | 14.58 | 14.62 | 14.3 | 14.35 | 43302158.0 |
| 2009-08-03 | AACC-DELISTED | Stock | 7.82 | 7.82 | 7.3 | 7.51 | 39237.0 |
| 2009-08-03 | AACG | Stock | 8.74 | 8.94 | 8.01 | 8.08 | 9100.0 |
| 2009-08-03 | AAI-DELISTED | Stock | 7.23 | 7.39 | 6.93 | 7.01 | 2739987.0 |
| 2009-08-03 | AAIC-DELISTED | Stock | 8.2 | 9.2 | 8.0 | 8.5 | 804731.0 |
| 2009-08-03 | AAME | Stock | 0.69 | 0.69 | 0.69 | 0.69 | 100.0 |
| 2009-08-03 | AAON | Stock | 3.8874 | 4.0494 | 3.8558 | 4.0494 | 335137.0 |
| 2009-08-03 | AAP | Stock | 46.53 | 47.08 | 45.68 | 47.06 | 1211600.0 |
| 2009-08-03 | AATI-DELISTED | Stock | 4.94 | 5.07 | 4.7 | 4.89 | 297053.0 |
| 2009-08-03 | AAU-DELISTED | Stock | 0.69 | 0.71 | 0.68 | 0.69 | 38668.0 |
| 2009-08-03 | AAUAF-DELISTED | Stock | 0.69 | 0.71 | 0.68 | 0.69 | 43989.0 |
| 2009-08-03 | AAV-DELISTED | Stock | 5.29 | 5.33 | 5.14 | 5.2 | 745576.0 |
| 2009-08-03 | AAWW-DELISTED | Stock | 25.36 | 25.93 | 24.79 | 25.68 | 265464.0 |
| 2009-08-03 | AAXJ | Stock | 51.26 | 51.69 | 51.05 | 51.6 | 199931.0 |
| 2009-08-03 | AAXN-DELISTED | Stock | 5.36 | 5.37 | 5.19 | 5.31 | 332487.0 |
| 2009-08-03 | AB | Stock | 20.94 | 21.03 | 20.52 | 20.7 | 1544800.0 |
| 2009-08-03 | ABAX-DELISTED | Stock | 26.55 | 27.88 | 26.5 | 27.28 | 674546.0 |
| 2009-08-03 | ABB-DELISTED | Stock | 18.7 | 19.0275 | 18.63 | 18.97 | 5047189.0 |
| 2009-08-03 | ABBC-DELISTED | Stock | 8.23 | 8.45 | 8.18 | 8.36 | 45339.0 |
| 2009-08-03 | ABBNY-DELISTED | Stock | 18.7 | 19.0275 | 18.63 | 18.99 | 5052980.0 |
| 2009-08-03 | ABC-DELISTED | Stock | 19.79 | 19.88 | 19.26 | 19.84 | 3934844.0 |
| 2009-08-03 | ABCB | Stock | 6.2249 | 6.9252 | 6.1957 | 6.7502 | 82764.0 |
| 2009-08-03 | ABCO-DELISTED | Stock | 12.91 | 13.405 | 12.735 | 13.265 | 184248.0 |
| 2009-08-03 | ABCW-DELISTED | Stock | 1.37 | 1.39 | 1.35 | 1.39 | 60810.0 |
| 2009-08-03 | ABD-DELISTED | Stock | 4.34 | 4.64 | 4.3 | 4.5 | 774530.0 |
| 2009-08-03 | ABE-DELISTED | Stock | 16.63 | 16.89 | 16.61 | 16.89 | 10171.0 |
| 2009-08-03 | ABEO | Stock | 5687.5 | 6100.0 | 5687.5 | 5812.5 | 29.0 |
| 2009-08-03 | ABFS-DELISTED | Stock | 28.68 | 28.89 | 27.71 | 28.64 | 568037.0 |
| 2009-08-03 | ABG | Stock | 14.26 | 14.26 | 13.59 | 13.98 | 477600.0 |
| 2009-08-03 | ABII-DELISTED | Stock | 30.46 | 31.98 | 30.05 | 30.37 | 73343.0 |
| 2009-08-03 | ABK-DELISTED | Stock | 0.77 | 0.78 | 0.74 | 0.76 | 6053212.0 |
| 2009-08-03 | ABM | Stock | 21.31 | 21.49 | 20.84 | 21.49 | 136200.0 |
| 2009-08-03 | ABMD-DELISTED | Stock | 7.55 | 7.78 | 7.31 | 7.68 | 246212.0 |
| 2009-08-03 | ABR | Stock | 1.85 | 1.88 | 1.74 | 1.76 | 123200.0 |
| 2009-08-03 | ABT | Stock | 21.6294 | 21.6486 | 21.2072 | 21.5046 | 21023551.0 |
| 2009-08-03 | ABTL-DELISTED | Stock | 2.501 | 2.5521 | 2.3739 | 2.45 | 27552.0 |
| 2009-08-03 | ABV-DELISTED | Stock | 72.55 | 74.91 | 72.29 | 73.85 | 824273.0 |
| 2009-08-03 | ABVA-DELISTED | Stock | 2.6 | 2.6 | 2.6 | 2.6 | 362.0 |
| 2009-08-03 | ABVT-DELISTED | Stock | 82.0 | 83.94 | 81.5 | 83.24 | 30548.0 |
| 2009-08-03 | ABX-DELISTED | Stock | 35.68 | 36.61 | 35.58 | 36.13 | 7979274.0 |
| 2009-08-03 | ACAD | Stock | 4.4 | 4.82 | 4.25 | 4.67 | 2101800.0 |
| 2009-08-03 | ACAP-DELISTED | Stock | 35.2 | 35.91 | 34.02 | 34.35 | 95914.0 |
> showing 50 of 5,804 rows — these rows as CSV