PREVIEW / stock_5min / 2022-06-29
file: by_date/stock_5min/2022/2022-06-29.parquet size: 6.8 MB rows: 434,099 symbols: 2,257
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-06-29 04:00:00 | AAPL | Stock | 137.44 | 138.0 | 137.3 | 137.54 | 3571.0 |
| 2022-06-29 04:05:00 | AAPL | Stock | 137.6 | 137.66 | 137.6 | 137.66 | 245.0 |
| 2022-06-29 04:10:00 | AAPL | Stock | 137.52 | 137.52 | 137.49 | 137.52 | 400.0 |
| 2022-06-29 04:15:00 | AAPL | Stock | 137.53 | 137.53 | 137.53 | 137.53 | 150.0 |
| 2022-06-29 04:20:00 | AAPL | Stock | 137.5 | 137.53 | 137.48 | 137.53 | 1037.0 |
| 2022-06-29 04:25:00 | AAPL | Stock | 137.5 | 137.5 | 137.38 | 137.41 | 1579.0 |
| 2022-06-29 04:30:00 | AAPL | Stock | 137.6 | 137.6 | 137.42 | 137.42 | 1344.0 |
| 2022-06-29 04:35:00 | AAPL | Stock | 137.55 | 137.59 | 137.46 | 137.59 | 3650.0 |
| 2022-06-29 04:40:00 | AAPL | Stock | 137.4 | 137.42 | 137.4 | 137.42 | 595.0 |
| 2022-06-29 04:55:00 | AAPL | Stock | 137.46 | 137.46 | 137.46 | 137.46 | 500.0 |
| 2022-06-29 05:00:00 | AAPL | Stock | 137.5 | 137.5 | 137.5 | 137.5 | 102.0 |
| 2022-06-29 05:05:00 | AAPL | Stock | 137.51 | 137.51 | 137.45 | 137.45 | 547.0 |
| 2022-06-29 05:10:00 | AAPL | Stock | 137.52 | 137.52 | 137.51 | 137.51 | 201.0 |
| 2022-06-29 05:15:00 | AAPL | Stock | 137.49 | 137.49 | 137.45 | 137.47 | 767.0 |
| 2022-06-29 05:30:00 | AAPL | Stock | 137.47 | 137.47 | 137.26 | 137.26 | 3152.0 |
| 2022-06-29 05:35:00 | AAPL | Stock | 137.25 | 137.25 | 137.2 | 137.2 | 876.0 |
| 2022-06-29 05:40:00 | AAPL | Stock | 137.17 | 137.29 | 137.15 | 137.25 | 1324.0 |
| 2022-06-29 05:45:00 | AAPL | Stock | 137.14 | 137.18 | 137.09 | 137.18 | 1830.0 |
| 2022-06-29 05:50:00 | AAPL | Stock | 137.1 | 137.12 | 137.05 | 137.05 | 1393.0 |
| 2022-06-29 05:55:00 | AAPL | Stock | 137.04 | 137.04 | 136.88 | 136.9 | 5093.0 |
| 2022-06-29 06:00:00 | AAPL | Stock | 136.87 | 137.06 | 136.87 | 136.97 | 1630.0 |
| 2022-06-29 06:05:00 | AAPL | Stock | 137.08 | 137.14 | 137.08 | 137.14 | 1916.0 |
| 2022-06-29 06:10:00 | AAPL | Stock | 137.18 | 137.2 | 137.18 | 137.2 | 1262.0 |
| 2022-06-29 06:15:00 | AAPL | Stock | 137.1 | 137.1 | 137.1 | 137.1 | 1050.0 |
| 2022-06-29 06:20:00 | AAPL | Stock | 137.02 | 137.16 | 137.01 | 137.16 | 1551.0 |
| 2022-06-29 06:30:00 | AAPL | Stock | 137.07 | 137.16 | 137.07 | 137.13 | 2695.0 |
| 2022-06-29 06:35:00 | AAPL | Stock | 137.17 | 137.3 | 137.17 | 137.3 | 2209.0 |
| 2022-06-29 06:40:00 | AAPL | Stock | 137.25 | 137.25 | 137.11 | 137.11 | 3844.0 |
| 2022-06-29 06:45:00 | AAPL | Stock | 137.1 | 137.1 | 136.96 | 137.03 | 2059.0 |
| 2022-06-29 06:50:00 | AAPL | Stock | 136.99 | 137.02 | 136.99 | 137.02 | 1867.0 |
| 2022-06-29 06:55:00 | AAPL | Stock | 137.06 | 137.06 | 137.06 | 137.06 | 150.0 |
| 2022-06-29 07:00:00 | AAPL | Stock | 137.22 | 137.22 | 137.03 | 137.03 | 5910.0 |
| 2022-06-29 07:05:00 | AAPL | Stock | 137.02 | 137.09 | 137.02 | 137.09 | 2602.0 |
| 2022-06-29 07:10:00 | AAPL | Stock | 137.07 | 137.07 | 136.96 | 137.0 | 6462.0 |
| 2022-06-29 07:15:00 | AAPL | Stock | 137.05 | 137.08 | 136.95 | 137.05 | 2853.0 |
| 2022-06-29 07:20:00 | AAPL | Stock | 137.05 | 137.09 | 137.04 | 137.04 | 1044.0 |
| 2022-06-29 07:25:00 | AAPL | Stock | 137.0 | 137.07 | 137.0 | 137.02 | 3042.0 |
| 2022-06-29 07:30:00 | AAPL | Stock | 137.08 | 137.26 | 137.08 | 137.15 | 2738.0 |
| 2022-06-29 07:35:00 | AAPL | Stock | 137.15 | 137.22 | 137.0 | 137.22 | 12830.0 |
| 2022-06-29 07:40:00 | AAPL | Stock | 137.16 | 137.19 | 137.1 | 137.1 | 624.0 |
| 2022-06-29 07:45:00 | AAPL | Stock | 137.12 | 137.25 | 137.1 | 137.24 | 4374.0 |
| 2022-06-29 07:50:00 | AAPL | Stock | 137.25 | 137.56 | 137.21 | 137.53 | 6734.0 |
| 2022-06-29 07:55:00 | AAPL | Stock | 137.5 | 137.72 | 137.39 | 137.6 | 9708.0 |
| 2022-06-29 08:00:00 | AAPL | Stock | 137.09 | 138.38 | 136.92 | 137.98 | 58309.0 |
| 2022-06-29 08:05:00 | AAPL | Stock | 137.95 | 138.13 | 137.9 | 137.9 | 14033.0 |
| 2022-06-29 08:10:00 | AAPL | Stock | 137.94 | 137.98 | 137.83 | 137.91 | 21354.0 |
| 2022-06-29 08:15:00 | AAPL | Stock | 137.88 | 138.0 | 137.84 | 137.85 | 8330.0 |
| 2022-06-29 08:20:00 | AAPL | Stock | 137.89 | 137.94 | 137.66 | 137.69 | 10979.0 |
| 2022-06-29 08:25:00 | AAPL | Stock | 137.65 | 137.8001 | 137.63 | 137.66 | 9896.0 |
| 2022-06-29 08:30:00 | AAPL | Stock | 137.69 | 137.69 | 137.12 | 137.3 | 34760.0 |
> showing 50 of 434,099 rows — these rows as CSV