PREVIEW / stock_5min / 2020-11-02
file: by_date/stock_5min/2020/2020-11-02.parquet size: 6.5 MB rows: 404,889 symbols: 2,536
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-11-02 04:00:00 | AAPL | Stock | 109.62 | 109.62 | 109.02 | 109.54 | 14198.0 |
| 2020-11-02 04:05:00 | AAPL | Stock | 109.58 | 109.58 | 109.45 | 109.54 | 4999.0 |
| 2020-11-02 04:10:00 | AAPL | Stock | 109.52 | 109.52 | 109.44 | 109.5 | 8728.0 |
| 2020-11-02 04:15:00 | AAPL | Stock | 109.49 | 109.49 | 109.32 | 109.37 | 5625.0 |
| 2020-11-02 04:20:00 | AAPL | Stock | 109.31 | 109.5 | 109.15 | 109.45 | 4730.0 |
| 2020-11-02 04:25:00 | AAPL | Stock | 109.49 | 109.65 | 109.48 | 109.56 | 16274.0 |
| 2020-11-02 04:30:00 | AAPL | Stock | 109.56 | 109.85 | 109.56 | 109.76 | 3925.0 |
| 2020-11-02 04:35:00 | AAPL | Stock | 109.69 | 109.7 | 109.66 | 109.7 | 1949.0 |
| 2020-11-02 04:40:00 | AAPL | Stock | 109.73 | 109.77 | 109.72 | 109.77 | 1007.0 |
| 2020-11-02 04:45:00 | AAPL | Stock | 109.77 | 109.77 | 109.46 | 109.46 | 6650.0 |
| 2020-11-02 04:50:00 | AAPL | Stock | 109.46 | 109.65 | 109.46 | 109.63 | 1908.0 |
| 2020-11-02 04:55:00 | AAPL | Stock | 109.75 | 109.75 | 109.64 | 109.64 | 1526.0 |
| 2020-11-02 05:00:00 | AAPL | Stock | 109.65 | 109.8 | 109.65 | 109.8 | 3731.0 |
| 2020-11-02 05:05:00 | AAPL | Stock | 109.78 | 109.85 | 109.75 | 109.75 | 1931.0 |
| 2020-11-02 05:10:00 | AAPL | Stock | 109.69 | 109.69 | 109.59 | 109.61 | 892.0 |
| 2020-11-02 05:15:00 | AAPL | Stock | 109.74 | 109.9 | 109.7 | 109.7 | 1614.0 |
| 2020-11-02 05:20:00 | AAPL | Stock | 109.7 | 109.8 | 109.7 | 109.76 | 562.0 |
| 2020-11-02 05:25:00 | AAPL | Stock | 109.71 | 109.79 | 109.71 | 109.77 | 1144.0 |
| 2020-11-02 05:30:00 | AAPL | Stock | 109.77 | 109.79 | 109.74 | 109.74 | 3035.0 |
| 2020-11-02 05:35:00 | AAPL | Stock | 109.63 | 109.79 | 109.62 | 109.79 | 2796.0 |
| 2020-11-02 05:40:00 | AAPL | Stock | 109.8 | 109.84 | 109.63 | 109.63 | 4765.0 |
| 2020-11-02 05:45:00 | AAPL | Stock | 109.67 | 109.68 | 109.62 | 109.68 | 1164.0 |
| 2020-11-02 05:50:00 | AAPL | Stock | 109.67 | 109.97 | 109.67 | 109.96 | 3359.0 |
| 2020-11-02 05:55:00 | AAPL | Stock | 109.92 | 110.1 | 109.92 | 110.0 | 8478.0 |
| 2020-11-02 06:00:00 | AAPL | Stock | 109.99 | 109.99 | 109.87 | 109.9 | 1080.0 |
| 2020-11-02 06:05:00 | AAPL | Stock | 109.9 | 109.95 | 109.9 | 109.95 | 2771.0 |
| 2020-11-02 06:10:00 | AAPL | Stock | 109.95 | 110.04 | 109.84 | 109.95 | 4108.0 |
| 2020-11-02 06:15:00 | AAPL | Stock | 109.99 | 110.0 | 109.9 | 109.96 | 4039.0 |
| 2020-11-02 06:20:00 | AAPL | Stock | 110.0 | 110.0 | 109.96 | 109.96 | 855.0 |
| 2020-11-02 06:25:00 | AAPL | Stock | 109.98 | 109.98 | 109.68 | 109.83 | 4342.0 |
| 2020-11-02 06:30:00 | AAPL | Stock | 109.83 | 109.83 | 109.71 | 109.8 | 1718.0 |
| 2020-11-02 06:35:00 | AAPL | Stock | 109.79 | 109.98 | 109.76 | 109.95 | 3028.0 |
| 2020-11-02 06:40:00 | AAPL | Stock | 109.94 | 109.94 | 109.82 | 109.87 | 2562.0 |
| 2020-11-02 06:45:00 | AAPL | Stock | 109.85 | 109.85 | 109.65 | 109.73 | 6421.0 |
| 2020-11-02 06:50:00 | AAPL | Stock | 109.8 | 109.8 | 109.5 | 109.65 | 10016.0 |
| 2020-11-02 06:55:00 | AAPL | Stock | 109.62 | 109.69 | 109.6 | 109.69 | 1526.0 |
| 2020-11-02 07:00:00 | AAPL | Stock | 109.67 | 109.87 | 109.34 | 109.4 | 92731.0 |
| 2020-11-02 07:05:00 | AAPL | Stock | 109.4 | 109.45 | 109.27 | 109.43 | 31398.0 |
| 2020-11-02 07:10:00 | AAPL | Stock | 109.42 | 109.66 | 109.42 | 109.62 | 58864.0 |
| 2020-11-02 07:15:00 | AAPL | Stock | 109.6 | 109.6 | 109.42 | 109.49 | 14877.0 |
| 2020-11-02 07:20:00 | AAPL | Stock | 109.5 | 109.5 | 109.44 | 109.44 | 5648.0 |
| 2020-11-02 07:25:00 | AAPL | Stock | 109.45 | 109.51 | 109.41 | 109.47 | 33313.0 |
| 2020-11-02 07:30:00 | AAPL | Stock | 109.49 | 109.68 | 109.47 | 109.67 | 28876.0 |
| 2020-11-02 07:35:00 | AAPL | Stock | 109.66 | 109.66 | 109.45 | 109.5 | 47032.0 |
| 2020-11-02 07:40:00 | AAPL | Stock | 109.55 | 109.68 | 109.45 | 109.66 | 30028.0 |
| 2020-11-02 07:45:00 | AAPL | Stock | 109.62 | 109.64 | 109.49 | 109.57 | 12460.0 |
| 2020-11-02 07:50:00 | AAPL | Stock | 109.57 | 109.58 | 109.3 | 109.4 | 53689.0 |
| 2020-11-02 07:55:00 | AAPL | Stock | 109.43 | 109.52 | 109.41 | 109.5 | 20184.0 |
| 2020-11-02 08:00:00 | AAPL | Stock | 109.45 | 109.8 | 109.27 | 109.37 | 350935.0 |
| 2020-11-02 08:05:00 | AAPL | Stock | 109.37 | 109.41 | 109.22 | 109.4 | 69900.0 |
> showing 50 of 404,889 rows — these rows as CSV