PREVIEW / stock_5min / 2021-06-04
file: by_date/stock_5min/2021/2021-06-04.parquet size: 7.3 MB rows: 450,524 symbols: 2,962
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-06-04 04:10:00 | AAPL | Stock | 123.52 | 123.52 | 123.52 | 123.52 | 383.0 |
| 2021-06-04 04:15:00 | AAPL | Stock | 123.59 | 123.6 | 123.59 | 123.6 | 500.0 |
| 2021-06-04 04:25:00 | AAPL | Stock | 123.52 | 123.53 | 123.51 | 123.53 | 1005.0 |
| 2021-06-04 04:30:00 | AAPL | Stock | 123.53 | 123.53 | 123.53 | 123.53 | 190.0 |
| 2021-06-04 04:35:00 | AAPL | Stock | 123.48 | 123.48 | 123.48 | 123.48 | 151.0 |
| 2021-06-04 04:40:00 | AAPL | Stock | 123.49 | 123.49 | 123.49 | 123.49 | 100.0 |
| 2021-06-04 04:45:00 | AAPL | Stock | 123.45 | 123.45 | 123.45 | 123.45 | 240.0 |
| 2021-06-04 05:00:00 | AAPL | Stock | 123.5 | 123.55 | 123.5 | 123.54 | 921.0 |
| 2021-06-04 05:10:00 | AAPL | Stock | 123.5 | 123.5 | 123.5 | 123.5 | 120.0 |
| 2021-06-04 05:15:00 | AAPL | Stock | 123.55 | 123.55 | 123.55 | 123.55 | 140.0 |
| 2021-06-04 05:25:00 | AAPL | Stock | 123.52 | 123.52 | 123.52 | 123.52 | 922.0 |
| 2021-06-04 05:35:00 | AAPL | Stock | 123.56 | 123.57 | 123.55 | 123.57 | 2005.0 |
| 2021-06-04 05:40:00 | AAPL | Stock | 123.56 | 123.56 | 123.56 | 123.56 | 496.0 |
| 2021-06-04 05:45:00 | AAPL | Stock | 123.56 | 123.59 | 123.56 | 123.59 | 618.0 |
| 2021-06-04 05:55:00 | AAPL | Stock | 123.68 | 123.72 | 123.68 | 123.72 | 686.0 |
| 2021-06-04 06:00:00 | AAPL | Stock | 123.77 | 123.77 | 123.77 | 123.77 | 124.0 |
| 2021-06-04 06:10:00 | AAPL | Stock | 123.73 | 123.73 | 123.67 | 123.67 | 233.0 |
| 2021-06-04 06:15:00 | AAPL | Stock | 123.69 | 123.69 | 123.69 | 123.69 | 1121.0 |
| 2021-06-04 06:20:00 | AAPL | Stock | 123.69 | 123.69 | 123.69 | 123.69 | 344.0 |
| 2021-06-04 06:25:00 | AAPL | Stock | 123.73 | 123.73 | 123.73 | 123.73 | 223.0 |
| 2021-06-04 06:30:00 | AAPL | Stock | 123.7 | 123.7 | 123.31 | 123.34 | 1226.0 |
| 2021-06-04 06:35:00 | AAPL | Stock | 123.4 | 123.59 | 123.4 | 123.51 | 1105.0 |
| 2021-06-04 06:40:00 | AAPL | Stock | 123.54 | 123.54 | 123.54 | 123.54 | 295.0 |
| 2021-06-04 06:45:00 | AAPL | Stock | 123.55 | 123.65 | 123.55 | 123.65 | 349.0 |
| 2021-06-04 06:55:00 | AAPL | Stock | 123.71 | 123.71 | 123.7 | 123.7 | 1493.0 |
| 2021-06-04 07:00:00 | AAPL | Stock | 123.67 | 123.78 | 123.66 | 123.76 | 7544.0 |
| 2021-06-04 07:05:00 | AAPL | Stock | 123.76 | 123.84 | 123.75 | 123.82 | 7868.0 |
| 2021-06-04 07:10:00 | AAPL | Stock | 123.8 | 123.86 | 123.75 | 123.85 | 4564.0 |
| 2021-06-04 07:15:00 | AAPL | Stock | 123.87 | 123.87 | 123.83 | 123.84 | 1815.0 |
| 2021-06-04 07:20:00 | AAPL | Stock | 123.85 | 123.87 | 123.84 | 123.86 | 5500.0 |
| 2021-06-04 07:25:00 | AAPL | Stock | 123.85 | 123.89 | 123.81 | 123.88 | 15061.0 |
| 2021-06-04 07:30:00 | AAPL | Stock | 123.89 | 123.93 | 123.85 | 123.85 | 3432.0 |
| 2021-06-04 07:35:00 | AAPL | Stock | 123.87 | 123.91 | 123.87 | 123.9 | 2131.0 |
| 2021-06-04 07:40:00 | AAPL | Stock | 123.88 | 123.88 | 123.78 | 123.78 | 5243.0 |
| 2021-06-04 07:45:00 | AAPL | Stock | 123.77 | 123.83 | 123.77 | 123.83 | 6133.0 |
| 2021-06-04 07:50:00 | AAPL | Stock | 123.86 | 123.97 | 123.84 | 123.97 | 15960.0 |
| 2021-06-04 07:55:00 | AAPL | Stock | 123.97 | 123.98 | 123.95 | 123.98 | 15811.0 |
| 2021-06-04 08:00:00 | AAPL | Stock | 123.7299 | 124.0 | 123.232 | 123.98 | 123197.0 |
| 2021-06-04 08:05:00 | AAPL | Stock | 123.98 | 124.01 | 123.95 | 124.0 | 20866.0 |
| 2021-06-04 08:10:00 | AAPL | Stock | 123.99 | 124.02 | 123.93 | 123.93 | 12742.0 |
| 2021-06-04 08:15:00 | AAPL | Stock | 123.96 | 123.99 | 123.92 | 123.95 | 7100.0 |
| 2021-06-04 08:20:00 | AAPL | Stock | 123.94 | 123.97 | 123.87 | 123.88 | 29923.0 |
| 2021-06-04 08:25:00 | AAPL | Stock | 123.92 | 123.96 | 123.9 | 123.91 | 14815.0 |
| 2021-06-04 08:30:00 | AAPL | Stock | 123.9 | 124.28 | 123.9 | 124.23 | 150954.0 |
| 2021-06-04 08:35:00 | AAPL | Stock | 124.25 | 124.27 | 123.8 | 123.94 | 178619.0 |
| 2021-06-04 08:40:00 | AAPL | Stock | 123.9 | 124.15 | 123.88 | 124.15 | 53492.0 |
| 2021-06-04 08:45:00 | AAPL | Stock | 124.19 | 124.21 | 124.04 | 124.16 | 54594.0 |
| 2021-06-04 08:50:00 | AAPL | Stock | 124.16 | 124.23 | 124.1 | 124.15 | 31899.0 |
| 2021-06-04 08:55:00 | AAPL | Stock | 124.19 | 124.26 | 124.15 | 124.15 | 51195.0 |
| 2021-06-04 09:00:00 | AAPL | Stock | 124.15 | 124.28 | 124.15 | 124.22 | 67115.0 |
> showing 50 of 450,524 rows — these rows as CSV