PREVIEW / stock_5min / 2020-09-14
file: by_date/stock_5min/2020/2020-09-14.parquet size: 6.5 MB rows: 409,469 symbols: 2,501
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-09-14 04:00:00 | AAPL | Stock | 114.65 | 115.15 | 114.28 | 114.94 | 27613.0 |
| 2020-09-14 04:05:00 | AAPL | Stock | 114.9 | 114.99 | 114.8 | 114.8 | 7130.0 |
| 2020-09-14 04:10:00 | AAPL | Stock | 114.7 | 114.7 | 114.52 | 114.7 | 8035.0 |
| 2020-09-14 04:15:00 | AAPL | Stock | 114.7 | 114.89 | 114.55 | 114.55 | 7897.0 |
| 2020-09-14 04:20:00 | AAPL | Stock | 114.5 | 114.5 | 114.3 | 114.3 | 7279.0 |
| 2020-09-14 04:25:00 | AAPL | Stock | 114.43 | 114.49 | 114.21 | 114.29 | 5040.0 |
| 2020-09-14 04:30:00 | AAPL | Stock | 114.12 | 114.5 | 114.1 | 114.13 | 15972.0 |
| 2020-09-14 04:35:00 | AAPL | Stock | 114.15 | 114.23 | 114.0 | 114.11 | 5834.0 |
| 2020-09-14 04:40:00 | AAPL | Stock | 114.11 | 114.34 | 114.05 | 114.06 | 8290.0 |
| 2020-09-14 04:45:00 | AAPL | Stock | 114.13 | 114.37 | 114.05 | 114.37 | 5279.0 |
| 2020-09-14 04:50:00 | AAPL | Stock | 114.37 | 114.37 | 114.08 | 114.08 | 2318.0 |
| 2020-09-14 04:55:00 | AAPL | Stock | 114.05 | 114.2 | 113.9 | 114.19 | 4430.0 |
| 2020-09-14 05:00:00 | AAPL | Stock | 114.18 | 114.4 | 114.18 | 114.32 | 3161.0 |
| 2020-09-14 05:05:00 | AAPL | Stock | 114.4 | 114.49 | 114.39 | 114.4 | 5755.0 |
| 2020-09-14 05:10:00 | AAPL | Stock | 114.38 | 114.41 | 114.19 | 114.4 | 2799.0 |
| 2020-09-14 05:15:00 | AAPL | Stock | 114.35 | 114.35 | 114.3 | 114.3 | 290.0 |
| 2020-09-14 05:20:00 | AAPL | Stock | 114.34 | 114.57 | 114.07 | 114.5 | 2987.0 |
| 2020-09-14 05:25:00 | AAPL | Stock | 114.5 | 114.58 | 114.45 | 114.51 | 1259.0 |
| 2020-09-14 05:30:00 | AAPL | Stock | 114.57 | 114.61 | 114.45 | 114.55 | 3927.0 |
| 2020-09-14 05:35:00 | AAPL | Stock | 114.33 | 114.33 | 113.8 | 113.8 | 5017.0 |
| 2020-09-14 05:40:00 | AAPL | Stock | 113.98 | 114.09 | 113.84 | 113.9 | 3351.0 |
| 2020-09-14 05:45:00 | AAPL | Stock | 114.0 | 114.12 | 113.9 | 114.1 | 4193.0 |
| 2020-09-14 05:50:00 | AAPL | Stock | 114.1 | 114.3 | 114.1 | 114.2 | 1710.0 |
| 2020-09-14 05:55:00 | AAPL | Stock | 114.2 | 114.3 | 114.2 | 114.2 | 1153.0 |
| 2020-09-14 06:00:00 | AAPL | Stock | 114.12 | 114.39 | 114.12 | 114.33 | 3293.0 |
| 2020-09-14 06:05:00 | AAPL | Stock | 114.41 | 114.57 | 114.4 | 114.55 | 3102.0 |
| 2020-09-14 06:10:00 | AAPL | Stock | 114.5 | 114.5 | 114.4 | 114.41 | 4614.0 |
| 2020-09-14 06:15:00 | AAPL | Stock | 114.4 | 114.51 | 114.4 | 114.43 | 4151.0 |
| 2020-09-14 06:20:00 | AAPL | Stock | 114.45 | 114.53 | 114.23 | 114.23 | 4448.0 |
| 2020-09-14 06:25:00 | AAPL | Stock | 114.2 | 114.24 | 114.1 | 114.11 | 3041.0 |
| 2020-09-14 06:30:00 | AAPL | Stock | 114.2 | 114.48 | 114.2 | 114.48 | 1868.0 |
| 2020-09-14 06:35:00 | AAPL | Stock | 114.48 | 114.53 | 114.48 | 114.53 | 1550.0 |
| 2020-09-14 06:40:00 | AAPL | Stock | 114.55 | 114.7 | 114.55 | 114.6 | 5954.0 |
| 2020-09-14 06:45:00 | AAPL | Stock | 114.6 | 114.6 | 114.46 | 114.6 | 1871.0 |
| 2020-09-14 06:50:00 | AAPL | Stock | 114.56 | 114.85 | 114.5 | 114.85 | 5394.0 |
| 2020-09-14 06:55:00 | AAPL | Stock | 114.8 | 114.98 | 114.6 | 114.8 | 8598.0 |
| 2020-09-14 07:00:00 | AAPL | Stock | 114.75 | 114.87 | 114.0 | 114.0 | 160106.0 |
| 2020-09-14 07:05:00 | AAPL | Stock | 114.05 | 114.28 | 113.95 | 114.12 | 50612.0 |
| 2020-09-14 07:10:00 | AAPL | Stock | 114.13 | 114.15 | 113.8 | 114.13 | 63942.0 |
| 2020-09-14 07:15:00 | AAPL | Stock | 114.11 | 114.15 | 113.9 | 113.92 | 29560.0 |
| 2020-09-14 07:20:00 | AAPL | Stock | 113.94 | 114.2 | 113.93 | 114.14 | 36411.0 |
| 2020-09-14 07:25:00 | AAPL | Stock | 114.15 | 114.5 | 114.04 | 114.1 | 46169.0 |
| 2020-09-14 07:30:00 | AAPL | Stock | 114.12 | 114.12 | 113.81 | 114.02 | 37524.0 |
| 2020-09-14 07:35:00 | AAPL | Stock | 114.03 | 114.06 | 113.82 | 114.06 | 35938.0 |
| 2020-09-14 07:40:00 | AAPL | Stock | 114.051 | 114.15 | 113.8 | 113.81 | 49479.0 |
| 2020-09-14 07:45:00 | AAPL | Stock | 113.82 | 114.0 | 113.8 | 113.86 | 27200.0 |
| 2020-09-14 07:50:00 | AAPL | Stock | 113.87 | 114.0 | 113.85 | 113.98 | 23256.0 |
| 2020-09-14 07:55:00 | AAPL | Stock | 113.98 | 113.98 | 113.7 | 113.77 | 41407.0 |
| 2020-09-14 08:00:00 | AAPL | Stock | 114.16 | 114.69 | 113.49 | 113.52 | 395123.0 |
| 2020-09-14 08:05:00 | AAPL | Stock | 113.58 | 113.85 | 113.51 | 113.78 | 56011.0 |
> showing 50 of 409,469 rows — these rows as CSV