PREVIEW / stock_daily / 2009-06-10
file: by_date/stock_daily/2009/2009-06-10.parquet size: 182 KB rows: 5,780 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-06-10 | AAPL | Stock | 5.0814 | 5.0839 | 4.9393 | 5.0089 | 688623600.0 |
| 2009-06-10 | MSFT | Stock | 22.17 | 22.62 | 22.12 | 22.55 | 61297200.0 |
| 2009-06-10 | NVDA | Stock | 0.2855 | 0.2948 | 0.2792 | 0.293 | 833320000.0 |
| 2009-06-10 | AMZN | Stock | 4.379 | 4.428 | 4.2415 | 4.3295 | 121472000.0 |
| 2009-06-10 | TLT | Stock | 88.87 | 89.43 | 87.56 | 88.19 | 12143036.0 |
| 2009-06-10 | ES | Stock | 21.07 | 21.32 | 20.85 | 21.16 | 1292200.0 |
| 2009-06-10 | CL | Stock | 35.075 | 35.4 | 34.975 | 35.18 | 8693400.0 |
| 2009-06-10 | A | Stock | 14.2489 | 14.2847 | 13.6981 | 13.9127 | 3781730.0 |
| 2009-06-10 | AABA-DELISTED | Stock | 16.72 | 16.72 | 16.1 | 16.34 | 15683008.0 |
| 2009-06-10 | AACC-DELISTED | Stock | 9.01 | 9.01 | 8.79 | 8.92 | 32022.0 |
| 2009-06-10 | AACG | Stock | 6.97 | 7.0 | 6.87 | 6.91 | 20500.0 |
| 2009-06-10 | AAI-DELISTED | Stock | 5.99 | 6.03 | 5.35 | 5.53 | 3963507.0 |
| 2009-06-10 | AAIC-DELISTED | Stock | 10.0 | 10.0 | 6.202 | 9.4 | 667775.0 |
| 2009-06-10 | AAON | Stock | 4.156 | 4.2568 | 3.996 | 4.0869 | 323494.0 |
| 2009-06-10 | AAP | Stock | 44.47 | 44.5 | 42.86 | 43.5 | 1600300.0 |
| 2009-06-10 | AATI-DELISTED | Stock | 4.61 | 4.79 | 4.5 | 4.62 | 487797.0 |
| 2009-06-10 | AAU-DELISTED | Stock | 0.75 | 0.779 | 0.75 | 0.76 | 53900.0 |
| 2009-06-10 | AAUAF-DELISTED | Stock | 0.75 | 0.779 | 0.75 | 0.76 | 54650.0 |
| 2009-06-10 | AAV-DELISTED | Stock | 5.19 | 5.47 | 5.13 | 5.32 | 1878963.0 |
| 2009-06-10 | AAWW-DELISTED | Stock | 25.21 | 25.6 | 24.9 | 25.55 | 242844.0 |
| 2009-06-10 | AAXJ | Stock | 46.18 | 46.18 | 45.15 | 45.73 | 795658.0 |
| 2009-06-10 | AAXN-DELISTED | Stock | 4.55 | 4.55 | 4.31 | 4.44 | 391767.0 |
| 2009-06-10 | AB | Stock | 22.1 | 22.29 | 21.24 | 21.55 | 475200.0 |
| 2009-06-10 | ABAX-DELISTED | Stock | 17.75 | 18.1 | 17.1 | 17.35 | 161203.0 |
| 2009-06-10 | ABB-DELISTED | Stock | 16.71 | 16.73 | 16.18 | 16.42 | 4313233.0 |
| 2009-06-10 | ABBC-DELISTED | Stock | 9.01 | 9.06 | 8.13 | 8.27 | 75842.0 |
| 2009-06-10 | ABBNY-DELISTED | Stock | 16.71 | 16.73 | 16.18 | 16.41 | 4531118.0 |
| 2009-06-10 | ABC-DELISTED | Stock | 17.99 | 18.05 | 17.85 | 17.98 | 2083284.0 |
| 2009-06-10 | ABCB | Stock | 6.5362 | 6.5362 | 5.9428 | 6.1374 | 31461.0 |
| 2009-06-10 | ABCO-DELISTED | Stock | 12.595 | 12.655 | 12.29 | 12.585 | 282298.0 |
| 2009-06-10 | ABCW-DELISTED | Stock | 1.46 | 1.57 | 1.32 | 1.34 | 183130.0 |
| 2009-06-10 | ABD-DELISTED | Stock | 3.33 | 3.45 | 3.26 | 3.38 | 293830.0 |
| 2009-06-10 | ABE-DELISTED | Stock | 15.67 | 15.83 | 15.59 | 15.6 | 14586.0 |
| 2009-06-10 | ABEO | Stock | 2562.5 | 2812.5 | 2475.0 | 2750.0 | 26.0 |
| 2009-06-10 | ABFS-DELISTED | Stock | 30.67 | 30.9 | 28.95 | 29.61 | 557980.0 |
| 2009-06-10 | ABG | Stock | 12.1 | 12.15 | 11.19 | 11.94 | 473700.0 |
| 2009-06-10 | ABII-DELISTED | Stock | 43.49 | 43.53 | 41.352 | 41.95 | 25939.0 |
| 2009-06-10 | ABK-DELISTED | Stock | 1.31 | 1.32 | 1.24 | 1.27 | 4582301.0 |
| 2009-06-10 | ABM | Stock | 19.0 | 19.02 | 18.44 | 18.73 | 351600.0 |
| 2009-06-10 | ABMD-DELISTED | Stock | 7.62 | 7.74 | 7.26 | 7.37 | 565483.0 |
| 2009-06-10 | ABR | Stock | 1.7 | 1.7 | 1.6 | 1.61 | 174300.0 |
| 2009-06-10 | ABT | Stock | 21.3991 | 21.4471 | 21.0632 | 21.1832 | 20868904.0 |
| 2009-06-10 | ABTL-DELISTED | Stock | 2.1753 | 2.1753 | 2.1247 | 2.15 | 2915.0 |
| 2009-06-10 | ABV-DELISTED | Stock | 66.56 | 66.78 | 65.1 | 66.14 | 452525.0 |
| 2009-06-10 | ABVA-DELISTED | Stock | 3.09 | 3.1 | 2.6 | 2.6 | 1709.0 |
| 2009-06-10 | ABVT-DELISTED | Stock | 82.75 | 83.0 | 80.0 | 80.64 | 46334.0 |
| 2009-06-10 | ABX-DELISTED | Stock | 36.64 | 36.76 | 34.73 | 35.1 | 13726847.0 |
| 2009-06-10 | ACAD | Stock | 2.32 | 2.46 | 2.25 | 2.28 | 184200.0 |
| 2009-06-10 | ACAP-DELISTED | Stock | 41.93 | 41.94 | 40.47 | 40.9 | 34223.0 |
| 2009-06-10 | ACAS-DELISTED | Stock | 2.85 | 2.85 | 2.7 | 2.76 | 2362074.0 |
> showing 50 of 5,780 rows — these rows as CSV