PREVIEW / stock_5min / 2018-06-29
file: by_date/stock_5min/2018/2018-06-29.parquet size: 5.6 MB rows: 361,208 symbols: 2,837
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 |
|---|---|---|---|---|---|---|---|
| 2018-06-29 04:00:00 | AAPL | Stock | 46.615 | 46.615 | 46.615 | 46.615 | 400.0 |
| 2018-06-29 04:05:00 | AAPL | Stock | 46.6975 | 46.6975 | 46.6975 | 46.6975 | 1600.0 |
| 2018-06-29 04:10:00 | AAPL | Stock | 46.7225 | 46.765 | 46.7225 | 46.765 | 8060.0 |
| 2018-06-29 04:20:00 | AAPL | Stock | 46.7675 | 46.7675 | 46.7675 | 46.7675 | 4712.0 |
| 2018-06-29 04:25:00 | AAPL | Stock | 46.7675 | 46.7675 | 46.7675 | 46.7675 | 5840.0 |
| 2018-06-29 04:30:00 | AAPL | Stock | 46.825 | 46.825 | 46.8225 | 46.8225 | 8316.0 |
| 2018-06-29 04:35:00 | AAPL | Stock | 46.8225 | 46.8225 | 46.8225 | 46.8225 | 1600.0 |
| 2018-06-29 04:50:00 | AAPL | Stock | 46.8 | 46.8 | 46.8 | 46.8 | 3808.0 |
| 2018-06-29 05:00:00 | AAPL | Stock | 46.8225 | 46.8225 | 46.8225 | 46.8225 | 800.0 |
| 2018-06-29 05:30:00 | AAPL | Stock | 46.81 | 46.8125 | 46.81 | 46.8125 | 2728.0 |
| 2018-06-29 05:35:00 | AAPL | Stock | 46.8125 | 46.8125 | 46.8125 | 46.8125 | 780.0 |
| 2018-06-29 05:50:00 | AAPL | Stock | 46.75 | 46.75 | 46.75 | 46.75 | 400.0 |
| 2018-06-29 06:00:00 | AAPL | Stock | 46.7425 | 46.7425 | 46.7425 | 46.7425 | 2000.0 |
| 2018-06-29 06:20:00 | AAPL | Stock | 46.7475 | 46.7475 | 46.7475 | 46.7475 | 8608.0 |
| 2018-06-29 06:25:00 | AAPL | Stock | 46.7 | 46.7 | 46.5975 | 46.5975 | 49152.0 |
| 2018-06-29 06:30:00 | AAPL | Stock | 46.595 | 46.5975 | 46.595 | 46.5975 | 12088.0 |
| 2018-06-29 06:35:00 | AAPL | Stock | 46.65 | 46.65 | 46.65 | 46.65 | 15820.0 |
| 2018-06-29 06:40:00 | AAPL | Stock | 46.63 | 46.63 | 46.63 | 46.63 | 5372.0 |
| 2018-06-29 06:45:00 | AAPL | Stock | 46.675 | 46.675 | 46.675 | 46.675 | 2000.0 |
| 2018-06-29 06:55:00 | AAPL | Stock | 46.6425 | 46.6425 | 46.6375 | 46.6375 | 4928.0 |
| 2018-06-29 07:00:00 | AAPL | Stock | 46.6425 | 46.6425 | 46.6 | 46.64 | 12800.0 |
| 2018-06-29 07:05:00 | AAPL | Stock | 46.625 | 46.625 | 46.5875 | 46.5875 | 3000.0 |
| 2018-06-29 07:10:00 | AAPL | Stock | 46.59 | 46.635 | 46.58 | 46.635 | 23052.0 |
| 2018-06-29 07:15:00 | AAPL | Stock | 46.6325 | 46.6325 | 46.6325 | 46.6325 | 4000.0 |
| 2018-06-29 07:20:00 | AAPL | Stock | 46.6275 | 46.6625 | 46.6275 | 46.6625 | 7924.0 |
| 2018-06-29 07:25:00 | AAPL | Stock | 46.6675 | 46.675 | 46.6675 | 46.675 | 840.0 |
| 2018-06-29 07:35:00 | AAPL | Stock | 46.6675 | 46.6975 | 46.66 | 46.6975 | 41240.0 |
| 2018-06-29 07:40:00 | AAPL | Stock | 46.695 | 46.6975 | 46.695 | 46.6975 | 3200.0 |
| 2018-06-29 07:45:00 | AAPL | Stock | 46.6925 | 46.7 | 46.6925 | 46.6975 | 8680.0 |
| 2018-06-29 07:50:00 | AAPL | Stock | 46.6975 | 46.6975 | 46.6975 | 46.6975 | 400.0 |
| 2018-06-29 07:55:00 | AAPL | Stock | 46.675 | 46.675 | 46.6625 | 46.6625 | 8748.0 |
| 2018-06-29 08:00:00 | AAPL | Stock | 46.625 | 46.71 | 46.625 | 46.695 | 47156.0 |
| 2018-06-29 08:05:00 | AAPL | Stock | 46.6825 | 46.71 | 46.6825 | 46.71 | 1592.0 |
| 2018-06-29 08:10:00 | AAPL | Stock | 46.7 | 46.7225 | 46.675 | 46.68 | 8484.0 |
| 2018-06-29 08:15:00 | AAPL | Stock | 46.68 | 46.71 | 46.625 | 46.625 | 41160.0 |
| 2018-06-29 08:20:00 | AAPL | Stock | 46.5925 | 46.6225 | 46.585 | 46.6 | 9840.0 |
| 2018-06-29 08:25:00 | AAPL | Stock | 46.6 | 46.64 | 46.6 | 46.625 | 14788.0 |
| 2018-06-29 08:30:00 | AAPL | Stock | 46.64 | 46.6875 | 46.64 | 46.6425 | 5112.0 |
| 2018-06-29 08:35:00 | AAPL | Stock | 46.6715 | 46.6715 | 46.6 | 46.605 | 14676.0 |
| 2018-06-29 08:40:00 | AAPL | Stock | 46.6 | 46.63 | 46.5875 | 46.625 | 28416.0 |
| 2018-06-29 08:45:00 | AAPL | Stock | 46.635 | 46.635 | 46.635 | 46.635 | 400.0 |
| 2018-06-29 08:50:00 | AAPL | Stock | 46.6325 | 46.6475 | 46.6325 | 46.6475 | 2040.0 |
| 2018-06-29 08:55:00 | AAPL | Stock | 46.65 | 46.655 | 46.6025 | 46.6025 | 16216.0 |
| 2018-06-29 09:00:00 | AAPL | Stock | 46.5975 | 46.6125 | 46.595 | 46.6125 | 11700.0 |
| 2018-06-29 09:05:00 | AAPL | Stock | 46.61 | 46.61 | 46.6 | 46.6075 | 2800.0 |
| 2018-06-29 09:10:00 | AAPL | Stock | 46.6175 | 46.625 | 46.6 | 46.6 | 16160.0 |
| 2018-06-29 09:15:00 | AAPL | Stock | 46.615 | 46.6175 | 46.595 | 46.6175 | 3232.0 |
| 2018-06-29 09:20:00 | AAPL | Stock | 46.605 | 46.62 | 46.605 | 46.6168 | 2200.0 |
| 2018-06-29 09:25:00 | AAPL | Stock | 46.6075 | 46.6175 | 46.5625 | 46.565 | 15708.0 |
| 2018-06-29 09:30:00 | AAPL | Stock | 46.5725 | 46.7975 | 46.5625 | 46.68 | 3095780.0 |
> showing 50 of 361,208 rows — these rows as CSV