PREVIEW / stock_daily / 2015-05-01
file: by_date/stock_daily/2015/2015-05-01.parquet size: 222 KB rows: 6,648 symbols: 3,513
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-05-01 | AAPL | Stock | 31.525 | 32.5325 | 31.325 | 32.2375 | 234050400.0 |
| 2015-05-01 | MSFT | Stock | 48.58 | 48.88 | 48.4 | 48.66 | 38937300.0 |
| 2015-05-01 | NVDA | Stock | 0.5595 | 0.5705 | 0.557 | 0.5688 | 256968000.0 |
| 2015-05-01 | AMZN | Stock | 21.191 | 21.282 | 20.8 | 21.1435 | 71316000.0 |
| 2015-05-01 | GOOGL | Stock | 27.5255 | 27.561 | 27.1925 | 27.558 | 36571320.0 |
| 2015-05-01 | META | Stock | 79.24 | 79.76 | 78.11 | 78.99 | 24136400.0 |
| 2015-05-01 | TSLA | Stock | 15.3293 | 15.4513 | 14.694 | 15.0687 | 79225500.0 |
| 2015-05-01 | TLT | Stock | 124.73 | 125.04 | 123.69 | 124.0 | 12378465.0 |
| 2015-05-01 | ES | Stock | 48.76 | 49.04 | 48.32 | 48.89 | 1328700.0 |
| 2015-05-01 | CL | Stock | 67.28 | 67.7 | 66.9 | 67.68 | 3135600.0 |
| 2015-05-01 | A | Stock | 41.41 | 41.93 | 41.24 | 41.83 | 1880200.0 |
| 2015-05-01 | AA.B-DELISTED | Stock | 45.85 | 47.58 | 45.85 | 47.33 | 471318.0 |
| 2015-05-01 | AABA-DELISTED | Stock | 42.55 | 42.6801 | 42.09 | 42.505 | 9559407.0 |
| 2015-05-01 | AAC-DELISTED | Stock | 34.81 | 34.81 | 32.5 | 34.5 | 167254.0 |
| 2015-05-01 | AACG | Stock | 4.33 | 4.48 | 4.33 | 4.42 | 2800.0 |
| 2015-05-01 | AAIC-DELISTED | Stock | 21.68 | 21.72 | 21.45 | 21.57 | 515846.0 |
| 2015-05-01 | AAL | Stock | 48.65 | 49.83 | 48.51 | 49.39 | 8084600.0 |
| 2015-05-01 | AAMC-DELISTED | Stock | 67.7676 | 67.7676 | 66.1794 | 66.1794 | 9340.0 |
| 2015-05-01 | AAMI | Stock | 19.35 | 19.56 | 19.11 | 19.43 | 73600.0 |
| 2015-05-01 | AAOI | Stock | 14.09 | 14.43 | 13.42 | 13.61 | 395400.0 |
| 2015-05-01 | AAON | Stock | 16.0133 | 16.2067 | 15.7067 | 16.1 | 148050.0 |
| 2015-05-01 | AAP | Stock | 143.09 | 145.46 | 142.63 | 145.34 | 596300.0 |
| 2015-05-01 | AAT | Stock | 39.78 | 40.37 | 39.7 | 40.28 | 127800.0 |
| 2015-05-01 | AAU-DELISTED | Stock | 0.8 | 0.8 | 0.761 | 0.79 | 76051.0 |
| 2015-05-01 | AAUAF-DELISTED | Stock | 0.8 | 0.81 | 0.78 | 0.785 | 76327.0 |
| 2015-05-01 | AAV-DELISTED | Stock | 6.17 | 6.25 | 6.08 | 6.125 | 86298.0 |
| 2015-05-01 | AAVL-DELISTED | Stock | 32.27 | 33.65 | 31.81 | 33.135 | 236091.0 |
| 2015-05-01 | AAWW-DELISTED | Stock | 48.88 | 52.735 | 48.82 | 51.95 | 1348173.0 |
| 2015-05-01 | AAXJ | Stock | 68.33 | 68.635 | 68.13 | 68.51 | 659347.0 |
| 2015-05-01 | AAXN-DELISTED | Stock | 30.5 | 33.23 | 30.5 | 32.37 | 6445780.0 |
| 2015-05-01 | AB | Stock | 31.47 | 32.24 | 31.23 | 32.05 | 421200.0 |
| 2015-05-01 | ABAC-DELISTED | Stock | 1.67 | 1.67 | 1.65 | 1.65 | 1500.0 |
| 2015-05-01 | ABAX-DELISTED | Stock | 62.0 | 62.86 | 55.0 | 55.5 | 1068972.0 |
| 2015-05-01 | ABB-DELISTED | Stock | 22.03 | 22.03 | 21.8 | 21.95 | 1457064.0 |
| 2015-05-01 | ABBNY-DELISTED | Stock | 22.03 | 22.03 | 21.8 | 21.94 | 1507759.0 |
| 2015-05-01 | ABBV | Stock | 65.09 | 65.5 | 63.88 | 64.32 | 9870800.0 |
| 2015-05-01 | ABC-DELISTED | Stock | 115.12 | 115.32 | 113.83 | 114.57 | 2558916.0 |
| 2015-05-01 | ABCB | Stock | 25.0 | 25.33 | 24.64 | 24.73 | 164700.0 |
| 2015-05-01 | ABCD-DELISTED | Stock | 2.91 | 3.05 | 2.91 | 2.95 | 10157.0 |
| 2015-05-01 | ABCO-DELISTED | Stock | 51.95 | 52.75 | 50.86 | 51.29 | 181639.0 |
| 2015-05-01 | ABCW-DELISTED | Stock | 36.28 | 36.46 | 34.92 | 36.0 | 18190.0 |
| 2015-05-01 | ABDC-DELISTED | Stock | 13.85 | 14.0 | 13.79 | 13.83 | 28126.0 |
| 2015-05-01 | ABE-DELISTED | Stock | 13.16 | 13.28 | 13.04 | 13.16 | 21959.0 |
| 2015-05-01 | ABEO | Stock | 69.75 | 72.75 | 68.75 | 70.75 | 5256.0 |
| 2015-05-01 | ABEOW-DELISTED | Stock | 1.28 | 1.28 | 1.28 | 1.28 | 100.0 |
| 2015-05-01 | ABEV | Stock | 6.34 | 6.35 | 6.24 | 6.31 | 4608300.0 |
| 2015-05-01 | ABG | Stock | 84.08 | 85.69 | 84.08 | 84.97 | 344800.0 |
| 2015-05-01 | ABGB-DELISTED | Stock | 16.21 | 16.21 | 15.97 | 16.21 | 9881.0 |
| 2015-05-01 | ABM | Stock | 32.16 | 32.32 | 32.04 | 32.17 | 292800.0 |
| 2015-05-01 | ABMD-DELISTED | Stock | 63.25 | 64.6 | 63.25 | 63.77 | 407564.0 |
> showing 50 of 6,648 rows — these rows as CSV