PREVIEW / stock_daily / 2010-10-22
file: by_date/stock_daily/2010/2010-10-22.parquet size: 192 KB rows: 5,981 symbols: 3,512
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-10-22 | AAPL | Stock | 11.0382 | 11.0729 | 10.9393 | 10.9811 | 372778000.0 |
| 2010-10-22 | MSFT | Stock | 25.52 | 25.54 | 25.27 | 25.38 | 25837900.0 |
| 2010-10-22 | NVDA | Stock | 0.279 | 0.2972 | 0.276 | 0.295 | 1322676000.0 |
| 2010-10-22 | AMZN | Stock | 8.1225 | 8.5085 | 8.1135 | 8.4565 | 326368000.0 |
| 2010-10-22 | TSLA | Stock | 1.3787 | 1.3953 | 1.37 | 1.3813 | 2416500.0 |
| 2010-10-22 | TLT | Stock | 100.44 | 101.47 | 100.412 | 101.38 | 4770791.0 |
| 2010-10-22 | ES | Stock | 30.7 | 30.85 | 30.5 | 30.85 | 1497900.0 |
| 2010-10-22 | CL | Stock | 38.47 | 38.75 | 38.3 | 38.42 | 2964000.0 |
| 2010-10-22 | A | Stock | 24.8498 | 24.9785 | 24.6924 | 24.8569 | 3521422.0 |
| 2010-10-22 | AABA-DELISTED | Stock | 15.9 | 16.41 | 15.86 | 16.32 | 23407855.0 |
| 2010-10-22 | AACC-DELISTED | Stock | 5.47 | 5.73 | 5.36 | 5.67 | 13085.0 |
| 2010-10-22 | AAI-DELISTED | Stock | 7.49 | 7.49 | 7.46 | 7.47 | 2418439.0 |
| 2010-10-22 | AAIC-DELISTED | Stock | 23.62 | 23.62 | 23.34 | 23.52 | 32526.0 |
| 2010-10-22 | AAME | Stock | 1.7 | 1.7 | 1.69 | 1.69 | 300.0 |
| 2010-10-22 | AAON | Stock | 4.9106 | 4.9244 | 4.8296 | 4.879 | 87075.0 |
| 2010-10-22 | AAP | Stock | 60.93 | 61.45 | 60.52 | 61.4 | 689800.0 |
| 2010-10-22 | AATI-DELISTED | Stock | 3.76 | 3.87 | 3.76 | 3.83 | 43865.0 |
| 2010-10-22 | AAU-DELISTED | Stock | 2.63 | 2.64 | 2.55 | 2.57 | 183992.0 |
| 2010-10-22 | AAUAF-DELISTED | Stock | 2.63 | 2.64 | 2.55 | 2.57 | 184392.0 |
| 2010-10-22 | AAV-DELISTED | Stock | 6.25 | 6.28 | 6.18 | 6.24 | 219361.0 |
| 2010-10-22 | AAWW-DELISTED | Stock | 53.43 | 53.93 | 52.6815 | 53.73 | 195913.0 |
| 2010-10-22 | AAXJ | Stock | 62.69 | 62.7 | 62.44 | 62.55 | 319374.0 |
| 2010-10-22 | AAXN-DELISTED | Stock | 4.54 | 4.59 | 4.5 | 4.53 | 255368.0 |
| 2010-10-22 | AB | Stock | 26.25 | 26.45 | 25.95 | 26.21 | 340500.0 |
| 2010-10-22 | ABAC-DELISTED | Stock | 5.35 | 5.5052 | 5.35 | 5.45 | 18440.0 |
| 2010-10-22 | ABAX-DELISTED | Stock | 22.9 | 23.24 | 22.59 | 22.99 | 79139.0 |
| 2010-10-22 | ABB-DELISTED | Stock | 22.52 | 22.56 | 22.31 | 22.37 | 1443535.0 |
| 2010-10-22 | ABBC-DELISTED | Stock | 10.63 | 10.75 | 10.46 | 10.6 | 36281.0 |
| 2010-10-22 | ABBNY-DELISTED | Stock | 22.52 | 22.56 | 22.31 | 22.37 | 1446411.0 |
| 2010-10-22 | ABC-DELISTED | Stock | 32.33 | 32.4499 | 32.04 | 32.09 | 2080887.0 |
| 2010-10-22 | ABCB | Stock | 9.48 | 9.67 | 9.37 | 9.42 | 31000.0 |
| 2010-10-22 | ABCD-DELISTED | Stock | 3.35 | 3.38 | 3.35 | 3.37 | 17812.0 |
| 2010-10-22 | ABCO-DELISTED | Stock | 23.05 | 23.42 | 22.96 | 23.36 | 42569.0 |
| 2010-10-22 | ABCW-DELISTED | Stock | 0.6506 | 0.6894 | 0.6506 | 0.67 | 16330.0 |
| 2010-10-22 | ABD-DELISTED | Stock | 5.95 | 5.95 | 5.76 | 5.86 | 91870.0 |
| 2010-10-22 | ABE-DELISTED | Stock | 19.3 | 19.32 | 19.23 | 19.24 | 4521.0 |
| 2010-10-22 | ABEO | Stock | 3775.0 | 3800.0 | 3687.5 | 3800.0 | 19.0 |
| 2010-10-22 | ABFS-DELISTED | Stock | 25.63 | 25.89 | 25.43 | 25.45 | 220840.0 |
| 2010-10-22 | ABG | Stock | 14.94 | 15.01 | 14.57 | 14.78 | 90200.0 |
| 2010-10-22 | ABK-DELISTED | Stock | 1.06 | 1.08 | 0.9833 | 1.0 | 12766025.0 |
| 2010-10-22 | ABM | Stock | 22.35 | 22.57 | 22.29 | 22.54 | 119200.0 |
| 2010-10-22 | ABMD-DELISTED | Stock | 9.93 | 10.57 | 9.91 | 10.55 | 67302.0 |
| 2010-10-22 | ABR | Stock | 5.38 | 5.38 | 5.25 | 5.28 | 22800.0 |
| 2010-10-22 | ABT | Stock | 25.4054 | 25.4054 | 25.1175 | 25.2183 | 7370571.0 |
| 2010-10-22 | ABTL-DELISTED | Stock | 3.6507 | 3.8924 | 3.6507 | 3.7 | 14151.0 |
| 2010-10-22 | ABV-DELISTED | Stock | 139.7 | 140.97 | 139.0 | 140.92 | 1069306.0 |
| 2010-10-22 | ABVA-DELISTED | Stock | 2.68 | 2.68 | 2.68 | 2.68 | 1180.0 |
| 2010-10-22 | ABVT-DELISTED | Stock | 54.26 | 54.64 | 53.81 | 54.24 | 49690.0 |
| 2010-10-22 | ABX-DELISTED | Stock | 45.6 | 46.0 | 45.1 | 45.98 | 5271989.0 |
| 2010-10-22 | ACAD | Stock | 0.9 | 0.9 | 0.87 | 0.87 | 122000.0 |
> showing 50 of 5,981 rows — these rows as CSV