PREVIEW / stock_1min / 2010-08-31
file: by_date/stock_1min/2010/2010-08-31.parquet size: 12.6 MB rows: 958,358 symbols: 2,805
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 |
|---|---|---|---|---|---|---|---|
| 2010-08-31 04:47:00 | AAPL | Stock | 8.6786 | 8.6786 | 8.6786 | 8.6786 | 2800.0 |
| 2010-08-31 06:18:00 | AAPL | Stock | 8.6725 | 8.6786 | 8.6725 | 8.6786 | 5600.0 |
| 2010-08-31 06:20:00 | AAPL | Stock | 8.6714 | 8.6714 | 8.6714 | 8.6714 | 2800.0 |
| 2010-08-31 06:55:00 | AAPL | Stock | 8.6711 | 8.6711 | 8.6711 | 8.6711 | 3752.0 |
| 2010-08-31 06:57:00 | AAPL | Stock | 8.6643 | 8.6643 | 8.6607 | 8.6607 | 5600.0 |
| 2010-08-31 07:02:00 | AAPL | Stock | 8.6479 | 8.6568 | 8.6479 | 8.6568 | 11788.0 |
| 2010-08-31 07:06:00 | AAPL | Stock | 8.6554 | 8.6554 | 8.6389 | 8.6389 | 22400.0 |
| 2010-08-31 07:15:00 | AAPL | Stock | 8.6439 | 8.6439 | 8.6439 | 8.6439 | 2800.0 |
| 2010-08-31 07:22:00 | AAPL | Stock | 8.645 | 8.645 | 8.645 | 8.645 | 5600.0 |
| 2010-08-31 07:23:00 | AAPL | Stock | 8.645 | 8.645 | 8.6346 | 8.6346 | 51296.0 |
| 2010-08-31 07:24:00 | AAPL | Stock | 8.6325 | 8.6325 | 8.6318 | 8.6321 | 28000.0 |
| 2010-08-31 07:25:00 | AAPL | Stock | 8.6218 | 8.6246 | 8.6214 | 8.6246 | 22400.0 |
| 2010-08-31 07:26:00 | AAPL | Stock | 8.6246 | 8.6246 | 8.615 | 8.615 | 8400.0 |
| 2010-08-31 07:32:00 | AAPL | Stock | 8.6246 | 8.625 | 8.6246 | 8.625 | 11200.0 |
| 2010-08-31 07:53:00 | AAPL | Stock | 8.6325 | 8.6325 | 8.6325 | 8.6325 | 7980.0 |
| 2010-08-31 07:59:00 | AAPL | Stock | 8.6493 | 8.6493 | 8.6493 | 8.6493 | 2800.0 |
| 2010-08-31 08:00:00 | AAPL | Stock | 8.6396 | 8.65 | 8.635 | 8.65 | 65184.0 |
| 2010-08-31 08:01:00 | AAPL | Stock | 8.6518 | 8.6536 | 8.6518 | 8.6536 | 42224.0 |
| 2010-08-31 08:02:00 | AAPL | Stock | 8.6536 | 8.6536 | 8.6432 | 8.6432 | 11900.0 |
| 2010-08-31 08:04:00 | AAPL | Stock | 8.6514 | 8.6518 | 8.6429 | 8.6429 | 64400.0 |
| 2010-08-31 08:05:00 | AAPL | Stock | 8.6418 | 8.6425 | 8.6418 | 8.6425 | 55160.0 |
| 2010-08-31 08:08:00 | AAPL | Stock | 8.6425 | 8.6482 | 8.6425 | 8.6482 | 14840.0 |
| 2010-08-31 08:11:00 | AAPL | Stock | 8.6464 | 8.6464 | 8.6464 | 8.6464 | 3920.0 |
| 2010-08-31 08:13:00 | AAPL | Stock | 8.65 | 8.65 | 8.6393 | 8.6393 | 36372.0 |
| 2010-08-31 08:16:00 | AAPL | Stock | 8.635 | 8.635 | 8.635 | 8.635 | 4200.0 |
| 2010-08-31 08:17:00 | AAPL | Stock | 8.635 | 8.635 | 8.6304 | 8.6321 | 11200.0 |
| 2010-08-31 08:18:00 | AAPL | Stock | 8.6286 | 8.6286 | 8.6286 | 8.6286 | 14000.0 |
| 2010-08-31 08:20:00 | AAPL | Stock | 8.6314 | 8.6429 | 8.6214 | 8.6218 | 91140.0 |
| 2010-08-31 08:21:00 | AAPL | Stock | 8.6218 | 8.625 | 8.6218 | 8.6218 | 33600.0 |
| 2010-08-31 08:22:00 | AAPL | Stock | 8.625 | 8.6321 | 8.625 | 8.6268 | 230188.0 |
| 2010-08-31 08:24:00 | AAPL | Stock | 8.63 | 8.63 | 8.63 | 8.63 | 2800.0 |
| 2010-08-31 08:25:00 | AAPL | Stock | 8.6296 | 8.6321 | 8.6296 | 8.6321 | 30520.0 |
| 2010-08-31 08:26:00 | AAPL | Stock | 8.6382 | 8.6382 | 8.6382 | 8.6382 | 2800.0 |
| 2010-08-31 08:27:00 | AAPL | Stock | 8.6379 | 8.6379 | 8.6379 | 8.6379 | 2800.0 |
| 2010-08-31 08:29:00 | AAPL | Stock | 8.6357 | 8.6357 | 8.6357 | 8.6357 | 5600.0 |
| 2010-08-31 08:30:00 | AAPL | Stock | 8.6293 | 8.6321 | 8.6293 | 8.6321 | 10220.0 |
| 2010-08-31 08:31:00 | AAPL | Stock | 8.6271 | 8.6271 | 8.6268 | 8.6268 | 5600.0 |
| 2010-08-31 08:32:00 | AAPL | Stock | 8.6271 | 8.6271 | 8.6179 | 8.6179 | 33600.0 |
| 2010-08-31 08:33:00 | AAPL | Stock | 8.6232 | 8.6232 | 8.6232 | 8.6232 | 2800.0 |
| 2010-08-31 08:34:00 | AAPL | Stock | 8.625 | 8.625 | 8.6204 | 8.6204 | 12600.0 |
| 2010-08-31 08:35:00 | AAPL | Stock | 8.6193 | 8.6225 | 8.6161 | 8.6161 | 40376.0 |
| 2010-08-31 08:36:00 | AAPL | Stock | 8.6161 | 8.6204 | 8.6007 | 8.6021 | 119840.0 |
| 2010-08-31 08:37:00 | AAPL | Stock | 8.5968 | 8.6004 | 8.5946 | 8.5946 | 22400.0 |
| 2010-08-31 08:38:00 | AAPL | Stock | 8.5979 | 8.5982 | 8.5975 | 8.5982 | 28000.0 |
| 2010-08-31 08:39:00 | AAPL | Stock | 8.5993 | 8.5996 | 8.5993 | 8.5996 | 8400.0 |
| 2010-08-31 08:40:00 | AAPL | Stock | 8.5993 | 8.6014 | 8.5993 | 8.6014 | 16184.0 |
| 2010-08-31 08:41:00 | AAPL | Stock | 8.5989 | 8.6021 | 8.5989 | 8.6021 | 60760.0 |
| 2010-08-31 08:42:00 | AAPL | Stock | 8.6021 | 8.6039 | 8.5964 | 8.5964 | 46760.0 |
| 2010-08-31 08:43:00 | AAPL | Stock | 8.5964 | 8.5971 | 8.5929 | 8.5932 | 14000.0 |
| 2010-08-31 08:44:00 | AAPL | Stock | 8.5929 | 8.5964 | 8.5893 | 8.5893 | 95256.0 |
> showing 50 of 958,358 rows — these rows as CSV