PREVIEW / stock_5min / 2020-08-26
file: by_date/stock_5min/2020/2020-08-26.parquet size: 6.5 MB rows: 408,089 symbols: 2,455
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 |
|---|---|---|---|---|---|---|---|
| 2020-08-26 04:00:00 | AAPL | Stock | 125.005 | 125.005 | 124.75 | 124.775 | 14952.0 |
| 2020-08-26 04:05:00 | AAPL | Stock | 124.7875 | 124.7875 | 124.75 | 124.75 | 2800.0 |
| 2020-08-26 04:20:00 | AAPL | Stock | 124.925 | 124.925 | 124.925 | 124.925 | 424.0 |
| 2020-08-26 04:35:00 | AAPL | Stock | 125.2125 | 125.25 | 125.2 | 125.25 | 2948.0 |
| 2020-08-26 04:40:00 | AAPL | Stock | 125.285 | 125.285 | 125.285 | 125.285 | 400.0 |
| 2020-08-26 04:45:00 | AAPL | Stock | 125.25 | 125.25 | 125.25 | 125.25 | 2320.0 |
| 2020-08-26 04:50:00 | AAPL | Stock | 125.1875 | 125.1875 | 125.1875 | 125.1875 | 2268.0 |
| 2020-08-26 04:55:00 | AAPL | Stock | 125.25 | 125.2875 | 125.25 | 125.2625 | 2024.0 |
| 2020-08-26 05:00:00 | AAPL | Stock | 125.305 | 125.44 | 125.305 | 125.44 | 1200.0 |
| 2020-08-26 05:05:00 | AAPL | Stock | 125.3875 | 125.5175 | 125.3875 | 125.5175 | 4040.0 |
| 2020-08-26 05:10:00 | AAPL | Stock | 125.45 | 125.45 | 125.275 | 125.275 | 3272.0 |
| 2020-08-26 05:15:00 | AAPL | Stock | 125.365 | 125.45 | 125.365 | 125.45 | 1756.0 |
| 2020-08-26 05:20:00 | AAPL | Stock | 125.485 | 125.485 | 125.485 | 125.485 | 480.0 |
| 2020-08-26 05:30:00 | AAPL | Stock | 125.5 | 125.5 | 125.5 | 125.5 | 5516.0 |
| 2020-08-26 05:35:00 | AAPL | Stock | 125.475 | 125.4875 | 125.415 | 125.415 | 2232.0 |
| 2020-08-26 05:45:00 | AAPL | Stock | 125.3075 | 125.3075 | 125.3075 | 125.3075 | 456.0 |
| 2020-08-26 05:50:00 | AAPL | Stock | 125.385 | 125.385 | 125.385 | 125.385 | 400.0 |
| 2020-08-26 05:55:00 | AAPL | Stock | 125.325 | 125.325 | 125.325 | 125.325 | 1532.0 |
| 2020-08-26 06:00:00 | AAPL | Stock | 125.375 | 125.375 | 125.315 | 125.315 | 1420.0 |
| 2020-08-26 06:05:00 | AAPL | Stock | 125.415 | 125.5 | 125.415 | 125.5 | 4564.0 |
| 2020-08-26 06:10:00 | AAPL | Stock | 125.5 | 125.5 | 125.5 | 125.5 | 964.0 |
| 2020-08-26 06:15:00 | AAPL | Stock | 125.4875 | 125.75 | 125.4875 | 125.625 | 35908.0 |
| 2020-08-26 06:20:00 | AAPL | Stock | 125.6175 | 125.725 | 125.6175 | 125.725 | 7876.0 |
| 2020-08-26 06:25:00 | AAPL | Stock | 125.72 | 125.945 | 125.72 | 125.945 | 9480.0 |
| 2020-08-26 06:30:00 | AAPL | Stock | 125.9375 | 126.1 | 125.9375 | 126.1 | 21724.0 |
| 2020-08-26 06:35:00 | AAPL | Stock | 126.0125 | 126.125 | 125.9475 | 126.125 | 16696.0 |
| 2020-08-26 06:40:00 | AAPL | Stock | 126.0775 | 126.0775 | 126.0325 | 126.05 | 7612.0 |
| 2020-08-26 06:45:00 | AAPL | Stock | 126.0875 | 126.0875 | 126.0875 | 126.0875 | 400.0 |
| 2020-08-26 06:50:00 | AAPL | Stock | 126.05 | 126.065 | 126.05 | 126.05 | 11196.0 |
| 2020-08-26 06:55:00 | AAPL | Stock | 126.105 | 126.23 | 126.055 | 126.1275 | 15964.0 |
| 2020-08-26 07:00:00 | AAPL | Stock | 126.2225 | 126.2225 | 125.7 | 125.7575 | 89792.0 |
| 2020-08-26 07:05:00 | AAPL | Stock | 125.7825 | 126.05 | 125.7825 | 125.8875 | 57816.0 |
| 2020-08-26 07:10:00 | AAPL | Stock | 125.8775 | 125.98 | 125.82 | 125.9375 | 18772.0 |
| 2020-08-26 07:15:00 | AAPL | Stock | 125.7625 | 125.8 | 125.7625 | 125.775 | 10080.0 |
| 2020-08-26 07:20:00 | AAPL | Stock | 125.775 | 125.9075 | 125.6675 | 125.875 | 46796.0 |
| 2020-08-26 07:25:00 | AAPL | Stock | 125.8925 | 126.075 | 125.875 | 125.97 | 46544.0 |
| 2020-08-26 07:30:00 | AAPL | Stock | 125.96 | 125.97 | 125.9225 | 125.925 | 11456.0 |
| 2020-08-26 07:35:00 | AAPL | Stock | 125.9575 | 126.0925 | 125.9575 | 126.05 | 48708.0 |
| 2020-08-26 07:40:00 | AAPL | Stock | 126.0475 | 126.0475 | 125.955 | 126.0375 | 32272.0 |
| 2020-08-26 07:45:00 | AAPL | Stock | 126.025 | 126.03 | 125.875 | 125.875 | 33084.0 |
| 2020-08-26 07:50:00 | AAPL | Stock | 125.875 | 125.9925 | 125.875 | 125.9225 | 11592.0 |
| 2020-08-26 07:55:00 | AAPL | Stock | 125.88 | 125.9 | 125.8175 | 125.875 | 16748.0 |
| 2020-08-26 08:00:00 | AAPL | Stock | 125.83 | 126.0975 | 125.135 | 125.85 | 250144.0 |
| 2020-08-26 08:05:00 | AAPL | Stock | 125.875 | 125.92 | 125.7625 | 125.9125 | 67012.0 |
| 2020-08-26 08:10:00 | AAPL | Stock | 125.92 | 125.975 | 125.8625 | 125.9225 | 32120.0 |
| 2020-08-26 08:15:00 | AAPL | Stock | 125.8788 | 125.9225 | 125.625 | 125.66 | 65568.0 |
| 2020-08-26 08:20:00 | AAPL | Stock | 125.6875 | 125.7975 | 125.675 | 125.7425 | 32796.0 |
| 2020-08-26 08:25:00 | AAPL | Stock | 125.7425 | 125.8425 | 125.7175 | 125.775 | 24512.0 |
| 2020-08-26 08:30:00 | AAPL | Stock | 125.7775 | 125.8 | 125.5 | 125.7475 | 67372.0 |
| 2020-08-26 08:35:00 | AAPL | Stock | 125.7375 | 125.875 | 125.715 | 125.8325 | 32336.0 |
> showing 50 of 408,089 rows — these rows as CSV