PREVIEW / stock_1min / 2012-10-03
file: by_date/stock_1min/2012/2012-10-03.parquet size: 12.6 MB rows: 931,008 symbols: 2,798
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 |
|---|---|---|---|---|---|---|---|
| 2012-10-03 04:00:00 | AAPL | Stock | 23.6425 | 23.6425 | 23.6425 | 23.6425 | 2800.0 |
| 2012-10-03 04:02:00 | AAPL | Stock | 23.6782 | 23.6782 | 23.6782 | 23.6782 | 2800.0 |
| 2012-10-03 04:03:00 | AAPL | Stock | 23.6964 | 23.6964 | 23.6964 | 23.6964 | 2800.0 |
| 2012-10-03 04:06:00 | AAPL | Stock | 23.6786 | 23.6786 | 23.6786 | 23.6786 | 4872.0 |
| 2012-10-03 04:07:00 | AAPL | Stock | 23.6714 | 23.6714 | 23.6714 | 23.6714 | 2800.0 |
| 2012-10-03 04:17:00 | AAPL | Stock | 23.7143 | 23.7143 | 23.7143 | 23.7143 | 2800.0 |
| 2012-10-03 04:19:00 | AAPL | Stock | 23.7143 | 23.7143 | 23.7143 | 23.7143 | 2800.0 |
| 2012-10-03 04:26:00 | AAPL | Stock | 23.7464 | 23.7464 | 23.7464 | 23.7464 | 4732.0 |
| 2012-10-03 04:27:00 | AAPL | Stock | 23.7464 | 23.7464 | 23.7464 | 23.7464 | 2800.0 |
| 2012-10-03 04:58:00 | AAPL | Stock | 23.7146 | 23.7146 | 23.7146 | 23.7146 | 2800.0 |
| 2012-10-03 04:59:00 | AAPL | Stock | 23.7143 | 23.7143 | 23.7143 | 23.7143 | 2800.0 |
| 2012-10-03 05:10:00 | AAPL | Stock | 23.75 | 23.75 | 23.75 | 23.75 | 5600.0 |
| 2012-10-03 05:13:00 | AAPL | Stock | 23.75 | 23.75 | 23.75 | 23.75 | 8400.0 |
| 2012-10-03 05:45:00 | AAPL | Stock | 23.75 | 23.75 | 23.75 | 23.75 | 2800.0 |
| 2012-10-03 06:05:00 | AAPL | Stock | 23.7507 | 23.7507 | 23.7507 | 23.7507 | 2800.0 |
| 2012-10-03 06:07:00 | AAPL | Stock | 23.7511 | 23.7511 | 23.7511 | 23.7511 | 2800.0 |
| 2012-10-03 06:09:00 | AAPL | Stock | 23.7661 | 23.7661 | 23.7625 | 23.7625 | 5600.0 |
| 2012-10-03 06:24:00 | AAPL | Stock | 23.7625 | 23.7643 | 23.7625 | 23.7643 | 7000.0 |
| 2012-10-03 06:46:00 | AAPL | Stock | 23.7518 | 23.7518 | 23.7518 | 23.7518 | 6328.0 |
| 2012-10-03 06:50:00 | AAPL | Stock | 23.7514 | 23.7514 | 23.75 | 23.75 | 32200.0 |
| 2012-10-03 07:02:00 | AAPL | Stock | 23.7161 | 23.7161 | 23.7161 | 23.7161 | 5880.0 |
| 2012-10-03 07:03:00 | AAPL | Stock | 23.7282 | 23.7321 | 23.7282 | 23.7321 | 8400.0 |
| 2012-10-03 07:04:00 | AAPL | Stock | 23.7321 | 23.7321 | 23.7286 | 23.7286 | 14000.0 |
| 2012-10-03 07:05:00 | AAPL | Stock | 23.7314 | 23.7321 | 23.7314 | 23.7321 | 8400.0 |
| 2012-10-03 07:06:00 | AAPL | Stock | 23.7286 | 23.7357 | 23.7286 | 23.7321 | 32480.0 |
| 2012-10-03 07:07:00 | AAPL | Stock | 23.7461 | 23.7479 | 23.7461 | 23.7479 | 8400.0 |
| 2012-10-03 07:16:00 | AAPL | Stock | 23.7464 | 23.7464 | 23.7429 | 23.7464 | 28000.0 |
| 2012-10-03 07:18:00 | AAPL | Stock | 23.7429 | 23.7429 | 23.7425 | 23.7425 | 5600.0 |
| 2012-10-03 07:19:00 | AAPL | Stock | 23.7375 | 23.7375 | 23.7375 | 23.7375 | 2800.0 |
| 2012-10-03 07:20:00 | AAPL | Stock | 23.7461 | 23.7464 | 23.7457 | 23.7457 | 9940.0 |
| 2012-10-03 07:23:00 | AAPL | Stock | 23.7411 | 23.7411 | 23.7411 | 23.7411 | 2800.0 |
| 2012-10-03 07:28:00 | AAPL | Stock | 23.7411 | 23.7411 | 23.7325 | 23.7325 | 5600.0 |
| 2012-10-03 07:31:00 | AAPL | Stock | 23.7443 | 23.7461 | 23.7443 | 23.7461 | 13300.0 |
| 2012-10-03 07:33:00 | AAPL | Stock | 23.7321 | 23.7321 | 23.7321 | 23.7321 | 2800.0 |
| 2012-10-03 07:35:00 | AAPL | Stock | 23.7339 | 23.7339 | 23.7339 | 23.7339 | 2800.0 |
| 2012-10-03 07:36:00 | AAPL | Stock | 23.7343 | 23.745 | 23.7321 | 23.7379 | 14000.0 |
| 2012-10-03 07:39:00 | AAPL | Stock | 23.7321 | 23.7321 | 23.7321 | 23.7321 | 2800.0 |
| 2012-10-03 07:41:00 | AAPL | Stock | 23.7379 | 23.7379 | 23.7379 | 23.7379 | 2800.0 |
| 2012-10-03 07:42:00 | AAPL | Stock | 23.7411 | 23.7411 | 23.7411 | 23.7411 | 2800.0 |
| 2012-10-03 07:43:00 | AAPL | Stock | 23.7357 | 23.7357 | 23.7357 | 23.7357 | 7000.0 |
| 2012-10-03 07:51:00 | AAPL | Stock | 23.7414 | 23.75 | 23.7414 | 23.75 | 39648.0 |
| 2012-10-03 07:53:00 | AAPL | Stock | 23.7393 | 23.7393 | 23.7393 | 23.7393 | 2800.0 |
| 2012-10-03 07:57:00 | AAPL | Stock | 23.7407 | 23.7407 | 23.7407 | 23.7407 | 5600.0 |
| 2012-10-03 07:59:00 | AAPL | Stock | 23.7357 | 23.7357 | 23.7357 | 23.7357 | 23660.0 |
| 2012-10-03 08:00:00 | AAPL | Stock | 23.7325 | 23.7407 | 23.6986 | 23.6986 | 112560.0 |
| 2012-10-03 08:01:00 | AAPL | Stock | 23.7 | 23.7 | 23.6964 | 23.6964 | 30800.0 |
| 2012-10-03 08:02:00 | AAPL | Stock | 23.6957 | 23.6964 | 23.6957 | 23.6964 | 21000.0 |
| 2012-10-03 08:03:00 | AAPL | Stock | 23.6989 | 23.7054 | 23.6989 | 23.7054 | 34608.0 |
| 2012-10-03 08:04:00 | AAPL | Stock | 23.705 | 23.705 | 23.6929 | 23.6964 | 36400.0 |
| 2012-10-03 08:05:00 | AAPL | Stock | 23.6943 | 23.6946 | 23.6929 | 23.6929 | 30800.0 |
> showing 50 of 931,008 rows — these rows as CSV