PREVIEW / stock_daily / 2010-12-21
file: by_date/stock_daily/2010/2010-12-21.parquet size: 197 KB rows: 6,100 symbols: 3,575
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-21 | AAPL | Stock | 11.5357 | 11.5854 | 11.5018 | 11.5786 | 256354000.0 |
| 2010-12-21 | MSFT | Stock | 27.85 | 28.14 | 27.76 | 28.07 | 38153000.0 |
| 2010-12-21 | NVDA | Stock | 0.3612 | 0.3718 | 0.361 | 0.3718 | 466952000.0 |
| 2010-12-21 | AMZN | Stock | 9.194 | 9.2825 | 9.13 | 9.2375 | 102220000.0 |
| 2010-12-21 | TSLA | Stock | 2.12 | 2.1793 | 2.114 | 2.1507 | 11665500.0 |
| 2010-12-21 | TLT | Stock | 93.13 | 93.79 | 92.49 | 93.79 | 8985008.0 |
| 2010-12-21 | ES | Stock | 32.04 | 32.09 | 31.81 | 31.89 | 1497300.0 |
| 2010-12-21 | CL | Stock | 40.285 | 40.43 | 39.685 | 39.95 | 5964200.0 |
| 2010-12-21 | A | Stock | 29.0773 | 29.3705 | 28.9843 | 29.206 | 5054189.0 |
| 2010-12-21 | AABA-DELISTED | Stock | 16.3 | 16.68 | 16.2 | 16.6 | 11308273.0 |
| 2010-12-21 | AACC-DELISTED | Stock | 5.75 | 5.75 | 5.65 | 5.72 | 12980.0 |
| 2010-12-21 | AACG | Stock | 3.68 | 3.87 | 3.68 | 3.87 | 2800.0 |
| 2010-12-21 | AAI-DELISTED | Stock | 7.42 | 7.43 | 7.37 | 7.43 | 2680105.0 |
| 2010-12-21 | AAIC-DELISTED | Stock | 25.15 | 25.45 | 25.06 | 25.18 | 26893.0 |
| 2010-12-21 | AAME | Stock | 1.94 | 1.99 | 1.94 | 1.99 | 1300.0 |
| 2010-12-21 | AAON | Stock | 5.7106 | 5.7383 | 5.6672 | 5.677 | 528525.0 |
| 2010-12-21 | AAP | Stock | 67.52 | 67.72 | 66.52 | 66.73 | 448600.0 |
| 2010-12-21 | AATI-DELISTED | Stock | 3.97 | 3.99 | 3.92 | 3.94 | 101184.0 |
| 2010-12-21 | AAU-DELISTED | Stock | 5.06 | 5.1 | 4.76 | 4.89 | 538960.0 |
| 2010-12-21 | AAUAF-DELISTED | Stock | 5.06 | 5.1 | 4.76 | 4.88 | 541935.0 |
| 2010-12-21 | AAV-DELISTED | Stock | 6.24 | 6.51 | 6.24 | 6.49 | 378733.0 |
| 2010-12-21 | AAWW-DELISTED | Stock | 57.0 | 57.33 | 56.56 | 57.3 | 430354.0 |
| 2010-12-21 | AAXJ | Stock | 62.7 | 62.92 | 62.54 | 62.79 | 186741.0 |
| 2010-12-21 | AAXN-DELISTED | Stock | 4.88 | 5.07 | 4.86 | 4.88 | 939507.0 |
| 2010-12-21 | AB | Stock | 22.24 | 22.58 | 22.16 | 22.5 | 559700.0 |
| 2010-12-21 | ABAC-DELISTED | Stock | 6.1 | 6.25 | 6.05 | 6.08 | 90976.0 |
| 2010-12-21 | ABAX-DELISTED | Stock | 27.85 | 28.07 | 27.76 | 27.97 | 149368.0 |
| 2010-12-21 | ABB-DELISTED | Stock | 22.05 | 22.09 | 21.8998 | 21.97 | 2418831.0 |
| 2010-12-21 | ABBC-DELISTED | Stock | 11.9 | 11.99 | 11.88 | 11.93 | 39835.0 |
| 2010-12-21 | ABBNY-DELISTED | Stock | 22.05 | 22.09 | 21.8998 | 21.95 | 2432751.0 |
| 2010-12-21 | ABC-DELISTED | Stock | 33.36 | 33.76 | 33.36 | 33.71 | 3582199.0 |
| 2010-12-21 | ABCB | Stock | 10.75 | 10.79 | 10.58 | 10.63 | 17900.0 |
| 2010-12-21 | ABCD-DELISTED | Stock | 3.31 | 3.42 | 3.31 | 3.4 | 18983.0 |
| 2010-12-21 | ABCO-DELISTED | Stock | 24.58 | 25.0 | 24.48 | 24.55 | 83265.0 |
| 2010-12-21 | ABCW-DELISTED | Stock | 1.1317 | 1.2 | 1.1122 | 1.2 | 114770.0 |
| 2010-12-21 | ABD-DELISTED | Stock | 8.44 | 8.733 | 8.4 | 8.67 | 390150.0 |
| 2010-12-21 | ABE-DELISTED | Stock | 18.59 | 18.75 | 18.53 | 18.75 | 10972.0 |
| 2010-12-21 | ABEO | Stock | 3000.0 | 3050.0 | 3000.0 | 3050.0 | 30.0 |
| 2010-12-21 | ABFS-DELISTED | Stock | 26.54 | 27.25 | 26.54 | 27.03 | 211940.0 |
| 2010-12-21 | ABG | Stock | 17.6 | 18.73 | 17.47 | 18.67 | 398500.0 |
| 2010-12-21 | ABH-DELISTED | Stock | 22.68 | 29.48 | 22.68 | 23.75 | 787432.0 |
| 2010-12-21 | ABM | Stock | 26.55 | 26.59 | 26.16 | 26.53 | 175500.0 |
| 2010-12-21 | ABMD-DELISTED | Stock | 9.29 | 9.54 | 9.2 | 9.41 | 451668.0 |
| 2010-12-21 | ABR | Stock | 5.58 | 5.64 | 5.55 | 5.6 | 49000.0 |
| 2010-12-21 | ABT | Stock | 23.1168 | 23.2367 | 22.9632 | 23.0304 | 16193622.0 |
| 2010-12-21 | ABTL-DELISTED | Stock | 3.9504 | 4.4635 | 3.9504 | 4.15 | 8050.0 |
| 2010-12-21 | ABUS | Stock | 4.67 | 4.67 | 4.51 | 4.52 | 9800.0 |
| 2010-12-21 | ABV-DELISTED | Stock | 148.11 | 153.79 | 148.11 | 152.955 | 808911.0 |
| 2010-12-21 | ABVA-DELISTED | Stock | 3.33 | 3.44 | 3.31 | 3.44 | 1380.0 |
| 2010-12-21 | ABVT-DELISTED | Stock | 57.25 | 57.99 | 57.12 | 57.84 | 68540.0 |
> showing 50 of 6,100 rows — these rows as CSV