PREVIEW / stock_daily / 2013-01-16
file: by_date/stock_daily/2013/2013-01-16.parquet size: 203 KB rows: 6,206 symbols: 3,484
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-16 | AAPL | Stock | 17.6657 | 18.1943 | 17.5893 | 18.0746 | 690804800.0 |
| 2013-01-16 | MSFT | Stock | 27.15 | 27.23 | 27.01 | 27.04 | 41077400.0 |
| 2013-01-16 | NVDA | Stock | 0.299 | 0.3048 | 0.299 | 0.3022 | 337376000.0 |
| 2013-01-16 | AMZN | Stock | 13.5265 | 13.562 | 13.3915 | 13.4465 | 41312000.0 |
| 2013-01-16 | META | Stock | 30.21 | 30.35 | 29.53 | 29.85 | 75332700.0 |
| 2013-01-16 | TSLA | Stock | 2.2567 | 2.282 | 2.2487 | 2.2733 | 20673000.0 |
| 2013-01-16 | TLT | Stock | 120.63 | 120.684 | 120.01 | 120.32 | 4286085.0 |
| 2013-01-16 | ES | Stock | 38.87 | 39.01 | 38.66 | 38.67 | 2327100.0 |
| 2013-01-16 | CL | Stock | 53.7 | 53.995 | 53.51 | 53.915 | 1461000.0 |
| 2013-01-16 | A | Stock | 30.8655 | 30.9299 | 30.6652 | 30.794 | 3019540.0 |
| 2013-01-16 | AABA-DELISTED | Stock | 19.91 | 20.14 | 19.62 | 20.07 | 33062327.0 |
| 2013-01-16 | AACC-DELISTED | Stock | 4.53 | 4.62 | 4.5 | 4.62 | 6573.0 |
| 2013-01-16 | AACG | Stock | 5.71 | 5.8 | 5.71 | 5.79 | 2100.0 |
| 2013-01-16 | AAIC-DELISTED | Stock | 22.49 | 22.7 | 22.26 | 22.62 | 80126.0 |
| 2013-01-16 | AAMC-DELISTED | Stock | 31.4706 | 31.7647 | 28.9118 | 30.7941 | 206781.0 |
| 2013-01-16 | AAME | Stock | 3.28 | 3.3 | 3.24 | 3.28 | 7400.0 |
| 2013-01-16 | AAMRQ-DELISTED | Stock | 1.505 | 1.57 | 1.47 | 1.5 | 6819529.0 |
| 2013-01-16 | AAON | Stock | 6.5807 | 6.6015 | 6.4741 | 6.5007 | 107663.0 |
| 2013-01-16 | AAP | Stock | 73.82 | 73.82 | 72.98 | 73.36 | 368700.0 |
| 2013-01-16 | AAT | Stock | 28.5 | 28.67 | 28.29 | 28.51 | 165700.0 |
| 2013-01-16 | AAU-DELISTED | Stock | 3.14 | 3.23 | 3.1368 | 3.22 | 227226.0 |
| 2013-01-16 | AAUAF-DELISTED | Stock | 3.15 | 3.24 | 3.1467 | 3.21 | 226823.0 |
| 2013-01-16 | AAV-DELISTED | Stock | 3.13 | 3.26 | 3.1299 | 3.26 | 157132.0 |
| 2013-01-16 | AAWW-DELISTED | Stock | 43.12 | 43.6 | 43.12 | 43.29 | 383344.0 |
| 2013-01-16 | AAXJ | Stock | 60.52 | 60.8 | 60.42 | 60.69 | 324107.0 |
| 2013-01-16 | AAXN-DELISTED | Stock | 9.35 | 9.382 | 9.17 | 9.25 | 586128.0 |
| 2013-01-16 | AB | Stock | 19.84 | 20.07 | 19.65 | 19.92 | 290500.0 |
| 2013-01-16 | ABAX-DELISTED | Stock | 39.14 | 39.5 | 38.63 | 39.24 | 55846.0 |
| 2013-01-16 | ABB-DELISTED | Stock | 20.96 | 21.16 | 20.93 | 21.05 | 1758437.0 |
| 2013-01-16 | ABBNY-DELISTED | Stock | 20.96 | 21.16 | 20.93 | 21.06 | 1817393.0 |
| 2013-01-16 | ABBV | Stock | 34.47 | 35.54 | 34.45 | 35.54 | 16512700.0 |
| 2013-01-16 | ABC-DELISTED | Stock | 45.11 | 45.31 | 44.89 | 45.03 | 1709500.0 |
| 2013-01-16 | ABCB | Stock | 12.83 | 12.87 | 12.73 | 12.8 | 11100.0 |
| 2013-01-16 | ABCD-DELISTED | Stock | 1.2002 | 1.27 | 1.2 | 1.2 | 9335.0 |
| 2013-01-16 | ABCO-DELISTED | Stock | 52.52 | 53.02 | 52.29 | 52.37 | 118475.0 |
| 2013-01-16 | ABCW-DELISTED | Stock | 0.5 | 0.6 | 0.5 | 0.57 | 61780.0 |
| 2013-01-16 | ABE-DELISTED | Stock | 21.68 | 21.882 | 21.68 | 21.73 | 3985.0 |
| 2013-01-16 | ABEO | Stock | 325.0 | 350.0 | 325.0 | 350.0 | 5.0 |
| 2013-01-16 | ABFS-DELISTED | Stock | 10.44 | 10.49 | 10.12 | 10.2 | 270102.0 |
| 2013-01-16 | ABG | Stock | 33.4 | 33.66 | 33.08 | 33.41 | 135100.0 |
| 2013-01-16 | ABM | Stock | 20.5 | 20.58 | 20.41 | 20.51 | 295100.0 |
| 2013-01-16 | ABMD-DELISTED | Stock | 12.18 | 12.69 | 11.96 | 12.45 | 1025787.0 |
| 2013-01-16 | ABR | Stock | 7.14 | 7.14 | 7.0 | 7.04 | 126500.0 |
| 2013-01-16 | ABT | Stock | 33.15 | 33.16 | 32.6 | 32.7 | 17500300.0 |
| 2013-01-16 | ABTL-DELISTED | Stock | 3.9793 | 3.9807 | 3.933 | 3.951 | 2121.0 |
| 2013-01-16 | ABUS | Stock | 5.37 | 5.37 | 5.14 | 5.22 | 10900.0 |
| 2013-01-16 | ABV-DELISTED | Stock | 43.28 | 44.21 | 43.25 | 44.09 | 1590580.0 |
| 2013-01-16 | ABX-DELISTED | Stock | 34.43 | 34.46 | 34.03 | 34.14 | 8109341.0 |
| 2013-01-16 | ACAD | Stock | 5.76 | 5.95 | 5.33 | 5.39 | 2889800.0 |
| 2013-01-16 | ACAS-DELISTED | Stock | 13.28 | 13.43 | 13.16 | 13.195 | 2628710.0 |
> showing 50 of 6,206 rows — these rows as CSV