PREVIEW / stock_5min / 2022-03-09
file: by_date/stock_5min/2022/2022-03-09.parquet size: 7.5 MB rows: 463,903 symbols: 2,529
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-03-09 04:00:00 | AAPL | Stock | 157.94 | 160.28 | 157.94 | 160.18 | 6259.0 |
| 2022-03-09 04:05:00 | AAPL | Stock | 160.18 | 160.18 | 159.87 | 159.87 | 2062.0 |
| 2022-03-09 04:10:00 | AAPL | Stock | 159.94 | 160.11 | 159.63 | 159.75 | 3592.0 |
| 2022-03-09 04:15:00 | AAPL | Stock | 159.96 | 160.1 | 159.9 | 160.08 | 4297.0 |
| 2022-03-09 04:20:00 | AAPL | Stock | 160.08 | 160.3 | 160.08 | 160.27 | 5393.0 |
| 2022-03-09 04:25:00 | AAPL | Stock | 160.27 | 160.32 | 160.19 | 160.22 | 3024.0 |
| 2022-03-09 04:30:00 | AAPL | Stock | 160.15 | 160.45 | 160.15 | 160.45 | 4432.0 |
| 2022-03-09 04:35:00 | AAPL | Stock | 160.32 | 160.72 | 160.32 | 160.72 | 1813.0 |
| 2022-03-09 04:40:00 | AAPL | Stock | 160.95 | 160.97 | 160.75 | 160.78 | 2264.0 |
| 2022-03-09 04:45:00 | AAPL | Stock | 160.76 | 160.76 | 160.65 | 160.7 | 6016.0 |
| 2022-03-09 04:50:00 | AAPL | Stock | 160.75 | 161.02 | 160.75 | 160.9 | 5025.0 |
| 2022-03-09 04:55:00 | AAPL | Stock | 160.84 | 160.93 | 160.84 | 160.93 | 1561.0 |
| 2022-03-09 05:00:00 | AAPL | Stock | 160.99 | 160.99 | 160.85 | 160.99 | 10475.0 |
| 2022-03-09 05:05:00 | AAPL | Stock | 160.95 | 161.1 | 160.95 | 161.0 | 4119.0 |
| 2022-03-09 05:10:00 | AAPL | Stock | 161.2 | 161.34 | 161.16 | 161.3 | 4343.0 |
| 2022-03-09 05:15:00 | AAPL | Stock | 161.25 | 161.4 | 161.24 | 161.4 | 5865.0 |
| 2022-03-09 05:20:00 | AAPL | Stock | 161.28 | 161.3 | 161.07 | 161.2 | 2427.0 |
| 2022-03-09 05:25:00 | AAPL | Stock | 161.36 | 161.37 | 161.0 | 161.37 | 2445.0 |
| 2022-03-09 05:30:00 | AAPL | Stock | 161.2 | 161.2 | 161.2 | 161.2 | 1144.0 |
| 2022-03-09 05:35:00 | AAPL | Stock | 161.4 | 161.5 | 161.4 | 161.44 | 1569.0 |
| 2022-03-09 05:40:00 | AAPL | Stock | 161.3 | 161.32 | 161.2 | 161.32 | 1725.0 |
| 2022-03-09 05:45:00 | AAPL | Stock | 161.17 | 161.17 | 160.88 | 160.88 | 11709.0 |
| 2022-03-09 05:50:00 | AAPL | Stock | 160.88 | 161.0 | 160.78 | 160.91 | 2078.0 |
| 2022-03-09 05:55:00 | AAPL | Stock | 160.77 | 160.78 | 160.52 | 160.52 | 1552.0 |
| 2022-03-09 06:00:00 | AAPL | Stock | 160.99 | 160.99 | 160.67 | 160.82 | 444.0 |
| 2022-03-09 06:05:00 | AAPL | Stock | 160.82 | 160.82 | 160.79 | 160.79 | 300.0 |
| 2022-03-09 06:10:00 | AAPL | Stock | 160.67 | 160.67 | 160.57 | 160.57 | 369.0 |
| 2022-03-09 06:15:00 | AAPL | Stock | 160.65 | 161.25 | 160.65 | 161.01 | 420.0 |
| 2022-03-09 06:20:00 | AAPL | Stock | 160.92 | 161.19 | 160.88 | 161.0 | 3319.0 |
| 2022-03-09 06:25:00 | AAPL | Stock | 161.16 | 161.2 | 161.04 | 161.05 | 1319.0 |
| 2022-03-09 06:30:00 | AAPL | Stock | 160.96 | 161.0 | 160.96 | 161.0 | 1131.0 |
| 2022-03-09 06:35:00 | AAPL | Stock | 161.0 | 161.21 | 160.89 | 161.16 | 5702.0 |
| 2022-03-09 06:40:00 | AAPL | Stock | 160.9 | 160.9 | 160.67 | 160.67 | 6434.0 |
| 2022-03-09 06:45:00 | AAPL | Stock | 160.73 | 160.74 | 160.69 | 160.7 | 1127.0 |
| 2022-03-09 06:50:00 | AAPL | Stock | 160.89 | 160.91 | 160.72 | 160.72 | 9891.0 |
| 2022-03-09 06:55:00 | AAPL | Stock | 160.7 | 160.73 | 160.58 | 160.72 | 4511.0 |
| 2022-03-09 07:00:00 | AAPL | Stock | 160.64 | 160.8 | 160.2 | 160.49 | 27400.0 |
| 2022-03-09 07:05:00 | AAPL | Stock | 160.35 | 160.52 | 160.31 | 160.5 | 16486.0 |
| 2022-03-09 07:10:00 | AAPL | Stock | 160.42 | 160.5 | 160.4 | 160.5 | 4981.0 |
| 2022-03-09 07:15:00 | AAPL | Stock | 160.48 | 160.6 | 160.45 | 160.56 | 12758.0 |
| 2022-03-09 07:20:00 | AAPL | Stock | 160.58 | 160.72 | 160.56 | 160.56 | 7348.0 |
| 2022-03-09 07:25:00 | AAPL | Stock | 160.51 | 160.51 | 160.46 | 160.49 | 1740.0 |
| 2022-03-09 07:30:00 | AAPL | Stock | 160.5 | 160.68 | 160.42 | 160.5 | 29888.0 |
| 2022-03-09 07:35:00 | AAPL | Stock | 160.46 | 160.77 | 160.38 | 160.43 | 14982.0 |
| 2022-03-09 07:40:00 | AAPL | Stock | 160.44 | 160.49 | 160.4 | 160.49 | 5267.0 |
| 2022-03-09 07:45:00 | AAPL | Stock | 160.52 | 160.7 | 160.45 | 160.45 | 8464.0 |
| 2022-03-09 07:50:00 | AAPL | Stock | 160.53 | 160.77 | 160.5 | 160.6 | 6396.0 |
| 2022-03-09 07:55:00 | AAPL | Stock | 160.66 | 160.87 | 160.52 | 160.73 | 17863.0 |
| 2022-03-09 08:00:00 | AAPL | Stock | 157.44 | 161.12 | 157.44 | 160.85 | 344533.0 |
| 2022-03-09 08:05:00 | AAPL | Stock | 160.85 | 160.98 | 160.78 | 160.9 | 38910.0 |
> showing 50 of 463,903 rows — these rows as CSV