PREVIEW / stock_5min / 2019-05-28
file: by_date/stock_5min/2019/2019-05-28.parquet size: 5.6 MB rows: 359,079 symbols: 2,601
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-05-28 04:00:00 | AAPL | Stock | 44.6875 | 44.6875 | 44.6875 | 44.6875 | 440.0 |
| 2019-05-28 04:05:00 | AAPL | Stock | 44.6875 | 44.6875 | 44.68 | 44.68 | 1720.0 |
| 2019-05-28 04:10:00 | AAPL | Stock | 44.68 | 44.6975 | 44.6575 | 44.6575 | 1600.0 |
| 2019-05-28 04:15:00 | AAPL | Stock | 44.6575 | 44.6575 | 44.6375 | 44.6375 | 1320.0 |
| 2019-05-28 04:20:00 | AAPL | Stock | 44.6225 | 44.6225 | 44.5625 | 44.5625 | 3064.0 |
| 2019-05-28 04:25:00 | AAPL | Stock | 44.565 | 44.565 | 44.565 | 44.565 | 400.0 |
| 2019-05-28 04:30:00 | AAPL | Stock | 44.595 | 44.595 | 44.545 | 44.545 | 9704.0 |
| 2019-05-28 04:35:00 | AAPL | Stock | 44.56 | 44.56 | 44.56 | 44.56 | 400.0 |
| 2019-05-28 04:40:00 | AAPL | Stock | 44.6075 | 44.6075 | 44.6075 | 44.6075 | 400.0 |
| 2019-05-28 04:50:00 | AAPL | Stock | 44.6025 | 44.6025 | 44.5225 | 44.6 | 5656.0 |
| 2019-05-28 04:55:00 | AAPL | Stock | 44.545 | 44.545 | 44.545 | 44.545 | 400.0 |
| 2019-05-28 05:00:00 | AAPL | Stock | 44.625 | 44.625 | 44.56 | 44.56 | 3028.0 |
| 2019-05-28 05:05:00 | AAPL | Stock | 44.5375 | 44.625 | 44.5375 | 44.625 | 2152.0 |
| 2019-05-28 05:15:00 | AAPL | Stock | 44.6 | 44.6 | 44.5925 | 44.5925 | 4060.0 |
| 2019-05-28 05:25:00 | AAPL | Stock | 44.55 | 44.625 | 44.55 | 44.625 | 2616.0 |
| 2019-05-28 05:30:00 | AAPL | Stock | 44.6575 | 44.6575 | 44.6575 | 44.6575 | 400.0 |
| 2019-05-28 05:35:00 | AAPL | Stock | 44.68 | 44.68 | 44.68 | 44.68 | 400.0 |
| 2019-05-28 05:40:00 | AAPL | Stock | 44.665 | 44.665 | 44.665 | 44.665 | 400.0 |
| 2019-05-28 05:55:00 | AAPL | Stock | 44.6975 | 44.7425 | 44.6875 | 44.725 | 5200.0 |
| 2019-05-28 06:00:00 | AAPL | Stock | 44.6425 | 44.6425 | 44.6425 | 44.6425 | 880.0 |
| 2019-05-28 06:05:00 | AAPL | Stock | 44.6425 | 44.6425 | 44.525 | 44.525 | 9800.0 |
| 2019-05-28 06:10:00 | AAPL | Stock | 44.525 | 44.5275 | 44.5125 | 44.5125 | 3796.0 |
| 2019-05-28 06:15:00 | AAPL | Stock | 44.5125 | 44.5125 | 44.4725 | 44.475 | 5924.0 |
| 2019-05-28 06:20:00 | AAPL | Stock | 44.5325 | 44.5325 | 44.5325 | 44.5325 | 1200.0 |
| 2019-05-28 06:25:00 | AAPL | Stock | 44.5075 | 44.5075 | 44.5075 | 44.5075 | 1180.0 |
| 2019-05-28 06:45:00 | AAPL | Stock | 44.5025 | 44.51 | 44.5 | 44.51 | 2312.0 |
| 2019-05-28 06:50:00 | AAPL | Stock | 44.545 | 44.6 | 44.545 | 44.6 | 2612.0 |
| 2019-05-28 07:00:00 | AAPL | Stock | 44.525 | 44.5625 | 44.525 | 44.5475 | 9400.0 |
| 2019-05-28 07:05:00 | AAPL | Stock | 44.535 | 44.5875 | 44.535 | 44.5875 | 2888.0 |
| 2019-05-28 07:10:00 | AAPL | Stock | 44.6 | 44.6075 | 44.575 | 44.575 | 5740.0 |
| 2019-05-28 07:20:00 | AAPL | Stock | 44.5775 | 44.5775 | 44.575 | 44.575 | 800.0 |
| 2019-05-28 07:25:00 | AAPL | Stock | 44.5625 | 44.5625 | 44.55 | 44.55 | 2000.0 |
| 2019-05-28 07:30:00 | AAPL | Stock | 44.55 | 44.6 | 44.55 | 44.6 | 5368.0 |
| 2019-05-28 07:35:00 | AAPL | Stock | 44.595 | 44.6025 | 44.595 | 44.6025 | 2000.0 |
| 2019-05-28 07:40:00 | AAPL | Stock | 44.6025 | 44.6025 | 44.6025 | 44.6025 | 6480.0 |
| 2019-05-28 07:45:00 | AAPL | Stock | 44.6375 | 44.66 | 44.6375 | 44.66 | 7072.0 |
| 2019-05-28 07:50:00 | AAPL | Stock | 44.695 | 44.8525 | 44.695 | 44.85 | 19188.0 |
| 2019-05-28 07:55:00 | AAPL | Stock | 44.7825 | 44.8 | 44.7425 | 44.8 | 9244.0 |
| 2019-05-28 08:00:00 | AAPL | Stock | 44.531 | 44.8125 | 44.525 | 44.7975 | 83400.0 |
| 2019-05-28 08:05:00 | AAPL | Stock | 44.7898 | 44.7925 | 44.72 | 44.75 | 10544.0 |
| 2019-05-28 08:10:00 | AAPL | Stock | 44.75 | 44.775 | 44.75 | 44.775 | 21516.0 |
| 2019-05-28 08:15:00 | AAPL | Stock | 44.7775 | 44.84 | 44.75 | 44.825 | 32128.0 |
| 2019-05-28 08:20:00 | AAPL | Stock | 44.825 | 44.84 | 44.805 | 44.825 | 29768.0 |
| 2019-05-28 08:25:00 | AAPL | Stock | 44.805 | 44.84 | 44.805 | 44.825 | 11796.0 |
| 2019-05-28 08:30:00 | AAPL | Stock | 44.835 | 44.8425 | 44.78 | 44.78 | 28944.0 |
| 2019-05-28 08:35:00 | AAPL | Stock | 44.78 | 44.8 | 44.755 | 44.7575 | 8796.0 |
| 2019-05-28 08:40:00 | AAPL | Stock | 44.7875 | 44.8025 | 44.76 | 44.76 | 16280.0 |
| 2019-05-28 08:45:00 | AAPL | Stock | 44.7725 | 44.795 | 44.7325 | 44.7575 | 14376.0 |
| 2019-05-28 08:50:00 | AAPL | Stock | 44.775 | 44.815 | 44.625 | 44.6925 | 39480.0 |
| 2019-05-28 08:55:00 | AAPL | Stock | 44.715 | 44.7525 | 44.64 | 44.6625 | 44692.0 |
> showing 50 of 359,079 rows — these rows as CSV