PREVIEW / stock_5min / 2019-01-30
file: by_date/stock_5min/2019/2019-01-30.parquet size: 5.7 MB rows: 357,764 symbols: 2,691
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-01-30 04:00:00 | AAPL | Stock | 40.825 | 40.825 | 40.6125 | 40.6125 | 51488.0 |
| 2019-01-30 04:05:00 | AAPL | Stock | 40.645 | 40.725 | 40.6425 | 40.725 | 24856.0 |
| 2019-01-30 04:10:00 | AAPL | Stock | 40.6775 | 40.7475 | 40.6775 | 40.7475 | 8396.0 |
| 2019-01-30 04:15:00 | AAPL | Stock | 40.745 | 40.745 | 40.675 | 40.675 | 4632.0 |
| 2019-01-30 04:20:00 | AAPL | Stock | 40.6875 | 40.695 | 40.675 | 40.695 | 3540.0 |
| 2019-01-30 04:25:00 | AAPL | Stock | 40.7 | 40.75 | 40.7 | 40.75 | 6012.0 |
| 2019-01-30 04:30:00 | AAPL | Stock | 40.75 | 40.75 | 40.75 | 40.75 | 4124.0 |
| 2019-01-30 04:35:00 | AAPL | Stock | 40.7225 | 40.75 | 40.7125 | 40.7125 | 8460.0 |
| 2019-01-30 04:40:00 | AAPL | Stock | 40.7125 | 40.7125 | 40.6625 | 40.675 | 36400.0 |
| 2019-01-30 04:45:00 | AAPL | Stock | 40.6875 | 40.6875 | 40.675 | 40.675 | 3900.0 |
| 2019-01-30 04:50:00 | AAPL | Stock | 40.65 | 40.655 | 40.6075 | 40.655 | 11292.0 |
| 2019-01-30 04:55:00 | AAPL | Stock | 40.6275 | 40.6275 | 40.6275 | 40.6275 | 448.0 |
| 2019-01-30 05:00:00 | AAPL | Stock | 40.625 | 40.655 | 40.625 | 40.655 | 3740.0 |
| 2019-01-30 05:05:00 | AAPL | Stock | 40.65 | 40.675 | 40.65 | 40.675 | 2028.0 |
| 2019-01-30 05:10:00 | AAPL | Stock | 40.68 | 40.695 | 40.68 | 40.68 | 26324.0 |
| 2019-01-30 05:15:00 | AAPL | Stock | 40.68 | 40.75 | 40.68 | 40.75 | 11704.0 |
| 2019-01-30 05:20:00 | AAPL | Stock | 40.785 | 40.8125 | 40.75 | 40.81 | 17836.0 |
| 2019-01-30 05:25:00 | AAPL | Stock | 40.825 | 40.8375 | 40.8 | 40.8 | 8036.0 |
| 2019-01-30 05:30:00 | AAPL | Stock | 40.85 | 40.85 | 40.84 | 40.85 | 6140.0 |
| 2019-01-30 05:35:00 | AAPL | Stock | 40.825 | 40.8625 | 40.825 | 40.8425 | 34660.0 |
| 2019-01-30 05:40:00 | AAPL | Stock | 40.8625 | 40.9225 | 40.85 | 40.9225 | 30504.0 |
| 2019-01-30 05:45:00 | AAPL | Stock | 40.875 | 40.8875 | 40.855 | 40.855 | 27124.0 |
| 2019-01-30 05:50:00 | AAPL | Stock | 40.83 | 40.83 | 40.825 | 40.825 | 3012.0 |
| 2019-01-30 05:55:00 | AAPL | Stock | 40.8275 | 40.8275 | 40.825 | 40.825 | 4504.0 |
| 2019-01-30 06:00:00 | AAPL | Stock | 40.8375 | 40.8525 | 40.8375 | 40.8525 | 21100.0 |
| 2019-01-30 06:05:00 | AAPL | Stock | 40.8525 | 40.875 | 40.85 | 40.875 | 4548.0 |
| 2019-01-30 06:10:00 | AAPL | Stock | 40.8375 | 40.8375 | 40.7875 | 40.7875 | 15104.0 |
| 2019-01-30 06:15:00 | AAPL | Stock | 40.7875 | 40.8225 | 40.7875 | 40.82 | 6836.0 |
| 2019-01-30 06:20:00 | AAPL | Stock | 40.7875 | 40.79 | 40.7875 | 40.79 | 13280.0 |
| 2019-01-30 06:25:00 | AAPL | Stock | 40.785 | 40.7875 | 40.75 | 40.75 | 60408.0 |
| 2019-01-30 06:30:00 | AAPL | Stock | 40.7625 | 40.875 | 40.7525 | 40.875 | 13500.0 |
| 2019-01-30 06:35:00 | AAPL | Stock | 40.805 | 40.805 | 40.8025 | 40.805 | 3080.0 |
| 2019-01-30 06:40:00 | AAPL | Stock | 40.805 | 40.805 | 40.8 | 40.8 | 3004.0 |
| 2019-01-30 06:45:00 | AAPL | Stock | 40.7675 | 40.775 | 40.75 | 40.775 | 11356.0 |
| 2019-01-30 06:50:00 | AAPL | Stock | 40.775 | 40.7825 | 40.75 | 40.75 | 38880.0 |
| 2019-01-30 06:55:00 | AAPL | Stock | 40.775 | 40.8 | 40.775 | 40.8 | 8120.0 |
| 2019-01-30 07:00:00 | AAPL | Stock | 40.85 | 40.875 | 40.8 | 40.825 | 99784.0 |
| 2019-01-30 07:05:00 | AAPL | Stock | 40.8275 | 40.835 | 40.785 | 40.785 | 43356.0 |
| 2019-01-30 07:10:00 | AAPL | Stock | 40.7775 | 40.785 | 40.75 | 40.78 | 79260.0 |
| 2019-01-30 07:15:00 | AAPL | Stock | 40.775 | 40.8 | 40.6425 | 40.69 | 217284.0 |
| 2019-01-30 07:20:00 | AAPL | Stock | 40.705 | 40.7425 | 40.675 | 40.725 | 61568.0 |
| 2019-01-30 07:25:00 | AAPL | Stock | 40.725 | 40.7375 | 40.725 | 40.725 | 44116.0 |
| 2019-01-30 07:30:00 | AAPL | Stock | 40.725 | 40.83 | 40.725 | 40.75 | 110488.0 |
| 2019-01-30 07:35:00 | AAPL | Stock | 40.77 | 40.7875 | 40.71 | 40.7525 | 94540.0 |
| 2019-01-30 07:40:00 | AAPL | Stock | 40.75 | 40.7525 | 40.6775 | 40.6775 | 66356.0 |
| 2019-01-30 07:45:00 | AAPL | Stock | 40.6775 | 40.7875 | 40.6775 | 40.725 | 64492.0 |
| 2019-01-30 07:50:00 | AAPL | Stock | 40.7225 | 40.725 | 40.6875 | 40.7125 | 63212.0 |
| 2019-01-30 07:55:00 | AAPL | Stock | 40.715 | 40.74 | 40.65 | 40.675 | 97716.0 |
| 2019-01-30 08:00:00 | AAPL | Stock | 40.6975 | 40.875 | 40.5475 | 40.585 | 386852.0 |
| 2019-01-30 08:05:00 | AAPL | Stock | 40.575 | 40.6025 | 40.45 | 40.475 | 287008.0 |
> showing 50 of 357,764 rows — these rows as CSV