PREVIEW / stock_5min / 2012-06-13
file: by_date/stock_5min/2012/2012-06-13.parquet size: 4.7 MB rows: 324,449 symbols: 3,491
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:05:00 | AAPL | Stock | 20.5775 | 20.5775 | 20.5775 | 20.5775 | 5600.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:05: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:15: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:35:00 | AAPL | Stock | 20.5357 | 20.5357 | 20.5357 | 20.5357 | 5600.0 |
| 2012-06-13 07:40:00 | AAPL | Stock | 20.5518 | 20.5536 | 20.5518 | 20.5536 | 10780.0 |
| 2012-06-13 07:50:00 | AAPL | Stock | 20.5643 | 20.5679 | 20.5536 | 20.5679 | 14420.0 |
| 2012-06-13 07:55:00 | AAPL | Stock | 20.5736 | 20.5821 | 20.555 | 20.5714 | 25200.0 |
| 2012-06-13 08:00:00 | AAPL | Stock | 20.5714 | 20.5746 | 20.5511 | 20.5543 | 176876.0 |
| 2012-06-13 08:05:00 | AAPL | Stock | 20.5539 | 20.5539 | 20.5357 | 20.5357 | 129584.0 |
| 2012-06-13 08:10:00 | AAPL | Stock | 20.5375 | 20.5529 | 20.5046 | 20.5207 | 212240.0 |
| 2012-06-13 08:15:00 | AAPL | Stock | 20.505 | 20.505 | 20.4821 | 20.4982 | 263956.0 |
| 2012-06-13 08:20:00 | AAPL | Stock | 20.4964 | 20.5064 | 20.4946 | 20.5064 | 20608.0 |
| 2012-06-13 08:25:00 | AAPL | Stock | 20.5107 | 20.5161 | 20.4957 | 20.5161 | 109508.0 |
| 2012-06-13 08:30:00 | AAPL | Stock | 20.5004 | 20.5043 | 20.4821 | 20.4979 | 300076.0 |
| 2012-06-13 08:35:00 | AAPL | Stock | 20.5004 | 20.5296 | 20.4964 | 20.5218 | 98868.0 |
| 2012-06-13 08:40:00 | AAPL | Stock | 20.5239 | 20.5279 | 20.5 | 20.5 | 199360.0 |
| 2012-06-13 08:45:00 | AAPL | Stock | 20.51 | 20.5161 | 20.4893 | 20.5004 | 117320.0 |
| 2012-06-13 08:50:00 | AAPL | Stock | 20.5007 | 20.5143 | 20.5007 | 20.5071 | 22400.0 |
| 2012-06-13 08:55:00 | AAPL | Stock | 20.5054 | 20.5107 | 20.505 | 20.5079 | 19600.0 |
| 2012-06-13 09:00:00 | AAPL | Stock | 20.5146 | 20.515 | 20.4957 | 20.5 | 117796.0 |
| 2012-06-13 09:05:00 | AAPL | Stock | 20.4996 | 20.5 | 20.4896 | 20.4993 | 65464.0 |
| 2012-06-13 09:10:00 | AAPL | Stock | 20.4993 | 20.5036 | 20.4964 | 20.5032 | 58800.0 |
| 2012-06-13 09:15:00 | AAPL | Stock | 20.5004 | 20.5004 | 20.4929 | 20.4993 | 36120.0 |
| 2012-06-13 09:20:00 | AAPL | Stock | 20.4964 | 20.5 | 20.4914 | 20.4993 | 128464.0 |
| 2012-06-13 09:25:00 | AAPL | Stock | 20.4971 | 20.5282 | 20.4954 | 20.5282 | 264124.0 |
| 2012-06-13 09:30:00 | AAPL | Stock | 20.5271 | 20.5871 | 20.4736 | 20.5311 | 10698296.0 |
| 2012-06-13 09:35:00 | AAPL | Stock | 20.5296 | 20.5775 | 20.5254 | 20.561 | 7202132.0 |
| 2012-06-13 09:40:00 | AAPL | Stock | 20.565 | 20.6543 | 20.5414 | 20.6346 | 14006804.0 |
| 2012-06-13 09:45:00 | AAPL | Stock | 20.6321 | 20.6453 | 20.5807 | 20.6071 | 7717528.0 |
| 2012-06-13 09:50:00 | AAPL | Stock | 20.6043 | 20.6071 | 20.5236 | 20.5357 | 7954184.0 |
| 2012-06-13 09:55:00 | AAPL | Stock | 20.5357 | 20.5654 | 20.5286 | 20.5364 | 4890032.0 |
| 2012-06-13 10:00:00 | AAPL | Stock | 20.5364 | 20.5961 | 20.5325 | 20.5878 | 5371324.0 |
| 2012-06-13 10:05:00 | AAPL | Stock | 20.5843 | 20.5896 | 20.555 | 20.5682 | 3605280.0 |
| 2012-06-13 10:10:00 | AAPL | Stock | 20.5671 | 20.6161 | 20.5643 | 20.5989 | 5166644.0 |
| 2012-06-13 10:15:00 | AAPL | Stock | 20.5996 | 20.6121 | 20.5743 | 20.5864 | 3011736.0 |
| 2012-06-13 10:20:00 | AAPL | Stock | 20.5907 | 20.5954 | 20.5446 | 20.5466 | 5388152.0 |
| 2012-06-13 10:25:00 | AAPL | Stock | 20.5475 | 20.5707 | 20.5314 | 20.5657 | 2729552.0 |
| 2012-06-13 10:30:00 | AAPL | Stock | 20.5657 | 20.6071 | 20.56 | 20.6018 | 3433892.0 |
| 2012-06-13 10:35:00 | AAPL | Stock | 20.6011 | 20.6379 | 20.5864 | 20.6379 | 6040720.0 |
| 2012-06-13 10:40:00 | AAPL | Stock | 20.6393 | 20.6454 | 20.6186 | 20.635 | 4973304.0 |
| 2012-06-13 10:45:00 | AAPL | Stock | 20.6346 | 20.6429 | 20.595 | 20.6143 | 3971240.0 |
| 2012-06-13 10:50:00 | AAPL | Stock | 20.6142 | 20.6214 | 20.5986 | 20.6079 | 2177616.0 |
| 2012-06-13 10:55:00 | AAPL | Stock | 20.6079 | 20.66 | 20.6014 | 20.65 | 4970616.0 |
| 2012-06-13 11:00:00 | AAPL | Stock | 20.6489 | 20.6525 | 20.6071 | 20.6111 | 2791488.0 |
| 2012-06-13 11:05:00 | AAPL | Stock | 20.6136 | 20.6243 | 20.5875 | 20.6011 | 2801708.0 |
> showing 50 of 324,449 rows — these rows as CSV