PREVIEW / stock_5min / 2020-01-02
file: by_date/stock_5min/2020/2020-01-02.parquet size: 6.1 MB rows: 377,987 symbols: 2,467
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 |
|---|---|---|---|---|---|---|---|
| 2020-01-02 04:00:00 | AAPL | Stock | 73.7625 | 73.77 | 73.7625 | 73.77 | 31832.0 |
| 2020-01-02 04:05:00 | AAPL | Stock | 73.8375 | 73.9375 | 73.8375 | 73.9375 | 6536.0 |
| 2020-01-02 04:10:00 | AAPL | Stock | 73.9 | 73.9225 | 73.9 | 73.9225 | 5012.0 |
| 2020-01-02 04:15:00 | AAPL | Stock | 73.92 | 73.935 | 73.92 | 73.935 | 1752.0 |
| 2020-01-02 04:20:00 | AAPL | Stock | 73.9 | 73.935 | 73.9 | 73.935 | 8672.0 |
| 2020-01-02 04:25:00 | AAPL | Stock | 73.935 | 73.935 | 73.935 | 73.935 | 1316.0 |
| 2020-01-02 04:30:00 | AAPL | Stock | 73.925 | 73.925 | 73.875 | 73.89 | 21656.0 |
| 2020-01-02 04:35:00 | AAPL | Stock | 73.89 | 73.89 | 73.89 | 73.89 | 4012.0 |
| 2020-01-02 04:50:00 | AAPL | Stock | 73.9075 | 73.935 | 73.9075 | 73.9325 | 5976.0 |
| 2020-01-02 05:00:00 | AAPL | Stock | 73.9375 | 73.97 | 73.9375 | 73.97 | 5528.0 |
| 2020-01-02 05:10:00 | AAPL | Stock | 73.975 | 74.0 | 73.975 | 74.0 | 2200.0 |
| 2020-01-02 05:15:00 | AAPL | Stock | 73.985 | 73.985 | 73.9775 | 73.9775 | 1796.0 |
| 2020-01-02 05:25:00 | AAPL | Stock | 74.0 | 74.0 | 73.98 | 73.98 | 7852.0 |
| 2020-01-02 05:30:00 | AAPL | Stock | 73.9975 | 73.9975 | 73.975 | 73.975 | 1400.0 |
| 2020-01-02 05:35:00 | AAPL | Stock | 73.9925 | 73.995 | 73.9625 | 73.9625 | 6124.0 |
| 2020-01-02 05:40:00 | AAPL | Stock | 73.9725 | 73.975 | 73.9725 | 73.975 | 2200.0 |
| 2020-01-02 05:45:00 | AAPL | Stock | 73.975 | 74.0 | 73.975 | 74.0 | 8024.0 |
| 2020-01-02 05:50:00 | AAPL | Stock | 73.95 | 74.0 | 73.95 | 74.0 | 2868.0 |
| 2020-01-02 05:55:00 | AAPL | Stock | 74.0 | 74.0125 | 74.0 | 74.0 | 14316.0 |
| 2020-01-02 06:00:00 | AAPL | Stock | 73.9375 | 73.9425 | 73.8875 | 73.89 | 6896.0 |
| 2020-01-02 06:05:00 | AAPL | Stock | 73.89 | 73.89 | 73.89 | 73.89 | 880.0 |
| 2020-01-02 06:10:00 | AAPL | Stock | 73.95 | 73.96 | 73.93 | 73.93 | 4232.0 |
| 2020-01-02 06:15:00 | AAPL | Stock | 73.9 | 73.9625 | 73.8875 | 73.9 | 6596.0 |
| 2020-01-02 06:20:00 | AAPL | Stock | 73.8925 | 73.8925 | 73.875 | 73.875 | 4484.0 |
| 2020-01-02 06:30:00 | AAPL | Stock | 73.8775 | 73.8775 | 73.875 | 73.8775 | 6092.0 |
| 2020-01-02 06:35:00 | AAPL | Stock | 73.865 | 73.865 | 73.865 | 73.865 | 1600.0 |
| 2020-01-02 06:40:00 | AAPL | Stock | 73.8775 | 73.88 | 73.8775 | 73.88 | 1000.0 |
| 2020-01-02 06:45:00 | AAPL | Stock | 73.875 | 73.8975 | 73.875 | 73.875 | 1200.0 |
| 2020-01-02 06:50:00 | AAPL | Stock | 73.825 | 73.8675 | 73.825 | 73.8625 | 5800.0 |
| 2020-01-02 06:55:00 | AAPL | Stock | 73.8625 | 73.8775 | 73.8625 | 73.8775 | 8188.0 |
| 2020-01-02 07:00:00 | AAPL | Stock | 73.875 | 73.975 | 73.7825 | 73.94 | 103552.0 |
| 2020-01-02 07:05:00 | AAPL | Stock | 73.9375 | 73.96 | 73.925 | 73.925 | 14216.0 |
| 2020-01-02 07:10:00 | AAPL | Stock | 73.9375 | 73.975 | 73.925 | 73.925 | 54768.0 |
| 2020-01-02 07:15:00 | AAPL | Stock | 73.925 | 73.9475 | 73.9 | 73.9125 | 23724.0 |
| 2020-01-02 07:20:00 | AAPL | Stock | 73.9125 | 73.9875 | 73.89 | 73.985 | 65988.0 |
| 2020-01-02 07:25:00 | AAPL | Stock | 73.995 | 74.02 | 73.96 | 73.9875 | 37136.0 |
| 2020-01-02 07:30:00 | AAPL | Stock | 73.975 | 74.025 | 73.9525 | 74.0125 | 51628.0 |
| 2020-01-02 07:35:00 | AAPL | Stock | 74.0075 | 74.025 | 73.9875 | 74.0125 | 12668.0 |
| 2020-01-02 07:40:00 | AAPL | Stock | 74.0125 | 74.025 | 73.98 | 73.98 | 22136.0 |
| 2020-01-02 07:45:00 | AAPL | Stock | 73.9975 | 74.0175 | 73.9975 | 74.0125 | 18892.0 |
| 2020-01-02 07:50:00 | AAPL | Stock | 74.0125 | 74.045 | 74.0125 | 74.0275 | 25532.0 |
| 2020-01-02 07:55:00 | AAPL | Stock | 74.0275 | 74.0375 | 74.02 | 74.025 | 10764.0 |
| 2020-01-02 08:00:00 | AAPL | Stock | 73.9725 | 74.0475 | 73.8588 | 74.0075 | 178828.0 |
| 2020-01-02 08:05:00 | AAPL | Stock | 74.0025 | 74.0375 | 73.9825 | 74.025 | 31412.0 |
| 2020-01-02 08:10:00 | AAPL | Stock | 74.025 | 74.0625 | 74.0075 | 74.0375 | 88976.0 |
| 2020-01-02 08:15:00 | AAPL | Stock | 74.0375 | 74.05 | 74.0075 | 74.0325 | 78148.0 |
| 2020-01-02 08:20:00 | AAPL | Stock | 74.0325 | 74.05 | 74.0125 | 74.05 | 19140.0 |
| 2020-01-02 08:25:00 | AAPL | Stock | 74.0575 | 74.0925 | 74.0475 | 74.0525 | 37800.0 |
| 2020-01-02 08:30:00 | AAPL | Stock | 74.0485 | 74.0875 | 74.0475 | 74.0875 | 26760.0 |
| 2020-01-02 08:35:00 | AAPL | Stock | 74.0875 | 74.0875 | 74.0275 | 74.0375 | 21900.0 |
> showing 50 of 377,987 rows — these rows as CSV