PREVIEW / stock_5min / 2018-08-03
file: by_date/stock_5min/2018/2018-08-03.parquet size: 5.4 MB rows: 347,351 symbols: 2,779
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-08-03 04:00:00 | AAPL | Stock | 51.65 | 51.75 | 51.625 | 51.75 | 9452.0 |
| 2018-08-03 04:05:00 | AAPL | Stock | 51.71 | 51.71 | 51.71 | 51.71 | 800.0 |
| 2018-08-03 04:10:00 | AAPL | Stock | 51.72 | 51.72 | 51.7125 | 51.7125 | 4800.0 |
| 2018-08-03 04:15:00 | AAPL | Stock | 51.7125 | 51.7125 | 51.7125 | 51.7125 | 2980.0 |
| 2018-08-03 04:20:00 | AAPL | Stock | 51.7125 | 51.7125 | 51.7025 | 51.7025 | 4000.0 |
| 2018-08-03 04:25:00 | AAPL | Stock | 51.7025 | 51.7025 | 51.665 | 51.665 | 3100.0 |
| 2018-08-03 04:30:00 | AAPL | Stock | 51.67 | 51.67 | 51.665 | 51.665 | 7700.0 |
| 2018-08-03 04:35:00 | AAPL | Stock | 51.655 | 51.66 | 51.655 | 51.655 | 8860.0 |
| 2018-08-03 04:40:00 | AAPL | Stock | 51.655 | 51.655 | 51.655 | 51.655 | 1000.0 |
| 2018-08-03 05:15:00 | AAPL | Stock | 51.66 | 51.66 | 51.66 | 51.66 | 568.0 |
| 2018-08-03 05:40:00 | AAPL | Stock | 51.7 | 51.7 | 51.7 | 51.7 | 400.0 |
| 2018-08-03 05:45:00 | AAPL | Stock | 51.7075 | 51.7075 | 51.7075 | 51.7075 | 400.0 |
| 2018-08-03 05:50:00 | AAPL | Stock | 51.665 | 51.665 | 51.665 | 51.665 | 876.0 |
| 2018-08-03 05:55:00 | AAPL | Stock | 51.685 | 51.685 | 51.685 | 51.685 | 2816.0 |
| 2018-08-03 06:00:00 | AAPL | Stock | 51.685 | 51.685 | 51.6625 | 51.6625 | 2460.0 |
| 2018-08-03 06:25:00 | AAPL | Stock | 51.675 | 51.675 | 51.675 | 51.675 | 520.0 |
| 2018-08-03 06:35:00 | AAPL | Stock | 51.6625 | 51.675 | 51.6625 | 51.675 | 8400.0 |
| 2018-08-03 06:50:00 | AAPL | Stock | 51.7 | 51.7425 | 51.7 | 51.7425 | 8012.0 |
| 2018-08-03 06:55:00 | AAPL | Stock | 51.725 | 51.725 | 51.725 | 51.725 | 400.0 |
| 2018-08-03 07:00:00 | AAPL | Stock | 51.74 | 51.7875 | 51.74 | 51.775 | 24280.0 |
| 2018-08-03 07:05:00 | AAPL | Stock | 51.765 | 51.8025 | 51.765 | 51.8 | 40200.0 |
| 2018-08-03 07:10:00 | AAPL | Stock | 51.7975 | 51.8375 | 51.7975 | 51.8375 | 42716.0 |
| 2018-08-03 07:15:00 | AAPL | Stock | 51.835 | 51.8475 | 51.785 | 51.785 | 40756.0 |
| 2018-08-03 07:20:00 | AAPL | Stock | 51.785 | 51.82 | 51.78 | 51.82 | 48420.0 |
| 2018-08-03 07:25:00 | AAPL | Stock | 51.82 | 51.825 | 51.82 | 51.825 | 29700.0 |
| 2018-08-03 07:30:00 | AAPL | Stock | 51.84 | 51.89 | 51.84 | 51.865 | 68288.0 |
| 2018-08-03 07:35:00 | AAPL | Stock | 51.885 | 51.915 | 51.885 | 51.8875 | 43280.0 |
| 2018-08-03 07:40:00 | AAPL | Stock | 51.8775 | 51.8875 | 51.875 | 51.8875 | 28060.0 |
| 2018-08-03 07:45:00 | AAPL | Stock | 51.8875 | 51.8975 | 51.8875 | 51.8875 | 15212.0 |
| 2018-08-03 07:50:00 | AAPL | Stock | 51.8925 | 51.92 | 51.8875 | 51.9125 | 37356.0 |
| 2018-08-03 07:55:00 | AAPL | Stock | 51.9125 | 51.9125 | 51.8925 | 51.8925 | 44676.0 |
| 2018-08-03 08:00:00 | AAPL | Stock | 51.7625 | 51.92 | 51.7125 | 51.7775 | 205788.0 |
| 2018-08-03 08:05:00 | AAPL | Stock | 51.805 | 51.825 | 51.8 | 51.8125 | 14136.0 |
| 2018-08-03 08:10:00 | AAPL | Stock | 51.805 | 51.81 | 51.7425 | 51.765 | 106608.0 |
| 2018-08-03 08:15:00 | AAPL | Stock | 51.75 | 51.7675 | 51.74 | 51.75 | 42828.0 |
| 2018-08-03 08:20:00 | AAPL | Stock | 51.74 | 51.76 | 51.7275 | 51.76 | 9220.0 |
| 2018-08-03 08:25:00 | AAPL | Stock | 51.7725 | 51.825 | 51.7625 | 51.825 | 24704.0 |
| 2018-08-03 08:30:00 | AAPL | Stock | 51.8 | 51.825 | 51.725 | 51.75 | 105312.0 |
| 2018-08-03 08:35:00 | AAPL | Stock | 51.7475 | 51.75 | 51.705 | 51.7225 | 42548.0 |
| 2018-08-03 08:40:00 | AAPL | Stock | 51.7325 | 51.77 | 51.7325 | 51.7625 | 26420.0 |
| 2018-08-03 08:45:00 | AAPL | Stock | 51.765 | 51.7875 | 51.75 | 51.7825 | 146452.0 |
| 2018-08-03 08:50:00 | AAPL | Stock | 51.7775 | 51.7775 | 51.75 | 51.77 | 20628.0 |
| 2018-08-03 08:55:00 | AAPL | Stock | 51.755 | 51.78 | 51.7325 | 51.7325 | 34752.0 |
| 2018-08-03 09:00:00 | AAPL | Stock | 51.7325 | 51.785 | 51.72 | 51.78 | 30928.0 |
| 2018-08-03 09:05:00 | AAPL | Stock | 51.775 | 51.7875 | 51.7725 | 51.775 | 29148.0 |
| 2018-08-03 09:10:00 | AAPL | Stock | 51.7725 | 51.8325 | 51.7725 | 51.825 | 54580.0 |
| 2018-08-03 09:15:00 | AAPL | Stock | 51.8125 | 51.8375 | 51.8 | 51.8275 | 53324.0 |
| 2018-08-03 09:20:00 | AAPL | Stock | 51.83 | 51.83 | 51.8125 | 51.8125 | 68588.0 |
| 2018-08-03 09:25:00 | AAPL | Stock | 51.8125 | 51.8125 | 51.75 | 51.7575 | 81808.0 |
| 2018-08-03 09:30:00 | AAPL | Stock | 51.7575 | 51.8375 | 51.485 | 51.485 | 7464744.0 |
> showing 50 of 347,351 rows — these rows as CSV