PREVIEW / stock_daily / 2010-12-14
file: by_date/stock_daily/2010/2010-12-14.parquet size: 196 KB rows: 6,060 symbols: 3,552
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-14 | AAPL | Stock | 11.4904 | 11.5193 | 11.3929 | 11.4389 | 351008000.0 |
| 2010-12-14 | MSFT | Stock | 27.31 | 27.75 | 27.26 | 27.62 | 64070500.0 |
| 2010-12-14 | NVDA | Stock | 0.3713 | 0.378 | 0.3642 | 0.3648 | 755160000.0 |
| 2010-12-14 | AMZN | Stock | 8.714 | 8.788 | 8.6545 | 8.697 | 73706000.0 |
| 2010-12-14 | TSLA | Stock | 2.0193 | 2.026 | 1.8507 | 1.902 | 26485500.0 |
| 2010-12-14 | TLT | Stock | 92.4 | 93.02 | 91.44 | 92.135 | 23519383.0 |
| 2010-12-14 | ES | Stock | 31.71 | 31.97 | 31.66 | 31.81 | 1040600.0 |
| 2010-12-14 | CL | Stock | 39.84 | 40.49 | 39.81 | 40.39 | 6626000.0 |
| 2010-12-14 | A | Stock | 27.7539 | 28.0615 | 27.7396 | 27.8255 | 4478074.0 |
| 2010-12-14 | AABA-DELISTED | Stock | 16.76 | 16.84 | 16.57 | 16.64 | 11577091.0 |
| 2010-12-14 | AACC-DELISTED | Stock | 5.96 | 6.0 | 5.88 | 5.99 | 51410.0 |
| 2010-12-14 | AACG | Stock | 3.85 | 3.95 | 3.8 | 3.92 | 2600.0 |
| 2010-12-14 | AAI-DELISTED | Stock | 7.41 | 7.43 | 7.39 | 7.4 | 4656391.0 |
| 2010-12-14 | AAIC-DELISTED | Stock | 24.24 | 24.615 | 24.0 | 24.16 | 70876.0 |
| 2010-12-14 | AAME | Stock | 1.95 | 1.98 | 1.94 | 1.95 | 1500.0 |
| 2010-12-14 | AAON | Stock | 5.7185 | 5.7363 | 5.6079 | 5.6514 | 233887.0 |
| 2010-12-14 | AAP | Stock | 68.15 | 68.36 | 67.54 | 68.03 | 458000.0 |
| 2010-12-14 | AATI-DELISTED | Stock | 3.93 | 3.96 | 3.89 | 3.93 | 73879.0 |
| 2010-12-14 | AAU-DELISTED | Stock | 4.48 | 4.67 | 4.26 | 4.6 | 458456.0 |
| 2010-12-14 | AAUAF-DELISTED | Stock | 4.48 | 4.67 | 4.26 | 4.6 | 459237.0 |
| 2010-12-14 | AAV-DELISTED | Stock | 6.54 | 6.64 | 6.52 | 6.53 | 280633.0 |
| 2010-12-14 | AAWW-DELISTED | Stock | 57.66 | 57.6999 | 56.66 | 57.11 | 151090.0 |
| 2010-12-14 | AAXJ | Stock | 63.76 | 63.76 | 63.38 | 63.52 | 165314.0 |
| 2010-12-14 | AAXN-DELISTED | Stock | 4.67 | 4.85 | 4.57 | 4.59 | 815644.0 |
| 2010-12-14 | AB | Stock | 23.0 | 23.35 | 22.95 | 23.08 | 501200.0 |
| 2010-12-14 | ABAC-DELISTED | Stock | 5.14 | 5.23 | 5.0 | 5.01 | 53786.0 |
| 2010-12-14 | ABAX-DELISTED | Stock | 27.7 | 27.77 | 27.21 | 27.4 | 163475.0 |
| 2010-12-14 | ABB-DELISTED | Stock | 21.24 | 21.6 | 21.22 | 21.5 | 3258917.0 |
| 2010-12-14 | ABBC-DELISTED | Stock | 12.0 | 12.0 | 11.88 | 11.97 | 37307.0 |
| 2010-12-14 | ABBNY-DELISTED | Stock | 21.24 | 21.6 | 21.22 | 21.52 | 3288207.0 |
| 2010-12-14 | ABC-DELISTED | Stock | 31.67 | 32.09 | 31.59 | 31.94 | 2873457.0 |
| 2010-12-14 | ABCB | Stock | 10.29 | 10.41 | 10.09 | 10.36 | 53300.0 |
| 2010-12-14 | ABCD-DELISTED | Stock | 3.28 | 3.34 | 3.205 | 3.3 | 30726.0 |
| 2010-12-14 | ABCO-DELISTED | Stock | 23.99 | 24.81 | 23.82 | 24.33 | 110111.0 |
| 2010-12-14 | ABCW-DELISTED | Stock | 1.305 | 1.3448 | 1.295 | 1.295 | 125380.0 |
| 2010-12-14 | ABD-DELISTED | Stock | 8.58 | 8.58 | 8.26 | 8.4 | 344130.0 |
| 2010-12-14 | ABE-DELISTED | Stock | 18.65 | 18.79 | 18.63 | 18.74 | 28182.0 |
| 2010-12-14 | ABEO | Stock | 3125.0 | 3125.0 | 3062.5 | 3112.5 | 44.0 |
| 2010-12-14 | ABFS-DELISTED | Stock | 28.15 | 28.39 | 27.95 | 28.22 | 143601.0 |
| 2010-12-14 | ABG | Stock | 16.89 | 17.26 | 16.83 | 16.94 | 241700.0 |
| 2010-12-14 | ABH-DELISTED | Stock | 0.09 | 0.11 | 0.09 | 0.09 | 151050.0 |
| 2010-12-14 | ABM | Stock | 25.62 | 25.99 | 25.59 | 25.8 | 299100.0 |
| 2010-12-14 | ABMD-DELISTED | Stock | 9.19 | 9.2 | 9.02 | 9.12 | 628583.0 |
| 2010-12-14 | ABR | Stock | 5.24 | 5.39 | 5.2 | 5.23 | 42800.0 |
| 2010-12-14 | ABT | Stock | 22.7857 | 23.0544 | 22.7185 | 23.0544 | 18408712.0 |
| 2010-12-14 | ABTL-DELISTED | Stock | 4.35 | 4.449 | 4.35 | 4.4 | 19816.0 |
| 2010-12-14 | ABUS | Stock | 4.65 | 4.75 | 4.65 | 4.75 | 24800.0 |
| 2010-12-14 | ABV-DELISTED | Stock | 141.68 | 143.64 | 141.51 | 142.83 | 301933.0 |
| 2010-12-14 | ABVT-DELISTED | Stock | 55.93 | 55.96 | 55.36 | 55.75 | 73242.0 |
| 2010-12-14 | ABX-DELISTED | Stock | 54.01 | 54.04 | 52.86 | 53.14 | 6913397.0 |
> showing 50 of 6,060 rows — these rows as CSV