PREVIEW / stock_1min / 2009-12-09
file: by_date/stock_1min/2009/2009-12-09.parquet size: 12.1 MB rows: 917,313 symbols: 2,766
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-12-09 04:37:00 | AAPL | Stock | 6.7707 | 6.7707 | 6.7707 | 6.7707 | 2800.0 |
| 2009-12-09 05:00:00 | AAPL | Stock | 6.7654 | 6.7654 | 6.7654 | 6.7654 | 7000.0 |
| 2009-12-09 05:03:00 | AAPL | Stock | 6.7632 | 6.7632 | 6.7632 | 6.7632 | 5600.0 |
| 2009-12-09 05:16:00 | AAPL | Stock | 6.7689 | 6.7689 | 6.7689 | 6.7689 | 2800.0 |
| 2009-12-09 05:33:00 | AAPL | Stock | 6.7807 | 6.7807 | 6.7807 | 6.7807 | 2800.0 |
| 2009-12-09 05:43:00 | AAPL | Stock | 6.7996 | 6.8 | 6.7996 | 6.8 | 5600.0 |
| 2009-12-09 05:51:00 | AAPL | Stock | 6.8036 | 6.8036 | 6.8036 | 6.8036 | 2800.0 |
| 2009-12-09 06:12:00 | AAPL | Stock | 6.7996 | 6.7996 | 6.7996 | 6.7996 | 3920.0 |
| 2009-12-09 06:55:00 | AAPL | Stock | 6.8018 | 6.8018 | 6.8 | 6.8 | 5600.0 |
| 2009-12-09 07:00:00 | AAPL | Stock | 6.8075 | 6.8075 | 6.8075 | 6.8075 | 2800.0 |
| 2009-12-09 07:01:00 | AAPL | Stock | 6.8082 | 6.8082 | 6.8082 | 6.8082 | 2800.0 |
| 2009-12-09 07:02:00 | AAPL | Stock | 6.8036 | 6.8036 | 6.8036 | 6.8036 | 5600.0 |
| 2009-12-09 07:03:00 | AAPL | Stock | 6.8079 | 6.8079 | 6.8079 | 6.8079 | 2800.0 |
| 2009-12-09 07:04:00 | AAPL | Stock | 6.8089 | 6.8089 | 6.8089 | 6.8089 | 2800.0 |
| 2009-12-09 07:06:00 | AAPL | Stock | 6.8018 | 6.8018 | 6.8018 | 6.8018 | 10920.0 |
| 2009-12-09 07:07:00 | AAPL | Stock | 6.8036 | 6.8036 | 6.8036 | 6.8036 | 2800.0 |
| 2009-12-09 07:09:00 | AAPL | Stock | 6.8018 | 6.8018 | 6.8018 | 6.8018 | 2940.0 |
| 2009-12-09 07:11:00 | AAPL | Stock | 6.8018 | 6.8018 | 6.8018 | 6.8018 | 25060.0 |
| 2009-12-09 07:13:00 | AAPL | Stock | 6.8018 | 6.8018 | 6.8 | 6.8 | 5740.0 |
| 2009-12-09 07:15:00 | AAPL | Stock | 6.8011 | 6.8011 | 6.8011 | 6.8011 | 14000.0 |
| 2009-12-09 07:21:00 | AAPL | Stock | 6.8011 | 6.8011 | 6.8011 | 6.8011 | 10220.0 |
| 2009-12-09 07:22:00 | AAPL | Stock | 6.8036 | 6.8036 | 6.8036 | 6.8036 | 5600.0 |
| 2009-12-09 07:24:00 | AAPL | Stock | 6.7993 | 6.7993 | 6.7993 | 6.7993 | 2800.0 |
| 2009-12-09 07:26:00 | AAPL | Stock | 6.8025 | 6.8043 | 6.8025 | 6.8043 | 102200.0 |
| 2009-12-09 07:27:00 | AAPL | Stock | 6.8043 | 6.8046 | 6.8043 | 6.8046 | 14000.0 |
| 2009-12-09 07:28:00 | AAPL | Stock | 6.8046 | 6.8046 | 6.8046 | 6.8046 | 10500.0 |
| 2009-12-09 07:29:00 | AAPL | Stock | 6.8036 | 6.8036 | 6.8036 | 6.8036 | 2800.0 |
| 2009-12-09 07:31:00 | AAPL | Stock | 6.7996 | 6.7996 | 6.7996 | 6.7996 | 2800.0 |
| 2009-12-09 07:33:00 | AAPL | Stock | 6.8032 | 6.8107 | 6.8032 | 6.8107 | 98560.0 |
| 2009-12-09 07:34:00 | AAPL | Stock | 6.8143 | 6.8143 | 6.8107 | 6.8143 | 33600.0 |
| 2009-12-09 07:36:00 | AAPL | Stock | 6.8143 | 6.8143 | 6.8143 | 6.8143 | 5600.0 |
| 2009-12-09 07:37:00 | AAPL | Stock | 6.8143 | 6.8143 | 6.8143 | 6.8143 | 5600.0 |
| 2009-12-09 07:38:00 | AAPL | Stock | 6.8136 | 6.8136 | 6.8136 | 6.8136 | 4200.0 |
| 2009-12-09 07:39:00 | AAPL | Stock | 6.8143 | 6.8143 | 6.8143 | 6.8143 | 2800.0 |
| 2009-12-09 07:42:00 | AAPL | Stock | 6.8154 | 6.8175 | 6.8154 | 6.8175 | 19600.0 |
| 2009-12-09 07:43:00 | AAPL | Stock | 6.8168 | 6.8179 | 6.8168 | 6.8179 | 30464.0 |
| 2009-12-09 07:44:00 | AAPL | Stock | 6.8175 | 6.8175 | 6.8175 | 6.8175 | 2800.0 |
| 2009-12-09 07:45:00 | AAPL | Stock | 6.8154 | 6.8154 | 6.8154 | 6.8154 | 2800.0 |
| 2009-12-09 07:46:00 | AAPL | Stock | 6.8175 | 6.8214 | 6.8175 | 6.8211 | 58324.0 |
| 2009-12-09 07:47:00 | AAPL | Stock | 6.8214 | 6.8214 | 6.8204 | 6.8204 | 12880.0 |
| 2009-12-09 07:48:00 | AAPL | Stock | 6.8211 | 6.8214 | 6.8211 | 6.8214 | 9800.0 |
| 2009-12-09 07:49:00 | AAPL | Stock | 6.8214 | 6.825 | 6.8214 | 6.825 | 28000.0 |
| 2009-12-09 07:51:00 | AAPL | Stock | 6.825 | 6.8325 | 6.825 | 6.8325 | 141372.0 |
| 2009-12-09 07:52:00 | AAPL | Stock | 6.835 | 6.8371 | 6.835 | 6.8357 | 58800.0 |
| 2009-12-09 07:53:00 | AAPL | Stock | 6.835 | 6.835 | 6.835 | 6.835 | 2800.0 |
| 2009-12-09 07:55:00 | AAPL | Stock | 6.8275 | 6.8275 | 6.8275 | 6.8275 | 2800.0 |
| 2009-12-09 07:57:00 | AAPL | Stock | 6.825 | 6.8318 | 6.8225 | 6.8318 | 28000.0 |
| 2009-12-09 07:59:00 | AAPL | Stock | 6.8232 | 6.8232 | 6.8229 | 6.8229 | 14000.0 |
| 2009-12-09 08:00:00 | AAPL | Stock | 6.825 | 6.8329 | 6.8214 | 6.8296 | 276248.0 |
| 2009-12-09 08:01:00 | AAPL | Stock | 6.83 | 6.8329 | 6.8214 | 6.8329 | 98280.0 |
> showing 50 of 917,313 rows — these rows as CSV