PREVIEW / stock_30min / 2017-05-05
file: by_date/stock_30min/2017/2017-05-05.parquet size: 1.6 MB rows: 80,363 symbols: 3,045
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2017-05-05 04:00:00 | AAPL | Stock | 36.6325 | 36.6325 | 36.6325 | 36.6325 | 1648.0 |
| 2017-05-05 05:00:00 | AAPL | Stock | 36.68 | 36.7 | 36.68 | 36.7 | 4328.0 |
| 2017-05-05 06:30:00 | AAPL | Stock | 36.72 | 36.72 | 36.72 | 36.72 | 800.0 |
| 2017-05-05 07:00:00 | AAPL | Stock | 36.725 | 36.725 | 36.6875 | 36.6875 | 6120.0 |
| 2017-05-05 07:30:00 | AAPL | Stock | 36.6825 | 36.7 | 36.6625 | 36.665 | 9824.0 |
| 2017-05-05 08:00:00 | AAPL | Stock | 36.675 | 36.6925 | 36.6625 | 36.6925 | 13940.0 |
| 2017-05-05 08:30:00 | AAPL | Stock | 36.695 | 36.75 | 36.695 | 36.7125 | 148864.0 |
| 2017-05-05 09:00:00 | AAPL | Stock | 36.7225 | 36.7325 | 36.6875 | 36.7025 | 79600.0 |
| 2017-05-05 09:30:00 | AAPL | Stock | 36.69 | 36.955 | 36.69 | 36.91 | 16110892.0 |
| 2017-05-05 10:00:00 | AAPL | Stock | 36.9118 | 37.0 | 36.8975 | 36.9502 | 9646240.0 |
| 2017-05-05 10:30:00 | AAPL | Stock | 36.9522 | 36.975 | 36.88 | 36.949 | 5907592.0 |
| 2017-05-05 11:00:00 | AAPL | Stock | 36.9487 | 37.05 | 36.9425 | 37.0185 | 8684156.0 |
| 2017-05-05 11:30:00 | AAPL | Stock | 37.0185 | 37.169 | 37.0 | 37.165 | 7441000.0 |
| 2017-05-05 12:00:00 | AAPL | Stock | 37.1665 | 37.2275 | 37.12 | 37.121 | 8365904.0 |
| 2017-05-05 12:30:00 | AAPL | Stock | 37.1213 | 37.175 | 37.09 | 37.1325 | 5041128.0 |
| 2017-05-05 13:00:00 | AAPL | Stock | 37.13 | 37.17 | 37.125 | 37.1425 | 2902376.0 |
| 2017-05-05 13:30:00 | AAPL | Stock | 37.1438 | 37.175 | 37.12 | 37.1625 | 2926220.0 |
| 2017-05-05 14:00:00 | AAPL | Stock | 37.165 | 37.2 | 37.155 | 37.17 | 3608740.0 |
| 2017-05-05 14:30:00 | AAPL | Stock | 37.17 | 37.185 | 37.1475 | 37.155 | 3370912.0 |
| 2017-05-05 15:00:00 | AAPL | Stock | 37.155 | 37.165 | 37.13 | 37.1325 | 4214316.0 |
| 2017-05-05 15:30:00 | AAPL | Stock | 37.1325 | 37.245 | 37.125 | 37.24 | 12477776.0 |
| 2017-05-05 16:00:00 | AAPL | Stock | 37.24 | 37.2625 | 37.0492 | 37.25 | 6335940.0 |
| 2017-05-05 16:30:00 | AAPL | Stock | 37.25 | 37.2625 | 37.24 | 37.255 | 482940.0 |
| 2017-05-05 17:00:00 | AAPL | Stock | 37.255 | 37.255 | 37.245 | 37.25 | 47352.0 |
| 2017-05-05 17:30:00 | AAPL | Stock | 37.25 | 37.25 | 37.2425 | 37.25 | 16720.0 |
| 2017-05-05 18:00:00 | AAPL | Stock | 37.25 | 37.2525 | 37.245 | 37.25 | 23608.0 |
| 2017-05-05 18:30:00 | AAPL | Stock | 37.25 | 37.26 | 37.25 | 37.25 | 12628.0 |
| 2017-05-05 19:00:00 | AAPL | Stock | 37.2575 | 37.26 | 37.245 | 37.245 | 30224.0 |
| 2017-05-05 19:30:00 | AAPL | Stock | 37.2525 | 37.2625 | 37.2425 | 37.2625 | 19540.0 |
| 2017-05-05 08:00:00 | MSFT | Stock | 68.8 | 68.88 | 68.8 | 68.88 | 600.0 |
| 2017-05-05 08:30:00 | MSFT | Stock | 68.98 | 68.98 | 68.89 | 68.97 | 899.0 |
| 2017-05-05 09:00:00 | MSFT | Stock | 68.9 | 69.0 | 68.88 | 68.9 | 8874.0 |
| 2017-05-05 09:30:00 | MSFT | Stock | 68.9 | 68.94 | 68.65 | 68.79 | 2597925.0 |
| 2017-05-05 10:00:00 | MSFT | Stock | 68.795 | 68.87 | 68.64 | 68.666 | 1258559.0 |
| 2017-05-05 10:30:00 | MSFT | Stock | 68.67 | 68.77 | 68.6 | 68.645 | 1400583.0 |
| 2017-05-05 11:00:00 | MSFT | Stock | 68.65 | 68.7 | 68.58 | 68.605 | 829270.0 |
| 2017-05-05 11:30:00 | MSFT | Stock | 68.61 | 68.68 | 68.485 | 68.62 | 1315933.0 |
| 2017-05-05 12:00:00 | MSFT | Stock | 68.62 | 68.74 | 68.615 | 68.725 | 898667.0 |
| 2017-05-05 12:30:00 | MSFT | Stock | 68.725 | 68.82 | 68.66 | 68.805 | 629145.0 |
| 2017-05-05 13:00:00 | MSFT | Stock | 68.805 | 68.88 | 68.755 | 68.86 | 851293.0 |
| 2017-05-05 13:30:00 | MSFT | Stock | 68.85 | 69.0 | 68.835 | 69.0 | 602295.0 |
| 2017-05-05 14:00:00 | MSFT | Stock | 68.995 | 69.03 | 68.76 | 68.815 | 1023585.0 |
| 2017-05-05 14:30:00 | MSFT | Stock | 68.81 | 68.83 | 68.74 | 68.755 | 750558.0 |
| 2017-05-05 15:00:00 | MSFT | Stock | 68.755 | 68.8 | 68.71 | 68.775 | 634843.0 |
| 2017-05-05 15:30:00 | MSFT | Stock | 68.78 | 69.01 | 68.76 | 68.99 | 2852315.0 |
| 2017-05-05 16:00:00 | MSFT | Stock | 69.0 | 69.0 | 68.685 | 68.99 | 1892921.0 |
| 2017-05-05 16:30:00 | MSFT | Stock | 69.0 | 69.02 | 68.99 | 69.01 | 3650.0 |
| 2017-05-05 17:00:00 | MSFT | Stock | 69.0 | 69.02 | 69.0 | 69.02 | 6241.0 |
| 2017-05-05 17:30:00 | MSFT | Stock | 69.0 | 69.0 | 69.0 | 69.0 | 1761.0 |
| 2017-05-05 18:30:00 | MSFT | Stock | 69.02 | 69.14 | 69.02 | 69.14 | 2522.0 |
> showing 50 of 80,363 rows — these rows as CSV