PREVIEW / stock_5min / 2019-06-24
file: by_date/stock_5min/2019/2019-06-24.parquet size: 5.7 MB rows: 362,479 symbols: 2,607
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-24 04:00:00 | AAPL | Stock | 49.825 | 49.825 | 49.825 | 49.825 | 4004.0 |
| 2019-06-24 04:05:00 | AAPL | Stock | 49.8125 | 49.8125 | 49.8125 | 49.8125 | 7600.0 |
| 2019-06-24 04:10:00 | AAPL | Stock | 49.8125 | 49.8125 | 49.8 | 49.8 | 1600.0 |
| 2019-06-24 04:15:00 | AAPL | Stock | 49.7675 | 49.8125 | 49.7675 | 49.8125 | 1600.0 |
| 2019-06-24 04:20:00 | AAPL | Stock | 49.8 | 49.8 | 49.8 | 49.8 | 1200.0 |
| 2019-06-24 04:40:00 | AAPL | Stock | 49.77 | 49.8125 | 49.77 | 49.8125 | 2400.0 |
| 2019-06-24 04:45:00 | AAPL | Stock | 49.8125 | 49.825 | 49.8 | 49.8 | 11276.0 |
| 2019-06-24 04:55:00 | AAPL | Stock | 49.8125 | 49.8125 | 49.8125 | 49.8125 | 400.0 |
| 2019-06-24 05:05:00 | AAPL | Stock | 49.8 | 49.8 | 49.8 | 49.8 | 4656.0 |
| 2019-06-24 05:10:00 | AAPL | Stock | 49.79 | 49.79 | 49.79 | 49.79 | 852.0 |
| 2019-06-24 05:15:00 | AAPL | Stock | 49.79 | 49.79 | 49.79 | 49.79 | 1948.0 |
| 2019-06-24 05:20:00 | AAPL | Stock | 49.8 | 49.8 | 49.8 | 49.8 | 3192.0 |
| 2019-06-24 05:40:00 | AAPL | Stock | 49.825 | 49.825 | 49.825 | 49.825 | 400.0 |
| 2019-06-24 06:05:00 | AAPL | Stock | 49.825 | 49.825 | 49.825 | 49.825 | 400.0 |
| 2019-06-24 06:45:00 | AAPL | Stock | 49.8 | 49.8 | 49.8 | 49.8 | 432.0 |
| 2019-06-24 06:50:00 | AAPL | Stock | 49.7625 | 49.7625 | 49.7625 | 49.7625 | 5800.0 |
| 2019-06-24 07:00:00 | AAPL | Stock | 49.7275 | 49.77 | 49.695 | 49.7 | 13716.0 |
| 2019-06-24 07:05:00 | AAPL | Stock | 49.6875 | 49.6875 | 49.67 | 49.675 | 4400.0 |
| 2019-06-24 07:10:00 | AAPL | Stock | 49.695 | 49.695 | 49.65 | 49.65 | 17740.0 |
| 2019-06-24 07:15:00 | AAPL | Stock | 49.6525 | 49.6525 | 49.575 | 49.5875 | 16124.0 |
| 2019-06-24 07:20:00 | AAPL | Stock | 49.6 | 49.6125 | 49.5875 | 49.6125 | 6800.0 |
| 2019-06-24 07:25:00 | AAPL | Stock | 49.6125 | 49.625 | 49.605 | 49.625 | 2400.0 |
| 2019-06-24 07:30:00 | AAPL | Stock | 49.63 | 49.63 | 49.63 | 49.63 | 400.0 |
| 2019-06-24 07:35:00 | AAPL | Stock | 49.645 | 49.645 | 49.575 | 49.59 | 31996.0 |
| 2019-06-24 07:40:00 | AAPL | Stock | 49.575 | 49.575 | 49.575 | 49.575 | 400.0 |
| 2019-06-24 07:45:00 | AAPL | Stock | 49.63 | 49.63 | 49.63 | 49.63 | 400.0 |
| 2019-06-24 07:50:00 | AAPL | Stock | 49.63 | 49.65 | 49.63 | 49.6475 | 6940.0 |
| 2019-06-24 07:55:00 | AAPL | Stock | 49.6875 | 49.6875 | 49.6875 | 49.6875 | 5072.0 |
| 2019-06-24 08:00:00 | AAPL | Stock | 49.75 | 49.7875 | 49.5625 | 49.695 | 76484.0 |
| 2019-06-24 08:05:00 | AAPL | Stock | 49.695 | 49.715 | 49.6875 | 49.6875 | 11436.0 |
| 2019-06-24 08:10:00 | AAPL | Stock | 49.71 | 49.725 | 49.71 | 49.725 | 32068.0 |
| 2019-06-24 08:15:00 | AAPL | Stock | 49.7125 | 49.7325 | 49.6975 | 49.7275 | 11768.0 |
| 2019-06-24 08:20:00 | AAPL | Stock | 49.7375 | 49.7375 | 49.675 | 49.675 | 33248.0 |
| 2019-06-24 08:25:00 | AAPL | Stock | 49.695 | 49.695 | 49.695 | 49.695 | 1920.0 |
| 2019-06-24 08:30:00 | AAPL | Stock | 49.695 | 49.74 | 49.695 | 49.74 | 10352.0 |
| 2019-06-24 08:35:00 | AAPL | Stock | 49.7325 | 49.775 | 49.7 | 49.775 | 15356.0 |
| 2019-06-24 08:40:00 | AAPL | Stock | 49.775 | 49.775 | 49.75 | 49.7722 | 21804.0 |
| 2019-06-24 08:45:00 | AAPL | Stock | 49.75 | 49.7675 | 49.7375 | 49.7625 | 5952.0 |
| 2019-06-24 08:50:00 | AAPL | Stock | 49.75 | 49.7675 | 49.74 | 49.74 | 24088.0 |
| 2019-06-24 08:55:00 | AAPL | Stock | 49.755 | 49.7575 | 49.75 | 49.75 | 12760.0 |
| 2019-06-24 09:00:00 | AAPL | Stock | 49.75 | 49.75 | 49.7275 | 49.7275 | 3600.0 |
| 2019-06-24 09:05:00 | AAPL | Stock | 49.74 | 49.75 | 49.725 | 49.725 | 3300.0 |
| 2019-06-24 09:10:00 | AAPL | Stock | 49.74 | 49.74 | 49.7175 | 49.7175 | 9868.0 |
| 2019-06-24 09:15:00 | AAPL | Stock | 49.7225 | 49.725 | 49.715 | 49.715 | 5200.0 |
| 2019-06-24 09:20:00 | AAPL | Stock | 49.725 | 49.7425 | 49.715 | 49.715 | 28548.0 |
| 2019-06-24 09:25:00 | AAPL | Stock | 49.71 | 49.71 | 49.645 | 49.655 | 58740.0 |
| 2019-06-24 09:30:00 | AAPL | Stock | 49.64 | 49.9625 | 49.5425 | 49.9 | 3443584.0 |
| 2019-06-24 09:35:00 | AAPL | Stock | 49.8875 | 49.9788 | 49.8375 | 49.9725 | 1016480.0 |
| 2019-06-24 09:40:00 | AAPL | Stock | 49.9775 | 50.0 | 49.8475 | 49.85 | 1148584.0 |
| 2019-06-24 09:45:00 | AAPL | Stock | 49.8575 | 49.9575 | 49.84 | 49.9375 | 913316.0 |
> showing 50 of 362,479 rows — these rows as CSV