PREVIEW / stock_daily / 2015-01-05
file: by_date/stock_daily/2015/2015-01-05.parquet size: 223 KB rows: 6,657 symbols: 3,545
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-05 | AAPL | Stock | 27.0725 | 27.1625 | 26.3525 | 26.5625 | 257142000.0 |
| 2015-01-05 | MSFT | Stock | 46.37 | 46.73 | 46.25 | 46.33 | 39673900.0 |
| 2015-01-05 | NVDA | Stock | 0.5032 | 0.5048 | 0.4925 | 0.4948 | 197952000.0 |
| 2015-01-05 | AMZN | Stock | 15.3505 | 15.419 | 15.0425 | 15.1095 | 55484000.0 |
| 2015-01-05 | GOOGL | Stock | 26.3575 | 26.3995 | 25.8875 | 25.973 | 41182380.0 |
| 2015-01-05 | META | Stock | 77.98 | 79.25 | 76.86 | 77.19 | 26452200.0 |
| 2015-01-05 | TSLA | Stock | 14.3033 | 14.4333 | 13.8107 | 14.006 | 80527500.0 |
| 2015-01-05 | TLT | Stock | 128.01 | 129.63 | 127.96 | 129.32 | 9789519.0 |
| 2015-01-05 | ES | Stock | 53.76 | 53.81 | 53.05 | 53.26 | 1400700.0 |
| 2015-01-05 | CL | Stock | 68.94 | 69.43 | 68.45 | 68.53 | 2950700.0 |
| 2015-01-05 | A | Stock | 40.32 | 40.46 | 39.7 | 39.8 | 2041800.0 |
| 2015-01-05 | AA.B-DELISTED | Stock | 50.99 | 50.99 | 48.63 | 48.93 | 23820.0 |
| 2015-01-05 | AABA-DELISTED | Stock | 49.71 | 49.88 | 48.91 | 49.14 | 11971315.0 |
| 2015-01-05 | AAC-DELISTED | Stock | 30.19 | 30.76 | 29.56 | 29.76 | 22274.0 |
| 2015-01-05 | AACG | Stock | 4.66 | 4.66 | 4.4 | 4.42 | 15900.0 |
| 2015-01-05 | AAIC-DELISTED | Stock | 26.61 | 26.69 | 26.43 | 26.62 | 203294.0 |
| 2015-01-05 | AAL | Stock | 54.37 | 54.54 | 53.34 | 53.88 | 11565000.0 |
| 2015-01-05 | AAMC-DELISTED | Stock | 97.0647 | 101.8441 | 95.5912 | 100.2559 | 26350.0 |
| 2015-01-05 | AAME | Stock | 3.9 | 4.01 | 3.9 | 4.01 | 13700.0 |
| 2015-01-05 | AAMI | Stock | 16.01 | 16.11 | 15.5 | 15.9 | 139300.0 |
| 2015-01-05 | AAOI | Stock | 10.75 | 10.85 | 10.4 | 10.65 | 204700.0 |
| 2015-01-05 | AAON | Stock | 14.5333 | 14.62 | 14.0733 | 14.1267 | 218700.0 |
| 2015-01-05 | AAP | Stock | 158.17 | 158.99 | 155.9 | 156.47 | 803600.0 |
| 2015-01-05 | AAT | Stock | 40.19 | 40.91 | 40.13 | 40.83 | 114100.0 |
| 2015-01-05 | AAU-DELISTED | Stock | 0.925 | 0.9581 | 0.9248 | 0.95 | 73181.0 |
| 2015-01-05 | AAUAF-DELISTED | Stock | 0.954 | 0.9884 | 0.95 | 0.95 | 71298.0 |
| 2015-01-05 | AAV-DELISTED | Stock | 4.59 | 4.74 | 4.54 | 4.61 | 131864.0 |
| 2015-01-05 | AAVL-DELISTED | Stock | 59.49 | 60.98 | 58.11 | 58.82 | 158895.0 |
| 2015-01-05 | AAWW-DELISTED | Stock | 48.09 | 48.09 | 46.57 | 46.66 | 163104.0 |
| 2015-01-05 | AAXJ | Stock | 60.61 | 60.61 | 59.88 | 59.94 | 614037.0 |
| 2015-01-05 | AAXN-DELISTED | Stock | 26.15 | 26.399 | 25.46 | 25.69 | 2328252.0 |
| 2015-01-05 | AB | Stock | 25.82 | 26.1 | 25.16 | 25.21 | 515900.0 |
| 2015-01-05 | ABAC-DELISTED | Stock | 1.8001 | 1.8001 | 1.7412 | 1.7496 | 10900.0 |
| 2015-01-05 | ABAX-DELISTED | Stock | 57.52 | 58.26 | 57.17 | 57.59 | 184016.0 |
| 2015-01-05 | ABB-DELISTED | Stock | 20.57 | 20.6 | 20.33 | 20.4 | 1490958.0 |
| 2015-01-05 | ABBNY-DELISTED | Stock | 20.57 | 20.6 | 20.33 | 20.38 | 1566397.0 |
| 2015-01-05 | ABBV | Stock | 65.5 | 66.1 | 63.88 | 64.65 | 8007400.0 |
| 2015-01-05 | ABC-DELISTED | Stock | 90.07 | 90.74 | 89.64 | 89.73 | 1471611.0 |
| 2015-01-05 | ABCB | Stock | 25.22 | 25.63 | 24.96 | 25.25 | 119800.0 |
| 2015-01-05 | ABCD-DELISTED | Stock | 1.65 | 1.85 | 1.65 | 1.77 | 16774.0 |
| 2015-01-05 | ABCO-DELISTED | Stock | 48.1 | 49.82 | 47.82 | 48.78 | 269673.0 |
| 2015-01-05 | ABCW-DELISTED | Stock | 34.78 | 35.0 | 34.75 | 34.88 | 24615.0 |
| 2015-01-05 | ABDC-DELISTED | Stock | 12.36 | 12.89 | 12.36 | 12.83 | 36405.0 |
| 2015-01-05 | ABE-DELISTED | Stock | 13.02 | 13.02 | 12.75 | 12.78 | 10995.0 |
| 2015-01-05 | ABEO | Stock | 92.75 | 93.75 | 80.25 | 80.25 | 1048.0 |
| 2015-01-05 | ABEOW-DELISTED | Stock | 0.989 | 1.15 | 0.8499 | 0.85 | 2850.0 |
| 2015-01-05 | ABEV | Stock | 5.76 | 5.85 | 5.7 | 5.84 | 17542900.0 |
| 2015-01-05 | ABG | Stock | 75.67 | 75.77 | 73.37 | 74.0 | 381800.0 |
| 2015-01-05 | ABGB-DELISTED | Stock | 11.36 | 11.37 | 11.1 | 11.14 | 17693.0 |
| 2015-01-05 | ABIL-DELISTED | Stock | 9.73 | 9.9 | 9.72 | 9.9 | 11900.0 |
> showing 50 of 6,657 rows — these rows as CSV