PREVIEW / stock_daily / 2010-12-03
file: by_date/stock_daily/2010/2010-12-03.parquet size: 196 KB rows: 6,043 symbols: 3,541
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-12-03 | AAPL | Stock | 11.3218 | 11.3804 | 11.2979 | 11.3371 | 342092800.0 |
| 2010-12-03 | MSFT | Stock | 26.81 | 27.06 | 26.78 | 27.02 | 52622000.0 |
| 2010-12-03 | NVDA | Stock | 0.3578 | 0.3698 | 0.357 | 0.3698 | 606044000.0 |
| 2010-12-03 | AMZN | Stock | 8.775 | 8.82 | 8.7025 | 8.784 | 98150000.0 |
| 2010-12-03 | TSLA | Stock | 2.134 | 2.15 | 2.058 | 2.0993 | 17401500.0 |
| 2010-12-03 | TLT | Stock | 96.28 | 96.33 | 94.85 | 94.89 | 10195108.0 |
| 2010-12-03 | ES | Stock | 31.73 | 31.84 | 31.43 | 31.64 | 1499800.0 |
| 2010-12-03 | CL | Stock | 38.815 | 39.0 | 38.74 | 38.975 | 3047800.0 |
| 2010-12-03 | A | Stock | 26.1087 | 26.8884 | 26.0944 | 26.8097 | 4565449.0 |
| 2010-12-03 | AABA-DELISTED | Stock | 16.28 | 16.37 | 16.2 | 16.34 | 8814073.0 |
| 2010-12-03 | AACC-DELISTED | Stock | 5.82 | 5.91 | 5.74 | 5.91 | 77509.0 |
| 2010-12-03 | AAI-DELISTED | Stock | 7.45 | 7.46 | 7.44 | 7.46 | 878564.0 |
| 2010-12-03 | AAIC-DELISTED | Stock | 25.13 | 25.24 | 24.86 | 25.15 | 26819.0 |
| 2010-12-03 | AAME | Stock | 1.98 | 1.98 | 1.94 | 1.94 | 1300.0 |
| 2010-12-03 | AAON | Stock | 5.276 | 5.3906 | 5.2286 | 5.3511 | 101250.0 |
| 2010-12-03 | AAP | Stock | 67.43 | 68.39 | 67.13 | 68.23 | 637000.0 |
| 2010-12-03 | AATI-DELISTED | Stock | 3.77 | 3.83 | 3.75 | 3.8 | 264682.0 |
| 2010-12-03 | AAU-DELISTED | Stock | 4.66 | 4.69 | 4.18 | 4.43 | 782478.0 |
| 2010-12-03 | AAUAF-DELISTED | Stock | 4.66 | 4.69 | 4.18 | 4.43 | 783078.0 |
| 2010-12-03 | AAV-DELISTED | Stock | 6.61 | 6.66 | 6.58 | 6.63 | 210294.0 |
| 2010-12-03 | AAWW-DELISTED | Stock | 54.69 | 55.83 | 54.69 | 55.64 | 192410.0 |
| 2010-12-03 | AAXJ | Stock | 63.19 | 63.78 | 63.0 | 63.7 | 1043228.0 |
| 2010-12-03 | AAXN-DELISTED | Stock | 4.07 | 4.14 | 4.04 | 4.09 | 213756.0 |
| 2010-12-03 | AB | Stock | 23.45 | 23.68 | 23.29 | 23.54 | 323600.0 |
| 2010-12-03 | ABAC-DELISTED | Stock | 4.77 | 5.4165 | 4.77 | 5.3187 | 72306.0 |
| 2010-12-03 | ABAX-DELISTED | Stock | 27.95 | 28.05 | 27.68 | 27.93 | 99812.0 |
| 2010-12-03 | ABB-DELISTED | Stock | 20.33 | 20.5 | 20.23 | 20.48 | 2910857.0 |
| 2010-12-03 | ABBC-DELISTED | Stock | 11.72 | 11.76 | 11.49 | 11.73 | 24416.0 |
| 2010-12-03 | ABBNY-DELISTED | Stock | 20.33 | 20.5 | 20.23 | 20.49 | 2915636.0 |
| 2010-12-03 | ABC-DELISTED | Stock | 31.76 | 32.2 | 31.63 | 32.14 | 2520354.0 |
| 2010-12-03 | ABCB | Stock | 9.89 | 10.0 | 9.85 | 9.96 | 34800.0 |
| 2010-12-03 | ABCD-DELISTED | Stock | 3.0 | 3.06 | 3.0 | 3.05 | 9586.0 |
| 2010-12-03 | ABCO-DELISTED | Stock | 23.74 | 24.47 | 23.6 | 24.28 | 65710.0 |
| 2010-12-03 | ABCW-DELISTED | Stock | 1.0 | 1.08 | 0.9819 | 1.04 | 276210.0 |
| 2010-12-03 | ABD-DELISTED | Stock | 7.35 | 7.48 | 7.3 | 7.43 | 205880.0 |
| 2010-12-03 | ABE-DELISTED | Stock | 18.9 | 18.918 | 18.66 | 18.77 | 7060.0 |
| 2010-12-03 | ABEO | Stock | 3500.0 | 3625.0 | 3500.0 | 3625.0 | 6.0 |
| 2010-12-03 | ABFS-DELISTED | Stock | 27.51 | 28.49 | 27.11 | 28.46 | 214508.0 |
| 2010-12-03 | ABG | Stock | 16.7 | 17.22 | 16.63 | 17.13 | 325000.0 |
| 2010-12-03 | ABM | Stock | 23.43 | 23.5 | 22.18 | 22.32 | 1189700.0 |
| 2010-12-03 | ABMD-DELISTED | Stock | 11.42 | 11.75 | 11.4 | 11.71 | 49845.0 |
| 2010-12-03 | ABR | Stock | 5.37 | 5.37 | 5.31 | 5.33 | 33400.0 |
| 2010-12-03 | ABT | Stock | 22.8241 | 22.8625 | 22.6082 | 22.7281 | 15885577.0 |
| 2010-12-03 | ABTL-DELISTED | Stock | 3.8872 | 4.0628 | 3.6239 | 4.0628 | 54661.0 |
| 2010-12-03 | ABUS | Stock | 4.86 | 4.86 | 4.71 | 4.76 | 9200.0 |
| 2010-12-03 | ABV-DELISTED | Stock | 139.41 | 143.5 | 139.11 | 143.24 | 349229.0 |
| 2010-12-03 | ABVA-DELISTED | Stock | 3.57 | 3.6 | 3.57 | 3.6 | 1200.0 |
| 2010-12-03 | ABVT-DELISTED | Stock | 56.49 | 57.26 | 55.99 | 57.2 | 162160.0 |
| 2010-12-03 | ABX-DELISTED | Stock | 53.79 | 55.38 | 53.78 | 54.02 | 12003172.0 |
| 2010-12-03 | ACAD | Stock | 0.69 | 0.8 | 0.67 | 0.74 | 373800.0 |
> showing 50 of 6,043 rows — these rows as CSV