PREVIEW / stock_5min / 2021-10-08
file: by_date/stock_5min/2021/2021-10-08.parquet size: 7.0 MB rows: 422,694 symbols: 2,683
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-10-08 04:00:00 | AAPL | Stock | 143.24 | 143.27 | 143.0 | 143.09 | 6623.0 |
| 2021-10-08 04:05:00 | AAPL | Stock | 143.01 | 143.01 | 142.87 | 142.87 | 5870.0 |
| 2021-10-08 04:10:00 | AAPL | Stock | 142.91 | 142.91 | 142.78 | 142.78 | 1934.0 |
| 2021-10-08 04:15:00 | AAPL | Stock | 142.87 | 142.9 | 142.84 | 142.85 | 4017.0 |
| 2021-10-08 04:30:00 | AAPL | Stock | 142.89 | 142.89 | 142.89 | 142.89 | 100.0 |
| 2021-10-08 04:35:00 | AAPL | Stock | 142.88 | 142.88 | 142.88 | 142.88 | 250.0 |
| 2021-10-08 04:45:00 | AAPL | Stock | 142.88 | 142.89 | 142.88 | 142.89 | 589.0 |
| 2021-10-08 04:50:00 | AAPL | Stock | 142.85 | 142.89 | 142.65 | 142.65 | 19498.0 |
| 2021-10-08 04:55:00 | AAPL | Stock | 142.7 | 142.7 | 142.7 | 142.7 | 1340.0 |
| 2021-10-08 05:00:00 | AAPL | Stock | 142.66 | 142.7 | 142.6 | 142.7 | 2207.0 |
| 2021-10-08 05:10:00 | AAPL | Stock | 142.72 | 142.72 | 142.71 | 142.71 | 755.0 |
| 2021-10-08 05:15:00 | AAPL | Stock | 142.71 | 142.71 | 142.71 | 142.71 | 499.0 |
| 2021-10-08 05:25:00 | AAPL | Stock | 142.75 | 142.75 | 142.75 | 142.75 | 398.0 |
| 2021-10-08 05:30:00 | AAPL | Stock | 142.78 | 142.78 | 142.76 | 142.76 | 680.0 |
| 2021-10-08 05:45:00 | AAPL | Stock | 142.89 | 142.9 | 142.89 | 142.9 | 600.0 |
| 2021-10-08 05:55:00 | AAPL | Stock | 143.05 | 143.05 | 143.05 | 143.05 | 300.0 |
| 2021-10-08 06:00:00 | AAPL | Stock | 143.05 | 143.05 | 143.0 | 143.0 | 772.0 |
| 2021-10-08 06:05:00 | AAPL | Stock | 143.04 | 143.04 | 143.02 | 143.02 | 273.0 |
| 2021-10-08 06:10:00 | AAPL | Stock | 143.14 | 143.19 | 143.11 | 143.19 | 1307.0 |
| 2021-10-08 06:15:00 | AAPL | Stock | 143.11 | 143.15 | 143.11 | 143.15 | 1696.0 |
| 2021-10-08 06:20:00 | AAPL | Stock | 143.15 | 143.15 | 143.04 | 143.04 | 887.0 |
| 2021-10-08 06:40:00 | AAPL | Stock | 143.17 | 143.17 | 143.17 | 143.17 | 411.0 |
| 2021-10-08 06:45:00 | AAPL | Stock | 143.13 | 143.13 | 143.12 | 143.12 | 250.0 |
| 2021-10-08 06:50:00 | AAPL | Stock | 143.11 | 143.11 | 143.11 | 143.11 | 151.0 |
| 2021-10-08 06:55:00 | AAPL | Stock | 143.11 | 143.11 | 143.05 | 143.05 | 976.0 |
| 2021-10-08 07:00:00 | AAPL | Stock | 143.0 | 143.28 | 143.0 | 143.28 | 7144.0 |
| 2021-10-08 07:05:00 | AAPL | Stock | 143.3 | 143.34 | 143.26 | 143.31 | 11252.0 |
| 2021-10-08 07:10:00 | AAPL | Stock | 143.3 | 143.35 | 143.29 | 143.35 | 5304.0 |
| 2021-10-08 07:15:00 | AAPL | Stock | 143.36 | 143.36 | 143.27 | 143.34 | 5593.0 |
| 2021-10-08 07:20:00 | AAPL | Stock | 143.32 | 143.41 | 143.32 | 143.41 | 6387.0 |
| 2021-10-08 07:25:00 | AAPL | Stock | 143.38 | 143.43 | 143.34 | 143.42 | 5702.0 |
| 2021-10-08 07:30:00 | AAPL | Stock | 143.44 | 143.47 | 143.36 | 143.38 | 5146.0 |
| 2021-10-08 07:35:00 | AAPL | Stock | 143.4 | 143.43 | 143.39 | 143.42 | 14636.0 |
| 2021-10-08 07:40:00 | AAPL | Stock | 143.45 | 143.49 | 143.42 | 143.43 | 8845.0 |
| 2021-10-08 07:45:00 | AAPL | Stock | 143.43 | 143.46 | 143.43 | 143.46 | 2377.0 |
| 2021-10-08 07:50:00 | AAPL | Stock | 143.48 | 143.49 | 143.44 | 143.44 | 1746.0 |
| 2021-10-08 07:55:00 | AAPL | Stock | 143.469 | 143.47 | 143.44 | 143.44 | 775.0 |
| 2021-10-08 08:00:00 | AAPL | Stock | 143.3301 | 143.48 | 143.05 | 143.44 | 94254.0 |
| 2021-10-08 08:05:00 | AAPL | Stock | 143.46 | 143.46 | 143.42 | 143.42 | 4708.0 |
| 2021-10-08 08:10:00 | AAPL | Stock | 143.44 | 143.48 | 143.42 | 143.48 | 12852.0 |
| 2021-10-08 08:15:00 | AAPL | Stock | 143.47 | 143.5 | 143.44 | 143.45 | 19363.0 |
| 2021-10-08 08:20:00 | AAPL | Stock | 143.49 | 143.7 | 143.47 | 143.7 | 28918.0 |
| 2021-10-08 08:25:00 | AAPL | Stock | 143.69 | 143.69 | 143.53 | 143.6 | 26201.0 |
| 2021-10-08 08:30:00 | AAPL | Stock | 143.68 | 143.72 | 143.25 | 143.56 | 116535.0 |
| 2021-10-08 08:35:00 | AAPL | Stock | 143.51 | 144.35 | 143.51 | 144.2 | 146590.0 |
| 2021-10-08 08:40:00 | AAPL | Stock | 144.24 | 144.29 | 144.0 | 144.02 | 112393.0 |
| 2021-10-08 08:45:00 | AAPL | Stock | 144.01 | 144.11 | 143.4 | 143.5 | 70677.0 |
| 2021-10-08 08:50:00 | AAPL | Stock | 143.48 | 143.82 | 143.48 | 143.82 | 38556.0 |
| 2021-10-08 08:55:00 | AAPL | Stock | 143.82 | 144.2 | 143.76 | 144.05 | 65874.0 |
| 2021-10-08 09:00:00 | AAPL | Stock | 144.09 | 144.17 | 144.0 | 144.07 | 51983.0 |
> showing 50 of 422,694 rows — these rows as CSV