PREVIEW / stock_1min / 2014-08-26
file: by_date/stock_1min/2014/2014-08-26.parquet size: 13.7 MB rows: 1,002,594 symbols: 2,931
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 |
|---|---|---|---|---|---|---|---|
| 2014-08-26 04:00:00 | AAPL | Stock | 25.3125 | 25.3125 | 25.3125 | 25.3125 | 2000.0 |
| 2014-08-26 04:04:00 | AAPL | Stock | 25.3325 | 25.3325 | 25.3325 | 25.3325 | 400.0 |
| 2014-08-26 04:06:00 | AAPL | Stock | 25.3325 | 25.3325 | 25.3325 | 25.3325 | 2000.0 |
| 2014-08-26 04:23:00 | AAPL | Stock | 25.35 | 25.35 | 25.35 | 25.35 | 400.0 |
| 2014-08-26 04:42:00 | AAPL | Stock | 25.35 | 25.35 | 25.35 | 25.35 | 400.0 |
| 2014-08-26 04:43:00 | AAPL | Stock | 25.3525 | 25.3525 | 25.3525 | 25.3525 | 2000.0 |
| 2014-08-26 04:52:00 | AAPL | Stock | 25.3425 | 25.3425 | 25.3425 | 25.3425 | 3796.0 |
| 2014-08-26 04:54:00 | AAPL | Stock | 25.3475 | 25.3475 | 25.3475 | 25.3475 | 400.0 |
| 2014-08-26 05:06:00 | AAPL | Stock | 25.3425 | 25.3425 | 25.3425 | 25.3425 | 2400.0 |
| 2014-08-26 05:55:00 | AAPL | Stock | 25.315 | 25.315 | 25.31 | 25.31 | 7912.0 |
| 2014-08-26 06:00:00 | AAPL | Stock | 25.3125 | 25.3125 | 25.3125 | 25.3125 | 4000.0 |
| 2014-08-26 06:03:00 | AAPL | Stock | 25.3125 | 25.3125 | 25.3125 | 25.3125 | 800.0 |
| 2014-08-26 06:04:00 | AAPL | Stock | 25.3125 | 25.3125 | 25.3125 | 25.3125 | 800.0 |
| 2014-08-26 06:05:00 | AAPL | Stock | 25.3125 | 25.3125 | 25.3125 | 25.3125 | 1200.0 |
| 2014-08-26 06:08:00 | AAPL | Stock | 25.3125 | 25.3125 | 25.3125 | 25.3125 | 400.0 |
| 2014-08-26 06:12:00 | AAPL | Stock | 25.3125 | 25.3125 | 25.3125 | 25.3125 | 400.0 |
| 2014-08-26 06:13:00 | AAPL | Stock | 25.3125 | 25.3125 | 25.3125 | 25.3125 | 1600.0 |
| 2014-08-26 06:29:00 | AAPL | Stock | 25.3375 | 25.3375 | 25.3375 | 25.3375 | 800.0 |
| 2014-08-26 06:31:00 | AAPL | Stock | 25.3425 | 25.3425 | 25.3425 | 25.3425 | 400.0 |
| 2014-08-26 06:33:00 | AAPL | Stock | 25.3425 | 25.3425 | 25.325 | 25.325 | 1600.0 |
| 2014-08-26 06:37:00 | AAPL | Stock | 25.345 | 25.345 | 25.345 | 25.345 | 400.0 |
| 2014-08-26 06:39:00 | AAPL | Stock | 25.3375 | 25.3375 | 25.3375 | 25.3375 | 1244.0 |
| 2014-08-26 06:48:00 | AAPL | Stock | 25.345 | 25.3475 | 25.345 | 25.3475 | 2512.0 |
| 2014-08-26 06:53:00 | AAPL | Stock | 25.3475 | 25.3475 | 25.3475 | 25.3475 | 400.0 |
| 2014-08-26 06:57:00 | AAPL | Stock | 25.35 | 25.35 | 25.35 | 25.35 | 3200.0 |
| 2014-08-26 07:02:00 | AAPL | Stock | 25.335 | 25.335 | 25.335 | 25.335 | 800.0 |
| 2014-08-26 07:03:00 | AAPL | Stock | 25.335 | 25.335 | 25.335 | 25.335 | 3328.0 |
| 2014-08-26 07:04:00 | AAPL | Stock | 25.335 | 25.335 | 25.325 | 25.33 | 6684.0 |
| 2014-08-26 07:06:00 | AAPL | Stock | 25.325 | 25.33 | 25.325 | 25.33 | 3804.0 |
| 2014-08-26 07:13:00 | AAPL | Stock | 25.345 | 25.3475 | 25.345 | 25.3475 | 2000.0 |
| 2014-08-26 07:17:00 | AAPL | Stock | 25.345 | 25.345 | 25.345 | 25.345 | 3600.0 |
| 2014-08-26 07:18:00 | AAPL | Stock | 25.345 | 25.345 | 25.345 | 25.345 | 800.0 |
| 2014-08-26 07:19:00 | AAPL | Stock | 25.35 | 25.35 | 25.35 | 25.35 | 2800.0 |
| 2014-08-26 07:23:00 | AAPL | Stock | 25.3625 | 25.3625 | 25.3625 | 25.3625 | 800.0 |
| 2014-08-26 07:25:00 | AAPL | Stock | 25.3575 | 25.3575 | 25.3575 | 25.3575 | 2000.0 |
| 2014-08-26 07:26:00 | AAPL | Stock | 25.3575 | 25.365 | 25.3575 | 25.365 | 8000.0 |
| 2014-08-26 07:29:00 | AAPL | Stock | 25.3625 | 25.3675 | 25.3625 | 25.3675 | 1432.0 |
| 2014-08-26 07:31:00 | AAPL | Stock | 25.3675 | 25.375 | 25.3675 | 25.375 | 6232.0 |
| 2014-08-26 07:34:00 | AAPL | Stock | 25.385 | 25.385 | 25.375 | 25.375 | 1600.0 |
| 2014-08-26 07:35:00 | AAPL | Stock | 25.375 | 25.385 | 25.3625 | 25.3625 | 18332.0 |
| 2014-08-26 07:38:00 | AAPL | Stock | 25.3775 | 25.3775 | 25.3775 | 25.3775 | 400.0 |
| 2014-08-26 07:39:00 | AAPL | Stock | 25.3825 | 25.385 | 25.3825 | 25.385 | 4800.0 |
| 2014-08-26 07:41:00 | AAPL | Stock | 25.3875 | 25.3925 | 25.3875 | 25.3925 | 1100.0 |
| 2014-08-26 07:42:00 | AAPL | Stock | 25.3925 | 25.3975 | 25.3925 | 25.3975 | 2960.0 |
| 2014-08-26 07:43:00 | AAPL | Stock | 25.38 | 25.38 | 25.3775 | 25.3775 | 1328.0 |
| 2014-08-26 07:54:00 | AAPL | Stock | 25.395 | 25.3975 | 25.395 | 25.3975 | 4400.0 |
| 2014-08-26 07:55:00 | AAPL | Stock | 25.395 | 25.395 | 25.3875 | 25.3875 | 1912.0 |
| 2014-08-26 07:58:00 | AAPL | Stock | 25.39 | 25.39 | 25.39 | 25.39 | 7400.0 |
| 2014-08-26 07:59:00 | AAPL | Stock | 25.3875 | 25.3875 | 25.3875 | 25.3875 | 3600.0 |
| 2014-08-26 08:00:00 | AAPL | Stock | 25.385 | 25.395 | 25.325 | 25.375 | 107008.0 |
> showing 50 of 1,002,594 rows — these rows as CSV