PREVIEW / stock_5min / 2018-05-09
file: by_date/stock_5min/2018/2018-05-09.parquet size: 5.7 MB rows: 363,371 symbols: 2,868
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 |
|---|---|---|---|---|---|---|---|
| 2018-05-09 04:45:00 | AAPL | Stock | 46.59 | 46.6 | 46.59 | 46.6 | 7600.0 |
| 2018-05-09 04:55:00 | AAPL | Stock | 46.6125 | 46.6125 | 46.6125 | 46.6125 | 2800.0 |
| 2018-05-09 05:00:00 | AAPL | Stock | 46.61 | 46.6725 | 46.61 | 46.6725 | 16196.0 |
| 2018-05-09 05:05:00 | AAPL | Stock | 46.66 | 46.66 | 46.65 | 46.65 | 3240.0 |
| 2018-05-09 05:10:00 | AAPL | Stock | 46.6475 | 46.6475 | 46.625 | 46.625 | 5668.0 |
| 2018-05-09 05:25:00 | AAPL | Stock | 46.65 | 46.65 | 46.65 | 46.65 | 2000.0 |
| 2018-05-09 05:30:00 | AAPL | Stock | 46.635 | 46.635 | 46.635 | 46.635 | 400.0 |
| 2018-05-09 05:50:00 | AAPL | Stock | 46.6475 | 46.6475 | 46.635 | 46.635 | 824.0 |
| 2018-05-09 06:05:00 | AAPL | Stock | 46.6 | 46.6 | 46.6 | 46.6 | 840.0 |
| 2018-05-09 06:25:00 | AAPL | Stock | 46.575 | 46.575 | 46.575 | 46.575 | 1692.0 |
| 2018-05-09 06:50:00 | AAPL | Stock | 46.5775 | 46.5775 | 46.5775 | 46.5775 | 400.0 |
| 2018-05-09 06:55:00 | AAPL | Stock | 46.5875 | 46.5875 | 46.5875 | 46.5875 | 400.0 |
| 2018-05-09 07:00:00 | AAPL | Stock | 46.5975 | 46.625 | 46.5925 | 46.615 | 33072.0 |
| 2018-05-09 07:05:00 | AAPL | Stock | 46.6375 | 46.65 | 46.6375 | 46.65 | 19076.0 |
| 2018-05-09 07:10:00 | AAPL | Stock | 46.6525 | 46.6825 | 46.65 | 46.6825 | 7252.0 |
| 2018-05-09 07:15:00 | AAPL | Stock | 46.675 | 46.6775 | 46.65 | 46.6625 | 12988.0 |
| 2018-05-09 07:20:00 | AAPL | Stock | 46.6375 | 46.65 | 46.6375 | 46.65 | 800.0 |
| 2018-05-09 07:25:00 | AAPL | Stock | 46.6375 | 46.6375 | 46.635 | 46.6375 | 7344.0 |
| 2018-05-09 07:30:00 | AAPL | Stock | 46.625 | 46.6475 | 46.625 | 46.6475 | 6260.0 |
| 2018-05-09 07:35:00 | AAPL | Stock | 46.655 | 46.675 | 46.65 | 46.665 | 19804.0 |
| 2018-05-09 07:40:00 | AAPL | Stock | 46.6625 | 46.68 | 46.6625 | 46.675 | 33688.0 |
| 2018-05-09 07:45:00 | AAPL | Stock | 46.6725 | 46.695 | 46.6675 | 46.675 | 50836.0 |
| 2018-05-09 07:50:00 | AAPL | Stock | 46.6875 | 46.6875 | 46.675 | 46.6775 | 6340.0 |
| 2018-05-09 07:55:00 | AAPL | Stock | 46.685 | 46.685 | 46.6375 | 46.6375 | 26496.0 |
| 2018-05-09 08:00:00 | AAPL | Stock | 46.6338 | 46.685 | 46.61 | 46.6625 | 114348.0 |
| 2018-05-09 08:05:00 | AAPL | Stock | 46.6625 | 46.675 | 46.6575 | 46.665 | 8568.0 |
| 2018-05-09 08:10:00 | AAPL | Stock | 46.675 | 46.6875 | 46.6675 | 46.6875 | 14040.0 |
| 2018-05-09 08:15:00 | AAPL | Stock | 46.675 | 46.6775 | 46.6475 | 46.6475 | 21404.0 |
| 2018-05-09 08:20:00 | AAPL | Stock | 46.65 | 46.6625 | 46.6375 | 46.6475 | 14292.0 |
| 2018-05-09 08:25:00 | AAPL | Stock | 46.645 | 46.6575 | 46.645 | 46.6525 | 11336.0 |
| 2018-05-09 08:30:00 | AAPL | Stock | 46.665 | 46.6675 | 46.6625 | 46.6625 | 6412.0 |
| 2018-05-09 08:35:00 | AAPL | Stock | 46.655 | 46.655 | 46.6175 | 46.6475 | 22884.0 |
| 2018-05-09 08:40:00 | AAPL | Stock | 46.6375 | 46.655 | 46.6325 | 46.6325 | 31420.0 |
| 2018-05-09 08:45:00 | AAPL | Stock | 46.6325 | 46.6425 | 46.625 | 46.64 | 13988.0 |
| 2018-05-09 08:50:00 | AAPL | Stock | 46.6375 | 46.6525 | 46.6375 | 46.6525 | 22408.0 |
| 2018-05-09 08:55:00 | AAPL | Stock | 46.655 | 46.655 | 46.6175 | 46.6175 | 21192.0 |
| 2018-05-09 09:00:00 | AAPL | Stock | 46.615 | 46.6275 | 46.6125 | 46.6275 | 20780.0 |
| 2018-05-09 09:05:00 | AAPL | Stock | 46.625 | 46.6375 | 46.5875 | 46.5875 | 54804.0 |
| 2018-05-09 09:10:00 | AAPL | Stock | 46.61 | 46.6125 | 46.5925 | 46.6125 | 10908.0 |
| 2018-05-09 09:15:00 | AAPL | Stock | 46.6125 | 46.625 | 46.6125 | 46.625 | 4480.0 |
| 2018-05-09 09:20:00 | AAPL | Stock | 46.625 | 46.6425 | 46.625 | 46.6425 | 16228.0 |
| 2018-05-09 09:25:00 | AAPL | Stock | 46.63 | 46.645 | 46.6075 | 46.645 | 14964.0 |
| 2018-05-09 09:30:00 | AAPL | Stock | 46.645 | 46.675 | 46.525 | 46.5625 | 3414220.0 |
| 2018-05-09 09:35:00 | AAPL | Stock | 46.565 | 46.585 | 46.4175 | 46.455 | 2540756.0 |
| 2018-05-09 09:40:00 | AAPL | Stock | 46.455 | 46.53 | 46.4525 | 46.51 | 1416688.0 |
| 2018-05-09 09:45:00 | AAPL | Stock | 46.51 | 46.575 | 46.4878 | 46.5425 | 1692468.0 |
| 2018-05-09 09:50:00 | AAPL | Stock | 46.55 | 46.5675 | 46.4275 | 46.49 | 1646664.0 |
| 2018-05-09 09:55:00 | AAPL | Stock | 46.4925 | 46.5007 | 46.415 | 46.4275 | 1527472.0 |
| 2018-05-09 10:00:00 | AAPL | Stock | 46.4288 | 46.5 | 46.3875 | 46.4765 | 1356628.0 |
| 2018-05-09 10:05:00 | AAPL | Stock | 46.48 | 46.5325 | 46.45 | 46.5275 | 1513612.0 |
> showing 50 of 363,371 rows — these rows as CSV