PREVIEW / stock_5min / 2019-10-28
file: by_date/stock_5min/2019/2019-10-28.parquet size: 5.7 MB rows: 355,938 symbols: 2,517
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-10-28 04:00:00 | AAPL | Stock | 61.825 | 61.875 | 61.825 | 61.875 | 2508.0 |
| 2019-10-28 04:10:00 | AAPL | Stock | 61.9625 | 61.9625 | 61.9625 | 61.9625 | 400.0 |
| 2019-10-28 04:30:00 | AAPL | Stock | 61.9575 | 61.9575 | 61.9575 | 61.9575 | 400.0 |
| 2019-10-28 04:40:00 | AAPL | Stock | 61.9825 | 61.9825 | 61.9825 | 61.9825 | 572.0 |
| 2019-10-28 04:45:00 | AAPL | Stock | 61.9575 | 61.9575 | 61.9 | 61.9 | 3052.0 |
| 2019-10-28 04:50:00 | AAPL | Stock | 61.9025 | 61.95 | 61.9025 | 61.95 | 14400.0 |
| 2019-10-28 04:55:00 | AAPL | Stock | 61.9575 | 61.9575 | 61.9575 | 61.9575 | 4400.0 |
| 2019-10-28 05:00:00 | AAPL | Stock | 61.915 | 61.915 | 61.905 | 61.905 | 1996.0 |
| 2019-10-28 05:15:00 | AAPL | Stock | 61.9175 | 61.9175 | 61.9 | 61.9 | 2768.0 |
| 2019-10-28 05:30:00 | AAPL | Stock | 61.875 | 61.875 | 61.875 | 61.875 | 3272.0 |
| 2019-10-28 05:35:00 | AAPL | Stock | 61.86 | 61.9 | 61.86 | 61.9 | 3524.0 |
| 2019-10-28 05:40:00 | AAPL | Stock | 61.8575 | 61.8575 | 61.855 | 61.855 | 840.0 |
| 2019-10-28 05:45:00 | AAPL | Stock | 61.9 | 61.9 | 61.9 | 61.9 | 400.0 |
| 2019-10-28 05:50:00 | AAPL | Stock | 61.9 | 61.9 | 61.8625 | 61.8625 | 1600.0 |
| 2019-10-28 05:55:00 | AAPL | Stock | 61.855 | 61.8625 | 61.855 | 61.8575 | 1776.0 |
| 2019-10-28 06:00:00 | AAPL | Stock | 61.86 | 61.86 | 61.8375 | 61.8375 | 2960.0 |
| 2019-10-28 06:05:00 | AAPL | Stock | 61.855 | 61.8625 | 61.8 | 61.8625 | 17772.0 |
| 2019-10-28 06:10:00 | AAPL | Stock | 61.825 | 61.835 | 61.825 | 61.835 | 2108.0 |
| 2019-10-28 06:20:00 | AAPL | Stock | 61.8375 | 61.8375 | 61.8375 | 61.8375 | 3276.0 |
| 2019-10-28 06:30:00 | AAPL | Stock | 61.8375 | 61.8375 | 61.8375 | 61.8375 | 4444.0 |
| 2019-10-28 06:50:00 | AAPL | Stock | 61.8375 | 61.8375 | 61.8375 | 61.8375 | 400.0 |
| 2019-10-28 06:55:00 | AAPL | Stock | 61.8375 | 61.8625 | 61.8375 | 61.8625 | 1196.0 |
| 2019-10-28 07:00:00 | AAPL | Stock | 61.8375 | 61.9375 | 61.8375 | 61.9 | 51836.0 |
| 2019-10-28 07:05:00 | AAPL | Stock | 61.9 | 61.9 | 61.8625 | 61.875 | 5144.0 |
| 2019-10-28 07:10:00 | AAPL | Stock | 61.8525 | 61.8625 | 61.8375 | 61.85 | 8372.0 |
| 2019-10-28 07:15:00 | AAPL | Stock | 61.85 | 61.8975 | 61.85 | 61.875 | 20656.0 |
| 2019-10-28 07:20:00 | AAPL | Stock | 61.8525 | 61.8525 | 61.8375 | 61.85 | 16148.0 |
| 2019-10-28 07:25:00 | AAPL | Stock | 61.8675 | 61.87 | 61.85 | 61.87 | 12320.0 |
| 2019-10-28 07:30:00 | AAPL | Stock | 61.85 | 61.8625 | 61.84 | 61.84 | 2480.0 |
| 2019-10-28 07:35:00 | AAPL | Stock | 61.84 | 61.84 | 61.8175 | 61.8175 | 20980.0 |
| 2019-10-28 07:40:00 | AAPL | Stock | 61.8125 | 61.8125 | 61.785 | 61.8 | 8116.0 |
| 2019-10-28 07:45:00 | AAPL | Stock | 61.8 | 61.86 | 61.8 | 61.86 | 9184.0 |
| 2019-10-28 07:50:00 | AAPL | Stock | 61.855 | 61.86 | 61.855 | 61.855 | 12856.0 |
| 2019-10-28 07:55:00 | AAPL | Stock | 61.8575 | 61.8575 | 61.85 | 61.85 | 812.0 |
| 2019-10-28 08:00:00 | AAPL | Stock | 61.9125 | 61.9375 | 61.4925 | 61.855 | 217244.0 |
| 2019-10-28 08:05:00 | AAPL | Stock | 61.8375 | 61.8375 | 61.785 | 61.7875 | 40840.0 |
| 2019-10-28 08:10:00 | AAPL | Stock | 61.8 | 61.8 | 61.7875 | 61.8 | 14836.0 |
| 2019-10-28 08:15:00 | AAPL | Stock | 61.8 | 61.83 | 61.8 | 61.825 | 26252.0 |
| 2019-10-28 08:20:00 | AAPL | Stock | 61.825 | 61.8575 | 61.82 | 61.8575 | 53188.0 |
| 2019-10-28 08:25:00 | AAPL | Stock | 61.86 | 61.8675 | 61.8425 | 61.8475 | 16108.0 |
| 2019-10-28 08:30:00 | AAPL | Stock | 61.8425 | 61.855 | 61.8425 | 61.8525 | 9100.0 |
| 2019-10-28 08:35:00 | AAPL | Stock | 61.8525 | 61.855 | 61.8375 | 61.85 | 29292.0 |
| 2019-10-28 08:40:00 | AAPL | Stock | 61.85 | 61.8575 | 61.85 | 61.855 | 17916.0 |
| 2019-10-28 08:45:00 | AAPL | Stock | 61.855 | 61.8875 | 61.85 | 61.8775 | 66388.0 |
| 2019-10-28 08:50:00 | AAPL | Stock | 61.87 | 61.925 | 61.86 | 61.9225 | 36492.0 |
| 2019-10-28 08:55:00 | AAPL | Stock | 61.9225 | 61.98 | 61.9225 | 61.9625 | 82296.0 |
| 2019-10-28 09:00:00 | AAPL | Stock | 61.965 | 61.9775 | 61.9375 | 61.95 | 51584.0 |
| 2019-10-28 09:05:00 | AAPL | Stock | 61.96 | 61.96 | 61.9375 | 61.96 | 66320.0 |
| 2019-10-28 09:10:00 | AAPL | Stock | 61.9575 | 61.975 | 61.945 | 61.96 | 72396.0 |
| 2019-10-28 09:15:00 | AAPL | Stock | 61.945 | 61.9625 | 61.9125 | 61.9125 | 55724.0 |
> showing 50 of 355,938 rows — these rows as CSV