PREVIEW / stock_5min / 2020-07-22
file: by_date/stock_5min/2020/2020-07-22.parquet size: 6.6 MB rows: 415,404 symbols: 2,440
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-07-22 04:00:00 | AAPL | Stock | 96.7525 | 96.7525 | 96.5 | 96.5 | 5684.0 |
| 2020-07-22 04:05:00 | AAPL | Stock | 96.505 | 96.505 | 96.4875 | 96.4975 | 3248.0 |
| 2020-07-22 04:10:00 | AAPL | Stock | 96.4025 | 96.5375 | 96.4025 | 96.52 | 5844.0 |
| 2020-07-22 04:15:00 | AAPL | Stock | 96.5 | 96.53 | 96.475 | 96.53 | 6912.0 |
| 2020-07-22 04:20:00 | AAPL | Stock | 96.5 | 96.535 | 96.5 | 96.535 | 5868.0 |
| 2020-07-22 04:25:00 | AAPL | Stock | 96.64 | 96.64 | 96.64 | 96.64 | 400.0 |
| 2020-07-22 04:30:00 | AAPL | Stock | 96.65 | 96.6575 | 96.5775 | 96.5775 | 4816.0 |
| 2020-07-22 04:35:00 | AAPL | Stock | 96.5 | 96.5 | 96.45 | 96.45 | 6160.0 |
| 2020-07-22 04:40:00 | AAPL | Stock | 96.4 | 96.5425 | 96.4 | 96.5425 | 3884.0 |
| 2020-07-22 04:45:00 | AAPL | Stock | 96.4225 | 96.4225 | 96.42 | 96.4225 | 4972.0 |
| 2020-07-22 04:50:00 | AAPL | Stock | 96.42 | 96.475 | 96.42 | 96.475 | 14240.0 |
| 2020-07-22 04:55:00 | AAPL | Stock | 96.495 | 96.55 | 96.4225 | 96.55 | 14740.0 |
| 2020-07-22 05:00:00 | AAPL | Stock | 96.5475 | 96.5475 | 96.5125 | 96.5125 | 1836.0 |
| 2020-07-22 05:05:00 | AAPL | Stock | 96.5 | 96.695 | 96.5 | 96.675 | 13500.0 |
| 2020-07-22 05:10:00 | AAPL | Stock | 96.65 | 96.65 | 96.5 | 96.5 | 1384.0 |
| 2020-07-22 05:15:00 | AAPL | Stock | 96.425 | 96.625 | 96.425 | 96.5925 | 13096.0 |
| 2020-07-22 05:20:00 | AAPL | Stock | 96.6225 | 96.625 | 96.6225 | 96.625 | 2992.0 |
| 2020-07-22 05:25:00 | AAPL | Stock | 96.625 | 96.745 | 96.625 | 96.745 | 800.0 |
| 2020-07-22 05:30:00 | AAPL | Stock | 96.725 | 96.725 | 96.725 | 96.725 | 800.0 |
| 2020-07-22 05:35:00 | AAPL | Stock | 96.85 | 96.85 | 96.85 | 96.85 | 1632.0 |
| 2020-07-22 05:40:00 | AAPL | Stock | 96.85 | 96.8625 | 96.81 | 96.8625 | 1600.0 |
| 2020-07-22 05:50:00 | AAPL | Stock | 96.925 | 96.925 | 96.9 | 96.9 | 2400.0 |
| 2020-07-22 05:55:00 | AAPL | Stock | 96.9425 | 97.0 | 96.9425 | 96.995 | 2540.0 |
| 2020-07-22 06:05:00 | AAPL | Stock | 96.975 | 97.0175 | 96.975 | 97.0175 | 800.0 |
| 2020-07-22 06:10:00 | AAPL | Stock | 97.04 | 97.04 | 97.04 | 97.04 | 400.0 |
| 2020-07-22 06:15:00 | AAPL | Stock | 97.0675 | 97.0675 | 97.0675 | 97.0675 | 800.0 |
| 2020-07-22 06:20:00 | AAPL | Stock | 97.1375 | 97.1375 | 97.1375 | 97.1375 | 580.0 |
| 2020-07-22 06:25:00 | AAPL | Stock | 97.415 | 97.415 | 97.2575 | 97.26 | 2400.0 |
| 2020-07-22 06:30:00 | AAPL | Stock | 97.26 | 97.3125 | 97.26 | 97.2825 | 7500.0 |
| 2020-07-22 06:35:00 | AAPL | Stock | 97.285 | 97.285 | 97.1975 | 97.1975 | 1788.0 |
| 2020-07-22 06:50:00 | AAPL | Stock | 97.16 | 97.16 | 97.16 | 97.16 | 1436.0 |
| 2020-07-22 06:55:00 | AAPL | Stock | 97.2425 | 97.345 | 97.2375 | 97.345 | 19608.0 |
| 2020-07-22 07:00:00 | AAPL | Stock | 97.4225 | 97.4225 | 97.2525 | 97.375 | 16820.0 |
| 2020-07-22 07:05:00 | AAPL | Stock | 97.375 | 97.4425 | 97.375 | 97.4125 | 6148.0 |
| 2020-07-22 07:10:00 | AAPL | Stock | 97.4125 | 97.425 | 97.3475 | 97.3475 | 19684.0 |
| 2020-07-22 07:15:00 | AAPL | Stock | 97.35 | 97.355 | 97.3125 | 97.355 | 12896.0 |
| 2020-07-22 07:20:00 | AAPL | Stock | 97.355 | 97.355 | 97.32 | 97.32 | 6152.0 |
| 2020-07-22 07:25:00 | AAPL | Stock | 97.3 | 97.3875 | 97.3 | 97.3875 | 15032.0 |
| 2020-07-22 07:30:00 | AAPL | Stock | 97.3975 | 97.43 | 97.375 | 97.375 | 15552.0 |
| 2020-07-22 07:35:00 | AAPL | Stock | 97.375 | 97.38 | 97.33 | 97.35 | 9476.0 |
| 2020-07-22 07:40:00 | AAPL | Stock | 97.35 | 97.375 | 97.315 | 97.35 | 5728.0 |
| 2020-07-22 07:45:00 | AAPL | Stock | 97.3625 | 97.3625 | 97.3275 | 97.3275 | 3200.0 |
| 2020-07-22 07:50:00 | AAPL | Stock | 97.2875 | 97.3 | 97.2875 | 97.3 | 3600.0 |
| 2020-07-22 07:55:00 | AAPL | Stock | 97.2875 | 97.35 | 97.25 | 97.25 | 7308.0 |
| 2020-07-22 08:00:00 | AAPL | Stock | 97.3 | 97.4835 | 97.2375 | 97.2375 | 66816.0 |
| 2020-07-22 08:05:00 | AAPL | Stock | 97.2375 | 97.2925 | 97.18 | 97.2925 | 23644.0 |
| 2020-07-22 08:10:00 | AAPL | Stock | 97.32 | 97.36 | 97.256 | 97.345 | 13416.0 |
| 2020-07-22 08:15:00 | AAPL | Stock | 97.3375 | 97.3375 | 97.25 | 97.25 | 20044.0 |
| 2020-07-22 08:20:00 | AAPL | Stock | 97.25 | 97.265 | 97.215 | 97.265 | 111796.0 |
| 2020-07-22 08:25:00 | AAPL | Stock | 97.3025 | 97.3025 | 97.2173 | 97.2173 | 7864.0 |
> showing 50 of 415,404 rows — these rows as CSV