PREVIEW / stock_5min / 2016-11-01
file: by_date/stock_5min/2016/2016-11-01.parquet size: 5.3 MB rows: 348,318 symbols: 3,167
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-11-01 05:25:00 | AAPL | Stock | 28.445 | 28.445 | 28.445 | 28.445 | 400.0 |
| 2016-11-01 07:00:00 | AAPL | Stock | 28.425 | 28.425 | 28.425 | 28.425 | 800.0 |
| 2016-11-01 07:05:00 | AAPL | Stock | 28.4375 | 28.4375 | 28.4375 | 28.4375 | 3676.0 |
| 2016-11-01 07:30:00 | AAPL | Stock | 28.435 | 28.435 | 28.435 | 28.435 | 800.0 |
| 2016-11-01 07:35:00 | AAPL | Stock | 28.4275 | 28.4275 | 28.4275 | 28.4275 | 800.0 |
| 2016-11-01 07:50:00 | AAPL | Stock | 28.4125 | 28.4125 | 28.4125 | 28.4125 | 18896.0 |
| 2016-11-01 08:00:00 | AAPL | Stock | 28.435 | 28.435 | 28.3875 | 28.3875 | 7484.0 |
| 2016-11-01 08:05:00 | AAPL | Stock | 28.3975 | 28.3975 | 28.3875 | 28.3875 | 5564.0 |
| 2016-11-01 08:10:00 | AAPL | Stock | 28.3825 | 28.3825 | 28.375 | 28.375 | 7000.0 |
| 2016-11-01 08:15:00 | AAPL | Stock | 28.375 | 28.3825 | 28.375 | 28.3825 | 28000.0 |
| 2016-11-01 08:20:00 | AAPL | Stock | 28.375 | 28.3825 | 28.35 | 28.35 | 26000.0 |
| 2016-11-01 08:25:00 | AAPL | Stock | 28.365 | 28.365 | 28.365 | 28.365 | 12800.0 |
| 2016-11-01 08:30:00 | AAPL | Stock | 28.3725 | 28.3725 | 28.3725 | 28.3725 | 16000.0 |
| 2016-11-01 08:35:00 | AAPL | Stock | 28.3575 | 28.3575 | 28.3575 | 28.3575 | 4200.0 |
| 2016-11-01 08:40:00 | AAPL | Stock | 28.37 | 28.3725 | 28.37 | 28.3725 | 1600.0 |
| 2016-11-01 08:45:00 | AAPL | Stock | 28.3725 | 28.375 | 28.3725 | 28.3725 | 16400.0 |
| 2016-11-01 08:50:00 | AAPL | Stock | 28.37 | 28.38 | 28.37 | 28.37 | 3600.0 |
| 2016-11-01 08:55:00 | AAPL | Stock | 28.37 | 28.3875 | 28.37 | 28.3875 | 14284.0 |
| 2016-11-01 09:00:00 | AAPL | Stock | 28.3875 | 28.4 | 28.3875 | 28.4 | 5600.0 |
| 2016-11-01 09:05:00 | AAPL | Stock | 28.4 | 28.405 | 28.3925 | 28.3925 | 16924.0 |
| 2016-11-01 09:15:00 | AAPL | Stock | 28.4 | 28.4 | 28.39 | 28.4 | 6400.0 |
| 2016-11-01 09:20:00 | AAPL | Stock | 28.3875 | 28.3875 | 28.36 | 28.365 | 28112.0 |
| 2016-11-01 09:25:00 | AAPL | Stock | 28.375 | 28.395 | 28.3575 | 28.3775 | 112584.0 |
| 2016-11-01 09:30:00 | AAPL | Stock | 28.365 | 28.4425 | 28.365 | 28.411 | 2686552.0 |
| 2016-11-01 09:35:00 | AAPL | Stock | 28.415 | 28.44 | 28.34 | 28.35 | 1511780.0 |
| 2016-11-01 09:40:00 | AAPL | Stock | 28.3525 | 28.355 | 28.2525 | 28.2888 | 3368440.0 |
| 2016-11-01 09:45:00 | AAPL | Stock | 28.29 | 28.325 | 28.2825 | 28.2975 | 1539980.0 |
| 2016-11-01 09:50:00 | AAPL | Stock | 28.3 | 28.3068 | 28.245 | 28.2625 | 2771028.0 |
| 2016-11-01 09:55:00 | AAPL | Stock | 28.2625 | 28.2725 | 28.2475 | 28.2612 | 1593136.0 |
| 2016-11-01 10:00:00 | AAPL | Stock | 28.2625 | 28.3 | 28.23 | 28.2325 | 2026316.0 |
| 2016-11-01 10:05:00 | AAPL | Stock | 28.2325 | 28.2475 | 28.216 | 28.2325 | 1658344.0 |
| 2016-11-01 10:10:00 | AAPL | Stock | 28.2338 | 28.2375 | 28.14 | 28.174 | 3438208.0 |
| 2016-11-01 10:15:00 | AAPL | Stock | 28.174 | 28.18 | 28.1275 | 28.1425 | 2546448.0 |
| 2016-11-01 10:20:00 | AAPL | Stock | 28.1425 | 28.2 | 28.1362 | 28.1968 | 2017420.0 |
| 2016-11-01 10:25:00 | AAPL | Stock | 28.1962 | 28.215 | 28.175 | 28.185 | 1122940.0 |
| 2016-11-01 10:30:00 | AAPL | Stock | 28.1825 | 28.23 | 28.165 | 28.2285 | 1013208.0 |
| 2016-11-01 10:35:00 | AAPL | Stock | 28.2275 | 28.2375 | 28.1775 | 28.1875 | 1092960.0 |
| 2016-11-01 10:40:00 | AAPL | Stock | 28.1885 | 28.2025 | 28.1625 | 28.1735 | 1019236.0 |
| 2016-11-01 10:45:00 | AAPL | Stock | 28.1735 | 28.1825 | 28.155 | 28.155 | 1074548.0 |
| 2016-11-01 10:50:00 | AAPL | Stock | 28.1538 | 28.1875 | 28.15 | 28.18 | 1476908.0 |
| 2016-11-01 10:55:00 | AAPL | Stock | 28.18 | 28.2 | 28.1775 | 28.1975 | 1291580.0 |
| 2016-11-01 11:00:00 | AAPL | Stock | 28.1975 | 28.21 | 28.18 | 28.189 | 1401200.0 |
| 2016-11-01 11:05:00 | AAPL | Stock | 28.19 | 28.2038 | 28.18 | 28.1938 | 695448.0 |
| 2016-11-01 11:10:00 | AAPL | Stock | 28.1938 | 28.205 | 28.17 | 28.1975 | 1083720.0 |
| 2016-11-01 11:15:00 | AAPL | Stock | 28.195 | 28.2075 | 28.1675 | 28.17 | 1059768.0 |
| 2016-11-01 11:20:00 | AAPL | Stock | 28.1725 | 28.18 | 28.165 | 28.1725 | 777708.0 |
| 2016-11-01 11:25:00 | AAPL | Stock | 28.1725 | 28.19 | 28.1575 | 28.1575 | 1148612.0 |
| 2016-11-01 11:30:00 | AAPL | Stock | 28.1575 | 28.1575 | 28.1275 | 28.1338 | 1730484.0 |
| 2016-11-01 11:35:00 | AAPL | Stock | 28.1338 | 28.155 | 28.1275 | 28.15 | 1162556.0 |
| 2016-11-01 11:40:00 | AAPL | Stock | 28.1488 | 28.1575 | 28.1375 | 28.1462 | 908364.0 |
> showing 50 of 348,318 rows — these rows as CSV