PREVIEW / stock_5min / 2022-10-04
file: by_date/stock_5min/2022/2022-10-04.parquet size: 7.0 MB rows: 438,284 symbols: 2,269
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-04 04:00:00 | AAPL | Stock | 144.02 | 145.27 | 144.02 | 144.9 | 9663.0 |
| 2022-10-04 04:05:00 | AAPL | Stock | 144.87 | 144.87 | 144.75 | 144.83 | 2551.0 |
| 2022-10-04 04:10:00 | AAPL | Stock | 144.82 | 144.92 | 144.8 | 144.86 | 3594.0 |
| 2022-10-04 04:15:00 | AAPL | Stock | 144.84 | 144.84 | 144.7 | 144.7 | 6118.0 |
| 2022-10-04 04:20:00 | AAPL | Stock | 144.63 | 144.63 | 144.51 | 144.55 | 2047.0 |
| 2022-10-04 04:25:00 | AAPL | Stock | 144.65 | 144.86 | 144.65 | 144.86 | 740.0 |
| 2022-10-04 04:30:00 | AAPL | Stock | 144.83 | 144.86 | 144.74 | 144.8 | 2200.0 |
| 2022-10-04 04:35:00 | AAPL | Stock | 144.87 | 144.95 | 144.82 | 144.82 | 3598.0 |
| 2022-10-04 04:40:00 | AAPL | Stock | 144.88 | 144.93 | 144.82 | 144.82 | 454.0 |
| 2022-10-04 04:45:00 | AAPL | Stock | 144.77 | 144.83 | 144.74 | 144.83 | 2288.0 |
| 2022-10-04 04:50:00 | AAPL | Stock | 144.83 | 144.83 | 144.76 | 144.76 | 457.0 |
| 2022-10-04 04:55:00 | AAPL | Stock | 144.8 | 144.96 | 144.8 | 144.96 | 1563.0 |
| 2022-10-04 05:00:00 | AAPL | Stock | 144.91 | 144.96 | 144.91 | 144.94 | 2934.0 |
| 2022-10-04 05:05:00 | AAPL | Stock | 144.86 | 144.97 | 144.8 | 144.87 | 3715.0 |
| 2022-10-04 05:10:00 | AAPL | Stock | 144.77 | 144.9 | 144.66 | 144.66 | 6959.0 |
| 2022-10-04 05:15:00 | AAPL | Stock | 144.78 | 144.78 | 144.78 | 144.78 | 100.0 |
| 2022-10-04 05:20:00 | AAPL | Stock | 144.78 | 144.78 | 144.78 | 144.78 | 150.0 |
| 2022-10-04 05:25:00 | AAPL | Stock | 144.75 | 144.98 | 144.72 | 144.98 | 13547.0 |
| 2022-10-04 05:30:00 | AAPL | Stock | 144.98 | 144.98 | 144.71 | 144.8 | 1000.0 |
| 2022-10-04 05:35:00 | AAPL | Stock | 144.8 | 144.89 | 144.8 | 144.89 | 1054.0 |
| 2022-10-04 05:40:00 | AAPL | Stock | 144.92 | 144.95 | 144.9 | 144.95 | 600.0 |
| 2022-10-04 05:45:00 | AAPL | Stock | 144.89 | 144.9 | 144.89 | 144.9 | 249.0 |
| 2022-10-04 05:50:00 | AAPL | Stock | 144.94 | 145.06 | 144.94 | 145.01 | 24099.0 |
| 2022-10-04 05:55:00 | AAPL | Stock | 145.1 | 145.19 | 145.1 | 145.15 | 2287.0 |
| 2022-10-04 06:00:00 | AAPL | Stock | 145.07 | 145.15 | 145.07 | 145.15 | 1119.0 |
| 2022-10-04 06:05:00 | AAPL | Stock | 145.12 | 145.12 | 145.04 | 145.09 | 2057.0 |
| 2022-10-04 06:10:00 | AAPL | Stock | 145.16 | 145.44 | 145.14 | 145.44 | 2290.0 |
| 2022-10-04 06:15:00 | AAPL | Stock | 145.31 | 145.56 | 145.31 | 145.56 | 5455.0 |
| 2022-10-04 06:20:00 | AAPL | Stock | 145.5 | 145.53 | 145.35 | 145.36 | 1652.0 |
| 2022-10-04 06:25:00 | AAPL | Stock | 145.4 | 145.42 | 145.35 | 145.39 | 1069.0 |
| 2022-10-04 06:30:00 | AAPL | Stock | 145.34 | 145.5 | 145.34 | 145.45 | 5714.0 |
| 2022-10-04 06:35:00 | AAPL | Stock | 145.41 | 145.46 | 145.33 | 145.4 | 2407.0 |
| 2022-10-04 06:40:00 | AAPL | Stock | 145.36 | 145.47 | 145.36 | 145.47 | 3969.0 |
| 2022-10-04 06:45:00 | AAPL | Stock | 145.44 | 145.44 | 145.27 | 145.27 | 1313.0 |
| 2022-10-04 06:50:00 | AAPL | Stock | 145.22 | 145.22 | 145.09 | 145.21 | 980.0 |
| 2022-10-04 06:55:00 | AAPL | Stock | 145.15 | 145.15 | 145.07 | 145.07 | 832.0 |
| 2022-10-04 07:00:00 | AAPL | Stock | 145.07 | 145.18 | 144.86 | 145.0 | 41145.0 |
| 2022-10-04 07:05:00 | AAPL | Stock | 145.0 | 145.1 | 144.88 | 145.1 | 9932.0 |
| 2022-10-04 07:10:00 | AAPL | Stock | 145.12 | 145.15 | 145.0 | 145.08 | 6068.0 |
| 2022-10-04 07:15:00 | AAPL | Stock | 145.04 | 145.1 | 144.96 | 144.96 | 5892.0 |
| 2022-10-04 07:20:00 | AAPL | Stock | 145.01 | 145.01 | 144.9 | 144.9 | 5892.0 |
| 2022-10-04 07:25:00 | AAPL | Stock | 144.92 | 145.01 | 144.92 | 145.0 | 3842.0 |
| 2022-10-04 07:30:00 | AAPL | Stock | 145.0 | 145.09 | 145.0 | 145.02 | 8444.0 |
| 2022-10-04 07:35:00 | AAPL | Stock | 145.09 | 145.09 | 145.01 | 145.02 | 5856.0 |
| 2022-10-04 07:40:00 | AAPL | Stock | 145.0 | 145.12 | 145.0 | 145.12 | 8750.0 |
| 2022-10-04 07:45:00 | AAPL | Stock | 145.15 | 145.15 | 144.97 | 145.02 | 7183.0 |
| 2022-10-04 07:50:00 | AAPL | Stock | 145.05 | 145.15 | 144.97 | 145.13 | 11361.0 |
| 2022-10-04 07:55:00 | AAPL | Stock | 145.13 | 145.18 | 145.1 | 145.18 | 11141.0 |
| 2022-10-04 08:00:00 | AAPL | Stock | 145.0 | 145.48 | 144.55 | 145.4 | 160466.0 |
| 2022-10-04 08:05:00 | AAPL | Stock | 145.4 | 145.4283 | 145.18 | 145.26 | 26969.0 |
> showing 50 of 438,284 rows — these rows as CSV