PREVIEW / stock_5min / 2019-05-23
file: by_date/stock_5min/2019/2019-05-23.parquet size: 5.7 MB rows: 361,061 symbols: 2,605
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-05-23 04:00:00 | AAPL | Stock | 44.875 | 44.92 | 44.8225 | 44.92 | 19220.0 |
| 2019-05-23 04:05:00 | AAPL | Stock | 44.935 | 45.035 | 44.935 | 45.0 | 24552.0 |
| 2019-05-23 04:15:00 | AAPL | Stock | 44.94 | 44.94 | 44.8625 | 44.8625 | 16212.0 |
| 2019-05-23 04:20:00 | AAPL | Stock | 44.8525 | 44.8525 | 44.815 | 44.815 | 7912.0 |
| 2019-05-23 04:25:00 | AAPL | Stock | 44.8175 | 44.875 | 44.8175 | 44.875 | 3668.0 |
| 2019-05-23 04:30:00 | AAPL | Stock | 44.87 | 44.87 | 44.87 | 44.87 | 400.0 |
| 2019-05-23 04:35:00 | AAPL | Stock | 44.845 | 44.845 | 44.825 | 44.825 | 4400.0 |
| 2019-05-23 04:40:00 | AAPL | Stock | 44.8125 | 44.825 | 44.8125 | 44.825 | 16232.0 |
| 2019-05-23 04:45:00 | AAPL | Stock | 44.845 | 44.855 | 44.8125 | 44.855 | 5760.0 |
| 2019-05-23 04:50:00 | AAPL | Stock | 44.855 | 44.855 | 44.855 | 44.855 | 12480.0 |
| 2019-05-23 04:55:00 | AAPL | Stock | 44.825 | 44.825 | 44.8125 | 44.8125 | 1600.0 |
| 2019-05-23 05:00:00 | AAPL | Stock | 44.825 | 44.825 | 44.825 | 44.825 | 400.0 |
| 2019-05-23 05:05:00 | AAPL | Stock | 44.8525 | 44.8625 | 44.8525 | 44.8625 | 1740.0 |
| 2019-05-23 05:15:00 | AAPL | Stock | 44.9075 | 44.9125 | 44.8475 | 44.8475 | 5532.0 |
| 2019-05-23 05:20:00 | AAPL | Stock | 44.835 | 44.835 | 44.745 | 44.7575 | 10040.0 |
| 2019-05-23 05:35:00 | AAPL | Stock | 44.725 | 44.725 | 44.71 | 44.71 | 1200.0 |
| 2019-05-23 05:40:00 | AAPL | Stock | 44.6925 | 44.6925 | 44.675 | 44.69 | 5260.0 |
| 2019-05-23 05:45:00 | AAPL | Stock | 44.72 | 44.72 | 44.6775 | 44.6775 | 3040.0 |
| 2019-05-23 05:50:00 | AAPL | Stock | 44.6925 | 44.725 | 44.6925 | 44.725 | 1600.0 |
| 2019-05-23 06:00:00 | AAPL | Stock | 44.68 | 44.68 | 44.64 | 44.64 | 10384.0 |
| 2019-05-23 06:05:00 | AAPL | Stock | 44.6375 | 44.6375 | 44.5875 | 44.5875 | 10480.0 |
| 2019-05-23 06:10:00 | AAPL | Stock | 44.625 | 44.6425 | 44.625 | 44.6425 | 27884.0 |
| 2019-05-23 06:15:00 | AAPL | Stock | 44.6575 | 44.6675 | 44.6025 | 44.665 | 12168.0 |
| 2019-05-23 06:20:00 | AAPL | Stock | 44.68 | 44.7375 | 44.68 | 44.695 | 7392.0 |
| 2019-05-23 06:25:00 | AAPL | Stock | 44.695 | 44.75 | 44.695 | 44.725 | 1588.0 |
| 2019-05-23 06:30:00 | AAPL | Stock | 44.7375 | 44.7375 | 44.7225 | 44.725 | 11392.0 |
| 2019-05-23 06:35:00 | AAPL | Stock | 44.7375 | 44.75 | 44.7375 | 44.75 | 2480.0 |
| 2019-05-23 06:40:00 | AAPL | Stock | 44.775 | 44.845 | 44.775 | 44.8375 | 4520.0 |
| 2019-05-23 06:45:00 | AAPL | Stock | 44.7575 | 44.84 | 44.7575 | 44.795 | 14612.0 |
| 2019-05-23 06:50:00 | AAPL | Stock | 44.775 | 44.79 | 44.775 | 44.78 | 1200.0 |
| 2019-05-23 06:55:00 | AAPL | Stock | 44.7675 | 44.7675 | 44.6925 | 44.75 | 10812.0 |
| 2019-05-23 07:00:00 | AAPL | Stock | 44.75 | 44.95 | 44.75 | 44.9 | 74560.0 |
| 2019-05-23 07:05:00 | AAPL | Stock | 44.9 | 44.945 | 44.8875 | 44.9125 | 11352.0 |
| 2019-05-23 07:10:00 | AAPL | Stock | 44.925 | 44.95 | 44.8575 | 44.8575 | 17044.0 |
| 2019-05-23 07:15:00 | AAPL | Stock | 44.8875 | 44.9 | 44.8525 | 44.8625 | 33272.0 |
| 2019-05-23 07:20:00 | AAPL | Stock | 44.855 | 44.8625 | 44.8 | 44.8 | 29972.0 |
| 2019-05-23 07:25:00 | AAPL | Stock | 44.825 | 44.95 | 44.82 | 44.9125 | 58948.0 |
| 2019-05-23 07:30:00 | AAPL | Stock | 44.925 | 44.9975 | 44.9025 | 44.9375 | 25832.0 |
| 2019-05-23 07:35:00 | AAPL | Stock | 44.97 | 44.9725 | 44.9 | 44.92 | 44380.0 |
| 2019-05-23 07:40:00 | AAPL | Stock | 44.92 | 44.935 | 44.83 | 44.83 | 55680.0 |
| 2019-05-23 07:45:00 | AAPL | Stock | 44.845 | 44.8675 | 44.8325 | 44.8375 | 7300.0 |
| 2019-05-23 07:50:00 | AAPL | Stock | 44.8325 | 44.91 | 44.7975 | 44.91 | 22372.0 |
| 2019-05-23 07:55:00 | AAPL | Stock | 44.915 | 44.95 | 44.8575 | 44.8625 | 50040.0 |
| 2019-05-23 08:00:00 | AAPL | Stock | 44.85 | 44.987 | 44.75 | 44.805 | 187652.0 |
| 2019-05-23 08:05:00 | AAPL | Stock | 44.81 | 44.86 | 44.805 | 44.86 | 28352.0 |
| 2019-05-23 08:10:00 | AAPL | Stock | 44.825 | 44.8825 | 44.7875 | 44.7875 | 14356.0 |
| 2019-05-23 08:15:00 | AAPL | Stock | 44.81 | 44.9 | 44.7875 | 44.855 | 26476.0 |
| 2019-05-23 08:20:00 | AAPL | Stock | 44.8525 | 44.925 | 44.825 | 44.8998 | 32012.0 |
| 2019-05-23 08:25:00 | AAPL | Stock | 44.9025 | 44.925 | 44.8675 | 44.875 | 40152.0 |
| 2019-05-23 08:30:00 | AAPL | Stock | 44.8775 | 44.9175 | 44.8625 | 44.895 | 69844.0 |
> showing 50 of 361,061 rows — these rows as CSV