PREVIEW / stock_daily / 2009-01-06
file: by_date/stock_daily/2009/2009-01-06.parquet size: 179 KB rows: 5,760 symbols: 3,447
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-01-06 | AAPL | Stock | 3.4268 | 3.4704 | 3.2996 | 3.3221 | 1289310400.0 |
| 2009-01-06 | MSFT | Stock | 20.75 | 21.0 | 20.61 | 20.76 | 58083400.0 |
| 2009-01-06 | NVDA | Stock | 0.2283 | 0.2358 | 0.2232 | 0.2292 | 657904000.0 |
| 2009-01-06 | AMZN | Stock | 2.7275 | 2.911 | 2.6875 | 2.868 | 221602000.0 |
| 2009-01-06 | TLT | Stock | 111.62 | 113.26 | 111.0 | 112.21 | 4110015.0 |
| 2009-01-06 | CL | Stock | 34.01 | 34.38 | 33.16 | 33.25 | 9178400.0 |
| 2009-01-06 | A | Stock | 12.2318 | 13.3834 | 12.0815 | 12.9685 | 11834210.0 |
| 2009-01-06 | AABA-DELISTED | Stock | 12.95 | 13.24 | 12.88 | 13.0 | 9420191.0 |
| 2009-01-06 | AACC-DELISTED | Stock | 5.35 | 5.7 | 5.29 | 5.67 | 70493.0 |
| 2009-01-06 | AACG | Stock | 4.87 | 5.0 | 4.84 | 4.84 | 3600.0 |
| 2009-01-06 | AAI-DELISTED | Stock | 4.51 | 4.64 | 4.48 | 4.58 | 2162309.0 |
| 2009-01-06 | AAIC-DELISTED | Stock | 5.2 | 6.0 | 5.0 | 6.0 | 457259.0 |
| 2009-01-06 | AAME | Stock | 0.76 | 0.8 | 0.65 | 0.65 | 10800.0 |
| 2009-01-06 | AAON | Stock | 4.1481 | 4.1758 | 4.081 | 4.1284 | 1198800.0 |
| 2009-01-06 | AAP | Stock | 34.01 | 34.3 | 33.28 | 33.73 | 1159300.0 |
| 2009-01-06 | AATI-DELISTED | Stock | 2.85 | 3.26 | 2.85 | 3.15 | 439412.0 |
| 2009-01-06 | AAU-DELISTED | Stock | 0.74 | 0.75 | 0.7101 | 0.75 | 89587.0 |
| 2009-01-06 | AAUAF-DELISTED | Stock | 0.74 | 0.75 | 0.7101 | 0.75 | 89769.0 |
| 2009-01-06 | AAV-DELISTED | Stock | 4.99 | 5.2 | 4.99 | 5.04 | 1082921.0 |
| 2009-01-06 | AAWW-DELISTED | Stock | 20.42 | 22.13 | 19.98 | 21.93 | 201099.0 |
| 2009-01-06 | AAXJ | Stock | 35.66 | 36.28 | 35.66 | 36.09 | 145003.0 |
| 2009-01-06 | AAXN-DELISTED | Stock | 5.7 | 5.7 | 5.48 | 5.5 | 699790.0 |
| 2009-01-06 | AB | Stock | 22.21 | 23.27 | 22.21 | 22.54 | 941800.0 |
| 2009-01-06 | ABAX-DELISTED | Stock | 16.47 | 17.62 | 16.22 | 17.25 | 228816.0 |
| 2009-01-06 | ABB-DELISTED | Stock | 15.1 | 15.43 | 14.97 | 15.23 | 5284159.0 |
| 2009-01-06 | ABBC-DELISTED | Stock | 9.3 | 9.33 | 9.0 | 9.02 | 197656.0 |
| 2009-01-06 | ABBNY-DELISTED | Stock | 15.1 | 15.43 | 14.97 | 15.24 | 5296459.0 |
| 2009-01-06 | ABC-DELISTED | Stock | 18.27 | 18.48 | 17.92 | 18.06 | 2898776.0 |
| 2009-01-06 | ABCB | Stock | 11.4188 | 11.5355 | 10.7575 | 11.0297 | 36807.0 |
| 2009-01-06 | ABCO-DELISTED | Stock | 11.273 | 11.538 | 10.867 | 11.127 | 161240.0 |
| 2009-01-06 | ABCW-DELISTED | Stock | 2.39 | 2.5 | 2.34 | 2.4 | 124120.0 |
| 2009-01-06 | ABD-DELISTED | Stock | 3.93 | 4.79 | 3.92 | 4.5 | 466470.0 |
| 2009-01-06 | ABE-DELISTED | Stock | 14.36 | 14.39 | 14.0 | 14.3665 | 37397.0 |
| 2009-01-06 | ABEO | Stock | 1012.5 | 1125.0 | 1012.5 | 1125.0 | 1.0 |
| 2009-01-06 | ABFS-DELISTED | Stock | 30.11 | 30.29 | 29.03 | 29.7 | 447086.0 |
| 2009-01-06 | ABG | Stock | 4.48 | 5.05 | 4.48 | 4.91 | 466500.0 |
| 2009-01-06 | ABII-DELISTED | Stock | 68.17 | 70.75 | 68.17 | 70.75 | 20497.0 |
| 2009-01-06 | ABK-DELISTED | Stock | 1.55 | 1.5713 | 1.4 | 1.46 | 10267928.0 |
| 2009-01-06 | ABM | Stock | 18.74 | 19.2 | 18.47 | 18.91 | 295800.0 |
| 2009-01-06 | ABMD-DELISTED | Stock | 16.1 | 16.17 | 15.04 | 15.14 | 282919.0 |
| 2009-01-06 | ABR | Stock | 3.5 | 3.5 | 3.22 | 3.36 | 183800.0 |
| 2009-01-06 | ABT | Stock | 25.3574 | 25.535 | 24.0188 | 24.4314 | 29167570.0 |
| 2009-01-06 | ABTL-DELISTED | Stock | 2.7 | 3.0 | 2.4 | 2.7 | 27280.0 |
| 2009-01-06 | ABV-DELISTED | Stock | 46.68 | 47.13 | 45.38 | 46.72 | 967222.0 |
| 2009-01-06 | ABVA-DELISTED | Stock | 1.52 | 2.27 | 1.4 | 1.46 | 5121.0 |
| 2009-01-06 | ABVT-DELISTED | Stock | 30.0 | 30.0 | 30.0 | 30.0 | 6076.0 |
| 2009-01-06 | ABX-DELISTED | Stock | 34.29 | 34.7 | 33.19 | 33.63 | 22868062.0 |
| 2009-01-06 | ACAD | Stock | 1.23 | 1.23 | 1.16 | 1.21 | 92700.0 |
| 2009-01-06 | ACAP-DELISTED | Stock | 46.01 | 46.46 | 45.24 | 46.19 | 98744.0 |
| 2009-01-06 | ACAS-DELISTED | Stock | 5.75 | 7.39 | 5.5 | 7.31 | 17930781.0 |
> showing 50 of 5,760 rows — these rows as CSV