PREVIEW / stock_daily / 2009-06-30
file: by_date/stock_daily/2009/2009-06-30.parquet size: 181 KB rows: 5,759 symbols: 3,427
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-06-30 | AAPL | Stock | 5.0921 | 5.1357 | 5.0643 | 5.0868 | 434224000.0 |
| 2009-06-30 | MSFT | Stock | 23.97 | 24.24 | 23.63 | 23.77 | 66452400.0 |
| 2009-06-30 | NVDA | Stock | 0.2882 | 0.2922 | 0.277 | 0.2822 | 589844000.0 |
| 2009-06-30 | AMZN | Stock | 4.181 | 4.246 | 4.1235 | 4.183 | 159696000.0 |
| 2009-06-30 | TLT | Stock | 94.19 | 95.11 | 93.81 | 94.57 | 3743764.0 |
| 2009-06-30 | ES | Stock | 22.39 | 22.58 | 22.14 | 22.31 | 1286600.0 |
| 2009-06-30 | CL | Stock | 35.73 | 35.945 | 35.05 | 35.37 | 7424200.0 |
| 2009-06-30 | A | Stock | 14.6352 | 14.7067 | 14.2918 | 14.5279 | 5433047.0 |
| 2009-06-30 | AABA-DELISTED | Stock | 15.89 | 15.9 | 15.35 | 15.66 | 15631504.0 |
| 2009-06-30 | AACC-DELISTED | Stock | 8.09 | 8.22 | 7.62 | 7.7 | 59315.0 |
| 2009-06-30 | AACG | Stock | 8.85 | 9.04 | 8.64 | 8.87 | 11600.0 |
| 2009-06-30 | AAI-DELISTED | Stock | 6.16 | 6.29 | 5.96 | 6.18 | 2591297.0 |
| 2009-06-30 | AAIC-DELISTED | Stock | 8.2 | 8.2 | 7.0 | 7.6 | 610624.0 |
| 2009-06-30 | AAME | Stock | 0.74 | 0.74 | 0.74 | 0.74 | 3800.0 |
| 2009-06-30 | AAON | Stock | 4.0928 | 4.1007 | 3.6444 | 3.9348 | 366019.0 |
| 2009-06-30 | AAP | Stock | 41.62 | 42.19 | 41.22 | 41.49 | 1393500.0 |
| 2009-06-30 | AATI-DELISTED | Stock | 4.58 | 4.65 | 4.45 | 4.59 | 226712.0 |
| 2009-06-30 | AAU-DELISTED | Stock | 0.6416 | 0.65 | 0.62 | 0.62 | 36033.0 |
| 2009-06-30 | AAUAF-DELISTED | Stock | 0.6416 | 0.65 | 0.62 | 0.62 | 36133.0 |
| 2009-06-30 | AAV-DELISTED | Stock | 4.21 | 4.3 | 4.2 | 4.25 | 527912.0 |
| 2009-06-30 | AAWW-DELISTED | Stock | 23.73 | 24.2284 | 22.92 | 23.19 | 184161.0 |
| 2009-06-30 | AAXJ | Stock | 44.3 | 44.44 | 43.62 | 43.78 | 193919.0 |
| 2009-06-30 | AAXN-DELISTED | Stock | 4.62 | 4.74 | 4.55 | 4.56 | 462499.0 |
| 2009-06-30 | AB | Stock | 20.13 | 20.29 | 19.34 | 20.09 | 340400.0 |
| 2009-06-30 | ABAX-DELISTED | Stock | 20.39 | 20.73 | 20.2728 | 20.54 | 126607.0 |
| 2009-06-30 | ABB-DELISTED | Stock | 15.97 | 16.08 | 15.58 | 15.82 | 3159731.0 |
| 2009-06-30 | ABBC-DELISTED | Stock | 8.21 | 8.3 | 7.96 | 7.96 | 49242.0 |
| 2009-06-30 | ABBNY-DELISTED | Stock | 15.97 | 16.08 | 15.58 | 15.78 | 3165231.0 |
| 2009-06-30 | ABC-DELISTED | Stock | 18.03 | 18.15 | 17.59 | 17.76 | 3114192.0 |
| 2009-06-30 | ABCB | Stock | 6.2444 | 6.5167 | 5.8359 | 6.1471 | 79371.0 |
| 2009-06-30 | ABCO-DELISTED | Stock | 12.94 | 13.145 | 12.74 | 12.85 | 122040.0 |
| 2009-06-30 | ABCW-DELISTED | Stock | 1.15 | 1.34 | 1.15 | 1.3 | 310290.0 |
| 2009-06-30 | ABD-DELISTED | Stock | 3.01 | 3.07 | 2.6994 | 2.82 | 518630.0 |
| 2009-06-30 | ABE-DELISTED | Stock | 15.27 | 15.27 | 14.71 | 15.03 | 5160.0 |
| 2009-06-30 | ABEO | Stock | 2812.5 | 2812.5 | 2812.5 | 2812.5 | 4.0 |
| 2009-06-30 | ABFS-DELISTED | Stock | 26.98 | 26.98 | 25.7 | 26.35 | 773717.0 |
| 2009-06-30 | ABG | Stock | 10.97 | 11.02 | 10.11 | 10.24 | 393000.0 |
| 2009-06-30 | ABII-DELISTED | Stock | 37.0 | 37.44 | 36.18 | 36.86 | 25896.0 |
| 2009-06-30 | ABK-DELISTED | Stock | 0.97 | 0.97 | 0.92 | 0.92 | 2591375.0 |
| 2009-06-30 | ABM | Stock | 18.11 | 18.3 | 17.96 | 18.07 | 223600.0 |
| 2009-06-30 | ABMD-DELISTED | Stock | 8.65 | 8.89 | 8.645 | 8.82 | 286912.0 |
| 2009-06-30 | ABR | Stock | 1.72 | 1.77 | 1.63 | 1.75 | 167700.0 |
| 2009-06-30 | ABT | Stock | 22.661 | 22.8625 | 22.1955 | 22.5698 | 29462068.0 |
| 2009-06-30 | ABTL-DELISTED | Stock | 2.13 | 2.15 | 2.1049 | 2.15 | 18621.0 |
| 2009-06-30 | ABV-DELISTED | Stock | 65.64 | 65.64 | 64.25 | 64.72 | 641891.0 |
| 2009-06-30 | ABVA-DELISTED | Stock | 2.5 | 2.5 | 2.5 | 2.5 | 790.0 |
| 2009-06-30 | ABVT-DELISTED | Stock | 81.6178 | 82.89 | 80.53 | 81.61 | 55017.0 |
| 2009-06-30 | ABX-DELISTED | Stock | 34.7 | 35.01 | 33.37 | 33.58 | 7482961.0 |
| 2009-06-30 | ACAD | Stock | 2.07 | 2.23 | 1.99 | 2.19 | 155600.0 |
| 2009-06-30 | ACAP-DELISTED | Stock | 39.57 | 39.57 | 38.99 | 39.22 | 35829.0 |
> showing 50 of 5,759 rows — these rows as CSV