PREVIEW / stock_daily / 2010-07-13
file: by_date/stock_daily/2010/2010-07-13.parquet size: 190 KB rows: 5,957 symbols: 3,507
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-07-13 | AAPL | Stock | 9.1543 | 9.1571 | 8.8011 | 8.9929 | 1190924000.0 |
| 2010-07-13 | MSFT | Stock | 25.14 | 25.3 | 24.9 | 25.13 | 61928700.0 |
| 2010-07-13 | NVDA | Stock | 0.2678 | 0.2748 | 0.2663 | 0.273 | 723316000.0 |
| 2010-07-13 | AMZN | Stock | 6.0345 | 6.244 | 6.015 | 6.1825 | 141822000.0 |
| 2010-07-13 | TSLA | Stock | 1.1593 | 1.2427 | 1.1267 | 1.2093 | 40201500.0 |
| 2010-07-13 | TLT | Stock | 98.85 | 98.89 | 98.18 | 98.33 | 5842456.0 |
| 2010-07-13 | ES | Stock | 27.54 | 27.54 | 27.22 | 27.32 | 1732300.0 |
| 2010-07-13 | CL | Stock | 41.65 | 41.745 | 41.425 | 41.575 | 4135800.0 |
| 2010-07-13 | A | Stock | 20.3648 | 20.7082 | 20.329 | 20.5651 | 5721874.0 |
| 2010-07-13 | AABA-DELISTED | Stock | 15.1 | 15.6 | 14.99 | 15.52 | 20411735.0 |
| 2010-07-13 | AACC-DELISTED | Stock | 3.91 | 4.19 | 3.9 | 4.19 | 37159.0 |
| 2010-07-13 | AACG | Stock | 3.1 | 3.1 | 2.89 | 2.94 | 21900.0 |
| 2010-07-13 | AAI-DELISTED | Stock | 5.01 | 5.01 | 4.9 | 4.94 | 3194138.0 |
| 2010-07-13 | AAIC-DELISTED | Stock | 19.28 | 19.28 | 18.69 | 18.96 | 61832.0 |
| 2010-07-13 | AAME | Stock | 1.25 | 1.27 | 1.2 | 1.27 | 2200.0 |
| 2010-07-13 | AAON | Stock | 4.6538 | 4.7388 | 4.5827 | 4.7249 | 247556.0 |
| 2010-07-13 | AAP | Stock | 51.65 | 52.77 | 51.63 | 52.65 | 1569300.0 |
| 2010-07-13 | AATI-DELISTED | Stock | 3.18 | 3.27 | 3.135 | 3.26 | 137877.0 |
| 2010-07-13 | AAU-DELISTED | Stock | 0.92 | 0.92 | 0.88 | 0.89 | 54954.0 |
| 2010-07-13 | AAUAF-DELISTED | Stock | 0.92 | 0.92 | 0.88 | 0.89 | 58954.0 |
| 2010-07-13 | AAV-DELISTED | Stock | 6.36 | 6.6 | 6.33 | 6.4 | 492115.0 |
| 2010-07-13 | AAWW-DELISTED | Stock | 52.18 | 54.5 | 51.24 | 54.4 | 292321.0 |
| 2010-07-13 | AAXJ | Stock | 55.07 | 55.33 | 54.91 | 55.25 | 114805.0 |
| 2010-07-13 | AAXN-DELISTED | Stock | 3.9 | 4.0 | 3.86 | 3.99 | 596739.0 |
| 2010-07-13 | AB | Stock | 28.88 | 29.12 | 28.56 | 28.8 | 345700.0 |
| 2010-07-13 | ABAX-DELISTED | Stock | 20.44 | 20.605 | 20.0 | 20.1 | 204352.0 |
| 2010-07-13 | ABB-DELISTED | Stock | 18.52 | 18.6799 | 18.51 | 18.6 | 2534457.0 |
| 2010-07-13 | ABBC-DELISTED | Stock | 9.01 | 9.27 | 8.95 | 9.23 | 60499.0 |
| 2010-07-13 | ABBNY-DELISTED | Stock | 18.52 | 18.6799 | 18.51 | 18.6 | 2551769.0 |
| 2010-07-13 | ABC-DELISTED | Stock | 31.97 | 32.54 | 31.97 | 32.33 | 2193324.0 |
| 2010-07-13 | ABCB | Stock | 10.31 | 10.59 | 10.19 | 10.49 | 84900.0 |
| 2010-07-13 | ABCD-DELISTED | Stock | 3.68 | 3.74 | 3.67 | 3.69 | 23754.0 |
| 2010-07-13 | ABCO-DELISTED | Stock | 21.1 | 21.16 | 20.73 | 21.1 | 188494.0 |
| 2010-07-13 | ABCW-DELISTED | Stock | 0.4896 | 0.4998 | 0.4617 | 0.47 | 73610.0 |
| 2010-07-13 | ABD-DELISTED | Stock | 5.48 | 5.7546 | 5.4 | 5.72 | 464220.0 |
| 2010-07-13 | ABE-DELISTED | Stock | 16.62 | 16.76 | 16.62 | 16.76 | 7140.0 |
| 2010-07-13 | ABEO | Stock | 2375.0 | 2437.5 | 2187.5 | 2375.0 | 168.0 |
| 2010-07-13 | ABFS-DELISTED | Stock | 21.84 | 22.49 | 21.77 | 22.46 | 485755.0 |
| 2010-07-13 | ABG | Stock | 10.28 | 10.99 | 10.0 | 10.93 | 362700.0 |
| 2010-07-13 | ABII-DELISTED | Stock | 74.99 | 75.09 | 74.62 | 74.84 | 46881.0 |
| 2010-07-13 | ABK-DELISTED | Stock | 0.72 | 0.75 | 0.685 | 0.7 | 10093967.0 |
| 2010-07-13 | ABM | Stock | 21.56 | 21.98 | 21.46 | 21.93 | 181200.0 |
| 2010-07-13 | ABMD-DELISTED | Stock | 10.67 | 11.07 | 10.45 | 11.02 | 274628.0 |
| 2010-07-13 | ABR | Stock | 6.21 | 6.27 | 5.69 | 5.77 | 345600.0 |
| 2010-07-13 | ABT | Stock | 22.9248 | 22.9776 | 22.8481 | 22.8721 | 14423510.0 |
| 2010-07-13 | ABTL-DELISTED | Stock | 5.9 | 6.5 | 5.75 | 5.9 | 41697.0 |
| 2010-07-13 | ABV-DELISTED | Stock | 106.0 | 106.38 | 105.16 | 105.67 | 628523.0 |
| 2010-07-13 | ABVT-DELISTED | Stock | 48.92 | 49.12 | 48.65 | 48.97 | 466954.0 |
| 2010-07-13 | ABX-DELISTED | Stock | 44.62 | 44.8 | 43.1 | 43.11 | 11117853.0 |
| 2010-07-13 | ACAD | Stock | 1.06 | 1.1 | 1.06 | 1.09 | 137000.0 |
> showing 50 of 5,957 rows — these rows as CSV