PREVIEW / stock_1min / 2011-06-13
file: by_date/stock_1min/2011/2011-06-13.parquet size: 14.0 MB rows: 1,062,008 symbols: 2,895
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 |
|---|---|---|---|---|---|---|---|
| 2011-06-13 05:20:00 | AAPL | Stock | 11.6393 | 11.6393 | 11.6393 | 11.6393 | 2800.0 |
| 2011-06-13 05:46:00 | AAPL | Stock | 11.6389 | 11.6389 | 11.6389 | 11.6389 | 2800.0 |
| 2011-06-13 06:24:00 | AAPL | Stock | 11.6696 | 11.6696 | 11.6696 | 11.6696 | 4200.0 |
| 2011-06-13 06:51:00 | AAPL | Stock | 11.6782 | 11.6782 | 11.6782 | 11.6782 | 2800.0 |
| 2011-06-13 06:52:00 | AAPL | Stock | 11.6782 | 11.6782 | 11.6782 | 11.6782 | 22960.0 |
| 2011-06-13 07:00:00 | AAPL | Stock | 11.6696 | 11.6696 | 11.6696 | 11.6696 | 2800.0 |
| 2011-06-13 07:01:00 | AAPL | Stock | 11.6893 | 11.6893 | 11.6893 | 11.6893 | 2800.0 |
| 2011-06-13 07:03:00 | AAPL | Stock | 11.6886 | 11.6893 | 11.6796 | 11.6796 | 33600.0 |
| 2011-06-13 07:04:00 | AAPL | Stock | 11.6929 | 11.6929 | 11.6929 | 11.6929 | 2800.0 |
| 2011-06-13 07:11:00 | AAPL | Stock | 11.6875 | 11.6886 | 11.6875 | 11.6886 | 14000.0 |
| 2011-06-13 07:12:00 | AAPL | Stock | 11.6875 | 11.6889 | 11.6875 | 11.6889 | 8400.0 |
| 2011-06-13 07:14:00 | AAPL | Stock | 11.6768 | 11.6768 | 11.6768 | 11.6768 | 28000.0 |
| 2011-06-13 07:23:00 | AAPL | Stock | 11.6871 | 11.6871 | 11.6871 | 11.6871 | 2800.0 |
| 2011-06-13 07:28:00 | AAPL | Stock | 11.6871 | 11.6871 | 11.6871 | 11.6871 | 5600.0 |
| 2011-06-13 07:29:00 | AAPL | Stock | 11.6875 | 11.6893 | 11.6875 | 11.6893 | 31080.0 |
| 2011-06-13 07:35:00 | AAPL | Stock | 11.6946 | 11.6946 | 11.6946 | 11.6946 | 2800.0 |
| 2011-06-13 07:37:00 | AAPL | Stock | 11.6904 | 11.6904 | 11.6904 | 11.6904 | 2800.0 |
| 2011-06-13 07:40:00 | AAPL | Stock | 11.6875 | 11.69 | 11.6821 | 11.69 | 11200.0 |
| 2011-06-13 07:41:00 | AAPL | Stock | 11.6839 | 11.6839 | 11.6839 | 11.6839 | 7560.0 |
| 2011-06-13 07:43:00 | AAPL | Stock | 11.6839 | 11.6839 | 11.6786 | 11.6836 | 86324.0 |
| 2011-06-13 07:52:00 | AAPL | Stock | 11.6793 | 11.6793 | 11.6793 | 11.6793 | 9436.0 |
| 2011-06-13 07:53:00 | AAPL | Stock | 11.6786 | 11.6854 | 11.6786 | 11.6854 | 28000.0 |
| 2011-06-13 07:55:00 | AAPL | Stock | 11.6854 | 11.6889 | 11.6854 | 11.6889 | 39200.0 |
| 2011-06-13 08:00:00 | AAPL | Stock | 11.68 | 11.6875 | 11.6796 | 11.6871 | 91952.0 |
| 2011-06-13 08:01:00 | AAPL | Stock | 11.6871 | 11.6907 | 11.6871 | 11.6875 | 80640.0 |
| 2011-06-13 08:02:00 | AAPL | Stock | 11.6875 | 11.6893 | 11.6875 | 11.6893 | 38220.0 |
| 2011-06-13 08:04:00 | AAPL | Stock | 11.6882 | 11.6882 | 11.6786 | 11.6786 | 30324.0 |
| 2011-06-13 08:05:00 | AAPL | Stock | 11.6793 | 11.6854 | 11.6786 | 11.6786 | 32592.0 |
| 2011-06-13 08:07:00 | AAPL | Stock | 11.6868 | 11.6875 | 11.6868 | 11.6875 | 11760.0 |
| 2011-06-13 08:08:00 | AAPL | Stock | 11.6796 | 11.6796 | 11.6796 | 11.6796 | 5600.0 |
| 2011-06-13 08:09:00 | AAPL | Stock | 11.6807 | 11.6807 | 11.6804 | 11.6804 | 11200.0 |
| 2011-06-13 08:10:00 | AAPL | Stock | 11.6807 | 11.6807 | 11.6807 | 11.6807 | 7840.0 |
| 2011-06-13 08:12:00 | AAPL | Stock | 11.6804 | 11.6804 | 11.6804 | 11.6804 | 22904.0 |
| 2011-06-13 08:15:00 | AAPL | Stock | 11.6821 | 11.6821 | 11.6786 | 11.6786 | 27944.0 |
| 2011-06-13 08:16:00 | AAPL | Stock | 11.6786 | 11.6836 | 11.6786 | 11.6836 | 8596.0 |
| 2011-06-13 08:18:00 | AAPL | Stock | 11.6829 | 11.6829 | 11.6829 | 11.6829 | 11200.0 |
| 2011-06-13 08:19:00 | AAPL | Stock | 11.6836 | 11.6875 | 11.6836 | 11.6875 | 63000.0 |
| 2011-06-13 08:20:00 | AAPL | Stock | 11.6875 | 11.6911 | 11.6875 | 11.6911 | 36260.0 |
| 2011-06-13 08:21:00 | AAPL | Stock | 11.6946 | 11.6946 | 11.6893 | 11.6893 | 34020.0 |
| 2011-06-13 08:23:00 | AAPL | Stock | 11.6893 | 11.6943 | 11.6893 | 11.6943 | 24500.0 |
| 2011-06-13 08:24:00 | AAPL | Stock | 11.6896 | 11.6896 | 11.6896 | 11.6896 | 2800.0 |
| 2011-06-13 08:26:00 | AAPL | Stock | 11.6929 | 11.6946 | 11.6929 | 11.6946 | 11760.0 |
| 2011-06-13 08:27:00 | AAPL | Stock | 11.6946 | 11.6989 | 11.6946 | 11.6989 | 36400.0 |
| 2011-06-13 08:28:00 | AAPL | Stock | 11.6989 | 11.6989 | 11.6989 | 11.6989 | 5600.0 |
| 2011-06-13 08:29:00 | AAPL | Stock | 11.7 | 11.7011 | 11.6982 | 11.7007 | 31920.0 |
| 2011-06-13 08:30:00 | AAPL | Stock | 11.6989 | 11.6989 | 11.6968 | 11.6968 | 13440.0 |
| 2011-06-13 08:31:00 | AAPL | Stock | 11.6982 | 11.7011 | 11.6982 | 11.7011 | 22400.0 |
| 2011-06-13 08:32:00 | AAPL | Stock | 11.7 | 11.7 | 11.7 | 11.7 | 2800.0 |
| 2011-06-13 08:33:00 | AAPL | Stock | 11.6968 | 11.6968 | 11.6964 | 11.6964 | 14000.0 |
| 2011-06-13 08:34:00 | AAPL | Stock | 11.6975 | 11.6982 | 11.6975 | 11.6982 | 8624.0 |
> showing 50 of 1,062,008 rows — these rows as CSV