PREVIEW / stock_1min / 2012-11-05
file: by_date/stock_1min/2012/2012-11-05.parquet size: 12.3 MB rows: 920,477 symbols: 2,809
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 |
|---|---|---|---|---|---|---|---|
| 2012-11-05 04:00:00 | AAPL | Stock | 20.6 | 20.6 | 20.5357 | 20.5357 | 16800.0 |
| 2012-11-05 04:25:00 | AAPL | Stock | 20.52 | 20.52 | 20.52 | 20.52 | 2800.0 |
| 2012-11-05 04:38:00 | AAPL | Stock | 20.5 | 20.5 | 20.4943 | 20.4943 | 10836.0 |
| 2012-11-05 05:33:00 | AAPL | Stock | 20.4679 | 20.4679 | 20.4679 | 20.4679 | 2800.0 |
| 2012-11-05 05:35:00 | AAPL | Stock | 20.48 | 20.4836 | 20.48 | 20.4836 | 12460.0 |
| 2012-11-05 05:36:00 | AAPL | Stock | 20.48 | 20.48 | 20.48 | 20.48 | 2800.0 |
| 2012-11-05 05:39:00 | AAPL | Stock | 20.515 | 20.515 | 20.515 | 20.515 | 2800.0 |
| 2012-11-05 05:47:00 | AAPL | Stock | 20.4964 | 20.4964 | 20.4964 | 20.4964 | 2800.0 |
| 2012-11-05 05:51:00 | AAPL | Stock | 20.5179 | 20.5179 | 20.5179 | 20.5179 | 2800.0 |
| 2012-11-05 05:57:00 | AAPL | Stock | 20.5179 | 20.5179 | 20.5179 | 20.5179 | 5600.0 |
| 2012-11-05 05:58:00 | AAPL | Stock | 20.5179 | 20.5179 | 20.5179 | 20.5179 | 5600.0 |
| 2012-11-05 06:00:00 | AAPL | Stock | 20.5179 | 20.5179 | 20.5179 | 20.5179 | 2800.0 |
| 2012-11-05 06:07:00 | AAPL | Stock | 20.5125 | 20.5125 | 20.5125 | 20.5125 | 7000.0 |
| 2012-11-05 06:26:00 | AAPL | Stock | 20.5357 | 20.5357 | 20.5357 | 20.5357 | 2800.0 |
| 2012-11-05 06:28:00 | AAPL | Stock | 20.5393 | 20.5393 | 20.5393 | 20.5393 | 5600.0 |
| 2012-11-05 06:31:00 | AAPL | Stock | 20.5575 | 20.5604 | 20.5575 | 20.5604 | 11200.0 |
| 2012-11-05 06:32:00 | AAPL | Stock | 20.5575 | 20.5575 | 20.5575 | 20.5575 | 2800.0 |
| 2012-11-05 06:35:00 | AAPL | Stock | 20.5389 | 20.5389 | 20.5389 | 20.5389 | 2800.0 |
| 2012-11-05 06:39:00 | AAPL | Stock | 20.5357 | 20.5357 | 20.5357 | 20.5357 | 8260.0 |
| 2012-11-05 06:47:00 | AAPL | Stock | 20.5357 | 20.5357 | 20.5357 | 20.5357 | 2800.0 |
| 2012-11-05 06:49:00 | AAPL | Stock | 20.5357 | 20.5357 | 20.5357 | 20.5357 | 7000.0 |
| 2012-11-05 06:55:00 | AAPL | Stock | 20.5304 | 20.5304 | 20.5304 | 20.5304 | 13244.0 |
| 2012-11-05 07:00:00 | AAPL | Stock | 20.5179 | 20.5357 | 20.5179 | 20.5179 | 16800.0 |
| 2012-11-05 07:04:00 | AAPL | Stock | 20.5221 | 20.5221 | 20.5221 | 20.5221 | 2800.0 |
| 2012-11-05 07:05:00 | AAPL | Stock | 20.5214 | 20.5214 | 20.5214 | 20.5214 | 33880.0 |
| 2012-11-05 07:06:00 | AAPL | Stock | 20.52 | 20.52 | 20.5179 | 20.5179 | 24920.0 |
| 2012-11-05 07:07:00 | AAPL | Stock | 20.5175 | 20.5179 | 20.5093 | 20.5179 | 22120.0 |
| 2012-11-05 07:10:00 | AAPL | Stock | 20.5093 | 20.5093 | 20.5 | 20.5 | 5600.0 |
| 2012-11-05 07:13:00 | AAPL | Stock | 20.5039 | 20.5039 | 20.5039 | 20.5039 | 13580.0 |
| 2012-11-05 07:16:00 | AAPL | Stock | 20.5 | 20.5 | 20.5 | 20.5 | 9576.0 |
| 2012-11-05 07:17:00 | AAPL | Stock | 20.5 | 20.5 | 20.5 | 20.5 | 14812.0 |
| 2012-11-05 07:18:00 | AAPL | Stock | 20.5 | 20.5121 | 20.5 | 20.5121 | 22400.0 |
| 2012-11-05 07:20:00 | AAPL | Stock | 20.4993 | 20.5 | 20.4993 | 20.5 | 6580.0 |
| 2012-11-05 07:21:00 | AAPL | Stock | 20.5004 | 20.5004 | 20.5 | 20.5 | 18620.0 |
| 2012-11-05 07:22:00 | AAPL | Stock | 20.4911 | 20.5 | 20.48 | 20.4821 | 66780.0 |
| 2012-11-05 07:23:00 | AAPL | Stock | 20.4857 | 20.4857 | 20.48 | 20.48 | 30800.0 |
| 2012-11-05 07:24:00 | AAPL | Stock | 20.48 | 20.48 | 20.4643 | 20.4643 | 39340.0 |
| 2012-11-05 07:25:00 | AAPL | Stock | 20.4643 | 20.4821 | 20.4643 | 20.4821 | 5600.0 |
| 2012-11-05 07:27:00 | AAPL | Stock | 20.4786 | 20.4786 | 20.4682 | 20.4682 | 5600.0 |
| 2012-11-05 07:28:00 | AAPL | Stock | 20.4679 | 20.4679 | 20.4679 | 20.4679 | 2800.0 |
| 2012-11-05 07:29:00 | AAPL | Stock | 20.4679 | 20.4679 | 20.4679 | 20.4679 | 4060.0 |
| 2012-11-05 07:30:00 | AAPL | Stock | 20.4643 | 20.4732 | 20.4464 | 20.4732 | 58128.0 |
| 2012-11-05 07:31:00 | AAPL | Stock | 20.4518 | 20.4518 | 20.4518 | 20.4518 | 2800.0 |
| 2012-11-05 07:32:00 | AAPL | Stock | 20.4486 | 20.4486 | 20.4446 | 20.4446 | 25200.0 |
| 2012-11-05 07:35:00 | AAPL | Stock | 20.4321 | 20.4393 | 20.4286 | 20.4286 | 75880.0 |
| 2012-11-05 07:36:00 | AAPL | Stock | 20.4282 | 20.4289 | 20.4143 | 20.4143 | 62356.0 |
| 2012-11-05 07:37:00 | AAPL | Stock | 20.4143 | 20.4143 | 20.3821 | 20.3929 | 186956.0 |
| 2012-11-05 07:38:00 | AAPL | Stock | 20.3929 | 20.3964 | 20.3829 | 20.3829 | 43680.0 |
| 2012-11-05 07:39:00 | AAPL | Stock | 20.3829 | 20.3929 | 20.3821 | 20.3929 | 94444.0 |
| 2012-11-05 07:40:00 | AAPL | Stock | 20.3921 | 20.3929 | 20.3918 | 20.3918 | 23072.0 |
> showing 50 of 920,477 rows — these rows as CSV