PREVIEW / stock_5min / 2016-08-03
file: by_date/stock_5min/2016/2016-08-03.parquet size: 5.4 MB rows: 353,280 symbols: 3,248
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-08-03 04:20:00 | AAPL | Stock | 26.08 | 26.08 | 26.08 | 26.08 | 1908.0 |
| 2016-08-03 04:30:00 | AAPL | Stock | 26.1175 | 26.1175 | 26.1175 | 26.1175 | 400.0 |
| 2016-08-03 04:55:00 | AAPL | Stock | 26.08 | 26.08 | 26.08 | 26.08 | 864.0 |
| 2016-08-03 05:20:00 | AAPL | Stock | 26.1175 | 26.1175 | 26.1175 | 26.1175 | 400.0 |
| 2016-08-03 05:50:00 | AAPL | Stock | 26.15 | 26.15 | 26.15 | 26.15 | 800.0 |
| 2016-08-03 05:55:00 | AAPL | Stock | 26.15 | 26.15 | 26.15 | 26.15 | 400.0 |
| 2016-08-03 06:05:00 | AAPL | Stock | 26.15 | 26.15 | 26.15 | 26.15 | 3600.0 |
| 2016-08-03 06:25:00 | AAPL | Stock | 26.145 | 26.145 | 26.145 | 26.145 | 2036.0 |
| 2016-08-03 06:35:00 | AAPL | Stock | 26.1625 | 26.1625 | 26.1625 | 26.1625 | 400.0 |
| 2016-08-03 06:40:00 | AAPL | Stock | 26.165 | 26.165 | 26.165 | 26.165 | 4000.0 |
| 2016-08-03 06:45:00 | AAPL | Stock | 26.1625 | 26.1625 | 26.1575 | 26.1575 | 5840.0 |
| 2016-08-03 06:50:00 | AAPL | Stock | 26.145 | 26.145 | 26.135 | 26.135 | 3600.0 |
| 2016-08-03 07:00:00 | AAPL | Stock | 26.13 | 26.13 | 26.13 | 26.13 | 1200.0 |
| 2016-08-03 07:10:00 | AAPL | Stock | 26.15 | 26.15 | 26.15 | 26.15 | 1620.0 |
| 2016-08-03 07:25:00 | AAPL | Stock | 26.13 | 26.13 | 26.13 | 26.13 | 708.0 |
| 2016-08-03 07:35:00 | AAPL | Stock | 26.13 | 26.13 | 26.125 | 26.125 | 5680.0 |
| 2016-08-03 07:45:00 | AAPL | Stock | 26.145 | 26.145 | 26.145 | 26.145 | 2400.0 |
| 2016-08-03 07:50:00 | AAPL | Stock | 26.145 | 26.145 | 26.13 | 26.13 | 8000.0 |
| 2016-08-03 07:55:00 | AAPL | Stock | 26.13 | 26.1325 | 26.13 | 26.1325 | 3800.0 |
| 2016-08-03 08:00:00 | AAPL | Stock | 26.145 | 26.15 | 26.12 | 26.15 | 41596.0 |
| 2016-08-03 08:05:00 | AAPL | Stock | 26.15 | 26.15 | 26.135 | 26.135 | 16000.0 |
| 2016-08-03 08:10:00 | AAPL | Stock | 26.15 | 26.1625 | 26.145 | 26.1625 | 18600.0 |
| 2016-08-03 08:15:00 | AAPL | Stock | 26.17 | 26.1775 | 26.165 | 26.17 | 35600.0 |
| 2016-08-03 08:20:00 | AAPL | Stock | 26.17 | 26.1975 | 26.17 | 26.19 | 36144.0 |
| 2016-08-03 08:25:00 | AAPL | Stock | 26.185 | 26.19 | 26.18 | 26.19 | 28352.0 |
| 2016-08-03 08:30:00 | AAPL | Stock | 26.185 | 26.19 | 26.17 | 26.17 | 28316.0 |
| 2016-08-03 08:35:00 | AAPL | Stock | 26.1675 | 26.1725 | 26.15 | 26.1725 | 7200.0 |
| 2016-08-03 08:40:00 | AAPL | Stock | 26.16 | 26.1725 | 26.16 | 26.1725 | 1300.0 |
| 2016-08-03 08:45:00 | AAPL | Stock | 26.1725 | 26.1725 | 26.1625 | 26.1725 | 20520.0 |
| 2016-08-03 08:50:00 | AAPL | Stock | 26.1675 | 26.17 | 26.1625 | 26.1625 | 23252.0 |
| 2016-08-03 08:55:00 | AAPL | Stock | 26.16 | 26.1675 | 26.1575 | 26.1675 | 8284.0 |
| 2016-08-03 09:00:00 | AAPL | Stock | 26.1675 | 26.18 | 26.1675 | 26.18 | 9904.0 |
| 2016-08-03 09:05:00 | AAPL | Stock | 26.18 | 26.1875 | 26.18 | 26.1875 | 37060.0 |
| 2016-08-03 09:10:00 | AAPL | Stock | 26.1875 | 26.1875 | 26.18 | 26.185 | 23952.0 |
| 2016-08-03 09:15:00 | AAPL | Stock | 26.185 | 26.19 | 26.1825 | 26.1825 | 35428.0 |
| 2016-08-03 09:20:00 | AAPL | Stock | 26.185 | 26.185 | 26.18 | 26.18 | 12800.0 |
| 2016-08-03 09:25:00 | AAPL | Stock | 26.18 | 26.2125 | 26.1775 | 26.2125 | 66064.0 |
| 2016-08-03 09:30:00 | AAPL | Stock | 26.2025 | 26.3475 | 26.1925 | 26.313 | 6461204.0 |
| 2016-08-03 09:35:00 | AAPL | Stock | 26.3135 | 26.385 | 26.275 | 26.385 | 4170708.0 |
| 2016-08-03 09:40:00 | AAPL | Stock | 26.385 | 26.4 | 26.3675 | 26.3762 | 3251044.0 |
| 2016-08-03 09:45:00 | AAPL | Stock | 26.3775 | 26.3925 | 26.35 | 26.3875 | 2540512.0 |
| 2016-08-03 09:50:00 | AAPL | Stock | 26.3875 | 26.3875 | 26.3175 | 26.3275 | 1899564.0 |
| 2016-08-03 09:55:00 | AAPL | Stock | 26.3275 | 26.39 | 26.315 | 26.39 | 2507808.0 |
| 2016-08-03 10:00:00 | AAPL | Stock | 26.39 | 26.405 | 26.3725 | 26.395 | 2497136.0 |
| 2016-08-03 10:05:00 | AAPL | Stock | 26.3925 | 26.4075 | 26.355 | 26.3862 | 2147332.0 |
| 2016-08-03 10:10:00 | AAPL | Stock | 26.3875 | 26.4462 | 26.385 | 26.4438 | 2479192.0 |
| 2016-08-03 10:15:00 | AAPL | Stock | 26.445 | 26.46 | 26.404 | 26.405 | 2443192.0 |
| 2016-08-03 10:20:00 | AAPL | Stock | 26.4062 | 26.42 | 26.3748 | 26.376 | 1177936.0 |
| 2016-08-03 10:25:00 | AAPL | Stock | 26.3775 | 26.3975 | 26.375 | 26.39 | 1028044.0 |
| 2016-08-03 10:30:00 | AAPL | Stock | 26.3875 | 26.41 | 26.3725 | 26.3975 | 1629172.0 |
> showing 50 of 353,280 rows — these rows as CSV