PREVIEW / stock_1min / 2010-03-22
file: by_date/stock_1min/2010/2010-03-22.parquet size: 13.1 MB rows: 988,128 symbols: 2,836
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 |
|---|---|---|---|---|---|---|---|
| 2010-03-22 04:15:00 | AAPL | Stock | 7.9 | 7.9 | 7.9 | 7.9 | 5600.0 |
| 2010-03-22 04:36:00 | AAPL | Stock | 7.8961 | 7.8961 | 7.8961 | 7.8961 | 7000.0 |
| 2010-03-22 05:42:00 | AAPL | Stock | 7.8982 | 7.9064 | 7.8982 | 7.9064 | 26600.0 |
| 2010-03-22 06:15:00 | AAPL | Stock | 7.8982 | 7.8982 | 7.8982 | 7.8982 | 2800.0 |
| 2010-03-22 06:24:00 | AAPL | Stock | 7.9036 | 7.9036 | 7.9036 | 7.9036 | 9912.0 |
| 2010-03-22 06:55:00 | AAPL | Stock | 7.9107 | 7.9107 | 7.9107 | 7.9107 | 2828.0 |
| 2010-03-22 07:03:00 | AAPL | Stock | 7.8982 | 7.8982 | 7.8982 | 7.8982 | 2800.0 |
| 2010-03-22 07:05:00 | AAPL | Stock | 7.9036 | 7.9036 | 7.9036 | 7.9036 | 3640.0 |
| 2010-03-22 07:11:00 | AAPL | Stock | 7.9036 | 7.9036 | 7.9036 | 7.9036 | 2800.0 |
| 2010-03-22 07:14:00 | AAPL | Stock | 7.9089 | 7.9089 | 7.9089 | 7.9089 | 2800.0 |
| 2010-03-22 07:16:00 | AAPL | Stock | 7.9089 | 7.9089 | 7.9089 | 7.9089 | 2800.0 |
| 2010-03-22 07:23:00 | AAPL | Stock | 7.9064 | 7.9064 | 7.9064 | 7.9064 | 2800.0 |
| 2010-03-22 07:25:00 | AAPL | Stock | 7.9089 | 7.9089 | 7.9089 | 7.9089 | 7000.0 |
| 2010-03-22 07:32:00 | AAPL | Stock | 7.9064 | 7.9064 | 7.8929 | 7.8982 | 30240.0 |
| 2010-03-22 07:36:00 | AAPL | Stock | 7.8968 | 7.8968 | 7.8968 | 7.8968 | 8400.0 |
| 2010-03-22 07:37:00 | AAPL | Stock | 7.8971 | 7.8971 | 7.8971 | 7.8971 | 2800.0 |
| 2010-03-22 07:49:00 | AAPL | Stock | 7.8964 | 7.8964 | 7.8964 | 7.8964 | 11200.0 |
| 2010-03-22 07:52:00 | AAPL | Stock | 7.8893 | 7.8893 | 7.8861 | 7.8861 | 30940.0 |
| 2010-03-22 07:53:00 | AAPL | Stock | 7.8861 | 7.8861 | 7.8861 | 7.8861 | 2800.0 |
| 2010-03-22 07:56:00 | AAPL | Stock | 7.8839 | 7.8839 | 7.8839 | 7.8839 | 11900.0 |
| 2010-03-22 07:57:00 | AAPL | Stock | 7.8836 | 7.8836 | 7.8836 | 7.8836 | 2800.0 |
| 2010-03-22 07:58:00 | AAPL | Stock | 7.8882 | 7.8907 | 7.8882 | 7.8907 | 5600.0 |
| 2010-03-22 07:59:00 | AAPL | Stock | 7.8907 | 7.8911 | 7.8775 | 7.8832 | 32592.0 |
| 2010-03-22 08:00:00 | AAPL | Stock | 7.8775 | 7.8929 | 7.875 | 7.8821 | 73836.0 |
| 2010-03-22 08:01:00 | AAPL | Stock | 7.8839 | 7.8839 | 7.8839 | 7.8839 | 2800.0 |
| 2010-03-22 08:03:00 | AAPL | Stock | 7.8839 | 7.8871 | 7.8804 | 7.8804 | 74088.0 |
| 2010-03-22 08:04:00 | AAPL | Stock | 7.8811 | 7.8818 | 7.8754 | 7.8754 | 16800.0 |
| 2010-03-22 08:05:00 | AAPL | Stock | 7.8764 | 7.8764 | 7.875 | 7.875 | 28000.0 |
| 2010-03-22 08:06:00 | AAPL | Stock | 7.8768 | 7.8768 | 7.8732 | 7.8732 | 35700.0 |
| 2010-03-22 08:07:00 | AAPL | Stock | 7.8729 | 7.875 | 7.8729 | 7.875 | 16968.0 |
| 2010-03-22 08:08:00 | AAPL | Stock | 7.8754 | 7.8754 | 7.8729 | 7.8729 | 26236.0 |
| 2010-03-22 08:09:00 | AAPL | Stock | 7.8729 | 7.8729 | 7.8679 | 7.8679 | 70700.0 |
| 2010-03-22 08:10:00 | AAPL | Stock | 7.8682 | 7.8682 | 7.8643 | 7.8679 | 98112.0 |
| 2010-03-22 08:11:00 | AAPL | Stock | 7.8643 | 7.8714 | 7.8643 | 7.8679 | 177072.0 |
| 2010-03-22 08:12:00 | AAPL | Stock | 7.8707 | 7.8743 | 7.8707 | 7.8714 | 19600.0 |
| 2010-03-22 08:13:00 | AAPL | Stock | 7.8739 | 7.8739 | 7.8643 | 7.8643 | 66612.0 |
| 2010-03-22 08:14:00 | AAPL | Stock | 7.8643 | 7.8696 | 7.8643 | 7.8696 | 56000.0 |
| 2010-03-22 08:15:00 | AAPL | Stock | 7.8718 | 7.8718 | 7.8718 | 7.8718 | 7000.0 |
| 2010-03-22 08:16:00 | AAPL | Stock | 7.8714 | 7.8761 | 7.8714 | 7.8761 | 25200.0 |
| 2010-03-22 08:17:00 | AAPL | Stock | 7.875 | 7.8761 | 7.875 | 7.8761 | 19600.0 |
| 2010-03-22 08:18:00 | AAPL | Stock | 7.8782 | 7.8782 | 7.8782 | 7.8782 | 2800.0 |
| 2010-03-22 08:19:00 | AAPL | Stock | 7.8761 | 7.8779 | 7.875 | 7.8768 | 142856.0 |
| 2010-03-22 08:20:00 | AAPL | Stock | 7.8779 | 7.8786 | 7.8779 | 7.8786 | 35840.0 |
| 2010-03-22 08:21:00 | AAPL | Stock | 7.8764 | 7.8768 | 7.875 | 7.875 | 39004.0 |
| 2010-03-22 08:22:00 | AAPL | Stock | 7.8746 | 7.8746 | 7.8746 | 7.8746 | 2800.0 |
| 2010-03-22 08:23:00 | AAPL | Stock | 7.8754 | 7.8754 | 7.8736 | 7.8736 | 5600.0 |
| 2010-03-22 08:24:00 | AAPL | Stock | 7.875 | 7.875 | 7.875 | 7.875 | 19600.0 |
| 2010-03-22 08:25:00 | AAPL | Stock | 7.8732 | 7.8804 | 7.8732 | 7.8739 | 40964.0 |
| 2010-03-22 08:26:00 | AAPL | Stock | 7.8739 | 7.8739 | 7.8725 | 7.8725 | 51800.0 |
| 2010-03-22 08:27:00 | AAPL | Stock | 7.8714 | 7.8725 | 7.8711 | 7.8721 | 38360.0 |
> showing 50 of 988,128 rows — these rows as CSV