PREVIEW / stock_daily / 2010-08-10
file: by_date/stock_daily/2010/2010-08-10.parquet size: 190 KB rows: 5,952 symbols: 3,503
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-10 | AAPL | Stock | 9.2804 | 9.3018 | 9.1982 | 9.2646 | 451920000.0 |
| 2010-08-10 | MSFT | Stock | 25.33 | 25.34 | 24.88 | 25.07 | 87257700.0 |
| 2010-08-10 | NVDA | Stock | 0.237 | 0.2375 | 0.23 | 0.231 | 772560000.0 |
| 2010-08-10 | AMZN | Stock | 6.3975 | 6.5 | 6.369 | 6.5 | 114138000.0 |
| 2010-08-10 | TSLA | Stock | 1.31 | 1.31 | 1.2547 | 1.2687 | 19219500.0 |
| 2010-08-10 | TLT | Stock | 100.06 | 101.01 | 99.47 | 99.94 | 11250994.0 |
| 2010-08-10 | ES | Stock | 28.79 | 29.41 | 28.75 | 29.2 | 1066200.0 |
| 2010-08-10 | CL | Stock | 37.905 | 39.295 | 37.9 | 38.985 | 10654000.0 |
| 2010-08-10 | A | Stock | 21.0587 | 21.2303 | 20.8369 | 21.073 | 4874407.0 |
| 2010-08-10 | AABA-DELISTED | Stock | 14.34 | 14.46 | 14.2 | 14.36 | 9560220.0 |
| 2010-08-10 | AACC-DELISTED | Stock | 4.42 | 4.519 | 4.16 | 4.24 | 21505.0 |
| 2010-08-10 | AACG | Stock | 3.03 | 3.16 | 3.03 | 3.06 | 500.0 |
| 2010-08-10 | AAI-DELISTED | Stock | 4.64 | 4.76 | 4.64 | 4.68 | 1221139.0 |
| 2010-08-10 | AAIC-DELISTED | Stock | 20.78 | 20.86 | 20.07 | 20.25 | 65280.0 |
| 2010-08-10 | AAME | Stock | 1.25 | 1.4 | 1.25 | 1.33 | 6700.0 |
| 2010-08-10 | AAON | Stock | 4.7131 | 4.7407 | 4.638 | 4.7012 | 213131.0 |
| 2010-08-10 | AAP | Stock | 52.81 | 53.49 | 52.52 | 53.05 | 774400.0 |
| 2010-08-10 | AATI-DELISTED | Stock | 3.3 | 3.35 | 3.26 | 3.31 | 130223.0 |
| 2010-08-10 | AAU-DELISTED | Stock | 1.4 | 1.7 | 1.39 | 1.51 | 3525617.0 |
| 2010-08-10 | AAUAF-DELISTED | Stock | 1.4 | 1.7 | 1.39 | 1.51 | 3537274.0 |
| 2010-08-10 | AAV-DELISTED | Stock | 6.22 | 6.29 | 6.16 | 6.24 | 205002.0 |
| 2010-08-10 | AAWW-DELISTED | Stock | 49.05 | 49.39 | 47.62 | 48.48 | 389341.0 |
| 2010-08-10 | AAXJ | Stock | 56.64 | 56.779 | 56.2 | 56.55 | 196124.0 |
| 2010-08-10 | AAXN-DELISTED | Stock | 4.02 | 4.15 | 4.0 | 4.06 | 388331.0 |
| 2010-08-10 | AB | Stock | 27.33 | 27.46 | 26.9 | 26.95 | 180200.0 |
| 2010-08-10 | ABAC-DELISTED | Stock | 3.89 | 4.01 | 3.826 | 4.0 | 55051.0 |
| 2010-08-10 | ABAX-DELISTED | Stock | 20.36 | 20.46 | 19.54 | 20.12 | 111121.0 |
| 2010-08-10 | ABB-DELISTED | Stock | 19.94 | 20.3 | 19.81 | 20.18 | 2067319.0 |
| 2010-08-10 | ABBC-DELISTED | Stock | 9.39 | 9.44 | 9.25 | 9.29 | 25167.0 |
| 2010-08-10 | ABBNY-DELISTED | Stock | 19.94 | 20.3 | 19.81 | 20.21 | 2077261.0 |
| 2010-08-10 | ABC-DELISTED | Stock | 29.9 | 30.085 | 29.65 | 29.96 | 2820902.0 |
| 2010-08-10 | ABCB | Stock | 9.45 | 9.58 | 9.25 | 9.26 | 40700.0 |
| 2010-08-10 | ABCD-DELISTED | Stock | 3.67 | 3.67 | 3.44 | 3.46 | 12840.0 |
| 2010-08-10 | ABCO-DELISTED | Stock | 22.02 | 22.18 | 21.58 | 22.08 | 119158.0 |
| 2010-08-10 | ABCW-DELISTED | Stock | 0.68 | 0.7 | 0.62 | 0.64 | 34990.0 |
| 2010-08-10 | ABD-DELISTED | Stock | 6.63 | 6.7 | 6.4 | 6.44 | 350790.0 |
| 2010-08-10 | ABE-DELISTED | Stock | 17.35 | 17.41 | 17.24 | 17.4 | 18615.0 |
| 2010-08-10 | ABEO | Stock | 2625.0 | 2625.0 | 2437.5 | 2562.5 | 20.0 |
| 2010-08-10 | ABFS-DELISTED | Stock | 21.59 | 21.89 | 20.83 | 21.22 | 204206.0 |
| 2010-08-10 | ABG | Stock | 14.15 | 14.25 | 13.85 | 14.0 | 320800.0 |
| 2010-08-10 | ABII-DELISTED | Stock | 75.71 | 76.1 | 75.71 | 76.07 | 113587.0 |
| 2010-08-10 | ABK-DELISTED | Stock | 0.635 | 0.7367 | 0.602 | 0.6995 | 47434594.0 |
| 2010-08-10 | ABM | Stock | 21.43 | 21.55 | 20.96 | 21.18 | 137100.0 |
| 2010-08-10 | ABMD-DELISTED | Stock | 10.1 | 10.33 | 9.95 | 10.14 | 151528.0 |
| 2010-08-10 | ABR | Stock | 5.6 | 5.76 | 5.3 | 5.36 | 95400.0 |
| 2010-08-10 | ABT | Stock | 24.3115 | 24.8057 | 24.2731 | 24.6953 | 18687370.0 |
| 2010-08-10 | ABTL-DELISTED | Stock | 5.1 | 5.25 | 5.1 | 5.2 | 619.0 |
| 2010-08-10 | ABV-DELISTED | Stock | 105.32 | 106.065 | 104.55 | 105.75 | 368504.0 |
| 2010-08-10 | ABVA-DELISTED | Stock | 2.95 | 2.95 | 2.95 | 2.95 | 300.0 |
| 2010-08-10 | ABVT-DELISTED | Stock | 52.95 | 53.61 | 52.54 | 53.0 | 133085.0 |
> showing 50 of 5,952 rows — these rows as CSV