PREVIEW / stock_5min / 2016-02-23
file: by_date/stock_5min/2016/2016-02-23.parquet size: 5.3 MB rows: 355,714 symbols: 3,341
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-02-23 04:50:00 | AAPL | Stock | 24.0625 | 24.0625 | 24.0625 | 24.0625 | 4000.0 |
| 2016-02-23 05:10:00 | AAPL | Stock | 24.0625 | 24.0625 | 24.0625 | 24.0625 | 400.0 |
| 2016-02-23 06:05:00 | AAPL | Stock | 24.1125 | 24.1125 | 24.1125 | 24.1125 | 2000.0 |
| 2016-02-23 06:15:00 | AAPL | Stock | 24.1125 | 24.1125 | 24.1 | 24.1 | 2000.0 |
| 2016-02-23 06:55:00 | AAPL | Stock | 24.1 | 24.1 | 24.1 | 24.1 | 1932.0 |
| 2016-02-23 07:00:00 | AAPL | Stock | 24.1175 | 24.1175 | 24.1175 | 24.1175 | 34480.0 |
| 2016-02-23 07:05:00 | AAPL | Stock | 24.1175 | 24.1175 | 24.1175 | 24.1175 | 12000.0 |
| 2016-02-23 07:10:00 | AAPL | Stock | 24.125 | 24.125 | 24.125 | 24.125 | 3600.0 |
| 2016-02-23 07:25:00 | AAPL | Stock | 24.1175 | 24.1175 | 24.115 | 24.115 | 1960.0 |
| 2016-02-23 07:30:00 | AAPL | Stock | 24.145 | 24.15 | 24.145 | 24.15 | 5600.0 |
| 2016-02-23 07:40:00 | AAPL | Stock | 24.1425 | 24.1425 | 24.1275 | 24.1275 | 2400.0 |
| 2016-02-23 07:45:00 | AAPL | Stock | 24.1325 | 24.1325 | 24.125 | 24.125 | 2800.0 |
| 2016-02-23 07:50:00 | AAPL | Stock | 24.115 | 24.115 | 24.1075 | 24.1075 | 1940.0 |
| 2016-02-23 07:55:00 | AAPL | Stock | 24.1 | 24.1 | 24.09 | 24.1 | 20800.0 |
| 2016-02-23 08:00:00 | AAPL | Stock | 24.115 | 24.135 | 24.08 | 24.08 | 107384.0 |
| 2016-02-23 08:05:00 | AAPL | Stock | 24.0825 | 24.0825 | 24.0625 | 24.08 | 54972.0 |
| 2016-02-23 08:10:00 | AAPL | Stock | 24.0775 | 24.0775 | 24.075 | 24.075 | 6300.0 |
| 2016-02-23 08:15:00 | AAPL | Stock | 24.0775 | 24.0775 | 24.0625 | 24.075 | 84308.0 |
| 2016-02-23 08:20:00 | AAPL | Stock | 24.075 | 24.0875 | 24.065 | 24.0875 | 10656.0 |
| 2016-02-23 08:25:00 | AAPL | Stock | 24.0925 | 24.0975 | 24.075 | 24.08 | 20232.0 |
| 2016-02-23 08:30:00 | AAPL | Stock | 24.075 | 24.0875 | 24.0675 | 24.075 | 17200.0 |
| 2016-02-23 08:35:00 | AAPL | Stock | 24.0875 | 24.0875 | 24.0775 | 24.0875 | 8480.0 |
| 2016-02-23 08:40:00 | AAPL | Stock | 24.0925 | 24.1 | 24.0925 | 24.095 | 33720.0 |
| 2016-02-23 08:45:00 | AAPL | Stock | 24.1 | 24.125 | 24.1 | 24.125 | 17848.0 |
| 2016-02-23 08:50:00 | AAPL | Stock | 24.125 | 24.13 | 24.1125 | 24.13 | 2932.0 |
| 2016-02-23 08:55:00 | AAPL | Stock | 24.13 | 24.1475 | 24.1275 | 24.1275 | 18360.0 |
| 2016-02-23 09:00:00 | AAPL | Stock | 24.12 | 24.125 | 24.12 | 24.125 | 5600.0 |
| 2016-02-23 09:05:00 | AAPL | Stock | 24.1075 | 24.1175 | 24.095 | 24.1 | 16068.0 |
| 2016-02-23 09:10:00 | AAPL | Stock | 24.1125 | 24.1125 | 24.095 | 24.1 | 16760.0 |
| 2016-02-23 09:15:00 | AAPL | Stock | 24.095 | 24.095 | 24.0725 | 24.0875 | 40168.0 |
| 2016-02-23 09:20:00 | AAPL | Stock | 24.09 | 24.09 | 24.0825 | 24.0825 | 1200.0 |
| 2016-02-23 09:25:00 | AAPL | Stock | 24.0875 | 24.1075 | 24.0775 | 24.0975 | 108844.0 |
| 2016-02-23 09:30:00 | AAPL | Stock | 24.1 | 24.1 | 24.032 | 24.08 | 3500160.0 |
| 2016-02-23 09:35:00 | AAPL | Stock | 24.0875 | 24.125 | 24.0725 | 24.0725 | 1872736.0 |
| 2016-02-23 09:40:00 | AAPL | Stock | 24.07 | 24.0875 | 24.045 | 24.07 | 2114148.0 |
| 2016-02-23 09:45:00 | AAPL | Stock | 24.0725 | 24.095 | 24.04 | 24.0475 | 1488456.0 |
| 2016-02-23 09:50:00 | AAPL | Stock | 24.05 | 24.0725 | 24.0425 | 24.0703 | 1462116.0 |
| 2016-02-23 09:55:00 | AAPL | Stock | 24.0725 | 24.095 | 24.04 | 24.045 | 1164300.0 |
| 2016-02-23 10:00:00 | AAPL | Stock | 24.0425 | 24.055 | 24.01 | 24.0325 | 1921544.0 |
| 2016-02-23 10:05:00 | AAPL | Stock | 24.0325 | 24.04 | 23.9525 | 23.9538 | 3021692.0 |
| 2016-02-23 10:10:00 | AAPL | Stock | 23.9525 | 24.0 | 23.9425 | 23.99 | 2237392.0 |
| 2016-02-23 10:15:00 | AAPL | Stock | 23.9912 | 24.02 | 23.9775 | 23.98 | 1324360.0 |
| 2016-02-23 10:20:00 | AAPL | Stock | 23.9812 | 23.995 | 23.9288 | 23.945 | 1908296.0 |
| 2016-02-23 10:25:00 | AAPL | Stock | 23.945 | 23.9875 | 23.935 | 23.945 | 2332968.0 |
| 2016-02-23 10:30:00 | AAPL | Stock | 23.9475 | 23.9575 | 23.915 | 23.9225 | 1949944.0 |
| 2016-02-23 10:35:00 | AAPL | Stock | 23.9225 | 23.93 | 23.8825 | 23.8875 | 1894948.0 |
| 2016-02-23 10:40:00 | AAPL | Stock | 23.8875 | 23.9225 | 23.88 | 23.9075 | 1411136.0 |
| 2016-02-23 10:45:00 | AAPL | Stock | 23.9075 | 23.9075 | 23.85 | 23.8712 | 1760584.0 |
| 2016-02-23 10:50:00 | AAPL | Stock | 23.87 | 23.8725 | 23.8275 | 23.845 | 1567856.0 |
| 2016-02-23 10:55:00 | AAPL | Stock | 23.8475 | 23.8475 | 23.805 | 23.8162 | 1548960.0 |
> showing 50 of 355,714 rows — these rows as CSV