PREVIEW / stock_daily / 2015-01-07
file: by_date/stock_daily/2015/2015-01-07.parquet size: 222 KB rows: 6,639 symbols: 3,530
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 |
|---|---|---|---|---|---|---|---|
| 2015-01-07 | AAPL | Stock | 26.8 | 27.05 | 26.675 | 26.9375 | 160423600.0 |
| 2015-01-07 | MSFT | Stock | 45.98 | 46.46 | 45.49 | 46.23 | 29114100.0 |
| 2015-01-07 | NVDA | Stock | 0.4832 | 0.4875 | 0.477 | 0.4785 | 321808000.0 |
| 2015-01-07 | AMZN | Stock | 14.875 | 15.064 | 14.7665 | 14.921 | 52806000.0 |
| 2015-01-07 | GOOGL | Stock | 25.5475 | 25.5745 | 25.1825 | 25.2575 | 46917500.0 |
| 2015-01-07 | META | Stock | 76.76 | 77.36 | 75.82 | 76.15 | 22045300.0 |
| 2015-01-07 | TSLA | Stock | 14.2233 | 14.3187 | 13.9853 | 14.0633 | 44526000.0 |
| 2015-01-07 | TLT | Stock | 130.7 | 131.97 | 130.17 | 131.39 | 9762919.0 |
| 2015-01-07 | ES | Stock | 53.7 | 54.35 | 53.31 | 54.07 | 1463200.0 |
| 2015-01-07 | CL | Stock | 68.13 | 68.44 | 67.74 | 68.35 | 2908000.0 |
| 2015-01-07 | A | Stock | 39.52 | 39.81 | 39.29 | 39.7 | 3359700.0 |
| 2015-01-07 | AA.B-DELISTED | Stock | 49.28 | 50.01 | 49.28 | 49.93 | 34443.0 |
| 2015-01-07 | AABA-DELISTED | Stock | 49.62 | 49.64 | 48.51 | 48.595 | 11164422.0 |
| 2015-01-07 | AAC-DELISTED | Stock | 29.76 | 29.94 | 28.5 | 28.54 | 48037.0 |
| 2015-01-07 | AACG | Stock | 4.5 | 4.5 | 4.24 | 4.35 | 10400.0 |
| 2015-01-07 | AAIC-DELISTED | Stock | 26.35 | 26.47 | 26.17 | 26.43 | 184880.0 |
| 2015-01-07 | AAL | Stock | 53.38 | 53.65 | 52.12 | 53.01 | 10069800.0 |
| 2015-01-07 | AAMC-DELISTED | Stock | 95.9588 | 98.5265 | 95.9588 | 97.0618 | 21124.0 |
| 2015-01-07 | AAME | Stock | 3.9 | 3.92 | 3.87 | 3.92 | 1500.0 |
| 2015-01-07 | AAMI | Stock | 15.39 | 15.65 | 15.26 | 15.54 | 137700.0 |
| 2015-01-07 | AAOI | Stock | 10.35 | 10.39 | 9.703 | 9.85 | 351500.0 |
| 2015-01-07 | AAON | Stock | 14.0333 | 14.0933 | 13.7933 | 14.0267 | 198900.0 |
| 2015-01-07 | AAP | Stock | 157.61 | 160.61 | 157.06 | 159.72 | 1326800.0 |
| 2015-01-07 | AAT | Stock | 41.27 | 41.98 | 40.87 | 41.93 | 164800.0 |
| 2015-01-07 | AAU-DELISTED | Stock | 1.0 | 1.0362 | 0.98 | 0.991 | 106738.0 |
| 2015-01-07 | AAUAF-DELISTED | Stock | 1.0 | 1.0362 | 0.98 | 0.991 | 107070.0 |
| 2015-01-07 | AAV-DELISTED | Stock | 4.55 | 4.7899 | 4.46 | 4.48 | 155909.0 |
| 2015-01-07 | AAVL-DELISTED | Stock | 55.0 | 60.7 | 55.0 | 60.01 | 277868.0 |
| 2015-01-07 | AAWW-DELISTED | Stock | 46.07 | 46.5 | 45.4301 | 46.47 | 233058.0 |
| 2015-01-07 | AAXJ | Stock | 60.0 | 60.37 | 59.96 | 60.36 | 837844.0 |
| 2015-01-07 | AAXN-DELISTED | Stock | 25.89 | 26.2 | 25.22 | 25.98 | 1561031.0 |
| 2015-01-07 | AB | Stock | 24.99 | 25.34 | 24.55 | 24.89 | 279200.0 |
| 2015-01-07 | ABAC-DELISTED | Stock | 1.72 | 1.735 | 1.72 | 1.735 | 500.0 |
| 2015-01-07 | ABAX-DELISTED | Stock | 57.29 | 57.78 | 56.35 | 57.1 | 187739.0 |
| 2015-01-07 | ABB-DELISTED | Stock | 20.09 | 20.16 | 19.9201 | 20.04 | 2304572.0 |
| 2015-01-07 | ABBNY-DELISTED | Stock | 20.09 | 20.16 | 19.9201 | 20.05 | 2439203.0 |
| 2015-01-07 | ABBV | Stock | 64.57 | 67.05 | 64.48 | 66.93 | 8283300.0 |
| 2015-01-07 | ABC-DELISTED | Stock | 90.98 | 92.4 | 90.43 | 91.99 | 1430808.0 |
| 2015-01-07 | ABCB | Stock | 24.93 | 25.06 | 24.44 | 24.49 | 60400.0 |
| 2015-01-07 | ABCD-DELISTED | Stock | 1.81 | 1.84 | 1.72 | 1.75 | 12322.0 |
| 2015-01-07 | ABCO-DELISTED | Stock | 48.72 | 49.03 | 47.4 | 48.45 | 229196.0 |
| 2015-01-07 | ABCW-DELISTED | Stock | 34.93 | 34.93 | 34.65 | 34.85 | 4076.0 |
| 2015-01-07 | ABDC-DELISTED | Stock | 13.0 | 13.11 | 12.92 | 13.09 | 41096.0 |
| 2015-01-07 | ABE-DELISTED | Stock | 13.01 | 13.18 | 13.01 | 13.1312 | 2021.0 |
| 2015-01-07 | ABEO | Stock | 86.75 | 87.0 | 83.5 | 83.5 | 164.0 |
| 2015-01-07 | ABEV | Stock | 6.12 | 6.21 | 6.07 | 6.16 | 23427500.0 |
| 2015-01-07 | ABG | Stock | 73.48 | 75.04 | 72.67 | 75.01 | 458100.0 |
| 2015-01-07 | ABGB-DELISTED | Stock | 12.92 | 13.23 | 12.83 | 13.17 | 37632.0 |
| 2015-01-07 | ABIL-DELISTED | Stock | 9.74 | 9.9 | 9.74 | 9.9 | 7800.0 |
| 2015-01-07 | ABM | Stock | 28.77 | 29.13 | 28.63 | 29.08 | 205200.0 |
> showing 50 of 6,639 rows — these rows as CSV