PREVIEW / stock_daily / 2013-08-12
file: by_date/stock_daily/2013/2013-08-12.parquet size: 212 KB rows: 6,382 symbols: 3,529
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-08-12 | AAPL | Stock | 16.3164 | 16.7375 | 16.3082 | 16.6914 | 364434000.0 |
| 2013-08-12 | MSFT | Stock | 32.46 | 32.97 | 32.46 | 32.87 | 25493700.0 |
| 2013-08-12 | NVDA | Stock | 0.3475 | 0.3645 | 0.3278 | 0.3592 | 257568000.0 |
| 2013-08-12 | AMZN | Stock | 14.7895 | 14.954 | 14.763 | 14.8345 | 30090000.0 |
| 2013-08-12 | META | Stock | 38.2 | 38.5 | 38.1 | 38.22 | 31161000.0 |
| 2013-08-12 | TSLA | Stock | 9.962 | 10.0333 | 9.47 | 9.8253 | 223683000.0 |
| 2013-08-12 | TLT | Stock | 107.61 | 107.6299 | 106.47 | 106.53 | 7562770.0 |
| 2013-08-12 | ES | Stock | 43.63 | 43.67 | 43.28 | 43.49 | 1186100.0 |
| 2013-08-12 | CL | Stock | 60.3 | 60.98 | 60.24 | 60.96 | 2276400.0 |
| 2013-08-12 | A | Stock | 32.8255 | 33.269 | 32.7039 | 33.226 | 1743586.0 |
| 2013-08-12 | AABA-DELISTED | Stock | 27.55 | 28.37 | 27.5 | 28.36 | 15968410.0 |
| 2013-08-12 | AACG | Stock | 5.24 | 5.38 | 5.2 | 5.38 | 4600.0 |
| 2013-08-12 | AAIC-DELISTED | Stock | 24.22 | 24.91 | 23.955 | 24.91 | 162863.0 |
| 2013-08-12 | AAME | Stock | 3.92 | 3.93 | 3.59 | 3.92 | 11600.0 |
| 2013-08-12 | AAMRQ-DELISTED | Stock | 5.795 | 5.87 | 5.73 | 5.81 | 2075770.0 |
| 2013-08-12 | AAON | Stock | 10.8533 | 11.3378 | 10.8444 | 11.2978 | 304650.0 |
| 2013-08-12 | AAP | Stock | 83.14 | 83.5 | 82.41 | 82.45 | 687100.0 |
| 2013-08-12 | AAT | Stock | 32.16 | 32.31 | 32.02 | 32.13 | 95500.0 |
| 2013-08-12 | AAU-DELISTED | Stock | 1.72 | 1.81 | 1.67 | 1.78 | 174224.0 |
| 2013-08-12 | AAUAF-DELISTED | Stock | 1.72 | 1.81 | 1.67 | 1.78 | 175024.0 |
| 2013-08-12 | AAV-DELISTED | Stock | 3.58 | 3.7 | 3.58 | 3.63 | 379508.0 |
| 2013-08-12 | AAWW-DELISTED | Stock | 42.84 | 43.42 | 42.5 | 42.93 | 206599.0 |
| 2013-08-12 | AAXJ | Stock | 56.08 | 56.4 | 55.92 | 56.33 | 353897.0 |
| 2013-08-12 | AAXN-DELISTED | Stock | 8.64 | 8.6945 | 8.58 | 8.6 | 256551.0 |
| 2013-08-12 | AB | Stock | 21.81 | 22.04 | 20.78 | 21.01 | 289700.0 |
| 2013-08-12 | ABAC-DELISTED | Stock | 0.6159 | 0.6179 | 0.6 | 0.6179 | 11520.0 |
| 2013-08-12 | ABAX-DELISTED | Stock | 39.78 | 40.98 | 39.78 | 40.98 | 77967.0 |
| 2013-08-12 | ABB-DELISTED | Stock | 22.37 | 22.49 | 22.34 | 22.36 | 1067729.0 |
| 2013-08-12 | ABBNY-DELISTED | Stock | 22.37 | 22.49 | 22.34 | 22.37 | 1070006.0 |
| 2013-08-12 | ABBV | Stock | 44.71 | 45.2 | 44.39 | 45.04 | 3826400.0 |
| 2013-08-12 | ABC-DELISTED | Stock | 58.9 | 59.24 | 58.45 | 58.68 | 1534779.0 |
| 2013-08-12 | ABCB | Stock | 18.78 | 19.43 | 18.75 | 19.08 | 29300.0 |
| 2013-08-12 | ABCD-DELISTED | Stock | 1.18 | 1.22 | 1.16 | 1.22 | 42423.0 |
| 2013-08-12 | ABCO-DELISTED | Stock | 57.59 | 58.58 | 57.31 | 58.58 | 86453.0 |
| 2013-08-12 | ABCW-DELISTED | Stock | 0.475 | 0.475 | 0.35 | 0.42 | 9569.0 |
| 2013-08-12 | ABE-DELISTED | Stock | 20.08 | 20.08 | 19.92 | 20.0 | 22326.0 |
| 2013-08-12 | ABEO | Stock | 462.5 | 550.0 | 450.0 | 525.0 | 3.0 |
| 2013-08-12 | ABFS-DELISTED | Stock | 23.08 | 23.82 | 22.98 | 23.54 | 671574.0 |
| 2013-08-12 | ABG | Stock | 51.19 | 51.53 | 51.02 | 51.42 | 350400.0 |
| 2013-08-12 | ABM | Stock | 25.65 | 26.0 | 25.65 | 25.97 | 82500.0 |
| 2013-08-12 | ABMD-DELISTED | Stock | 22.11 | 22.65 | 22.05 | 22.63 | 392486.0 |
| 2013-08-12 | ABR | Stock | 7.41 | 7.54 | 7.41 | 7.53 | 97800.0 |
| 2013-08-12 | ABR.A-DELISTED | Stock | 24.85 | 24.85 | 24.71 | 24.71 | 8700.0 |
| 2013-08-12 | ABR.B-DELISTED | Stock | 24.0 | 24.09 | 23.89 | 23.9 | 5735.0 |
| 2013-08-12 | ABT | Stock | 35.79 | 36.03 | 35.72 | 35.9 | 4986900.0 |
| 2013-08-12 | ABTL-DELISTED | Stock | 6.17 | 6.28 | 6.07 | 6.23 | 63204.0 |
| 2013-08-12 | ABUS | Stock | 5.5 | 5.63 | 5.47 | 5.63 | 51500.0 |
| 2013-08-12 | ABV-DELISTED | Stock | 37.55 | 37.9 | 36.86 | 37.11 | 1635190.0 |
| 2013-08-12 | ABX-DELISTED | Stock | 18.1 | 18.44 | 18.08 | 18.21 | 22456418.0 |
| 2013-08-12 | ACAD | Stock | 20.67 | 20.89 | 19.98 | 20.17 | 1696500.0 |
> showing 50 of 6,382 rows — these rows as CSV