PREVIEW / stock_daily / 2015-01-15
file: by_date/stock_daily/2015/2015-01-15.parquet size: 221 KB rows: 6,616 symbols: 3,518
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-15 | AAPL | Stock | 27.5 | 27.515 | 26.665 | 26.705 | 240056000.0 |
| 2015-01-15 | MSFT | Stock | 46.22 | 46.38 | 45.41 | 45.48 | 32750800.0 |
| 2015-01-15 | NVDA | Stock | 0.497 | 0.5 | 0.4898 | 0.49 | 188932000.0 |
| 2015-01-15 | AMZN | Stock | 14.7 | 14.8 | 14.341 | 14.3475 | 88384000.0 |
| 2015-01-15 | GOOGL | Stock | 25.4445 | 25.4875 | 25.1005 | 25.2005 | 51133640.0 |
| 2015-01-15 | META | Stock | 76.4 | 76.57 | 73.54 | 74.05 | 34134000.0 |
| 2015-01-15 | TSLA | Stock | 12.966 | 13.05 | 12.6667 | 12.7913 | 78247500.0 |
| 2015-01-15 | TLT | Stock | 132.85 | 135.03 | 132.68 | 134.91 | 11454237.0 |
| 2015-01-15 | ES | Stock | 54.31 | 55.15 | 54.0 | 55.09 | 2110200.0 |
| 2015-01-15 | CL | Stock | 68.76 | 68.94 | 68.21 | 68.32 | 2383700.0 |
| 2015-01-15 | A | Stock | 39.33 | 39.41 | 37.99 | 38.01 | 2628900.0 |
| 2015-01-15 | AA.B-DELISTED | Stock | 48.95 | 49.33 | 48.65 | 48.65 | 32845.0 |
| 2015-01-15 | AABA-DELISTED | Stock | 47.54 | 47.75 | 46.2 | 46.21 | 13817719.0 |
| 2015-01-15 | AAC-DELISTED | Stock | 29.88 | 29.88 | 28.4 | 28.7 | 57488.0 |
| 2015-01-15 | AACG | Stock | 4.45 | 4.8 | 4.44 | 4.75 | 18700.0 |
| 2015-01-15 | AAIC-DELISTED | Stock | 25.82 | 26.03 | 25.7 | 25.83 | 239340.0 |
| 2015-01-15 | AAL | Stock | 49.14 | 50.4 | 48.58 | 49.41 | 10396900.0 |
| 2015-01-15 | AAMC-DELISTED | Stock | 57.9412 | 70.5559 | 53.2176 | 68.0441 | 96118.0 |
| 2015-01-15 | AAME | Stock | 3.9 | 4.0 | 3.8 | 3.94 | 8500.0 |
| 2015-01-15 | AAMI | Stock | 15.54 | 15.77 | 15.25 | 15.56 | 155200.0 |
| 2015-01-15 | AAOI | Stock | 8.86 | 8.86 | 8.36 | 8.38 | 313700.0 |
| 2015-01-15 | AAON | Stock | 14.54 | 14.54 | 14.0 | 14.2 | 136350.0 |
| 2015-01-15 | AAP | Stock | 151.17 | 151.86 | 147.83 | 148.02 | 926200.0 |
| 2015-01-15 | AAT | Stock | 44.15 | 44.15 | 43.23 | 43.57 | 123000.0 |
| 2015-01-15 | AAU-DELISTED | Stock | 1.15 | 1.16 | 1.11 | 1.15 | 299184.0 |
| 2015-01-15 | AAUAF-DELISTED | Stock | 1.15 | 1.16 | 1.11 | 1.15 | 300352.0 |
| 2015-01-15 | AAV-DELISTED | Stock | 4.63 | 4.68 | 4.37 | 4.43 | 136344.0 |
| 2015-01-15 | AAVL-DELISTED | Stock | 57.09 | 60.44 | 51.08 | 51.45 | 322226.0 |
| 2015-01-15 | AAWW-DELISTED | Stock | 46.08 | 46.43 | 45.04 | 45.49 | 141421.0 |
| 2015-01-15 | AAXJ | Stock | 62.26 | 62.44 | 61.94 | 61.96 | 2208861.0 |
| 2015-01-15 | AAXN-DELISTED | Stock | 26.18 | 26.33 | 25.21 | 25.23 | 1376073.0 |
| 2015-01-15 | AB | Stock | 25.7 | 25.7 | 25.16 | 25.36 | 178100.0 |
| 2015-01-15 | ABAC-DELISTED | Stock | 1.45 | 1.45 | 1.45 | 1.45 | 300.0 |
| 2015-01-15 | ABAX-DELISTED | Stock | 57.99 | 58.3 | 56.23 | 56.65 | 132239.0 |
| 2015-01-15 | ABB-DELISTED | Stock | 20.09 | 20.21 | 19.7 | 20.125 | 6360045.0 |
| 2015-01-15 | ABBNY-DELISTED | Stock | 20.09 | 20.21 | 19.7 | 20.12 | 6556834.0 |
| 2015-01-15 | ABBV | Stock | 64.0 | 64.11 | 62.87 | 62.89 | 6149100.0 |
| 2015-01-15 | ABC-DELISTED | Stock | 92.15 | 92.4 | 91.1 | 91.4 | 1187860.0 |
| 2015-01-15 | ABCB | Stock | 23.61 | 23.61 | 22.97 | 23.0 | 100300.0 |
| 2015-01-15 | ABCD-DELISTED | Stock | 1.8 | 1.83 | 1.785 | 1.8 | 18000.0 |
| 2015-01-15 | ABCO-DELISTED | Stock | 47.96 | 48.19 | 47.02 | 47.77 | 183456.0 |
| 2015-01-15 | ABCW-DELISTED | Stock | 34.9 | 34.9 | 34.1 | 34.57 | 14673.0 |
| 2015-01-15 | ABDC-DELISTED | Stock | 12.751 | 12.94 | 12.71 | 12.93 | 22856.0 |
| 2015-01-15 | ABE-DELISTED | Stock | 13.13 | 13.26 | 13.091 | 13.092 | 8379.0 |
| 2015-01-15 | ABEO | Stock | 77.5 | 81.25 | 77.5 | 77.5 | 1536.0 |
| 2015-01-15 | ABEOW-DELISTED | Stock | 0.8 | 0.8 | 0.72 | 0.72 | 2000.0 |
| 2015-01-15 | ABEV | Stock | 6.42 | 6.45 | 6.34 | 6.36 | 13711000.0 |
| 2015-01-15 | ABG | Stock | 72.23 | 72.36 | 70.1 | 70.12 | 440500.0 |
| 2015-01-15 | ABGB-DELISTED | Stock | 16.36 | 16.49 | 15.94 | 16.0 | 76072.0 |
| 2015-01-15 | ABM | Stock | 29.57 | 29.68 | 28.98 | 29.1 | 209000.0 |
> showing 50 of 6,616 rows — these rows as CSV