PREVIEW / stock_5min / 2018-06-14
file: by_date/stock_5min/2018/2018-06-14.parquet size: 5.7 MB rows: 365,123 symbols: 2,828
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-14 04:00:00 | AAPL | Stock | 47.6575 | 47.6575 | 47.6575 | 47.6575 | 2400.0 |
| 2018-06-14 04:05:00 | AAPL | Stock | 47.6575 | 47.6575 | 47.6575 | 47.6575 | 400.0 |
| 2018-06-14 05:05:00 | AAPL | Stock | 47.66 | 47.66 | 47.66 | 47.66 | 2524.0 |
| 2018-06-14 05:25:00 | AAPL | Stock | 47.65 | 47.6625 | 47.65 | 47.6625 | 8000.0 |
| 2018-06-14 05:35:00 | AAPL | Stock | 47.725 | 47.725 | 47.725 | 47.725 | 400.0 |
| 2018-06-14 05:40:00 | AAPL | Stock | 47.7225 | 47.7225 | 47.7225 | 47.7225 | 400.0 |
| 2018-06-14 05:55:00 | AAPL | Stock | 47.6225 | 47.6225 | 47.6225 | 47.6225 | 1600.0 |
| 2018-06-14 06:05:00 | AAPL | Stock | 47.5875 | 47.5875 | 47.585 | 47.5875 | 8000.0 |
| 2018-06-14 06:15:00 | AAPL | Stock | 47.6275 | 47.6275 | 47.6275 | 47.6275 | 400.0 |
| 2018-06-14 06:30:00 | AAPL | Stock | 47.625 | 47.625 | 47.625 | 47.625 | 800.0 |
| 2018-06-14 06:35:00 | AAPL | Stock | 47.625 | 47.625 | 47.625 | 47.625 | 600.0 |
| 2018-06-14 07:00:00 | AAPL | Stock | 47.625 | 47.65 | 47.625 | 47.625 | 5200.0 |
| 2018-06-14 07:05:00 | AAPL | Stock | 47.6275 | 47.6275 | 47.625 | 47.625 | 1352.0 |
| 2018-06-14 07:10:00 | AAPL | Stock | 47.6275 | 47.6275 | 47.61 | 47.61 | 9120.0 |
| 2018-06-14 07:15:00 | AAPL | Stock | 47.625 | 47.625 | 47.625 | 47.625 | 1188.0 |
| 2018-06-14 07:20:00 | AAPL | Stock | 47.6475 | 47.6725 | 47.6475 | 47.66 | 21392.0 |
| 2018-06-14 07:25:00 | AAPL | Stock | 47.6575 | 47.6825 | 47.6575 | 47.6825 | 3600.0 |
| 2018-06-14 07:30:00 | AAPL | Stock | 47.705 | 47.705 | 47.6975 | 47.6975 | 1532.0 |
| 2018-06-14 07:35:00 | AAPL | Stock | 47.7025 | 47.7125 | 47.7025 | 47.7125 | 2212.0 |
| 2018-06-14 07:45:00 | AAPL | Stock | 47.7325 | 47.7325 | 47.71 | 47.73 | 8668.0 |
| 2018-06-14 07:50:00 | AAPL | Stock | 47.7625 | 47.7675 | 47.75 | 47.7675 | 9116.0 |
| 2018-06-14 07:55:00 | AAPL | Stock | 47.785 | 47.785 | 47.785 | 47.785 | 4292.0 |
| 2018-06-14 08:00:00 | AAPL | Stock | 47.6775 | 47.8 | 47.62 | 47.7725 | 48464.0 |
| 2018-06-14 08:05:00 | AAPL | Stock | 47.7675 | 47.7925 | 47.75 | 47.7925 | 12496.0 |
| 2018-06-14 08:10:00 | AAPL | Stock | 47.8 | 47.8 | 47.775 | 47.775 | 25824.0 |
| 2018-06-14 08:15:00 | AAPL | Stock | 47.8 | 47.8 | 47.7925 | 47.795 | 6292.0 |
| 2018-06-14 08:20:00 | AAPL | Stock | 47.8 | 47.835 | 47.8 | 47.835 | 42756.0 |
| 2018-06-14 08:25:00 | AAPL | Stock | 47.825 | 47.825 | 47.825 | 47.825 | 6156.0 |
| 2018-06-14 08:30:00 | AAPL | Stock | 47.825 | 47.85 | 47.825 | 47.84 | 25720.0 |
| 2018-06-14 08:35:00 | AAPL | Stock | 47.84 | 47.855 | 47.8325 | 47.8375 | 44788.0 |
| 2018-06-14 08:40:00 | AAPL | Stock | 47.835 | 47.84 | 47.8 | 47.825 | 74072.0 |
| 2018-06-14 08:45:00 | AAPL | Stock | 47.8125 | 47.8125 | 47.8 | 47.8 | 14700.0 |
| 2018-06-14 08:50:00 | AAPL | Stock | 47.8 | 47.81 | 47.8 | 47.805 | 7528.0 |
| 2018-06-14 08:55:00 | AAPL | Stock | 47.8 | 47.8 | 47.7875 | 47.7925 | 29404.0 |
| 2018-06-14 09:00:00 | AAPL | Stock | 47.8 | 47.815 | 47.795 | 47.815 | 23876.0 |
| 2018-06-14 09:05:00 | AAPL | Stock | 47.815 | 47.815 | 47.81 | 47.8125 | 7760.0 |
| 2018-06-14 09:10:00 | AAPL | Stock | 47.8075 | 47.825 | 47.7925 | 47.82 | 19244.0 |
| 2018-06-14 09:15:00 | AAPL | Stock | 47.8175 | 47.83 | 47.8175 | 47.825 | 11644.0 |
| 2018-06-14 09:20:00 | AAPL | Stock | 47.8425 | 47.8425 | 47.8125 | 47.825 | 4540.0 |
| 2018-06-14 09:25:00 | AAPL | Stock | 47.8375 | 47.8875 | 47.8142 | 47.8875 | 21808.0 |
| 2018-06-14 09:30:00 | AAPL | Stock | 47.8875 | 47.8925 | 47.6875 | 47.7725 | 2715784.0 |
| 2018-06-14 09:35:00 | AAPL | Stock | 47.7725 | 47.88 | 47.7475 | 47.7525 | 2142584.0 |
| 2018-06-14 09:40:00 | AAPL | Stock | 47.7525 | 47.7525 | 47.6275 | 47.635 | 2286124.0 |
| 2018-06-14 09:45:00 | AAPL | Stock | 47.6388 | 47.6725 | 47.57 | 47.57 | 1963712.0 |
| 2018-06-14 09:50:00 | AAPL | Stock | 47.57 | 47.6725 | 47.555 | 47.595 | 1767136.0 |
| 2018-06-14 09:55:00 | AAPL | Stock | 47.5925 | 47.66 | 47.565 | 47.6575 | 1290800.0 |
| 2018-06-14 10:00:00 | AAPL | Stock | 47.655 | 47.8188 | 47.655 | 47.7625 | 1725532.0 |
| 2018-06-14 10:05:00 | AAPL | Stock | 47.765 | 47.8575 | 47.7625 | 47.825 | 1567592.0 |
| 2018-06-14 10:10:00 | AAPL | Stock | 47.825 | 47.83 | 47.77 | 47.78 | 908932.0 |
| 2018-06-14 10:15:00 | AAPL | Stock | 47.7825 | 47.8375 | 47.78 | 47.83 | 699852.0 |
> showing 50 of 365,123 rows — these rows as CSV