PREVIEW / stock_daily / 2010-11-26
file: by_date/stock_daily/2010/2010-11-26.parquet size: 186 KB rows: 5,806 symbols: 3,394
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-11-26 | AAPL | Stock | 11.205 | 11.3464 | 11.1764 | 11.25 | 237585600.0 |
| 2010-11-26 | MSFT | Stock | 25.21 | 25.41 | 25.17 | 25.25 | 21356500.0 |
| 2010-11-26 | NVDA | Stock | 0.344 | 0.346 | 0.34 | 0.34 | 143104000.0 |
| 2010-11-26 | AMZN | Stock | 8.868 | 8.919 | 8.808 | 8.86 | 85432000.0 |
| 2010-11-26 | TSLA | Stock | 2.3733 | 2.4 | 2.3167 | 2.3547 | 5259000.0 |
| 2010-11-26 | TLT | Stock | 96.72 | 97.12 | 96.55 | 97.016 | 4848875.0 |
| 2010-11-26 | ES | Stock | 31.7 | 31.97 | 31.57 | 31.69 | 976500.0 |
| 2010-11-26 | CL | Stock | 38.78 | 38.94 | 38.565 | 38.695 | 1707000.0 |
| 2010-11-26 | A | Stock | 25.7225 | 26.0658 | 25.5866 | 26.0014 | 1094634.0 |
| 2010-11-26 | AABA-DELISTED | Stock | 16.25 | 16.4 | 16.25 | 16.27 | 4543080.0 |
| 2010-11-26 | AACC-DELISTED | Stock | 5.37 | 5.43 | 5.33 | 5.4 | 6000.0 |
| 2010-11-26 | AAI-DELISTED | Stock | 7.43 | 7.44 | 7.41 | 7.42 | 1376776.0 |
| 2010-11-26 | AAIC-DELISTED | Stock | 23.4 | 23.62 | 23.25 | 23.57 | 9506.0 |
| 2010-11-26 | AAME | Stock | 1.92 | 1.98 | 1.92 | 1.98 | 1000.0 |
| 2010-11-26 | AAON | Stock | 4.9402 | 5.116 | 4.9323 | 5.1062 | 80494.0 |
| 2010-11-26 | AAP | Stock | 66.93 | 67.73 | 66.56 | 67.11 | 294300.0 |
| 2010-11-26 | AATI-DELISTED | Stock | 3.69 | 3.75 | 3.67 | 3.75 | 26605.0 |
| 2010-11-26 | AAU-DELISTED | Stock | 3.82 | 4.0807 | 3.7197 | 3.82 | 1088697.0 |
| 2010-11-26 | AAUAF-DELISTED | Stock | 3.81 | 4.07 | 3.71 | 3.83 | 1094874.0 |
| 2010-11-26 | AAV-DELISTED | Stock | 6.61 | 6.66 | 6.59 | 6.62 | 109381.0 |
| 2010-11-26 | AAWW-DELISTED | Stock | 55.4 | 56.31 | 55.4 | 55.84 | 24592.0 |
| 2010-11-26 | AAXJ | Stock | 61.13 | 61.24 | 60.9 | 60.9 | 566913.0 |
| 2010-11-26 | AAXN-DELISTED | Stock | 4.08 | 4.25 | 4.08 | 4.16 | 112804.0 |
| 2010-11-26 | AB | Stock | 23.1 | 23.45 | 23.01 | 23.19 | 110000.0 |
| 2010-11-26 | ABAC-DELISTED | Stock | 6.1 | 6.1 | 5.92 | 6.1 | 15849.0 |
| 2010-11-26 | ABAX-DELISTED | Stock | 26.67 | 27.252 | 26.58 | 27.0 | 23354.0 |
| 2010-11-26 | ABB-DELISTED | Stock | 19.48 | 19.62 | 19.45 | 19.6 | 800827.0 |
| 2010-11-26 | ABBC-DELISTED | Stock | 11.8 | 11.91 | 11.77 | 11.77 | 14050.0 |
| 2010-11-26 | ABBNY-DELISTED | Stock | 19.48 | 19.62 | 19.45 | 19.58 | 802377.0 |
| 2010-11-26 | ABC-DELISTED | Stock | 30.69 | 30.91 | 30.5102 | 30.86 | 606968.0 |
| 2010-11-26 | ABCB | Stock | 9.8 | 9.91 | 9.78 | 9.86 | 7700.0 |
| 2010-11-26 | ABCD-DELISTED | Stock | 2.97 | 3.0299 | 2.97 | 2.98 | 5087.0 |
| 2010-11-26 | ABCO-DELISTED | Stock | 23.74 | 24.44 | 23.74 | 24.07 | 48364.0 |
| 2010-11-26 | ABCW-DELISTED | Stock | 0.89 | 0.89 | 0.86 | 0.87 | 25220.0 |
| 2010-11-26 | ABD-DELISTED | Stock | 7.21 | 7.28 | 7.13 | 7.15 | 53450.0 |
| 2010-11-26 | ABE-DELISTED | Stock | 18.62 | 18.78 | 18.33 | 18.4 | 6536.0 |
| 2010-11-26 | ABFS-DELISTED | Stock | 24.96 | 25.13 | 24.71 | 24.74 | 58153.0 |
| 2010-11-26 | ABG | Stock | 16.0 | 16.21 | 16.0 | 16.1 | 64100.0 |
| 2010-11-26 | ABM | Stock | 23.49 | 23.61 | 23.36 | 23.37 | 115900.0 |
| 2010-11-26 | ABMD-DELISTED | Stock | 11.72 | 11.88 | 11.64 | 11.75 | 28381.0 |
| 2010-11-26 | ABR | Stock | 5.35 | 5.39 | 5.28 | 5.31 | 5500.0 |
| 2010-11-26 | ABT | Stock | 22.5602 | 22.5602 | 22.4354 | 22.4546 | 6334306.0 |
| 2010-11-26 | ABTL-DELISTED | Stock | 3.9474 | 4.0332 | 3.8947 | 3.9 | 2796.0 |
| 2010-11-26 | ABUS | Stock | 5.25 | 5.34 | 5.22 | 5.22 | 3400.0 |
| 2010-11-26 | ABV-DELISTED | Stock | 139.49 | 141.67 | 138.9 | 139.29 | 257726.0 |
| 2010-11-26 | ABVA-DELISTED | Stock | 3.65 | 3.65 | 3.6 | 3.6 | 400.0 |
| 2010-11-26 | ABVT-DELISTED | Stock | 61.27 | 61.9499 | 61.21 | 61.29 | 65209.0 |
| 2010-11-26 | ABX-DELISTED | Stock | 50.02 | 50.56 | 49.93 | 50.4701 | 3307824.0 |
| 2010-11-26 | ACAD | Stock | 0.71 | 0.71 | 0.67 | 0.7 | 63200.0 |
| 2010-11-26 | ACAS-DELISTED | Stock | 7.3 | 7.41 | 7.28 | 7.35 | 1052304.0 |
> showing 50 of 5,806 rows — these rows as CSV