PREVIEW / stock_5min / 2019-02-05
file: by_date/stock_5min/2019/2019-02-05.parquet size: 5.6 MB rows: 353,008 symbols: 2,686
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 |
|---|---|---|---|---|---|---|---|
| 2019-02-05 04:00:00 | AAPL | Stock | 42.825 | 42.9375 | 42.825 | 42.875 | 37672.0 |
| 2019-02-05 04:05:00 | AAPL | Stock | 42.875 | 42.9 | 42.875 | 42.9 | 5864.0 |
| 2019-02-05 04:10:00 | AAPL | Stock | 42.8975 | 42.8975 | 42.825 | 42.8325 | 3200.0 |
| 2019-02-05 04:25:00 | AAPL | Stock | 42.895 | 42.895 | 42.895 | 42.895 | 400.0 |
| 2019-02-05 04:30:00 | AAPL | Stock | 42.8525 | 42.875 | 42.8525 | 42.865 | 14700.0 |
| 2019-02-05 04:35:00 | AAPL | Stock | 42.865 | 42.865 | 42.865 | 42.865 | 1016.0 |
| 2019-02-05 04:40:00 | AAPL | Stock | 42.865 | 42.865 | 42.865 | 42.865 | 800.0 |
| 2019-02-05 04:45:00 | AAPL | Stock | 42.865 | 42.865 | 42.865 | 42.865 | 1868.0 |
| 2019-02-05 04:55:00 | AAPL | Stock | 42.88 | 42.9 | 42.88 | 42.895 | 13824.0 |
| 2019-02-05 05:00:00 | AAPL | Stock | 42.9 | 42.9 | 42.895 | 42.9 | 6948.0 |
| 2019-02-05 05:10:00 | AAPL | Stock | 42.9 | 42.91 | 42.895 | 42.9 | 11196.0 |
| 2019-02-05 05:15:00 | AAPL | Stock | 42.91 | 42.93 | 42.91 | 42.93 | 3820.0 |
| 2019-02-05 05:30:00 | AAPL | Stock | 42.9 | 42.9 | 42.9 | 42.9 | 800.0 |
| 2019-02-05 05:35:00 | AAPL | Stock | 42.9125 | 42.9125 | 42.9125 | 42.9125 | 424.0 |
| 2019-02-05 05:40:00 | AAPL | Stock | 42.925 | 42.98 | 42.925 | 42.98 | 5256.0 |
| 2019-02-05 06:00:00 | AAPL | Stock | 42.975 | 42.975 | 42.975 | 42.975 | 400.0 |
| 2019-02-05 06:10:00 | AAPL | Stock | 42.975 | 43.0575 | 42.975 | 43.055 | 7156.0 |
| 2019-02-05 06:25:00 | AAPL | Stock | 43.105 | 43.105 | 43.105 | 43.105 | 3416.0 |
| 2019-02-05 06:35:00 | AAPL | Stock | 43.0725 | 43.0725 | 43.025 | 43.0275 | 7940.0 |
| 2019-02-05 06:40:00 | AAPL | Stock | 43.0125 | 43.0125 | 43.0075 | 43.0075 | 2496.0 |
| 2019-02-05 06:45:00 | AAPL | Stock | 43.0275 | 43.0275 | 43.0275 | 43.0275 | 800.0 |
| 2019-02-05 06:50:00 | AAPL | Stock | 43.0275 | 43.0275 | 43.0275 | 43.0275 | 400.0 |
| 2019-02-05 06:55:00 | AAPL | Stock | 43.0275 | 43.0275 | 43.0275 | 43.0275 | 1984.0 |
| 2019-02-05 07:00:00 | AAPL | Stock | 43.0025 | 43.0275 | 43.0 | 43.025 | 31772.0 |
| 2019-02-05 07:05:00 | AAPL | Stock | 43.0125 | 43.025 | 43.0025 | 43.0125 | 8108.0 |
| 2019-02-05 07:10:00 | AAPL | Stock | 43.0225 | 43.0625 | 43.0225 | 43.0625 | 23440.0 |
| 2019-02-05 07:15:00 | AAPL | Stock | 43.0625 | 43.07 | 43.0625 | 43.07 | 1680.0 |
| 2019-02-05 07:20:00 | AAPL | Stock | 43.07 | 43.095 | 43.0625 | 43.09 | 27316.0 |
| 2019-02-05 07:25:00 | AAPL | Stock | 43.0875 | 43.0875 | 43.0525 | 43.0525 | 15340.0 |
| 2019-02-05 07:30:00 | AAPL | Stock | 43.0625 | 43.07 | 43.0125 | 43.0575 | 18120.0 |
| 2019-02-05 07:35:00 | AAPL | Stock | 43.0625 | 43.0775 | 43.05 | 43.0775 | 16724.0 |
| 2019-02-05 07:40:00 | AAPL | Stock | 43.0675 | 43.1325 | 43.0675 | 43.13 | 64228.0 |
| 2019-02-05 07:45:00 | AAPL | Stock | 43.13 | 43.13 | 43.075 | 43.075 | 17536.0 |
| 2019-02-05 07:50:00 | AAPL | Stock | 43.075 | 43.0875 | 43.075 | 43.0875 | 8060.0 |
| 2019-02-05 07:55:00 | AAPL | Stock | 43.065 | 43.0975 | 43.065 | 43.0875 | 14840.0 |
| 2019-02-05 08:00:00 | AAPL | Stock | 43.095 | 43.1325 | 43.0 | 43.11 | 142560.0 |
| 2019-02-05 08:05:00 | AAPL | Stock | 43.11 | 43.2425 | 43.1 | 43.2 | 41520.0 |
| 2019-02-05 08:10:00 | AAPL | Stock | 43.175 | 43.185 | 43.125 | 43.17 | 38872.0 |
| 2019-02-05 08:15:00 | AAPL | Stock | 43.155 | 43.1625 | 43.085 | 43.1475 | 55700.0 |
| 2019-02-05 08:20:00 | AAPL | Stock | 43.15 | 43.15 | 43.1275 | 43.14 | 9400.0 |
| 2019-02-05 08:25:00 | AAPL | Stock | 43.125 | 43.1375 | 43.0625 | 43.0625 | 36520.0 |
| 2019-02-05 08:30:00 | AAPL | Stock | 43.0425 | 43.065 | 43.03 | 43.065 | 24188.0 |
| 2019-02-05 08:35:00 | AAPL | Stock | 43.0725 | 43.125 | 43.0725 | 43.125 | 49812.0 |
| 2019-02-05 08:40:00 | AAPL | Stock | 43.125 | 43.185 | 43.1225 | 43.16 | 54328.0 |
| 2019-02-05 08:45:00 | AAPL | Stock | 43.1325 | 43.16 | 43.1275 | 43.16 | 9400.0 |
| 2019-02-05 08:50:00 | AAPL | Stock | 43.15 | 43.205 | 43.125 | 43.175 | 69664.0 |
| 2019-02-05 08:55:00 | AAPL | Stock | 43.2 | 43.225 | 43.175 | 43.2025 | 57820.0 |
| 2019-02-05 09:00:00 | AAPL | Stock | 43.2 | 43.2225 | 43.175 | 43.1875 | 61944.0 |
| 2019-02-05 09:05:00 | AAPL | Stock | 43.1875 | 43.215 | 43.155 | 43.2125 | 24328.0 |
| 2019-02-05 09:10:00 | AAPL | Stock | 43.1875 | 43.225 | 43.1875 | 43.2 | 67964.0 |
> showing 50 of 353,008 rows — these rows as CSV