PREVIEW / stock_5min / 2020-09-22
file: by_date/stock_5min/2020/2020-09-22.parquet size: 6.4 MB rows: 403,673 symbols: 2,502
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-22 04:00:00 | AAPL | Stock | 111.0 | 111.0 | 110.0 | 110.55 | 12897.0 |
| 2020-09-22 04:05:00 | AAPL | Stock | 110.59 | 110.59 | 110.08 | 110.34 | 8315.0 |
| 2020-09-22 04:10:00 | AAPL | Stock | 110.54 | 110.79 | 110.34 | 110.56 | 6378.0 |
| 2020-09-22 04:15:00 | AAPL | Stock | 110.65 | 110.91 | 110.65 | 110.8 | 7337.0 |
| 2020-09-22 04:20:00 | AAPL | Stock | 110.71 | 110.77 | 110.56 | 110.56 | 3676.0 |
| 2020-09-22 04:25:00 | AAPL | Stock | 110.52 | 110.59 | 110.37 | 110.59 | 6297.0 |
| 2020-09-22 04:30:00 | AAPL | Stock | 110.59 | 110.86 | 110.59 | 110.85 | 4285.0 |
| 2020-09-22 04:35:00 | AAPL | Stock | 110.85 | 110.88 | 110.8 | 110.8 | 6225.0 |
| 2020-09-22 04:40:00 | AAPL | Stock | 110.72 | 110.72 | 110.64 | 110.65 | 2328.0 |
| 2020-09-22 04:45:00 | AAPL | Stock | 110.7 | 110.78 | 110.43 | 110.6 | 3574.0 |
| 2020-09-22 04:50:00 | AAPL | Stock | 110.59 | 110.65 | 110.41 | 110.6 | 5854.0 |
| 2020-09-22 04:55:00 | AAPL | Stock | 110.59 | 110.63 | 110.51 | 110.63 | 1611.0 |
| 2020-09-22 05:00:00 | AAPL | Stock | 110.64 | 110.65 | 110.58 | 110.65 | 2361.0 |
| 2020-09-22 05:05:00 | AAPL | Stock | 110.6 | 110.6 | 110.6 | 110.6 | 240.0 |
| 2020-09-22 05:10:00 | AAPL | Stock | 110.6 | 110.9 | 110.6 | 110.9 | 7988.0 |
| 2020-09-22 05:15:00 | AAPL | Stock | 110.86 | 110.95 | 110.86 | 110.95 | 1371.0 |
| 2020-09-22 05:20:00 | AAPL | Stock | 110.93 | 111.27 | 110.93 | 111.27 | 9781.0 |
| 2020-09-22 05:25:00 | AAPL | Stock | 111.27 | 111.42 | 111.27 | 111.38 | 6298.0 |
| 2020-09-22 05:30:00 | AAPL | Stock | 111.35 | 111.35 | 111.25 | 111.3 | 5889.0 |
| 2020-09-22 05:35:00 | AAPL | Stock | 111.23 | 111.3 | 111.12 | 111.25 | 6522.0 |
| 2020-09-22 05:40:00 | AAPL | Stock | 111.29 | 111.36 | 111.29 | 111.36 | 2161.0 |
| 2020-09-22 05:45:00 | AAPL | Stock | 111.32 | 111.42 | 111.3 | 111.4 | 3608.0 |
| 2020-09-22 05:50:00 | AAPL | Stock | 111.4 | 111.4 | 111.33 | 111.39 | 3361.0 |
| 2020-09-22 05:55:00 | AAPL | Stock | 111.36 | 111.52 | 111.36 | 111.44 | 16210.0 |
| 2020-09-22 06:00:00 | AAPL | Stock | 111.42 | 111.42 | 111.25 | 111.33 | 11667.0 |
| 2020-09-22 06:05:00 | AAPL | Stock | 111.28 | 111.29 | 111.2 | 111.2 | 2016.0 |
| 2020-09-22 06:10:00 | AAPL | Stock | 111.29 | 111.29 | 111.03 | 111.03 | 2941.0 |
| 2020-09-22 06:15:00 | AAPL | Stock | 111.03 | 111.2 | 111.0 | 111.19 | 4832.0 |
| 2020-09-22 06:20:00 | AAPL | Stock | 111.14 | 111.26 | 111.1 | 111.26 | 3230.0 |
| 2020-09-22 06:25:00 | AAPL | Stock | 111.38 | 111.6 | 111.22 | 111.6 | 13926.0 |
| 2020-09-22 06:30:00 | AAPL | Stock | 111.61 | 111.68 | 111.41 | 111.41 | 4677.0 |
| 2020-09-22 06:35:00 | AAPL | Stock | 111.4 | 111.55 | 111.4 | 111.53 | 3118.0 |
| 2020-09-22 06:40:00 | AAPL | Stock | 111.5 | 111.53 | 111.45 | 111.45 | 5630.0 |
| 2020-09-22 06:45:00 | AAPL | Stock | 111.38 | 111.43 | 111.3 | 111.31 | 2278.0 |
| 2020-09-22 06:50:00 | AAPL | Stock | 111.31 | 111.36 | 111.28 | 111.28 | 2176.0 |
| 2020-09-22 06:55:00 | AAPL | Stock | 111.25 | 111.27 | 111.16 | 111.19 | 3720.0 |
| 2020-09-22 07:00:00 | AAPL | Stock | 111.26 | 111.41 | 111.03 | 111.32 | 101185.0 |
| 2020-09-22 07:05:00 | AAPL | Stock | 111.32 | 111.32 | 111.08 | 111.19 | 45182.0 |
| 2020-09-22 07:10:00 | AAPL | Stock | 111.18 | 111.48 | 111.14 | 111.44 | 50439.0 |
| 2020-09-22 07:15:00 | AAPL | Stock | 111.47 | 111.87 | 111.43 | 111.801 | 70241.0 |
| 2020-09-22 07:20:00 | AAPL | Stock | 111.81 | 111.95 | 111.71 | 111.75 | 47130.0 |
| 2020-09-22 07:25:00 | AAPL | Stock | 111.73 | 111.99 | 111.7 | 111.88 | 32767.0 |
| 2020-09-22 07:30:00 | AAPL | Stock | 111.88 | 111.94 | 111.77 | 111.78 | 38206.0 |
| 2020-09-22 07:35:00 | AAPL | Stock | 111.78 | 111.86 | 111.7 | 111.8 | 29672.0 |
| 2020-09-22 07:40:00 | AAPL | Stock | 111.8 | 111.85 | 111.6 | 111.67 | 71396.0 |
| 2020-09-22 07:45:00 | AAPL | Stock | 111.66 | 111.67 | 111.52 | 111.6 | 39112.0 |
| 2020-09-22 07:50:00 | AAPL | Stock | 111.57 | 111.65 | 111.1 | 111.13 | 69171.0 |
| 2020-09-22 07:55:00 | AAPL | Stock | 111.13 | 111.27 | 110.8 | 111.03 | 112381.0 |
| 2020-09-22 08:00:00 | AAPL | Stock | 111.03 | 112.0 | 110.8 | 111.12 | 558935.0 |
| 2020-09-22 08:05:00 | AAPL | Stock | 111.15 | 111.29 | 110.951 | 111.29 | 68548.0 |
> showing 50 of 403,673 rows — these rows as CSV