PREVIEW / stock_30min / 2016-07-15
file: by_date/stock_30min/2016/2016-07-15.parquet size: 1.6 MB rows: 82,270 symbols: 3,279
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 |
|---|---|---|---|---|---|---|---|
| 2016-07-15 04:00:00 | AAPL | Stock | 24.6825 | 24.6825 | 24.6825 | 24.6825 | 820.0 |
| 2016-07-15 04:30:00 | AAPL | Stock | 24.6975 | 24.7 | 24.6975 | 24.7 | 1600.0 |
| 2016-07-15 05:00:00 | AAPL | Stock | 24.7 | 24.7025 | 24.7 | 24.7025 | 1600.0 |
| 2016-07-15 05:30:00 | AAPL | Stock | 24.6975 | 24.6975 | 24.6975 | 24.6975 | 400.0 |
| 2016-07-15 06:30:00 | AAPL | Stock | 24.6625 | 24.675 | 24.6625 | 24.675 | 6492.0 |
| 2016-07-15 07:00:00 | AAPL | Stock | 24.65 | 24.6725 | 24.6325 | 24.6725 | 8260.0 |
| 2016-07-15 07:30:00 | AAPL | Stock | 24.6725 | 24.6725 | 24.65 | 24.67 | 7976.0 |
| 2016-07-15 08:00:00 | AAPL | Stock | 24.65 | 24.675 | 24.6325 | 24.65 | 60732.0 |
| 2016-07-15 08:30:00 | AAPL | Stock | 24.65 | 24.67 | 24.625 | 24.6475 | 79440.0 |
| 2016-07-15 09:00:00 | AAPL | Stock | 24.6375 | 24.7825 | 24.6375 | 24.7625 | 3130892.0 |
| 2016-07-15 09:30:00 | AAPL | Stock | 24.7525 | 24.825 | 24.6775 | 24.735 | 29344360.0 |
| 2016-07-15 10:00:00 | AAPL | Stock | 24.7375 | 24.7475 | 24.6875 | 24.74 | 9091568.0 |
| 2016-07-15 10:30:00 | AAPL | Stock | 24.739 | 24.7425 | 24.705 | 24.725 | 5319960.0 |
| 2016-07-15 11:00:00 | AAPL | Stock | 24.7275 | 24.7475 | 24.7087 | 24.7375 | 6094808.0 |
| 2016-07-15 11:30:00 | AAPL | Stock | 24.74 | 24.7475 | 24.6525 | 24.6562 | 6006644.0 |
| 2016-07-15 12:00:00 | AAPL | Stock | 24.6552 | 24.6875 | 24.625 | 24.6825 | 6009596.0 |
| 2016-07-15 12:30:00 | AAPL | Stock | 24.6828 | 24.6925 | 24.6562 | 24.685 | 4002544.0 |
| 2016-07-15 13:00:00 | AAPL | Stock | 24.685 | 24.735 | 24.6825 | 24.7225 | 4312216.0 |
| 2016-07-15 13:30:00 | AAPL | Stock | 24.7225 | 24.7325 | 24.715 | 24.73 | 3315660.0 |
| 2016-07-15 14:00:00 | AAPL | Stock | 24.73 | 24.745 | 24.67 | 24.6725 | 3763308.0 |
| 2016-07-15 14:30:00 | AAPL | Stock | 24.6725 | 24.705 | 24.6485 | 24.6912 | 5440952.0 |
| 2016-07-15 15:00:00 | AAPL | Stock | 24.6925 | 24.72 | 24.6675 | 24.6968 | 8386548.0 |
| 2016-07-15 15:30:00 | AAPL | Stock | 24.6953 | 24.7025 | 24.6725 | 24.69 | 10793404.0 |
| 2016-07-15 16:00:00 | AAPL | Stock | 24.69 | 24.695 | 24.655 | 24.655 | 7614136.0 |
| 2016-07-15 16:30:00 | AAPL | Stock | 24.67 | 24.695 | 24.6175 | 24.6325 | 248164.0 |
| 2016-07-15 17:00:00 | AAPL | Stock | 24.64 | 24.6525 | 24.62 | 24.62 | 77020.0 |
| 2016-07-15 17:30:00 | AAPL | Stock | 24.62 | 24.635 | 24.6125 | 24.625 | 71964.0 |
| 2016-07-15 18:00:00 | AAPL | Stock | 24.615 | 24.6175 | 24.6 | 24.6175 | 77648.0 |
| 2016-07-15 18:30:00 | AAPL | Stock | 24.6025 | 24.62 | 24.6 | 24.62 | 34136.0 |
| 2016-07-15 19:00:00 | AAPL | Stock | 24.6025 | 24.6225 | 24.595 | 24.595 | 82336.0 |
| 2016-07-15 19:30:00 | AAPL | Stock | 24.5975 | 24.6575 | 24.5975 | 24.6375 | 35272.0 |
| 2016-07-15 06:30:00 | MSFT | Stock | 53.9 | 53.98 | 53.85 | 53.98 | 2833.0 |
| 2016-07-15 07:00:00 | MSFT | Stock | 53.74 | 53.74 | 53.71 | 53.72 | 700.0 |
| 2016-07-15 07:30:00 | MSFT | Stock | 53.8 | 53.85 | 53.8 | 53.85 | 500.0 |
| 2016-07-15 08:00:00 | MSFT | Stock | 53.74 | 53.74 | 53.74 | 53.74 | 100.0 |
| 2016-07-15 08:30:00 | MSFT | Stock | 53.75 | 53.86 | 53.75 | 53.86 | 1406.0 |
| 2016-07-15 09:00:00 | MSFT | Stock | 53.85 | 54.0 | 53.8 | 53.87 | 660043.0 |
| 2016-07-15 09:30:00 | MSFT | Stock | 53.87 | 54.0 | 53.59 | 53.686 | 5826904.0 |
| 2016-07-15 10:00:00 | MSFT | Stock | 53.69 | 53.71 | 53.52 | 53.54 | 1802079.0 |
| 2016-07-15 10:30:00 | MSFT | Stock | 53.54 | 53.55 | 53.43 | 53.49 | 1476254.0 |
| 2016-07-15 11:00:00 | MSFT | Stock | 53.5 | 53.52 | 53.34 | 53.46 | 1434034.0 |
| 2016-07-15 11:30:00 | MSFT | Stock | 53.465 | 53.52 | 53.35 | 53.395 | 1152469.0 |
| 2016-07-15 12:00:00 | MSFT | Stock | 53.39 | 53.4 | 53.21 | 53.3 | 2034699.0 |
| 2016-07-15 12:30:00 | MSFT | Stock | 53.3 | 53.35 | 53.21 | 53.33 | 1550560.0 |
| 2016-07-15 13:00:00 | MSFT | Stock | 53.322 | 53.53 | 53.32 | 53.49 | 1089463.0 |
| 2016-07-15 13:30:00 | MSFT | Stock | 53.49 | 53.55 | 53.43 | 53.45 | 1014523.0 |
| 2016-07-15 14:00:00 | MSFT | Stock | 53.45 | 53.5 | 53.42 | 53.454 | 1403400.0 |
| 2016-07-15 14:30:00 | MSFT | Stock | 53.47 | 53.56 | 53.47 | 53.54 | 1168836.0 |
| 2016-07-15 15:00:00 | MSFT | Stock | 53.535 | 53.65 | 53.535 | 53.63 | 1642294.0 |
| 2016-07-15 15:30:00 | MSFT | Stock | 53.62 | 53.71 | 53.57 | 53.69 | 3951889.0 |
> showing 50 of 82,270 rows — these rows as CSV