PREVIEW / stock_daily / 2013-06-14
file: by_date/stock_daily/2013/2013-06-14.parquet size: 207 KB rows: 6,319 symbols: 3,507
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-06-14 | AAPL | Stock | 15.55 | 15.5818 | 15.3036 | 15.3589 | 271866000.0 |
| 2013-06-14 | MSFT | Stock | 34.55 | 34.69 | 34.25 | 34.4 | 53192600.0 |
| 2013-06-14 | NVDA | Stock | 0.3605 | 0.361 | 0.3562 | 0.3588 | 236012000.0 |
| 2013-06-14 | AMZN | Stock | 13.75 | 13.8535 | 13.672 | 13.6995 | 43016000.0 |
| 2013-06-14 | META | Stock | 23.56 | 23.89 | 23.26 | 23.63 | 30677100.0 |
| 2013-06-14 | TSLA | Stock | 6.6667 | 6.8347 | 6.622 | 6.6867 | 98470500.0 |
| 2013-06-14 | TLT | Stock | 114.1 | 114.66 | 113.82 | 113.82 | 6679558.0 |
| 2013-06-14 | ES | Stock | 41.95 | 42.19 | 41.72 | 42.13 | 1181700.0 |
| 2013-06-14 | CL | Stock | 58.51 | 59.01 | 58.21 | 58.82 | 3099100.0 |
| 2013-06-14 | A | Stock | 31.7167 | 31.8813 | 31.3662 | 31.4735 | 2345425.0 |
| 2013-06-14 | AABA-DELISTED | Stock | 26.32 | 26.55 | 26.16 | 26.28 | 7383771.0 |
| 2013-06-14 | AACG | Stock | 4.31 | 4.5 | 4.28 | 4.45 | 3400.0 |
| 2013-06-14 | AAIC-DELISTED | Stock | 28.11 | 28.42 | 28.04 | 28.06 | 147809.0 |
| 2013-06-14 | AAME | Stock | 3.93 | 3.95 | 3.93 | 3.95 | 500.0 |
| 2013-06-14 | AAMRQ-DELISTED | Stock | 4.628 | 4.77 | 4.53 | 4.55 | 3971665.0 |
| 2013-06-14 | AAON | Stock | 9.6681 | 9.7304 | 9.5348 | 9.5644 | 260550.0 |
| 2013-06-14 | AAP | Stock | 82.61 | 83.64 | 81.64 | 82.48 | 521900.0 |
| 2013-06-14 | AAT | Stock | 31.94 | 32.13 | 31.45 | 31.56 | 123800.0 |
| 2013-06-14 | AAU-DELISTED | Stock | 1.75 | 1.762 | 1.65 | 1.69 | 57385.0 |
| 2013-06-14 | AAUAF-DELISTED | Stock | 1.73 | 1.74 | 1.63 | 1.69 | 58299.0 |
| 2013-06-14 | AAV-DELISTED | Stock | 4.39 | 4.4 | 4.22 | 4.32 | 433025.0 |
| 2013-06-14 | AAWW-DELISTED | Stock | 47.14 | 47.79 | 45.87 | 46.12 | 126305.0 |
| 2013-06-14 | AAXJ | Stock | 56.06 | 56.33 | 55.62 | 55.74 | 281378.0 |
| 2013-06-14 | AAXN-DELISTED | Stock | 9.44 | 9.47 | 9.2 | 9.27 | 227223.0 |
| 2013-06-14 | AB | Stock | 24.66 | 24.84 | 24.18 | 24.31 | 245600.0 |
| 2013-06-14 | ABAC-DELISTED | Stock | 0.589 | 0.59 | 0.587 | 0.5899 | 4937.0 |
| 2013-06-14 | ABAX-DELISTED | Stock | 46.26 | 46.73 | 46.11 | 46.53 | 100708.0 |
| 2013-06-14 | ABB-DELISTED | Stock | 21.86 | 21.96 | 21.73 | 21.83 | 745722.0 |
| 2013-06-14 | ABBNY-DELISTED | Stock | 21.86 | 21.96 | 21.73 | 21.82 | 761279.0 |
| 2013-06-14 | ABBV | Stock | 42.98 | 43.5 | 42.5 | 43.21 | 4078500.0 |
| 2013-06-14 | ABC-DELISTED | Stock | 54.44 | 55.21 | 54.4 | 54.92 | 1909630.0 |
| 2013-06-14 | ABCB | Stock | 16.39 | 16.48 | 16.04 | 16.16 | 27000.0 |
| 2013-06-14 | ABCD-DELISTED | Stock | 1.48 | 1.48 | 1.33 | 1.4699 | 600.0 |
| 2013-06-14 | ABCO-DELISTED | Stock | 53.2 | 53.51 | 52.17 | 53.36 | 130862.0 |
| 2013-06-14 | ABCW-DELISTED | Stock | 0.58 | 0.58 | 0.56 | 0.56 | 7783.0 |
| 2013-06-14 | ABE-DELISTED | Stock | 20.15 | 20.288 | 20.0542 | 20.26 | 5456.0 |
| 2013-06-14 | ABEO | Stock | 587.5 | 625.0 | 575.0 | 625.0 | 13.0 |
| 2013-06-14 | ABFS-DELISTED | Stock | 19.81 | 20.27 | 19.6 | 19.73 | 316775.0 |
| 2013-06-14 | ABG | Stock | 40.82 | 41.18 | 40.09 | 40.18 | 127900.0 |
| 2013-06-14 | ABM | Stock | 24.48 | 24.54 | 24.13 | 24.14 | 190300.0 |
| 2013-06-14 | ABMD-DELISTED | Stock | 21.52 | 21.8 | 21.35 | 21.62 | 419851.0 |
| 2013-06-14 | ABR | Stock | 6.81 | 6.89 | 6.75 | 6.77 | 141400.0 |
| 2013-06-14 | ABR.A-DELISTED | Stock | 24.71 | 24.969 | 24.68 | 24.95 | 5285.0 |
| 2013-06-14 | ABR.B-DELISTED | Stock | 24.19 | 24.2 | 24.05 | 24.06 | 4470.0 |
| 2013-06-14 | ABT | Stock | 36.68 | 37.1 | 36.59 | 36.81 | 4817800.0 |
| 2013-06-14 | ABTL-DELISTED | Stock | 4.83 | 4.85 | 4.76 | 4.78 | 6553.0 |
| 2013-06-14 | ABUS | Stock | 4.79 | 4.84 | 4.79 | 4.82 | 8300.0 |
| 2013-06-14 | ABV-DELISTED | Stock | 36.7 | 37.19 | 36.52 | 36.79 | 4315561.0 |
| 2013-06-14 | ABX-DELISTED | Stock | 19.96 | 20.01 | 19.46 | 19.51 | 9333817.0 |
| 2013-06-14 | ACAD | Stock | 19.63 | 19.8 | 18.24 | 19.31 | 4840600.0 |
> showing 50 of 6,319 rows — these rows as CSV