PREVIEW / stock_daily / 2015-04-07
file: by_date/stock_daily/2015/2015-04-07.parquet size: 222 KB rows: 6,613 symbols: 3,498
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-04-07 | AAPL | Stock | 31.91 | 32.03 | 31.495 | 31.5025 | 140049200.0 |
| 2015-04-07 | MSFT | Stock | 41.61 | 41.91 | 41.31 | 41.53 | 28809400.0 |
| 2015-04-07 | NVDA | Stock | 0.5418 | 0.5525 | 0.5388 | 0.5465 | 413964000.0 |
| 2015-04-07 | AMZN | Stock | 18.8075 | 18.9655 | 18.7015 | 18.7205 | 39098000.0 |
| 2015-04-07 | GOOGL | Stock | 27.2495 | 27.508 | 27.1793 | 27.243 | 27318320.0 |
| 2015-04-07 | META | Stock | 82.65 | 83.42 | 82.22 | 82.32 | 17467000.0 |
| 2015-04-07 | TSLA | Stock | 13.5007 | 13.6707 | 13.4093 | 13.55 | 65218500.0 |
| 2015-04-07 | TLT | Stock | 130.23 | 131.22 | 129.85 | 131.09 | 4764948.0 |
| 2015-04-07 | ES | Stock | 50.97 | 51.3 | 50.25 | 50.31 | 1135500.0 |
| 2015-04-07 | CL | Stock | 69.93 | 70.44 | 69.69 | 69.71 | 1777400.0 |
| 2015-04-07 | A | Stock | 41.94 | 42.52 | 41.87 | 42.44 | 3072400.0 |
| 2015-04-07 | AA.B-DELISTED | Stock | 45.25 | 45.58 | 45.2 | 45.32 | 35778.0 |
| 2015-04-07 | AABA-DELISTED | Stock | 43.79 | 44.22 | 43.56 | 43.6 | 10673810.0 |
| 2015-04-07 | AAC-DELISTED | Stock | 30.75 | 32.75 | 30.7 | 32.33 | 191496.0 |
| 2015-04-07 | AACG | Stock | 4.1 | 4.6 | 4.1 | 4.34 | 11300.0 |
| 2015-04-07 | AAIC-DELISTED | Stock | 24.02 | 24.23 | 24.0 | 24.07 | 170516.0 |
| 2015-04-07 | AAL | Stock | 48.3 | 48.8 | 47.49 | 47.5 | 9393200.0 |
| 2015-04-07 | AAMC-DELISTED | Stock | 69.7059 | 77.9518 | 69.7059 | 76.4559 | 101208.0 |
| 2015-04-07 | AAME | Stock | 3.96 | 3.99 | 3.94 | 3.94 | 1500.0 |
| 2015-04-07 | AAMI | Stock | 18.5 | 19.26 | 18.4 | 19.01 | 833700.0 |
| 2015-04-07 | AAOI | Stock | 13.7 | 13.87 | 13.15 | 13.19 | 180600.0 |
| 2015-04-07 | AAON | Stock | 15.8667 | 15.98 | 15.6733 | 15.6933 | 151500.0 |
| 2015-04-07 | AAP | Stock | 146.05 | 147.1 | 145.79 | 146.71 | 797000.0 |
| 2015-04-07 | AAT | Stock | 43.59 | 43.59 | 42.73 | 42.78 | 105800.0 |
| 2015-04-07 | AAU-DELISTED | Stock | 0.8613 | 0.88 | 0.83 | 0.835 | 149601.0 |
| 2015-04-07 | AAUAF-DELISTED | Stock | 0.8613 | 0.88 | 0.83 | 0.84 | 150416.0 |
| 2015-04-07 | AAV-DELISTED | Stock | 5.73 | 5.859 | 5.66 | 5.67 | 91439.0 |
| 2015-04-07 | AAVL-DELISTED | Stock | 38.5 | 39.3 | 38.02 | 38.86 | 319370.0 |
| 2015-04-07 | AAWW-DELISTED | Stock | 42.67 | 43.41 | 42.1 | 42.26 | 176787.0 |
| 2015-04-07 | AAXJ | Stock | 65.8 | 65.93 | 65.62 | 65.62 | 512868.0 |
| 2015-04-07 | AAXN-DELISTED | Stock | 24.46 | 25.0 | 24.4 | 24.52 | 713310.0 |
| 2015-04-07 | AB | Stock | 30.54 | 30.76 | 30.28 | 30.33 | 106300.0 |
| 2015-04-07 | ABAC-DELISTED | Stock | 1.65 | 1.7999 | 1.65 | 1.77 | 18440.0 |
| 2015-04-07 | ABAX-DELISTED | Stock | 62.43 | 63.41 | 62.13 | 62.19 | 64842.0 |
| 2015-04-07 | ABB-DELISTED | Stock | 21.76 | 21.81 | 21.56 | 21.59 | 1049674.0 |
| 2015-04-07 | ABBNY-DELISTED | Stock | 21.76 | 21.81 | 21.56 | 21.59 | 1144172.0 |
| 2015-04-07 | ABBV | Stock | 58.25 | 58.75 | 57.79 | 58.42 | 10171500.0 |
| 2015-04-07 | ABC-DELISTED | Stock | 112.91 | 113.49 | 112.45 | 112.71 | 985246.0 |
| 2015-04-07 | ABCB | Stock | 26.46 | 26.71 | 26.46 | 26.49 | 50800.0 |
| 2015-04-07 | ABCD-DELISTED | Stock | 3.15 | 3.155 | 3.01 | 3.01 | 46805.0 |
| 2015-04-07 | ABCO-DELISTED | Stock | 54.05 | 54.05 | 51.79 | 51.84 | 210567.0 |
| 2015-04-07 | ABCW-DELISTED | Stock | 34.11 | 34.6 | 34.11 | 34.58 | 2490.0 |
| 2015-04-07 | ABDC-DELISTED | Stock | 13.64 | 13.81 | 13.56 | 13.79 | 69855.0 |
| 2015-04-07 | ABE-DELISTED | Stock | 13.01 | 13.02 | 12.84 | 12.99 | 27748.0 |
| 2015-04-07 | ABEO | Stock | 80.5 | 80.75 | 78.75 | 79.5 | 916.0 |
| 2015-04-07 | ABEV | Stock | 6.19 | 6.29 | 6.16 | 6.23 | 14887300.0 |
| 2015-04-07 | ABG | Stock | 85.15 | 85.72 | 84.46 | 84.81 | 288700.0 |
| 2015-04-07 | ABGB-DELISTED | Stock | 18.65 | 18.65 | 17.714 | 18.26 | 847479.0 |
| 2015-04-07 | ABIL-DELISTED | Stock | 10.06 | 10.06 | 10.06 | 10.06 | 280.0 |
| 2015-04-07 | ABM | Stock | 32.12 | 32.13 | 31.77 | 31.82 | 288600.0 |
> showing 50 of 6,613 rows — these rows as CSV