PREVIEW / stock_1min / 2012-06-13
file: by_date/stock_1min/2012/2012-06-13.parquet size: 12.6 MB rows: 949,585 symbols: 2,817
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-06-13 05:06:00 | AAPL | Stock | 20.5775 | 20.5775 | 20.5775 | 20.5775 | 2800.0 |
| 2012-06-13 05:07:00 | AAPL | Stock | 20.5775 | 20.5775 | 20.5775 | 20.5775 | 2800.0 |
| 2012-06-13 05:55:00 | AAPL | Stock | 20.5454 | 20.5454 | 20.5454 | 20.5454 | 11200.0 |
| 2012-06-13 07:00:00 | AAPL | Stock | 20.5893 | 20.5893 | 20.5893 | 20.5893 | 5600.0 |
| 2012-06-13 07:08:00 | AAPL | Stock | 20.5571 | 20.5571 | 20.5393 | 20.5393 | 18200.0 |
| 2012-06-13 07:10:00 | AAPL | Stock | 20.5446 | 20.5446 | 20.5446 | 20.5446 | 2800.0 |
| 2012-06-13 07:19:00 | AAPL | Stock | 20.5446 | 20.5446 | 20.5446 | 20.5446 | 2800.0 |
| 2012-06-13 07:20:00 | AAPL | Stock | 20.5464 | 20.5464 | 20.5464 | 20.5464 | 2800.0 |
| 2012-06-13 07:25:00 | AAPL | Stock | 20.54 | 20.54 | 20.54 | 20.54 | 2800.0 |
| 2012-06-13 07:37:00 | AAPL | Stock | 20.5357 | 20.5357 | 20.5357 | 20.5357 | 5600.0 |
| 2012-06-13 07:44:00 | AAPL | Stock | 20.5518 | 20.5536 | 20.5518 | 20.5536 | 10780.0 |
| 2012-06-13 07:51:00 | AAPL | Stock | 20.5643 | 20.5643 | 20.5643 | 20.5643 | 2800.0 |
| 2012-06-13 07:52:00 | AAPL | Stock | 20.5536 | 20.5536 | 20.5536 | 20.5536 | 2800.0 |
| 2012-06-13 07:54:00 | AAPL | Stock | 20.5643 | 20.5679 | 20.5643 | 20.5679 | 8820.0 |
| 2012-06-13 07:56:00 | AAPL | Stock | 20.5736 | 20.5821 | 20.555 | 20.555 | 16800.0 |
| 2012-06-13 07:58:00 | AAPL | Stock | 20.575 | 20.575 | 20.575 | 20.575 | 2800.0 |
| 2012-06-13 07:59:00 | AAPL | Stock | 20.5714 | 20.5714 | 20.5714 | 20.5714 | 5600.0 |
| 2012-06-13 08:00:00 | AAPL | Stock | 20.5714 | 20.5746 | 20.5561 | 20.5589 | 58800.0 |
| 2012-06-13 08:01:00 | AAPL | Stock | 20.5625 | 20.57 | 20.5625 | 20.57 | 9968.0 |
| 2012-06-13 08:02:00 | AAPL | Stock | 20.5607 | 20.5607 | 20.5579 | 20.5579 | 11200.0 |
| 2012-06-13 08:03:00 | AAPL | Stock | 20.5546 | 20.5546 | 20.5511 | 20.5543 | 43708.0 |
| 2012-06-13 08:04:00 | AAPL | Stock | 20.5543 | 20.5543 | 20.5543 | 20.5543 | 53200.0 |
| 2012-06-13 08:05:00 | AAPL | Stock | 20.5539 | 20.5539 | 20.55 | 20.5536 | 14924.0 |
| 2012-06-13 08:06:00 | AAPL | Stock | 20.5536 | 20.5536 | 20.5475 | 20.5536 | 19600.0 |
| 2012-06-13 08:07:00 | AAPL | Stock | 20.5464 | 20.5464 | 20.5364 | 20.5396 | 81200.0 |
| 2012-06-13 08:08:00 | AAPL | Stock | 20.5371 | 20.5375 | 20.5371 | 20.5375 | 8260.0 |
| 2012-06-13 08:09:00 | AAPL | Stock | 20.5411 | 20.5411 | 20.5357 | 20.5357 | 5600.0 |
| 2012-06-13 08:10:00 | AAPL | Stock | 20.5375 | 20.5461 | 20.5375 | 20.5461 | 33600.0 |
| 2012-06-13 08:11:00 | AAPL | Stock | 20.5464 | 20.5529 | 20.5368 | 20.5368 | 54880.0 |
| 2012-06-13 08:12:00 | AAPL | Stock | 20.5375 | 20.5375 | 20.5321 | 20.5321 | 50540.0 |
| 2012-06-13 08:13:00 | AAPL | Stock | 20.5182 | 20.5321 | 20.5046 | 20.5264 | 55440.0 |
| 2012-06-13 08:14:00 | AAPL | Stock | 20.5111 | 20.5207 | 20.5107 | 20.5207 | 17780.0 |
| 2012-06-13 08:15:00 | AAPL | Stock | 20.505 | 20.505 | 20.4821 | 20.4918 | 155960.0 |
| 2012-06-13 08:16:00 | AAPL | Stock | 20.5 | 20.5036 | 20.4929 | 20.4929 | 28000.0 |
| 2012-06-13 08:17:00 | AAPL | Stock | 20.4857 | 20.4971 | 20.4857 | 20.4971 | 8400.0 |
| 2012-06-13 08:18:00 | AAPL | Stock | 20.4971 | 20.4993 | 20.4821 | 20.4946 | 57848.0 |
| 2012-06-13 08:19:00 | AAPL | Stock | 20.4918 | 20.4982 | 20.4918 | 20.4982 | 13748.0 |
| 2012-06-13 08:20:00 | AAPL | Stock | 20.4964 | 20.4964 | 20.4946 | 20.4946 | 5768.0 |
| 2012-06-13 08:23:00 | AAPL | Stock | 20.4986 | 20.4986 | 20.4986 | 20.4986 | 6440.0 |
| 2012-06-13 08:24:00 | AAPL | Stock | 20.5018 | 20.5064 | 20.5018 | 20.5064 | 8400.0 |
| 2012-06-13 08:25:00 | AAPL | Stock | 20.5107 | 20.5107 | 20.5107 | 20.5107 | 22400.0 |
| 2012-06-13 08:26:00 | AAPL | Stock | 20.5011 | 20.5011 | 20.4957 | 20.4957 | 35448.0 |
| 2012-06-13 08:27:00 | AAPL | Stock | 20.4979 | 20.5036 | 20.4961 | 20.5004 | 32200.0 |
| 2012-06-13 08:29:00 | AAPL | Stock | 20.5036 | 20.5161 | 20.5036 | 20.5161 | 19460.0 |
| 2012-06-13 08:30:00 | AAPL | Stock | 20.5004 | 20.5032 | 20.4821 | 20.4954 | 217560.0 |
| 2012-06-13 08:31:00 | AAPL | Stock | 20.4961 | 20.5043 | 20.4911 | 20.4911 | 33152.0 |
| 2012-06-13 08:32:00 | AAPL | Stock | 20.4893 | 20.4911 | 20.4882 | 20.4911 | 12964.0 |
| 2012-06-13 08:33:00 | AAPL | Stock | 20.4864 | 20.4957 | 20.4864 | 20.4957 | 22400.0 |
| 2012-06-13 08:34:00 | AAPL | Stock | 20.4918 | 20.4979 | 20.4918 | 20.4979 | 14000.0 |
| 2012-06-13 08:35:00 | AAPL | Stock | 20.5004 | 20.5032 | 20.4964 | 20.4964 | 40152.0 |
> showing 50 of 949,585 rows — these rows as CSV