PREVIEW / stock_daily / 2011-02-22
file: by_date/stock_daily/2011/2011-02-22.parquet size: 198 KB rows: 6,116 symbols: 3,566
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 |
|---|---|---|---|---|---|---|---|
| 2011-02-22 | AAPL | Stock | 12.2196 | 12.3357 | 12.0614 | 12.0932 | 872555600.0 |
| 2011-02-22 | MSFT | Stock | 26.78 | 27.1 | 26.52 | 26.59 | 60889000.0 |
| 2011-02-22 | NVDA | Stock | 0.6198 | 0.6215 | 0.5782 | 0.5802 | 1396648000.0 |
| 2011-02-22 | AMZN | Stock | 9.184 | 9.236 | 8.966 | 9.021 | 112742000.0 |
| 2011-02-22 | TSLA | Stock | 1.5253 | 1.5333 | 1.452 | 1.458 | 30969000.0 |
| 2011-02-22 | TLT | Stock | 89.91 | 90.94 | 89.71 | 90.83 | 11912278.0 |
| 2011-02-22 | ES | Stock | 33.18 | 33.47 | 33.18 | 33.44 | 1108500.0 |
| 2011-02-22 | CL | Stock | 39.055 | 39.455 | 38.91 | 39.3 | 5638000.0 |
| 2011-02-22 | A | Stock | 30.9514 | 31.2947 | 30.3219 | 30.3934 | 5792893.0 |
| 2011-02-22 | AABA-DELISTED | Stock | 17.13 | 17.39 | 16.87 | 16.91 | 32890976.0 |
| 2011-02-22 | AACC-DELISTED | Stock | 5.69 | 5.78 | 5.65 | 5.65 | 19940.0 |
| 2011-02-22 | AACG | Stock | 4.8 | 5.0 | 4.7 | 5.0 | 19300.0 |
| 2011-02-22 | AAI-DELISTED | Stock | 7.4 | 7.41 | 7.33 | 7.36 | 1711002.0 |
| 2011-02-22 | AAIC-DELISTED | Stock | 28.15 | 28.23 | 27.1 | 27.37 | 46996.0 |
| 2011-02-22 | AAME | Stock | 2.1 | 2.1 | 2.1 | 2.1 | 800.0 |
| 2011-02-22 | AAON | Stock | 6.0286 | 6.1235 | 6.003 | 6.0247 | 131625.0 |
| 2011-02-22 | AAP | Stock | 61.85 | 61.93 | 60.35 | 61.43 | 1313500.0 |
| 2011-02-22 | AAT | Stock | 21.49 | 21.57 | 21.26 | 21.42 | 118100.0 |
| 2011-02-22 | AATI-DELISTED | Stock | 4.35 | 4.39 | 4.22 | 4.29 | 192408.0 |
| 2011-02-22 | AAU-DELISTED | Stock | 4.38 | 4.45 | 3.91 | 4.0399 | 670169.0 |
| 2011-02-22 | AAUAF-DELISTED | Stock | 4.38 | 4.45 | 3.91 | 4.03 | 680337.0 |
| 2011-02-22 | AAV-DELISTED | Stock | 7.68 | 7.87 | 7.6 | 7.63 | 371315.0 |
| 2011-02-22 | AAWW-DELISTED | Stock | 70.93 | 71.68 | 69.34 | 69.37 | 544401.0 |
| 2011-02-22 | AAXJ | Stock | 60.27 | 60.5 | 59.23 | 59.57 | 1762175.0 |
| 2011-02-22 | AAXN-DELISTED | Stock | 4.22 | 4.35 | 4.16 | 4.17 | 552767.0 |
| 2011-02-22 | AB | Stock | 22.9 | 23.04 | 22.16 | 22.25 | 590800.0 |
| 2011-02-22 | ABAC-DELISTED | Stock | 4.15 | 4.6 | 4.15 | 4.5499 | 255741.0 |
| 2011-02-22 | ABAX-DELISTED | Stock | 26.18 | 26.6 | 25.96 | 26.18 | 66347.0 |
| 2011-02-22 | ABB-DELISTED | Stock | 23.67 | 23.93 | 23.54 | 23.63 | 1887331.0 |
| 2011-02-22 | ABBC-DELISTED | Stock | 13.01 | 13.06 | 12.84 | 12.96 | 145954.0 |
| 2011-02-22 | ABBNY-DELISTED | Stock | 23.67 | 23.93 | 23.54 | 23.64 | 1889279.0 |
| 2011-02-22 | ABC-DELISTED | Stock | 37.26 | 37.8 | 37.03 | 37.39 | 2600574.0 |
| 2011-02-22 | ABCB | Stock | 9.8 | 9.95 | 9.79 | 9.81 | 50000.0 |
| 2011-02-22 | ABCD-DELISTED | Stock | 3.81 | 3.81 | 3.64 | 3.68 | 59429.0 |
| 2011-02-22 | ABCO-DELISTED | Stock | 25.74 | 26.01 | 25.73 | 25.73 | 283068.0 |
| 2011-02-22 | ABCW-DELISTED | Stock | 1.22 | 1.25 | 1.2 | 1.2 | 106110.0 |
| 2011-02-22 | ABD-DELISTED | Stock | 8.905 | 9.055 | 8.615 | 8.625 | 222300.0 |
| 2011-02-22 | ABE-DELISTED | Stock | 18.11 | 18.32 | 17.66 | 17.8 | 25820.0 |
| 2011-02-22 | ABEO | Stock | 2750.0 | 2937.5 | 2750.0 | 2925.0 | 30.0 |
| 2011-02-22 | ABFS-DELISTED | Stock | 25.02 | 25.17 | 24.48 | 24.56 | 147288.0 |
| 2011-02-22 | ABG | Stock | 19.5 | 20.12 | 18.25 | 19.41 | 963800.0 |
| 2011-02-22 | ABH-DELISTED | Stock | 29.23 | 29.32 | 27.94 | 28.03 | 762939.0 |
| 2011-02-22 | ABM | Stock | 26.66 | 27.14 | 26.59 | 26.76 | 246000.0 |
| 2011-02-22 | ABMD-DELISTED | Stock | 13.08 | 13.1 | 12.77 | 12.83 | 134076.0 |
| 2011-02-22 | ABR | Stock | 6.5 | 6.51 | 6.23 | 6.24 | 38700.0 |
| 2011-02-22 | ABT | Stock | 22.2963 | 22.6322 | 22.2963 | 22.5362 | 23800125.0 |
| 2011-02-22 | ABTL-DELISTED | Stock | 5.75 | 5.95 | 5.4375 | 5.85 | 91417.0 |
| 2011-02-22 | ABUS | Stock | 5.25 | 5.25 | 4.96 | 5.05 | 22300.0 |
| 2011-02-22 | ABV-DELISTED | Stock | 27.45 | 27.59 | 26.89 | 26.94 | 3770311.0 |
| 2011-02-22 | ABVA-DELISTED | Stock | 4.6 | 4.6 | 4.56 | 4.6 | 1684.0 |
> showing 50 of 6,116 rows — these rows as CSV