PREVIEW / stock_5min / 2020-08-17
file: by_date/stock_5min/2020/2020-08-17.parquet size: 6.5 MB rows: 409,051 symbols: 2,442
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 |
|---|---|---|---|---|---|---|---|
| 2020-08-17 04:00:00 | AAPL | Stock | 115.6 | 115.6 | 115.5 | 115.5 | 4336.0 |
| 2020-08-17 04:05:00 | AAPL | Stock | 115.45 | 115.59 | 115.45 | 115.5375 | 5400.0 |
| 2020-08-17 04:15:00 | AAPL | Stock | 115.5 | 115.5 | 115.5 | 115.5 | 400.0 |
| 2020-08-17 04:25:00 | AAPL | Stock | 115.5025 | 115.5025 | 115.5025 | 115.5025 | 400.0 |
| 2020-08-17 04:30:00 | AAPL | Stock | 115.4825 | 115.535 | 115.45 | 115.535 | 1692.0 |
| 2020-08-17 04:35:00 | AAPL | Stock | 115.5225 | 115.5225 | 115.5225 | 115.5225 | 400.0 |
| 2020-08-17 04:40:00 | AAPL | Stock | 115.55 | 115.55 | 115.5025 | 115.5025 | 996.0 |
| 2020-08-17 04:45:00 | AAPL | Stock | 115.605 | 115.605 | 115.5925 | 115.5925 | 800.0 |
| 2020-08-17 04:50:00 | AAPL | Stock | 115.62 | 115.6225 | 115.6 | 115.6 | 1200.0 |
| 2020-08-17 05:05:00 | AAPL | Stock | 115.56 | 115.56 | 115.56 | 115.56 | 1940.0 |
| 2020-08-17 05:15:00 | AAPL | Stock | 115.575 | 115.5875 | 115.575 | 115.5875 | 2512.0 |
| 2020-08-17 05:20:00 | AAPL | Stock | 115.5525 | 115.575 | 115.5525 | 115.575 | 1324.0 |
| 2020-08-17 05:30:00 | AAPL | Stock | 115.5625 | 115.58 | 115.5625 | 115.58 | 2000.0 |
| 2020-08-17 05:35:00 | AAPL | Stock | 115.5975 | 115.5975 | 115.565 | 115.565 | 800.0 |
| 2020-08-17 05:40:00 | AAPL | Stock | 115.5625 | 115.5625 | 115.5625 | 115.5625 | 1200.0 |
| 2020-08-17 05:45:00 | AAPL | Stock | 115.5625 | 115.5625 | 115.5625 | 115.5625 | 400.0 |
| 2020-08-17 05:50:00 | AAPL | Stock | 115.5925 | 115.6 | 115.5925 | 115.5925 | 1600.0 |
| 2020-08-17 06:05:00 | AAPL | Stock | 115.6125 | 115.6325 | 115.6125 | 115.6325 | 3208.0 |
| 2020-08-17 06:10:00 | AAPL | Stock | 115.6325 | 115.6325 | 115.6325 | 115.6325 | 800.0 |
| 2020-08-17 06:15:00 | AAPL | Stock | 115.6375 | 115.6375 | 115.6375 | 115.6375 | 1392.0 |
| 2020-08-17 06:20:00 | AAPL | Stock | 115.65 | 115.65 | 115.65 | 115.65 | 400.0 |
| 2020-08-17 06:30:00 | AAPL | Stock | 115.6125 | 115.625 | 115.6125 | 115.625 | 2412.0 |
| 2020-08-17 06:45:00 | AAPL | Stock | 115.6275 | 115.6275 | 115.6125 | 115.6125 | 5004.0 |
| 2020-08-17 06:50:00 | AAPL | Stock | 115.5825 | 115.5825 | 115.5775 | 115.5775 | 1568.0 |
| 2020-08-17 07:00:00 | AAPL | Stock | 115.6025 | 115.6125 | 115.495 | 115.6 | 61116.0 |
| 2020-08-17 07:05:00 | AAPL | Stock | 115.5575 | 115.6625 | 115.5475 | 115.645 | 68148.0 |
| 2020-08-17 07:10:00 | AAPL | Stock | 115.6475 | 115.65 | 115.5875 | 115.5875 | 16200.0 |
| 2020-08-17 07:15:00 | AAPL | Stock | 115.5625 | 115.585 | 115.5275 | 115.5825 | 10216.0 |
| 2020-08-17 07:20:00 | AAPL | Stock | 115.565 | 115.565 | 115.5275 | 115.5275 | 3848.0 |
| 2020-08-17 07:25:00 | AAPL | Stock | 115.525 | 115.6 | 115.525 | 115.5775 | 11748.0 |
| 2020-08-17 07:30:00 | AAPL | Stock | 115.5825 | 115.5825 | 115.2575 | 115.36 | 33068.0 |
| 2020-08-17 07:35:00 | AAPL | Stock | 115.3225 | 115.4325 | 115.3125 | 115.4325 | 22060.0 |
| 2020-08-17 07:40:00 | AAPL | Stock | 115.4625 | 115.475 | 115.4375 | 115.475 | 5732.0 |
| 2020-08-17 07:45:00 | AAPL | Stock | 115.45 | 115.4525 | 115.3725 | 115.375 | 24392.0 |
| 2020-08-17 07:50:00 | AAPL | Stock | 115.3975 | 115.6 | 115.3375 | 115.595 | 46240.0 |
| 2020-08-17 07:55:00 | AAPL | Stock | 115.4975 | 115.4975 | 115.415 | 115.4625 | 9580.0 |
| 2020-08-17 08:00:00 | AAPL | Stock | 115.5275 | 115.66 | 115.1925 | 115.4975 | 161332.0 |
| 2020-08-17 08:05:00 | AAPL | Stock | 115.5 | 115.559 | 115.5 | 115.55 | 43684.0 |
| 2020-08-17 08:10:00 | AAPL | Stock | 115.555 | 115.6 | 115.555 | 115.5875 | 29660.0 |
| 2020-08-17 08:15:00 | AAPL | Stock | 115.6 | 115.65 | 115.5525 | 115.65 | 29088.0 |
| 2020-08-17 08:20:00 | AAPL | Stock | 115.625 | 115.7175 | 115.6225 | 115.7175 | 65216.0 |
| 2020-08-17 08:25:00 | AAPL | Stock | 115.7425 | 115.75 | 115.6675 | 115.6675 | 64188.0 |
| 2020-08-17 08:30:00 | AAPL | Stock | 115.6975 | 115.785 | 115.65 | 115.785 | 58888.0 |
| 2020-08-17 08:35:00 | AAPL | Stock | 115.79 | 115.825 | 115.7125 | 115.725 | 43512.0 |
| 2020-08-17 08:40:00 | AAPL | Stock | 115.725 | 115.9375 | 115.725 | 115.925 | 52276.0 |
| 2020-08-17 08:45:00 | AAPL | Stock | 115.91 | 115.9365 | 115.875 | 115.925 | 25780.0 |
| 2020-08-17 08:50:00 | AAPL | Stock | 115.925 | 115.95 | 115.905 | 115.925 | 32128.0 |
| 2020-08-17 08:55:00 | AAPL | Stock | 115.9375 | 116.0 | 115.8915 | 115.975 | 60944.0 |
| 2020-08-17 09:00:00 | AAPL | Stock | 115.9975 | 115.9975 | 115.9075 | 115.95 | 48180.0 |
| 2020-08-17 09:05:00 | AAPL | Stock | 115.9625 | 116.0 | 115.9625 | 115.995 | 67672.0 |
> showing 50 of 409,051 rows — these rows as CSV