PREVIEW / stock_5min / 2019-08-05
file: by_date/stock_5min/2019/2019-08-05.parquet size: 6.0 MB rows: 373,490 symbols: 2,568
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 |
|---|---|---|---|---|---|---|---|
| 2019-08-05 04:00:00 | AAPL | Stock | 49.75 | 49.995 | 49.75 | 49.875 | 23480.0 |
| 2019-08-05 04:05:00 | AAPL | Stock | 49.8725 | 49.8725 | 49.745 | 49.7875 | 3340.0 |
| 2019-08-05 04:10:00 | AAPL | Stock | 49.72 | 49.72 | 49.7 | 49.7 | 5624.0 |
| 2019-08-05 04:15:00 | AAPL | Stock | 49.705 | 49.705 | 49.705 | 49.705 | 1200.0 |
| 2019-08-05 04:20:00 | AAPL | Stock | 49.7325 | 49.735 | 49.7325 | 49.735 | 2708.0 |
| 2019-08-05 04:25:00 | AAPL | Stock | 49.735 | 49.745 | 49.705 | 49.705 | 3288.0 |
| 2019-08-05 04:30:00 | AAPL | Stock | 49.7 | 49.7875 | 49.69 | 49.7875 | 9876.0 |
| 2019-08-05 04:35:00 | AAPL | Stock | 49.7875 | 49.86 | 49.7875 | 49.86 | 11200.0 |
| 2019-08-05 04:40:00 | AAPL | Stock | 49.915 | 49.915 | 49.915 | 49.915 | 400.0 |
| 2019-08-05 04:50:00 | AAPL | Stock | 49.82 | 49.82 | 49.82 | 49.82 | 400.0 |
| 2019-08-05 04:55:00 | AAPL | Stock | 49.775 | 49.775 | 49.6525 | 49.6525 | 16016.0 |
| 2019-08-05 05:00:00 | AAPL | Stock | 49.645 | 49.7 | 49.625 | 49.7 | 25200.0 |
| 2019-08-05 05:05:00 | AAPL | Stock | 49.65 | 49.65 | 49.625 | 49.625 | 16316.0 |
| 2019-08-05 05:10:00 | AAPL | Stock | 49.6 | 49.6475 | 49.6 | 49.645 | 13400.0 |
| 2019-08-05 05:15:00 | AAPL | Stock | 49.635 | 49.65 | 49.635 | 49.6475 | 2312.0 |
| 2019-08-05 05:25:00 | AAPL | Stock | 49.6325 | 49.8225 | 49.6325 | 49.8025 | 4040.0 |
| 2019-08-05 05:30:00 | AAPL | Stock | 49.8825 | 49.8825 | 49.8025 | 49.8175 | 2200.0 |
| 2019-08-05 05:35:00 | AAPL | Stock | 49.8025 | 49.875 | 49.7975 | 49.85 | 5128.0 |
| 2019-08-05 05:40:00 | AAPL | Stock | 49.9175 | 50.0 | 49.9075 | 49.9075 | 3576.0 |
| 2019-08-05 05:45:00 | AAPL | Stock | 49.9 | 49.9 | 49.8925 | 49.8925 | 3200.0 |
| 2019-08-05 05:50:00 | AAPL | Stock | 49.8875 | 49.8875 | 49.8425 | 49.8425 | 2600.0 |
| 2019-08-05 05:55:00 | AAPL | Stock | 49.8975 | 49.9 | 49.875 | 49.875 | 2800.0 |
| 2019-08-05 06:00:00 | AAPL | Stock | 49.8625 | 49.8625 | 49.8625 | 49.8625 | 6564.0 |
| 2019-08-05 06:05:00 | AAPL | Stock | 49.9725 | 49.975 | 49.97 | 49.975 | 2280.0 |
| 2019-08-05 06:10:00 | AAPL | Stock | 49.97 | 49.9725 | 49.8875 | 49.8875 | 5696.0 |
| 2019-08-05 06:15:00 | AAPL | Stock | 49.875 | 49.925 | 49.7525 | 49.785 | 18672.0 |
| 2019-08-05 06:20:00 | AAPL | Stock | 49.755 | 49.755 | 49.75 | 49.75 | 4236.0 |
| 2019-08-05 06:30:00 | AAPL | Stock | 49.7875 | 49.7875 | 49.75 | 49.75 | 3316.0 |
| 2019-08-05 06:35:00 | AAPL | Stock | 49.75 | 49.7625 | 49.75 | 49.7625 | 1200.0 |
| 2019-08-05 06:45:00 | AAPL | Stock | 49.7375 | 49.7725 | 49.7375 | 49.7725 | 1960.0 |
| 2019-08-05 06:50:00 | AAPL | Stock | 49.7775 | 49.7975 | 49.75 | 49.75 | 5176.0 |
| 2019-08-05 06:55:00 | AAPL | Stock | 49.7925 | 49.7925 | 49.735 | 49.76 | 9692.0 |
| 2019-08-05 07:00:00 | AAPL | Stock | 49.775 | 49.875 | 49.6625 | 49.685 | 126292.0 |
| 2019-08-05 07:05:00 | AAPL | Stock | 49.695 | 49.745 | 49.5875 | 49.5875 | 35368.0 |
| 2019-08-05 07:10:00 | AAPL | Stock | 49.59 | 49.6275 | 49.525 | 49.625 | 36528.0 |
| 2019-08-05 07:15:00 | AAPL | Stock | 49.62 | 49.6275 | 49.5425 | 49.6 | 23404.0 |
| 2019-08-05 07:20:00 | AAPL | Stock | 49.555 | 49.695 | 49.5 | 49.505 | 39376.0 |
| 2019-08-05 07:25:00 | AAPL | Stock | 49.545 | 49.5775 | 49.47 | 49.47 | 30396.0 |
| 2019-08-05 07:30:00 | AAPL | Stock | 49.465 | 49.71 | 49.465 | 49.625 | 72516.0 |
| 2019-08-05 07:35:00 | AAPL | Stock | 49.6625 | 49.7125 | 49.6375 | 49.6925 | 29952.0 |
| 2019-08-05 07:40:00 | AAPL | Stock | 49.675 | 49.6875 | 49.5775 | 49.65 | 30104.0 |
| 2019-08-05 07:45:00 | AAPL | Stock | 49.6525 | 49.725 | 49.65 | 49.65 | 16672.0 |
| 2019-08-05 07:50:00 | AAPL | Stock | 49.6325 | 49.675 | 49.585 | 49.6025 | 9348.0 |
| 2019-08-05 07:55:00 | AAPL | Stock | 49.615 | 49.7175 | 49.6125 | 49.6125 | 15620.0 |
| 2019-08-05 08:00:00 | AAPL | Stock | 49.725 | 49.86 | 49.45 | 49.45 | 250812.0 |
| 2019-08-05 08:05:00 | AAPL | Stock | 49.4575 | 49.6625 | 49.4575 | 49.6525 | 137712.0 |
| 2019-08-05 08:10:00 | AAPL | Stock | 49.6525 | 49.695 | 49.515 | 49.55 | 45664.0 |
| 2019-08-05 08:15:00 | AAPL | Stock | 49.55 | 49.58 | 49.515 | 49.52 | 26248.0 |
| 2019-08-05 08:20:00 | AAPL | Stock | 49.52 | 49.65 | 49.465 | 49.6125 | 125748.0 |
| 2019-08-05 08:25:00 | AAPL | Stock | 49.6425 | 49.6425 | 49.55 | 49.5975 | 25544.0 |
> showing 50 of 373,490 rows — these rows as CSV