PREVIEW / stock_daily / 2013-10-29
file: by_date/stock_daily/2013/2013-10-29.parquet size: 214 KB rows: 6,419 symbols: 3,548
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-10-29 | AAPL | Stock | 19.1525 | 19.2589 | 18.3764 | 18.4529 | 635807200.0 |
| 2013-10-29 | MSFT | Stock | 35.63 | 35.72 | 35.26 | 35.52 | 31702200.0 |
| 2013-10-29 | NVDA | Stock | 0.3798 | 0.3815 | 0.3763 | 0.3808 | 387952000.0 |
| 2013-10-29 | AMZN | Stock | 17.948 | 18.1445 | 17.8145 | 18.135 | 43708000.0 |
| 2013-10-29 | META | Stock | 50.73 | 50.79 | 49.25 | 49.4 | 102143000.0 |
| 2013-10-29 | TSLA | Stock | 10.8507 | 11.03 | 10.2 | 10.9647 | 211675500.0 |
| 2013-10-29 | TLT | Stock | 107.62 | 108.07 | 107.51 | 108.06 | 5270646.0 |
| 2013-10-29 | ES | Stock | 43.68 | 43.75 | 43.23 | 43.46 | 1146000.0 |
| 2013-10-29 | CL | Stock | 64.89 | 66.0 | 64.72 | 65.94 | 4525900.0 |
| 2013-10-29 | A | Stock | 36.8526 | 37.1245 | 36.6452 | 36.9814 | 1669212.0 |
| 2013-10-29 | AABA-DELISTED | Stock | 33.07 | 34.0 | 32.82 | 33.169 | 28686334.0 |
| 2013-10-29 | AACG | Stock | 4.08 | 4.35 | 4.08 | 4.23 | 13400.0 |
| 2013-10-29 | AAIC-DELISTED | Stock | 25.41 | 25.56 | 24.4 | 24.53 | 223102.0 |
| 2013-10-29 | AAMC-DELISTED | Stock | 180.0 | 181.4824 | 179.6471 | 180.0 | 4743.0 |
| 2013-10-29 | AAME | Stock | 4.05 | 4.07 | 4.03 | 4.06 | 11300.0 |
| 2013-10-29 | AAMRQ-DELISTED | Stock | 7.06 | 7.12 | 6.75 | 7.0 | 19382343.0 |
| 2013-10-29 | AAOI | Stock | 11.91 | 13.18 | 11.91 | 13.06 | 180100.0 |
| 2013-10-29 | AAON | Stock | 12.2444 | 12.4978 | 12.1733 | 12.3422 | 121050.0 |
| 2013-10-29 | AAP | Stock | 100.95 | 101.51 | 99.97 | 100.3 | 952100.0 |
| 2013-10-29 | AAT | Stock | 33.81 | 33.97 | 33.68 | 33.74 | 283200.0 |
| 2013-10-29 | AAU-DELISTED | Stock | 1.4 | 1.4 | 1.34 | 1.36 | 87527.0 |
| 2013-10-29 | AAUAF-DELISTED | Stock | 1.41 | 1.41 | 1.34 | 1.35 | 89762.0 |
| 2013-10-29 | AAV-DELISTED | Stock | 3.97 | 4.016 | 3.96 | 3.97 | 84368.0 |
| 2013-10-29 | AAWW-DELISTED | Stock | 49.64 | 49.9 | 48.5 | 49.3 | 212537.0 |
| 2013-10-29 | AAXJ | Stock | 60.37 | 60.61 | 60.37 | 60.56 | 360105.0 |
| 2013-10-29 | AAXN-DELISTED | Stock | 15.25 | 15.73 | 15.25 | 15.68 | 1042949.0 |
| 2013-10-29 | AB | Stock | 22.65 | 23.0 | 22.39 | 22.39 | 622600.0 |
| 2013-10-29 | ABAC-DELISTED | Stock | 1.56 | 1.6 | 1.54 | 1.55 | 26903.0 |
| 2013-10-29 | ABAX-DELISTED | Stock | 35.77 | 36.0 | 35.61 | 35.83 | 172403.0 |
| 2013-10-29 | ABB-DELISTED | Stock | 25.65 | 25.68 | 25.46 | 25.61 | 1730160.0 |
| 2013-10-29 | ABBNY-DELISTED | Stock | 25.65 | 25.68 | 25.46 | 25.6 | 2287071.0 |
| 2013-10-29 | ABBV | Stock | 49.48 | 50.2 | 49.48 | 49.79 | 5022900.0 |
| 2013-10-29 | ABC-DELISTED | Stock | 65.38 | 65.8 | 65.105 | 65.8 | 1238825.0 |
| 2013-10-29 | ABCB | Stock | 18.82 | 19.0 | 18.61 | 19.0 | 114400.0 |
| 2013-10-29 | ABCD-DELISTED | Stock | 1.34 | 1.36 | 1.32 | 1.32 | 17315.0 |
| 2013-10-29 | ABCO-DELISTED | Stock | 69.38 | 70.2 | 68.63 | 69.51 | 100484.0 |
| 2013-10-29 | ABE-DELISTED | Stock | 20.49 | 20.58 | 20.47 | 20.49 | 2550.0 |
| 2013-10-29 | ABEO | Stock | 412.5 | 437.5 | 387.5 | 437.5 | 52.0 |
| 2013-10-29 | ABFS-DELISTED | Stock | 27.5 | 27.9 | 27.4 | 27.6 | 260000.0 |
| 2013-10-29 | ABG | Stock | 48.08 | 48.2 | 47.29 | 47.83 | 313600.0 |
| 2013-10-29 | ABGB-DELISTED | Stock | 11.94 | 11.96 | 11.74 | 11.86 | 82820.0 |
| 2013-10-29 | ABM | Stock | 28.4 | 28.55 | 28.04 | 28.12 | 229600.0 |
| 2013-10-29 | ABMD-DELISTED | Stock | 21.67 | 21.78 | 21.41 | 21.76 | 224079.0 |
| 2013-10-29 | ABR | Stock | 6.94 | 6.95 | 6.62 | 6.68 | 370800.0 |
| 2013-10-29 | ABR.A-DELISTED | Stock | 25.14 | 25.2399 | 25.0 | 25.1975 | 3243.0 |
| 2013-10-29 | ABR.B-DELISTED | Stock | 23.59 | 23.59 | 23.59 | 23.59 | 500.0 |
| 2013-10-29 | ABT | Stock | 37.36 | 37.46 | 37.26 | 37.28 | 5263700.0 |
| 2013-10-29 | ABTL-DELISTED | Stock | 8.17 | 8.8 | 8.14 | 8.52 | 195841.0 |
| 2013-10-29 | ABUS | Stock | 9.0 | 9.1 | 8.95 | 9.02 | 129400.0 |
| 2013-10-29 | ABV-DELISTED | Stock | 38.88 | 38.9 | 38.55 | 38.59 | 1409917.0 |
> showing 50 of 6,419 rows — these rows as CSV