PREVIEW / stock_daily / 2010-01-08
file: by_date/stock_daily/2010/2010-01-08.parquet size: 189 KB rows: 5,885 symbols: 3,476
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 |
|---|---|---|---|---|---|---|---|
| 2010-01-08 | AAPL | Stock | 7.5107 | 7.5714 | 7.4664 | 7.5707 | 447610800.0 |
| 2010-01-08 | MSFT | Stock | 30.28 | 30.88 | 30.24 | 30.66 | 51197400.0 |
| 2010-01-08 | NVDA | Stock | 0.459 | 0.467 | 0.4562 | 0.4638 | 478168000.0 |
| 2010-01-08 | AMZN | Stock | 6.528 | 6.684 | 6.4515 | 6.676 | 196610000.0 |
| 2010-01-08 | TLT | Stock | 89.51 | 89.56 | 88.76 | 89.29 | 2910649.0 |
| 2010-01-08 | ES | Stock | 25.87 | 26.24 | 25.77 | 26.04 | 969700.0 |
| 2010-01-08 | CL | Stock | 40.105 | 40.83 | 40.05 | 40.755 | 8150200.0 |
| 2010-01-08 | A | Stock | 21.917 | 22.0672 | 21.7454 | 22.0315 | 3733918.0 |
| 2010-01-08 | AABA-DELISTED | Stock | 16.7 | 16.76 | 16.615 | 16.7 | 14235241.0 |
| 2010-01-08 | AACC-DELISTED | Stock | 6.53 | 6.88 | 6.53 | 6.6 | 12667.0 |
| 2010-01-08 | AACG | Stock | 4.74 | 4.75 | 4.53 | 4.75 | 1700.0 |
| 2010-01-08 | AAI-DELISTED | Stock | 5.13 | 5.24 | 5.04 | 5.11 | 4893260.0 |
| 2010-01-08 | AAIC-DELISTED | Stock | 16.06 | 16.1 | 15.87 | 16.1 | 43615.0 |
| 2010-01-08 | AAME | Stock | 1.39 | 1.39 | 1.39 | 1.39 | 100.0 |
| 2010-01-08 | AAON | Stock | 3.7985 | 3.8736 | 3.7689 | 3.8637 | 205537.0 |
| 2010-01-08 | AAP | Stock | 40.25 | 40.82 | 40.11 | 40.64 | 960300.0 |
| 2010-01-08 | AATI-DELISTED | Stock | 3.81 | 4.05 | 3.76 | 4.0 | 336946.0 |
| 2010-01-08 | AAU-DELISTED | Stock | 1.3 | 1.3 | 1.24 | 1.2626 | 206063.0 |
| 2010-01-08 | AAUAF-DELISTED | Stock | 1.3 | 1.3 | 1.24 | 1.2626 | 209847.0 |
| 2010-01-08 | AAV-DELISTED | Stock | 7.08 | 7.34 | 6.95 | 7.31 | 586065.0 |
| 2010-01-08 | AAWW-DELISTED | Stock | 38.96 | 40.0 | 38.96 | 39.31 | 251064.0 |
| 2010-01-08 | AAXJ | Stock | 57.53 | 57.89 | 57.35 | 57.71 | 129082.0 |
| 2010-01-08 | AAXN-DELISTED | Stock | 5.64 | 5.8 | 5.43 | 5.56 | 1756845.0 |
| 2010-01-08 | AB | Stock | 28.41 | 29.38 | 28.23 | 29.27 | 415000.0 |
| 2010-01-08 | ABAX-DELISTED | Stock | 25.68 | 26.24 | 25.29 | 25.62 | 92040.0 |
| 2010-01-08 | ABB-DELISTED | Stock | 20.23 | 20.81 | 20.18 | 20.74 | 4694926.0 |
| 2010-01-08 | ABBC-DELISTED | Stock | 6.7 | 6.78 | 6.7 | 6.75 | 35997.0 |
| 2010-01-08 | ABBNY-DELISTED | Stock | 20.23 | 20.81 | 20.18 | 20.74 | 4832993.0 |
| 2010-01-08 | ABC-DELISTED | Stock | 25.86 | 26.1 | 25.68 | 26.07 | 4164289.0 |
| 2010-01-08 | ABCB | Stock | 7.6643 | 7.7433 | 7.5161 | 7.7235 | 10631.0 |
| 2010-01-08 | ABCD-DELISTED | Stock | 3.9801 | 3.984 | 3.92 | 3.95 | 18120.0 |
| 2010-01-08 | ABCO-DELISTED | Stock | 15.935 | 16.065 | 15.915 | 16.01 | 74045.0 |
| 2010-01-08 | ABCW-DELISTED | Stock | 0.69 | 0.7 | 0.6598 | 0.68 | 143250.0 |
| 2010-01-08 | ABD-DELISTED | Stock | 8.05 | 8.14 | 7.9 | 8.08 | 142510.0 |
| 2010-01-08 | ABE-DELISTED | Stock | 17.08 | 17.08 | 16.86 | 17.01 | 7566.0 |
| 2010-01-08 | ABEO | Stock | 4100.0 | 4112.5 | 4025.0 | 4112.5 | 25.0 |
| 2010-01-08 | ABFS-DELISTED | Stock | 27.64 | 28.3892 | 27.49 | 28.27 | 382976.0 |
| 2010-01-08 | ABG | Stock | 13.0 | 13.15 | 12.95 | 13.15 | 148100.0 |
| 2010-01-08 | ABII-DELISTED | Stock | 41.74 | 41.92 | 41.11 | 41.37 | 34117.0 |
| 2010-01-08 | ABK-DELISTED | Stock | 0.8388 | 0.85 | 0.8082 | 0.8184 | 10146521.0 |
| 2010-01-08 | ABM | Stock | 21.12 | 21.26 | 21.01 | 21.22 | 138000.0 |
| 2010-01-08 | ABMD-DELISTED | Stock | 8.38 | 8.55 | 8.11 | 8.22 | 355158.0 |
| 2010-01-08 | ABR | Stock | 2.24 | 2.39 | 2.24 | 2.3 | 190600.0 |
| 2010-01-08 | ABT | Stock | 26.2738 | 26.509 | 26.2355 | 26.413 | 12148604.0 |
| 2010-01-08 | ABTL-DELISTED | Stock | 4.5948 | 5.0052 | 4.5047 | 5.0052 | 27717.0 |
| 2010-01-08 | ABV-DELISTED | Stock | 103.3 | 105.17 | 103.2 | 104.67 | 338461.0 |
| 2010-01-08 | ABVT-DELISTED | Stock | 65.19 | 65.61 | 64.8 | 65.17 | 71162.0 |
| 2010-01-08 | ABX-DELISTED | Stock | 41.6 | 41.67 | 40.7 | 41.4201 | 9100490.0 |
| 2010-01-08 | ACAD | Stock | 1.39 | 1.47 | 1.34 | 1.44 | 1189700.0 |
| 2010-01-08 | ACAP-DELISTED | Stock | 29.68 | 29.95 | 29.4 | 29.93 | 32572.0 |
> showing 50 of 5,885 rows — these rows as CSV