PREVIEW / stock_5min / 2019-05-15
file: by_date/stock_5min/2019/2019-05-15.parquet size: 5.6 MB rows: 356,803 symbols: 2,626
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-05-15 04:00:00 | AAPL | Stock | 47.175 | 47.2575 | 47.17 | 47.225 | 10008.0 |
| 2019-05-15 04:05:00 | AAPL | Stock | 47.1625 | 47.1625 | 47.065 | 47.1325 | 1600.0 |
| 2019-05-15 04:10:00 | AAPL | Stock | 47.16 | 47.16 | 47.16 | 47.16 | 4032.0 |
| 2019-05-15 04:20:00 | AAPL | Stock | 47.145 | 47.145 | 47.145 | 47.145 | 2544.0 |
| 2019-05-15 04:25:00 | AAPL | Stock | 47.16 | 47.1775 | 47.16 | 47.16 | 6844.0 |
| 2019-05-15 04:45:00 | AAPL | Stock | 47.2125 | 47.22 | 47.2125 | 47.2125 | 7496.0 |
| 2019-05-15 04:50:00 | AAPL | Stock | 47.2225 | 47.2225 | 47.2225 | 47.2225 | 400.0 |
| 2019-05-15 04:55:00 | AAPL | Stock | 47.2125 | 47.2125 | 47.2125 | 47.2125 | 1592.0 |
| 2019-05-15 05:10:00 | AAPL | Stock | 47.2225 | 47.2225 | 47.2225 | 47.2225 | 516.0 |
| 2019-05-15 05:15:00 | AAPL | Stock | 47.3175 | 47.3175 | 47.3175 | 47.3175 | 2344.0 |
| 2019-05-15 05:25:00 | AAPL | Stock | 47.375 | 47.375 | 47.3675 | 47.3675 | 800.0 |
| 2019-05-15 05:30:00 | AAPL | Stock | 47.35 | 47.35 | 47.3275 | 47.3275 | 800.0 |
| 2019-05-15 05:35:00 | AAPL | Stock | 47.29 | 47.29 | 47.225 | 47.225 | 1200.0 |
| 2019-05-15 05:40:00 | AAPL | Stock | 47.22 | 47.22 | 47.1675 | 47.1675 | 1888.0 |
| 2019-05-15 05:45:00 | AAPL | Stock | 47.1625 | 47.1625 | 47.1625 | 47.1625 | 900.0 |
| 2019-05-15 05:50:00 | AAPL | Stock | 47.125 | 47.1625 | 47.125 | 47.1625 | 4184.0 |
| 2019-05-15 05:55:00 | AAPL | Stock | 47.1375 | 47.1425 | 47.125 | 47.125 | 17052.0 |
| 2019-05-15 06:00:00 | AAPL | Stock | 47.1 | 47.1175 | 47.0975 | 47.1175 | 4968.0 |
| 2019-05-15 06:05:00 | AAPL | Stock | 47.1525 | 47.1525 | 47.1525 | 47.1525 | 400.0 |
| 2019-05-15 06:10:00 | AAPL | Stock | 47.1275 | 47.15 | 47.12 | 47.15 | 3828.0 |
| 2019-05-15 06:15:00 | AAPL | Stock | 47.105 | 47.105 | 47.075 | 47.075 | 2472.0 |
| 2019-05-15 06:20:00 | AAPL | Stock | 47.1475 | 47.1475 | 47.075 | 47.075 | 1564.0 |
| 2019-05-15 06:25:00 | AAPL | Stock | 47.0575 | 47.0575 | 47.04 | 47.04 | 872.0 |
| 2019-05-15 06:35:00 | AAPL | Stock | 47.0375 | 47.0375 | 46.97 | 46.97 | 13484.0 |
| 2019-05-15 06:40:00 | AAPL | Stock | 46.97 | 47.0 | 46.97 | 47.0 | 3840.0 |
| 2019-05-15 06:45:00 | AAPL | Stock | 47.015 | 47.015 | 47.015 | 47.015 | 400.0 |
| 2019-05-15 06:50:00 | AAPL | Stock | 46.9575 | 46.9575 | 46.9575 | 46.9575 | 584.0 |
| 2019-05-15 06:55:00 | AAPL | Stock | 46.9925 | 46.9925 | 46.9925 | 46.9925 | 592.0 |
| 2019-05-15 07:00:00 | AAPL | Stock | 47.025 | 47.125 | 47.0 | 47.125 | 20492.0 |
| 2019-05-15 07:05:00 | AAPL | Stock | 47.125 | 47.125 | 47.0975 | 47.1 | 12976.0 |
| 2019-05-15 07:10:00 | AAPL | Stock | 47.15 | 47.185 | 47.15 | 47.185 | 10708.0 |
| 2019-05-15 07:15:00 | AAPL | Stock | 47.15 | 47.15 | 47.1 | 47.1 | 1408.0 |
| 2019-05-15 07:20:00 | AAPL | Stock | 47.1425 | 47.15 | 47.1425 | 47.15 | 2576.0 |
| 2019-05-15 07:25:00 | AAPL | Stock | 47.15 | 47.1725 | 47.1375 | 47.1375 | 4920.0 |
| 2019-05-15 07:30:00 | AAPL | Stock | 47.0875 | 47.11 | 47.0475 | 47.1 | 4800.0 |
| 2019-05-15 07:35:00 | AAPL | Stock | 47.0975 | 47.1 | 47.0975 | 47.1 | 3772.0 |
| 2019-05-15 07:40:00 | AAPL | Stock | 47.0825 | 47.0825 | 47.05 | 47.05 | 22468.0 |
| 2019-05-15 07:45:00 | AAPL | Stock | 47.0725 | 47.075 | 46.98 | 47.0 | 16256.0 |
| 2019-05-15 07:50:00 | AAPL | Stock | 46.99 | 47.0125 | 46.975 | 46.975 | 27816.0 |
| 2019-05-15 07:55:00 | AAPL | Stock | 46.965 | 46.965 | 46.93 | 46.95 | 23484.0 |
| 2019-05-15 08:00:00 | AAPL | Stock | 47.05 | 47.2825 | 46.905 | 46.95 | 96876.0 |
| 2019-05-15 08:05:00 | AAPL | Stock | 46.95 | 47.02 | 46.9 | 46.9 | 10188.0 |
| 2019-05-15 08:10:00 | AAPL | Stock | 46.9 | 46.9375 | 46.8825 | 46.9 | 28020.0 |
| 2019-05-15 08:15:00 | AAPL | Stock | 46.9075 | 47.165 | 46.8375 | 46.87 | 220016.0 |
| 2019-05-15 08:20:00 | AAPL | Stock | 46.8375 | 46.865 | 46.8375 | 46.845 | 21300.0 |
| 2019-05-15 08:25:00 | AAPL | Stock | 46.86 | 46.8975 | 46.8425 | 46.8525 | 44680.0 |
| 2019-05-15 08:30:00 | AAPL | Stock | 46.8325 | 46.8325 | 46.78 | 46.785 | 37748.0 |
| 2019-05-15 08:35:00 | AAPL | Stock | 46.8 | 46.845 | 46.785 | 46.785 | 45056.0 |
| 2019-05-15 08:40:00 | AAPL | Stock | 46.7825 | 46.8 | 46.725 | 46.725 | 66604.0 |
| 2019-05-15 08:45:00 | AAPL | Stock | 46.75 | 46.7625 | 46.7248 | 46.75 | 48692.0 |
> showing 50 of 356,803 rows — these rows as CSV