PREVIEW / stock_5min / 2019-06-12
file: by_date/stock_5min/2019/2019-06-12.parquet size: 5.5 MB rows: 353,164 symbols: 2,593
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 |
|---|---|---|---|---|---|---|---|
| 2019-06-12 04:00:00 | AAPL | Stock | 48.5425 | 48.5425 | 48.375 | 48.3875 | 1672.0 |
| 2019-06-12 04:05:00 | AAPL | Stock | 48.3625 | 48.3625 | 48.3625 | 48.3625 | 400.0 |
| 2019-06-12 04:15:00 | AAPL | Stock | 48.3275 | 48.3275 | 48.3275 | 48.3275 | 3284.0 |
| 2019-06-12 05:05:00 | AAPL | Stock | 48.35 | 48.35 | 48.35 | 48.35 | 720.0 |
| 2019-06-12 05:10:00 | AAPL | Stock | 48.35 | 48.35 | 48.35 | 48.35 | 400.0 |
| 2019-06-12 05:25:00 | AAPL | Stock | 48.35 | 48.35 | 48.35 | 48.35 | 2380.0 |
| 2019-06-12 06:05:00 | AAPL | Stock | 48.2975 | 48.2975 | 48.2975 | 48.2975 | 644.0 |
| 2019-06-12 06:40:00 | AAPL | Stock | 48.31 | 48.3475 | 48.3 | 48.3475 | 6928.0 |
| 2019-06-12 06:45:00 | AAPL | Stock | 48.35 | 48.35 | 48.35 | 48.35 | 400.0 |
| 2019-06-12 06:50:00 | AAPL | Stock | 48.35 | 48.35 | 48.35 | 48.35 | 400.0 |
| 2019-06-12 07:00:00 | AAPL | Stock | 48.37 | 48.4125 | 48.37 | 48.4125 | 16068.0 |
| 2019-06-12 07:05:00 | AAPL | Stock | 48.405 | 48.405 | 48.35 | 48.3525 | 10868.0 |
| 2019-06-12 07:10:00 | AAPL | Stock | 48.3275 | 48.33 | 48.325 | 48.325 | 4200.0 |
| 2019-06-12 07:15:00 | AAPL | Stock | 48.325 | 48.3475 | 48.325 | 48.325 | 14420.0 |
| 2019-06-12 07:20:00 | AAPL | Stock | 48.3 | 48.3 | 48.3 | 48.3 | 2804.0 |
| 2019-06-12 07:25:00 | AAPL | Stock | 48.3 | 48.3 | 48.28 | 48.3 | 6660.0 |
| 2019-06-12 07:30:00 | AAPL | Stock | 48.2875 | 48.3275 | 48.2875 | 48.3275 | 12108.0 |
| 2019-06-12 07:35:00 | AAPL | Stock | 48.32 | 48.3425 | 48.295 | 48.295 | 6044.0 |
| 2019-06-12 07:40:00 | AAPL | Stock | 48.2875 | 48.3025 | 48.285 | 48.29 | 3364.0 |
| 2019-06-12 07:45:00 | AAPL | Stock | 48.3025 | 48.33 | 48.3025 | 48.33 | 2400.0 |
| 2019-06-12 07:55:00 | AAPL | Stock | 48.295 | 48.295 | 48.295 | 48.295 | 532.0 |
| 2019-06-12 08:00:00 | AAPL | Stock | 48.3975 | 48.425 | 48.2655 | 48.3125 | 81224.0 |
| 2019-06-12 08:05:00 | AAPL | Stock | 48.3175 | 48.3175 | 48.3 | 48.3 | 3860.0 |
| 2019-06-12 08:10:00 | AAPL | Stock | 48.3 | 48.345 | 48.3 | 48.345 | 9072.0 |
| 2019-06-12 08:15:00 | AAPL | Stock | 48.325 | 48.325 | 48.2975 | 48.3 | 10592.0 |
| 2019-06-12 08:20:00 | AAPL | Stock | 48.3175 | 48.345 | 48.3125 | 48.345 | 5952.0 |
| 2019-06-12 08:25:00 | AAPL | Stock | 48.33 | 48.33 | 48.2925 | 48.2925 | 13624.0 |
| 2019-06-12 08:30:00 | AAPL | Stock | 48.32 | 48.4125 | 48.32 | 48.3375 | 33468.0 |
| 2019-06-12 08:35:00 | AAPL | Stock | 48.35 | 48.35 | 48.3125 | 48.3125 | 9356.0 |
| 2019-06-12 08:40:00 | AAPL | Stock | 48.3175 | 48.3325 | 48.3175 | 48.3325 | 2400.0 |
| 2019-06-12 08:45:00 | AAPL | Stock | 48.3125 | 48.3175 | 48.3 | 48.3025 | 10380.0 |
| 2019-06-12 08:50:00 | AAPL | Stock | 48.3005 | 48.325 | 48.3005 | 48.3175 | 5900.0 |
| 2019-06-12 08:55:00 | AAPL | Stock | 48.315 | 48.335 | 48.315 | 48.3175 | 10824.0 |
| 2019-06-12 09:00:00 | AAPL | Stock | 48.335 | 48.3625 | 48.325 | 48.3625 | 18392.0 |
| 2019-06-12 09:05:00 | AAPL | Stock | 48.375 | 48.4075 | 48.375 | 48.4075 | 14372.0 |
| 2019-06-12 09:10:00 | AAPL | Stock | 48.4 | 48.4225 | 48.38 | 48.4225 | 17220.0 |
| 2019-06-12 09:15:00 | AAPL | Stock | 48.4 | 48.4225 | 48.4 | 48.42 | 11256.0 |
| 2019-06-12 09:20:00 | AAPL | Stock | 48.43 | 48.4575 | 48.4 | 48.4 | 29696.0 |
| 2019-06-12 09:25:00 | AAPL | Stock | 48.4475 | 48.525 | 48.4475 | 48.525 | 11536.0 |
| 2019-06-12 09:30:00 | AAPL | Stock | 48.49 | 48.6295 | 48.3462 | 48.6 | 4189968.0 |
| 2019-06-12 09:35:00 | AAPL | Stock | 48.6025 | 48.6975 | 48.5575 | 48.6 | 1840864.0 |
| 2019-06-12 09:40:00 | AAPL | Stock | 48.605 | 48.675 | 48.5588 | 48.5925 | 1627040.0 |
| 2019-06-12 09:45:00 | AAPL | Stock | 48.595 | 48.68 | 48.5525 | 48.613 | 1535312.0 |
| 2019-06-12 09:50:00 | AAPL | Stock | 48.62 | 48.7475 | 48.62 | 48.685 | 1597188.0 |
| 2019-06-12 09:55:00 | AAPL | Stock | 48.685 | 48.808 | 48.645 | 48.795 | 1410052.0 |
| 2019-06-12 10:00:00 | AAPL | Stock | 48.7975 | 48.8058 | 48.7325 | 48.755 | 1156776.0 |
| 2019-06-12 10:05:00 | AAPL | Stock | 48.755 | 48.7612 | 48.655 | 48.675 | 1265684.0 |
| 2019-06-12 10:10:00 | AAPL | Stock | 48.6738 | 48.7275 | 48.6125 | 48.6675 | 982524.0 |
| 2019-06-12 10:15:00 | AAPL | Stock | 48.6665 | 48.7 | 48.6425 | 48.6775 | 723916.0 |
| 2019-06-12 10:20:00 | AAPL | Stock | 48.6775 | 48.7928 | 48.672 | 48.6975 | 958160.0 |
> showing 50 of 353,164 rows — these rows as CSV