PREVIEW / stock_1min / 2011-02-28
file: by_date/stock_1min/2011/2011-02-28.parquet size: 13.7 MB rows: 1,021,161 symbols: 2,886
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 |
|---|---|---|---|---|---|---|---|
| 2011-02-28 04:00:00 | AAPL | Stock | 12.5 | 12.5 | 12.5 | 12.5 | 12600.0 |
| 2011-02-28 04:02:00 | AAPL | Stock | 12.5064 | 12.5064 | 12.5046 | 12.5046 | 8400.0 |
| 2011-02-28 04:25:00 | AAPL | Stock | 12.5464 | 12.5464 | 12.5464 | 12.5464 | 2800.0 |
| 2011-02-28 04:29:00 | AAPL | Stock | 12.5671 | 12.5714 | 12.5671 | 12.5714 | 11200.0 |
| 2011-02-28 04:30:00 | AAPL | Stock | 12.5714 | 12.5714 | 12.57 | 12.57 | 14000.0 |
| 2011-02-28 04:34:00 | AAPL | Stock | 12.5761 | 12.5761 | 12.5761 | 12.5761 | 14000.0 |
| 2011-02-28 04:47:00 | AAPL | Stock | 12.5821 | 12.5821 | 12.5821 | 12.5821 | 5600.0 |
| 2011-02-28 05:06:00 | AAPL | Stock | 12.5643 | 12.5643 | 12.4464 | 12.4464 | 22820.0 |
| 2011-02-28 05:25:00 | AAPL | Stock | 12.5793 | 12.5793 | 12.5793 | 12.5793 | 2800.0 |
| 2011-02-28 05:27:00 | AAPL | Stock | 12.5704 | 12.5704 | 12.5704 | 12.5704 | 2800.0 |
| 2011-02-28 05:39:00 | AAPL | Stock | 12.5714 | 12.5714 | 12.5714 | 12.5714 | 5600.0 |
| 2011-02-28 05:40:00 | AAPL | Stock | 12.5714 | 12.5714 | 12.5714 | 12.5714 | 2800.0 |
| 2011-02-28 05:44:00 | AAPL | Stock | 12.5714 | 12.5714 | 12.5714 | 12.5714 | 2800.0 |
| 2011-02-28 05:51:00 | AAPL | Stock | 12.5714 | 12.5714 | 12.5714 | 12.5714 | 5600.0 |
| 2011-02-28 05:57:00 | AAPL | Stock | 12.575 | 12.575 | 12.575 | 12.575 | 2800.0 |
| 2011-02-28 06:06:00 | AAPL | Stock | 12.5732 | 12.5732 | 12.5732 | 12.5732 | 8400.0 |
| 2011-02-28 06:21:00 | AAPL | Stock | 12.5857 | 12.5861 | 12.5857 | 12.5861 | 5600.0 |
| 2011-02-28 06:31:00 | AAPL | Stock | 12.5821 | 12.5821 | 12.5821 | 12.5821 | 2800.0 |
| 2011-02-28 06:32:00 | AAPL | Stock | 12.5821 | 12.5821 | 12.5821 | 12.5821 | 2800.0 |
| 2011-02-28 06:34:00 | AAPL | Stock | 12.5721 | 12.5721 | 12.5718 | 12.5718 | 5600.0 |
| 2011-02-28 06:41:00 | AAPL | Stock | 12.5821 | 12.5821 | 12.5821 | 12.5821 | 2800.0 |
| 2011-02-28 06:49:00 | AAPL | Stock | 12.5718 | 12.5821 | 12.5714 | 12.5821 | 14000.0 |
| 2011-02-28 06:50:00 | AAPL | Stock | 12.5889 | 12.5889 | 12.5889 | 12.5889 | 2800.0 |
| 2011-02-28 07:00:00 | AAPL | Stock | 12.5804 | 12.5804 | 12.5804 | 12.5804 | 2800.0 |
| 2011-02-28 07:01:00 | AAPL | Stock | 12.5804 | 12.5804 | 12.5804 | 12.5804 | 11200.0 |
| 2011-02-28 07:02:00 | AAPL | Stock | 12.58 | 12.58 | 12.5679 | 12.5679 | 50092.0 |
| 2011-02-28 07:03:00 | AAPL | Stock | 12.5643 | 12.5643 | 12.5611 | 12.5611 | 5600.0 |
| 2011-02-28 07:04:00 | AAPL | Stock | 12.5711 | 12.5711 | 12.5711 | 12.5711 | 2800.0 |
| 2011-02-28 07:05:00 | AAPL | Stock | 12.5714 | 12.5714 | 12.5643 | 12.5643 | 8400.0 |
| 2011-02-28 07:06:00 | AAPL | Stock | 12.5607 | 12.5625 | 12.5607 | 12.5625 | 12040.0 |
| 2011-02-28 07:07:00 | AAPL | Stock | 12.5582 | 12.5582 | 12.5543 | 12.5543 | 8400.0 |
| 2011-02-28 07:08:00 | AAPL | Stock | 12.5536 | 12.5536 | 12.5536 | 12.5536 | 14000.0 |
| 2011-02-28 07:09:00 | AAPL | Stock | 12.5486 | 12.5486 | 12.5479 | 12.5482 | 23800.0 |
| 2011-02-28 07:10:00 | AAPL | Stock | 12.5536 | 12.5536 | 12.5536 | 12.5536 | 11200.0 |
| 2011-02-28 07:13:00 | AAPL | Stock | 12.55 | 12.55 | 12.5361 | 12.5396 | 40684.0 |
| 2011-02-28 07:14:00 | AAPL | Stock | 12.5357 | 12.5357 | 12.5357 | 12.5357 | 2800.0 |
| 2011-02-28 07:18:00 | AAPL | Stock | 12.5357 | 12.5357 | 12.5357 | 12.5357 | 14000.0 |
| 2011-02-28 07:19:00 | AAPL | Stock | 12.5357 | 12.5357 | 12.5357 | 12.5357 | 12124.0 |
| 2011-02-28 07:20:00 | AAPL | Stock | 12.5289 | 12.5289 | 12.5286 | 12.5286 | 19600.0 |
| 2011-02-28 07:21:00 | AAPL | Stock | 12.535 | 12.535 | 12.525 | 12.5271 | 35000.0 |
| 2011-02-28 07:26:00 | AAPL | Stock | 12.5257 | 12.5257 | 12.525 | 12.525 | 22400.0 |
| 2011-02-28 07:27:00 | AAPL | Stock | 12.5214 | 12.5214 | 12.5214 | 12.5214 | 4340.0 |
| 2011-02-28 07:28:00 | AAPL | Stock | 12.5186 | 12.5186 | 12.5186 | 12.5186 | 7140.0 |
| 2011-02-28 07:29:00 | AAPL | Stock | 12.525 | 12.525 | 12.525 | 12.525 | 8400.0 |
| 2011-02-28 07:30:00 | AAPL | Stock | 12.525 | 12.525 | 12.525 | 12.525 | 5600.0 |
| 2011-02-28 07:34:00 | AAPL | Stock | 12.5343 | 12.5357 | 12.5254 | 12.5354 | 41860.0 |
| 2011-02-28 07:35:00 | AAPL | Stock | 12.5357 | 12.5357 | 12.5357 | 12.5357 | 33012.0 |
| 2011-02-28 07:36:00 | AAPL | Stock | 12.5357 | 12.5421 | 12.5357 | 12.5421 | 15932.0 |
| 2011-02-28 07:37:00 | AAPL | Stock | 12.5304 | 12.5304 | 12.5304 | 12.5304 | 22400.0 |
| 2011-02-28 07:38:00 | AAPL | Stock | 12.5336 | 12.5336 | 12.5336 | 12.5336 | 2800.0 |
> showing 50 of 1,021,161 rows — these rows as CSV