PREVIEW / stock_5min / 2015-08-27
file: by_date/stock_5min/2015/2015-08-27.parquet size: 5.7 MB rows: 376,004 symbols: 3,485
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 |
|---|---|---|---|---|---|---|---|
| 2015-08-27 04:00:00 | AAPL | Stock | 27.5825 | 28.0975 | 27.5825 | 28.05 | 49696.0 |
| 2015-08-27 04:05:00 | AAPL | Stock | 28.005 | 28.05 | 28.0025 | 28.0025 | 8400.0 |
| 2015-08-27 04:10:00 | AAPL | Stock | 28.0125 | 28.0125 | 28.0 | 28.0 | 27560.0 |
| 2015-08-27 04:15:00 | AAPL | Stock | 28.0125 | 28.0125 | 27.9875 | 28.0125 | 13580.0 |
| 2015-08-27 04:20:00 | AAPL | Stock | 28.0125 | 28.0575 | 28.0125 | 28.0575 | 14380.0 |
| 2015-08-27 04:25:00 | AAPL | Stock | 28.0725 | 28.0725 | 28.0725 | 28.0725 | 800.0 |
| 2015-08-27 04:30:00 | AAPL | Stock | 28.0725 | 28.09 | 28.05 | 28.05 | 21200.0 |
| 2015-08-27 04:35:00 | AAPL | Stock | 28.0525 | 28.0625 | 28.0 | 28.0 | 13680.0 |
| 2015-08-27 04:40:00 | AAPL | Stock | 28.025 | 28.025 | 28.025 | 28.025 | 1600.0 |
| 2015-08-27 04:45:00 | AAPL | Stock | 28.0275 | 28.0275 | 28.0275 | 28.0275 | 1200.0 |
| 2015-08-27 04:50:00 | AAPL | Stock | 28.035 | 28.1 | 28.035 | 28.1 | 7988.0 |
| 2015-08-27 04:55:00 | AAPL | Stock | 28.12 | 28.12 | 28.075 | 28.08 | 5300.0 |
| 2015-08-27 05:00:00 | AAPL | Stock | 28.08 | 28.08 | 28.075 | 28.08 | 8200.0 |
| 2015-08-27 05:05:00 | AAPL | Stock | 28.08 | 28.08 | 28.0625 | 28.08 | 19244.0 |
| 2015-08-27 05:10:00 | AAPL | Stock | 28.11 | 28.1125 | 28.1 | 28.1 | 10780.0 |
| 2015-08-27 05:15:00 | AAPL | Stock | 28.085 | 28.1 | 28.085 | 28.1 | 8180.0 |
| 2015-08-27 05:20:00 | AAPL | Stock | 28.1 | 28.1 | 28.1 | 28.1 | 6308.0 |
| 2015-08-27 05:25:00 | AAPL | Stock | 28.0875 | 28.1 | 28.0875 | 28.1 | 5200.0 |
| 2015-08-27 05:30:00 | AAPL | Stock | 28.075 | 28.075 | 28.0625 | 28.0625 | 9000.0 |
| 2015-08-27 05:35:00 | AAPL | Stock | 28.0625 | 28.0625 | 28.05 | 28.05 | 10680.0 |
| 2015-08-27 05:40:00 | AAPL | Stock | 28.075 | 28.1 | 28.075 | 28.1 | 9724.0 |
| 2015-08-27 05:45:00 | AAPL | Stock | 28.0925 | 28.0925 | 28.0925 | 28.0925 | 400.0 |
| 2015-08-27 05:50:00 | AAPL | Stock | 28.0625 | 28.0625 | 28.025 | 28.05 | 8608.0 |
| 2015-08-27 05:55:00 | AAPL | Stock | 28.0275 | 28.075 | 28.0275 | 28.0725 | 1600.0 |
| 2015-08-27 06:00:00 | AAPL | Stock | 28.095 | 28.1 | 28.0875 | 28.1 | 16500.0 |
| 2015-08-27 06:05:00 | AAPL | Stock | 28.1 | 28.1 | 28.0775 | 28.1 | 36268.0 |
| 2015-08-27 06:10:00 | AAPL | Stock | 28.1 | 28.1 | 28.0875 | 28.1 | 10212.0 |
| 2015-08-27 06:15:00 | AAPL | Stock | 28.095 | 28.1 | 28.075 | 28.075 | 6560.0 |
| 2015-08-27 06:20:00 | AAPL | Stock | 28.075 | 28.075 | 28.0475 | 28.0475 | 5940.0 |
| 2015-08-27 06:25:00 | AAPL | Stock | 28.0375 | 28.05 | 28.0375 | 28.05 | 3352.0 |
| 2015-08-27 06:30:00 | AAPL | Stock | 28.05 | 28.0875 | 28.04 | 28.085 | 85180.0 |
| 2015-08-27 06:35:00 | AAPL | Stock | 28.0875 | 28.1 | 28.0375 | 28.1 | 99844.0 |
| 2015-08-27 06:40:00 | AAPL | Stock | 28.065 | 28.1125 | 28.05 | 28.1125 | 157528.0 |
| 2015-08-27 06:45:00 | AAPL | Stock | 28.1225 | 28.125 | 28.075 | 28.1 | 115852.0 |
| 2015-08-27 06:50:00 | AAPL | Stock | 28.12 | 28.125 | 28.0575 | 28.0775 | 233936.0 |
| 2015-08-27 06:55:00 | AAPL | Stock | 28.0775 | 28.0825 | 28.005 | 28.005 | 31924.0 |
| 2015-08-27 07:00:00 | AAPL | Stock | 28.01 | 28.0425 | 27.9975 | 28.0375 | 44472.0 |
| 2015-08-27 07:05:00 | AAPL | Stock | 28.0375 | 28.0375 | 27.995 | 28.025 | 18716.0 |
| 2015-08-27 07:10:00 | AAPL | Stock | 28.025 | 28.0425 | 28.025 | 28.0325 | 10420.0 |
| 2015-08-27 07:15:00 | AAPL | Stock | 28.0325 | 28.035 | 27.9875 | 28.01 | 66968.0 |
| 2015-08-27 07:20:00 | AAPL | Stock | 28.015 | 28.075 | 28.0125 | 28.0375 | 95992.0 |
| 2015-08-27 07:25:00 | AAPL | Stock | 28.0375 | 28.05 | 28.0 | 28.0025 | 69180.0 |
| 2015-08-27 07:30:00 | AAPL | Stock | 28.015 | 28.025 | 27.97 | 27.995 | 118960.0 |
| 2015-08-27 07:35:00 | AAPL | Stock | 27.9975 | 28.0125 | 27.99 | 28.0 | 9860.0 |
| 2015-08-27 07:40:00 | AAPL | Stock | 28.0 | 28.0375 | 27.9875 | 28.0225 | 137408.0 |
| 2015-08-27 07:45:00 | AAPL | Stock | 28.0025 | 28.0175 | 27.97 | 27.97 | 32584.0 |
| 2015-08-27 07:50:00 | AAPL | Stock | 27.9725 | 27.995 | 27.9425 | 27.945 | 35420.0 |
| 2015-08-27 07:55:00 | AAPL | Stock | 27.945 | 27.9525 | 27.9075 | 27.9075 | 53112.0 |
| 2015-08-27 08:00:00 | AAPL | Stock | 27.905 | 28.1 | 27.7825 | 28.0125 | 1003156.0 |
| 2015-08-27 08:05:00 | AAPL | Stock | 27.8225 | 27.84 | 27.8075 | 27.8282 | 165292.0 |
> showing 50 of 376,004 rows — these rows as CSV