PREVIEW / stock_1min / 2009-11-03
file: by_date/stock_1min/2009/2009-11-03.parquet size: 13.2 MB rows: 1,004,128 symbols: 2,777
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 |
|---|---|---|---|---|---|---|---|
| 2009-11-03 05:11:00 | AAPL | Stock | 6.715 | 6.715 | 6.715 | 6.715 | 5600.0 |
| 2009-11-03 06:09:00 | AAPL | Stock | 6.6661 | 6.6661 | 6.6661 | 6.6661 | 5600.0 |
| 2009-11-03 06:14:00 | AAPL | Stock | 6.6654 | 6.6654 | 6.6654 | 6.6654 | 5600.0 |
| 2009-11-03 06:15:00 | AAPL | Stock | 6.6611 | 6.6611 | 6.6611 | 6.6611 | 2800.0 |
| 2009-11-03 06:19:00 | AAPL | Stock | 6.6632 | 6.6632 | 6.6607 | 6.6607 | 5600.0 |
| 2009-11-03 06:23:00 | AAPL | Stock | 6.6704 | 6.6804 | 6.6704 | 6.6804 | 28000.0 |
| 2009-11-03 06:24:00 | AAPL | Stock | 6.6804 | 6.6804 | 6.6804 | 6.6804 | 11200.0 |
| 2009-11-03 06:34:00 | AAPL | Stock | 6.6786 | 6.6786 | 6.6786 | 6.6786 | 2800.0 |
| 2009-11-03 06:38:00 | AAPL | Stock | 6.6836 | 6.6836 | 6.6836 | 6.6836 | 5600.0 |
| 2009-11-03 06:39:00 | AAPL | Stock | 6.6839 | 6.6839 | 6.6839 | 6.6839 | 2800.0 |
| 2009-11-03 07:01:00 | AAPL | Stock | 6.6786 | 6.6786 | 6.6786 | 6.6786 | 2800.0 |
| 2009-11-03 07:05:00 | AAPL | Stock | 6.6839 | 6.6839 | 6.6839 | 6.6839 | 13440.0 |
| 2009-11-03 07:07:00 | AAPL | Stock | 6.6839 | 6.6839 | 6.6839 | 6.6839 | 8932.0 |
| 2009-11-03 07:13:00 | AAPL | Stock | 6.6921 | 6.6921 | 6.6921 | 6.6921 | 11200.0 |
| 2009-11-03 07:14:00 | AAPL | Stock | 6.6964 | 6.6964 | 6.6964 | 6.6964 | 2800.0 |
| 2009-11-03 07:15:00 | AAPL | Stock | 6.7104 | 6.7104 | 6.7104 | 6.7104 | 2800.0 |
| 2009-11-03 07:19:00 | AAPL | Stock | 6.705 | 6.705 | 6.705 | 6.705 | 3164.0 |
| 2009-11-03 07:32:00 | AAPL | Stock | 6.7068 | 6.7068 | 6.7068 | 6.7068 | 2800.0 |
| 2009-11-03 07:34:00 | AAPL | Stock | 6.6964 | 6.6964 | 6.6829 | 6.6829 | 22092.0 |
| 2009-11-03 07:35:00 | AAPL | Stock | 6.6825 | 6.6825 | 6.6825 | 6.6825 | 11200.0 |
| 2009-11-03 07:39:00 | AAPL | Stock | 6.6946 | 6.6946 | 6.6946 | 6.6946 | 6720.0 |
| 2009-11-03 07:47:00 | AAPL | Stock | 6.7029 | 6.7029 | 6.7029 | 6.7029 | 14000.0 |
| 2009-11-03 07:50:00 | AAPL | Stock | 6.7 | 6.7 | 6.7 | 6.7 | 11200.0 |
| 2009-11-03 07:55:00 | AAPL | Stock | 6.6946 | 6.6946 | 6.6939 | 6.6939 | 11200.0 |
| 2009-11-03 07:58:00 | AAPL | Stock | 6.6904 | 6.6904 | 6.6904 | 6.6904 | 2800.0 |
| 2009-11-03 08:00:00 | AAPL | Stock | 6.7 | 6.7018 | 6.6896 | 6.6964 | 121464.0 |
| 2009-11-03 08:01:00 | AAPL | Stock | 6.6964 | 6.7018 | 6.6964 | 6.7018 | 63560.0 |
| 2009-11-03 08:02:00 | AAPL | Stock | 6.7018 | 6.7046 | 6.7 | 6.7046 | 46396.0 |
| 2009-11-03 08:03:00 | AAPL | Stock | 6.7046 | 6.7104 | 6.7046 | 6.7104 | 39760.0 |
| 2009-11-03 08:04:00 | AAPL | Stock | 6.7071 | 6.7071 | 6.7071 | 6.7071 | 11200.0 |
| 2009-11-03 08:05:00 | AAPL | Stock | 6.7071 | 6.7104 | 6.7071 | 6.7104 | 8400.0 |
| 2009-11-03 08:06:00 | AAPL | Stock | 6.7121 | 6.7193 | 6.7121 | 6.7125 | 90048.0 |
| 2009-11-03 08:07:00 | AAPL | Stock | 6.7121 | 6.7143 | 6.7086 | 6.7143 | 47600.0 |
| 2009-11-03 08:08:00 | AAPL | Stock | 6.7107 | 6.7107 | 6.7107 | 6.7107 | 2800.0 |
| 2009-11-03 08:10:00 | AAPL | Stock | 6.7136 | 6.7136 | 6.7132 | 6.7132 | 16800.0 |
| 2009-11-03 08:11:00 | AAPL | Stock | 6.7107 | 6.7107 | 6.7089 | 6.7089 | 14000.0 |
| 2009-11-03 08:12:00 | AAPL | Stock | 6.7071 | 6.7071 | 6.7025 | 6.7025 | 28364.0 |
| 2009-11-03 08:13:00 | AAPL | Stock | 6.7025 | 6.7029 | 6.7 | 6.7 | 36400.0 |
| 2009-11-03 08:14:00 | AAPL | Stock | 6.7 | 6.7 | 6.7 | 6.7 | 2800.0 |
| 2009-11-03 08:15:00 | AAPL | Stock | 6.7029 | 6.7029 | 6.7029 | 6.7029 | 4900.0 |
| 2009-11-03 08:16:00 | AAPL | Stock | 6.7025 | 6.7025 | 6.7 | 6.7 | 6104.0 |
| 2009-11-03 08:17:00 | AAPL | Stock | 6.7025 | 6.7025 | 6.7025 | 6.7025 | 11200.0 |
| 2009-11-03 08:18:00 | AAPL | Stock | 6.7004 | 6.7071 | 6.7004 | 6.7071 | 5600.0 |
| 2009-11-03 08:22:00 | AAPL | Stock | 6.7121 | 6.7121 | 6.7121 | 6.7121 | 2800.0 |
| 2009-11-03 08:23:00 | AAPL | Stock | 6.7114 | 6.7136 | 6.7114 | 6.7136 | 14000.0 |
| 2009-11-03 08:24:00 | AAPL | Stock | 6.7104 | 6.7107 | 6.7104 | 6.7104 | 25200.0 |
| 2009-11-03 08:25:00 | AAPL | Stock | 6.7136 | 6.7139 | 6.7107 | 6.7139 | 70000.0 |
| 2009-11-03 08:26:00 | AAPL | Stock | 6.7139 | 6.7139 | 6.7107 | 6.7125 | 170800.0 |
| 2009-11-03 08:27:00 | AAPL | Stock | 6.7125 | 6.7143 | 6.7107 | 6.7143 | 175812.0 |
| 2009-11-03 08:28:00 | AAPL | Stock | 6.7143 | 6.7143 | 6.7125 | 6.7143 | 117124.0 |
> showing 50 of 1,004,128 rows — these rows as CSV