PREVIEW / stock_5min / 2020-12-21
file: by_date/stock_5min/2020/2020-12-21.parquet size: 7.8 MB rows: 484,116 symbols: 2,693
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 |
|---|---|---|---|---|---|---|---|
| 2020-12-21 04:00:00 | AAPL | Stock | 127.1 | 127.5 | 126.0 | 127.0 | 22956.0 |
| 2020-12-21 04:05:00 | AAPL | Stock | 127.04 | 127.31 | 127.04 | 127.31 | 6523.0 |
| 2020-12-21 04:10:00 | AAPL | Stock | 127.31 | 127.37 | 127.0 | 127.0 | 8721.0 |
| 2020-12-21 04:15:00 | AAPL | Stock | 127.06 | 127.2 | 127.02 | 127.2 | 2004.0 |
| 2020-12-21 04:20:00 | AAPL | Stock | 127.28 | 127.35 | 127.06 | 127.06 | 5256.0 |
| 2020-12-21 04:25:00 | AAPL | Stock | 127.06 | 127.19 | 126.99 | 127.06 | 5763.0 |
| 2020-12-21 04:30:00 | AAPL | Stock | 127.06 | 127.06 | 126.55 | 126.55 | 7878.0 |
| 2020-12-21 04:35:00 | AAPL | Stock | 126.55 | 126.59 | 125.99 | 126.25 | 15259.0 |
| 2020-12-21 04:40:00 | AAPL | Stock | 126.3 | 127.28 | 126.1 | 126.2 | 4580.0 |
| 2020-12-21 04:45:00 | AAPL | Stock | 126.1 | 126.1 | 125.62 | 125.83 | 9869.0 |
| 2020-12-21 04:50:00 | AAPL | Stock | 125.85 | 125.98 | 125.7 | 125.97 | 5008.0 |
| 2020-12-21 04:55:00 | AAPL | Stock | 126.07 | 126.1 | 126.0 | 126.0 | 1867.0 |
| 2020-12-21 05:00:00 | AAPL | Stock | 125.95 | 125.99 | 125.35 | 125.4 | 8005.0 |
| 2020-12-21 05:05:00 | AAPL | Stock | 125.4 | 125.41 | 124.5 | 124.86 | 65811.0 |
| 2020-12-21 05:10:00 | AAPL | Stock | 124.74 | 125.17 | 124.7 | 125.1 | 8717.0 |
| 2020-12-21 05:15:00 | AAPL | Stock | 125.1 | 125.3 | 125.05 | 125.05 | 5065.0 |
| 2020-12-21 05:20:00 | AAPL | Stock | 125.0 | 125.02 | 124.58 | 124.58 | 4757.0 |
| 2020-12-21 05:25:00 | AAPL | Stock | 124.56 | 124.73 | 124.41 | 124.49 | 8316.0 |
| 2020-12-21 05:30:00 | AAPL | Stock | 124.43 | 124.51 | 124.02 | 124.42 | 16559.0 |
| 2020-12-21 05:35:00 | AAPL | Stock | 124.43 | 124.7 | 124.42 | 124.7 | 5037.0 |
| 2020-12-21 05:40:00 | AAPL | Stock | 124.7 | 124.7 | 124.42 | 124.5 | 13685.0 |
| 2020-12-21 05:45:00 | AAPL | Stock | 124.52 | 124.58 | 124.42 | 124.42 | 17053.0 |
| 2020-12-21 05:50:00 | AAPL | Stock | 124.42 | 124.43 | 124.01 | 124.01 | 13757.0 |
| 2020-12-21 05:55:00 | AAPL | Stock | 124.15 | 124.4 | 124.11 | 124.28 | 10318.0 |
| 2020-12-21 06:00:00 | AAPL | Stock | 124.28 | 124.5 | 124.28 | 124.3 | 7250.0 |
| 2020-12-21 06:05:00 | AAPL | Stock | 124.32 | 124.34 | 124.15 | 124.15 | 10758.0 |
| 2020-12-21 06:10:00 | AAPL | Stock | 124.18 | 124.52 | 124.0 | 124.52 | 11497.0 |
| 2020-12-21 06:15:00 | AAPL | Stock | 124.6 | 124.64 | 124.53 | 124.53 | 4381.0 |
| 2020-12-21 06:20:00 | AAPL | Stock | 124.55 | 124.63 | 124.45 | 124.6 | 7944.0 |
| 2020-12-21 06:25:00 | AAPL | Stock | 124.6 | 124.8 | 124.23 | 124.5 | 4044.0 |
| 2020-12-21 06:30:00 | AAPL | Stock | 124.62 | 124.7 | 124.52 | 124.53 | 3008.0 |
| 2020-12-21 06:35:00 | AAPL | Stock | 124.53 | 124.74 | 124.5 | 124.74 | 5963.0 |
| 2020-12-21 06:40:00 | AAPL | Stock | 124.74 | 124.87 | 124.74 | 124.87 | 2095.0 |
| 2020-12-21 06:45:00 | AAPL | Stock | 124.87 | 125.0 | 124.86 | 124.99 | 4701.0 |
| 2020-12-21 06:50:00 | AAPL | Stock | 124.93 | 124.93 | 124.69 | 124.69 | 400.0 |
| 2020-12-21 06:55:00 | AAPL | Stock | 124.68 | 124.89 | 124.66 | 124.85 | 2581.0 |
| 2020-12-21 07:00:00 | AAPL | Stock | 124.75 | 125.37 | 124.65 | 125.09 | 110646.0 |
| 2020-12-21 07:05:00 | AAPL | Stock | 125.09 | 125.36 | 125.05 | 125.35 | 44851.0 |
| 2020-12-21 07:10:00 | AAPL | Stock | 125.38 | 125.48 | 125.2 | 125.2 | 35159.0 |
| 2020-12-21 07:15:00 | AAPL | Stock | 125.21 | 125.29 | 125.05 | 125.1 | 31176.0 |
| 2020-12-21 07:20:00 | AAPL | Stock | 125.1 | 125.1 | 124.55 | 124.7 | 59995.0 |
| 2020-12-21 07:25:00 | AAPL | Stock | 124.71 | 124.83 | 123.84 | 124.3 | 549609.0 |
| 2020-12-21 07:30:00 | AAPL | Stock | 124.32 | 124.95 | 124.24 | 124.74 | 175870.0 |
| 2020-12-21 07:35:00 | AAPL | Stock | 124.75 | 124.95 | 124.73 | 124.94 | 46729.0 |
| 2020-12-21 07:40:00 | AAPL | Stock | 124.94 | 125.01 | 124.8 | 124.85 | 101985.0 |
| 2020-12-21 07:45:00 | AAPL | Stock | 124.84 | 124.88 | 124.67 | 124.75 | 26284.0 |
| 2020-12-21 07:50:00 | AAPL | Stock | 124.78 | 124.91 | 124.65 | 124.72 | 29186.0 |
| 2020-12-21 07:55:00 | AAPL | Stock | 124.74 | 124.83 | 124.65 | 124.69 | 20586.0 |
| 2020-12-21 08:00:00 | AAPL | Stock | 124.7 | 125.45 | 123.85 | 124.92 | 359152.0 |
| 2020-12-21 08:05:00 | AAPL | Stock | 124.9 | 124.9 | 124.52 | 124.59 | 56601.0 |
> showing 50 of 484,116 rows — these rows as CSV