PREVIEW / stock_5min / 2016-06-30
file: by_date/stock_5min/2016/2016-06-30.parquet size: 5.5 MB rows: 367,464 symbols: 3,306
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-06-30 04:05:00 | AAPL | Stock | 23.5875 | 23.5875 | 23.5875 | 23.5875 | 1000.0 |
| 2016-06-30 04:50:00 | AAPL | Stock | 23.5875 | 23.5875 | 23.5875 | 23.5875 | 1120.0 |
| 2016-06-30 05:15:00 | AAPL | Stock | 23.5875 | 23.5875 | 23.5875 | 23.5875 | 1188.0 |
| 2016-06-30 05:40:00 | AAPL | Stock | 23.5875 | 23.5875 | 23.5875 | 23.5875 | 8000.0 |
| 2016-06-30 06:40:00 | AAPL | Stock | 23.6 | 23.6 | 23.6 | 23.6 | 844.0 |
| 2016-06-30 06:45:00 | AAPL | Stock | 23.6 | 23.6 | 23.5975 | 23.6 | 1712.0 |
| 2016-06-30 06:55:00 | AAPL | Stock | 23.6 | 23.6 | 23.6 | 23.6 | 468.0 |
| 2016-06-30 07:00:00 | AAPL | Stock | 23.585 | 23.585 | 23.585 | 23.585 | 800.0 |
| 2016-06-30 07:05:00 | AAPL | Stock | 23.585 | 23.585 | 23.585 | 23.585 | 1200.0 |
| 2016-06-30 07:10:00 | AAPL | Stock | 23.5825 | 23.5825 | 23.5825 | 23.5825 | 400.0 |
| 2016-06-30 07:15:00 | AAPL | Stock | 23.5825 | 23.5825 | 23.58 | 23.58 | 2760.0 |
| 2016-06-30 07:20:00 | AAPL | Stock | 23.575 | 23.5875 | 23.575 | 23.5875 | 12000.0 |
| 2016-06-30 07:35:00 | AAPL | Stock | 23.575 | 23.575 | 23.575 | 23.575 | 1760.0 |
| 2016-06-30 07:40:00 | AAPL | Stock | 23.58 | 23.58 | 23.575 | 23.575 | 2668.0 |
| 2016-06-30 07:45:00 | AAPL | Stock | 23.575 | 23.575 | 23.565 | 23.565 | 4912.0 |
| 2016-06-30 07:55:00 | AAPL | Stock | 23.55 | 23.55 | 23.525 | 23.525 | 4164.0 |
| 2016-06-30 08:00:00 | AAPL | Stock | 23.575 | 23.585 | 23.5125 | 23.5175 | 22704.0 |
| 2016-06-30 08:05:00 | AAPL | Stock | 23.5175 | 23.535 | 23.5125 | 23.5125 | 36616.0 |
| 2016-06-30 08:10:00 | AAPL | Stock | 23.5125 | 23.5225 | 23.5 | 23.5 | 35244.0 |
| 2016-06-30 08:15:00 | AAPL | Stock | 23.51 | 23.525 | 23.51 | 23.525 | 14028.0 |
| 2016-06-30 08:20:00 | AAPL | Stock | 23.53 | 23.53 | 23.525 | 23.525 | 2400.0 |
| 2016-06-30 08:25:00 | AAPL | Stock | 23.525 | 23.525 | 23.515 | 23.5225 | 14540.0 |
| 2016-06-30 08:30:00 | AAPL | Stock | 23.5225 | 23.545 | 23.5225 | 23.5275 | 14596.0 |
| 2016-06-30 08:35:00 | AAPL | Stock | 23.5225 | 23.525 | 23.5225 | 23.5225 | 8800.0 |
| 2016-06-30 08:40:00 | AAPL | Stock | 23.525 | 23.525 | 23.52 | 23.525 | 6800.0 |
| 2016-06-30 08:45:00 | AAPL | Stock | 23.5325 | 23.5425 | 23.5325 | 23.54 | 26320.0 |
| 2016-06-30 08:50:00 | AAPL | Stock | 23.55 | 23.5525 | 23.55 | 23.5525 | 9388.0 |
| 2016-06-30 08:55:00 | AAPL | Stock | 23.5625 | 23.5625 | 23.5525 | 23.5525 | 10280.0 |
| 2016-06-30 09:00:00 | AAPL | Stock | 23.5425 | 23.5625 | 23.5425 | 23.5625 | 3252.0 |
| 2016-06-30 09:05:00 | AAPL | Stock | 23.55 | 23.55 | 23.5375 | 23.5375 | 11352.0 |
| 2016-06-30 09:10:00 | AAPL | Stock | 23.545 | 23.57 | 23.545 | 23.57 | 22464.0 |
| 2016-06-30 09:15:00 | AAPL | Stock | 23.5725 | 23.575 | 23.56 | 23.56 | 19200.0 |
| 2016-06-30 09:20:00 | AAPL | Stock | 23.55 | 23.555 | 23.55 | 23.555 | 2608.0 |
| 2016-06-30 09:25:00 | AAPL | Stock | 23.5625 | 23.6125 | 23.5625 | 23.6125 | 121172.0 |
| 2016-06-30 09:30:00 | AAPL | Stock | 23.6125 | 23.685 | 23.575 | 23.6825 | 4832936.0 |
| 2016-06-30 09:35:00 | AAPL | Stock | 23.6838 | 23.7025 | 23.6375 | 23.6525 | 2972648.0 |
| 2016-06-30 09:40:00 | AAPL | Stock | 23.6525 | 23.6775 | 23.6425 | 23.6675 | 2186512.0 |
| 2016-06-30 09:45:00 | AAPL | Stock | 23.6675 | 23.675 | 23.6325 | 23.6425 | 2225788.0 |
| 2016-06-30 09:50:00 | AAPL | Stock | 23.6475 | 23.6525 | 23.605 | 23.6075 | 2136388.0 |
| 2016-06-30 09:55:00 | AAPL | Stock | 23.61 | 23.6425 | 23.6062 | 23.63 | 1830152.0 |
| 2016-06-30 10:00:00 | AAPL | Stock | 23.631 | 23.645 | 23.6175 | 23.6245 | 1189116.0 |
| 2016-06-30 10:05:00 | AAPL | Stock | 23.6225 | 23.67 | 23.5925 | 23.6675 | 2231920.0 |
| 2016-06-30 10:10:00 | AAPL | Stock | 23.67 | 23.6925 | 23.665 | 23.685 | 1837400.0 |
| 2016-06-30 10:15:00 | AAPL | Stock | 23.6875 | 23.7125 | 23.665 | 23.6715 | 1953708.0 |
| 2016-06-30 10:20:00 | AAPL | Stock | 23.6702 | 23.6875 | 23.6425 | 23.655 | 1002984.0 |
| 2016-06-30 10:25:00 | AAPL | Stock | 23.6565 | 23.665 | 23.6175 | 23.6275 | 1058192.0 |
| 2016-06-30 10:30:00 | AAPL | Stock | 23.6275 | 23.67 | 23.6262 | 23.6575 | 1334388.0 |
| 2016-06-30 10:35:00 | AAPL | Stock | 23.6575 | 23.675 | 23.6425 | 23.6675 | 988148.0 |
| 2016-06-30 10:40:00 | AAPL | Stock | 23.6675 | 23.6825 | 23.6375 | 23.67 | 1462756.0 |
| 2016-06-30 10:45:00 | AAPL | Stock | 23.67 | 23.71 | 23.6625 | 23.7075 | 1157272.0 |
> showing 50 of 367,464 rows — these rows as CSV