PREVIEW / stock_5min / 2021-01-28
file: by_date/stock_5min/2021/2021-01-28.parquet size: 8.2 MB rows: 511,264 symbols: 2,739
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-01-28 04:00:00 | AAPL | Stock | 137.59 | 137.95 | 136.75 | 136.78 | 21583.0 |
| 2021-01-28 04:05:00 | AAPL | Stock | 136.82 | 137.2 | 136.8 | 137.08 | 8322.0 |
| 2021-01-28 04:10:00 | AAPL | Stock | 137.01 | 137.01 | 136.5 | 136.9 | 14486.0 |
| 2021-01-28 04:15:00 | AAPL | Stock | 136.94 | 137.02 | 136.6 | 136.6 | 9261.0 |
| 2021-01-28 04:20:00 | AAPL | Stock | 136.6 | 136.6 | 134.71 | 134.87 | 47114.0 |
| 2021-01-28 04:25:00 | AAPL | Stock | 134.89 | 135.44 | 134.5 | 135.23 | 32346.0 |
| 2021-01-28 04:30:00 | AAPL | Stock | 135.12 | 136.08 | 135.12 | 135.8 | 14455.0 |
| 2021-01-28 04:35:00 | AAPL | Stock | 135.73 | 135.73 | 135.5 | 135.65 | 12274.0 |
| 2021-01-28 04:40:00 | AAPL | Stock | 135.66 | 135.84 | 135.32 | 135.36 | 14883.0 |
| 2021-01-28 04:45:00 | AAPL | Stock | 135.38 | 135.8 | 135.38 | 135.8 | 17079.0 |
| 2021-01-28 04:50:00 | AAPL | Stock | 135.84 | 136.53 | 135.84 | 136.44 | 18325.0 |
| 2021-01-28 04:55:00 | AAPL | Stock | 136.46 | 136.96 | 136.39 | 136.88 | 16243.0 |
| 2021-01-28 05:00:00 | AAPL | Stock | 136.83 | 136.98 | 136.7 | 136.87 | 9490.0 |
| 2021-01-28 05:05:00 | AAPL | Stock | 136.71 | 136.9 | 136.52 | 136.88 | 7213.0 |
| 2021-01-28 05:10:00 | AAPL | Stock | 136.88 | 137.08 | 136.78 | 137.05 | 7060.0 |
| 2021-01-28 05:15:00 | AAPL | Stock | 137.03 | 137.76 | 136.94 | 137.76 | 23773.0 |
| 2021-01-28 05:20:00 | AAPL | Stock | 137.9 | 138.15 | 137.83 | 138.05 | 25771.0 |
| 2021-01-28 05:25:00 | AAPL | Stock | 138.1 | 138.1 | 137.69 | 137.78 | 5765.0 |
| 2021-01-28 05:30:00 | AAPL | Stock | 137.72 | 138.7 | 137.61 | 138.35 | 29190.0 |
| 2021-01-28 05:35:00 | AAPL | Stock | 138.67 | 138.95 | 138.55 | 138.69 | 17040.0 |
| 2021-01-28 05:40:00 | AAPL | Stock | 138.6 | 138.88 | 138.51 | 138.63 | 10666.0 |
| 2021-01-28 05:45:00 | AAPL | Stock | 138.64 | 138.64 | 137.9 | 137.91 | 6977.0 |
| 2021-01-28 05:50:00 | AAPL | Stock | 137.97 | 138.01 | 137.5 | 137.61 | 5752.0 |
| 2021-01-28 05:55:00 | AAPL | Stock | 137.7 | 138.18 | 137.5 | 137.6 | 4260.0 |
| 2021-01-28 06:00:00 | AAPL | Stock | 137.62 | 137.62 | 137.0 | 137.0 | 8917.0 |
| 2021-01-28 06:05:00 | AAPL | Stock | 137.03 | 138.0 | 137.0 | 138.0 | 5976.0 |
| 2021-01-28 06:10:00 | AAPL | Stock | 138.01 | 138.25 | 138.0 | 138.2 | 6169.0 |
| 2021-01-28 06:15:00 | AAPL | Stock | 138.23 | 139.3 | 138.23 | 139.13 | 18212.0 |
| 2021-01-28 06:20:00 | AAPL | Stock | 139.19 | 139.2 | 138.66 | 138.76 | 13285.0 |
| 2021-01-28 06:25:00 | AAPL | Stock | 138.65 | 138.98 | 138.65 | 138.74 | 3007.0 |
| 2021-01-28 06:30:00 | AAPL | Stock | 138.7 | 138.7 | 138.3 | 138.47 | 3398.0 |
| 2021-01-28 06:35:00 | AAPL | Stock | 138.49 | 138.7 | 138.49 | 138.51 | 1486.0 |
| 2021-01-28 06:40:00 | AAPL | Stock | 138.36 | 138.68 | 138.29 | 138.68 | 1349.0 |
| 2021-01-28 06:45:00 | AAPL | Stock | 138.8 | 139.02 | 138.8 | 138.81 | 3724.0 |
| 2021-01-28 06:50:00 | AAPL | Stock | 138.82 | 138.94 | 138.81 | 138.94 | 2951.0 |
| 2021-01-28 06:55:00 | AAPL | Stock | 138.9 | 139.3 | 138.9 | 139.22 | 20748.0 |
| 2021-01-28 07:00:00 | AAPL | Stock | 139.16 | 139.2 | 137.73 | 138.11 | 135674.0 |
| 2021-01-28 07:05:00 | AAPL | Stock | 138.15 | 139.5 | 138.01 | 139.3 | 196033.0 |
| 2021-01-28 07:10:00 | AAPL | Stock | 139.28 | 140.0 | 139.01 | 139.95 | 106993.0 |
| 2021-01-28 07:15:00 | AAPL | Stock | 139.94 | 140.05 | 139.29 | 139.6 | 76039.0 |
| 2021-01-28 07:20:00 | AAPL | Stock | 139.66 | 139.66 | 139.3 | 139.48 | 37148.0 |
| 2021-01-28 07:25:00 | AAPL | Stock | 139.36 | 139.85 | 139.33 | 139.8 | 31998.0 |
| 2021-01-28 07:30:00 | AAPL | Stock | 139.81 | 139.9 | 138.62 | 138.98 | 76757.0 |
| 2021-01-28 07:35:00 | AAPL | Stock | 139.0 | 139.35 | 139.0 | 139.09 | 28331.0 |
| 2021-01-28 07:40:00 | AAPL | Stock | 139.04 | 139.28 | 138.8 | 138.93 | 51935.0 |
| 2021-01-28 07:45:00 | AAPL | Stock | 138.91 | 139.42 | 138.82 | 139.4 | 46018.0 |
| 2021-01-28 07:50:00 | AAPL | Stock | 139.44 | 139.55 | 138.99 | 139.0 | 47224.0 |
| 2021-01-28 07:55:00 | AAPL | Stock | 139.01 | 139.09 | 138.7 | 138.88 | 57992.0 |
| 2021-01-28 08:00:00 | AAPL | Stock | 138.85 | 140.04 | 137.81 | 138.53 | 288445.0 |
| 2021-01-28 08:05:00 | AAPL | Stock | 138.51 | 138.69 | 138.25 | 138.58 | 88813.0 |
> showing 50 of 511,264 rows — these rows as CSV