PREVIEW / stock_5min / 2020-08-11
file: by_date/stock_5min/2020/2020-08-11.parquet size: 6.9 MB rows: 431,430 symbols: 2,442
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-11 04:00:00 | AAPL | Stock | 113.025 | 113.15 | 113.025 | 113.15 | 2516.0 |
| 2020-08-11 04:05:00 | AAPL | Stock | 113.145 | 113.15 | 113.145 | 113.15 | 1200.0 |
| 2020-08-11 04:10:00 | AAPL | Stock | 113.1975 | 113.2 | 113.1975 | 113.1975 | 2124.0 |
| 2020-08-11 04:15:00 | AAPL | Stock | 113.2375 | 113.2425 | 113.175 | 113.175 | 3412.0 |
| 2020-08-11 04:20:00 | AAPL | Stock | 113.2 | 113.215 | 113.18 | 113.18 | 4864.0 |
| 2020-08-11 04:35:00 | AAPL | Stock | 113.24 | 113.37 | 113.24 | 113.365 | 11256.0 |
| 2020-08-11 04:40:00 | AAPL | Stock | 113.375 | 113.375 | 113.345 | 113.345 | 9600.0 |
| 2020-08-11 04:45:00 | AAPL | Stock | 113.345 | 113.345 | 113.345 | 113.345 | 1228.0 |
| 2020-08-11 04:50:00 | AAPL | Stock | 113.3825 | 113.4375 | 113.35 | 113.35 | 2000.0 |
| 2020-08-11 04:55:00 | AAPL | Stock | 113.34 | 113.34 | 113.325 | 113.325 | 8084.0 |
| 2020-08-11 05:00:00 | AAPL | Stock | 113.3375 | 113.3375 | 113.2025 | 113.22 | 5624.0 |
| 2020-08-11 05:05:00 | AAPL | Stock | 113.235 | 113.235 | 113.235 | 113.235 | 1040.0 |
| 2020-08-11 05:10:00 | AAPL | Stock | 113.2375 | 113.2375 | 113.21 | 113.21 | 1756.0 |
| 2020-08-11 05:15:00 | AAPL | Stock | 113.2025 | 113.285 | 113.2025 | 113.285 | 1924.0 |
| 2020-08-11 05:25:00 | AAPL | Stock | 113.29 | 113.525 | 113.29 | 113.5125 | 17860.0 |
| 2020-08-11 05:30:00 | AAPL | Stock | 113.465 | 113.465 | 113.465 | 113.465 | 1100.0 |
| 2020-08-11 05:35:00 | AAPL | Stock | 113.4975 | 113.5525 | 113.4975 | 113.5125 | 3176.0 |
| 2020-08-11 05:40:00 | AAPL | Stock | 113.55 | 113.55 | 113.375 | 113.375 | 5764.0 |
| 2020-08-11 05:45:00 | AAPL | Stock | 113.375 | 113.375 | 113.3675 | 113.375 | 2164.0 |
| 2020-08-11 05:50:00 | AAPL | Stock | 113.375 | 113.375 | 113.2175 | 113.24 | 17496.0 |
| 2020-08-11 05:55:00 | AAPL | Stock | 113.2275 | 113.255 | 113.22 | 113.25 | 14524.0 |
| 2020-08-11 06:00:00 | AAPL | Stock | 113.25 | 113.2875 | 113.2125 | 113.2875 | 12536.0 |
| 2020-08-11 06:05:00 | AAPL | Stock | 113.2775 | 113.3125 | 113.25 | 113.3 | 13628.0 |
| 2020-08-11 06:10:00 | AAPL | Stock | 113.255 | 113.3 | 113.255 | 113.3 | 2500.0 |
| 2020-08-11 06:15:00 | AAPL | Stock | 113.26 | 113.29 | 113.2325 | 113.2325 | 5728.0 |
| 2020-08-11 06:20:00 | AAPL | Stock | 113.2 | 113.2 | 113.1525 | 113.1875 | 8796.0 |
| 2020-08-11 06:25:00 | AAPL | Stock | 113.19 | 113.1925 | 113.19 | 113.1925 | 2400.0 |
| 2020-08-11 06:30:00 | AAPL | Stock | 113.21 | 113.225 | 113.21 | 113.225 | 1800.0 |
| 2020-08-11 06:35:00 | AAPL | Stock | 113.1875 | 113.1875 | 113.1875 | 113.1875 | 1204.0 |
| 2020-08-11 06:40:00 | AAPL | Stock | 113.2 | 113.2 | 113.2 | 113.2 | 400.0 |
| 2020-08-11 06:45:00 | AAPL | Stock | 113.1525 | 113.1525 | 113.1525 | 113.1525 | 1204.0 |
| 2020-08-11 06:50:00 | AAPL | Stock | 113.1625 | 113.2225 | 113.1625 | 113.2225 | 3944.0 |
| 2020-08-11 06:55:00 | AAPL | Stock | 113.205 | 113.2125 | 113.1475 | 113.1475 | 6176.0 |
| 2020-08-11 07:00:00 | AAPL | Stock | 113.1875 | 113.2925 | 113.1425 | 113.235 | 99796.0 |
| 2020-08-11 07:05:00 | AAPL | Stock | 113.245 | 113.2575 | 113.1375 | 113.1375 | 28140.0 |
| 2020-08-11 07:10:00 | AAPL | Stock | 113.15 | 113.175 | 112.885 | 112.96 | 50160.0 |
| 2020-08-11 07:15:00 | AAPL | Stock | 112.9925 | 113.1375 | 112.9875 | 113.1375 | 71368.0 |
| 2020-08-11 07:20:00 | AAPL | Stock | 113.1375 | 113.1375 | 112.7775 | 112.7925 | 51720.0 |
| 2020-08-11 07:25:00 | AAPL | Stock | 112.8375 | 112.8375 | 112.6375 | 112.675 | 40848.0 |
| 2020-08-11 07:30:00 | AAPL | Stock | 112.675 | 112.76 | 112.65 | 112.7125 | 38548.0 |
| 2020-08-11 07:35:00 | AAPL | Stock | 112.7225 | 112.7225 | 112.5075 | 112.55 | 62928.0 |
| 2020-08-11 07:40:00 | AAPL | Stock | 112.5725 | 112.58 | 112.3175 | 112.3525 | 90240.0 |
| 2020-08-11 07:45:00 | AAPL | Stock | 112.375 | 112.4875 | 112.36 | 112.4875 | 28864.0 |
| 2020-08-11 07:50:00 | AAPL | Stock | 112.495 | 112.6225 | 112.495 | 112.55 | 65060.0 |
| 2020-08-11 07:55:00 | AAPL | Stock | 112.565 | 112.565 | 112.28 | 112.4 | 56268.0 |
| 2020-08-11 08:00:00 | AAPL | Stock | 112.91 | 113.275 | 112.2575 | 112.56 | 281248.0 |
| 2020-08-11 08:05:00 | AAPL | Stock | 112.5375 | 112.7125 | 112.5 | 112.68 | 32096.0 |
| 2020-08-11 08:10:00 | AAPL | Stock | 112.6875 | 112.695 | 112.515 | 112.62 | 29968.0 |
| 2020-08-11 08:15:00 | AAPL | Stock | 112.6175 | 112.625 | 112.5225 | 112.53 | 55844.0 |
| 2020-08-11 08:20:00 | AAPL | Stock | 112.505 | 112.525 | 112.35 | 112.475 | 78412.0 |
> showing 50 of 431,430 rows — these rows as CSV