PREVIEW / stock_daily / 2010-08-06
file: by_date/stock_daily/2010/2010-08-06.parquet size: 188 KB rows: 5,905 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-08-06 | AAPL | Stock | 9.2779 | 9.3389 | 9.2011 | 9.2889 | 444897600.0 |
| 2010-08-06 | MSFT | Stock | 25.18 | 25.56 | 25.02 | 25.55 | 55982100.0 |
| 2010-08-06 | NVDA | Stock | 0.235 | 0.2412 | 0.233 | 0.2388 | 739904000.0 |
| 2010-08-06 | AMZN | Stock | 6.336 | 6.42 | 6.295 | 6.416 | 101304000.0 |
| 2010-08-06 | TSLA | Stock | 1.34 | 1.344 | 1.3013 | 1.306 | 11128500.0 |
| 2010-08-06 | TLT | Stock | 99.79 | 100.21 | 99.49 | 100.1 | 6042386.0 |
| 2010-08-06 | ES | Stock | 28.96 | 29.16 | 28.68 | 28.97 | 1833300.0 |
| 2010-08-06 | CL | Stock | 38.31 | 38.485 | 38.02 | 38.25 | 7069600.0 |
| 2010-08-06 | A | Stock | 20.1574 | 20.5651 | 20.0787 | 20.5508 | 4722164.0 |
| 2010-08-06 | AABA-DELISTED | Stock | 14.06 | 14.38 | 14.0 | 14.34 | 13207297.0 |
| 2010-08-06 | AACC-DELISTED | Stock | 4.23 | 4.5 | 4.16 | 4.42 | 39434.0 |
| 2010-08-06 | AACG | Stock | 3.01 | 3.13 | 2.99 | 3.0 | 18100.0 |
| 2010-08-06 | AAI-DELISTED | Stock | 4.66 | 4.72 | 4.65 | 4.66 | 1679221.0 |
| 2010-08-06 | AAIC-DELISTED | Stock | 20.05 | 20.16 | 19.66 | 20.06 | 25998.0 |
| 2010-08-06 | AAME | Stock | 1.26 | 1.32 | 1.26 | 1.3 | 11700.0 |
| 2010-08-06 | AAON | Stock | 4.9323 | 4.9323 | 4.721 | 4.798 | 402975.0 |
| 2010-08-06 | AAP | Stock | 53.56 | 53.89 | 52.41 | 52.75 | 962300.0 |
| 2010-08-06 | AATI-DELISTED | Stock | 3.27 | 3.28 | 3.19 | 3.24 | 88856.0 |
| 2010-08-06 | AAU-DELISTED | Stock | 0.96 | 0.9992 | 0.9592 | 0.9707 | 74392.0 |
| 2010-08-06 | AAUAF-DELISTED | Stock | 0.96 | 1.0 | 0.9599 | 0.9715 | 74636.0 |
| 2010-08-06 | AAV-DELISTED | Stock | 6.19 | 6.34 | 6.19 | 6.34 | 179917.0 |
| 2010-08-06 | AAWW-DELISTED | Stock | 50.03 | 50.58 | 48.38 | 48.87 | 573598.0 |
| 2010-08-06 | AAXJ | Stock | 56.61 | 57.02 | 56.42 | 56.97 | 1236529.0 |
| 2010-08-06 | AAXN-DELISTED | Stock | 3.96 | 4.09 | 3.92 | 4.06 | 326841.0 |
| 2010-08-06 | AB | Stock | 27.33 | 27.38 | 26.45 | 26.7 | 324300.0 |
| 2010-08-06 | ABAC-DELISTED | Stock | 3.6921 | 3.9499 | 3.69 | 3.8981 | 46135.0 |
| 2010-08-06 | ABAX-DELISTED | Stock | 20.59 | 20.92 | 20.08 | 20.46 | 138491.0 |
| 2010-08-06 | ABB-DELISTED | Stock | 20.57 | 20.75 | 20.47 | 20.72 | 2345940.0 |
| 2010-08-06 | ABBC-DELISTED | Stock | 9.31 | 9.43 | 9.14 | 9.32 | 25849.0 |
| 2010-08-06 | ABBNY-DELISTED | Stock | 20.57 | 20.75 | 20.47 | 20.74 | 2367678.0 |
| 2010-08-06 | ABC-DELISTED | Stock | 30.15 | 30.33 | 29.83 | 30.22 | 3252332.0 |
| 2010-08-06 | ABCB | Stock | 9.33 | 9.48 | 9.02 | 9.46 | 50600.0 |
| 2010-08-06 | ABCD-DELISTED | Stock | 3.55 | 3.65 | 3.47 | 3.56 | 36536.0 |
| 2010-08-06 | ABCO-DELISTED | Stock | 22.05 | 22.27 | 21.55 | 21.76 | 53846.0 |
| 2010-08-06 | ABCW-DELISTED | Stock | 0.532 | 0.57 | 0.532 | 0.57 | 17970.0 |
| 2010-08-06 | ABD-DELISTED | Stock | 6.22 | 6.48 | 6.1 | 6.43 | 709360.0 |
| 2010-08-06 | ABE-DELISTED | Stock | 17.38 | 17.4 | 17.29 | 17.36 | 5649.0 |
| 2010-08-06 | ABEO | Stock | 2500.0 | 2625.0 | 2500.0 | 2625.0 | 4.0 |
| 2010-08-06 | ABFS-DELISTED | Stock | 21.84 | 22.15 | 21.2 | 21.5 | 375044.0 |
| 2010-08-06 | ABG | Stock | 13.19 | 13.95 | 13.02 | 13.91 | 185400.0 |
| 2010-08-06 | ABII-DELISTED | Stock | 75.52 | 75.95 | 75.43 | 75.8 | 28550.0 |
| 2010-08-06 | ABK-DELISTED | Stock | 0.8692 | 0.8988 | 0.85 | 0.873 | 12530330.0 |
| 2010-08-06 | ABM | Stock | 21.47 | 21.47 | 20.78 | 21.24 | 128900.0 |
| 2010-08-06 | ABMD-DELISTED | Stock | 10.06 | 10.14 | 9.75 | 9.96 | 199508.0 |
| 2010-08-06 | ABR | Stock | 5.85 | 5.93 | 5.66 | 5.83 | 157300.0 |
| 2010-08-06 | ABT | Stock | 23.8509 | 24.3163 | 23.8509 | 24.2635 | 16663193.0 |
| 2010-08-06 | ABTL-DELISTED | Stock | 5.35 | 5.5 | 5.25 | 5.25 | 10329.0 |
| 2010-08-06 | ABV-DELISTED | Stock | 106.83 | 106.83 | 104.99 | 105.84 | 654496.0 |
| 2010-08-06 | ABVA-DELISTED | Stock | 3.025 | 3.3 | 2.95 | 3.0 | 5645.0 |
| 2010-08-06 | ABVT-DELISTED | Stock | 52.06 | 54.29 | 51.8001 | 53.69 | 331933.0 |
> showing 50 of 5,905 rows — these rows as CSV