PREVIEW / stock_daily / 2010-03-26
file: by_date/stock_daily/2010/2010-03-26.parquet size: 191 KB rows: 5,914 symbols: 3,494
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-03-26 | AAPL | Stock | 8.1768 | 8.2839 | 8.1625 | 8.2464 | 640875200.0 |
| 2010-03-26 | MSFT | Stock | 30.09 | 30.2 | 29.59 | 29.66 | 55595500.0 |
| 2010-03-26 | NVDA | Stock | 0.4372 | 0.4418 | 0.43 | 0.4335 | 344676000.0 |
| 2010-03-26 | AMZN | Stock | 6.745 | 6.8495 | 6.688 | 6.753 | 131314000.0 |
| 2010-03-26 | TLT | Stock | 88.54 | 89.12 | 88.49 | 88.95 | 4111700.0 |
| 2010-03-26 | ES | Stock | 27.11 | 27.22 | 26.89 | 27.02 | 1231400.0 |
| 2010-03-26 | CL | Stock | 41.745 | 42.34 | 41.745 | 42.22 | 5112200.0 |
| 2010-03-26 | A | Stock | 24.7854 | 24.8212 | 24.3991 | 24.5422 | 4705808.0 |
| 2010-03-26 | AABA-DELISTED | Stock | 16.39 | 16.57 | 16.31 | 16.55 | 23073788.0 |
| 2010-03-26 | AACC-DELISTED | Stock | 6.33 | 6.38 | 6.28 | 6.37 | 22993.0 |
| 2010-03-26 | AACG | Stock | 4.01 | 4.23 | 4.0 | 4.23 | 14800.0 |
| 2010-03-26 | AAI-DELISTED | Stock | 5.07 | 5.18 | 5.05 | 5.06 | 2809794.0 |
| 2010-03-26 | AAIC-DELISTED | Stock | 18.0 | 18.14 | 17.9685 | 18.04 | 32110.0 |
| 2010-03-26 | AAON | Stock | 4.322 | 4.3753 | 4.3062 | 4.3457 | 200475.0 |
| 2010-03-26 | AAP | Stock | 42.91 | 43.21 | 42.03 | 42.48 | 1590400.0 |
| 2010-03-26 | AATI-DELISTED | Stock | 3.47 | 3.7 | 3.46 | 3.66 | 636636.0 |
| 2010-03-26 | AAU-DELISTED | Stock | 0.91 | 0.9198 | 0.9018 | 0.91 | 62564.0 |
| 2010-03-26 | AAUAF-DELISTED | Stock | 0.91 | 0.9198 | 0.9018 | 0.91 | 63864.0 |
| 2010-03-26 | AAV-DELISTED | Stock | 6.93 | 6.97 | 6.61 | 6.65 | 1130344.0 |
| 2010-03-26 | AAWW-DELISTED | Stock | 52.12 | 53.4 | 51.65 | 52.87 | 531416.0 |
| 2010-03-26 | AAXJ | Stock | 56.47 | 56.47 | 55.64 | 55.94 | 90309.0 |
| 2010-03-26 | AAXN-DELISTED | Stock | 6.32 | 6.3699 | 5.871 | 6.01 | 2312843.0 |
| 2010-03-26 | AB | Stock | 30.34 | 30.56 | 30.05 | 30.25 | 258600.0 |
| 2010-03-26 | ABAX-DELISTED | Stock | 27.45 | 27.45 | 26.51 | 26.93 | 99242.0 |
| 2010-03-26 | ABB-DELISTED | Stock | 21.49 | 21.7 | 21.27 | 21.518 | 1877182.0 |
| 2010-03-26 | ABBC-DELISTED | Stock | 8.15 | 8.38 | 8.15 | 8.2 | 23465.0 |
| 2010-03-26 | ABBNY-DELISTED | Stock | 21.51 | 21.7 | 21.27 | 21.49 | 1877182.0 |
| 2010-03-26 | ABC-DELISTED | Stock | 28.63 | 28.72 | 28.3 | 28.6 | 2455853.0 |
| 2010-03-26 | ABCB | Stock | 9.5508 | 9.5804 | 8.9581 | 9.0273 | 34425.0 |
| 2010-03-26 | ABCD-DELISTED | Stock | 3.9999 | 4.0 | 3.9445 | 3.96 | 735.0 |
| 2010-03-26 | ABCO-DELISTED | Stock | 16.053 | 16.103 | 15.6 | 15.757 | 104597.0 |
| 2010-03-26 | ABCW-DELISTED | Stock | 1.2 | 1.2 | 1.14 | 1.16 | 185860.0 |
| 2010-03-26 | ABD-DELISTED | Stock | 7.62 | 7.71 | 7.55 | 7.68 | 288140.0 |
| 2010-03-26 | ABE-DELISTED | Stock | 16.66 | 16.8392 | 16.62 | 16.685 | 28728.0 |
| 2010-03-26 | ABEO | Stock | 3087.5 | 3187.5 | 3062.5 | 3137.5 | 14.0 |
| 2010-03-26 | ABFS-DELISTED | Stock | 29.48 | 29.9599 | 29.07 | 29.27 | 236051.0 |
| 2010-03-26 | ABG | Stock | 14.03 | 14.04 | 13.88 | 13.96 | 280000.0 |
| 2010-03-26 | ABII-DELISTED | Stock | 50.81 | 50.83 | 49.655 | 50.23 | 35109.0 |
| 2010-03-26 | ABK-DELISTED | Stock | 0.6225 | 0.645 | 0.52 | 0.5201 | 42839508.0 |
| 2010-03-26 | ABM | Stock | 20.86 | 21.22 | 20.82 | 20.92 | 397300.0 |
| 2010-03-26 | ABMD-DELISTED | Stock | 10.32 | 10.615 | 10.32 | 10.6 | 248525.0 |
| 2010-03-26 | ABR | Stock | 3.27 | 3.41 | 3.23 | 3.31 | 224200.0 |
| 2010-03-26 | ABT | Stock | 25.7653 | 25.8036 | 25.1607 | 25.3814 | 25017716.0 |
| 2010-03-26 | ABTL-DELISTED | Stock | 5.3 | 5.35 | 5.1 | 5.2 | 16027.0 |
| 2010-03-26 | ABV-DELISTED | Stock | 91.78 | 92.14 | 90.97 | 91.2 | 670692.0 |
| 2010-03-26 | ABVA-DELISTED | Stock | 2.65 | 2.68 | 2.5 | 2.535 | 6400.0 |
| 2010-03-26 | ABVT-DELISTED | Stock | 50.2 | 51.32 | 50.2 | 51.0 | 163521.0 |
| 2010-03-26 | ABX-DELISTED | Stock | 36.96 | 37.58 | 36.69 | 37.4 | 10143462.0 |
| 2010-03-26 | ACAD | Stock | 1.68 | 1.7 | 1.54 | 1.55 | 722000.0 |
| 2010-03-26 | ACAP-DELISTED | Stock | 32.04 | 32.2 | 31.9 | 31.98 | 16741.0 |
> showing 50 of 5,914 rows — these rows as CSV