PREVIEW / stock_5min / 2020-08-05
file: by_date/stock_5min/2020/2020-08-05.parquet size: 6.7 MB rows: 421,586 symbols: 2,438
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-08-05 04:00:00 | AAPL | Stock | 110.205 | 110.37 | 110.205 | 110.37 | 10836.0 |
| 2020-08-05 04:05:00 | AAPL | Stock | 110.405 | 110.41 | 110.405 | 110.41 | 2600.0 |
| 2020-08-05 04:10:00 | AAPL | Stock | 110.3025 | 110.3025 | 110.3025 | 110.3025 | 1592.0 |
| 2020-08-05 04:15:00 | AAPL | Stock | 110.255 | 110.255 | 110.255 | 110.255 | 880.0 |
| 2020-08-05 04:20:00 | AAPL | Stock | 110.1525 | 110.1525 | 110.1525 | 110.1525 | 1384.0 |
| 2020-08-05 04:25:00 | AAPL | Stock | 110.2325 | 110.245 | 110.2325 | 110.245 | 928.0 |
| 2020-08-05 04:30:00 | AAPL | Stock | 110.1675 | 110.1925 | 110.04 | 110.04 | 4976.0 |
| 2020-08-05 04:40:00 | AAPL | Stock | 110.2 | 110.2 | 110.2 | 110.2 | 800.0 |
| 2020-08-05 04:45:00 | AAPL | Stock | 110.235 | 110.235 | 110.1875 | 110.1875 | 1648.0 |
| 2020-08-05 04:50:00 | AAPL | Stock | 110.235 | 110.325 | 110.235 | 110.325 | 4152.0 |
| 2020-08-05 05:05:00 | AAPL | Stock | 110.325 | 110.325 | 110.325 | 110.325 | 2364.0 |
| 2020-08-05 05:10:00 | AAPL | Stock | 110.325 | 110.325 | 110.325 | 110.325 | 1560.0 |
| 2020-08-05 05:15:00 | AAPL | Stock | 110.325 | 110.325 | 110.3225 | 110.3225 | 800.0 |
| 2020-08-05 05:20:00 | AAPL | Stock | 110.3 | 110.3 | 110.3 | 110.3 | 400.0 |
| 2020-08-05 05:25:00 | AAPL | Stock | 110.325 | 110.4275 | 110.325 | 110.4275 | 5308.0 |
| 2020-08-05 05:30:00 | AAPL | Stock | 110.3925 | 110.415 | 110.3475 | 110.415 | 1604.0 |
| 2020-08-05 05:35:00 | AAPL | Stock | 110.3125 | 110.3125 | 110.25 | 110.285 | 4544.0 |
| 2020-08-05 05:40:00 | AAPL | Stock | 110.395 | 110.4275 | 110.39 | 110.4275 | 3136.0 |
| 2020-08-05 05:45:00 | AAPL | Stock | 110.5 | 110.625 | 110.4875 | 110.625 | 8664.0 |
| 2020-08-05 05:50:00 | AAPL | Stock | 110.6875 | 110.745 | 110.6875 | 110.745 | 3372.0 |
| 2020-08-05 05:55:00 | AAPL | Stock | 110.71 | 110.71 | 110.605 | 110.705 | 4080.0 |
| 2020-08-05 06:00:00 | AAPL | Stock | 110.6325 | 110.6325 | 109.5 | 109.5825 | 115808.0 |
| 2020-08-05 06:05:00 | AAPL | Stock | 109.6 | 109.6825 | 109.255 | 109.5 | 52808.0 |
| 2020-08-05 06:10:00 | AAPL | Stock | 109.4525 | 109.55 | 109.345 | 109.345 | 4800.0 |
| 2020-08-05 06:15:00 | AAPL | Stock | 109.435 | 109.435 | 109.3175 | 109.34 | 5020.0 |
| 2020-08-05 06:20:00 | AAPL | Stock | 109.325 | 109.5 | 109.1875 | 109.375 | 18516.0 |
| 2020-08-05 06:25:00 | AAPL | Stock | 109.4475 | 109.6575 | 109.4475 | 109.6575 | 11872.0 |
| 2020-08-05 06:30:00 | AAPL | Stock | 109.74 | 109.74 | 109.6525 | 109.72 | 5356.0 |
| 2020-08-05 06:35:00 | AAPL | Stock | 109.72 | 109.75 | 109.675 | 109.675 | 10132.0 |
| 2020-08-05 06:40:00 | AAPL | Stock | 109.7375 | 109.7575 | 109.625 | 109.625 | 11948.0 |
| 2020-08-05 06:45:00 | AAPL | Stock | 109.5975 | 109.5975 | 109.5275 | 109.5275 | 4568.0 |
| 2020-08-05 06:50:00 | AAPL | Stock | 109.5275 | 109.55 | 109.495 | 109.5 | 5792.0 |
| 2020-08-05 06:55:00 | AAPL | Stock | 109.5 | 109.5 | 109.245 | 109.3075 | 34264.0 |
| 2020-08-05 07:00:00 | AAPL | Stock | 109.5 | 109.75 | 109.5 | 109.75 | 60776.0 |
| 2020-08-05 07:05:00 | AAPL | Stock | 109.67 | 109.7275 | 109.6 | 109.6625 | 34516.0 |
| 2020-08-05 07:10:00 | AAPL | Stock | 109.63 | 109.63 | 109.575 | 109.575 | 28804.0 |
| 2020-08-05 07:15:00 | AAPL | Stock | 109.57 | 109.6475 | 109.455 | 109.455 | 58364.0 |
| 2020-08-05 07:20:00 | AAPL | Stock | 109.4975 | 109.4975 | 109.3625 | 109.38 | 46540.0 |
| 2020-08-05 07:25:00 | AAPL | Stock | 109.385 | 109.4025 | 109.3725 | 109.4 | 11984.0 |
| 2020-08-05 07:30:00 | AAPL | Stock | 109.4 | 109.45 | 109.375 | 109.4475 | 29808.0 |
| 2020-08-05 07:35:00 | AAPL | Stock | 109.4625 | 109.6 | 109.4625 | 109.6 | 19416.0 |
| 2020-08-05 07:40:00 | AAPL | Stock | 109.625 | 109.6875 | 109.625 | 109.64 | 24936.0 |
| 2020-08-05 07:45:00 | AAPL | Stock | 109.6325 | 109.675 | 109.525 | 109.525 | 20104.0 |
| 2020-08-05 07:50:00 | AAPL | Stock | 109.5972 | 109.5972 | 109.405 | 109.4275 | 40752.0 |
| 2020-08-05 07:55:00 | AAPL | Stock | 109.43 | 109.5 | 109.3925 | 109.4125 | 19508.0 |
| 2020-08-05 08:00:00 | AAPL | Stock | 109.4125 | 109.9375 | 109.3125 | 109.3708 | 239740.0 |
| 2020-08-05 08:05:00 | AAPL | Stock | 109.35 | 109.4 | 109.22 | 109.3975 | 75092.0 |
| 2020-08-05 08:10:00 | AAPL | Stock | 109.375 | 109.425 | 109.16 | 109.24 | 53252.0 |
| 2020-08-05 08:15:00 | AAPL | Stock | 109.1875 | 109.2375 | 109.0625 | 109.15 | 129240.0 |
| 2020-08-05 08:20:00 | AAPL | Stock | 109.2025 | 109.2975 | 109.125 | 109.25 | 58812.0 |
> showing 50 of 421,586 rows — these rows as CSV