PREVIEW / stock_5min / 2019-12-05
file: by_date/stock_5min/2019/2019-12-05.parquet size: 5.8 MB rows: 362,580 symbols: 2,478
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-12-05 04:00:00 | AAPL | Stock | 65.5525 | 65.625 | 65.5525 | 65.625 | 3584.0 |
| 2019-12-05 04:05:00 | AAPL | Stock | 65.625 | 65.625 | 65.6 | 65.6 | 5600.0 |
| 2019-12-05 04:10:00 | AAPL | Stock | 65.5075 | 65.5625 | 65.5075 | 65.51 | 3608.0 |
| 2019-12-05 04:15:00 | AAPL | Stock | 65.525 | 65.525 | 65.5075 | 65.5075 | 4156.0 |
| 2019-12-05 04:20:00 | AAPL | Stock | 65.5825 | 65.5825 | 65.5825 | 65.5825 | 400.0 |
| 2019-12-05 04:45:00 | AAPL | Stock | 65.6125 | 65.63 | 65.6125 | 65.63 | 14400.0 |
| 2019-12-05 04:55:00 | AAPL | Stock | 65.665 | 65.665 | 65.665 | 65.665 | 6992.0 |
| 2019-12-05 05:00:00 | AAPL | Stock | 65.67 | 65.67 | 65.665 | 65.665 | 8760.0 |
| 2019-12-05 05:20:00 | AAPL | Stock | 65.6375 | 65.6375 | 65.6375 | 65.6375 | 580.0 |
| 2019-12-05 05:30:00 | AAPL | Stock | 65.6875 | 65.7475 | 65.6875 | 65.7475 | 4972.0 |
| 2019-12-05 05:35:00 | AAPL | Stock | 65.75 | 65.76 | 65.75 | 65.76 | 3600.0 |
| 2019-12-05 05:40:00 | AAPL | Stock | 65.76 | 65.76 | 65.7525 | 65.755 | 5600.0 |
| 2019-12-05 05:45:00 | AAPL | Stock | 65.7325 | 65.75 | 65.7325 | 65.7325 | 6320.0 |
| 2019-12-05 05:50:00 | AAPL | Stock | 65.8 | 65.825 | 65.795 | 65.795 | 3684.0 |
| 2019-12-05 05:55:00 | AAPL | Stock | 65.82 | 65.825 | 65.8075 | 65.8075 | 9032.0 |
| 2019-12-05 06:00:00 | AAPL | Stock | 65.8 | 65.81 | 65.8 | 65.81 | 6388.0 |
| 2019-12-05 06:05:00 | AAPL | Stock | 65.8425 | 65.875 | 65.8425 | 65.875 | 10340.0 |
| 2019-12-05 06:10:00 | AAPL | Stock | 65.8875 | 65.8875 | 65.8825 | 65.8825 | 4556.0 |
| 2019-12-05 06:15:00 | AAPL | Stock | 65.8825 | 65.8875 | 65.855 | 65.885 | 15756.0 |
| 2019-12-05 06:20:00 | AAPL | Stock | 65.855 | 65.855 | 65.855 | 65.855 | 400.0 |
| 2019-12-05 06:25:00 | AAPL | Stock | 65.885 | 65.925 | 65.885 | 65.925 | 10004.0 |
| 2019-12-05 06:30:00 | AAPL | Stock | 65.9475 | 65.9675 | 65.91 | 65.91 | 4868.0 |
| 2019-12-05 06:35:00 | AAPL | Stock | 65.9475 | 65.95 | 65.9275 | 65.9275 | 3636.0 |
| 2019-12-05 06:40:00 | AAPL | Stock | 65.93 | 65.995 | 65.93 | 65.9725 | 16544.0 |
| 2019-12-05 06:45:00 | AAPL | Stock | 65.9725 | 65.98 | 65.95 | 65.9525 | 11704.0 |
| 2019-12-05 06:50:00 | AAPL | Stock | 65.9525 | 65.9525 | 65.9325 | 65.9325 | 2576.0 |
| 2019-12-05 06:55:00 | AAPL | Stock | 65.9275 | 65.93 | 65.9275 | 65.9275 | 7008.0 |
| 2019-12-05 07:00:00 | AAPL | Stock | 65.9275 | 65.965 | 65.915 | 65.965 | 63820.0 |
| 2019-12-05 07:05:00 | AAPL | Stock | 65.965 | 65.975 | 65.925 | 65.925 | 9880.0 |
| 2019-12-05 07:10:00 | AAPL | Stock | 65.9275 | 65.9275 | 65.9125 | 65.9125 | 1800.0 |
| 2019-12-05 07:15:00 | AAPL | Stock | 65.9125 | 65.9175 | 65.9 | 65.9 | 19496.0 |
| 2019-12-05 07:20:00 | AAPL | Stock | 65.9 | 65.9075 | 65.8925 | 65.905 | 8004.0 |
| 2019-12-05 07:25:00 | AAPL | Stock | 65.9225 | 65.9225 | 65.9 | 65.9 | 4700.0 |
| 2019-12-05 07:30:00 | AAPL | Stock | 65.88 | 65.895 | 65.8775 | 65.8925 | 5000.0 |
| 2019-12-05 07:35:00 | AAPL | Stock | 65.8775 | 65.8775 | 65.85 | 65.8725 | 25644.0 |
| 2019-12-05 07:40:00 | AAPL | Stock | 65.8825 | 65.8925 | 65.85 | 65.8625 | 5360.0 |
| 2019-12-05 07:45:00 | AAPL | Stock | 65.85 | 65.8625 | 65.85 | 65.8625 | 8436.0 |
| 2019-12-05 07:50:00 | AAPL | Stock | 65.8725 | 65.895 | 65.8725 | 65.8875 | 6000.0 |
| 2019-12-05 07:55:00 | AAPL | Stock | 65.8925 | 65.895 | 65.875 | 65.8875 | 14688.0 |
| 2019-12-05 08:00:00 | AAPL | Stock | 65.975 | 65.975 | 65.8325 | 65.8325 | 107396.0 |
| 2019-12-05 08:05:00 | AAPL | Stock | 65.825 | 65.825 | 65.735 | 65.7887 | 26740.0 |
| 2019-12-05 08:10:00 | AAPL | Stock | 65.7925 | 65.8325 | 65.7775 | 65.7875 | 35160.0 |
| 2019-12-05 08:15:00 | AAPL | Stock | 65.79 | 65.8325 | 65.79 | 65.8325 | 14260.0 |
| 2019-12-05 08:20:00 | AAPL | Stock | 65.83 | 65.9075 | 65.83 | 65.9075 | 50692.0 |
| 2019-12-05 08:25:00 | AAPL | Stock | 65.8875 | 65.9225 | 65.8875 | 65.9175 | 35256.0 |
| 2019-12-05 08:30:00 | AAPL | Stock | 65.915 | 65.95 | 65.8875 | 65.895 | 17404.0 |
| 2019-12-05 08:35:00 | AAPL | Stock | 65.88 | 65.8975 | 65.8625 | 65.8975 | 46372.0 |
| 2019-12-05 08:40:00 | AAPL | Stock | 65.8875 | 65.9375 | 65.8825 | 65.9175 | 20776.0 |
| 2019-12-05 08:45:00 | AAPL | Stock | 65.9075 | 65.925 | 65.8825 | 65.885 | 26788.0 |
| 2019-12-05 08:50:00 | AAPL | Stock | 65.9 | 65.975 | 65.875 | 65.895 | 35812.0 |
> showing 50 of 362,580 rows — these rows as CSV