PREVIEW / stock_daily / 2010-03-24
file: by_date/stock_daily/2010/2010-03-24.parquet size: 191 KB rows: 5,922 symbols: 3,489
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-24 | AAPL | Stock | 8.13 | 8.2214 | 8.1254 | 8.1918 | 597780400.0 |
| 2010-03-24 | MSFT | Stock | 29.72 | 29.85 | 29.6 | 29.65 | 33987700.0 |
| 2010-03-24 | NVDA | Stock | 0.4435 | 0.4448 | 0.4315 | 0.4322 | 436252000.0 |
| 2010-03-24 | AMZN | Stock | 6.432 | 6.47 | 6.36 | 6.402 | 93928000.0 |
| 2010-03-24 | TLT | Stock | 89.84 | 90.25 | 89.0595 | 89.27 | 8049821.0 |
| 2010-03-24 | ES | Stock | 27.2 | 27.25 | 26.94 | 26.95 | 666700.0 |
| 2010-03-24 | CL | Stock | 42.58 | 42.59 | 42.045 | 42.17 | 4359600.0 |
| 2010-03-24 | A | Stock | 24.3062 | 24.3991 | 24.2203 | 24.2489 | 3791516.0 |
| 2010-03-24 | AABA-DELISTED | Stock | 16.1 | 16.2 | 15.92 | 16.1 | 32078421.0 |
| 2010-03-24 | AACC-DELISTED | Stock | 6.33 | 6.37 | 6.2505 | 6.3 | 10824.0 |
| 2010-03-24 | AACG | Stock | 4.08 | 4.08 | 4.0 | 4.03 | 66800.0 |
| 2010-03-24 | AAI-DELISTED | Stock | 5.09 | 5.13 | 5.02 | 5.07 | 2872998.0 |
| 2010-03-24 | AAIC-DELISTED | Stock | 18.05 | 18.29 | 17.85 | 17.95 | 56623.0 |
| 2010-03-24 | AAME | Stock | 1.6 | 1.6 | 1.45 | 1.45 | 7600.0 |
| 2010-03-24 | AAON | Stock | 4.4109 | 4.4306 | 4.3477 | 4.3615 | 299194.0 |
| 2010-03-24 | AAP | Stock | 43.71 | 43.9 | 43.36 | 43.39 | 1290900.0 |
| 2010-03-24 | AATI-DELISTED | Stock | 3.65 | 3.65 | 3.49 | 3.52 | 424543.0 |
| 2010-03-24 | AAU-DELISTED | Stock | 0.93 | 0.93 | 0.9002 | 0.91 | 74957.0 |
| 2010-03-24 | AAUAF-DELISTED | Stock | 0.93 | 0.93 | 0.9002 | 0.91 | 76993.0 |
| 2010-03-24 | AAV-DELISTED | Stock | 7.16 | 7.27 | 7.14 | 7.18 | 669148.0 |
| 2010-03-24 | AAWW-DELISTED | Stock | 50.3 | 50.7 | 48.48 | 50.15 | 423700.0 |
| 2010-03-24 | AAXJ | Stock | 55.9 | 55.95 | 55.44 | 55.59 | 117981.0 |
| 2010-03-24 | AAXN-DELISTED | Stock | 6.58 | 6.72 | 6.52 | 6.62 | 1247330.0 |
| 2010-03-24 | AB | Stock | 30.0 | 30.3 | 29.65 | 30.05 | 295700.0 |
| 2010-03-24 | ABAX-DELISTED | Stock | 28.28 | 28.5 | 28.0 | 28.02 | 158767.0 |
| 2010-03-24 | ABB-DELISTED | Stock | 21.37 | 21.5 | 21.29 | 21.35 | 1451880.0 |
| 2010-03-24 | ABBC-DELISTED | Stock | 8.37 | 8.42 | 8.28 | 8.31 | 57507.0 |
| 2010-03-24 | ABBNY-DELISTED | Stock | 21.37 | 21.5 | 21.29 | 21.38 | 1453440.0 |
| 2010-03-24 | ABC-DELISTED | Stock | 29.27 | 29.3 | 28.66 | 28.72 | 2141547.0 |
| 2010-03-24 | ABCB | Stock | 9.61 | 9.6396 | 9.2939 | 9.3927 | 54776.0 |
| 2010-03-24 | ABCD-DELISTED | Stock | 3.89 | 4.03 | 3.8899 | 3.9 | 438269.0 |
| 2010-03-24 | ABCO-DELISTED | Stock | 16.56 | 16.67 | 16.365 | 16.405 | 68952.0 |
| 2010-03-24 | ABCW-DELISTED | Stock | 1.1892 | 1.199 | 1.121 | 1.16 | 255830.0 |
| 2010-03-24 | ABD-DELISTED | Stock | 7.3 | 7.68 | 7.3 | 7.61 | 431010.0 |
| 2010-03-24 | ABE-DELISTED | Stock | 17.13 | 17.13 | 16.56 | 16.57 | 22578.0 |
| 2010-03-24 | ABEO | Stock | 3087.5 | 3100.0 | 3000.0 | 3050.0 | 27.0 |
| 2010-03-24 | ABFS-DELISTED | Stock | 29.77 | 30.36 | 29.48 | 29.48 | 359823.0 |
| 2010-03-24 | ABG | Stock | 14.16 | 14.17 | 13.89 | 13.92 | 140000.0 |
| 2010-03-24 | ABII-DELISTED | Stock | 52.35 | 52.535 | 51.57 | 51.88 | 40608.0 |
| 2010-03-24 | ABK-DELISTED | Stock | 0.73 | 0.82 | 0.72 | 0.797 | 26796422.0 |
| 2010-03-24 | ABM | Stock | 20.88 | 20.99 | 20.68 | 20.82 | 297100.0 |
| 2010-03-24 | ABMD-DELISTED | Stock | 10.31 | 10.48 | 10.31 | 10.44 | 159161.0 |
| 2010-03-24 | ABR | Stock | 2.9 | 3.16 | 2.9 | 3.16 | 568600.0 |
| 2010-03-24 | ABT | Stock | 26.0292 | 26.0675 | 25.794 | 25.8468 | 13205711.0 |
| 2010-03-24 | ABTL-DELISTED | Stock | 5.2962 | 5.2962 | 5.051 | 5.1 | 46148.0 |
| 2010-03-24 | ABV-DELISTED | Stock | 92.8 | 92.8 | 91.65 | 91.82 | 471853.0 |
| 2010-03-24 | ABVA-DELISTED | Stock | 2.63 | 2.64 | 2.61 | 2.61 | 7150.0 |
| 2010-03-24 | ABVT-DELISTED | Stock | 54.25 | 54.77 | 52.02 | 52.47 | 259985.0 |
| 2010-03-24 | ABX-DELISTED | Stock | 38.24 | 38.3 | 37.11 | 37.23 | 16658492.0 |
| 2010-03-24 | ACAD | Stock | 1.61 | 1.66 | 1.56 | 1.6 | 513600.0 |
> showing 50 of 5,922 rows — these rows as CSV