PREVIEW / stock_1min / 2011-04-12
file: by_date/stock_1min/2011/2011-04-12.parquet size: 13.4 MB rows: 999,657 symbols: 2,871
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-04-12 04:00:00 | AAPL | Stock | 11.7679 | 11.7679 | 11.7679 | 11.7679 | 2800.0 |
| 2011-04-12 04:05:00 | AAPL | Stock | 11.7675 | 11.7675 | 11.7675 | 11.7675 | 2800.0 |
| 2011-04-12 04:14:00 | AAPL | Stock | 11.7718 | 11.7743 | 11.7718 | 11.7743 | 8400.0 |
| 2011-04-12 04:15:00 | AAPL | Stock | 11.7761 | 11.7764 | 11.7761 | 11.7764 | 5600.0 |
| 2011-04-12 04:28:00 | AAPL | Stock | 11.7368 | 11.7368 | 11.7368 | 11.7368 | 2800.0 |
| 2011-04-12 04:55:00 | AAPL | Stock | 11.7396 | 11.7396 | 11.7396 | 11.7396 | 2800.0 |
| 2011-04-12 05:12:00 | AAPL | Stock | 11.7364 | 11.7364 | 11.7325 | 11.7364 | 10080.0 |
| 2011-04-12 05:17:00 | AAPL | Stock | 11.7482 | 11.7482 | 11.7482 | 11.7482 | 2800.0 |
| 2011-04-12 05:32:00 | AAPL | Stock | 11.75 | 11.75 | 11.75 | 11.75 | 6160.0 |
| 2011-04-12 05:42:00 | AAPL | Stock | 11.7332 | 11.7332 | 11.7332 | 11.7332 | 2800.0 |
| 2011-04-12 05:58:00 | AAPL | Stock | 11.7329 | 11.7329 | 11.7321 | 11.7321 | 8400.0 |
| 2011-04-12 06:04:00 | AAPL | Stock | 11.7461 | 11.7461 | 11.7461 | 11.7461 | 2800.0 |
| 2011-04-12 06:07:00 | AAPL | Stock | 11.7464 | 11.7464 | 11.7464 | 11.7464 | 2800.0 |
| 2011-04-12 06:08:00 | AAPL | Stock | 11.7411 | 11.7411 | 11.7411 | 11.7411 | 2800.0 |
| 2011-04-12 06:09:00 | AAPL | Stock | 11.7357 | 11.7357 | 11.7357 | 11.7357 | 2800.0 |
| 2011-04-12 06:14:00 | AAPL | Stock | 11.7321 | 11.7321 | 11.7321 | 11.7321 | 5600.0 |
| 2011-04-12 06:16:00 | AAPL | Stock | 11.7339 | 11.7464 | 11.7339 | 11.7464 | 22400.0 |
| 2011-04-12 06:17:00 | AAPL | Stock | 11.75 | 11.75 | 11.75 | 11.75 | 12012.0 |
| 2011-04-12 06:54:00 | AAPL | Stock | 11.7393 | 11.7393 | 11.7393 | 11.7393 | 5600.0 |
| 2011-04-12 06:55:00 | AAPL | Stock | 11.7393 | 11.7393 | 11.7393 | 11.7393 | 2800.0 |
| 2011-04-12 07:03:00 | AAPL | Stock | 11.7332 | 11.7332 | 11.7232 | 11.7232 | 5600.0 |
| 2011-04-12 07:07:00 | AAPL | Stock | 11.7218 | 11.7218 | 11.7107 | 11.7107 | 232680.0 |
| 2011-04-12 07:09:00 | AAPL | Stock | 11.7018 | 11.7018 | 11.6968 | 11.6968 | 5600.0 |
| 2011-04-12 07:13:00 | AAPL | Stock | 11.7018 | 11.7018 | 11.7018 | 11.7018 | 2800.0 |
| 2011-04-12 07:16:00 | AAPL | Stock | 11.7039 | 11.7039 | 11.7039 | 11.7039 | 2800.0 |
| 2011-04-12 07:18:00 | AAPL | Stock | 11.71 | 11.71 | 11.71 | 11.71 | 2800.0 |
| 2011-04-12 07:20:00 | AAPL | Stock | 11.725 | 11.7464 | 11.7143 | 11.7179 | 35056.0 |
| 2011-04-12 07:21:00 | AAPL | Stock | 11.725 | 11.725 | 11.725 | 11.725 | 5600.0 |
| 2011-04-12 07:22:00 | AAPL | Stock | 11.7146 | 11.725 | 11.7146 | 11.725 | 5600.0 |
| 2011-04-12 07:23:00 | AAPL | Stock | 11.7118 | 11.7118 | 11.7111 | 11.7111 | 34440.0 |
| 2011-04-12 07:24:00 | AAPL | Stock | 11.7143 | 11.7143 | 11.7143 | 11.7143 | 8400.0 |
| 2011-04-12 07:25:00 | AAPL | Stock | 11.7143 | 11.7143 | 11.7107 | 11.7107 | 33600.0 |
| 2011-04-12 07:26:00 | AAPL | Stock | 11.7075 | 11.7075 | 11.7071 | 11.7075 | 28560.0 |
| 2011-04-12 07:27:00 | AAPL | Stock | 11.7075 | 11.7075 | 11.7021 | 11.7021 | 22400.0 |
| 2011-04-12 07:28:00 | AAPL | Stock | 11.7021 | 11.705 | 11.7011 | 11.705 | 36820.0 |
| 2011-04-12 07:29:00 | AAPL | Stock | 11.6971 | 11.6971 | 11.6971 | 11.6971 | 2800.0 |
| 2011-04-12 07:30:00 | AAPL | Stock | 11.6975 | 11.6979 | 11.6964 | 11.6964 | 56000.0 |
| 2011-04-12 07:31:00 | AAPL | Stock | 11.6961 | 11.6961 | 11.6961 | 11.6961 | 2800.0 |
| 2011-04-12 07:33:00 | AAPL | Stock | 11.7021 | 11.7021 | 11.7021 | 11.7021 | 5600.0 |
| 2011-04-12 07:34:00 | AAPL | Stock | 11.7021 | 11.7075 | 11.7021 | 11.7075 | 35280.0 |
| 2011-04-12 07:38:00 | AAPL | Stock | 11.7079 | 11.7079 | 11.7075 | 11.7075 | 28000.0 |
| 2011-04-12 07:39:00 | AAPL | Stock | 11.7039 | 11.7039 | 11.7036 | 11.7036 | 5600.0 |
| 2011-04-12 07:40:00 | AAPL | Stock | 11.7036 | 11.7036 | 11.7025 | 11.7036 | 16800.0 |
| 2011-04-12 07:41:00 | AAPL | Stock | 11.7068 | 11.7089 | 11.7068 | 11.7071 | 67368.0 |
| 2011-04-12 07:42:00 | AAPL | Stock | 11.7143 | 11.7143 | 11.7143 | 11.7143 | 2800.0 |
| 2011-04-12 07:43:00 | AAPL | Stock | 11.7143 | 11.7143 | 11.7143 | 11.7143 | 7392.0 |
| 2011-04-12 07:45:00 | AAPL | Stock | 11.7136 | 11.7136 | 11.7071 | 11.7089 | 61600.0 |
| 2011-04-12 07:46:00 | AAPL | Stock | 11.7089 | 11.7139 | 11.7089 | 11.7139 | 8540.0 |
| 2011-04-12 07:47:00 | AAPL | Stock | 11.7139 | 11.7139 | 11.7125 | 11.7125 | 8260.0 |
| 2011-04-12 07:48:00 | AAPL | Stock | 11.7136 | 11.7139 | 11.7136 | 11.7139 | 11200.0 |
> showing 50 of 999,657 rows — these rows as CSV