PREVIEW / stock_5min / 2020-10-02
file: by_date/stock_5min/2020/2020-10-02.parquet size: 6.6 MB rows: 413,591 symbols: 2,504
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-10-02 04:00:00 | AAPL | Stock | 114.65 | 114.7 | 113.78 | 114.03 | 45614.0 |
| 2020-10-02 04:05:00 | AAPL | Stock | 114.03 | 114.14 | 113.81 | 113.82 | 13420.0 |
| 2020-10-02 04:10:00 | AAPL | Stock | 113.82 | 113.83 | 113.62 | 113.8 | 13886.0 |
| 2020-10-02 04:15:00 | AAPL | Stock | 113.76 | 114.03 | 113.75 | 114.03 | 9939.0 |
| 2020-10-02 04:20:00 | AAPL | Stock | 114.03 | 114.2 | 114.0 | 114.2 | 6252.0 |
| 2020-10-02 04:25:00 | AAPL | Stock | 114.18 | 114.33 | 114.15 | 114.31 | 6122.0 |
| 2020-10-02 04:30:00 | AAPL | Stock | 114.3 | 114.3 | 114.07 | 114.1 | 8748.0 |
| 2020-10-02 04:35:00 | AAPL | Stock | 114.15 | 114.34 | 114.15 | 114.25 | 3632.0 |
| 2020-10-02 04:40:00 | AAPL | Stock | 114.25 | 114.32 | 114.2 | 114.22 | 6170.0 |
| 2020-10-02 04:45:00 | AAPL | Stock | 114.21 | 114.21 | 114.1 | 114.1 | 9160.0 |
| 2020-10-02 04:50:00 | AAPL | Stock | 114.09 | 114.32 | 114.09 | 114.29 | 4908.0 |
| 2020-10-02 04:55:00 | AAPL | Stock | 114.29 | 114.63 | 114.27 | 114.27 | 11382.0 |
| 2020-10-02 05:00:00 | AAPL | Stock | 114.2 | 114.4 | 114.09 | 114.38 | 14504.0 |
| 2020-10-02 05:05:00 | AAPL | Stock | 114.39 | 114.57 | 114.2 | 114.2 | 7475.0 |
| 2020-10-02 05:10:00 | AAPL | Stock | 114.38 | 114.38 | 114.2 | 114.2 | 3106.0 |
| 2020-10-02 05:15:00 | AAPL | Stock | 114.23 | 114.26 | 114.08 | 114.08 | 7534.0 |
| 2020-10-02 05:20:00 | AAPL | Stock | 114.08 | 114.21 | 113.6 | 113.7 | 10670.0 |
| 2020-10-02 05:25:00 | AAPL | Stock | 113.72 | 113.83 | 113.5 | 113.54 | 17192.0 |
| 2020-10-02 05:30:00 | AAPL | Stock | 113.54 | 114.0 | 113.54 | 113.6 | 14320.0 |
| 2020-10-02 05:35:00 | AAPL | Stock | 113.61 | 113.73 | 113.44 | 113.48 | 25893.0 |
| 2020-10-02 05:40:00 | AAPL | Stock | 113.49 | 113.5 | 113.23 | 113.25 | 17888.0 |
| 2020-10-02 05:45:00 | AAPL | Stock | 113.25 | 113.67 | 113.25 | 113.5 | 10697.0 |
| 2020-10-02 05:50:00 | AAPL | Stock | 113.5 | 113.65 | 113.5 | 113.6 | 4500.0 |
| 2020-10-02 05:55:00 | AAPL | Stock | 113.58 | 113.58 | 113.46 | 113.46 | 2913.0 |
| 2020-10-02 06:00:00 | AAPL | Stock | 113.5 | 113.5 | 113.36 | 113.4 | 5428.0 |
| 2020-10-02 06:05:00 | AAPL | Stock | 113.4 | 113.77 | 113.37 | 113.5 | 24876.0 |
| 2020-10-02 06:10:00 | AAPL | Stock | 113.5 | 113.55 | 113.2 | 113.3 | 7043.0 |
| 2020-10-02 06:15:00 | AAPL | Stock | 113.31 | 113.32 | 113.0 | 113.15 | 18461.0 |
| 2020-10-02 06:20:00 | AAPL | Stock | 113.14 | 113.44 | 113.08 | 113.32 | 7352.0 |
| 2020-10-02 06:25:00 | AAPL | Stock | 113.32 | 113.86 | 113.32 | 113.67 | 13095.0 |
| 2020-10-02 06:30:00 | AAPL | Stock | 113.66 | 114.38 | 113.54 | 114.25 | 41445.0 |
| 2020-10-02 06:35:00 | AAPL | Stock | 114.25 | 114.25 | 113.84 | 113.92 | 11705.0 |
| 2020-10-02 06:40:00 | AAPL | Stock | 113.98 | 114.02 | 113.85 | 114.02 | 4341.0 |
| 2020-10-02 06:45:00 | AAPL | Stock | 114.09 | 114.09 | 113.83 | 113.9 | 4178.0 |
| 2020-10-02 06:50:00 | AAPL | Stock | 113.8 | 114.17 | 113.8 | 114.17 | 1971.0 |
| 2020-10-02 06:55:00 | AAPL | Stock | 114.17 | 114.17 | 113.95 | 114.0 | 2876.0 |
| 2020-10-02 07:00:00 | AAPL | Stock | 114.0 | 114.2 | 113.29 | 113.69 | 187221.0 |
| 2020-10-02 07:05:00 | AAPL | Stock | 113.66 | 113.7 | 113.56 | 113.57 | 70657.0 |
| 2020-10-02 07:10:00 | AAPL | Stock | 113.58 | 113.75 | 113.57 | 113.75 | 61109.0 |
| 2020-10-02 07:15:00 | AAPL | Stock | 113.73 | 113.76 | 113.58 | 113.63 | 60105.0 |
| 2020-10-02 07:20:00 | AAPL | Stock | 113.62 | 113.62 | 113.25 | 113.29 | 74278.0 |
| 2020-10-02 07:25:00 | AAPL | Stock | 113.29 | 113.33 | 113.15 | 113.19 | 118948.0 |
| 2020-10-02 07:30:00 | AAPL | Stock | 113.19 | 113.4 | 113.14 | 113.25 | 48609.0 |
| 2020-10-02 07:35:00 | AAPL | Stock | 113.25 | 113.32 | 113.19 | 113.21 | 40035.0 |
| 2020-10-02 07:40:00 | AAPL | Stock | 113.22 | 113.23 | 113.02 | 113.02 | 51817.0 |
| 2020-10-02 07:45:00 | AAPL | Stock | 113.05 | 113.16 | 113.0 | 113.16 | 83326.0 |
| 2020-10-02 07:50:00 | AAPL | Stock | 113.16 | 113.31 | 113.1 | 113.15 | 82571.0 |
| 2020-10-02 07:55:00 | AAPL | Stock | 113.1 | 113.17 | 112.8 | 112.92 | 125241.0 |
| 2020-10-02 08:00:00 | AAPL | Stock | 112.96 | 117.08 | 112.79 | 113.09 | 676783.0 |
| 2020-10-02 08:05:00 | AAPL | Stock | 113.08 | 113.4 | 113.05 | 113.32 | 131920.0 |
> showing 50 of 413,591 rows — these rows as CSV