PREVIEW / stock_5min / 2016-01-27
file: by_date/stock_5min/2016/2016-01-27.parquet size: 5.4 MB rows: 363,290 symbols: 3,359
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 |
|---|---|---|---|---|---|---|---|
| 2016-01-27 04:00:00 | AAPL | Stock | 24.2625 | 24.2625 | 24.2625 | 24.2625 | 400.0 |
| 2016-01-27 04:15:00 | AAPL | Stock | 24.3125 | 24.3125 | 24.3125 | 24.3125 | 400.0 |
| 2016-01-27 04:30:00 | AAPL | Stock | 24.32 | 24.32 | 24.3 | 24.3 | 2800.0 |
| 2016-01-27 04:35:00 | AAPL | Stock | 24.31 | 24.31 | 24.275 | 24.275 | 1312.0 |
| 2016-01-27 04:40:00 | AAPL | Stock | 24.305 | 24.3075 | 24.295 | 24.3075 | 3844.0 |
| 2016-01-27 04:45:00 | AAPL | Stock | 24.295 | 24.32 | 24.295 | 24.3 | 15240.0 |
| 2016-01-27 04:50:00 | AAPL | Stock | 24.3 | 24.3 | 24.3 | 24.3 | 1772.0 |
| 2016-01-27 04:55:00 | AAPL | Stock | 24.3 | 24.325 | 24.3 | 24.325 | 6028.0 |
| 2016-01-27 05:00:00 | AAPL | Stock | 24.3025 | 24.3025 | 24.3 | 24.3 | 4520.0 |
| 2016-01-27 05:05:00 | AAPL | Stock | 24.325 | 24.325 | 24.275 | 24.275 | 23956.0 |
| 2016-01-27 05:10:00 | AAPL | Stock | 24.2625 | 24.2625 | 24.25 | 24.25 | 2260.0 |
| 2016-01-27 05:15:00 | AAPL | Stock | 24.2625 | 24.2625 | 24.25 | 24.25 | 11988.0 |
| 2016-01-27 05:20:00 | AAPL | Stock | 24.25 | 24.25 | 24.2175 | 24.25 | 15960.0 |
| 2016-01-27 05:25:00 | AAPL | Stock | 24.2425 | 24.25 | 24.2 | 24.25 | 17880.0 |
| 2016-01-27 05:30:00 | AAPL | Stock | 24.2475 | 24.3 | 24.2475 | 24.3 | 19104.0 |
| 2016-01-27 05:35:00 | AAPL | Stock | 24.3 | 24.3125 | 24.2925 | 24.2925 | 36352.0 |
| 2016-01-27 05:40:00 | AAPL | Stock | 24.255 | 24.255 | 24.2225 | 24.255 | 2800.0 |
| 2016-01-27 05:45:00 | AAPL | Stock | 24.27 | 24.27 | 24.2225 | 24.2225 | 2000.0 |
| 2016-01-27 05:50:00 | AAPL | Stock | 24.245 | 24.245 | 24.08 | 24.2 | 19876.0 |
| 2016-01-27 05:55:00 | AAPL | Stock | 24.135 | 24.2 | 23.9425 | 24.125 | 46800.0 |
| 2016-01-27 06:00:00 | AAPL | Stock | 24.1525 | 24.195 | 24.0525 | 24.145 | 64448.0 |
| 2016-01-27 06:05:00 | AAPL | Stock | 24.15 | 24.17 | 23.985 | 24.0025 | 94288.0 |
| 2016-01-27 06:10:00 | AAPL | Stock | 24.095 | 24.095 | 24.0 | 24.005 | 39472.0 |
| 2016-01-27 06:15:00 | AAPL | Stock | 24.0125 | 24.065 | 24.0 | 24.0625 | 22028.0 |
| 2016-01-27 06:20:00 | AAPL | Stock | 24.095 | 24.1125 | 24.0525 | 24.0525 | 22644.0 |
| 2016-01-27 06:25:00 | AAPL | Stock | 23.4198 | 24.045 | 23.4198 | 23.9975 | 60504.0 |
| 2016-01-27 06:30:00 | AAPL | Stock | 24.0475 | 24.0875 | 24.03 | 24.0725 | 22080.0 |
| 2016-01-27 06:35:00 | AAPL | Stock | 24.085 | 24.12 | 24.0625 | 24.12 | 55516.0 |
| 2016-01-27 06:40:00 | AAPL | Stock | 24.1 | 24.1225 | 23.9875 | 24.025 | 95056.0 |
| 2016-01-27 06:45:00 | AAPL | Stock | 24.0125 | 24.0125 | 23.93 | 23.93 | 111340.0 |
| 2016-01-27 06:50:00 | AAPL | Stock | 23.95 | 24.075 | 23.87 | 23.975 | 175060.0 |
| 2016-01-27 06:55:00 | AAPL | Stock | 23.98 | 23.98 | 23.9275 | 23.9725 | 97592.0 |
| 2016-01-27 07:00:00 | AAPL | Stock | 23.9675 | 24.01 | 23.93 | 24.005 | 132292.0 |
| 2016-01-27 07:05:00 | AAPL | Stock | 24.01 | 24.0475 | 23.925 | 23.955 | 261780.0 |
| 2016-01-27 07:10:00 | AAPL | Stock | 24.01 | 24.0625 | 23.955 | 23.9875 | 79988.0 |
| 2016-01-27 07:15:00 | AAPL | Stock | 23.98 | 24.0 | 23.905 | 23.9375 | 304860.0 |
| 2016-01-27 07:20:00 | AAPL | Stock | 23.9475 | 23.9725 | 23.9125 | 23.95 | 140344.0 |
| 2016-01-27 07:25:00 | AAPL | Stock | 23.95 | 24.015 | 23.95 | 23.99 | 139268.0 |
| 2016-01-27 07:30:00 | AAPL | Stock | 23.9775 | 24.03 | 23.975 | 24.02 | 330392.0 |
| 2016-01-27 07:35:00 | AAPL | Stock | 24.0225 | 24.095 | 24.0225 | 24.0275 | 285908.0 |
| 2016-01-27 07:40:00 | AAPL | Stock | 24.045 | 24.0625 | 23.995 | 24.01 | 254272.0 |
| 2016-01-27 07:45:00 | AAPL | Stock | 24.0 | 24.025 | 23.99 | 24.02 | 132952.0 |
| 2016-01-27 07:50:00 | AAPL | Stock | 24.0175 | 24.0575 | 24.0175 | 24.0575 | 249312.0 |
| 2016-01-27 07:55:00 | AAPL | Stock | 24.0575 | 24.1025 | 24.05 | 24.1025 | 133068.0 |
| 2016-01-27 08:00:00 | AAPL | Stock | 24.0875 | 24.1 | 23.925 | 24.0675 | 1195800.0 |
| 2016-01-27 08:05:00 | AAPL | Stock | 24.05 | 24.0775 | 24.0325 | 24.06 | 261212.0 |
| 2016-01-27 08:10:00 | AAPL | Stock | 24.055 | 24.1 | 24.0475 | 24.075 | 404320.0 |
| 2016-01-27 08:15:00 | AAPL | Stock | 24.0875 | 24.1 | 24.05 | 24.05 | 339112.0 |
| 2016-01-27 08:20:00 | AAPL | Stock | 24.05 | 24.0975 | 24.0475 | 24.0975 | 257712.0 |
| 2016-01-27 08:25:00 | AAPL | Stock | 24.0975 | 24.2475 | 24.0925 | 24.22 | 828764.0 |
> showing 50 of 363,290 rows — these rows as CSV