PREVIEW / stock_5min / 2019-06-19
file: by_date/stock_5min/2019/2019-06-19.parquet size: 5.6 MB rows: 357,004 symbols: 2,573
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-06-19 04:10:00 | AAPL | Stock | 49.77 | 49.77 | 49.77 | 49.77 | 604.0 |
| 2019-06-19 04:15:00 | AAPL | Stock | 49.7525 | 49.7525 | 49.735 | 49.735 | 3748.0 |
| 2019-06-19 04:25:00 | AAPL | Stock | 49.6925 | 49.6925 | 49.6925 | 49.6925 | 400.0 |
| 2019-06-19 04:30:00 | AAPL | Stock | 49.6875 | 49.6875 | 49.6875 | 49.6875 | 400.0 |
| 2019-06-19 04:35:00 | AAPL | Stock | 49.6675 | 49.6675 | 49.6675 | 49.6675 | 400.0 |
| 2019-06-19 04:45:00 | AAPL | Stock | 49.6375 | 49.6375 | 49.5625 | 49.5625 | 6672.0 |
| 2019-06-19 04:50:00 | AAPL | Stock | 49.575 | 49.575 | 49.575 | 49.575 | 920.0 |
| 2019-06-19 05:05:00 | AAPL | Stock | 49.625 | 49.625 | 49.625 | 49.625 | 400.0 |
| 2019-06-19 05:25:00 | AAPL | Stock | 49.6 | 49.6 | 49.5875 | 49.5875 | 3180.0 |
| 2019-06-19 05:30:00 | AAPL | Stock | 49.63 | 49.63 | 49.63 | 49.63 | 400.0 |
| 2019-06-19 05:50:00 | AAPL | Stock | 49.6875 | 49.75 | 49.6875 | 49.75 | 14384.0 |
| 2019-06-19 05:55:00 | AAPL | Stock | 49.775 | 49.85 | 49.775 | 49.85 | 5600.0 |
| 2019-06-19 06:00:00 | AAPL | Stock | 49.7875 | 49.7875 | 49.7875 | 49.7875 | 2700.0 |
| 2019-06-19 06:05:00 | AAPL | Stock | 49.7875 | 49.8125 | 49.7675 | 49.7675 | 5040.0 |
| 2019-06-19 06:10:00 | AAPL | Stock | 49.825 | 49.85 | 49.825 | 49.85 | 4400.0 |
| 2019-06-19 06:15:00 | AAPL | Stock | 49.8275 | 49.875 | 49.8275 | 49.875 | 5540.0 |
| 2019-06-19 06:30:00 | AAPL | Stock | 49.875 | 49.875 | 49.875 | 49.875 | 2000.0 |
| 2019-06-19 06:40:00 | AAPL | Stock | 49.9 | 49.9 | 49.865 | 49.8975 | 3376.0 |
| 2019-06-19 06:45:00 | AAPL | Stock | 49.85 | 49.8575 | 49.85 | 49.8575 | 9412.0 |
| 2019-06-19 06:55:00 | AAPL | Stock | 49.875 | 49.875 | 49.875 | 49.875 | 400.0 |
| 2019-06-19 07:00:00 | AAPL | Stock | 49.875 | 49.875 | 49.8225 | 49.8225 | 9964.0 |
| 2019-06-19 07:05:00 | AAPL | Stock | 49.775 | 49.775 | 49.75 | 49.75 | 13096.0 |
| 2019-06-19 07:10:00 | AAPL | Stock | 49.75 | 49.75 | 49.75 | 49.75 | 3112.0 |
| 2019-06-19 07:15:00 | AAPL | Stock | 49.7475 | 49.7475 | 49.7475 | 49.7475 | 1680.0 |
| 2019-06-19 07:20:00 | AAPL | Stock | 49.7175 | 49.75 | 49.7175 | 49.75 | 2612.0 |
| 2019-06-19 07:25:00 | AAPL | Stock | 49.7725 | 49.82 | 49.7725 | 49.8 | 4320.0 |
| 2019-06-19 07:30:00 | AAPL | Stock | 49.815 | 49.815 | 49.8 | 49.8 | 2256.0 |
| 2019-06-19 07:40:00 | AAPL | Stock | 49.8225 | 49.91 | 49.8225 | 49.91 | 14776.0 |
| 2019-06-19 07:45:00 | AAPL | Stock | 49.8775 | 49.8775 | 49.875 | 49.875 | 2512.0 |
| 2019-06-19 07:50:00 | AAPL | Stock | 49.875 | 49.8825 | 49.875 | 49.8825 | 1580.0 |
| 2019-06-19 07:55:00 | AAPL | Stock | 49.86 | 49.86 | 49.855 | 49.8575 | 7060.0 |
| 2019-06-19 08:00:00 | AAPL | Stock | 49.725 | 49.925 | 49.725 | 49.8875 | 83472.0 |
| 2019-06-19 08:05:00 | AAPL | Stock | 49.875 | 49.8825 | 49.825 | 49.825 | 6680.0 |
| 2019-06-19 08:10:00 | AAPL | Stock | 49.7975 | 49.7975 | 49.75 | 49.7625 | 18264.0 |
| 2019-06-19 08:15:00 | AAPL | Stock | 49.81 | 49.8125 | 49.75 | 49.7875 | 15128.0 |
| 2019-06-19 08:20:00 | AAPL | Stock | 49.7625 | 49.7875 | 49.7625 | 49.7875 | 11420.0 |
| 2019-06-19 08:25:00 | AAPL | Stock | 49.7875 | 49.825 | 49.7875 | 49.825 | 18392.0 |
| 2019-06-19 08:30:00 | AAPL | Stock | 49.8075 | 49.8075 | 49.7875 | 49.79 | 9800.0 |
| 2019-06-19 08:35:00 | AAPL | Stock | 49.8 | 49.865 | 49.8 | 49.8375 | 12504.0 |
| 2019-06-19 08:40:00 | AAPL | Stock | 49.8618 | 49.8618 | 49.8175 | 49.825 | 1800.0 |
| 2019-06-19 08:45:00 | AAPL | Stock | 49.8275 | 49.865 | 49.8125 | 49.85 | 7120.0 |
| 2019-06-19 08:50:00 | AAPL | Stock | 49.85 | 49.8825 | 49.85 | 49.8825 | 13560.0 |
| 2019-06-19 08:55:00 | AAPL | Stock | 49.825 | 49.86 | 49.825 | 49.83 | 42212.0 |
| 2019-06-19 09:00:00 | AAPL | Stock | 49.8615 | 49.8625 | 49.8275 | 49.85 | 29900.0 |
| 2019-06-19 09:05:00 | AAPL | Stock | 49.8575 | 49.8575 | 49.83 | 49.85 | 7188.0 |
| 2019-06-19 09:10:00 | AAPL | Stock | 49.85 | 49.875 | 49.8475 | 49.875 | 20440.0 |
| 2019-06-19 09:15:00 | AAPL | Stock | 49.875 | 49.88 | 49.8625 | 49.88 | 7840.0 |
| 2019-06-19 09:20:00 | AAPL | Stock | 49.865 | 49.8775 | 49.855 | 49.855 | 6400.0 |
| 2019-06-19 09:25:00 | AAPL | Stock | 49.8575 | 49.92 | 49.845 | 49.92 | 42372.0 |
| 2019-06-19 09:30:00 | AAPL | Stock | 49.92 | 49.9325 | 49.6825 | 49.6962 | 3688160.0 |
> showing 50 of 357,004 rows — these rows as CSV