PREVIEW / stock_daily / 2010-08-24
file: by_date/stock_daily/2010/2010-08-24.parquet size: 189 KB rows: 5,946 symbols: 3,495
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-08-24 | AAPL | Stock | 8.6668 | 8.6786 | 8.5232 | 8.5689 | 602565600.0 |
| 2010-08-24 | MSFT | Stock | 24.09 | 24.35 | 24.0 | 24.04 | 66522500.0 |
| 2010-08-24 | NVDA | Stock | 0.2375 | 0.2455 | 0.237 | 0.243 | 641332000.0 |
| 2010-08-24 | AMZN | Stock | 6.2705 | 6.272 | 6.159 | 6.2265 | 107394000.0 |
| 2010-08-24 | TSLA | Stock | 1.2833 | 1.314 | 1.2633 | 1.28 | 10096500.0 |
| 2010-08-24 | TLT | Stock | 107.04 | 108.13 | 106.67 | 107.76 | 9813383.0 |
| 2010-08-24 | ES | Stock | 28.42 | 29.02 | 28.29 | 28.78 | 1320300.0 |
| 2010-08-24 | CL | Stock | 37.325 | 37.97 | 37.325 | 37.735 | 4310400.0 |
| 2010-08-24 | A | Stock | 19.6853 | 19.7926 | 19.3777 | 19.5708 | 4102850.0 |
| 2010-08-24 | AABA-DELISTED | Stock | 13.54 | 13.64 | 13.39 | 13.4 | 13394957.0 |
| 2010-08-24 | AACC-DELISTED | Stock | 3.8342 | 3.94 | 3.79 | 3.85 | 42522.0 |
| 2010-08-24 | AACG | Stock | 2.95 | 2.99 | 2.93 | 2.95 | 52500.0 |
| 2010-08-24 | AAI-DELISTED | Stock | 4.53 | 4.545 | 4.44 | 4.45 | 2541590.0 |
| 2010-08-24 | AAIC-DELISTED | Stock | 19.43 | 19.68 | 19.07 | 19.46 | 48352.0 |
| 2010-08-24 | AAME | Stock | 1.27 | 1.27 | 1.15 | 1.23 | 2800.0 |
| 2010-08-24 | AAON | Stock | 4.0948 | 4.1659 | 3.9664 | 4.0849 | 158962.0 |
| 2010-08-24 | AAP | Stock | 54.12 | 54.93 | 53.65 | 54.26 | 946500.0 |
| 2010-08-24 | AATI-DELISTED | Stock | 3.5 | 3.51 | 3.32 | 3.37 | 268797.0 |
| 2010-08-24 | AAU-DELISTED | Stock | 2.23 | 2.32 | 2.06 | 2.13 | 1311349.0 |
| 2010-08-24 | AAUAF-DELISTED | Stock | 2.23 | 2.32 | 2.06 | 2.13 | 1323799.0 |
| 2010-08-24 | AAV-DELISTED | Stock | 5.74 | 5.82 | 5.65 | 5.77 | 243873.0 |
| 2010-08-24 | AAWW-DELISTED | Stock | 44.63 | 44.63 | 42.43 | 43.4 | 623952.0 |
| 2010-08-24 | AAXJ | Stock | 54.56 | 54.86 | 54.23 | 54.54 | 684604.0 |
| 2010-08-24 | AAXN-DELISTED | Stock | 3.8 | 3.9 | 3.63 | 3.63 | 759309.0 |
| 2010-08-24 | AB | Stock | 24.69 | 25.03 | 24.34 | 24.6 | 388600.0 |
| 2010-08-24 | ABAC-DELISTED | Stock | 3.81 | 3.97 | 3.71 | 3.87 | 11675.0 |
| 2010-08-24 | ABAX-DELISTED | Stock | 18.62 | 18.96 | 18.38 | 18.7 | 99660.0 |
| 2010-08-24 | ABB-DELISTED | Stock | 18.8 | 19.03 | 18.64 | 18.86 | 1734397.0 |
| 2010-08-24 | ABBC-DELISTED | Stock | 9.87 | 10.05 | 9.85 | 9.85 | 54670.0 |
| 2010-08-24 | ABBNY-DELISTED | Stock | 18.8 | 19.03 | 18.64 | 18.87 | 1749856.0 |
| 2010-08-24 | ABC-DELISTED | Stock | 28.3 | 28.3 | 27.79 | 27.85 | 2728176.0 |
| 2010-08-24 | ABCB | Stock | 8.02 | 8.08 | 7.85 | 7.92 | 71700.0 |
| 2010-08-24 | ABCD-DELISTED | Stock | 2.88 | 3.05 | 2.88 | 2.9 | 27564.0 |
| 2010-08-24 | ABCO-DELISTED | Stock | 20.51 | 20.58 | 20.2 | 20.2 | 157952.0 |
| 2010-08-24 | ABCW-DELISTED | Stock | 0.6294 | 0.6505 | 0.6212 | 0.6306 | 70490.0 |
| 2010-08-24 | ABD-DELISTED | Stock | 5.64 | 5.66 | 5.41 | 5.41 | 531120.0 |
| 2010-08-24 | ABE-DELISTED | Stock | 17.11 | 17.13 | 16.9645 | 17.05 | 5705.0 |
| 2010-08-24 | ABEO | Stock | 2625.0 | 2687.5 | 2500.0 | 2600.0 | 18.0 |
| 2010-08-24 | ABFS-DELISTED | Stock | 19.39 | 19.99 | 19.01 | 19.62 | 281069.0 |
| 2010-08-24 | ABG | Stock | 11.93 | 12.37 | 11.67 | 12.1 | 210600.0 |
| 2010-08-24 | ABII-DELISTED | Stock | 74.32 | 74.47 | 73.85 | 73.88 | 108501.0 |
| 2010-08-24 | ABK-DELISTED | Stock | 0.4603 | 0.504 | 0.4603 | 0.4817 | 8969061.0 |
| 2010-08-24 | ABM | Stock | 18.91 | 19.14 | 18.71 | 18.81 | 269600.0 |
| 2010-08-24 | ABMD-DELISTED | Stock | 8.78 | 8.93 | 8.63 | 8.84 | 212454.0 |
| 2010-08-24 | ABR | Stock | 4.88 | 4.91 | 4.5 | 4.74 | 82600.0 |
| 2010-08-24 | ABT | Stock | 23.6493 | 23.8844 | 23.5438 | 23.7405 | 18669654.0 |
| 2010-08-24 | ABTL-DELISTED | Stock | 4.5779 | 4.7034 | 4.4 | 4.4 | 6586.0 |
| 2010-08-24 | ABV-DELISTED | Stock | 107.6 | 109.28 | 107.26 | 108.72 | 707659.0 |
| 2010-08-24 | ABVT-DELISTED | Stock | 48.5 | 49.66 | 48.43 | 49.43 | 75597.0 |
| 2010-08-24 | ABX-DELISTED | Stock | 42.9 | 44.39 | 42.8 | 43.78 | 6930008.0 |
> showing 50 of 5,946 rows — these rows as CSV