PREVIEW / stock_1min / 2010-06-25
file: by_date/stock_1min/2010/2010-06-25.parquet size: 14.9 MB rows: 1,106,487 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-06-25 05:11:00 | AAPL | Stock | 9.6111 | 9.6111 | 9.6111 | 9.6111 | 2800.0 |
| 2010-06-25 05:21:00 | AAPL | Stock | 9.5989 | 9.5989 | 9.5989 | 9.5989 | 2800.0 |
| 2010-06-25 05:49:00 | AAPL | Stock | 9.5896 | 9.5896 | 9.5896 | 9.5896 | 2800.0 |
| 2010-06-25 06:03:00 | AAPL | Stock | 9.5825 | 9.5825 | 9.5754 | 9.5754 | 22400.0 |
| 2010-06-25 06:13:00 | AAPL | Stock | 9.5736 | 9.5736 | 9.5736 | 9.5736 | 16800.0 |
| 2010-06-25 06:15:00 | AAPL | Stock | 9.5711 | 9.5711 | 9.5711 | 9.5711 | 7588.0 |
| 2010-06-25 06:41:00 | AAPL | Stock | 9.6004 | 9.6004 | 9.6004 | 9.6004 | 2800.0 |
| 2010-06-25 07:00:00 | AAPL | Stock | 9.635 | 9.6357 | 9.635 | 9.6357 | 9100.0 |
| 2010-06-25 07:06:00 | AAPL | Stock | 9.6168 | 9.6179 | 9.6168 | 9.6179 | 5600.0 |
| 2010-06-25 07:11:00 | AAPL | Stock | 9.625 | 9.625 | 9.6182 | 9.6182 | 44800.0 |
| 2010-06-25 07:12:00 | AAPL | Stock | 9.6357 | 9.6361 | 9.6357 | 9.6361 | 5600.0 |
| 2010-06-25 07:13:00 | AAPL | Stock | 9.6375 | 9.6375 | 9.6375 | 9.6375 | 2800.0 |
| 2010-06-25 07:15:00 | AAPL | Stock | 9.6261 | 9.6429 | 9.6261 | 9.6379 | 39200.0 |
| 2010-06-25 07:18:00 | AAPL | Stock | 9.6336 | 9.6382 | 9.6336 | 9.6382 | 19320.0 |
| 2010-06-25 07:23:00 | AAPL | Stock | 9.6343 | 9.6343 | 9.6343 | 9.6343 | 2800.0 |
| 2010-06-25 07:25:00 | AAPL | Stock | 9.6379 | 9.6379 | 9.6379 | 9.6379 | 4200.0 |
| 2010-06-25 07:27:00 | AAPL | Stock | 9.6379 | 9.6379 | 9.6339 | 9.6343 | 14000.0 |
| 2010-06-25 07:30:00 | AAPL | Stock | 9.6429 | 9.6429 | 9.6429 | 9.6429 | 2800.0 |
| 2010-06-25 07:32:00 | AAPL | Stock | 9.6586 | 9.6704 | 9.6586 | 9.6704 | 27636.0 |
| 2010-06-25 07:33:00 | AAPL | Stock | 9.67 | 9.6711 | 9.67 | 9.6711 | 14000.0 |
| 2010-06-25 07:35:00 | AAPL | Stock | 9.6711 | 9.6711 | 9.6711 | 9.6711 | 2800.0 |
| 2010-06-25 07:36:00 | AAPL | Stock | 9.6557 | 9.6618 | 9.6554 | 9.6575 | 63000.0 |
| 2010-06-25 07:37:00 | AAPL | Stock | 9.6693 | 9.6693 | 9.6693 | 9.6693 | 11200.0 |
| 2010-06-25 07:38:00 | AAPL | Stock | 9.665 | 9.665 | 9.6625 | 9.6625 | 5600.0 |
| 2010-06-25 07:39:00 | AAPL | Stock | 9.6679 | 9.6679 | 9.6607 | 9.6675 | 22400.0 |
| 2010-06-25 07:40:00 | AAPL | Stock | 9.6625 | 9.6625 | 9.6607 | 9.6607 | 16800.0 |
| 2010-06-25 07:44:00 | AAPL | Stock | 9.6643 | 9.6643 | 9.6643 | 9.6643 | 2800.0 |
| 2010-06-25 07:50:00 | AAPL | Stock | 9.6696 | 9.6696 | 9.665 | 9.665 | 14000.0 |
| 2010-06-25 07:53:00 | AAPL | Stock | 9.6632 | 9.6632 | 9.6607 | 9.6607 | 11200.0 |
| 2010-06-25 07:54:00 | AAPL | Stock | 9.6607 | 9.6607 | 9.6607 | 9.6607 | 11200.0 |
| 2010-06-25 07:57:00 | AAPL | Stock | 9.6571 | 9.6571 | 9.6521 | 9.6521 | 5600.0 |
| 2010-06-25 08:00:00 | AAPL | Stock | 9.6625 | 9.6629 | 9.65 | 9.6604 | 44800.0 |
| 2010-06-25 08:02:00 | AAPL | Stock | 9.6518 | 9.6518 | 9.6357 | 9.6364 | 72100.0 |
| 2010-06-25 08:03:00 | AAPL | Stock | 9.6429 | 9.6429 | 9.6293 | 9.6293 | 38220.0 |
| 2010-06-25 08:04:00 | AAPL | Stock | 9.6311 | 9.6346 | 9.6296 | 9.6336 | 30800.0 |
| 2010-06-25 08:05:00 | AAPL | Stock | 9.6345 | 9.6364 | 9.6343 | 9.6364 | 47180.0 |
| 2010-06-25 08:06:00 | AAPL | Stock | 9.6429 | 9.6429 | 9.6411 | 9.6411 | 13468.0 |
| 2010-06-25 08:07:00 | AAPL | Stock | 9.64 | 9.6407 | 9.6389 | 9.6407 | 30800.0 |
| 2010-06-25 08:08:00 | AAPL | Stock | 9.6393 | 9.6407 | 9.6357 | 9.6386 | 58800.0 |
| 2010-06-25 08:09:00 | AAPL | Stock | 9.6389 | 9.6389 | 9.6386 | 9.6386 | 8400.0 |
| 2010-06-25 08:10:00 | AAPL | Stock | 9.6362 | 9.6387 | 9.6357 | 9.6357 | 22400.0 |
| 2010-06-25 08:11:00 | AAPL | Stock | 9.6357 | 9.6357 | 9.6321 | 9.6339 | 88760.0 |
| 2010-06-25 08:12:00 | AAPL | Stock | 9.6321 | 9.6321 | 9.6307 | 9.6321 | 28056.0 |
| 2010-06-25 08:13:00 | AAPL | Stock | 9.6307 | 9.6334 | 9.6307 | 9.6334 | 5600.0 |
| 2010-06-25 08:14:00 | AAPL | Stock | 9.6332 | 9.6332 | 9.6307 | 9.6307 | 46060.0 |
| 2010-06-25 08:15:00 | AAPL | Stock | 9.63 | 9.6304 | 9.63 | 9.6304 | 19600.0 |
| 2010-06-25 08:16:00 | AAPL | Stock | 9.6314 | 9.6354 | 9.6304 | 9.6354 | 51660.0 |
| 2010-06-25 08:17:00 | AAPL | Stock | 9.6314 | 9.6354 | 9.6314 | 9.6336 | 66304.0 |
| 2010-06-25 08:18:00 | AAPL | Stock | 9.6339 | 9.6339 | 9.6332 | 9.6332 | 16800.0 |
| 2010-06-25 08:19:00 | AAPL | Stock | 9.6354 | 9.6379 | 9.6354 | 9.6379 | 34524.0 |
> showing 50 of 1,106,487 rows — these rows as CSV