PREVIEW / stock_5min / 2015-08-31
file: by_date/stock_5min/2015/2015-08-31.parquet size: 5.4 MB rows: 363,275 symbols: 3,479
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-08-31 04:00:00 | AAPL | Stock | 28.375 | 28.375 | 28.075 | 28.12 | 45120.0 |
| 2015-08-31 04:05:00 | AAPL | Stock | 28.0975 | 28.0975 | 28.0975 | 28.0975 | 1200.0 |
| 2015-08-31 04:10:00 | AAPL | Stock | 28.0975 | 28.0975 | 28.0175 | 28.0175 | 24572.0 |
| 2015-08-31 04:15:00 | AAPL | Stock | 28.0175 | 28.04 | 28.0175 | 28.04 | 2796.0 |
| 2015-08-31 04:20:00 | AAPL | Stock | 28.0325 | 28.04 | 28.0275 | 28.04 | 11724.0 |
| 2015-08-31 04:25:00 | AAPL | Stock | 28.03 | 28.03 | 28.0125 | 28.0125 | 6000.0 |
| 2015-08-31 04:30:00 | AAPL | Stock | 28.025 | 28.04 | 28.0125 | 28.0125 | 15332.0 |
| 2015-08-31 04:35:00 | AAPL | Stock | 28.0125 | 28.0125 | 28.0125 | 28.0125 | 3200.0 |
| 2015-08-31 04:45:00 | AAPL | Stock | 27.98 | 28.0 | 27.9775 | 28.0 | 11836.0 |
| 2015-08-31 04:50:00 | AAPL | Stock | 27.975 | 27.975 | 27.975 | 27.975 | 400.0 |
| 2015-08-31 04:55:00 | AAPL | Stock | 27.975 | 28.0 | 27.975 | 27.99 | 11600.0 |
| 2015-08-31 05:00:00 | AAPL | Stock | 28.0 | 28.0125 | 28.0 | 28.0125 | 9840.0 |
| 2015-08-31 05:05:00 | AAPL | Stock | 28.0125 | 28.0125 | 28.0 | 28.0 | 2800.0 |
| 2015-08-31 05:10:00 | AAPL | Stock | 28.0 | 28.0375 | 28.0 | 28.0275 | 20000.0 |
| 2015-08-31 05:15:00 | AAPL | Stock | 28.0375 | 28.075 | 28.0375 | 28.075 | 8324.0 |
| 2015-08-31 05:20:00 | AAPL | Stock | 28.05 | 28.0625 | 28.05 | 28.0625 | 11520.0 |
| 2015-08-31 05:25:00 | AAPL | Stock | 28.0625 | 28.0625 | 28.045 | 28.0625 | 8180.0 |
| 2015-08-31 05:30:00 | AAPL | Stock | 28.0625 | 28.075 | 28.0625 | 28.075 | 15360.0 |
| 2015-08-31 05:35:00 | AAPL | Stock | 28.06 | 28.0625 | 28.06 | 28.0625 | 2400.0 |
| 2015-08-31 05:40:00 | AAPL | Stock | 28.0575 | 28.0575 | 28.015 | 28.015 | 2800.0 |
| 2015-08-31 05:45:00 | AAPL | Stock | 28.025 | 28.025 | 28.0 | 28.0125 | 1600.0 |
| 2015-08-31 05:50:00 | AAPL | Stock | 28.0125 | 28.025 | 28.0125 | 28.025 | 6488.0 |
| 2015-08-31 05:55:00 | AAPL | Stock | 28.03 | 28.05 | 28.03 | 28.05 | 14300.0 |
| 2015-08-31 06:00:00 | AAPL | Stock | 28.05 | 28.0625 | 28.0375 | 28.0475 | 11012.0 |
| 2015-08-31 06:10:00 | AAPL | Stock | 28.0625 | 28.0675 | 28.0625 | 28.0675 | 13560.0 |
| 2015-08-31 06:15:00 | AAPL | Stock | 28.0575 | 28.075 | 28.055 | 28.075 | 7660.0 |
| 2015-08-31 06:20:00 | AAPL | Stock | 28.075 | 28.125 | 28.075 | 28.125 | 9260.0 |
| 2015-08-31 06:25:00 | AAPL | Stock | 28.1275 | 28.1275 | 28.1125 | 28.1125 | 1200.0 |
| 2015-08-31 06:30:00 | AAPL | Stock | 28.15 | 28.15 | 28.1475 | 28.15 | 4800.0 |
| 2015-08-31 06:40:00 | AAPL | Stock | 28.125 | 28.15 | 28.125 | 28.15 | 5344.0 |
| 2015-08-31 06:45:00 | AAPL | Stock | 28.1375 | 28.1375 | 28.125 | 28.125 | 5580.0 |
| 2015-08-31 06:50:00 | AAPL | Stock | 28.1375 | 28.1375 | 28.115 | 28.12 | 6000.0 |
| 2015-08-31 06:55:00 | AAPL | Stock | 28.0875 | 28.0875 | 28.075 | 28.0775 | 13060.0 |
| 2015-08-31 07:00:00 | AAPL | Stock | 28.0875 | 28.0875 | 28.0875 | 28.0875 | 7800.0 |
| 2015-08-31 07:05:00 | AAPL | Stock | 28.1 | 28.1 | 28.0625 | 28.0625 | 31112.0 |
| 2015-08-31 07:10:00 | AAPL | Stock | 28.08 | 28.09 | 28.075 | 28.08 | 20400.0 |
| 2015-08-31 07:15:00 | AAPL | Stock | 28.08 | 28.1 | 28.075 | 28.0975 | 24000.0 |
| 2015-08-31 07:20:00 | AAPL | Stock | 28.1 | 28.1 | 28.0825 | 28.1 | 30660.0 |
| 2015-08-31 07:25:00 | AAPL | Stock | 28.105 | 28.125 | 28.105 | 28.125 | 13300.0 |
| 2015-08-31 07:30:00 | AAPL | Stock | 28.1225 | 28.1275 | 28.1125 | 28.1275 | 14000.0 |
| 2015-08-31 07:35:00 | AAPL | Stock | 28.125 | 28.135 | 28.1175 | 28.13 | 40120.0 |
| 2015-08-31 07:40:00 | AAPL | Stock | 28.125 | 28.1375 | 28.125 | 28.1375 | 6472.0 |
| 2015-08-31 07:45:00 | AAPL | Stock | 28.14 | 28.1775 | 28.14 | 28.1775 | 9660.0 |
| 2015-08-31 07:55:00 | AAPL | Stock | 28.1675 | 28.1725 | 28.165 | 28.1725 | 1964.0 |
| 2015-08-31 08:00:00 | AAPL | Stock | 28.1575 | 28.1725 | 28.03 | 28.15 | 208852.0 |
| 2015-08-31 08:05:00 | AAPL | Stock | 28.1575 | 28.175 | 28.15 | 28.17 | 38404.0 |
| 2015-08-31 08:10:00 | AAPL | Stock | 28.17 | 28.17 | 28.1175 | 28.125 | 80480.0 |
| 2015-08-31 08:15:00 | AAPL | Stock | 28.125 | 28.125 | 28.1175 | 28.12 | 39584.0 |
| 2015-08-31 08:20:00 | AAPL | Stock | 28.1175 | 28.1175 | 28.0968 | 28.105 | 73460.0 |
| 2015-08-31 08:25:00 | AAPL | Stock | 28.105 | 28.115 | 28.1025 | 28.115 | 36500.0 |
> showing 50 of 363,275 rows — these rows as CSV