PREVIEW / stock_daily / 2010-08-26
file: by_date/stock_daily/2010/2010-08-26.parquet size: 189 KB rows: 5,943 symbols: 3,491
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-26 | AAPL | Stock | 8.7661 | 8.7768 | 8.5814 | 8.5814 | 466505200.0 |
| 2010-08-26 | MSFT | Stock | 24.09 | 24.19 | 23.79 | 23.82 | 49105300.0 |
| 2010-08-26 | NVDA | Stock | 0.2513 | 0.254 | 0.245 | 0.245 | 657596000.0 |
| 2010-08-26 | AMZN | Stock | 6.3575 | 6.3795 | 6.241 | 6.243 | 93890000.0 |
| 2010-08-26 | TSLA | Stock | 1.326 | 1.3513 | 1.3067 | 1.3167 | 6507000.0 |
| 2010-08-26 | TLT | Stock | 107.56 | 108.49 | 107.29 | 108.42 | 7040673.0 |
| 2010-08-26 | ES | Stock | 28.8 | 28.89 | 28.43 | 28.58 | 1984300.0 |
| 2010-08-26 | CL | Stock | 37.805 | 37.85 | 36.96 | 36.995 | 7080400.0 |
| 2010-08-26 | A | Stock | 19.9428 | 20.1216 | 19.6638 | 19.6781 | 4125778.0 |
| 2010-08-26 | AABA-DELISTED | Stock | 13.36 | 13.4 | 13.21 | 13.21 | 14341183.0 |
| 2010-08-26 | AACC-DELISTED | Stock | 4.1 | 4.18 | 3.8 | 3.9 | 167841.0 |
| 2010-08-26 | AACG | Stock | 2.86 | 2.95 | 2.85 | 2.85 | 2100.0 |
| 2010-08-26 | AAI-DELISTED | Stock | 4.54 | 4.54 | 4.45 | 4.47 | 1047866.0 |
| 2010-08-26 | AAIC-DELISTED | Stock | 19.55 | 19.78 | 19.17 | 19.27 | 86998.0 |
| 2010-08-26 | AAME | Stock | 1.21 | 1.25 | 1.18 | 1.25 | 12600.0 |
| 2010-08-26 | AAON | Stock | 4.1659 | 4.2232 | 4.1659 | 4.1956 | 235406.0 |
| 2010-08-26 | AAP | Stock | 54.87 | 55.21 | 54.34 | 54.68 | 900900.0 |
| 2010-08-26 | AATI-DELISTED | Stock | 3.47 | 3.47 | 3.382 | 3.42 | 68488.0 |
| 2010-08-26 | AAU-DELISTED | Stock | 2.1 | 2.18 | 2.01 | 2.01 | 400909.0 |
| 2010-08-26 | AAUAF-DELISTED | Stock | 2.09 | 2.18 | 2.01 | 2.01 | 401509.0 |
| 2010-08-26 | AAV-DELISTED | Stock | 5.87 | 5.97 | 5.86 | 5.9 | 240212.0 |
| 2010-08-26 | AAWW-DELISTED | Stock | 44.15 | 45.68 | 44.06 | 45.08 | 485035.0 |
| 2010-08-26 | AAXJ | Stock | 54.53 | 54.9 | 54.22 | 54.24 | 703139.0 |
| 2010-08-26 | AAXN-DELISTED | Stock | 3.62 | 3.69 | 3.54 | 3.58 | 447478.0 |
| 2010-08-26 | AB | Stock | 24.43 | 24.97 | 24.01 | 24.2 | 341700.0 |
| 2010-08-26 | ABAC-DELISTED | Stock | 3.755 | 3.78 | 3.63 | 3.76 | 21750.0 |
| 2010-08-26 | ABAX-DELISTED | Stock | 18.77 | 18.84 | 18.22 | 18.25 | 50500.0 |
| 2010-08-26 | ABB-DELISTED | Stock | 19.06 | 19.21 | 18.73 | 18.82 | 1638288.0 |
| 2010-08-26 | ABBC-DELISTED | Stock | 10.0 | 10.03 | 9.85 | 9.87 | 25265.0 |
| 2010-08-26 | ABBNY-DELISTED | Stock | 19.06 | 19.21 | 18.73 | 18.79 | 1768317.0 |
| 2010-08-26 | ABC-DELISTED | Stock | 28.0 | 28.06 | 27.5 | 27.63 | 2231584.0 |
| 2010-08-26 | ABCB | Stock | 8.06 | 8.14 | 7.97 | 8.05 | 60200.0 |
| 2010-08-26 | ABCD-DELISTED | Stock | 3.09 | 3.09 | 2.93 | 2.94 | 8379.0 |
| 2010-08-26 | ABCO-DELISTED | Stock | 20.33 | 20.55 | 20.2 | 20.5 | 206824.0 |
| 2010-08-26 | ABCW-DELISTED | Stock | 0.61 | 0.63 | 0.6 | 0.63 | 61280.0 |
| 2010-08-26 | ABD-DELISTED | Stock | 5.665 | 5.8498 | 5.625 | 5.675 | 264580.0 |
| 2010-08-26 | ABE-DELISTED | Stock | 16.95 | 16.99 | 16.82 | 16.87 | 3907.0 |
| 2010-08-26 | ABEO | Stock | 2475.0 | 2562.5 | 2475.0 | 2562.5 | 7.0 |
| 2010-08-26 | ABFS-DELISTED | Stock | 20.47 | 20.83 | 20.24 | 20.6 | 259118.0 |
| 2010-08-26 | ABG | Stock | 12.21 | 12.56 | 12.0 | 12.02 | 204400.0 |
| 2010-08-26 | ABII-DELISTED | Stock | 74.18 | 74.18 | 73.55 | 73.85 | 55493.0 |
| 2010-08-26 | ABK-DELISTED | Stock | 0.56 | 0.56 | 0.485 | 0.5 | 7626907.0 |
| 2010-08-26 | ABM | Stock | 19.38 | 19.93 | 19.32 | 19.6 | 349300.0 |
| 2010-08-26 | ABMD-DELISTED | Stock | 9.0 | 9.14 | 8.961 | 9.01 | 108775.0 |
| 2010-08-26 | ABR | Stock | 4.61 | 4.89 | 4.54 | 4.54 | 54400.0 |
| 2010-08-26 | ABT | Stock | 24.014 | 24.014 | 23.6877 | 23.7501 | 11410796.0 |
| 2010-08-26 | ABTL-DELISTED | Stock | 4.251 | 4.449 | 4.149 | 4.399 | 1724.0 |
| 2010-08-26 | ABV-DELISTED | Stock | 106.9 | 108.07 | 106.51 | 106.62 | 507340.0 |
| 2010-08-26 | ABVA-DELISTED | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 394.0 |
| 2010-08-26 | ABVT-DELISTED | Stock | 49.47 | 50.8 | 49.47 | 50.43 | 128113.0 |
> showing 50 of 5,943 rows — these rows as CSV