PREVIEW / stock_daily / 2013-01-29
file: by_date/stock_daily/2013/2013-01-29.parquet size: 206 KB rows: 6,240 symbols: 3,504
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 |
|---|---|---|---|---|---|---|---|
| 2013-01-29 | AAPL | Stock | 16.375 | 16.4357 | 16.1471 | 16.3668 | 571158000.0 |
| 2013-01-29 | MSFT | Stock | 27.82 | 28.13 | 27.6 | 28.01 | 49242600.0 |
| 2013-01-29 | NVDA | Stock | 0.314 | 0.3148 | 0.3073 | 0.3085 | 388872000.0 |
| 2013-01-29 | AMZN | Stock | 13.7675 | 13.773 | 12.9175 | 13.0175 | 203452000.0 |
| 2013-01-29 | META | Stock | 32.0 | 32.07 | 30.71 | 30.79 | 72976500.0 |
| 2013-01-29 | TSLA | Stock | 2.54 | 2.5627 | 2.4753 | 2.53 | 21399000.0 |
| 2013-01-29 | TLT | Stock | 117.62 | 118.0801 | 116.87 | 116.95 | 5553869.0 |
| 2013-01-29 | ES | Stock | 40.25 | 40.66 | 40.17 | 40.63 | 1461900.0 |
| 2013-01-29 | CL | Stock | 54.98 | 55.5 | 54.71 | 55.455 | 3249400.0 |
| 2013-01-29 | A | Stock | 32.1602 | 32.1745 | 31.8312 | 31.9313 | 4125917.0 |
| 2013-01-29 | AABA-DELISTED | Stock | 20.89 | 20.9 | 19.68 | 19.71 | 56922461.0 |
| 2013-01-29 | AACC-DELISTED | Stock | 5.13 | 5.39 | 5.13 | 5.34 | 29509.0 |
| 2013-01-29 | AACG | Stock | 5.52 | 5.52 | 5.48 | 5.48 | 1100.0 |
| 2013-01-29 | AAIC-DELISTED | Stock | 23.15 | 23.4 | 23.01 | 23.35 | 86123.0 |
| 2013-01-29 | AAMC-DELISTED | Stock | 34.7206 | 37.0588 | 34.7206 | 36.7647 | 151664.0 |
| 2013-01-29 | AAME | Stock | 3.34 | 3.38 | 3.32 | 3.33 | 4400.0 |
| 2013-01-29 | AAMRQ-DELISTED | Stock | 1.245 | 1.28 | 1.13 | 1.14 | 11470515.0 |
| 2013-01-29 | AAON | Stock | 6.6785 | 6.7704 | 6.6667 | 6.7615 | 298013.0 |
| 2013-01-29 | AAP | Stock | 75.83 | 75.83 | 74.49 | 74.57 | 852000.0 |
| 2013-01-29 | AAT | Stock | 28.57 | 29.56 | 28.46 | 29.48 | 857500.0 |
| 2013-01-29 | AAU-DELISTED | Stock | 2.76 | 2.85 | 2.76 | 2.83 | 149732.0 |
| 2013-01-29 | AAUAF-DELISTED | Stock | 2.79 | 2.85 | 2.76 | 2.83 | 150032.0 |
| 2013-01-29 | AAV-DELISTED | Stock | 2.95 | 2.98 | 2.93 | 2.97 | 201818.0 |
| 2013-01-29 | AAWW-DELISTED | Stock | 46.81 | 47.47 | 46.18 | 46.58 | 162429.0 |
| 2013-01-29 | AAXJ | Stock | 60.41 | 60.7 | 60.24 | 60.56 | 699632.0 |
| 2013-01-29 | AAXN-DELISTED | Stock | 8.84 | 8.99 | 8.77 | 8.885 | 520368.0 |
| 2013-01-29 | AB | Stock | 20.34 | 20.55 | 20.08 | 20.47 | 219400.0 |
| 2013-01-29 | ABAC-DELISTED | Stock | 0.946 | 0.946 | 0.88 | 0.9297 | 4710.0 |
| 2013-01-29 | ABAX-DELISTED | Stock | 39.64 | 39.7599 | 38.89 | 39.67 | 84155.0 |
| 2013-01-29 | ABB-DELISTED | Stock | 21.38 | 21.55 | 21.369 | 21.52 | 1634385.0 |
| 2013-01-29 | ABBNY-DELISTED | Stock | 21.38 | 21.55 | 21.369 | 21.51 | 1657747.0 |
| 2013-01-29 | ABBV | Stock | 36.71 | 37.46 | 36.25 | 37.31 | 8838500.0 |
| 2013-01-29 | ABC-DELISTED | Stock | 45.13 | 45.77 | 45.02 | 45.55 | 2342170.0 |
| 2013-01-29 | ABCB | Stock | 13.21 | 13.29 | 13.1 | 13.21 | 123600.0 |
| 2013-01-29 | ABCD-DELISTED | Stock | 1.32 | 1.355 | 1.231 | 1.3 | 9400.0 |
| 2013-01-29 | ABCO-DELISTED | Stock | 54.61 | 54.97 | 54.161 | 54.91 | 194569.0 |
| 2013-01-29 | ABCW-DELISTED | Stock | 0.65 | 0.65 | 0.61 | 0.61 | 8375.0 |
| 2013-01-29 | ABE-DELISTED | Stock | 21.67 | 21.78 | 21.67 | 21.72 | 8290.0 |
| 2013-01-29 | ABEO | Stock | 462.5 | 525.0 | 462.5 | 512.5 | 23.0 |
| 2013-01-29 | ABFS-DELISTED | Stock | 11.05 | 11.13 | 10.59 | 10.63 | 472212.0 |
| 2013-01-29 | ABG | Stock | 34.32 | 34.83 | 33.92 | 34.77 | 177600.0 |
| 2013-01-29 | ABM | Stock | 21.86 | 21.91 | 21.69 | 21.9 | 284300.0 |
| 2013-01-29 | ABMD-DELISTED | Stock | 13.59 | 14.0 | 13.46 | 13.8 | 800919.0 |
| 2013-01-29 | ABR | Stock | 6.88 | 7.14 | 6.85 | 7.09 | 163700.0 |
| 2013-01-29 | ABT | Stock | 32.97 | 33.45 | 32.96 | 33.33 | 14644400.0 |
| 2013-01-29 | ABTL-DELISTED | Stock | 4.06 | 4.12 | 4.05 | 4.074 | 12200.0 |
| 2013-01-29 | ABUS | Stock | 4.67 | 4.67 | 4.52 | 4.63 | 52600.0 |
| 2013-01-29 | ABV-DELISTED | Stock | 45.72 | 46.62 | 45.68 | 46.61 | 1850365.0 |
| 2013-01-29 | ABX-DELISTED | Stock | 32.85 | 33.05 | 32.49 | 32.81 | 8390196.0 |
| 2013-01-29 | ACAD | Stock | 6.75 | 6.84 | 6.17 | 6.28 | 3249100.0 |
> showing 50 of 6,240 rows — these rows as CSV