PREVIEW / stock_5min / 2019-02-06
file: by_date/stock_5min/2019/2019-02-06.parquet size: 5.5 MB rows: 346,517 symbols: 2,661
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-02-06 04:05:00 | AAPL | Stock | 43.5475 | 43.5525 | 43.5 | 43.5 | 12000.0 |
| 2019-02-06 04:10:00 | AAPL | Stock | 43.4725 | 43.4725 | 43.4725 | 43.4725 | 400.0 |
| 2019-02-06 04:15:00 | AAPL | Stock | 43.4275 | 43.45 | 43.425 | 43.45 | 2068.0 |
| 2019-02-06 04:20:00 | AAPL | Stock | 43.5 | 43.5 | 43.5 | 43.5 | 800.0 |
| 2019-02-06 04:25:00 | AAPL | Stock | 43.5 | 43.5 | 43.4625 | 43.47 | 16000.0 |
| 2019-02-06 04:30:00 | AAPL | Stock | 43.4075 | 43.4075 | 43.4075 | 43.4075 | 3552.0 |
| 2019-02-06 04:35:00 | AAPL | Stock | 43.4375 | 43.4375 | 43.4375 | 43.4375 | 2000.0 |
| 2019-02-06 04:50:00 | AAPL | Stock | 43.4375 | 43.4375 | 43.4375 | 43.4375 | 1680.0 |
| 2019-02-06 05:00:00 | AAPL | Stock | 43.475 | 43.485 | 43.475 | 43.485 | 976.0 |
| 2019-02-06 05:05:00 | AAPL | Stock | 43.5 | 43.5 | 43.5 | 43.5 | 440.0 |
| 2019-02-06 05:10:00 | AAPL | Stock | 43.5025 | 43.5475 | 43.5 | 43.535 | 21868.0 |
| 2019-02-06 05:15:00 | AAPL | Stock | 43.525 | 43.5425 | 43.505 | 43.535 | 3428.0 |
| 2019-02-06 05:20:00 | AAPL | Stock | 43.5125 | 43.5125 | 43.5125 | 43.5125 | 4000.0 |
| 2019-02-06 05:40:00 | AAPL | Stock | 43.55 | 43.555 | 43.55 | 43.555 | 5672.0 |
| 2019-02-06 05:45:00 | AAPL | Stock | 43.5125 | 43.5125 | 43.5125 | 43.5125 | 672.0 |
| 2019-02-06 05:50:00 | AAPL | Stock | 43.5375 | 43.54 | 43.5375 | 43.54 | 4560.0 |
| 2019-02-06 05:55:00 | AAPL | Stock | 43.5475 | 43.555 | 43.5475 | 43.555 | 16484.0 |
| 2019-02-06 06:20:00 | AAPL | Stock | 43.57 | 43.57 | 43.57 | 43.57 | 400.0 |
| 2019-02-06 06:30:00 | AAPL | Stock | 43.57 | 43.57 | 43.57 | 43.57 | 11100.0 |
| 2019-02-06 06:40:00 | AAPL | Stock | 43.595 | 43.595 | 43.595 | 43.595 | 2000.0 |
| 2019-02-06 06:45:00 | AAPL | Stock | 43.6175 | 43.6175 | 43.595 | 43.595 | 9836.0 |
| 2019-02-06 07:00:00 | AAPL | Stock | 43.595 | 43.595 | 43.55 | 43.585 | 12388.0 |
| 2019-02-06 07:05:00 | AAPL | Stock | 43.5825 | 43.5925 | 43.5825 | 43.5925 | 4016.0 |
| 2019-02-06 07:10:00 | AAPL | Stock | 43.5825 | 43.62 | 43.5825 | 43.62 | 5412.0 |
| 2019-02-06 07:15:00 | AAPL | Stock | 43.615 | 43.615 | 43.6 | 43.6 | 2096.0 |
| 2019-02-06 07:20:00 | AAPL | Stock | 43.625 | 43.6375 | 43.6125 | 43.615 | 25004.0 |
| 2019-02-06 07:25:00 | AAPL | Stock | 43.61 | 43.61 | 43.575 | 43.58 | 4080.0 |
| 2019-02-06 07:30:00 | AAPL | Stock | 43.61 | 43.6425 | 43.6075 | 43.6425 | 7016.0 |
| 2019-02-06 07:35:00 | AAPL | Stock | 43.65 | 43.6925 | 43.6375 | 43.6375 | 29056.0 |
| 2019-02-06 07:40:00 | AAPL | Stock | 43.6475 | 43.6775 | 43.625 | 43.625 | 10020.0 |
| 2019-02-06 07:45:00 | AAPL | Stock | 43.6275 | 43.65 | 43.625 | 43.65 | 5580.0 |
| 2019-02-06 07:50:00 | AAPL | Stock | 43.65 | 43.66 | 43.6125 | 43.66 | 46568.0 |
| 2019-02-06 07:55:00 | AAPL | Stock | 43.65 | 43.65 | 43.6125 | 43.6475 | 21156.0 |
| 2019-02-06 08:00:00 | AAPL | Stock | 43.6125 | 43.685 | 43.545 | 43.545 | 78864.0 |
| 2019-02-06 08:05:00 | AAPL | Stock | 43.675 | 43.7 | 43.6625 | 43.6925 | 41848.0 |
| 2019-02-06 08:10:00 | AAPL | Stock | 43.6925 | 43.6925 | 43.675 | 43.6875 | 9884.0 |
| 2019-02-06 08:15:00 | AAPL | Stock | 43.6925 | 43.71 | 43.675 | 43.71 | 16392.0 |
| 2019-02-06 08:20:00 | AAPL | Stock | 43.68 | 43.7375 | 43.68 | 43.7375 | 23148.0 |
| 2019-02-06 08:25:00 | AAPL | Stock | 43.7175 | 43.7175 | 43.6925 | 43.7025 | 30772.0 |
| 2019-02-06 08:30:00 | AAPL | Stock | 43.715 | 43.7175 | 43.7 | 43.71 | 18892.0 |
| 2019-02-06 08:35:00 | AAPL | Stock | 43.71 | 43.71 | 43.7 | 43.7 | 13456.0 |
| 2019-02-06 08:40:00 | AAPL | Stock | 43.71 | 43.725 | 43.71 | 43.725 | 19996.0 |
| 2019-02-06 08:45:00 | AAPL | Stock | 43.715 | 43.735 | 43.7125 | 43.725 | 40976.0 |
| 2019-02-06 08:50:00 | AAPL | Stock | 43.7275 | 43.735 | 43.69 | 43.715 | 30824.0 |
| 2019-02-06 08:55:00 | AAPL | Stock | 43.6925 | 43.71 | 43.6675 | 43.695 | 23528.0 |
| 2019-02-06 09:00:00 | AAPL | Stock | 43.687 | 43.6875 | 43.65 | 43.65 | 34036.0 |
| 2019-02-06 09:05:00 | AAPL | Stock | 43.635 | 43.695 | 43.6325 | 43.675 | 22952.0 |
| 2019-02-06 09:10:00 | AAPL | Stock | 43.675 | 43.6975 | 43.655 | 43.6745 | 32452.0 |
| 2019-02-06 09:15:00 | AAPL | Stock | 43.655 | 43.6875 | 43.625 | 43.6763 | 37252.0 |
| 2019-02-06 09:20:00 | AAPL | Stock | 43.67 | 43.6875 | 43.6625 | 43.68 | 5396.0 |
> showing 50 of 346,517 rows — these rows as CSV