PREVIEW / stock_5min / 2016-04-27
file: by_date/stock_5min/2016/2016-04-27.parquet size: 5.4 MB rows: 360,377 symbols: 3,327
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-04-27 04:00:00 | AAPL | Stock | 24.6875 | 24.6875 | 24.185 | 24.23 | 91516.0 |
| 2016-04-27 04:05:00 | AAPL | Stock | 24.23 | 24.25 | 24.23 | 24.245 | 74796.0 |
| 2016-04-27 04:10:00 | AAPL | Stock | 24.2625 | 24.275 | 24.25 | 24.275 | 44620.0 |
| 2016-04-27 04:15:00 | AAPL | Stock | 24.2725 | 24.275 | 24.26 | 24.2625 | 6764.0 |
| 2016-04-27 04:20:00 | AAPL | Stock | 24.265 | 24.2875 | 24.2475 | 24.2725 | 15476.0 |
| 2016-04-27 04:25:00 | AAPL | Stock | 24.2725 | 24.285 | 24.23 | 24.25 | 15880.0 |
| 2016-04-27 04:30:00 | AAPL | Stock | 24.2525 | 24.28 | 24.25 | 24.2725 | 50136.0 |
| 2016-04-27 04:35:00 | AAPL | Stock | 24.285 | 24.2875 | 24.2725 | 24.2725 | 18364.0 |
| 2016-04-27 04:40:00 | AAPL | Stock | 24.27 | 24.2875 | 24.27 | 24.27 | 15020.0 |
| 2016-04-27 04:45:00 | AAPL | Stock | 24.275 | 24.2825 | 24.25 | 24.2825 | 67692.0 |
| 2016-04-27 04:50:00 | AAPL | Stock | 24.26 | 24.2825 | 24.2525 | 24.2825 | 3096.0 |
| 2016-04-27 04:55:00 | AAPL | Stock | 24.2825 | 24.2875 | 24.28 | 24.28 | 10024.0 |
| 2016-04-27 05:00:00 | AAPL | Stock | 24.2725 | 24.275 | 24.2525 | 24.2525 | 14808.0 |
| 2016-04-27 05:05:00 | AAPL | Stock | 24.255 | 24.275 | 24.2125 | 24.2125 | 45136.0 |
| 2016-04-27 05:10:00 | AAPL | Stock | 24.2325 | 24.25 | 24.23 | 24.25 | 26344.0 |
| 2016-04-27 05:15:00 | AAPL | Stock | 24.2375 | 24.2475 | 24.215 | 24.215 | 13200.0 |
| 2016-04-27 05:20:00 | AAPL | Stock | 24.2425 | 24.2475 | 24.225 | 24.225 | 6340.0 |
| 2016-04-27 05:25:00 | AAPL | Stock | 24.2125 | 24.225 | 24.2 | 24.2 | 12596.0 |
| 2016-04-27 05:30:00 | AAPL | Stock | 24.225 | 24.225 | 24.2 | 24.22 | 4000.0 |
| 2016-04-27 05:35:00 | AAPL | Stock | 24.205 | 24.225 | 24.1675 | 24.19 | 45284.0 |
| 2016-04-27 05:40:00 | AAPL | Stock | 24.195 | 24.2 | 24.18 | 24.18 | 4976.0 |
| 2016-04-27 05:45:00 | AAPL | Stock | 24.185 | 24.2 | 24.185 | 24.185 | 21524.0 |
| 2016-04-27 05:50:00 | AAPL | Stock | 24.1775 | 24.1925 | 24.1775 | 24.1875 | 8808.0 |
| 2016-04-27 05:55:00 | AAPL | Stock | 24.18 | 24.1875 | 24.1775 | 24.1875 | 4000.0 |
| 2016-04-27 06:00:00 | AAPL | Stock | 24.18 | 24.1875 | 24.1625 | 24.1625 | 28204.0 |
| 2016-04-27 06:05:00 | AAPL | Stock | 24.1625 | 24.1875 | 24.155 | 24.1675 | 11376.0 |
| 2016-04-27 06:10:00 | AAPL | Stock | 24.1675 | 24.1875 | 24.1575 | 24.1725 | 83016.0 |
| 2016-04-27 06:15:00 | AAPL | Stock | 24.1775 | 24.1975 | 24.14 | 24.1625 | 64688.0 |
| 2016-04-27 06:20:00 | AAPL | Stock | 24.165 | 24.165 | 24.1025 | 24.125 | 134032.0 |
| 2016-04-27 06:25:00 | AAPL | Stock | 24.1025 | 24.16 | 24.0875 | 24.105 | 52368.0 |
| 2016-04-27 06:30:00 | AAPL | Stock | 24.0875 | 24.125 | 24.05 | 24.125 | 183772.0 |
| 2016-04-27 06:35:00 | AAPL | Stock | 24.075 | 24.1 | 24.0525 | 24.1 | 102680.0 |
| 2016-04-27 06:40:00 | AAPL | Stock | 24.1 | 24.1475 | 24.1 | 24.1475 | 42792.0 |
| 2016-04-27 06:45:00 | AAPL | Stock | 24.135 | 24.1825 | 24.12 | 24.14 | 33044.0 |
| 2016-04-27 06:50:00 | AAPL | Stock | 24.17 | 24.185 | 24.145 | 24.145 | 14332.0 |
| 2016-04-27 06:55:00 | AAPL | Stock | 24.17 | 24.1725 | 24.1375 | 24.145 | 27860.0 |
| 2016-04-27 07:00:00 | AAPL | Stock | 24.1375 | 24.1625 | 24.085 | 24.145 | 123160.0 |
| 2016-04-27 07:05:00 | AAPL | Stock | 24.14 | 24.1725 | 24.1275 | 24.1425 | 49152.0 |
| 2016-04-27 07:10:00 | AAPL | Stock | 24.15 | 24.1625 | 24.15 | 24.15 | 14064.0 |
| 2016-04-27 07:15:00 | AAPL | Stock | 24.15 | 24.155 | 24.105 | 24.115 | 52276.0 |
| 2016-04-27 07:20:00 | AAPL | Stock | 24.1225 | 24.1225 | 24.07 | 24.085 | 102900.0 |
| 2016-04-27 07:25:00 | AAPL | Stock | 24.085 | 24.11 | 24.075 | 24.09 | 53568.0 |
| 2016-04-27 07:30:00 | AAPL | Stock | 24.09 | 24.0925 | 24.0625 | 24.0625 | 61680.0 |
| 2016-04-27 07:35:00 | AAPL | Stock | 24.0775 | 24.155 | 24.0675 | 24.1425 | 106952.0 |
| 2016-04-27 07:40:00 | AAPL | Stock | 24.1525 | 24.155 | 24.095 | 24.1175 | 105300.0 |
| 2016-04-27 07:45:00 | AAPL | Stock | 24.12 | 24.12 | 23.925 | 23.945 | 706328.0 |
| 2016-04-27 07:50:00 | AAPL | Stock | 23.95 | 24.025 | 23.895 | 23.95 | 767192.0 |
| 2016-04-27 07:55:00 | AAPL | Stock | 23.9425 | 23.97 | 23.915 | 23.95 | 748200.0 |
| 2016-04-27 08:00:00 | AAPL | Stock | 23.95 | 24.1875 | 23.9125 | 24.015 | 904252.0 |
| 2016-04-27 08:05:00 | AAPL | Stock | 24.0075 | 24.07 | 23.9425 | 24.065 | 956112.0 |
> showing 50 of 360,377 rows — these rows as CSV