PREVIEW / stock_5min / 2022-01-27
file: by_date/stock_5min/2022/2022-01-27.parquet size: 7.5 MB rows: 464,345 symbols: 2,697
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 |
|---|---|---|---|---|---|---|---|
| 2022-01-27 04:00:00 | AAPL | Stock | 160.33 | 160.36 | 159.28 | 160.1 | 23702.0 |
| 2022-01-27 04:05:00 | AAPL | Stock | 160.1 | 160.15 | 159.99 | 159.99 | 3907.0 |
| 2022-01-27 04:10:00 | AAPL | Stock | 159.88 | 160.07 | 159.67 | 160.07 | 6477.0 |
| 2022-01-27 04:15:00 | AAPL | Stock | 160.19 | 160.22 | 160.0 | 160.22 | 2985.0 |
| 2022-01-27 04:20:00 | AAPL | Stock | 160.2 | 160.38 | 160.04 | 160.38 | 3453.0 |
| 2022-01-27 04:25:00 | AAPL | Stock | 160.38 | 160.5 | 160.38 | 160.48 | 1381.0 |
| 2022-01-27 04:30:00 | AAPL | Stock | 160.31 | 160.34 | 160.12 | 160.34 | 2362.0 |
| 2022-01-27 04:35:00 | AAPL | Stock | 160.32 | 160.49 | 160.21 | 160.37 | 1381.0 |
| 2022-01-27 04:45:00 | AAPL | Stock | 160.68 | 160.76 | 160.63 | 160.65 | 1597.0 |
| 2022-01-27 04:50:00 | AAPL | Stock | 160.66 | 160.9 | 160.66 | 160.81 | 1737.0 |
| 2022-01-27 04:55:00 | AAPL | Stock | 160.89 | 160.92 | 160.89 | 160.92 | 200.0 |
| 2022-01-27 05:00:00 | AAPL | Stock | 160.8 | 160.8 | 160.78 | 160.78 | 923.0 |
| 2022-01-27 05:05:00 | AAPL | Stock | 161.15 | 161.3 | 161.1 | 161.1 | 4353.0 |
| 2022-01-27 05:10:00 | AAPL | Stock | 161.09 | 161.19 | 160.85 | 160.89 | 2387.0 |
| 2022-01-27 05:15:00 | AAPL | Stock | 160.9 | 160.98 | 160.4 | 160.6 | 1219.0 |
| 2022-01-27 05:20:00 | AAPL | Stock | 160.56 | 160.56 | 160.56 | 160.56 | 160.0 |
| 2022-01-27 05:25:00 | AAPL | Stock | 160.94 | 161.0 | 160.94 | 160.95 | 754.0 |
| 2022-01-27 05:30:00 | AAPL | Stock | 160.9 | 160.9 | 160.9 | 160.9 | 100.0 |
| 2022-01-27 05:35:00 | AAPL | Stock | 160.8 | 160.8 | 160.8 | 160.8 | 100.0 |
| 2022-01-27 05:40:00 | AAPL | Stock | 161.0 | 161.0 | 160.51 | 160.51 | 1246.0 |
| 2022-01-27 05:45:00 | AAPL | Stock | 160.57 | 160.61 | 160.4 | 160.4 | 2886.0 |
| 2022-01-27 05:50:00 | AAPL | Stock | 160.33 | 160.33 | 159.69 | 159.79 | 6240.0 |
| 2022-01-27 05:55:00 | AAPL | Stock | 159.52 | 159.65 | 159.33 | 159.53 | 8249.0 |
| 2022-01-27 06:00:00 | AAPL | Stock | 159.65 | 159.88 | 159.52 | 159.88 | 4193.0 |
| 2022-01-27 06:05:00 | AAPL | Stock | 159.9 | 160.08 | 159.9 | 160.01 | 2100.0 |
| 2022-01-27 06:10:00 | AAPL | Stock | 159.95 | 160.35 | 159.95 | 160.3 | 2111.0 |
| 2022-01-27 06:15:00 | AAPL | Stock | 160.36 | 160.5 | 160.25 | 160.25 | 1967.0 |
| 2022-01-27 06:20:00 | AAPL | Stock | 160.01 | 160.2 | 160.01 | 160.13 | 2239.0 |
| 2022-01-27 06:25:00 | AAPL | Stock | 160.35 | 161.04 | 160.35 | 161.0 | 2948.0 |
| 2022-01-27 06:30:00 | AAPL | Stock | 160.65 | 160.95 | 160.65 | 160.76 | 4277.0 |
| 2022-01-27 06:35:00 | AAPL | Stock | 160.98 | 160.98 | 160.41 | 160.41 | 5294.0 |
| 2022-01-27 06:40:00 | AAPL | Stock | 160.45 | 160.66 | 160.45 | 160.5 | 2252.0 |
| 2022-01-27 06:45:00 | AAPL | Stock | 160.5 | 160.6 | 160.23 | 160.6 | 2100.0 |
| 2022-01-27 06:50:00 | AAPL | Stock | 160.57 | 161.0 | 160.57 | 160.99 | 2362.0 |
| 2022-01-27 06:55:00 | AAPL | Stock | 160.85 | 161.1 | 160.85 | 161.0 | 7966.0 |
| 2022-01-27 07:00:00 | AAPL | Stock | 161.0 | 161.15 | 160.9 | 161.0 | 10487.0 |
| 2022-01-27 07:05:00 | AAPL | Stock | 161.0 | 161.0 | 160.75 | 160.95 | 6086.0 |
| 2022-01-27 07:10:00 | AAPL | Stock | 160.92 | 161.4 | 160.89 | 161.38 | 14328.0 |
| 2022-01-27 07:15:00 | AAPL | Stock | 161.33 | 161.44 | 161.0 | 161.0 | 10757.0 |
| 2022-01-27 07:20:00 | AAPL | Stock | 161.0 | 161.15 | 160.7 | 160.7 | 15702.0 |
| 2022-01-27 07:25:00 | AAPL | Stock | 160.77 | 161.0 | 160.74 | 160.86 | 12404.0 |
| 2022-01-27 07:30:00 | AAPL | Stock | 160.9 | 161.07 | 160.51 | 160.55 | 12204.0 |
| 2022-01-27 07:35:00 | AAPL | Stock | 160.6 | 161.0 | 160.57 | 160.92 | 13259.0 |
| 2022-01-27 07:40:00 | AAPL | Stock | 160.93 | 161.0 | 160.75 | 160.97 | 5575.0 |
| 2022-01-27 07:45:00 | AAPL | Stock | 161.1 | 161.3 | 161.04 | 161.25 | 11150.0 |
| 2022-01-27 07:50:00 | AAPL | Stock | 161.25 | 161.68 | 161.25 | 161.55 | 33085.0 |
| 2022-01-27 07:55:00 | AAPL | Stock | 161.57 | 161.7 | 161.55 | 161.56 | 9271.0 |
| 2022-01-27 08:00:00 | AAPL | Stock | 160.9999 | 161.95 | 159.321 | 161.5699 | 254930.0 |
| 2022-01-27 08:05:00 | AAPL | Stock | 161.5699 | 161.91 | 161.5699 | 161.91 | 39439.0 |
| 2022-01-27 08:10:00 | AAPL | Stock | 161.9 | 161.94 | 161.76 | 161.82 | 46798.0 |
> showing 50 of 464,345 rows — these rows as CSV