PREVIEW / stock_5min / 2019-03-08
file: by_date/stock_5min/2019/2019-03-08.parquet size: 5.6 MB rows: 358,876 symbols: 2,647
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-03-08 04:00:00 | AAPL | Stock | 42.9725 | 42.9725 | 42.9725 | 42.9725 | 4888.0 |
| 2019-03-08 04:10:00 | AAPL | Stock | 42.925 | 42.925 | 42.925 | 42.925 | 3200.0 |
| 2019-03-08 04:40:00 | AAPL | Stock | 42.9 | 42.9025 | 42.875 | 42.875 | 7048.0 |
| 2019-03-08 04:45:00 | AAPL | Stock | 42.8525 | 42.8525 | 42.8525 | 42.8525 | 944.0 |
| 2019-03-08 04:50:00 | AAPL | Stock | 42.8325 | 42.8325 | 42.81 | 42.81 | 1380.0 |
| 2019-03-08 04:55:00 | AAPL | Stock | 42.875 | 42.875 | 42.875 | 42.875 | 1016.0 |
| 2019-03-08 05:00:00 | AAPL | Stock | 42.92 | 42.9375 | 42.92 | 42.9375 | 24492.0 |
| 2019-03-08 05:05:00 | AAPL | Stock | 42.9275 | 42.9275 | 42.83 | 42.835 | 30084.0 |
| 2019-03-08 05:10:00 | AAPL | Stock | 42.895 | 42.895 | 42.895 | 42.895 | 1600.0 |
| 2019-03-08 05:15:00 | AAPL | Stock | 42.8375 | 42.8375 | 42.825 | 42.825 | 4800.0 |
| 2019-03-08 05:25:00 | AAPL | Stock | 42.8475 | 42.875 | 42.8375 | 42.875 | 5388.0 |
| 2019-03-08 05:30:00 | AAPL | Stock | 42.8875 | 42.8875 | 42.8875 | 42.8875 | 400.0 |
| 2019-03-08 05:40:00 | AAPL | Stock | 42.8875 | 42.8875 | 42.875 | 42.875 | 13592.0 |
| 2019-03-08 05:50:00 | AAPL | Stock | 42.875 | 42.8875 | 42.875 | 42.88 | 8656.0 |
| 2019-03-08 06:00:00 | AAPL | Stock | 42.8775 | 42.8775 | 42.8775 | 42.8775 | 2628.0 |
| 2019-03-08 06:05:00 | AAPL | Stock | 42.88 | 42.88 | 42.8775 | 42.8775 | 960.0 |
| 2019-03-08 06:15:00 | AAPL | Stock | 42.8875 | 42.8925 | 42.8875 | 42.8875 | 2236.0 |
| 2019-03-08 06:25:00 | AAPL | Stock | 42.88 | 42.88 | 42.8775 | 42.8775 | 3760.0 |
| 2019-03-08 06:35:00 | AAPL | Stock | 42.9325 | 42.9325 | 42.9325 | 42.9325 | 1200.0 |
| 2019-03-08 06:40:00 | AAPL | Stock | 42.905 | 42.905 | 42.905 | 42.905 | 1456.0 |
| 2019-03-08 06:45:00 | AAPL | Stock | 42.89 | 42.89 | 42.89 | 42.89 | 1452.0 |
| 2019-03-08 06:50:00 | AAPL | Stock | 42.88 | 42.88 | 42.88 | 42.88 | 1600.0 |
| 2019-03-08 06:55:00 | AAPL | Stock | 42.85 | 42.85 | 42.8425 | 42.8425 | 5400.0 |
| 2019-03-08 07:00:00 | AAPL | Stock | 42.8825 | 42.9025 | 42.8375 | 42.9025 | 18892.0 |
| 2019-03-08 07:05:00 | AAPL | Stock | 42.91 | 42.91 | 42.91 | 42.91 | 800.0 |
| 2019-03-08 07:10:00 | AAPL | Stock | 42.9125 | 42.9125 | 42.8875 | 42.8875 | 3052.0 |
| 2019-03-08 07:15:00 | AAPL | Stock | 42.885 | 42.8975 | 42.8325 | 42.8325 | 19296.0 |
| 2019-03-08 07:20:00 | AAPL | Stock | 42.8525 | 42.8525 | 42.85 | 42.85 | 4300.0 |
| 2019-03-08 07:25:00 | AAPL | Stock | 42.8725 | 42.8725 | 42.8325 | 42.8625 | 12380.0 |
| 2019-03-08 07:30:00 | AAPL | Stock | 42.8575 | 42.875 | 42.8575 | 42.86 | 15748.0 |
| 2019-03-08 07:35:00 | AAPL | Stock | 42.86 | 42.8625 | 42.8325 | 42.835 | 13464.0 |
| 2019-03-08 07:40:00 | AAPL | Stock | 42.835 | 42.875 | 42.835 | 42.84 | 26092.0 |
| 2019-03-08 07:45:00 | AAPL | Stock | 42.8825 | 42.8875 | 42.835 | 42.87 | 22796.0 |
| 2019-03-08 07:50:00 | AAPL | Stock | 42.8675 | 42.8675 | 42.85 | 42.855 | 1760.0 |
| 2019-03-08 07:55:00 | AAPL | Stock | 42.8675 | 42.8675 | 42.8125 | 42.815 | 27524.0 |
| 2019-03-08 08:00:00 | AAPL | Stock | 42.85 | 42.925 | 42.8125 | 42.8625 | 50368.0 |
| 2019-03-08 08:05:00 | AAPL | Stock | 42.845 | 42.8625 | 42.825 | 42.825 | 10536.0 |
| 2019-03-08 08:10:00 | AAPL | Stock | 42.825 | 42.835 | 42.8125 | 42.825 | 20304.0 |
| 2019-03-08 08:15:00 | AAPL | Stock | 42.8 | 42.8125 | 42.7905 | 42.7905 | 18716.0 |
| 2019-03-08 08:20:00 | AAPL | Stock | 42.8 | 42.85 | 42.8 | 42.85 | 9488.0 |
| 2019-03-08 08:25:00 | AAPL | Stock | 42.8375 | 42.8675 | 42.8375 | 42.865 | 14360.0 |
| 2019-03-08 08:30:00 | AAPL | Stock | 42.8325 | 42.8325 | 42.6375 | 42.71 | 45164.0 |
| 2019-03-08 08:35:00 | AAPL | Stock | 42.7375 | 42.7925 | 42.675 | 42.675 | 96000.0 |
| 2019-03-08 08:40:00 | AAPL | Stock | 42.725 | 42.75 | 42.675 | 42.6825 | 45136.0 |
| 2019-03-08 08:45:00 | AAPL | Stock | 42.675 | 43.125 | 42.65 | 42.6525 | 436668.0 |
| 2019-03-08 08:50:00 | AAPL | Stock | 42.6525 | 42.6525 | 42.5875 | 42.5875 | 121904.0 |
| 2019-03-08 08:55:00 | AAPL | Stock | 42.6 | 42.625 | 42.5825 | 42.595 | 53524.0 |
| 2019-03-08 09:00:00 | AAPL | Stock | 42.5925 | 42.595 | 42.5675 | 42.5775 | 47016.0 |
| 2019-03-08 09:05:00 | AAPL | Stock | 42.5775 | 42.5775 | 42.4775 | 42.53 | 165724.0 |
| 2019-03-08 09:10:00 | AAPL | Stock | 42.52 | 42.54 | 42.52 | 42.5275 | 15448.0 |
> showing 50 of 358,876 rows — these rows as CSV