PREVIEW / stock_5min / 2021-07-26
file: by_date/stock_5min/2021/2021-07-26.parquet size: 7.3 MB rows: 451,045 symbols: 2,845
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 |
|---|---|---|---|---|---|---|---|
| 2021-07-26 04:00:00 | AAPL | Stock | 148.35 | 148.35 | 147.84 | 147.84 | 8306.0 |
| 2021-07-26 04:05:00 | AAPL | Stock | 147.8 | 147.86 | 147.4 | 147.43 | 15806.0 |
| 2021-07-26 04:10:00 | AAPL | Stock | 147.44 | 147.5 | 147.41 | 147.5 | 5923.0 |
| 2021-07-26 04:15:00 | AAPL | Stock | 147.45 | 147.53 | 147.43 | 147.5 | 9842.0 |
| 2021-07-26 04:20:00 | AAPL | Stock | 147.51 | 147.67 | 147.51 | 147.67 | 3287.0 |
| 2021-07-26 04:25:00 | AAPL | Stock | 147.63 | 147.63 | 147.46 | 147.46 | 2907.0 |
| 2021-07-26 04:30:00 | AAPL | Stock | 147.46 | 147.64 | 147.46 | 147.5 | 2768.0 |
| 2021-07-26 04:35:00 | AAPL | Stock | 147.5 | 147.6 | 147.5 | 147.6 | 2392.0 |
| 2021-07-26 04:40:00 | AAPL | Stock | 147.55 | 147.66 | 147.55 | 147.65 | 3583.0 |
| 2021-07-26 04:45:00 | AAPL | Stock | 147.7 | 147.7 | 147.5 | 147.5 | 6678.0 |
| 2021-07-26 04:50:00 | AAPL | Stock | 147.5 | 147.6 | 147.5 | 147.6 | 2897.0 |
| 2021-07-26 04:55:00 | AAPL | Stock | 147.55 | 147.61 | 147.55 | 147.6 | 1408.0 |
| 2021-07-26 05:00:00 | AAPL | Stock | 147.56 | 147.65 | 147.56 | 147.6 | 5222.0 |
| 2021-07-26 05:05:00 | AAPL | Stock | 147.6 | 147.7 | 147.6 | 147.69 | 3427.0 |
| 2021-07-26 05:10:00 | AAPL | Stock | 147.68 | 147.7 | 147.64 | 147.69 | 4073.0 |
| 2021-07-26 05:15:00 | AAPL | Stock | 147.7 | 147.82 | 147.7 | 147.82 | 2128.0 |
| 2021-07-26 05:20:00 | AAPL | Stock | 147.78 | 147.78 | 147.73 | 147.73 | 882.0 |
| 2021-07-26 05:25:00 | AAPL | Stock | 147.8 | 147.99 | 147.79 | 147.9 | 9066.0 |
| 2021-07-26 05:30:00 | AAPL | Stock | 147.8 | 147.85 | 147.8 | 147.85 | 1082.0 |
| 2021-07-26 05:35:00 | AAPL | Stock | 147.96 | 148.0 | 147.95 | 147.95 | 2689.0 |
| 2021-07-26 05:40:00 | AAPL | Stock | 147.9 | 147.9 | 147.9 | 147.9 | 786.0 |
| 2021-07-26 05:45:00 | AAPL | Stock | 147.9 | 148.0 | 147.85 | 148.0 | 3827.0 |
| 2021-07-26 05:50:00 | AAPL | Stock | 148.0 | 148.05 | 148.0 | 148.05 | 1586.0 |
| 2021-07-26 05:55:00 | AAPL | Stock | 147.96 | 148.0 | 147.95 | 147.95 | 1141.0 |
| 2021-07-26 06:00:00 | AAPL | Stock | 147.94 | 147.95 | 147.94 | 147.95 | 839.0 |
| 2021-07-26 06:05:00 | AAPL | Stock | 147.99 | 147.99 | 147.99 | 147.99 | 100.0 |
| 2021-07-26 06:10:00 | AAPL | Stock | 147.98 | 148.0 | 147.95 | 147.99 | 1228.0 |
| 2021-07-26 06:15:00 | AAPL | Stock | 148.0 | 148.0 | 148.0 | 148.0 | 350.0 |
| 2021-07-26 06:20:00 | AAPL | Stock | 147.99 | 147.99 | 147.99 | 147.99 | 168.0 |
| 2021-07-26 06:25:00 | AAPL | Stock | 147.89 | 147.9 | 147.89 | 147.9 | 753.0 |
| 2021-07-26 06:30:00 | AAPL | Stock | 147.92 | 147.92 | 147.82 | 147.85 | 867.0 |
| 2021-07-26 06:35:00 | AAPL | Stock | 147.94 | 147.94 | 147.92 | 147.92 | 350.0 |
| 2021-07-26 06:40:00 | AAPL | Stock | 147.86 | 147.86 | 147.85 | 147.85 | 310.0 |
| 2021-07-26 06:45:00 | AAPL | Stock | 147.81 | 147.81 | 147.8 | 147.8 | 300.0 |
| 2021-07-26 06:50:00 | AAPL | Stock | 147.77 | 147.79 | 147.77 | 147.79 | 1187.0 |
| 2021-07-26 06:55:00 | AAPL | Stock | 147.7 | 147.7 | 147.64 | 147.64 | 1638.0 |
| 2021-07-26 07:00:00 | AAPL | Stock | 147.7 | 148.02 | 147.7 | 148.02 | 17791.0 |
| 2021-07-26 07:05:00 | AAPL | Stock | 148.04 | 148.19 | 148.0 | 148.16 | 22104.0 |
| 2021-07-26 07:10:00 | AAPL | Stock | 148.15 | 148.22 | 148.15 | 148.22 | 16397.0 |
| 2021-07-26 07:15:00 | AAPL | Stock | 148.22 | 148.24 | 148.15 | 148.15 | 8414.0 |
| 2021-07-26 07:20:00 | AAPL | Stock | 148.12 | 148.2 | 148.05 | 148.2 | 6570.0 |
| 2021-07-26 07:25:00 | AAPL | Stock | 148.25 | 148.32 | 148.2 | 148.27 | 11563.0 |
| 2021-07-26 07:30:00 | AAPL | Stock | 148.29 | 148.33 | 148.27 | 148.3 | 5125.0 |
| 2021-07-26 07:35:00 | AAPL | Stock | 148.33 | 148.51 | 148.3 | 148.5 | 19155.0 |
| 2021-07-26 07:40:00 | AAPL | Stock | 148.48 | 148.48 | 148.361 | 148.37 | 13507.0 |
| 2021-07-26 07:45:00 | AAPL | Stock | 148.39 | 148.39 | 148.37 | 148.38 | 7461.0 |
| 2021-07-26 07:50:00 | AAPL | Stock | 148.38 | 148.38 | 148.3 | 148.3 | 15172.0 |
| 2021-07-26 07:55:00 | AAPL | Stock | 148.3 | 148.42 | 148.3 | 148.35 | 8286.0 |
| 2021-07-26 08:00:00 | AAPL | Stock | 148.4 | 148.55 | 147.77 | 148.5 | 181235.0 |
| 2021-07-26 08:05:00 | AAPL | Stock | 148.5 | 148.55 | 148.31 | 148.48 | 25891.0 |
> showing 50 of 451,045 rows — these rows as CSV