PREVIEW / stock_daily / 2015-01-22
file: by_date/stock_daily/2015/2015-01-22.parquet size: 223 KB rows: 6,640 symbols: 3,526
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-22 | AAPL | Stock | 27.565 | 28.1175 | 27.43 | 28.1 | 215185600.0 |
| 2015-01-22 | MSFT | Stock | 46.38 | 47.14 | 46.08 | 47.13 | 35898000.0 |
| 2015-01-22 | NVDA | Stock | 0.5085 | 0.5178 | 0.5032 | 0.5162 | 159712000.0 |
| 2015-01-22 | AMZN | Stock | 15.0 | 15.6125 | 15.0 | 15.516 | 107252000.0 |
| 2015-01-22 | GOOGL | Stock | 26.15 | 26.942 | 26.0955 | 26.865 | 56068020.0 |
| 2015-01-22 | META | Stock | 77.17 | 77.75 | 76.68 | 77.65 | 19519500.0 |
| 2015-01-22 | TSLA | Stock | 13.1333 | 13.5493 | 13.0133 | 13.4413 | 61753500.0 |
| 2015-01-22 | TLT | Stock | 134.0 | 134.18 | 132.28 | 132.92 | 10200015.0 |
| 2015-01-22 | ES | Stock | 56.04 | 56.09 | 55.11 | 55.56 | 1298400.0 |
| 2015-01-22 | CL | Stock | 68.48 | 69.44 | 68.1 | 69.32 | 3084400.0 |
| 2015-01-22 | A | Stock | 38.51 | 39.86 | 38.12 | 39.65 | 4856600.0 |
| 2015-01-22 | AA.B-DELISTED | Stock | 51.09 | 51.4 | 50.75 | 51.39 | 13870.0 |
| 2015-01-22 | AABA-DELISTED | Stock | 48.43 | 49.08 | 48.01 | 48.88 | 11511493.0 |
| 2015-01-22 | AAC-DELISTED | Stock | 28.87 | 29.39 | 28.13 | 29.2 | 73088.0 |
| 2015-01-22 | AACG | Stock | 4.75 | 4.93 | 4.65 | 4.85 | 23000.0 |
| 2015-01-22 | AAIC-DELISTED | Stock | 26.68 | 27.06 | 26.51 | 27.02 | 243433.0 |
| 2015-01-22 | AAL | Stock | 54.52 | 55.82 | 53.91 | 55.59 | 16201100.0 |
| 2015-01-22 | AAMC-DELISTED | Stock | 77.9206 | 77.9206 | 70.5882 | 70.6206 | 15150.0 |
| 2015-01-22 | AAME | Stock | 3.82 | 4.0 | 3.82 | 4.0 | 6900.0 |
| 2015-01-22 | AAMI | Stock | 15.91 | 16.49 | 15.71 | 16.27 | 144400.0 |
| 2015-01-22 | AAOI | Stock | 8.78 | 9.06 | 8.612 | 8.98 | 172500.0 |
| 2015-01-22 | AAON | Stock | 14.5333 | 15.0667 | 14.4 | 15.02 | 176550.0 |
| 2015-01-22 | AAP | Stock | 154.4 | 157.62 | 153.9 | 156.54 | 738800.0 |
| 2015-01-22 | AAT | Stock | 43.73 | 44.34 | 43.47 | 44.17 | 132300.0 |
| 2015-01-22 | AAU-DELISTED | Stock | 1.23 | 1.23 | 1.17 | 1.21 | 277774.0 |
| 2015-01-22 | AAUAF-DELISTED | Stock | 1.25 | 1.25 | 1.19 | 1.21 | 274506.0 |
| 2015-01-22 | AAV-DELISTED | Stock | 4.18 | 4.24 | 4.08 | 4.16 | 209256.0 |
| 2015-01-22 | AAVL-DELISTED | Stock | 41.64 | 43.5091 | 37.01 | 43.26 | 712815.0 |
| 2015-01-22 | AAWW-DELISTED | Stock | 46.0 | 47.55 | 45.94 | 47.45 | 159304.0 |
| 2015-01-22 | AAXJ | Stock | 63.28 | 64.02 | 62.96 | 63.9 | 3442832.0 |
| 2015-01-22 | AAXN-DELISTED | Stock | 27.09 | 27.79 | 26.35 | 27.43 | 2250172.0 |
| 2015-01-22 | AB | Stock | 26.45 | 26.74 | 26.09 | 26.64 | 243300.0 |
| 2015-01-22 | ABAC-DELISTED | Stock | 1.5 | 1.5 | 1.401 | 1.49 | 4867.0 |
| 2015-01-22 | ABAX-DELISTED | Stock | 59.53 | 60.38 | 58.7201 | 59.4 | 511960.0 |
| 2015-01-22 | ABB-DELISTED | Stock | 20.0 | 20.07 | 19.891 | 20.0 | 2100549.0 |
| 2015-01-22 | ABBNY-DELISTED | Stock | 20.0 | 20.07 | 19.891 | 20.01 | 2187984.0 |
| 2015-01-22 | ABBV | Stock | 63.2 | 63.45 | 61.88 | 62.98 | 8941700.0 |
| 2015-01-22 | ABC-DELISTED | Stock | 93.23 | 94.225 | 91.95 | 94.16 | 1429649.0 |
| 2015-01-22 | ABCB | Stock | 23.19 | 24.59 | 23.14 | 24.59 | 75900.0 |
| 2015-01-22 | ABCD-DELISTED | Stock | 2.3 | 2.36 | 2.21 | 2.29 | 52462.0 |
| 2015-01-22 | ABCO-DELISTED | Stock | 44.0 | 45.56 | 43.0 | 45.24 | 2030933.0 |
| 2015-01-22 | ABCW-DELISTED | Stock | 34.7 | 34.75 | 33.5 | 34.75 | 4737.0 |
| 2015-01-22 | ABDC-DELISTED | Stock | 12.83 | 12.99 | 12.77 | 12.86 | 23864.0 |
| 2015-01-22 | ABE-DELISTED | Stock | 13.28 | 13.45 | 13.28 | 13.36 | 7155.0 |
| 2015-01-22 | ABEO | Stock | 77.0 | 79.25 | 77.0 | 77.5 | 72.0 |
| 2015-01-22 | ABEOW-DELISTED | Stock | 0.72 | 0.72 | 0.72 | 0.72 | 1000.0 |
| 2015-01-22 | ABEV | Stock | 6.71 | 6.8 | 6.61 | 6.74 | 12144100.0 |
| 2015-01-22 | ABG | Stock | 72.26 | 74.24 | 71.99 | 74.04 | 289000.0 |
| 2015-01-22 | ABGB-DELISTED | Stock | 16.35 | 16.35 | 15.99 | 16.25 | 38518.0 |
| 2015-01-22 | ABM | Stock | 29.1 | 29.67 | 28.91 | 29.64 | 164400.0 |
> showing 50 of 6,640 rows — these rows as CSV