PREVIEW / stock_5min / 2018-12-27
file: by_date/stock_5min/2018/2018-12-27.parquet size: 6.0 MB rows: 382,558 symbols: 2,724
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-12-27 04:00:00 | AAPL | Stock | 38.745 | 39.0175 | 38.745 | 39.0175 | 2400.0 |
| 2018-12-27 04:05:00 | AAPL | Stock | 38.8 | 38.8575 | 38.8 | 38.8325 | 12000.0 |
| 2018-12-27 04:10:00 | AAPL | Stock | 38.8425 | 38.8425 | 38.755 | 38.7575 | 4700.0 |
| 2018-12-27 04:15:00 | AAPL | Stock | 38.73 | 38.73 | 38.73 | 38.73 | 3568.0 |
| 2018-12-27 04:20:00 | AAPL | Stock | 38.73 | 38.7725 | 38.73 | 38.7725 | 1600.0 |
| 2018-12-27 04:25:00 | AAPL | Stock | 38.7 | 38.7 | 38.675 | 38.675 | 4880.0 |
| 2018-12-27 04:30:00 | AAPL | Stock | 38.6225 | 38.6275 | 38.6225 | 38.6275 | 1400.0 |
| 2018-12-27 04:40:00 | AAPL | Stock | 38.6375 | 38.6375 | 38.5875 | 38.5875 | 4800.0 |
| 2018-12-27 04:45:00 | AAPL | Stock | 38.6275 | 38.6275 | 38.6275 | 38.6275 | 400.0 |
| 2018-12-27 04:50:00 | AAPL | Stock | 38.6275 | 38.6275 | 38.6275 | 38.6275 | 1512.0 |
| 2018-12-27 04:55:00 | AAPL | Stock | 38.6275 | 38.6275 | 38.59 | 38.625 | 12836.0 |
| 2018-12-27 05:00:00 | AAPL | Stock | 38.6125 | 38.6725 | 38.6125 | 38.6475 | 15104.0 |
| 2018-12-27 05:05:00 | AAPL | Stock | 38.6025 | 38.675 | 38.58 | 38.675 | 7284.0 |
| 2018-12-27 05:10:00 | AAPL | Stock | 38.6525 | 38.6675 | 38.65 | 38.6625 | 8288.0 |
| 2018-12-27 05:25:00 | AAPL | Stock | 38.715 | 38.75 | 38.625 | 38.625 | 14060.0 |
| 2018-12-27 05:30:00 | AAPL | Stock | 38.745 | 38.745 | 38.745 | 38.745 | 800.0 |
| 2018-12-27 05:35:00 | AAPL | Stock | 38.6625 | 38.75 | 38.6625 | 38.75 | 3748.0 |
| 2018-12-27 05:40:00 | AAPL | Stock | 38.8 | 38.8 | 38.7075 | 38.7075 | 9232.0 |
| 2018-12-27 05:50:00 | AAPL | Stock | 38.7275 | 38.7275 | 38.7125 | 38.7125 | 1200.0 |
| 2018-12-27 05:55:00 | AAPL | Stock | 38.75 | 38.75 | 38.625 | 38.66 | 4120.0 |
| 2018-12-27 06:25:00 | AAPL | Stock | 38.745 | 38.775 | 38.745 | 38.775 | 4612.0 |
| 2018-12-27 06:30:00 | AAPL | Stock | 38.765 | 38.765 | 38.7525 | 38.7525 | 2292.0 |
| 2018-12-27 06:35:00 | AAPL | Stock | 38.7375 | 38.7375 | 38.7375 | 38.7375 | 400.0 |
| 2018-12-27 06:40:00 | AAPL | Stock | 38.7375 | 38.775 | 38.735 | 38.775 | 3620.0 |
| 2018-12-27 06:45:00 | AAPL | Stock | 38.7525 | 38.8 | 38.7525 | 38.755 | 1296.0 |
| 2018-12-27 06:50:00 | AAPL | Stock | 38.76 | 38.76 | 38.725 | 38.75 | 3956.0 |
| 2018-12-27 06:55:00 | AAPL | Stock | 38.68 | 38.68 | 38.68 | 38.68 | 1200.0 |
| 2018-12-27 07:00:00 | AAPL | Stock | 38.68 | 38.8575 | 38.6775 | 38.8 | 44520.0 |
| 2018-12-27 07:10:00 | AAPL | Stock | 38.775 | 38.775 | 38.75 | 38.75 | 23332.0 |
| 2018-12-27 07:15:00 | AAPL | Stock | 38.775 | 38.8125 | 38.725 | 38.725 | 26224.0 |
| 2018-12-27 07:20:00 | AAPL | Stock | 38.6875 | 38.69 | 38.5625 | 38.625 | 39928.0 |
| 2018-12-27 07:25:00 | AAPL | Stock | 38.6675 | 38.7325 | 38.6675 | 38.7325 | 5532.0 |
| 2018-12-27 07:30:00 | AAPL | Stock | 38.75 | 38.75 | 38.725 | 38.75 | 11068.0 |
| 2018-12-27 07:35:00 | AAPL | Stock | 38.76 | 38.7825 | 38.76 | 38.78 | 5536.0 |
| 2018-12-27 07:40:00 | AAPL | Stock | 38.7625 | 38.7975 | 38.7575 | 38.7975 | 3944.0 |
| 2018-12-27 07:45:00 | AAPL | Stock | 38.8575 | 38.8575 | 38.8125 | 38.845 | 7080.0 |
| 2018-12-27 07:50:00 | AAPL | Stock | 38.8275 | 38.8275 | 38.7875 | 38.7875 | 3200.0 |
| 2018-12-27 07:55:00 | AAPL | Stock | 38.7675 | 38.7725 | 38.7675 | 38.7725 | 800.0 |
| 2018-12-27 08:00:00 | AAPL | Stock | 38.7575 | 38.8575 | 38.595 | 38.735 | 153560.0 |
| 2018-12-27 08:05:00 | AAPL | Stock | 38.7125 | 39.3875 | 38.7 | 38.735 | 25308.0 |
| 2018-12-27 08:10:00 | AAPL | Stock | 38.7475 | 38.875 | 38.735 | 38.86 | 93952.0 |
| 2018-12-27 08:15:00 | AAPL | Stock | 38.8525 | 38.8625 | 38.78 | 38.815 | 20656.0 |
| 2018-12-27 08:20:00 | AAPL | Stock | 38.7875 | 38.815 | 38.755 | 38.815 | 16236.0 |
| 2018-12-27 08:25:00 | AAPL | Stock | 38.8125 | 38.86 | 38.8125 | 38.825 | 24440.0 |
| 2018-12-27 08:30:00 | AAPL | Stock | 38.835 | 38.835 | 38.77 | 38.825 | 23556.0 |
| 2018-12-27 08:35:00 | AAPL | Stock | 38.805 | 38.8275 | 38.775 | 38.775 | 24564.0 |
| 2018-12-27 08:40:00 | AAPL | Stock | 38.775 | 38.8125 | 38.7575 | 38.8 | 29060.0 |
| 2018-12-27 08:45:00 | AAPL | Stock | 38.825 | 38.825 | 38.7675 | 38.825 | 9384.0 |
| 2018-12-27 08:50:00 | AAPL | Stock | 38.825 | 38.825 | 38.7575 | 38.765 | 23976.0 |
| 2018-12-27 08:55:00 | AAPL | Stock | 38.7725 | 38.785 | 38.745 | 38.78 | 63532.0 |
> showing 50 of 382,558 rows — these rows as CSV