PREVIEW / stock_daily / 2010-02-19
file: by_date/stock_daily/2010/2010-02-19.parquet size: 188 KB rows: 5,886 symbols: 3,477
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-02-19 | AAPL | Stock | 7.2093 | 7.2571 | 7.1825 | 7.2025 | 415469600.0 |
| 2010-02-19 | MSFT | Stock | 28.79 | 28.92 | 28.69 | 28.77 | 44451800.0 |
| 2010-02-19 | NVDA | Stock | 0.415 | 0.4195 | 0.4125 | 0.4145 | 510548000.0 |
| 2010-02-19 | AMZN | Stock | 5.8955 | 5.9545 | 5.85 | 5.876 | 142312000.0 |
| 2010-02-19 | TLT | Stock | 89.24 | 89.51 | 88.9 | 89.45 | 3502421.0 |
| 2010-02-19 | ES | Stock | 26.14 | 26.72 | 26.09 | 26.67 | 1316300.0 |
| 2010-02-19 | CL | Stock | 41.21 | 41.21 | 40.615 | 40.875 | 4863000.0 |
| 2010-02-19 | A | Stock | 22.0601 | 22.3677 | 21.9027 | 22.3176 | 4186171.0 |
| 2010-02-19 | AABA-DELISTED | Stock | 15.49 | 15.71 | 15.36 | 15.58 | 14905804.0 |
| 2010-02-19 | AACC-DELISTED | Stock | 5.7 | 5.93 | 5.68 | 5.73 | 28581.0 |
| 2010-02-19 | AACG | Stock | 3.45 | 3.65 | 3.36 | 3.45 | 13800.0 |
| 2010-02-19 | AAI-DELISTED | Stock | 4.9 | 5.04 | 4.87 | 5.03 | 2997608.0 |
| 2010-02-19 | AAIC-DELISTED | Stock | 17.8299 | 17.9 | 17.6 | 17.77 | 19288.0 |
| 2010-02-19 | AAME | Stock | 1.4 | 1.4 | 1.37 | 1.37 | 28700.0 |
| 2010-02-19 | AAON | Stock | 4.2844 | 4.3417 | 4.2252 | 4.3081 | 211612.0 |
| 2010-02-19 | AAP | Stock | 39.79 | 40.34 | 39.51 | 40.0 | 2525300.0 |
| 2010-02-19 | AATI-DELISTED | Stock | 3.47 | 3.51 | 3.41 | 3.45 | 110499.0 |
| 2010-02-19 | AAU-DELISTED | Stock | 0.95 | 0.98 | 0.91 | 0.96 | 36450.0 |
| 2010-02-19 | AAUAF-DELISTED | Stock | 0.95 | 0.98 | 0.91 | 0.96 | 37550.0 |
| 2010-02-19 | AAV-DELISTED | Stock | 7.01 | 7.15 | 6.96 | 7.1 | 431430.0 |
| 2010-02-19 | AAWW-DELISTED | Stock | 39.55 | 40.02 | 39.14 | 39.99 | 300358.0 |
| 2010-02-19 | AAXJ | Stock | 52.88 | 53.09 | 52.54 | 52.87 | 226825.0 |
| 2010-02-19 | AAXN-DELISTED | Stock | 6.8599 | 7.34 | 6.82 | 7.15 | 5249239.0 |
| 2010-02-19 | AB | Stock | 25.96 | 26.87 | 25.96 | 26.7 | 372400.0 |
| 2010-02-19 | ABAX-DELISTED | Stock | 25.58 | 25.82 | 25.36 | 25.48 | 105267.0 |
| 2010-02-19 | ABB-DELISTED | Stock | 19.61 | 19.91 | 19.52 | 19.8 | 3272013.0 |
| 2010-02-19 | ABBC-DELISTED | Stock | 7.64 | 7.74 | 7.58 | 7.71 | 36501.0 |
| 2010-02-19 | ABBNY-DELISTED | Stock | 19.61 | 19.91 | 19.52 | 19.78 | 3332014.0 |
| 2010-02-19 | ABC-DELISTED | Stock | 27.87 | 28.19 | 27.6 | 28.13 | 3765875.0 |
| 2010-02-19 | ABCB | Stock | 9.4815 | 9.6791 | 9.4322 | 9.61 | 40500.0 |
| 2010-02-19 | ABCD-DELISTED | Stock | 3.76 | 3.8 | 3.75 | 3.78 | 15020.0 |
| 2010-02-19 | ABCO-DELISTED | Stock | 16.355 | 16.375 | 16.17 | 16.21 | 69234.0 |
| 2010-02-19 | ABCW-DELISTED | Stock | 1.2705 | 1.2705 | 1.2398 | 1.25 | 84360.0 |
| 2010-02-19 | ABD-DELISTED | Stock | 7.5 | 7.68 | 7.39 | 7.51 | 243710.0 |
| 2010-02-19 | ABE-DELISTED | Stock | 16.17 | 16.1934 | 16.08 | 16.18 | 5811.0 |
| 2010-02-19 | ABEO | Stock | 3312.5 | 3375.0 | 3250.0 | 3362.5 | 21.0 |
| 2010-02-19 | ABFS-DELISTED | Stock | 24.76 | 25.29 | 24.6 | 25.08 | 380349.0 |
| 2010-02-19 | ABG | Stock | 11.68 | 11.83 | 11.63 | 11.7 | 155300.0 |
| 2010-02-19 | ABII-DELISTED | Stock | 33.72 | 34.38 | 33.65 | 33.72 | 85610.0 |
| 2010-02-19 | ABK-DELISTED | Stock | 0.6784 | 0.6784 | 0.63 | 0.65 | 5380782.0 |
| 2010-02-19 | ABM | Stock | 20.37 | 20.75 | 20.22 | 20.65 | 159500.0 |
| 2010-02-19 | ABMD-DELISTED | Stock | 10.0 | 10.11 | 9.72 | 9.95 | 230516.0 |
| 2010-02-19 | ABR | Stock | 2.43 | 2.52 | 2.4 | 2.43 | 158900.0 |
| 2010-02-19 | ABT | Stock | 26.3314 | 26.3362 | 25.9476 | 26.0915 | 20116924.0 |
| 2010-02-19 | ABTL-DELISTED | Stock | 5.55 | 5.55 | 5.35 | 5.5 | 5898.0 |
| 2010-02-19 | ABV-DELISTED | Stock | 99.04 | 100.9 | 99.0 | 100.3 | 483195.0 |
| 2010-02-19 | ABVA-DELISTED | Stock | 2.58 | 3.0 | 2.51 | 2.862 | 8135.0 |
| 2010-02-19 | ABVT-DELISTED | Stock | 61.65 | 62.0 | 61.0 | 61.74 | 137829.0 |
| 2010-02-19 | ABX-DELISTED | Stock | 38.84 | 40.0 | 38.61 | 39.34 | 15926972.0 |
| 2010-02-19 | ACAD | Stock | 1.31 | 1.33 | 1.3 | 1.32 | 93600.0 |
> showing 50 of 5,886 rows — these rows as CSV