PREVIEW / stock_5min / 2018-09-06
file: by_date/stock_5min/2018/2018-09-06.parquet size: 5.5 MB rows: 350,783 symbols: 2,780
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-09-06 04:00:00 | AAPL | Stock | 56.67 | 56.67 | 56.6 | 56.6 | 16616.0 |
| 2018-09-06 04:05:00 | AAPL | Stock | 56.67 | 56.67 | 56.67 | 56.67 | 1244.0 |
| 2018-09-06 04:10:00 | AAPL | Stock | 56.67 | 56.67 | 56.67 | 56.67 | 400.0 |
| 2018-09-06 04:20:00 | AAPL | Stock | 56.7025 | 56.7025 | 56.7 | 56.7 | 1092.0 |
| 2018-09-06 04:45:00 | AAPL | Stock | 56.875 | 56.875 | 56.875 | 56.875 | 8268.0 |
| 2018-09-06 04:50:00 | AAPL | Stock | 56.8625 | 56.875 | 56.8625 | 56.875 | 10244.0 |
| 2018-09-06 05:00:00 | AAPL | Stock | 56.875 | 56.875 | 56.875 | 56.875 | 6000.0 |
| 2018-09-06 05:05:00 | AAPL | Stock | 56.925 | 56.925 | 56.925 | 56.925 | 10000.0 |
| 2018-09-06 05:10:00 | AAPL | Stock | 56.875 | 56.9375 | 56.875 | 56.9375 | 1276.0 |
| 2018-09-06 05:15:00 | AAPL | Stock | 56.92 | 56.92 | 56.92 | 56.92 | 1908.0 |
| 2018-09-06 05:20:00 | AAPL | Stock | 56.92 | 56.92 | 56.915 | 56.915 | 1744.0 |
| 2018-09-06 05:25:00 | AAPL | Stock | 57.0 | 57.0 | 57.0 | 57.0 | 400.0 |
| 2018-09-06 05:55:00 | AAPL | Stock | 56.97 | 56.97 | 56.97 | 56.97 | 428.0 |
| 2018-09-06 06:15:00 | AAPL | Stock | 56.8025 | 56.8025 | 56.8 | 56.8 | 1200.0 |
| 2018-09-06 06:25:00 | AAPL | Stock | 56.885 | 56.8875 | 56.885 | 56.8875 | 5900.0 |
| 2018-09-06 06:35:00 | AAPL | Stock | 56.825 | 56.825 | 56.825 | 56.825 | 800.0 |
| 2018-09-06 06:45:00 | AAPL | Stock | 56.8 | 56.8 | 56.76 | 56.76 | 9788.0 |
| 2018-09-06 06:55:00 | AAPL | Stock | 56.8125 | 56.8125 | 56.8125 | 56.8125 | 608.0 |
| 2018-09-06 07:00:00 | AAPL | Stock | 56.7575 | 56.8 | 56.75 | 56.75 | 15684.0 |
| 2018-09-06 07:05:00 | AAPL | Stock | 56.75 | 56.75 | 56.675 | 56.675 | 8224.0 |
| 2018-09-06 07:10:00 | AAPL | Stock | 56.675 | 56.735 | 56.6675 | 56.735 | 15948.0 |
| 2018-09-06 07:15:00 | AAPL | Stock | 56.6825 | 56.75 | 56.6825 | 56.7 | 1600.0 |
| 2018-09-06 07:20:00 | AAPL | Stock | 56.745 | 56.7625 | 56.7375 | 56.7575 | 4800.0 |
| 2018-09-06 07:25:00 | AAPL | Stock | 56.7725 | 56.7725 | 56.74 | 56.74 | 8672.0 |
| 2018-09-06 07:30:00 | AAPL | Stock | 56.7475 | 56.75 | 56.7375 | 56.75 | 6392.0 |
| 2018-09-06 07:35:00 | AAPL | Stock | 56.76 | 56.765 | 56.75 | 56.765 | 3000.0 |
| 2018-09-06 07:40:00 | AAPL | Stock | 56.775 | 56.775 | 56.7525 | 56.77 | 13732.0 |
| 2018-09-06 07:45:00 | AAPL | Stock | 56.775 | 56.775 | 56.76 | 56.76 | 4476.0 |
| 2018-09-06 07:50:00 | AAPL | Stock | 56.7825 | 56.7875 | 56.7625 | 56.7825 | 14636.0 |
| 2018-09-06 07:55:00 | AAPL | Stock | 56.7875 | 56.7925 | 56.7875 | 56.7925 | 1600.0 |
| 2018-09-06 08:00:00 | AAPL | Stock | 56.725 | 56.88 | 56.6675 | 56.8725 | 103820.0 |
| 2018-09-06 08:05:00 | AAPL | Stock | 56.875 | 56.8975 | 56.8625 | 56.89 | 17648.0 |
| 2018-09-06 08:10:00 | AAPL | Stock | 56.89 | 56.895 | 56.875 | 56.89 | 31688.0 |
| 2018-09-06 08:15:00 | AAPL | Stock | 56.89 | 56.895 | 56.85 | 56.85 | 24436.0 |
| 2018-09-06 08:20:00 | AAPL | Stock | 56.865 | 56.8975 | 56.8525 | 56.8525 | 25076.0 |
| 2018-09-06 08:25:00 | AAPL | Stock | 56.8625 | 56.9075 | 56.8625 | 56.9075 | 41444.0 |
| 2018-09-06 08:30:00 | AAPL | Stock | 56.9075 | 56.9225 | 56.8775 | 56.8775 | 59760.0 |
| 2018-09-06 08:35:00 | AAPL | Stock | 56.88 | 56.885 | 56.8625 | 56.865 | 26756.0 |
| 2018-09-06 08:40:00 | AAPL | Stock | 56.865 | 56.88 | 56.85 | 56.85 | 13584.0 |
| 2018-09-06 08:45:00 | AAPL | Stock | 56.8525 | 56.87 | 56.835 | 56.87 | 10924.0 |
| 2018-09-06 08:50:00 | AAPL | Stock | 56.8725 | 56.9 | 56.8725 | 56.895 | 28620.0 |
| 2018-09-06 08:55:00 | AAPL | Stock | 56.8975 | 56.9225 | 56.8975 | 56.92 | 32636.0 |
| 2018-09-06 09:00:00 | AAPL | Stock | 56.92 | 56.925 | 56.8875 | 56.9 | 17508.0 |
| 2018-09-06 09:05:00 | AAPL | Stock | 56.9 | 56.9 | 56.8625 | 56.875 | 12716.0 |
| 2018-09-06 09:10:00 | AAPL | Stock | 56.8625 | 56.8625 | 56.8425 | 56.8425 | 3124.0 |
| 2018-09-06 09:15:00 | AAPL | Stock | 56.87 | 56.87 | 56.8525 | 56.865 | 33840.0 |
| 2018-09-06 09:20:00 | AAPL | Stock | 56.875 | 56.8875 | 56.85 | 56.8525 | 47372.0 |
| 2018-09-06 09:25:00 | AAPL | Stock | 56.8525 | 56.875 | 56.555 | 56.5575 | 237580.0 |
| 2018-09-06 09:30:00 | AAPL | Stock | 56.5575 | 56.8375 | 56.5575 | 56.671 | 3832880.0 |
| 2018-09-06 09:35:00 | AAPL | Stock | 56.6695 | 56.7245 | 56.375 | 56.4175 | 2349368.0 |
> showing 50 of 350,783 rows — these rows as CSV