PREVIEW / stock_5min / 2018-06-25
file: by_date/stock_5min/2018/2018-06-25.parquet size: 5.7 MB rows: 368,966 symbols: 2,815
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-06-25 04:00:00 | AAPL | Stock | 46.125 | 46.125 | 45.9225 | 45.9225 | 3200.0 |
| 2018-06-25 04:05:00 | AAPL | Stock | 45.9575 | 45.9575 | 45.9575 | 45.9575 | 2000.0 |
| 2018-06-25 04:10:00 | AAPL | Stock | 45.9575 | 45.9575 | 45.9475 | 45.9475 | 800.0 |
| 2018-06-25 04:15:00 | AAPL | Stock | 45.9625 | 45.9625 | 45.9625 | 45.9625 | 1984.0 |
| 2018-06-25 04:20:00 | AAPL | Stock | 45.945 | 45.945 | 45.9275 | 45.9275 | 2436.0 |
| 2018-06-25 04:40:00 | AAPL | Stock | 45.8775 | 45.8775 | 45.8775 | 45.8775 | 1616.0 |
| 2018-06-25 05:00:00 | AAPL | Stock | 45.8 | 45.8875 | 45.77 | 45.77 | 5120.0 |
| 2018-06-25 05:05:00 | AAPL | Stock | 45.7775 | 45.8125 | 45.75 | 45.8125 | 5492.0 |
| 2018-06-25 05:10:00 | AAPL | Stock | 45.7525 | 45.8175 | 45.7525 | 45.8175 | 1800.0 |
| 2018-06-25 05:15:00 | AAPL | Stock | 45.75 | 45.75 | 45.675 | 45.675 | 3124.0 |
| 2018-06-25 05:25:00 | AAPL | Stock | 45.675 | 45.7325 | 45.675 | 45.6825 | 9024.0 |
| 2018-06-25 05:55:00 | AAPL | Stock | 45.72 | 45.72 | 45.7125 | 45.7125 | 1800.0 |
| 2018-06-25 06:00:00 | AAPL | Stock | 45.75 | 45.75 | 45.75 | 45.75 | 400.0 |
| 2018-06-25 06:05:00 | AAPL | Stock | 45.75 | 45.75 | 45.75 | 45.75 | 400.0 |
| 2018-06-25 06:15:00 | AAPL | Stock | 45.71 | 45.71 | 45.71 | 45.71 | 1600.0 |
| 2018-06-25 06:25:00 | AAPL | Stock | 45.7025 | 45.7025 | 45.7 | 45.7 | 9676.0 |
| 2018-06-25 06:30:00 | AAPL | Stock | 45.7275 | 45.7275 | 45.7125 | 45.7125 | 13236.0 |
| 2018-06-25 06:35:00 | AAPL | Stock | 45.71 | 45.71 | 45.71 | 45.71 | 2000.0 |
| 2018-06-25 06:40:00 | AAPL | Stock | 45.6925 | 45.6925 | 45.6875 | 45.6875 | 5408.0 |
| 2018-06-25 06:45:00 | AAPL | Stock | 45.735 | 45.775 | 45.7225 | 45.725 | 7140.0 |
| 2018-06-25 06:50:00 | AAPL | Stock | 45.7725 | 45.7725 | 45.75 | 45.75 | 1400.0 |
| 2018-06-25 06:55:00 | AAPL | Stock | 45.7525 | 45.7525 | 45.75 | 45.75 | 7352.0 |
| 2018-06-25 07:00:00 | AAPL | Stock | 45.75 | 45.82 | 45.6775 | 45.75 | 90796.0 |
| 2018-06-25 07:05:00 | AAPL | Stock | 45.7475 | 45.8175 | 45.7475 | 45.8075 | 18896.0 |
| 2018-06-25 07:10:00 | AAPL | Stock | 45.7975 | 45.8475 | 45.7975 | 45.825 | 35236.0 |
| 2018-06-25 07:15:00 | AAPL | Stock | 45.83 | 45.8425 | 45.8 | 45.8225 | 3200.0 |
| 2018-06-25 07:20:00 | AAPL | Stock | 45.8025 | 45.8025 | 45.7875 | 45.7875 | 14400.0 |
| 2018-06-25 07:25:00 | AAPL | Stock | 45.775 | 45.775 | 45.765 | 45.765 | 12784.0 |
| 2018-06-25 07:30:00 | AAPL | Stock | 45.775 | 45.8125 | 45.775 | 45.8125 | 4596.0 |
| 2018-06-25 07:35:00 | AAPL | Stock | 45.8125 | 45.8125 | 45.7925 | 45.8 | 21720.0 |
| 2018-06-25 07:40:00 | AAPL | Stock | 45.7925 | 45.815 | 45.76 | 45.76 | 10272.0 |
| 2018-06-25 07:45:00 | AAPL | Stock | 45.81 | 45.81 | 45.8025 | 45.8025 | 1500.0 |
| 2018-06-25 07:50:00 | AAPL | Stock | 45.8225 | 45.8225 | 45.8 | 45.8 | 5144.0 |
| 2018-06-25 07:55:00 | AAPL | Stock | 45.8 | 45.84 | 45.79 | 45.83 | 14240.0 |
| 2018-06-25 08:00:00 | AAPL | Stock | 45.7025 | 45.8625 | 45.7 | 45.85 | 141956.0 |
| 2018-06-25 08:05:00 | AAPL | Stock | 45.84 | 45.8425 | 45.8325 | 45.8425 | 12740.0 |
| 2018-06-25 08:10:00 | AAPL | Stock | 45.8275 | 45.855 | 45.825 | 45.855 | 27288.0 |
| 2018-06-25 08:15:00 | AAPL | Stock | 45.8575 | 45.87 | 45.8325 | 45.8375 | 20584.0 |
| 2018-06-25 08:20:00 | AAPL | Stock | 45.825 | 45.825 | 45.825 | 45.825 | 400.0 |
| 2018-06-25 08:25:00 | AAPL | Stock | 45.8625 | 45.9 | 45.8625 | 45.89 | 31556.0 |
| 2018-06-25 08:30:00 | AAPL | Stock | 45.9075 | 45.9125 | 45.875 | 45.9 | 56404.0 |
| 2018-06-25 08:35:00 | AAPL | Stock | 45.9 | 45.9 | 45.875 | 45.8925 | 9188.0 |
| 2018-06-25 08:40:00 | AAPL | Stock | 45.89 | 45.91 | 45.8775 | 45.8775 | 95200.0 |
| 2018-06-25 08:45:00 | AAPL | Stock | 45.8875 | 45.8875 | 45.8625 | 45.875 | 15280.0 |
| 2018-06-25 08:50:00 | AAPL | Stock | 45.875 | 45.8825 | 45.8225 | 45.825 | 23948.0 |
| 2018-06-25 08:55:00 | AAPL | Stock | 45.8075 | 45.8225 | 45.795 | 45.8075 | 22848.0 |
| 2018-06-25 09:00:00 | AAPL | Stock | 45.8025 | 45.825 | 45.8 | 45.825 | 17736.0 |
| 2018-06-25 09:05:00 | AAPL | Stock | 45.8225 | 45.8225 | 45.8025 | 45.8025 | 8608.0 |
| 2018-06-25 09:10:00 | AAPL | Stock | 45.815 | 45.815 | 45.7875 | 45.8075 | 16556.0 |
| 2018-06-25 09:15:00 | AAPL | Stock | 45.795 | 45.825 | 45.795 | 45.805 | 19336.0 |
> showing 50 of 368,966 rows — these rows as CSV