PREVIEW / stock_daily / 2009-04-27
file: by_date/stock_daily/2009/2009-04-27.parquet size: 177 KB rows: 5,762 symbols: 3,444
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-04-27 | AAPL | Stock | 4.3893 | 4.4643 | 4.3807 | 4.4546 | 480690000.0 |
| 2009-04-27 | MSFT | Stock | 20.55 | 20.82 | 20.28 | 20.4 | 68219600.0 |
| 2009-04-27 | NVDA | Stock | 0.282 | 0.29 | 0.2738 | 0.2755 | 787024000.0 |
| 2009-04-27 | AMZN | Stock | 4.194 | 4.249 | 4.1105 | 4.156 | 194118000.0 |
| 2009-04-27 | TLT | Stock | 101.07 | 101.19 | 100.06 | 101.0 | 2294515.0 |
| 2009-04-27 | ES | Stock | 20.25 | 20.83 | 20.0 | 20.73 | 2479500.0 |
| 2009-04-27 | CL | Stock | 29.54 | 30.1 | 29.395 | 29.685 | 6155200.0 |
| 2009-04-27 | A | Stock | 11.9313 | 12.3104 | 11.9313 | 12.103 | 4380913.0 |
| 2009-04-27 | AABA-DELISTED | Stock | 14.48 | 14.55 | 13.88 | 13.89 | 21708702.0 |
| 2009-04-27 | AACC-DELISTED | Stock | 6.2 | 6.39 | 5.99 | 6.01 | 21356.0 |
| 2009-04-27 | AACG | Stock | 4.04 | 4.15 | 3.97 | 4.0 | 23300.0 |
| 2009-04-27 | AAI-DELISTED | Stock | 7.02 | 7.205 | 6.67 | 6.91 | 7206951.0 |
| 2009-04-27 | AAIC-DELISTED | Stock | 5.8 | 5.8 | 4.998 | 5.0 | 369092.0 |
| 2009-04-27 | AAON | Stock | 3.5062 | 3.6523 | 3.5062 | 3.6267 | 456131.0 |
| 2009-04-27 | AAP | Stock | 42.45 | 43.08 | 42.02 | 42.47 | 1713100.0 |
| 2009-04-27 | AATI-DELISTED | Stock | 4.87 | 5.14 | 4.76 | 4.79 | 427620.0 |
| 2009-04-27 | AAU-DELISTED | Stock | 0.67 | 0.7 | 0.66 | 0.67 | 132627.0 |
| 2009-04-27 | AAUAF-DELISTED | Stock | 0.67 | 0.7 | 0.66 | 0.67 | 134627.0 |
| 2009-04-27 | AAV-DELISTED | Stock | 2.81 | 2.88 | 2.75 | 2.8 | 497999.0 |
| 2009-04-27 | AAWW-DELISTED | Stock | 25.26 | 25.61 | 23.18 | 23.87 | 177971.0 |
| 2009-04-27 | AAXJ | Stock | 36.35 | 36.91 | 36.24 | 36.24 | 238196.0 |
| 2009-04-27 | AAXN-DELISTED | Stock | 4.88 | 5.01 | 4.74 | 4.75 | 932029.0 |
| 2009-04-27 | AB | Stock | 15.68 | 16.0 | 15.38 | 15.82 | 842900.0 |
| 2009-04-27 | ABAX-DELISTED | Stock | 14.54 | 15.1725 | 14.52 | 14.75 | 205813.0 |
| 2009-04-27 | ABB-DELISTED | Stock | 14.43 | 14.82 | 14.4 | 14.58 | 2873246.0 |
| 2009-04-27 | ABBC-DELISTED | Stock | 8.52 | 8.92 | 8.52 | 8.7 | 42394.0 |
| 2009-04-27 | ABBNY-DELISTED | Stock | 14.43 | 14.82 | 14.4 | 14.58 | 2903830.0 |
| 2009-04-27 | ABC-DELISTED | Stock | 17.07 | 17.81 | 16.96 | 17.63 | 4232592.0 |
| 2009-04-27 | ABCB | Stock | 6.0596 | 6.2152 | 5.6608 | 5.6608 | 30433.0 |
| 2009-04-27 | ABCO-DELISTED | Stock | 8.043 | 8.297 | 8.043 | 8.177 | 372485.0 |
| 2009-04-27 | ABCW-DELISTED | Stock | 1.6549 | 1.655 | 1.5851 | 1.5951 | 88920.0 |
| 2009-04-27 | ABD-DELISTED | Stock | 2.135 | 2.135 | 1.771 | 1.83 | 321670.0 |
| 2009-04-27 | ABE-DELISTED | Stock | 13.28 | 13.298 | 13.09 | 13.28 | 27465.0 |
| 2009-04-27 | ABEO | Stock | 1712.5 | 1712.5 | 1687.5 | 1700.0 | 3.0 |
| 2009-04-27 | ABFS-DELISTED | Stock | 21.58 | 21.77 | 20.5 | 20.73 | 493705.0 |
| 2009-04-27 | ABG | Stock | 7.59 | 7.86 | 7.1 | 7.46 | 466200.0 |
| 2009-04-27 | ABII-DELISTED | Stock | 50.5 | 51.5 | 46.4767 | 46.5 | 25892.0 |
| 2009-04-27 | ABK-DELISTED | Stock | 0.97 | 1.01 | 0.95 | 0.96 | 4046657.0 |
| 2009-04-27 | ABM | Stock | 17.16 | 17.41 | 16.86 | 17.06 | 236600.0 |
| 2009-04-27 | ABMD-DELISTED | Stock | 5.8 | 5.95 | 5.78 | 5.84 | 317443.0 |
| 2009-04-27 | ABR | Stock | 1.48 | 1.84 | 1.48 | 1.66 | 346900.0 |
| 2009-04-27 | ABT | Stock | 20.6314 | 21.044 | 20.5642 | 20.7082 | 16169654.0 |
| 2009-04-27 | ABTL-DELISTED | Stock | 2.5243 | 2.7257 | 2.0194 | 2.6 | 96043.0 |
| 2009-04-27 | ABV-DELISTED | Stock | 52.76 | 54.06 | 52.5 | 52.61 | 957301.0 |
| 2009-04-27 | ABVA-DELISTED | Stock | 1.9 | 2.06 | 1.9 | 2.05 | 2026.0 |
| 2009-04-27 | ABVT-DELISTED | Stock | 49.0 | 49.0 | 48.5 | 49.0 | 6000.0 |
| 2009-04-27 | ABX-DELISTED | Stock | 30.37 | 30.71 | 29.74 | 30.24 | 7651553.0 |
| 2009-04-27 | ACAD | Stock | 0.94 | 0.97 | 0.88 | 0.92 | 75000.0 |
| 2009-04-27 | ACAP-DELISTED | Stock | 40.51 | 41.48 | 40.46 | 41.07 | 51726.0 |
| 2009-04-27 | ACAS-DELISTED | Stock | 2.68 | 2.805 | 2.64 | 2.66 | 2626168.0 |
> showing 50 of 5,762 rows — these rows as CSV