PREVIEW / stock_5min / 2015-12-17
file: by_date/stock_5min/2015/2015-12-17.parquet size: 5.7 MB rows: 377,336 symbols: 3,436
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 |
|---|---|---|---|---|---|---|---|
| 2015-12-17 04:25:00 | AAPL | Stock | 27.92 | 27.92 | 27.92 | 27.92 | 800.0 |
| 2015-12-17 04:40:00 | AAPL | Stock | 27.9075 | 27.925 | 27.9075 | 27.925 | 14732.0 |
| 2015-12-17 04:45:00 | AAPL | Stock | 27.9375 | 27.9475 | 27.9375 | 27.945 | 4800.0 |
| 2015-12-17 04:50:00 | AAPL | Stock | 27.945 | 27.945 | 27.945 | 27.945 | 400.0 |
| 2015-12-17 04:55:00 | AAPL | Stock | 27.9475 | 27.95 | 27.9475 | 27.95 | 2800.0 |
| 2015-12-17 05:00:00 | AAPL | Stock | 27.9625 | 27.9625 | 27.9425 | 27.9425 | 2400.0 |
| 2015-12-17 05:15:00 | AAPL | Stock | 27.9475 | 27.95 | 27.9475 | 27.95 | 4400.0 |
| 2015-12-17 05:30:00 | AAPL | Stock | 27.96 | 27.9625 | 27.96 | 27.9625 | 11888.0 |
| 2015-12-17 05:40:00 | AAPL | Stock | 27.9725 | 27.9725 | 27.9725 | 27.9725 | 700.0 |
| 2015-12-17 06:00:00 | AAPL | Stock | 27.9525 | 27.9525 | 27.95 | 27.95 | 3928.0 |
| 2015-12-17 06:05:00 | AAPL | Stock | 27.9725 | 27.975 | 27.9725 | 27.975 | 6800.0 |
| 2015-12-17 06:10:00 | AAPL | Stock | 27.995 | 27.995 | 27.9925 | 27.9925 | 2000.0 |
| 2015-12-17 06:15:00 | AAPL | Stock | 27.98 | 27.98 | 27.98 | 27.98 | 1600.0 |
| 2015-12-17 06:25:00 | AAPL | Stock | 27.9775 | 27.9775 | 27.9775 | 27.9775 | 800.0 |
| 2015-12-17 06:40:00 | AAPL | Stock | 27.985 | 28.005 | 27.985 | 28.0 | 17196.0 |
| 2015-12-17 06:45:00 | AAPL | Stock | 28.0025 | 28.0375 | 28.0025 | 28.0375 | 800.0 |
| 2015-12-17 06:55:00 | AAPL | Stock | 28.0125 | 28.0125 | 28.0125 | 28.0125 | 4400.0 |
| 2015-12-17 07:00:00 | AAPL | Stock | 28.02 | 28.035 | 28.02 | 28.035 | 5800.0 |
| 2015-12-17 07:05:00 | AAPL | Stock | 28.0475 | 28.0475 | 28.0125 | 28.035 | 11520.0 |
| 2015-12-17 07:10:00 | AAPL | Stock | 28.025 | 28.025 | 28.0225 | 28.0225 | 3800.0 |
| 2015-12-17 07:15:00 | AAPL | Stock | 28.025 | 28.0375 | 28.0225 | 28.025 | 23000.0 |
| 2015-12-17 07:20:00 | AAPL | Stock | 28.015 | 28.035 | 28.0075 | 28.035 | 14840.0 |
| 2015-12-17 07:25:00 | AAPL | Stock | 28.0375 | 28.06 | 28.0275 | 28.05 | 17720.0 |
| 2015-12-17 07:30:00 | AAPL | Stock | 28.0275 | 28.0625 | 28.0275 | 28.05 | 36800.0 |
| 2015-12-17 07:35:00 | AAPL | Stock | 28.0625 | 28.0675 | 28.06 | 28.065 | 15660.0 |
| 2015-12-17 07:40:00 | AAPL | Stock | 28.0825 | 28.1125 | 28.07 | 28.07 | 50248.0 |
| 2015-12-17 07:45:00 | AAPL | Stock | 28.1025 | 28.1075 | 28.085 | 28.1 | 25880.0 |
| 2015-12-17 07:50:00 | AAPL | Stock | 28.0925 | 28.1025 | 28.0925 | 28.1 | 4436.0 |
| 2015-12-17 07:55:00 | AAPL | Stock | 28.1 | 28.1125 | 28.075 | 28.075 | 23812.0 |
| 2015-12-17 08:00:00 | AAPL | Stock | 28.065 | 28.1 | 28.0125 | 28.045 | 105748.0 |
| 2015-12-17 08:05:00 | AAPL | Stock | 28.045 | 28.05 | 28.02 | 28.0375 | 50696.0 |
| 2015-12-17 08:10:00 | AAPL | Stock | 28.04 | 28.075 | 28.04 | 28.065 | 17700.0 |
| 2015-12-17 08:15:00 | AAPL | Stock | 28.065 | 28.065 | 28.0375 | 28.0375 | 40872.0 |
| 2015-12-17 08:20:00 | AAPL | Stock | 28.0375 | 28.085 | 28.0375 | 28.08 | 34840.0 |
| 2015-12-17 08:25:00 | AAPL | Stock | 28.08 | 28.08 | 28.05 | 28.055 | 56692.0 |
| 2015-12-17 08:30:00 | AAPL | Stock | 28.0625 | 28.0725 | 28.0375 | 28.045 | 29180.0 |
| 2015-12-17 08:35:00 | AAPL | Stock | 28.0475 | 28.0925 | 28.045 | 28.07 | 361760.0 |
| 2015-12-17 08:40:00 | AAPL | Stock | 28.07 | 28.08 | 28.07 | 28.075 | 6600.0 |
| 2015-12-17 08:45:00 | AAPL | Stock | 28.0775 | 28.1125 | 28.0775 | 28.105 | 78808.0 |
| 2015-12-17 08:50:00 | AAPL | Stock | 28.1125 | 28.1125 | 28.0825 | 28.0925 | 33500.0 |
| 2015-12-17 08:55:00 | AAPL | Stock | 28.095 | 28.095 | 28.065 | 28.07 | 19580.0 |
| 2015-12-17 09:00:00 | AAPL | Stock | 28.085 | 28.105 | 28.0675 | 28.08 | 82108.0 |
| 2015-12-17 09:05:00 | AAPL | Stock | 28.0775 | 28.085 | 28.0725 | 28.0775 | 83420.0 |
| 2015-12-17 09:10:00 | AAPL | Stock | 28.0825 | 28.11 | 28.0775 | 28.09 | 42600.0 |
| 2015-12-17 09:15:00 | AAPL | Stock | 28.0875 | 28.0875 | 28.065 | 28.0775 | 6400.0 |
| 2015-12-17 09:20:00 | AAPL | Stock | 28.0825 | 28.085 | 27.835 | 28.07 | 48284.0 |
| 2015-12-17 09:25:00 | AAPL | Stock | 28.075 | 28.075 | 28.005 | 28.0375 | 111780.0 |
| 2015-12-17 09:30:00 | AAPL | Stock | 28.005 | 28.0425 | 27.9 | 27.9575 | 5256736.0 |
| 2015-12-17 09:35:00 | AAPL | Stock | 27.955 | 27.9925 | 27.8475 | 27.8725 | 3302524.0 |
| 2015-12-17 09:40:00 | AAPL | Stock | 27.8738 | 27.92 | 27.835 | 27.86 | 3559528.0 |
> showing 50 of 377,336 rows — these rows as CSV