PREVIEW / stock_daily / 2010-10-01
file: by_date/stock_daily/2010/2010-10-01.parquet size: 192 KB rows: 5,961 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-10-01 | AAPL | Stock | 10.2196 | 10.235 | 10.0482 | 10.09 | 448142800.0 |
| 2010-10-01 | MSFT | Stock | 24.77 | 24.82 | 24.3 | 24.38 | 62672300.0 |
| 2010-10-01 | NVDA | Stock | 0.2962 | 0.2968 | 0.2815 | 0.2838 | 999120000.0 |
| 2010-10-01 | AMZN | Stock | 7.854 | 7.872 | 7.61 | 7.6855 | 173668000.0 |
| 2010-10-01 | TSLA | Stock | 1.3793 | 1.3833 | 1.354 | 1.3733 | 8965500.0 |
| 2010-10-01 | TLT | Stock | 104.23 | 105.14 | 103.98 | 104.61 | 9368358.0 |
| 2010-10-01 | ES | Stock | 29.86 | 29.92 | 29.51 | 29.83 | 1022600.0 |
| 2010-10-01 | CL | Stock | 38.555 | 38.69 | 38.22 | 38.285 | 9056800.0 |
| 2010-10-01 | A | Stock | 24.0987 | 24.5207 | 23.8841 | 24.1273 | 8238554.0 |
| 2010-10-01 | AABA-DELISTED | Stock | 14.19 | 14.35 | 14.13 | 14.27 | 15999664.0 |
| 2010-10-01 | AACC-DELISTED | Stock | 5.42 | 5.76 | 5.39 | 5.68 | 34964.0 |
| 2010-10-01 | AACG | Stock | 2.88 | 3.07 | 2.88 | 3.03 | 4200.0 |
| 2010-10-01 | AAI-DELISTED | Stock | 7.35 | 7.37 | 7.33 | 7.33 | 14653649.0 |
| 2010-10-01 | AAIC-DELISTED | Stock | 23.42 | 23.43 | 23.07 | 23.32 | 30220.0 |
| 2010-10-01 | AAME | Stock | 1.66 | 1.69 | 1.65 | 1.65 | 4600.0 |
| 2010-10-01 | AAON | Stock | 4.6795 | 4.6795 | 4.5314 | 4.6262 | 189844.0 |
| 2010-10-01 | AAP | Stock | 59.22 | 59.61 | 57.96 | 58.7 | 838700.0 |
| 2010-10-01 | AATI-DELISTED | Stock | 3.55 | 3.55 | 3.41 | 3.47 | 99457.0 |
| 2010-10-01 | AAU-DELISTED | Stock | 2.91 | 3.3409 | 2.86 | 3.28 | 1338340.0 |
| 2010-10-01 | AAUAF-DELISTED | Stock | 2.87 | 3.29 | 2.82 | 3.28 | 1357176.0 |
| 2010-10-01 | AAV-DELISTED | Stock | 6.34 | 6.44 | 6.3 | 6.42 | 363699.0 |
| 2010-10-01 | AAWW-DELISTED | Stock | 50.73 | 50.76 | 49.55 | 50.11 | 704553.0 |
| 2010-10-01 | AAXJ | Stock | 61.12 | 61.55 | 61.03 | 61.55 | 475568.0 |
| 2010-10-01 | AAXN-DELISTED | Stock | 3.88 | 3.89 | 3.82 | 3.88 | 220134.0 |
| 2010-10-01 | AB | Stock | 26.7 | 26.95 | 26.41 | 26.59 | 204200.0 |
| 2010-10-01 | ABAC-DELISTED | Stock | 3.95 | 4.4 | 3.7981 | 4.36 | 61980.0 |
| 2010-10-01 | ABAX-DELISTED | Stock | 23.33 | 23.48 | 22.8701 | 23.27 | 67236.0 |
| 2010-10-01 | ABB-DELISTED | Stock | 21.53 | 21.54 | 21.23 | 21.36 | 3198598.0 |
| 2010-10-01 | ABBC-DELISTED | Stock | 10.59 | 10.7199 | 10.32 | 10.63 | 24850.0 |
| 2010-10-01 | ABBNY-DELISTED | Stock | 21.53 | 21.54 | 21.23 | 21.39 | 3473929.0 |
| 2010-10-01 | ABC-DELISTED | Stock | 30.85 | 30.97 | 30.4 | 30.85 | 3294581.0 |
| 2010-10-01 | ABCB | Stock | 9.43 | 9.53 | 9.15 | 9.53 | 38300.0 |
| 2010-10-01 | ABCD-DELISTED | Stock | 3.2 | 3.21 | 3.17 | 3.17 | 31801.0 |
| 2010-10-01 | ABCO-DELISTED | Stock | 22.12 | 23.33 | 22.08 | 23.19 | 267316.0 |
| 2010-10-01 | ABCW-DELISTED | Stock | 0.68 | 0.69 | 0.68 | 0.69 | 14290.0 |
| 2010-10-01 | ABD-DELISTED | Stock | 5.84 | 5.9767 | 5.7 | 5.92 | 191830.0 |
| 2010-10-01 | ABE-DELISTED | Stock | 18.73 | 18.86 | 18.59 | 18.77 | 36285.0 |
| 2010-10-01 | ABEO | Stock | 2550.0 | 2725.0 | 2437.5 | 2700.0 | 30.0 |
| 2010-10-01 | ABFS-DELISTED | Stock | 24.47 | 24.63 | 23.65 | 23.75 | 192474.0 |
| 2010-10-01 | ABG | Stock | 14.23 | 14.47 | 13.93 | 14.41 | 210100.0 |
| 2010-10-01 | ABII-DELISTED | Stock | 76.61 | 77.0 | 76.52 | 76.99 | 93561.0 |
| 2010-10-01 | ABK-DELISTED | Stock | 0.56 | 0.5672 | 0.5533 | 0.5599 | 1965604.0 |
| 2010-10-01 | ABM | Stock | 21.79 | 21.79 | 21.42 | 21.6 | 324600.0 |
| 2010-10-01 | ABMD-DELISTED | Stock | 10.7 | 10.7 | 10.47 | 10.59 | 74369.0 |
| 2010-10-01 | ABR | Stock | 5.05 | 5.06 | 4.93 | 5.01 | 35000.0 |
| 2010-10-01 | ABT | Stock | 25.2087 | 25.2279 | 25.0072 | 25.2279 | 9918091.0 |
| 2010-10-01 | ABTL-DELISTED | Stock | 4.2503 | 4.2503 | 4.0002 | 4.1997 | 19159.0 |
| 2010-10-01 | ABV-DELISTED | Stock | 124.98 | 126.02 | 124.19 | 125.02 | 558378.0 |
| 2010-10-01 | ABVT-DELISTED | Stock | 52.25 | 52.64 | 51.89 | 52.6 | 79328.0 |
| 2010-10-01 | ABX-DELISTED | Stock | 46.85 | 47.28 | 46.55 | 47.06 | 8626538.0 |
> showing 50 of 5,961 rows — these rows as CSV