PREVIEW / stock_1min / 2013-06-12
file: by_date/stock_1min/2013/2013-06-12.parquet size: 13.5 MB rows: 994,337 symbols: 2,821
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 |
|---|---|---|---|---|---|---|---|
| 2013-06-12 05:56:00 | AAPL | Stock | 15.7043 | 15.7043 | 15.7043 | 15.7043 | 2800.0 |
| 2013-06-12 06:06:00 | AAPL | Stock | 15.7054 | 15.7054 | 15.7054 | 15.7054 | 2800.0 |
| 2013-06-12 06:13:00 | AAPL | Stock | 15.6968 | 15.6968 | 15.6964 | 15.6964 | 5600.0 |
| 2013-06-12 06:19:00 | AAPL | Stock | 15.6964 | 15.6964 | 15.6964 | 15.6964 | 2800.0 |
| 2013-06-12 06:34:00 | AAPL | Stock | 15.6964 | 15.6964 | 15.6964 | 15.6964 | 7000.0 |
| 2013-06-12 06:48:00 | AAPL | Stock | 15.7107 | 15.7107 | 15.7104 | 15.7107 | 16800.0 |
| 2013-06-12 06:56:00 | AAPL | Stock | 15.7282 | 15.7286 | 15.7282 | 15.7286 | 11200.0 |
| 2013-06-12 06:57:00 | AAPL | Stock | 15.7286 | 15.7286 | 15.7286 | 15.7286 | 5572.0 |
| 2013-06-12 07:00:00 | AAPL | Stock | 15.7321 | 15.7321 | 15.7321 | 15.7321 | 2800.0 |
| 2013-06-12 07:01:00 | AAPL | Stock | 15.7232 | 15.7232 | 15.7107 | 15.7107 | 19600.0 |
| 2013-06-12 07:02:00 | AAPL | Stock | 15.7143 | 15.7446 | 15.7143 | 15.7446 | 19264.0 |
| 2013-06-12 07:04:00 | AAPL | Stock | 15.7325 | 15.7325 | 15.7193 | 15.7193 | 25200.0 |
| 2013-06-12 07:05:00 | AAPL | Stock | 15.7221 | 15.7221 | 15.7221 | 15.7221 | 2800.0 |
| 2013-06-12 07:07:00 | AAPL | Stock | 15.7268 | 15.7268 | 15.7268 | 15.7268 | 2800.0 |
| 2013-06-12 07:12:00 | AAPL | Stock | 15.7357 | 15.7357 | 15.7254 | 15.7254 | 18200.0 |
| 2013-06-12 07:13:00 | AAPL | Stock | 15.7236 | 15.7314 | 15.7236 | 15.7314 | 8400.0 |
| 2013-06-12 07:15:00 | AAPL | Stock | 15.7304 | 15.7304 | 15.7304 | 15.7304 | 2800.0 |
| 2013-06-12 07:16:00 | AAPL | Stock | 15.7229 | 15.7232 | 15.7229 | 15.7232 | 14000.0 |
| 2013-06-12 07:19:00 | AAPL | Stock | 15.7232 | 15.7232 | 15.7232 | 15.7232 | 2800.0 |
| 2013-06-12 07:22:00 | AAPL | Stock | 15.7143 | 15.7143 | 15.7143 | 15.7143 | 5600.0 |
| 2013-06-12 07:23:00 | AAPL | Stock | 15.7143 | 15.7143 | 15.7143 | 15.7143 | 8400.0 |
| 2013-06-12 07:28:00 | AAPL | Stock | 15.7225 | 15.7225 | 15.7225 | 15.7225 | 2800.0 |
| 2013-06-12 07:31:00 | AAPL | Stock | 15.7143 | 15.715 | 15.7143 | 15.7143 | 14000.0 |
| 2013-06-12 07:32:00 | AAPL | Stock | 15.7 | 15.7 | 15.7 | 15.7 | 10640.0 |
| 2013-06-12 07:33:00 | AAPL | Stock | 15.7143 | 15.7143 | 15.7143 | 15.7143 | 5600.0 |
| 2013-06-12 07:35:00 | AAPL | Stock | 15.7225 | 15.7232 | 15.7225 | 15.7232 | 11900.0 |
| 2013-06-12 07:38:00 | AAPL | Stock | 15.7221 | 15.7221 | 15.7221 | 15.7221 | 2800.0 |
| 2013-06-12 07:39:00 | AAPL | Stock | 15.7243 | 15.7243 | 15.7243 | 15.7243 | 5460.0 |
| 2013-06-12 07:43:00 | AAPL | Stock | 15.7311 | 15.7375 | 15.7311 | 15.7375 | 19488.0 |
| 2013-06-12 07:44:00 | AAPL | Stock | 15.7375 | 15.7375 | 15.7375 | 15.7375 | 2800.0 |
| 2013-06-12 07:45:00 | AAPL | Stock | 15.7454 | 15.7454 | 15.7454 | 15.7454 | 5600.0 |
| 2013-06-12 07:47:00 | AAPL | Stock | 15.7375 | 15.7375 | 15.7375 | 15.7375 | 2800.0 |
| 2013-06-12 07:52:00 | AAPL | Stock | 15.7304 | 15.7304 | 15.7304 | 15.7304 | 2800.0 |
| 2013-06-12 07:58:00 | AAPL | Stock | 15.7268 | 15.7268 | 15.7268 | 15.7268 | 25200.0 |
| 2013-06-12 07:59:00 | AAPL | Stock | 15.7232 | 15.7232 | 15.7232 | 15.7232 | 2800.0 |
| 2013-06-12 08:00:00 | AAPL | Stock | 15.7271 | 15.7454 | 15.7014 | 15.7032 | 141344.0 |
| 2013-06-12 08:01:00 | AAPL | Stock | 15.7186 | 15.7286 | 15.6429 | 15.7143 | 129276.0 |
| 2013-06-12 08:02:00 | AAPL | Stock | 15.7139 | 15.7139 | 15.7139 | 15.7139 | 2800.0 |
| 2013-06-12 08:03:00 | AAPL | Stock | 15.7143 | 15.7214 | 15.7143 | 15.7214 | 8400.0 |
| 2013-06-12 08:04:00 | AAPL | Stock | 15.7214 | 15.7214 | 15.7143 | 15.7143 | 30492.0 |
| 2013-06-12 08:05:00 | AAPL | Stock | 15.7154 | 15.7214 | 15.7143 | 15.7214 | 33600.0 |
| 2013-06-12 08:06:00 | AAPL | Stock | 15.7182 | 15.7182 | 15.7179 | 15.7179 | 17892.0 |
| 2013-06-12 08:07:00 | AAPL | Stock | 15.7164 | 15.7164 | 15.7164 | 15.7164 | 2800.0 |
| 2013-06-12 08:08:00 | AAPL | Stock | 15.7154 | 15.7154 | 15.7154 | 15.7154 | 2800.0 |
| 2013-06-12 08:10:00 | AAPL | Stock | 15.7143 | 15.7143 | 15.7143 | 15.7143 | 2800.0 |
| 2013-06-12 08:11:00 | AAPL | Stock | 15.7107 | 15.7136 | 15.7032 | 15.7136 | 72800.0 |
| 2013-06-12 08:13:00 | AAPL | Stock | 15.7043 | 15.7043 | 15.7018 | 15.7018 | 6440.0 |
| 2013-06-12 08:14:00 | AAPL | Stock | 15.7018 | 15.7018 | 15.7018 | 15.7018 | 14980.0 |
| 2013-06-12 08:15:00 | AAPL | Stock | 15.7007 | 15.71 | 15.7007 | 15.71 | 19600.0 |
| 2013-06-12 08:16:00 | AAPL | Stock | 15.7004 | 15.7007 | 15.6968 | 15.7 | 43596.0 |
> showing 50 of 994,337 rows — these rows as CSV