PREVIEW / stock_5min / 2018-07-10
file: by_date/stock_5min/2018/2018-07-10.parquet size: 5.6 MB rows: 360,606 symbols: 2,823
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-07-10 04:00:00 | AAPL | Stock | 47.6425 | 47.6425 | 47.565 | 47.565 | 2236.0 |
| 2018-07-10 05:20:00 | AAPL | Stock | 47.565 | 47.565 | 47.5625 | 47.565 | 5312.0 |
| 2018-07-10 05:25:00 | AAPL | Stock | 47.5925 | 47.6025 | 47.5925 | 47.6025 | 4400.0 |
| 2018-07-10 05:30:00 | AAPL | Stock | 47.625 | 47.6425 | 47.625 | 47.6425 | 1200.0 |
| 2018-07-10 05:55:00 | AAPL | Stock | 47.6175 | 47.6975 | 47.6175 | 47.6975 | 1376.0 |
| 2018-07-10 06:20:00 | AAPL | Stock | 47.66 | 47.68 | 47.66 | 47.68 | 2000.0 |
| 2018-07-10 06:35:00 | AAPL | Stock | 47.6725 | 47.6725 | 47.6725 | 47.6725 | 1600.0 |
| 2018-07-10 06:50:00 | AAPL | Stock | 47.65 | 47.66 | 47.65 | 47.66 | 3612.0 |
| 2018-07-10 06:55:00 | AAPL | Stock | 47.6725 | 47.6875 | 47.665 | 47.6875 | 21600.0 |
| 2018-07-10 07:00:00 | AAPL | Stock | 47.685 | 47.7075 | 47.675 | 47.7075 | 30356.0 |
| 2018-07-10 07:05:00 | AAPL | Stock | 47.69 | 47.69 | 47.675 | 47.675 | 12396.0 |
| 2018-07-10 07:10:00 | AAPL | Stock | 47.655 | 47.695 | 47.645 | 47.675 | 19600.0 |
| 2018-07-10 07:15:00 | AAPL | Stock | 47.6925 | 47.7025 | 47.6925 | 47.7025 | 4480.0 |
| 2018-07-10 07:20:00 | AAPL | Stock | 47.725 | 47.725 | 47.7025 | 47.7025 | 2800.0 |
| 2018-07-10 07:25:00 | AAPL | Stock | 47.7075 | 47.7075 | 47.6975 | 47.6975 | 3784.0 |
| 2018-07-10 07:30:00 | AAPL | Stock | 47.6875 | 47.6875 | 47.65 | 47.6825 | 16792.0 |
| 2018-07-10 07:35:00 | AAPL | Stock | 47.6825 | 47.6875 | 47.675 | 47.6875 | 6084.0 |
| 2018-07-10 07:40:00 | AAPL | Stock | 47.6925 | 47.6925 | 47.6875 | 47.6875 | 3272.0 |
| 2018-07-10 07:45:00 | AAPL | Stock | 47.6925 | 47.75 | 47.675 | 47.75 | 25524.0 |
| 2018-07-10 07:50:00 | AAPL | Stock | 47.7275 | 47.7275 | 47.67 | 47.67 | 31828.0 |
| 2018-07-10 07:55:00 | AAPL | Stock | 47.675 | 47.695 | 47.675 | 47.695 | 2968.0 |
| 2018-07-10 08:00:00 | AAPL | Stock | 47.7105 | 47.735 | 47.67 | 47.67 | 48596.0 |
| 2018-07-10 08:05:00 | AAPL | Stock | 47.6625 | 47.67 | 47.6625 | 47.67 | 6928.0 |
| 2018-07-10 08:10:00 | AAPL | Stock | 47.6525 | 47.67 | 47.6525 | 47.67 | 3332.0 |
| 2018-07-10 08:15:00 | AAPL | Stock | 47.6625 | 47.6875 | 47.6625 | 47.675 | 17908.0 |
| 2018-07-10 08:20:00 | AAPL | Stock | 47.6625 | 47.685 | 47.6625 | 47.685 | 9216.0 |
| 2018-07-10 08:25:00 | AAPL | Stock | 47.6675 | 47.6975 | 47.625 | 47.625 | 27076.0 |
| 2018-07-10 08:30:00 | AAPL | Stock | 47.6375 | 47.655 | 47.625 | 47.6375 | 35264.0 |
| 2018-07-10 08:35:00 | AAPL | Stock | 47.6375 | 47.675 | 47.63 | 47.67 | 12816.0 |
| 2018-07-10 08:40:00 | AAPL | Stock | 47.6725 | 47.6725 | 47.6575 | 47.6725 | 5844.0 |
| 2018-07-10 08:45:00 | AAPL | Stock | 47.695 | 47.7 | 47.695 | 47.6975 | 4800.0 |
| 2018-07-10 08:50:00 | AAPL | Stock | 47.705 | 47.705 | 47.675 | 47.675 | 5200.0 |
| 2018-07-10 08:55:00 | AAPL | Stock | 47.675 | 47.675 | 47.6675 | 47.675 | 2800.0 |
| 2018-07-10 09:00:00 | AAPL | Stock | 47.665 | 47.67 | 47.65 | 47.65 | 30444.0 |
| 2018-07-10 09:05:00 | AAPL | Stock | 47.6525 | 47.6875 | 47.65 | 47.6875 | 13616.0 |
| 2018-07-10 09:10:00 | AAPL | Stock | 47.6875 | 47.6875 | 47.685 | 47.685 | 4100.0 |
| 2018-07-10 09:15:00 | AAPL | Stock | 47.6875 | 47.7075 | 47.6875 | 47.7075 | 2700.0 |
| 2018-07-10 09:20:00 | AAPL | Stock | 47.7075 | 47.7125 | 47.6775 | 47.7 | 15032.0 |
| 2018-07-10 09:25:00 | AAPL | Stock | 47.7 | 47.7225 | 47.6575 | 47.665 | 24204.0 |
| 2018-07-10 09:30:00 | AAPL | Stock | 47.645 | 47.7825 | 47.6375 | 47.6625 | 2939724.0 |
| 2018-07-10 09:35:00 | AAPL | Stock | 47.6625 | 47.7225 | 47.5975 | 47.6275 | 1251968.0 |
| 2018-07-10 09:40:00 | AAPL | Stock | 47.6287 | 47.6525 | 47.555 | 47.65 | 1422532.0 |
| 2018-07-10 09:45:00 | AAPL | Stock | 47.6538 | 47.6675 | 47.5725 | 47.59 | 1093588.0 |
| 2018-07-10 09:50:00 | AAPL | Stock | 47.5938 | 47.628 | 47.5675 | 47.5875 | 835896.0 |
| 2018-07-10 09:55:00 | AAPL | Stock | 47.5875 | 47.67 | 47.58 | 47.65 | 1260164.0 |
| 2018-07-10 10:00:00 | AAPL | Stock | 47.6475 | 47.675 | 47.62 | 47.62 | 1098540.0 |
| 2018-07-10 10:05:00 | AAPL | Stock | 47.6225 | 47.64 | 47.5775 | 47.5925 | 750144.0 |
| 2018-07-10 10:10:00 | AAPL | Stock | 47.5925 | 47.6325 | 47.5675 | 47.575 | 622500.0 |
| 2018-07-10 10:15:00 | AAPL | Stock | 47.5775 | 47.68 | 47.5775 | 47.675 | 1038524.0 |
| 2018-07-10 10:20:00 | AAPL | Stock | 47.6775 | 47.73 | 47.6625 | 47.6675 | 1097780.0 |
> showing 50 of 360,606 rows — these rows as CSV