PREVIEW / stock_5min / 2012-06-29
file: by_date/stock_5min/2012/2012-06-29.parquet size: 5.0 MB rows: 340,390 symbols: 3,540
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-29 04:00:00 | AAPL | Stock | 20.3393 | 20.4643 | 20.3393 | 20.4643 | 58800.0 |
| 2012-06-29 04:15:00 | AAPL | Stock | 20.4496 | 20.4496 | 20.4496 | 20.4496 | 2800.0 |
| 2012-06-29 05:00:00 | AAPL | Stock | 20.4554 | 20.4554 | 20.4554 | 20.4554 | 5600.0 |
| 2012-06-29 05:15:00 | AAPL | Stock | 20.4514 | 20.4514 | 20.4514 | 20.4514 | 6440.0 |
| 2012-06-29 05:25:00 | AAPL | Stock | 20.4286 | 20.4286 | 20.4286 | 20.4286 | 2800.0 |
| 2012-06-29 05:45:00 | AAPL | Stock | 20.4514 | 20.4514 | 20.4514 | 20.4514 | 2800.0 |
| 2012-06-29 05:50:00 | AAPL | Stock | 20.4514 | 20.4539 | 20.4514 | 20.4539 | 16800.0 |
| 2012-06-29 06:00:00 | AAPL | Stock | 20.4464 | 20.4643 | 20.4464 | 20.4643 | 12600.0 |
| 2012-06-29 06:05:00 | AAPL | Stock | 20.4839 | 20.4839 | 20.4839 | 20.4839 | 5600.0 |
| 2012-06-29 06:10:00 | AAPL | Stock | 20.4729 | 20.4732 | 20.4729 | 20.4732 | 8400.0 |
| 2012-06-29 06:15:00 | AAPL | Stock | 20.4607 | 20.4607 | 20.4607 | 20.4607 | 4200.0 |
| 2012-06-29 06:20:00 | AAPL | Stock | 20.4614 | 20.4836 | 20.4607 | 20.475 | 25200.0 |
| 2012-06-29 06:35:00 | AAPL | Stock | 20.4689 | 20.4689 | 20.4621 | 20.4621 | 8400.0 |
| 2012-06-29 06:40:00 | AAPL | Stock | 20.4646 | 20.4646 | 20.4646 | 20.4646 | 2800.0 |
| 2012-06-29 07:00:00 | AAPL | Stock | 20.4732 | 20.4911 | 20.4646 | 20.4821 | 98084.0 |
| 2012-06-29 07:05:00 | AAPL | Stock | 20.4929 | 20.4946 | 20.4821 | 20.4929 | 37240.0 |
| 2012-06-29 07:10:00 | AAPL | Stock | 20.4929 | 20.4929 | 20.4821 | 20.4821 | 5600.0 |
| 2012-06-29 07:15:00 | AAPL | Stock | 20.4825 | 20.4871 | 20.475 | 20.4793 | 74732.0 |
| 2012-06-29 07:20:00 | AAPL | Stock | 20.4821 | 20.4832 | 20.4821 | 20.4832 | 5600.0 |
| 2012-06-29 07:25:00 | AAPL | Stock | 20.4918 | 20.5354 | 20.4907 | 20.535 | 60900.0 |
| 2012-06-29 07:30:00 | AAPL | Stock | 20.5218 | 20.5236 | 20.5011 | 20.5011 | 89544.0 |
| 2012-06-29 07:35:00 | AAPL | Stock | 20.4986 | 20.4993 | 20.4911 | 20.4911 | 14000.0 |
| 2012-06-29 07:40:00 | AAPL | Stock | 20.4875 | 20.5 | 20.4821 | 20.4871 | 78064.0 |
| 2012-06-29 07:45:00 | AAPL | Stock | 20.5 | 20.5089 | 20.4932 | 20.4932 | 178948.0 |
| 2012-06-29 07:50:00 | AAPL | Stock | 20.4936 | 20.4989 | 20.49 | 20.4939 | 171304.0 |
| 2012-06-29 07:55:00 | AAPL | Stock | 20.4989 | 20.5179 | 20.4989 | 20.5107 | 104356.0 |
| 2012-06-29 08:00:00 | AAPL | Stock | 20.5107 | 20.5318 | 20.4893 | 20.4946 | 420308.0 |
| 2012-06-29 08:05:00 | AAPL | Stock | 20.5225 | 20.525 | 20.5164 | 20.5164 | 255080.0 |
| 2012-06-29 08:10:00 | AAPL | Stock | 20.5179 | 20.525 | 20.5018 | 20.5161 | 318024.0 |
| 2012-06-29 08:15:00 | AAPL | Stock | 20.5179 | 20.5393 | 20.5143 | 20.5393 | 576492.0 |
| 2012-06-29 08:20:00 | AAPL | Stock | 20.5407 | 20.5786 | 20.5357 | 20.5746 | 647584.0 |
| 2012-06-29 08:25:00 | AAPL | Stock | 20.5725 | 20.5982 | 20.5714 | 20.5968 | 753732.0 |
| 2012-06-29 08:30:00 | AAPL | Stock | 20.5893 | 20.6079 | 20.5796 | 20.6071 | 520996.0 |
| 2012-06-29 08:35:00 | AAPL | Stock | 20.6057 | 20.6175 | 20.6036 | 20.6111 | 475496.0 |
| 2012-06-29 08:40:00 | AAPL | Stock | 20.6143 | 20.6429 | 20.6093 | 20.6304 | 732872.0 |
| 2012-06-29 08:45:00 | AAPL | Stock | 20.6339 | 20.6525 | 20.6321 | 20.6357 | 417452.0 |
| 2012-06-29 08:50:00 | AAPL | Stock | 20.6321 | 20.6321 | 20.6211 | 20.6304 | 343196.0 |
| 2012-06-29 08:55:00 | AAPL | Stock | 20.6286 | 20.6329 | 20.6086 | 20.6086 | 249060.0 |
| 2012-06-29 09:00:00 | AAPL | Stock | 20.6161 | 20.6271 | 20.5971 | 20.6071 | 679728.0 |
| 2012-06-29 09:05:00 | AAPL | Stock | 20.6132 | 20.6607 | 20.6104 | 20.6607 | 512680.0 |
| 2012-06-29 09:10:00 | AAPL | Stock | 20.625 | 20.6386 | 20.6221 | 20.6357 | 281904.0 |
| 2012-06-29 09:15:00 | AAPL | Stock | 20.6325 | 20.635 | 20.6096 | 20.6096 | 272020.0 |
| 2012-06-29 09:20:00 | AAPL | Stock | 20.61 | 20.6196 | 20.6071 | 20.6161 | 138488.0 |
| 2012-06-29 09:25:00 | AAPL | Stock | 20.6129 | 20.6507 | 20.6071 | 20.6429 | 647752.0 |
| 2012-06-29 09:30:00 | AAPL | Stock | 20.6429 | 20.6486 | 20.5586 | 20.5664 | 21880488.0 |
| 2012-06-29 09:35:00 | AAPL | Stock | 20.5692 | 20.5746 | 20.5479 | 20.5558 | 8804180.0 |
| 2012-06-29 09:40:00 | AAPL | Stock | 20.5586 | 20.5639 | 20.5357 | 20.5386 | 7117208.0 |
| 2012-06-29 09:45:00 | AAPL | Stock | 20.5361 | 20.5482 | 20.5089 | 20.5321 | 8475936.0 |
| 2012-06-29 09:50:00 | AAPL | Stock | 20.5307 | 20.5461 | 20.5189 | 20.5446 | 6668676.0 |
| 2012-06-29 09:55:00 | AAPL | Stock | 20.5439 | 20.5746 | 20.5357 | 20.5637 | 8511020.0 |
> showing 50 of 340,390 rows — these rows as CSV