PREVIEW / stock_1min / 2010-01-07
file: by_date/stock_1min/2010/2010-01-07.parquet size: 12.8 MB rows: 958,839 symbols: 2,796
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-01-07 06:56:00 | AAPL | Stock | 7.5357 | 7.5361 | 7.5357 | 7.5361 | 5600.0 |
| 2010-01-07 07:03:00 | AAPL | Stock | 7.5532 | 7.5532 | 7.5532 | 7.5532 | 4200.0 |
| 2010-01-07 07:07:00 | AAPL | Stock | 7.5429 | 7.5429 | 7.5429 | 7.5429 | 2800.0 |
| 2010-01-07 07:09:00 | AAPL | Stock | 7.5429 | 7.5429 | 7.5429 | 7.5429 | 5600.0 |
| 2010-01-07 07:13:00 | AAPL | Stock | 7.5482 | 7.5482 | 7.5482 | 7.5482 | 42000.0 |
| 2010-01-07 07:32:00 | AAPL | Stock | 7.5518 | 7.5518 | 7.5518 | 7.5518 | 16800.0 |
| 2010-01-07 07:41:00 | AAPL | Stock | 7.5489 | 7.5489 | 7.5482 | 7.5482 | 8400.0 |
| 2010-01-07 07:42:00 | AAPL | Stock | 7.5482 | 7.5482 | 7.5482 | 7.5482 | 179200.0 |
| 2010-01-07 07:44:00 | AAPL | Stock | 7.5482 | 7.5482 | 7.5482 | 7.5482 | 20720.0 |
| 2010-01-07 07:48:00 | AAPL | Stock | 7.5482 | 7.5482 | 7.5482 | 7.5482 | 2800.0 |
| 2010-01-07 07:49:00 | AAPL | Stock | 7.5414 | 7.5414 | 7.5414 | 7.5414 | 14000.0 |
| 2010-01-07 07:50:00 | AAPL | Stock | 7.5482 | 7.5482 | 7.5482 | 7.5482 | 16800.0 |
| 2010-01-07 07:57:00 | AAPL | Stock | 7.5482 | 7.5482 | 7.5482 | 7.5482 | 2800.0 |
| 2010-01-07 07:58:00 | AAPL | Stock | 7.5414 | 7.5414 | 7.5414 | 7.5414 | 8400.0 |
| 2010-01-07 08:00:00 | AAPL | Stock | 7.5496 | 7.55 | 7.5414 | 7.55 | 66668.0 |
| 2010-01-07 08:01:00 | AAPL | Stock | 7.5482 | 7.5482 | 7.5446 | 7.5446 | 31080.0 |
| 2010-01-07 08:02:00 | AAPL | Stock | 7.5479 | 7.5482 | 7.5446 | 7.5482 | 17080.0 |
| 2010-01-07 08:03:00 | AAPL | Stock | 7.5468 | 7.5482 | 7.545 | 7.545 | 16520.0 |
| 2010-01-07 08:04:00 | AAPL | Stock | 7.5454 | 7.55 | 7.5454 | 7.55 | 5600.0 |
| 2010-01-07 08:05:00 | AAPL | Stock | 7.5482 | 7.5496 | 7.5446 | 7.5486 | 17388.0 |
| 2010-01-07 08:06:00 | AAPL | Stock | 7.5496 | 7.5496 | 7.5468 | 7.5468 | 22960.0 |
| 2010-01-07 08:08:00 | AAPL | Stock | 7.5468 | 7.5468 | 7.5468 | 7.5468 | 7812.0 |
| 2010-01-07 08:09:00 | AAPL | Stock | 7.5493 | 7.55 | 7.5493 | 7.55 | 19292.0 |
| 2010-01-07 08:11:00 | AAPL | Stock | 7.5446 | 7.5471 | 7.5446 | 7.5471 | 5600.0 |
| 2010-01-07 08:12:00 | AAPL | Stock | 7.5482 | 7.5482 | 7.5482 | 7.5482 | 8400.0 |
| 2010-01-07 08:13:00 | AAPL | Stock | 7.5496 | 7.5496 | 7.5446 | 7.5464 | 126000.0 |
| 2010-01-07 08:14:00 | AAPL | Stock | 7.545 | 7.5464 | 7.5446 | 7.5461 | 44800.0 |
| 2010-01-07 08:15:00 | AAPL | Stock | 7.5425 | 7.545 | 7.5354 | 7.545 | 232260.0 |
| 2010-01-07 08:16:00 | AAPL | Stock | 7.5393 | 7.5393 | 7.5393 | 7.5393 | 4200.0 |
| 2010-01-07 08:17:00 | AAPL | Stock | 7.5396 | 7.5396 | 7.5393 | 7.5393 | 42000.0 |
| 2010-01-07 08:18:00 | AAPL | Stock | 7.5396 | 7.5396 | 7.5396 | 7.5396 | 5600.0 |
| 2010-01-07 08:20:00 | AAPL | Stock | 7.5443 | 7.5446 | 7.5443 | 7.5446 | 16800.0 |
| 2010-01-07 08:21:00 | AAPL | Stock | 7.5443 | 7.5486 | 7.5443 | 7.5482 | 18424.0 |
| 2010-01-07 08:22:00 | AAPL | Stock | 7.5496 | 7.5496 | 7.5446 | 7.5446 | 61600.0 |
| 2010-01-07 08:23:00 | AAPL | Stock | 7.55 | 7.55 | 7.55 | 7.55 | 8400.0 |
| 2010-01-07 08:24:00 | AAPL | Stock | 7.5468 | 7.5468 | 7.5468 | 7.5468 | 5040.0 |
| 2010-01-07 08:25:00 | AAPL | Stock | 7.5468 | 7.5496 | 7.5468 | 7.5496 | 29960.0 |
| 2010-01-07 08:26:00 | AAPL | Stock | 7.5475 | 7.55 | 7.5475 | 7.55 | 40600.0 |
| 2010-01-07 08:27:00 | AAPL | Stock | 7.5496 | 7.5496 | 7.5496 | 7.5496 | 7000.0 |
| 2010-01-07 08:28:00 | AAPL | Stock | 7.55 | 7.55 | 7.55 | 7.55 | 4200.0 |
| 2010-01-07 08:29:00 | AAPL | Stock | 7.5471 | 7.55 | 7.5471 | 7.55 | 5600.0 |
| 2010-01-07 08:31:00 | AAPL | Stock | 7.5468 | 7.5468 | 7.5464 | 7.5464 | 5740.0 |
| 2010-01-07 08:32:00 | AAPL | Stock | 7.5468 | 7.5468 | 7.5464 | 7.5464 | 41160.0 |
| 2010-01-07 08:33:00 | AAPL | Stock | 7.5496 | 7.5496 | 7.5471 | 7.5471 | 8400.0 |
| 2010-01-07 08:34:00 | AAPL | Stock | 7.5475 | 7.5554 | 7.5475 | 7.5554 | 137508.0 |
| 2010-01-07 08:35:00 | AAPL | Stock | 7.5554 | 7.5554 | 7.5504 | 7.5511 | 85820.0 |
| 2010-01-07 08:36:00 | AAPL | Stock | 7.5546 | 7.5546 | 7.5546 | 7.5546 | 2800.0 |
| 2010-01-07 08:37:00 | AAPL | Stock | 7.5518 | 7.5604 | 7.5518 | 7.5604 | 91924.0 |
| 2010-01-07 08:38:00 | AAPL | Stock | 7.5636 | 7.5639 | 7.5596 | 7.5639 | 74592.0 |
| 2010-01-07 08:39:00 | AAPL | Stock | 7.5639 | 7.5668 | 7.5629 | 7.5657 | 63000.0 |
> showing 50 of 958,839 rows — these rows as CSV