PREVIEW / stock_5min / 2016-10-03
file: by_date/stock_5min/2016/2016-10-03.parquet size: 5.2 MB rows: 344,626 symbols: 3,218
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-10-03 05:20:00 | AAPL | Stock | 28.2425 | 28.2425 | 28.2425 | 28.2425 | 400.0 |
| 2016-10-03 05:25:00 | AAPL | Stock | 28.2425 | 28.2425 | 28.2425 | 28.2425 | 1596.0 |
| 2016-10-03 06:05:00 | AAPL | Stock | 28.2425 | 28.2425 | 28.2425 | 28.2425 | 400.0 |
| 2016-10-03 06:50:00 | AAPL | Stock | 28.2425 | 28.2425 | 28.24 | 28.24 | 4000.0 |
| 2016-10-03 07:00:00 | AAPL | Stock | 28.245 | 28.245 | 28.2375 | 28.245 | 3200.0 |
| 2016-10-03 07:05:00 | AAPL | Stock | 28.245 | 28.245 | 28.245 | 28.245 | 400.0 |
| 2016-10-03 07:10:00 | AAPL | Stock | 28.2475 | 28.25 | 28.2475 | 28.25 | 6056.0 |
| 2016-10-03 07:15:00 | AAPL | Stock | 28.2525 | 28.3225 | 28.2525 | 28.3125 | 4840.0 |
| 2016-10-03 07:25:00 | AAPL | Stock | 28.25 | 28.3075 | 28.25 | 28.3075 | 4200.0 |
| 2016-10-03 07:35:00 | AAPL | Stock | 28.3075 | 28.3075 | 28.3075 | 28.3075 | 3960.0 |
| 2016-10-03 07:40:00 | AAPL | Stock | 28.3075 | 28.315 | 28.3075 | 28.315 | 3888.0 |
| 2016-10-03 07:45:00 | AAPL | Stock | 28.325 | 28.325 | 28.325 | 28.325 | 4000.0 |
| 2016-10-03 07:50:00 | AAPL | Stock | 28.3175 | 28.3175 | 28.3175 | 28.3175 | 2400.0 |
| 2016-10-03 08:00:00 | AAPL | Stock | 28.3 | 28.3 | 28.245 | 28.25 | 31664.0 |
| 2016-10-03 08:05:00 | AAPL | Stock | 28.2525 | 28.2525 | 28.2425 | 28.2425 | 13796.0 |
| 2016-10-03 08:10:00 | AAPL | Stock | 28.2425 | 28.2425 | 28.2375 | 28.2375 | 9080.0 |
| 2016-10-03 08:15:00 | AAPL | Stock | 28.225 | 28.24 | 28.2225 | 28.24 | 4488.0 |
| 2016-10-03 08:20:00 | AAPL | Stock | 28.24 | 28.24 | 28.2275 | 28.24 | 33600.0 |
| 2016-10-03 08:25:00 | AAPL | Stock | 28.245 | 28.2575 | 28.24 | 28.2575 | 26584.0 |
| 2016-10-03 08:30:00 | AAPL | Stock | 28.26 | 28.2625 | 28.255 | 28.255 | 12172.0 |
| 2016-10-03 08:35:00 | AAPL | Stock | 28.2525 | 28.2525 | 28.2475 | 28.2475 | 16800.0 |
| 2016-10-03 08:40:00 | AAPL | Stock | 28.2475 | 28.2475 | 28.24 | 28.24 | 17516.0 |
| 2016-10-03 08:45:00 | AAPL | Stock | 28.23 | 28.2375 | 28.23 | 28.2375 | 3600.0 |
| 2016-10-03 08:50:00 | AAPL | Stock | 28.2375 | 28.2375 | 28.2125 | 28.2225 | 18332.0 |
| 2016-10-03 08:55:00 | AAPL | Stock | 28.2025 | 28.225 | 28.2 | 28.2025 | 18800.0 |
| 2016-10-03 09:00:00 | AAPL | Stock | 28.2025 | 28.225 | 28.2025 | 28.225 | 26320.0 |
| 2016-10-03 09:05:00 | AAPL | Stock | 28.2275 | 28.23 | 28.22 | 28.2275 | 10936.0 |
| 2016-10-03 09:10:00 | AAPL | Stock | 28.2225 | 28.225 | 28.2125 | 28.215 | 14400.0 |
| 2016-10-03 09:15:00 | AAPL | Stock | 28.2125 | 28.225 | 28.2125 | 28.2125 | 29968.0 |
| 2016-10-03 09:20:00 | AAPL | Stock | 28.2125 | 28.23 | 28.2025 | 28.22 | 61184.0 |
| 2016-10-03 09:25:00 | AAPL | Stock | 28.22 | 28.2225 | 28.18 | 28.19 | 12200.0 |
| 2016-10-03 09:30:00 | AAPL | Stock | 28.1775 | 28.2548 | 28.1525 | 28.2288 | 3833500.0 |
| 2016-10-03 09:35:00 | AAPL | Stock | 28.2275 | 28.2375 | 28.1775 | 28.1925 | 1972232.0 |
| 2016-10-03 09:40:00 | AAPL | Stock | 28.1972 | 28.1972 | 28.1018 | 28.1018 | 1752436.0 |
| 2016-10-03 09:45:00 | AAPL | Stock | 28.1 | 28.1425 | 28.0875 | 28.11 | 2275220.0 |
| 2016-10-03 09:50:00 | AAPL | Stock | 28.1102 | 28.1238 | 28.0825 | 28.105 | 1621804.0 |
| 2016-10-03 09:55:00 | AAPL | Stock | 28.1028 | 28.1238 | 28.0852 | 28.1225 | 1229276.0 |
| 2016-10-03 10:00:00 | AAPL | Stock | 28.1225 | 28.16 | 28.105 | 28.145 | 1617088.0 |
| 2016-10-03 10:05:00 | AAPL | Stock | 28.1425 | 28.1525 | 28.105 | 28.1525 | 1033432.0 |
| 2016-10-03 10:10:00 | AAPL | Stock | 28.1525 | 28.174 | 28.1425 | 28.1715 | 1018356.0 |
| 2016-10-03 10:15:00 | AAPL | Stock | 28.17 | 28.17 | 28.14 | 28.1525 | 769648.0 |
| 2016-10-03 10:20:00 | AAPL | Stock | 28.1525 | 28.1575 | 28.12 | 28.135 | 727188.0 |
| 2016-10-03 10:25:00 | AAPL | Stock | 28.1325 | 28.145 | 28.115 | 28.12 | 887452.0 |
| 2016-10-03 10:30:00 | AAPL | Stock | 28.12 | 28.175 | 28.115 | 28.1678 | 746496.0 |
| 2016-10-03 10:35:00 | AAPL | Stock | 28.17 | 28.1975 | 28.17 | 28.19 | 1002844.0 |
| 2016-10-03 10:40:00 | AAPL | Stock | 28.1915 | 28.215 | 28.18 | 28.2125 | 1119056.0 |
| 2016-10-03 10:45:00 | AAPL | Stock | 28.2125 | 28.2525 | 28.2 | 28.2512 | 1505848.0 |
| 2016-10-03 10:50:00 | AAPL | Stock | 28.251 | 28.2625 | 28.2275 | 28.2575 | 1239848.0 |
| 2016-10-03 10:55:00 | AAPL | Stock | 28.26 | 28.26 | 28.2275 | 28.2375 | 763856.0 |
| 2016-10-03 11:00:00 | AAPL | Stock | 28.2375 | 28.2425 | 28.2275 | 28.23 | 493608.0 |
> showing 50 of 344,626 rows — these rows as CSV