PREVIEW / stock_5min / 2018-09-13
file: by_date/stock_5min/2018/2018-09-13.parquet size: 5.6 MB rows: 354,117 symbols: 2,795
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 |
|---|---|---|---|---|---|---|---|
| 2018-09-13 04:00:00 | AAPL | Stock | 55.425 | 55.45 | 55.375 | 55.45 | 2420.0 |
| 2018-09-13 04:10:00 | AAPL | Stock | 55.4875 | 55.5 | 55.4875 | 55.5 | 9328.0 |
| 2018-09-13 04:15:00 | AAPL | Stock | 55.5 | 55.5 | 55.5 | 55.5 | 784.0 |
| 2018-09-13 04:35:00 | AAPL | Stock | 55.5 | 55.5 | 55.4975 | 55.4975 | 860.0 |
| 2018-09-13 04:45:00 | AAPL | Stock | 55.4375 | 55.4375 | 55.4375 | 55.4375 | 800.0 |
| 2018-09-13 04:50:00 | AAPL | Stock | 55.4625 | 55.4625 | 55.4625 | 55.4625 | 13200.0 |
| 2018-09-13 04:55:00 | AAPL | Stock | 55.4975 | 55.4975 | 55.4975 | 55.4975 | 800.0 |
| 2018-09-13 05:05:00 | AAPL | Stock | 55.4625 | 55.5 | 55.4625 | 55.4625 | 12076.0 |
| 2018-09-13 05:20:00 | AAPL | Stock | 55.5 | 55.5 | 55.425 | 55.425 | 10384.0 |
| 2018-09-13 05:25:00 | AAPL | Stock | 55.46 | 55.46 | 55.3875 | 55.3875 | 2680.0 |
| 2018-09-13 05:30:00 | AAPL | Stock | 55.375 | 55.38 | 55.25 | 55.25 | 47516.0 |
| 2018-09-13 05:35:00 | AAPL | Stock | 55.35 | 55.385 | 55.3325 | 55.35 | 19180.0 |
| 2018-09-13 05:40:00 | AAPL | Stock | 55.3375 | 55.3375 | 55.325 | 55.325 | 18672.0 |
| 2018-09-13 05:45:00 | AAPL | Stock | 55.35 | 55.35 | 55.325 | 55.325 | 11148.0 |
| 2018-09-13 05:50:00 | AAPL | Stock | 55.3225 | 55.325 | 55.3225 | 55.325 | 4396.0 |
| 2018-09-13 06:00:00 | AAPL | Stock | 55.375 | 55.4 | 55.375 | 55.4 | 2600.0 |
| 2018-09-13 06:05:00 | AAPL | Stock | 55.43 | 55.43 | 55.43 | 55.43 | 1920.0 |
| 2018-09-13 06:10:00 | AAPL | Stock | 55.4 | 55.4 | 55.4 | 55.4 | 800.0 |
| 2018-09-13 06:15:00 | AAPL | Stock | 55.435 | 55.46 | 55.43 | 55.4525 | 12072.0 |
| 2018-09-13 06:20:00 | AAPL | Stock | 55.4375 | 55.465 | 55.4375 | 55.465 | 5336.0 |
| 2018-09-13 06:25:00 | AAPL | Stock | 55.4925 | 55.4975 | 55.4925 | 55.4975 | 9152.0 |
| 2018-09-13 06:35:00 | AAPL | Stock | 55.525 | 55.53 | 55.525 | 55.525 | 2000.0 |
| 2018-09-13 06:40:00 | AAPL | Stock | 55.55 | 55.575 | 55.55 | 55.575 | 1492.0 |
| 2018-09-13 06:45:00 | AAPL | Stock | 55.5925 | 55.6 | 55.5925 | 55.5925 | 1256.0 |
| 2018-09-13 06:50:00 | AAPL | Stock | 55.575 | 55.625 | 55.565 | 55.625 | 23724.0 |
| 2018-09-13 06:55:00 | AAPL | Stock | 55.625 | 55.625 | 55.6175 | 55.6175 | 2320.0 |
| 2018-09-13 07:00:00 | AAPL | Stock | 55.5975 | 55.7325 | 55.575 | 55.675 | 60608.0 |
| 2018-09-13 07:05:00 | AAPL | Stock | 55.67 | 55.6725 | 55.6375 | 55.6375 | 8112.0 |
| 2018-09-13 07:10:00 | AAPL | Stock | 55.66 | 55.6925 | 55.6575 | 55.6925 | 25116.0 |
| 2018-09-13 07:15:00 | AAPL | Stock | 55.7 | 55.7 | 55.6575 | 55.6575 | 4000.0 |
| 2018-09-13 07:20:00 | AAPL | Stock | 55.6925 | 55.71 | 55.67 | 55.6975 | 14788.0 |
| 2018-09-13 07:25:00 | AAPL | Stock | 55.6625 | 55.675 | 55.625 | 55.625 | 29948.0 |
| 2018-09-13 07:30:00 | AAPL | Stock | 55.605 | 55.6125 | 55.59 | 55.6125 | 16632.0 |
| 2018-09-13 07:35:00 | AAPL | Stock | 55.6125 | 55.6325 | 55.59 | 55.6325 | 8472.0 |
| 2018-09-13 07:40:00 | AAPL | Stock | 55.6475 | 55.6825 | 55.6375 | 55.65 | 22840.0 |
| 2018-09-13 07:45:00 | AAPL | Stock | 55.675 | 55.72 | 55.675 | 55.7125 | 36328.0 |
| 2018-09-13 07:50:00 | AAPL | Stock | 55.7225 | 55.7325 | 55.6925 | 55.695 | 22852.0 |
| 2018-09-13 07:55:00 | AAPL | Stock | 55.71 | 55.735 | 55.6925 | 55.6925 | 38124.0 |
| 2018-09-13 08:00:00 | AAPL | Stock | 55.707 | 55.73 | 55.5675 | 55.66 | 200452.0 |
| 2018-09-13 08:05:00 | AAPL | Stock | 55.65 | 55.6825 | 55.625 | 55.6625 | 58152.0 |
| 2018-09-13 08:10:00 | AAPL | Stock | 55.6625 | 55.68 | 55.6525 | 55.6625 | 17176.0 |
| 2018-09-13 08:15:00 | AAPL | Stock | 55.6725 | 55.68 | 55.6625 | 55.6625 | 20708.0 |
| 2018-09-13 08:20:00 | AAPL | Stock | 55.67 | 55.7 | 55.65 | 55.6875 | 99664.0 |
| 2018-09-13 08:25:00 | AAPL | Stock | 55.6925 | 55.6925 | 55.6425 | 55.6575 | 11384.0 |
| 2018-09-13 08:30:00 | AAPL | Stock | 55.665 | 55.8625 | 55.625 | 55.825 | 254564.0 |
| 2018-09-13 08:35:00 | AAPL | Stock | 55.825 | 55.91 | 55.825 | 55.87 | 144172.0 |
| 2018-09-13 08:40:00 | AAPL | Stock | 55.87 | 55.87 | 55.8125 | 55.85 | 57364.0 |
| 2018-09-13 08:45:00 | AAPL | Stock | 55.85 | 55.875 | 55.8275 | 55.875 | 63216.0 |
| 2018-09-13 08:50:00 | AAPL | Stock | 55.875 | 55.91 | 55.8625 | 55.87 | 103752.0 |
| 2018-09-13 08:55:00 | AAPL | Stock | 55.8725 | 55.9 | 55.8375 | 55.85 | 63696.0 |
> showing 50 of 354,117 rows — these rows as CSV