PREVIEW / stock_daily / 2015-06-24
file: by_date/stock_daily/2015/2015-06-24.parquet size: 225 KB rows: 6,679 symbols: 3,509
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-06-24 | AAPL | Stock | 31.8025 | 32.45 | 31.78 | 32.0275 | 221123600.0 |
| 2015-06-24 | MSFT | Stock | 45.67 | 46.25 | 45.55 | 45.64 | 34890900.0 |
| 2015-06-24 | NVDA | Stock | 0.5298 | 0.5325 | 0.5228 | 0.5253 | 253368000.0 |
| 2015-06-24 | AMZN | Stock | 22.2485 | 22.3235 | 22.0115 | 22.042 | 52416000.0 |
| 2015-06-24 | GOOGL | Stock | 28.124 | 28.132 | 27.8405 | 27.9285 | 28923120.0 |
| 2015-06-24 | META | Stock | 87.66 | 89.25 | 87.45 | 88.86 | 41370200.0 |
| 2015-06-24 | TSLA | Stock | 17.7987 | 17.8233 | 17.5813 | 17.678 | 36184500.0 |
| 2015-06-24 | TLT | Stock | 116.51 | 117.17 | 116.16 | 116.95 | 8600392.0 |
| 2015-06-24 | ES | Stock | 45.89 | 46.13 | 45.56 | 45.57 | 835600.0 |
| 2015-06-24 | CL | Stock | 66.93 | 67.12 | 66.48 | 66.49 | 2815400.0 |
| 2015-06-24 | A | Stock | 39.47 | 40.45 | 39.03 | 40.19 | 6127700.0 |
| 2015-06-24 | AA.B-DELISTED | Stock | 41.9499 | 41.9499 | 41.52 | 41.6 | 19643.0 |
| 2015-06-24 | AABA-DELISTED | Stock | 40.68 | 41.23 | 40.58 | 40.945 | 10192388.0 |
| 2015-06-24 | AAC-DELISTED | Stock | 44.5 | 44.6387 | 42.94 | 42.99 | 234906.0 |
| 2015-06-24 | AACG | Stock | 5.25 | 5.3 | 5.15 | 5.17 | 7200.0 |
| 2015-06-24 | AAIC-DELISTED | Stock | 20.86 | 20.95 | 20.85 | 20.92 | 234206.0 |
| 2015-06-24 | AAL | Stock | 42.7 | 42.92 | 42.07 | 42.24 | 6895900.0 |
| 2015-06-24 | AAMC-DELISTED | Stock | 45.5882 | 45.5882 | 42.6471 | 42.7265 | 30535.0 |
| 2015-06-24 | AAME | Stock | 3.56 | 3.71 | 3.54 | 3.69 | 2800.0 |
| 2015-06-24 | AAMI | Stock | 18.38 | 18.495 | 18.07 | 18.08 | 233400.0 |
| 2015-06-24 | AAOI | Stock | 18.44 | 19.99 | 18.29 | 19.2 | 1158500.0 |
| 2015-06-24 | AAON | Stock | 15.3667 | 15.5733 | 15.2867 | 15.36 | 168450.0 |
| 2015-06-24 | AAP | Stock | 164.0 | 164.72 | 162.7 | 163.42 | 491200.0 |
| 2015-06-24 | AAT | Stock | 39.96 | 40.14 | 39.31 | 39.42 | 225400.0 |
| 2015-06-24 | AAU-DELISTED | Stock | 0.834 | 0.838 | 0.829 | 0.83 | 72677.0 |
| 2015-06-24 | AAUAF-DELISTED | Stock | 0.815 | 0.83 | 0.81 | 0.83 | 75154.0 |
| 2015-06-24 | AAV-DELISTED | Stock | 6.39 | 6.559 | 6.39 | 6.47 | 59167.0 |
| 2015-06-24 | AAVL-DELISTED | Stock | 16.24 | 16.97 | 16.24 | 16.71 | 1023416.0 |
| 2015-06-24 | AAWW-DELISTED | Stock | 56.63 | 57.33 | 55.51 | 56.03 | 564932.0 |
| 2015-06-24 | AAXJ | Stock | 65.46 | 65.6454 | 65.15 | 65.15 | 1529094.0 |
| 2015-06-24 | AAXN-DELISTED | Stock | 34.5 | 34.5971 | 33.71 | 33.78 | 1355556.0 |
| 2015-06-24 | AB | Stock | 29.98 | 30.16 | 29.6 | 29.85 | 205300.0 |
| 2015-06-24 | ABAC-DELISTED | Stock | 1.44 | 1.513 | 1.37 | 1.39 | 24269.0 |
| 2015-06-24 | ABAX-DELISTED | Stock | 52.42 | 52.61 | 51.39 | 51.47 | 114180.0 |
| 2015-06-24 | ABB-DELISTED | Stock | 21.82 | 21.96 | 21.72 | 21.73 | 2050907.0 |
| 2015-06-24 | ABBNY-DELISTED | Stock | 21.82 | 21.96 | 21.72 | 21.73 | 2124812.0 |
| 2015-06-24 | ABBV | Stock | 70.52 | 70.75 | 69.03 | 69.22 | 9308200.0 |
| 2015-06-24 | ABC-DELISTED | Stock | 111.5 | 111.6 | 109.57 | 109.6 | 1332858.0 |
| 2015-06-24 | ABCB | Stock | 25.85 | 25.99 | 25.76 | 25.83 | 72500.0 |
| 2015-06-24 | ABCD-DELISTED | Stock | 4.24 | 4.315 | 4.159 | 4.22 | 35086.0 |
| 2015-06-24 | ABCO-DELISTED | Stock | 54.08 | 54.61 | 53.84 | 54.21 | 171392.0 |
| 2015-06-24 | ABCW-DELISTED | Stock | 37.19 | 37.46 | 37.07 | 37.2 | 30840.0 |
| 2015-06-24 | ABDC-DELISTED | Stock | 13.5292 | 13.7 | 13.5292 | 13.7 | 27478.0 |
| 2015-06-24 | ABE-DELISTED | Stock | 12.84 | 12.91 | 12.8 | 12.81 | 26293.0 |
| 2015-06-24 | ABEO | Stock | 171.75 | 172.25 | 158.0 | 159.25 | 31544.0 |
| 2015-06-24 | ABEOW-DELISTED | Stock | 2.6 | 2.6 | 2.22 | 2.48 | 5850.0 |
| 2015-06-24 | ABEV | Stock | 6.15 | 6.2 | 6.09 | 6.1 | 5148900.0 |
| 2015-06-24 | ABG | Stock | 92.0 | 93.06 | 91.94 | 92.73 | 460300.0 |
| 2015-06-24 | ABGB-DELISTED | Stock | 17.01 | 17.01 | 16.82 | 16.88 | 8606.0 |
| 2015-06-24 | ABIL-DELISTED | Stock | 9.9753 | 9.9753 | 9.9753 | 9.9753 | 164.0 |
> showing 50 of 6,679 rows — these rows as CSV