PREVIEW / stock_5min / 2021-12-06
file: by_date/stock_5min/2021/2021-12-06.parquet size: 7.8 MB rows: 482,429 symbols: 2,700
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-12-06 04:00:00 | AAPL | Stock | 163.29 | 163.92 | 163.1 | 163.92 | 21815.0 |
| 2021-12-06 04:05:00 | AAPL | Stock | 163.69 | 163.9 | 163.5 | 163.72 | 5189.0 |
| 2021-12-06 04:10:00 | AAPL | Stock | 163.73 | 163.73 | 163.5 | 163.61 | 6675.0 |
| 2021-12-06 04:15:00 | AAPL | Stock | 163.57 | 163.75 | 163.57 | 163.75 | 6749.0 |
| 2021-12-06 04:20:00 | AAPL | Stock | 163.75 | 163.87 | 163.62 | 163.87 | 21167.0 |
| 2021-12-06 04:25:00 | AAPL | Stock | 163.88 | 164.25 | 163.88 | 164.2 | 10319.0 |
| 2021-12-06 04:30:00 | AAPL | Stock | 164.2 | 164.2 | 163.7 | 163.7 | 13333.0 |
| 2021-12-06 04:35:00 | AAPL | Stock | 163.69 | 163.86 | 163.37 | 163.37 | 9274.0 |
| 2021-12-06 04:40:00 | AAPL | Stock | 163.36 | 163.44 | 163.3 | 163.44 | 7692.0 |
| 2021-12-06 04:45:00 | AAPL | Stock | 163.33 | 163.34 | 162.8 | 162.96 | 10143.0 |
| 2021-12-06 04:50:00 | AAPL | Stock | 162.9 | 163.45 | 162.9 | 163.3 | 12952.0 |
| 2021-12-06 04:55:00 | AAPL | Stock | 163.3 | 163.3 | 162.9 | 163.2 | 4595.0 |
| 2021-12-06 05:00:00 | AAPL | Stock | 163.18 | 163.3 | 162.95 | 162.95 | 5591.0 |
| 2021-12-06 05:05:00 | AAPL | Stock | 162.95 | 163.05 | 162.95 | 163.05 | 1731.0 |
| 2021-12-06 05:10:00 | AAPL | Stock | 162.92 | 163.05 | 162.9 | 163.05 | 1270.0 |
| 2021-12-06 05:15:00 | AAPL | Stock | 163.19 | 163.5 | 163.01 | 163.5 | 8835.0 |
| 2021-12-06 05:20:00 | AAPL | Stock | 163.4 | 163.8 | 163.4 | 163.53 | 5312.0 |
| 2021-12-06 05:25:00 | AAPL | Stock | 163.3 | 163.3 | 162.56 | 162.64 | 8097.0 |
| 2021-12-06 05:30:00 | AAPL | Stock | 162.6 | 162.8 | 162.25 | 162.8 | 7121.0 |
| 2021-12-06 05:35:00 | AAPL | Stock | 162.75 | 162.87 | 162.33 | 162.62 | 6100.0 |
| 2021-12-06 05:40:00 | AAPL | Stock | 162.45 | 162.6 | 162.35 | 162.47 | 4691.0 |
| 2021-12-06 05:45:00 | AAPL | Stock | 162.56 | 162.75 | 162.51 | 162.62 | 11615.0 |
| 2021-12-06 05:50:00 | AAPL | Stock | 162.65 | 162.7 | 162.07 | 162.07 | 6267.0 |
| 2021-12-06 05:55:00 | AAPL | Stock | 162.13 | 162.13 | 161.84 | 162.12 | 6511.0 |
| 2021-12-06 06:00:00 | AAPL | Stock | 162.09 | 162.31 | 162.09 | 162.31 | 1994.0 |
| 2021-12-06 06:05:00 | AAPL | Stock | 162.27 | 162.37 | 162.15 | 162.37 | 2455.0 |
| 2021-12-06 06:10:00 | AAPL | Stock | 162.39 | 162.4 | 162.12 | 162.23 | 6431.0 |
| 2021-12-06 06:15:00 | AAPL | Stock | 162.23 | 162.51 | 162.23 | 162.51 | 2710.0 |
| 2021-12-06 06:20:00 | AAPL | Stock | 162.51 | 162.65 | 162.45 | 162.53 | 2336.0 |
| 2021-12-06 06:25:00 | AAPL | Stock | 162.5 | 162.51 | 162.46 | 162.46 | 779.0 |
| 2021-12-06 06:30:00 | AAPL | Stock | 162.37 | 162.39 | 162.37 | 162.39 | 571.0 |
| 2021-12-06 06:35:00 | AAPL | Stock | 162.39 | 162.4 | 162.35 | 162.35 | 696.0 |
| 2021-12-06 06:40:00 | AAPL | Stock | 162.5 | 162.89 | 162.5 | 162.84 | 6641.0 |
| 2021-12-06 06:45:00 | AAPL | Stock | 162.85 | 163.0 | 162.8 | 162.98 | 4251.0 |
| 2021-12-06 06:50:00 | AAPL | Stock | 162.89 | 162.93 | 162.87 | 162.89 | 3468.0 |
| 2021-12-06 06:55:00 | AAPL | Stock | 162.89 | 163.2 | 162.89 | 163.2 | 8022.0 |
| 2021-12-06 07:00:00 | AAPL | Stock | 163.13 | 163.25 | 162.59 | 162.61 | 29348.0 |
| 2021-12-06 07:05:00 | AAPL | Stock | 162.65 | 162.74 | 162.21 | 162.4 | 9604.0 |
| 2021-12-06 07:10:00 | AAPL | Stock | 162.49 | 162.56 | 162.35 | 162.45 | 8492.0 |
| 2021-12-06 07:15:00 | AAPL | Stock | 162.45 | 162.45 | 162.21 | 162.23 | 11960.0 |
| 2021-12-06 07:20:00 | AAPL | Stock | 162.1 | 162.31 | 162.02 | 162.26 | 16360.0 |
| 2021-12-06 07:25:00 | AAPL | Stock | 162.2 | 162.59 | 162.2 | 162.55 | 15150.0 |
| 2021-12-06 07:30:00 | AAPL | Stock | 162.55 | 162.57 | 162.4 | 162.53 | 28245.0 |
| 2021-12-06 07:35:00 | AAPL | Stock | 162.51 | 163.15 | 162.51 | 163.11 | 61124.0 |
| 2021-12-06 07:40:00 | AAPL | Stock | 163.13 | 163.45 | 163.11 | 163.4 | 59046.0 |
| 2021-12-06 07:45:00 | AAPL | Stock | 163.38 | 163.56 | 163.28 | 163.49 | 22317.0 |
| 2021-12-06 07:50:00 | AAPL | Stock | 163.5 | 163.57 | 163.3 | 163.46 | 37233.0 |
| 2021-12-06 07:55:00 | AAPL | Stock | 163.45 | 163.65 | 163.44 | 163.51 | 23488.0 |
| 2021-12-06 08:00:00 | AAPL | Stock | 162.3102 | 163.79 | 161.436 | 163.54 | 246187.0 |
| 2021-12-06 08:05:00 | AAPL | Stock | 163.53 | 163.64 | 163.29 | 163.59 | 61617.0 |
> showing 50 of 482,429 rows — these rows as CSV