PREVIEW / stock_5min / 2022-10-03
file: by_date/stock_5min/2022/2022-10-03.parquet size: 6.9 MB rows: 427,920 symbols: 2,264
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-10-03 04:00:00 | AAPL | Stock | 137.21 | 137.21 | 136.7 | 136.8 | 21571.0 |
| 2022-10-03 04:05:00 | AAPL | Stock | 136.75 | 136.75 | 136.4 | 136.49 | 19475.0 |
| 2022-10-03 04:10:00 | AAPL | Stock | 136.45 | 136.65 | 136.45 | 136.65 | 10675.0 |
| 2022-10-03 04:15:00 | AAPL | Stock | 136.68 | 136.79 | 136.66 | 136.66 | 3597.0 |
| 2022-10-03 04:20:00 | AAPL | Stock | 136.78 | 136.88 | 136.73 | 136.83 | 3720.0 |
| 2022-10-03 04:25:00 | AAPL | Stock | 136.81 | 136.81 | 136.67 | 136.73 | 1131.0 |
| 2022-10-03 04:30:00 | AAPL | Stock | 136.71 | 136.97 | 136.68 | 136.96 | 3458.0 |
| 2022-10-03 04:35:00 | AAPL | Stock | 136.91 | 136.91 | 136.81 | 136.85 | 1875.0 |
| 2022-10-03 04:40:00 | AAPL | Stock | 136.88 | 136.92 | 136.88 | 136.92 | 1120.0 |
| 2022-10-03 04:45:00 | AAPL | Stock | 136.94 | 136.95 | 136.84 | 136.94 | 1986.0 |
| 2022-10-03 04:50:00 | AAPL | Stock | 136.92 | 136.94 | 136.89 | 136.94 | 3976.0 |
| 2022-10-03 04:55:00 | AAPL | Stock | 136.95 | 136.98 | 136.82 | 136.97 | 2525.0 |
| 2022-10-03 05:00:00 | AAPL | Stock | 136.9 | 136.9 | 136.71 | 136.79 | 3772.0 |
| 2022-10-03 05:05:00 | AAPL | Stock | 136.72 | 136.72 | 136.57 | 136.65 | 3633.0 |
| 2022-10-03 05:10:00 | AAPL | Stock | 136.65 | 136.77 | 136.61 | 136.77 | 1723.0 |
| 2022-10-03 05:15:00 | AAPL | Stock | 136.79 | 136.81 | 136.79 | 136.81 | 3432.0 |
| 2022-10-03 05:20:00 | AAPL | Stock | 136.88 | 137.1 | 136.88 | 137.1 | 14353.0 |
| 2022-10-03 05:25:00 | AAPL | Stock | 137.09 | 137.1 | 136.91 | 137.01 | 2877.0 |
| 2022-10-03 05:30:00 | AAPL | Stock | 137.12 | 137.34 | 137.12 | 137.33 | 3471.0 |
| 2022-10-03 05:35:00 | AAPL | Stock | 137.33 | 137.33 | 137.21 | 137.24 | 416.0 |
| 2022-10-03 05:40:00 | AAPL | Stock | 137.27 | 137.27 | 137.11 | 137.12 | 6095.0 |
| 2022-10-03 05:45:00 | AAPL | Stock | 137.13 | 137.2 | 137.12 | 137.2 | 3148.0 |
| 2022-10-03 05:50:00 | AAPL | Stock | 137.28 | 137.45 | 137.23 | 137.41 | 9047.0 |
| 2022-10-03 05:55:00 | AAPL | Stock | 137.3 | 137.38 | 137.27 | 137.27 | 3586.0 |
| 2022-10-03 06:00:00 | AAPL | Stock | 137.34 | 137.43 | 137.34 | 137.43 | 702.0 |
| 2022-10-03 06:05:00 | AAPL | Stock | 137.37 | 137.4 | 137.36 | 137.37 | 2525.0 |
| 2022-10-03 06:10:00 | AAPL | Stock | 137.37 | 137.59 | 137.36 | 137.46 | 7177.0 |
| 2022-10-03 06:15:00 | AAPL | Stock | 137.3 | 137.35 | 137.24 | 137.35 | 1060.0 |
| 2022-10-03 06:20:00 | AAPL | Stock | 137.38 | 137.41 | 137.3 | 137.41 | 2540.0 |
| 2022-10-03 06:25:00 | AAPL | Stock | 137.41 | 137.64 | 137.41 | 137.56 | 9553.0 |
| 2022-10-03 06:30:00 | AAPL | Stock | 137.49 | 137.68 | 137.48 | 137.57 | 6317.0 |
| 2022-10-03 06:35:00 | AAPL | Stock | 137.5 | 137.5 | 137.41 | 137.41 | 1305.0 |
| 2022-10-03 06:40:00 | AAPL | Stock | 137.33 | 137.33 | 137.32 | 137.32 | 700.0 |
| 2022-10-03 06:45:00 | AAPL | Stock | 137.31 | 137.79 | 137.21 | 137.79 | 8216.0 |
| 2022-10-03 06:50:00 | AAPL | Stock | 137.84 | 137.84 | 137.51 | 137.6 | 1312.0 |
| 2022-10-03 06:55:00 | AAPL | Stock | 137.59 | 137.82 | 137.59 | 137.73 | 2903.0 |
| 2022-10-03 07:00:00 | AAPL | Stock | 137.65 | 137.81 | 137.59 | 137.6 | 14290.0 |
| 2022-10-03 07:05:00 | AAPL | Stock | 137.68 | 137.75 | 137.62 | 137.62 | 12611.0 |
| 2022-10-03 07:10:00 | AAPL | Stock | 137.61 | 137.67 | 137.5 | 137.67 | 12825.0 |
| 2022-10-03 07:15:00 | AAPL | Stock | 137.67 | 137.8 | 137.66 | 137.66 | 10995.0 |
| 2022-10-03 07:20:00 | AAPL | Stock | 137.64 | 137.65 | 137.49 | 137.55 | 12357.0 |
| 2022-10-03 07:25:00 | AAPL | Stock | 137.55 | 137.58 | 137.51 | 137.58 | 3150.0 |
| 2022-10-03 07:30:00 | AAPL | Stock | 137.58 | 137.74 | 137.57 | 137.74 | 4069.0 |
| 2022-10-03 07:35:00 | AAPL | Stock | 137.68 | 137.86 | 137.68 | 137.75 | 8867.0 |
| 2022-10-03 07:40:00 | AAPL | Stock | 137.78 | 137.83 | 137.77 | 137.8 | 19984.0 |
| 2022-10-03 07:45:00 | AAPL | Stock | 137.8 | 137.97 | 137.65 | 137.65 | 33060.0 |
| 2022-10-03 07:50:00 | AAPL | Stock | 137.65 | 137.71 | 137.54 | 137.7 | 6581.0 |
| 2022-10-03 07:55:00 | AAPL | Stock | 137.67 | 138.11 | 137.66 | 138.11 | 19190.0 |
| 2022-10-03 08:00:00 | AAPL | Stock | 137.58 | 138.33 | 136.7015 | 138.12 | 189414.0 |
| 2022-10-03 08:05:00 | AAPL | Stock | 138.12 | 138.2 | 137.99 | 138.15 | 61973.0 |
> showing 50 of 427,920 rows — these rows as CSV