PREVIEW / stock_5min / 2018-03-01
file: by_date/stock_5min/2018/2018-03-01.parquet size: 5.7 MB rows: 369,231 symbols: 2,878
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-03-01 04:00:00 | AAPL | Stock | 44.8425 | 44.8425 | 44.8425 | 44.8425 | 2584.0 |
| 2018-03-01 04:10:00 | AAPL | Stock | 44.6375 | 44.65 | 44.6375 | 44.65 | 1600.0 |
| 2018-03-01 04:15:00 | AAPL | Stock | 44.63 | 44.63 | 44.63 | 44.63 | 400.0 |
| 2018-03-01 04:25:00 | AAPL | Stock | 44.6875 | 44.6875 | 44.6875 | 44.6875 | 1440.0 |
| 2018-03-01 04:40:00 | AAPL | Stock | 44.5875 | 44.5875 | 44.525 | 44.525 | 2000.0 |
| 2018-03-01 04:50:00 | AAPL | Stock | 44.525 | 44.525 | 44.5 | 44.5 | 8532.0 |
| 2018-03-01 04:55:00 | AAPL | Stock | 44.5 | 44.5 | 44.5 | 44.5 | 400.0 |
| 2018-03-01 05:00:00 | AAPL | Stock | 44.5325 | 44.565 | 44.5 | 44.565 | 26200.0 |
| 2018-03-01 05:05:00 | AAPL | Stock | 44.57 | 44.57 | 44.57 | 44.57 | 800.0 |
| 2018-03-01 05:10:00 | AAPL | Stock | 44.56 | 44.6225 | 44.5375 | 44.6125 | 16424.0 |
| 2018-03-01 05:20:00 | AAPL | Stock | 44.55 | 44.55 | 44.48 | 44.48 | 12344.0 |
| 2018-03-01 05:25:00 | AAPL | Stock | 44.505 | 44.51 | 44.475 | 44.475 | 25436.0 |
| 2018-03-01 05:30:00 | AAPL | Stock | 44.4725 | 44.475 | 44.4725 | 44.475 | 11368.0 |
| 2018-03-01 05:35:00 | AAPL | Stock | 44.45 | 44.475 | 44.45 | 44.475 | 10000.0 |
| 2018-03-01 05:40:00 | AAPL | Stock | 44.4875 | 44.4875 | 44.475 | 44.475 | 5320.0 |
| 2018-03-01 05:50:00 | AAPL | Stock | 44.525 | 44.525 | 44.525 | 44.525 | 400.0 |
| 2018-03-01 05:55:00 | AAPL | Stock | 44.5025 | 44.5025 | 44.475 | 44.475 | 7584.0 |
| 2018-03-01 06:00:00 | AAPL | Stock | 44.475 | 44.5 | 44.475 | 44.5 | 10000.0 |
| 2018-03-01 06:05:00 | AAPL | Stock | 44.535 | 44.535 | 44.535 | 44.535 | 1600.0 |
| 2018-03-01 06:25:00 | AAPL | Stock | 44.5 | 44.5 | 44.5 | 44.5 | 1600.0 |
| 2018-03-01 06:30:00 | AAPL | Stock | 44.495 | 44.495 | 44.495 | 44.495 | 800.0 |
| 2018-03-01 06:35:00 | AAPL | Stock | 44.4775 | 44.4775 | 44.445 | 44.445 | 3196.0 |
| 2018-03-01 06:45:00 | AAPL | Stock | 44.4425 | 44.4425 | 44.3875 | 44.3875 | 4400.0 |
| 2018-03-01 06:50:00 | AAPL | Stock | 44.3875 | 44.3875 | 44.275 | 44.3 | 13800.0 |
| 2018-03-01 06:55:00 | AAPL | Stock | 44.3425 | 44.3425 | 44.32 | 44.32 | 800.0 |
| 2018-03-01 07:00:00 | AAPL | Stock | 44.35 | 44.3875 | 44.325 | 44.325 | 10968.0 |
| 2018-03-01 07:05:00 | AAPL | Stock | 44.325 | 44.35 | 44.325 | 44.35 | 7200.0 |
| 2018-03-01 07:10:00 | AAPL | Stock | 44.35 | 44.3775 | 44.35 | 44.3625 | 38312.0 |
| 2018-03-01 07:15:00 | AAPL | Stock | 44.3875 | 44.425 | 44.3875 | 44.425 | 8880.0 |
| 2018-03-01 07:20:00 | AAPL | Stock | 44.425 | 44.4275 | 44.4 | 44.4 | 26888.0 |
| 2018-03-01 07:25:00 | AAPL | Stock | 44.4 | 44.4025 | 44.375 | 44.4025 | 17848.0 |
| 2018-03-01 07:30:00 | AAPL | Stock | 44.4025 | 44.45 | 44.4025 | 44.4275 | 10240.0 |
| 2018-03-01 07:35:00 | AAPL | Stock | 44.4125 | 44.455 | 44.4125 | 44.4525 | 33096.0 |
| 2018-03-01 07:40:00 | AAPL | Stock | 44.45 | 44.45 | 44.3975 | 44.43 | 54716.0 |
| 2018-03-01 07:45:00 | AAPL | Stock | 44.43 | 44.4475 | 44.425 | 44.425 | 29756.0 |
| 2018-03-01 07:50:00 | AAPL | Stock | 44.42 | 44.425 | 44.42 | 44.425 | 9084.0 |
| 2018-03-01 07:55:00 | AAPL | Stock | 44.425 | 44.425 | 44.4 | 44.4125 | 29560.0 |
| 2018-03-01 08:00:00 | AAPL | Stock | 44.3875 | 44.475 | 44.325 | 44.4425 | 141612.0 |
| 2018-03-01 08:05:00 | AAPL | Stock | 44.4375 | 44.4625 | 44.4125 | 44.4625 | 16400.0 |
| 2018-03-01 08:10:00 | AAPL | Stock | 44.4625 | 44.4825 | 44.4275 | 44.4825 | 15012.0 |
| 2018-03-01 08:15:00 | AAPL | Stock | 44.4825 | 44.4875 | 44.455 | 44.455 | 4800.0 |
| 2018-03-01 08:20:00 | AAPL | Stock | 44.4625 | 44.4625 | 44.4625 | 44.4625 | 13540.0 |
| 2018-03-01 08:25:00 | AAPL | Stock | 44.4575 | 44.4875 | 44.4525 | 44.4875 | 55596.0 |
| 2018-03-01 08:30:00 | AAPL | Stock | 44.475 | 44.55 | 44.475 | 44.5275 | 42880.0 |
| 2018-03-01 08:35:00 | AAPL | Stock | 44.5375 | 44.6125 | 44.5375 | 44.6125 | 37908.0 |
| 2018-03-01 08:40:00 | AAPL | Stock | 44.61 | 44.67 | 44.575 | 44.62 | 114964.0 |
| 2018-03-01 08:45:00 | AAPL | Stock | 44.655 | 44.72 | 44.64 | 44.7125 | 64532.0 |
| 2018-03-01 08:50:00 | AAPL | Stock | 44.7 | 44.725 | 44.6925 | 44.7025 | 79084.0 |
| 2018-03-01 08:55:00 | AAPL | Stock | 44.725 | 44.7325 | 44.6775 | 44.6775 | 45128.0 |
| 2018-03-01 09:00:00 | AAPL | Stock | 44.69 | 44.7225 | 44.68 | 44.68 | 37088.0 |
> showing 50 of 369,231 rows — these rows as CSV