PREVIEW / stock_daily / 2009-04-20
file: by_date/stock_daily/2009/2009-04-20.parquet size: 176 KB rows: 5,714 symbols: 3,407
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-20 | AAPL | Stock | 4.3475 | 4.3925 | 4.2557 | 4.3036 | 466466000.0 |
| 2009-04-20 | MSFT | Stock | 18.89 | 18.95 | 18.57 | 18.61 | 62937200.0 |
| 2009-04-20 | NVDA | Stock | 0.2828 | 0.2852 | 0.2748 | 0.2763 | 590660000.0 |
| 2009-04-20 | AMZN | Stock | 3.922 | 3.9895 | 3.8415 | 3.8785 | 173738000.0 |
| 2009-04-20 | TLT | Stock | 102.63 | 103.4025 | 102.45 | 103.24 | 1714341.0 |
| 2009-04-20 | ES | Stock | 21.06 | 21.26 | 20.82 | 21.0 | 1420600.0 |
| 2009-04-20 | CL | Stock | 30.3 | 30.565 | 30.115 | 30.24 | 6097000.0 |
| 2009-04-20 | A | Stock | 12.1316 | 12.1674 | 11.5522 | 11.7454 | 6736682.0 |
| 2009-04-20 | AABA-DELISTED | Stock | 14.16 | 14.25 | 13.6 | 13.67 | 13307772.0 |
| 2009-04-20 | AACC-DELISTED | Stock | 6.59 | 6.65 | 6.033 | 6.095 | 44702.0 |
| 2009-04-20 | AACG | Stock | 4.21 | 4.39 | 4.11 | 4.3 | 3100.0 |
| 2009-04-20 | AAI-DELISTED | Stock | 5.31 | 5.43 | 5.09 | 5.32 | 2757953.0 |
| 2009-04-20 | AAIC-DELISTED | Stock | 6.6 | 6.8 | 5.8 | 6.0 | 819266.0 |
| 2009-04-20 | AAME | Stock | 0.74 | 0.75 | 0.72 | 0.72 | 10900.0 |
| 2009-04-20 | AAON | Stock | 3.3817 | 3.5002 | 3.198 | 3.283 | 462206.0 |
| 2009-04-20 | AAP | Stock | 41.71 | 43.07 | 41.53 | 41.82 | 1119400.0 |
| 2009-04-20 | AATI-DELISTED | Stock | 4.65 | 4.73 | 4.56 | 4.69 | 227194.0 |
| 2009-04-20 | AAU-DELISTED | Stock | 0.74 | 0.74 | 0.59 | 0.61 | 185137.0 |
| 2009-04-20 | AAUAF-DELISTED | Stock | 0.74 | 0.74 | 0.59 | 0.61 | 185937.0 |
| 2009-04-20 | AAV-DELISTED | Stock | 3.05 | 3.05 | 2.73 | 2.78 | 1027633.0 |
| 2009-04-20 | AAWW-DELISTED | Stock | 23.37 | 23.38 | 20.73 | 20.95 | 237067.0 |
| 2009-04-20 | AAXJ | Stock | 37.21 | 37.21 | 36.13 | 36.32 | 71184.0 |
| 2009-04-20 | AAXN-DELISTED | Stock | 4.97 | 5.02 | 4.68 | 4.71 | 571720.0 |
| 2009-04-20 | AB | Stock | 19.35 | 19.35 | 18.31 | 18.85 | 1000700.0 |
| 2009-04-20 | ABAX-DELISTED | Stock | 15.0 | 15.23 | 14.39 | 15.05 | 261510.0 |
| 2009-04-20 | ABB-DELISTED | Stock | 14.67 | 14.68 | 14.31 | 14.33 | 2762477.0 |
| 2009-04-20 | ABBC-DELISTED | Stock | 8.84 | 8.84 | 8.36 | 8.55 | 91099.0 |
| 2009-04-20 | ABBNY-DELISTED | Stock | 14.67 | 14.68 | 14.31 | 14.31 | 2763221.0 |
| 2009-04-20 | ABC-DELISTED | Stock | 17.35 | 17.64 | 17.2 | 17.36 | 2890490.0 |
| 2009-04-20 | ABCB | Stock | 7.6256 | 7.6256 | 5.9039 | 6.1082 | 39686.0 |
| 2009-04-20 | ABCO-DELISTED | Stock | 9.067 | 9.157 | 8.693 | 8.698 | 120551.0 |
| 2009-04-20 | ABCW-DELISTED | Stock | 1.59 | 1.71 | 1.49 | 1.69 | 228110.0 |
| 2009-04-20 | ABD-DELISTED | Stock | 1.33 | 1.37 | 1.23 | 1.24 | 235780.0 |
| 2009-04-20 | ABE-DELISTED | Stock | 12.66 | 12.96 | 12.12 | 12.31 | 18877.0 |
| 2009-04-20 | ABEO | Stock | 1987.5 | 1987.5 | 1925.0 | 1925.0 | 2.0 |
| 2009-04-20 | ABFS-DELISTED | Stock | 24.42 | 24.43 | 21.84 | 21.94 | 563646.0 |
| 2009-04-20 | ABG | Stock | 6.8 | 6.98 | 6.01 | 6.04 | 542300.0 |
| 2009-04-20 | ABII-DELISTED | Stock | 46.35 | 46.5499 | 43.84 | 45.09 | 19109.0 |
| 2009-04-20 | ABK-DELISTED | Stock | 1.02 | 1.04 | 0.85 | 0.86 | 11003384.0 |
| 2009-04-20 | ABM | Stock | 17.41 | 17.42 | 16.8 | 16.88 | 224200.0 |
| 2009-04-20 | ABMD-DELISTED | Stock | 5.61 | 5.63 | 5.06 | 5.25 | 326475.0 |
| 2009-04-20 | ABR | Stock | 1.26 | 1.36 | 1.26 | 1.36 | 228100.0 |
| 2009-04-20 | ABT | Stock | 21.0728 | 21.3223 | 20.9817 | 21.1544 | 25768237.0 |
| 2009-04-20 | ABTL-DELISTED | Stock | 1.7 | 2.25 | 1.65 | 2.25 | 774027.0 |
| 2009-04-20 | ABV-DELISTED | Stock | 51.18 | 51.18 | 50.39 | 50.62 | 592887.0 |
| 2009-04-20 | ABVA-DELISTED | Stock | 1.95 | 1.95 | 1.95 | 1.95 | 9283.0 |
| 2009-04-20 | ABVT-DELISTED | Stock | 49.0 | 49.0 | 49.0 | 49.0 | 5245.0 |
| 2009-04-20 | ABX-DELISTED | Stock | 28.07 | 29.28 | 27.89 | 29.03 | 13236946.0 |
| 2009-04-20 | ACAD | Stock | 1.05 | 1.05 | 1.0 | 1.0 | 103000.0 |
| 2009-04-20 | ACAP-DELISTED | Stock | 40.85 | 41.68 | 40.2 | 40.31 | 37615.0 |
> showing 50 of 5,714 rows — these rows as CSV