PREVIEW / stock_5min / 2016-01-04
file: by_date/stock_5min/2016/2016-01-04.parquet size: 5.7 MB rows: 379,882 symbols: 3,395
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 |
|---|---|---|---|---|---|---|---|
| 2016-01-04 04:00:00 | AAPL | Stock | 26.3625 | 26.3625 | 25.9 | 25.9975 | 71360.0 |
| 2016-01-04 04:05:00 | AAPL | Stock | 25.925 | 25.9425 | 25.8775 | 25.8775 | 16540.0 |
| 2016-01-04 04:10:00 | AAPL | Stock | 25.88 | 25.8975 | 25.875 | 25.8975 | 13092.0 |
| 2016-01-04 04:15:00 | AAPL | Stock | 25.9 | 25.9 | 25.9 | 25.9 | 400.0 |
| 2016-01-04 04:25:00 | AAPL | Stock | 25.9275 | 25.9275 | 25.915 | 25.915 | 4600.0 |
| 2016-01-04 04:35:00 | AAPL | Stock | 25.9275 | 25.9275 | 25.9275 | 25.9275 | 3544.0 |
| 2016-01-04 04:40:00 | AAPL | Stock | 25.9275 | 25.9275 | 25.925 | 25.925 | 4000.0 |
| 2016-01-04 04:45:00 | AAPL | Stock | 25.95 | 25.95 | 25.9125 | 25.925 | 15264.0 |
| 2016-01-04 04:50:00 | AAPL | Stock | 25.9 | 25.925 | 25.88 | 25.88 | 6852.0 |
| 2016-01-04 04:55:00 | AAPL | Stock | 25.875 | 25.875 | 25.85 | 25.85 | 6432.0 |
| 2016-01-04 05:05:00 | AAPL | Stock | 25.8875 | 25.8875 | 25.8875 | 25.8875 | 1676.0 |
| 2016-01-04 05:10:00 | AAPL | Stock | 25.9 | 25.9125 | 25.8875 | 25.9125 | 6000.0 |
| 2016-01-04 05:15:00 | AAPL | Stock | 25.905 | 25.905 | 25.905 | 25.905 | 1288.0 |
| 2016-01-04 05:20:00 | AAPL | Stock | 25.9 | 25.9 | 25.87 | 25.87 | 9600.0 |
| 2016-01-04 05:25:00 | AAPL | Stock | 25.9 | 25.9 | 25.9 | 25.9 | 800.0 |
| 2016-01-04 05:30:00 | AAPL | Stock | 25.925 | 25.925 | 25.875 | 25.875 | 5608.0 |
| 2016-01-04 05:35:00 | AAPL | Stock | 25.9 | 25.925 | 25.9 | 25.925 | 800.0 |
| 2016-01-04 05:40:00 | AAPL | Stock | 25.925 | 25.9425 | 25.925 | 25.9425 | 800.0 |
| 2016-01-04 05:45:00 | AAPL | Stock | 25.9 | 25.9 | 25.9 | 25.9 | 800.0 |
| 2016-01-04 05:55:00 | AAPL | Stock | 25.92 | 25.92 | 25.92 | 25.92 | 800.0 |
| 2016-01-04 06:00:00 | AAPL | Stock | 25.9225 | 25.9225 | 25.8875 | 25.8875 | 3352.0 |
| 2016-01-04 06:05:00 | AAPL | Stock | 25.9075 | 25.9075 | 25.875 | 25.875 | 27124.0 |
| 2016-01-04 06:10:00 | AAPL | Stock | 25.895 | 25.895 | 25.875 | 25.875 | 4704.0 |
| 2016-01-04 06:15:00 | AAPL | Stock | 25.875 | 25.8875 | 25.8625 | 25.875 | 46828.0 |
| 2016-01-04 06:20:00 | AAPL | Stock | 25.865 | 25.865 | 25.85 | 25.85 | 9600.0 |
| 2016-01-04 06:25:00 | AAPL | Stock | 25.8375 | 25.8375 | 25.82 | 25.82 | 4000.0 |
| 2016-01-04 06:30:00 | AAPL | Stock | 25.8475 | 25.85 | 25.82 | 25.85 | 5996.0 |
| 2016-01-04 06:35:00 | AAPL | Stock | 25.835 | 25.835 | 25.775 | 25.775 | 12216.0 |
| 2016-01-04 06:40:00 | AAPL | Stock | 25.7875 | 25.7875 | 25.7575 | 25.785 | 20188.0 |
| 2016-01-04 06:45:00 | AAPL | Stock | 25.8 | 25.8 | 25.8 | 25.8 | 5556.0 |
| 2016-01-04 06:50:00 | AAPL | Stock | 25.7875 | 25.7875 | 25.775 | 25.775 | 1360.0 |
| 2016-01-04 06:55:00 | AAPL | Stock | 25.7725 | 25.7725 | 25.75 | 25.75 | 13604.0 |
| 2016-01-04 07:00:00 | AAPL | Stock | 25.75 | 25.7675 | 25.7375 | 25.7375 | 31784.0 |
| 2016-01-04 07:05:00 | AAPL | Stock | 25.735 | 25.7475 | 25.7025 | 25.725 | 54184.0 |
| 2016-01-04 07:10:00 | AAPL | Stock | 25.735 | 25.7875 | 25.715 | 25.75 | 76980.0 |
| 2016-01-04 07:15:00 | AAPL | Stock | 25.7525 | 25.7875 | 25.75 | 25.785 | 61636.0 |
| 2016-01-04 07:20:00 | AAPL | Stock | 25.775 | 25.7875 | 25.755 | 25.7875 | 32852.0 |
| 2016-01-04 07:25:00 | AAPL | Stock | 25.7875 | 25.7875 | 25.775 | 25.7775 | 2980.0 |
| 2016-01-04 07:30:00 | AAPL | Stock | 25.795 | 25.7975 | 25.765 | 25.7925 | 15368.0 |
| 2016-01-04 07:35:00 | AAPL | Stock | 25.7875 | 25.8 | 25.7875 | 25.8 | 13820.0 |
| 2016-01-04 07:40:00 | AAPL | Stock | 25.795 | 25.8 | 25.775 | 25.775 | 19432.0 |
| 2016-01-04 07:45:00 | AAPL | Stock | 25.785 | 25.7875 | 25.7625 | 25.765 | 21084.0 |
| 2016-01-04 07:50:00 | AAPL | Stock | 25.765 | 25.8125 | 25.755 | 25.8125 | 42936.0 |
| 2016-01-04 07:55:00 | AAPL | Stock | 25.795 | 25.825 | 25.795 | 25.825 | 35864.0 |
| 2016-01-04 08:00:00 | AAPL | Stock | 25.825 | 25.895 | 25.725 | 25.8725 | 542512.0 |
| 2016-01-04 08:05:00 | AAPL | Stock | 25.8625 | 25.8775 | 25.825 | 25.825 | 77440.0 |
| 2016-01-04 08:10:00 | AAPL | Stock | 25.83 | 25.83 | 25.805 | 25.8175 | 34368.0 |
| 2016-01-04 08:15:00 | AAPL | Stock | 25.815 | 25.8375 | 25.8025 | 25.815 | 77496.0 |
| 2016-01-04 08:20:00 | AAPL | Stock | 25.8125 | 25.8325 | 25.795 | 25.8175 | 40660.0 |
| 2016-01-04 08:25:00 | AAPL | Stock | 25.8125 | 25.825 | 25.7925 | 25.805 | 57448.0 |
> showing 50 of 379,882 rows — these rows as CSV