PREVIEW / stock_5min / 2018-06-26
file: by_date/stock_5min/2018/2018-06-26.parquet size: 5.6 MB rows: 360,759 symbols: 2,823
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-06-26 04:00:00 | AAPL | Stock | 45.825 | 45.825 | 45.825 | 45.825 | 600.0 |
| 2018-06-26 04:35:00 | AAPL | Stock | 45.775 | 45.775 | 45.775 | 45.775 | 3880.0 |
| 2018-06-26 05:05:00 | AAPL | Stock | 45.725 | 45.725 | 45.725 | 45.725 | 400.0 |
| 2018-06-26 05:20:00 | AAPL | Stock | 45.7375 | 45.755 | 45.7375 | 45.755 | 3948.0 |
| 2018-06-26 05:25:00 | AAPL | Stock | 45.755 | 45.755 | 45.755 | 45.755 | 800.0 |
| 2018-06-26 05:45:00 | AAPL | Stock | 45.6975 | 45.6975 | 45.695 | 45.6975 | 18484.0 |
| 2018-06-26 05:55:00 | AAPL | Stock | 45.6975 | 45.6975 | 45.6975 | 45.6975 | 1492.0 |
| 2018-06-26 06:00:00 | AAPL | Stock | 45.755 | 45.755 | 45.755 | 45.755 | 400.0 |
| 2018-06-26 06:05:00 | AAPL | Stock | 45.7025 | 45.7025 | 45.655 | 45.655 | 7260.0 |
| 2018-06-26 06:30:00 | AAPL | Stock | 45.6675 | 45.675 | 45.6675 | 45.675 | 6388.0 |
| 2018-06-26 06:45:00 | AAPL | Stock | 45.7125 | 45.73 | 45.7125 | 45.7125 | 9904.0 |
| 2018-06-26 07:00:00 | AAPL | Stock | 45.6875 | 45.75 | 45.6875 | 45.745 | 12408.0 |
| 2018-06-26 07:05:00 | AAPL | Stock | 45.7475 | 45.7475 | 45.7025 | 45.7375 | 2484.0 |
| 2018-06-26 07:10:00 | AAPL | Stock | 45.7375 | 45.7375 | 45.7 | 45.7 | 11036.0 |
| 2018-06-26 07:25:00 | AAPL | Stock | 45.6875 | 45.6875 | 45.6875 | 45.6875 | 8000.0 |
| 2018-06-26 07:30:00 | AAPL | Stock | 45.665 | 45.675 | 45.65 | 45.6525 | 4168.0 |
| 2018-06-26 07:35:00 | AAPL | Stock | 45.6525 | 45.6575 | 45.6475 | 45.6475 | 10176.0 |
| 2018-06-26 07:40:00 | AAPL | Stock | 45.64 | 45.6525 | 45.635 | 45.635 | 6136.0 |
| 2018-06-26 07:45:00 | AAPL | Stock | 45.64 | 45.665 | 45.64 | 45.65 | 7376.0 |
| 2018-06-26 07:50:00 | AAPL | Stock | 45.65 | 45.65 | 45.65 | 45.65 | 1424.0 |
| 2018-06-26 07:55:00 | AAPL | Stock | 45.65 | 45.6725 | 45.65 | 45.6725 | 2624.0 |
| 2018-06-26 08:00:00 | AAPL | Stock | 45.75 | 45.75 | 45.6375 | 45.7 | 48956.0 |
| 2018-06-26 08:05:00 | AAPL | Stock | 45.6875 | 45.7375 | 45.675 | 45.72 | 47412.0 |
| 2018-06-26 08:10:00 | AAPL | Stock | 45.72 | 45.775 | 45.72 | 45.775 | 11212.0 |
| 2018-06-26 08:15:00 | AAPL | Stock | 45.775 | 45.8125 | 45.775 | 45.8125 | 23656.0 |
| 2018-06-26 08:20:00 | AAPL | Stock | 45.8125 | 45.825 | 45.8 | 45.825 | 15100.0 |
| 2018-06-26 08:25:00 | AAPL | Stock | 45.82 | 45.8375 | 45.805 | 45.8375 | 40328.0 |
| 2018-06-26 08:30:00 | AAPL | Stock | 45.8375 | 45.9 | 45.8375 | 45.8725 | 36056.0 |
| 2018-06-26 08:35:00 | AAPL | Stock | 45.8625 | 45.8625 | 45.8375 | 45.8605 | 8600.0 |
| 2018-06-26 08:40:00 | AAPL | Stock | 45.86 | 45.865 | 45.855 | 45.864 | 3500.0 |
| 2018-06-26 08:45:00 | AAPL | Stock | 45.8575 | 45.88 | 45.825 | 45.8275 | 34424.0 |
| 2018-06-26 08:50:00 | AAPL | Stock | 45.845 | 45.8575 | 45.8 | 45.8 | 14644.0 |
| 2018-06-26 08:55:00 | AAPL | Stock | 45.8 | 45.8225 | 45.79 | 45.805 | 16728.0 |
| 2018-06-26 09:00:00 | AAPL | Stock | 45.8225 | 45.8225 | 45.785 | 45.785 | 19256.0 |
| 2018-06-26 09:05:00 | AAPL | Stock | 45.8 | 45.8025 | 45.7725 | 45.7925 | 24440.0 |
| 2018-06-26 09:10:00 | AAPL | Stock | 45.7775 | 45.805 | 45.775 | 45.805 | 11464.0 |
| 2018-06-26 09:15:00 | AAPL | Stock | 45.8125 | 45.825 | 45.81 | 45.815 | 63212.0 |
| 2018-06-26 09:20:00 | AAPL | Stock | 45.82 | 45.82 | 45.8075 | 45.8075 | 7064.0 |
| 2018-06-26 09:25:00 | AAPL | Stock | 45.8075 | 45.8075 | 45.64 | 45.7225 | 98232.0 |
| 2018-06-26 09:30:00 | AAPL | Stock | 45.7225 | 45.915 | 45.635 | 45.7375 | 3994860.0 |
| 2018-06-26 09:35:00 | AAPL | Stock | 45.7375 | 45.87 | 45.6545 | 45.8325 | 1943272.0 |
| 2018-06-26 09:40:00 | AAPL | Stock | 45.8325 | 46.0125 | 45.8188 | 46.005 | 1927500.0 |
| 2018-06-26 09:45:00 | AAPL | Stock | 46.005 | 46.115 | 45.9525 | 46.1125 | 2026188.0 |
| 2018-06-26 09:50:00 | AAPL | Stock | 46.1125 | 46.14 | 46.05 | 46.09 | 1672404.0 |
| 2018-06-26 09:55:00 | AAPL | Stock | 46.0962 | 46.1125 | 45.985 | 46.095 | 1452600.0 |
| 2018-06-26 10:00:00 | AAPL | Stock | 46.095 | 46.195 | 46.0875 | 46.165 | 1711304.0 |
| 2018-06-26 10:05:00 | AAPL | Stock | 46.16 | 46.1875 | 46.1125 | 46.1775 | 1374940.0 |
| 2018-06-26 10:10:00 | AAPL | Stock | 46.1775 | 46.235 | 46.16 | 46.1812 | 1406364.0 |
| 2018-06-26 10:15:00 | AAPL | Stock | 46.1812 | 46.2575 | 46.1625 | 46.1875 | 1598104.0 |
| 2018-06-26 10:20:00 | AAPL | Stock | 46.185 | 46.1925 | 46.0962 | 46.13 | 1103940.0 |
> showing 50 of 360,759 rows — these rows as CSV