PREVIEW / stock_daily / 2009-07-22
file: by_date/stock_daily/2009/2009-07-22.parquet size: 180 KB rows: 5,751 symbols: 3,424
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-07-22 | AAPL | Stock | 5.6354 | 5.6689 | 5.5754 | 5.5979 | 874104000.0 |
| 2009-07-22 | MSFT | Stock | 24.7 | 24.9 | 24.51 | 24.8 | 66192500.0 |
| 2009-07-22 | NVDA | Stock | 0.2932 | 0.3095 | 0.2912 | 0.3068 | 600908000.0 |
| 2009-07-22 | AMZN | Stock | 4.4325 | 4.4615 | 4.389 | 4.4395 | 106592000.0 |
| 2009-07-22 | TLT | Stock | 93.4 | 93.5257 | 92.36 | 92.71 | 1986706.0 |
| 2009-07-22 | ES | Stock | 22.17 | 22.5 | 22.17 | 22.28 | 817400.0 |
| 2009-07-22 | CL | Stock | 36.715 | 37.14 | 36.6 | 36.72 | 6398400.0 |
| 2009-07-22 | A | Stock | 15.3362 | 15.4578 | 15.1073 | 15.3791 | 6473439.0 |
| 2009-07-22 | AABA-DELISTED | Stock | 16.19 | 17.48 | 16.12 | 17.36 | 53030582.0 |
| 2009-07-22 | AACC-DELISTED | Stock | 8.14 | 8.5 | 8.14 | 8.5 | 37357.0 |
| 2009-07-22 | AACG | Stock | 8.2 | 8.83 | 8.2 | 8.83 | 6700.0 |
| 2009-07-22 | AAI-DELISTED | Stock | 6.1 | 6.75 | 5.9 | 6.37 | 8180547.0 |
| 2009-07-22 | AAIC-DELISTED | Stock | 7.6 | 8.4 | 7.6 | 8.4 | 285396.0 |
| 2009-07-22 | AAON | Stock | 3.9783 | 4.0375 | 3.9407 | 4.0217 | 278944.0 |
| 2009-07-22 | AAP | Stock | 46.12 | 47.09 | 45.8 | 46.46 | 1010500.0 |
| 2009-07-22 | AATI-DELISTED | Stock | 4.76 | 5.125 | 4.67 | 5.02 | 498727.0 |
| 2009-07-22 | AAU-DELISTED | Stock | 0.67 | 0.71 | 0.65 | 0.71 | 42800.0 |
| 2009-07-22 | AAUAF-DELISTED | Stock | 0.67 | 0.71 | 0.65 | 0.71 | 44400.0 |
| 2009-07-22 | AAV-DELISTED | Stock | 5.0 | 5.1 | 4.89 | 5.0901 | 768757.0 |
| 2009-07-22 | AAWW-DELISTED | Stock | 22.96 | 23.786 | 22.4 | 23.61 | 196030.0 |
| 2009-07-22 | AAXJ | Stock | 47.39 | 48.99 | 47.2 | 47.82 | 193800.0 |
| 2009-07-22 | AAXN-DELISTED | Stock | 5.07 | 5.3 | 5.04 | 5.29 | 418849.0 |
| 2009-07-22 | AB | Stock | 21.95 | 22.41 | 21.43 | 21.75 | 803700.0 |
| 2009-07-22 | ABAX-DELISTED | Stock | 19.78 | 19.95 | 19.62 | 19.67 | 108927.0 |
| 2009-07-22 | ABB-DELISTED | Stock | 16.13 | 16.42 | 16.05 | 16.14 | 6015866.0 |
| 2009-07-22 | ABBC-DELISTED | Stock | 8.47 | 8.58 | 8.39 | 8.5 | 32920.0 |
| 2009-07-22 | ABBNY-DELISTED | Stock | 16.13 | 16.42 | 16.05 | 16.13 | 6167166.0 |
| 2009-07-22 | ABC-DELISTED | Stock | 19.17 | 19.4 | 18.71 | 18.78 | 3871784.0 |
| 2009-07-22 | ABCB | Stock | 6.0596 | 6.2346 | 5.972 | 6.2346 | 14702.0 |
| 2009-07-22 | ABCO-DELISTED | Stock | 12.245 | 12.31 | 11.84 | 11.895 | 165614.0 |
| 2009-07-22 | ABCW-DELISTED | Stock | 1.1815 | 1.1919 | 1.1296 | 1.14 | 29270.0 |
| 2009-07-22 | ABD-DELISTED | Stock | 3.0901 | 3.0901 | 2.8995 | 3.0299 | 115980.0 |
| 2009-07-22 | ABE-DELISTED | Stock | 16.17 | 16.36 | 16.17 | 16.26 | 3433.0 |
| 2009-07-22 | ABEO | Stock | 2500.0 | 2725.0 | 2500.0 | 2587.5 | 37.0 |
| 2009-07-22 | ABFS-DELISTED | Stock | 24.9 | 26.33 | 24.02 | 24.46 | 1699543.0 |
| 2009-07-22 | ABG | Stock | 11.87 | 12.38 | 11.81 | 12.08 | 198000.0 |
| 2009-07-22 | ABII-DELISTED | Stock | 32.09 | 32.48 | 31.44 | 31.9 | 13058.0 |
| 2009-07-22 | ABK-DELISTED | Stock | 0.94 | 0.95 | 0.88 | 0.88 | 2542108.0 |
| 2009-07-22 | ABM | Stock | 19.27 | 20.0 | 19.21 | 19.76 | 195500.0 |
| 2009-07-22 | ABMD-DELISTED | Stock | 7.7 | 7.7 | 7.44 | 7.53 | 243858.0 |
| 2009-07-22 | ABR | Stock | 1.57 | 1.6 | 1.55 | 1.55 | 45200.0 |
| 2009-07-22 | ABT | Stock | 21.5958 | 21.711 | 21.116 | 21.2168 | 21022926.0 |
| 2009-07-22 | ABTL-DELISTED | Stock | 2.551 | 2.7041 | 2.4995 | 2.5 | 41602.0 |
| 2009-07-22 | ABV-DELISTED | Stock | 69.41 | 69.59 | 67.99 | 68.12 | 634974.0 |
| 2009-07-22 | ABVA-DELISTED | Stock | 2.34 | 2.34 | 2.34 | 2.34 | 500.0 |
| 2009-07-22 | ABVT-DELISTED | Stock | 77.85 | 77.85 | 76.61 | 77.25 | 15737.0 |
| 2009-07-22 | ABX-DELISTED | Stock | 35.05 | 35.71 | 34.77 | 34.97 | 5622993.0 |
| 2009-07-22 | ACAD | Stock | 2.4 | 2.52 | 2.36 | 2.42 | 493100.0 |
| 2009-07-22 | ACAP-DELISTED | Stock | 38.39 | 39.52 | 38.39 | 39.33 | 13337.0 |
| 2009-07-22 | ACAS-DELISTED | Stock | 2.69 | 2.95 | 2.65 | 2.91 | 2255878.0 |
> showing 50 of 5,751 rows — these rows as CSV