PREVIEW / stock_5min / 2019-09-05
file: by_date/stock_5min/2019/2019-09-05.parquet size: 5.8 MB rows: 363,987 symbols: 2,565
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-09-05 04:00:00 | AAPL | Stock | 52.65 | 52.65 | 52.65 | 52.65 | 1580.0 |
| 2019-09-05 04:10:00 | AAPL | Stock | 52.75 | 52.7575 | 52.75 | 52.7575 | 1600.0 |
| 2019-09-05 04:15:00 | AAPL | Stock | 52.8375 | 52.8375 | 52.8375 | 52.8375 | 1968.0 |
| 2019-09-05 04:20:00 | AAPL | Stock | 52.835 | 52.8575 | 52.835 | 52.8575 | 2988.0 |
| 2019-09-05 04:25:00 | AAPL | Stock | 52.85 | 52.875 | 52.85 | 52.875 | 1392.0 |
| 2019-09-05 04:50:00 | AAPL | Stock | 52.875 | 52.875 | 52.875 | 52.875 | 5568.0 |
| 2019-09-05 05:05:00 | AAPL | Stock | 52.8975 | 52.8975 | 52.8975 | 52.8975 | 1808.0 |
| 2019-09-05 05:15:00 | AAPL | Stock | 52.9225 | 52.945 | 52.9225 | 52.945 | 2244.0 |
| 2019-09-05 05:20:00 | AAPL | Stock | 52.875 | 52.875 | 52.875 | 52.875 | 1200.0 |
| 2019-09-05 05:25:00 | AAPL | Stock | 52.8875 | 52.895 | 52.8875 | 52.895 | 4160.0 |
| 2019-09-05 05:30:00 | AAPL | Stock | 52.9125 | 53.0 | 52.9125 | 53.0 | 5532.0 |
| 2019-09-05 05:35:00 | AAPL | Stock | 52.9925 | 52.9975 | 52.9925 | 52.9975 | 3840.0 |
| 2019-09-05 05:40:00 | AAPL | Stock | 52.995 | 52.995 | 52.995 | 52.995 | 400.0 |
| 2019-09-05 05:50:00 | AAPL | Stock | 52.9925 | 53.0025 | 52.9925 | 53.0025 | 21532.0 |
| 2019-09-05 05:55:00 | AAPL | Stock | 53.025 | 53.0375 | 53.0 | 53.0 | 20180.0 |
| 2019-09-05 06:05:00 | AAPL | Stock | 53.005 | 53.0225 | 53.005 | 53.0225 | 800.0 |
| 2019-09-05 06:10:00 | AAPL | Stock | 53.0 | 53.0 | 53.0 | 53.0 | 400.0 |
| 2019-09-05 06:15:00 | AAPL | Stock | 52.9625 | 52.9625 | 52.9625 | 52.9625 | 4000.0 |
| 2019-09-05 06:25:00 | AAPL | Stock | 52.9575 | 52.9575 | 52.8 | 52.8125 | 18692.0 |
| 2019-09-05 06:30:00 | AAPL | Stock | 52.7775 | 52.875 | 52.7675 | 52.875 | 9584.0 |
| 2019-09-05 06:35:00 | AAPL | Stock | 52.9175 | 52.95 | 52.9125 | 52.95 | 3680.0 |
| 2019-09-05 06:40:00 | AAPL | Stock | 52.945 | 52.9725 | 52.945 | 52.9725 | 3600.0 |
| 2019-09-05 06:50:00 | AAPL | Stock | 52.9475 | 52.9475 | 52.9475 | 52.9475 | 3600.0 |
| 2019-09-05 06:55:00 | AAPL | Stock | 52.93 | 52.93 | 52.93 | 52.93 | 400.0 |
| 2019-09-05 07:00:00 | AAPL | Stock | 52.905 | 52.9575 | 52.8275 | 52.875 | 66948.0 |
| 2019-09-05 07:05:00 | AAPL | Stock | 52.8875 | 52.8875 | 52.85 | 52.855 | 16488.0 |
| 2019-09-05 07:10:00 | AAPL | Stock | 52.85 | 52.8625 | 52.84 | 52.84 | 22972.0 |
| 2019-09-05 07:15:00 | AAPL | Stock | 52.84 | 52.86 | 52.84 | 52.86 | 9220.0 |
| 2019-09-05 07:20:00 | AAPL | Stock | 52.86 | 52.8875 | 52.83 | 52.8875 | 26876.0 |
| 2019-09-05 07:25:00 | AAPL | Stock | 52.875 | 52.9 | 52.875 | 52.8775 | 9968.0 |
| 2019-09-05 07:30:00 | AAPL | Stock | 52.875 | 52.875 | 52.845 | 52.855 | 20000.0 |
| 2019-09-05 07:35:00 | AAPL | Stock | 52.855 | 52.875 | 52.84 | 52.86 | 13384.0 |
| 2019-09-05 07:40:00 | AAPL | Stock | 52.8425 | 52.8625 | 52.8425 | 52.845 | 8068.0 |
| 2019-09-05 07:45:00 | AAPL | Stock | 52.8375 | 52.85 | 52.825 | 52.825 | 6064.0 |
| 2019-09-05 07:50:00 | AAPL | Stock | 52.8275 | 52.8275 | 52.8125 | 52.825 | 18468.0 |
| 2019-09-05 07:55:00 | AAPL | Stock | 52.825 | 52.825 | 52.765 | 52.765 | 9556.0 |
| 2019-09-05 08:00:00 | AAPL | Stock | 52.895 | 52.9475 | 52.79 | 52.83 | 160144.0 |
| 2019-09-05 08:05:00 | AAPL | Stock | 52.83 | 52.8875 | 52.8125 | 52.875 | 26472.0 |
| 2019-09-05 08:10:00 | AAPL | Stock | 52.8168 | 52.88 | 52.8168 | 52.8725 | 8292.0 |
| 2019-09-05 08:15:00 | AAPL | Stock | 52.8775 | 52.9 | 52.8325 | 52.8325 | 18820.0 |
| 2019-09-05 08:20:00 | AAPL | Stock | 52.8435 | 52.9125 | 52.8435 | 52.9125 | 24600.0 |
| 2019-09-05 08:25:00 | AAPL | Stock | 52.91 | 52.935 | 52.91 | 52.9125 | 37724.0 |
| 2019-09-05 08:30:00 | AAPL | Stock | 52.9125 | 52.9125 | 52.8875 | 52.9 | 28716.0 |
| 2019-09-05 08:35:00 | AAPL | Stock | 52.878 | 52.9125 | 52.878 | 52.9 | 24792.0 |
| 2019-09-05 08:40:00 | AAPL | Stock | 52.9 | 52.9325 | 52.9 | 52.9125 | 46884.0 |
| 2019-09-05 08:45:00 | AAPL | Stock | 52.9 | 52.9275 | 52.9 | 52.905 | 18776.0 |
| 2019-09-05 08:50:00 | AAPL | Stock | 52.915 | 52.935 | 52.9125 | 52.925 | 36744.0 |
| 2019-09-05 08:55:00 | AAPL | Stock | 52.92 | 52.95 | 52.9025 | 52.905 | 51644.0 |
| 2019-09-05 09:00:00 | AAPL | Stock | 52.91 | 52.925 | 52.8825 | 52.915 | 63620.0 |
| 2019-09-05 09:05:00 | AAPL | Stock | 52.9 | 52.9 | 52.8725 | 52.8975 | 5200.0 |
> showing 50 of 363,987 rows — these rows as CSV