PREVIEW / stock_5min / 2012-10-12
file: by_date/stock_5min/2012/2012-10-12.parquet size: 4.5 MB rows: 303,208 symbols: 3,441
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-10-12 06:45:00 | AAPL | Stock | 22.4886 | 22.4893 | 22.4886 | 22.4893 | 10640.0 |
| 2012-10-12 06:55:00 | AAPL | Stock | 22.5 | 22.5107 | 22.5 | 22.5107 | 14812.0 |
| 2012-10-12 07:00:00 | AAPL | Stock | 22.5107 | 22.5107 | 22.4893 | 22.4893 | 44800.0 |
| 2012-10-12 07:05:00 | AAPL | Stock | 22.4668 | 22.4679 | 22.4668 | 22.4668 | 14000.0 |
| 2012-10-12 07:10:00 | AAPL | Stock | 22.4946 | 22.4946 | 22.4946 | 22.4946 | 4620.0 |
| 2012-10-12 07:15:00 | AAPL | Stock | 22.5 | 22.5 | 22.5 | 22.5 | 2800.0 |
| 2012-10-12 07:20:00 | AAPL | Stock | 22.5071 | 22.5071 | 22.5071 | 22.5071 | 14000.0 |
| 2012-10-12 07:30:00 | AAPL | Stock | 22.4857 | 22.5286 | 22.4857 | 22.5286 | 56812.0 |
| 2012-10-12 07:35:00 | AAPL | Stock | 22.5179 | 22.5346 | 22.5179 | 22.5196 | 65520.0 |
| 2012-10-12 07:40:00 | AAPL | Stock | 22.5196 | 22.5518 | 22.5196 | 22.5479 | 125160.0 |
| 2012-10-12 07:45:00 | AAPL | Stock | 22.5357 | 22.5357 | 22.5268 | 22.5357 | 63000.0 |
| 2012-10-12 07:50:00 | AAPL | Stock | 22.5354 | 22.545 | 22.5354 | 22.545 | 78596.0 |
| 2012-10-12 07:55:00 | AAPL | Stock | 22.5418 | 22.5804 | 22.5393 | 22.5786 | 197120.0 |
| 2012-10-12 08:00:00 | AAPL | Stock | 22.5821 | 22.5857 | 22.5396 | 22.5593 | 405552.0 |
| 2012-10-12 08:05:00 | AAPL | Stock | 22.5536 | 22.5993 | 22.5536 | 22.5964 | 341964.0 |
| 2012-10-12 08:10:00 | AAPL | Stock | 22.5996 | 22.5996 | 22.5654 | 22.5679 | 178500.0 |
| 2012-10-12 08:15:00 | AAPL | Stock | 22.5596 | 22.5704 | 22.5536 | 22.5625 | 132804.0 |
| 2012-10-12 08:20:00 | AAPL | Stock | 22.5589 | 22.5589 | 22.5411 | 22.5411 | 71120.0 |
| 2012-10-12 08:25:00 | AAPL | Stock | 22.5361 | 22.5393 | 22.5214 | 22.5357 | 177240.0 |
| 2012-10-12 08:30:00 | AAPL | Stock | 22.5393 | 22.5536 | 22.525 | 22.5261 | 119280.0 |
| 2012-10-12 08:35:00 | AAPL | Stock | 22.5346 | 22.5386 | 22.5214 | 22.5218 | 112700.0 |
| 2012-10-12 08:40:00 | AAPL | Stock | 22.5218 | 22.5268 | 22.5071 | 22.5107 | 163408.0 |
| 2012-10-12 08:45:00 | AAPL | Stock | 22.5164 | 22.5164 | 22.4896 | 22.5 | 228032.0 |
| 2012-10-12 08:50:00 | AAPL | Stock | 22.5082 | 22.5082 | 22.4914 | 22.4914 | 189896.0 |
| 2012-10-12 08:55:00 | AAPL | Stock | 22.4929 | 22.4996 | 22.4818 | 22.4996 | 246736.0 |
| 2012-10-12 09:00:00 | AAPL | Stock | 22.4936 | 22.51 | 22.4929 | 22.5011 | 161448.0 |
| 2012-10-12 09:05:00 | AAPL | Stock | 22.5007 | 22.5007 | 22.4761 | 22.4896 | 378168.0 |
| 2012-10-12 09:10:00 | AAPL | Stock | 22.4821 | 22.4939 | 22.4664 | 22.4714 | 337820.0 |
| 2012-10-12 09:15:00 | AAPL | Stock | 22.4814 | 22.4829 | 22.4546 | 22.4643 | 481208.0 |
| 2012-10-12 09:20:00 | AAPL | Stock | 22.4693 | 22.4739 | 22.4575 | 22.4575 | 172284.0 |
| 2012-10-12 09:25:00 | AAPL | Stock | 22.4607 | 22.4961 | 22.4607 | 22.4961 | 457632.0 |
| 2012-10-12 09:30:00 | AAPL | Stock | 22.4843 | 22.4996 | 22.3929 | 22.4711 | 19990600.0 |
| 2012-10-12 09:35:00 | AAPL | Stock | 22.4696 | 22.5136 | 22.3614 | 22.3789 | 15391488.0 |
| 2012-10-12 09:40:00 | AAPL | Stock | 22.3829 | 22.3939 | 22.3379 | 22.3429 | 15903132.0 |
| 2012-10-12 09:45:00 | AAPL | Stock | 22.3429 | 22.4414 | 22.3321 | 22.4254 | 11325916.0 |
| 2012-10-12 09:50:00 | AAPL | Stock | 22.4329 | 22.4371 | 22.3868 | 22.4357 | 8179612.0 |
| 2012-10-12 09:55:00 | AAPL | Stock | 22.4332 | 22.5657 | 22.4264 | 22.5657 | 16689120.0 |
| 2012-10-12 10:00:00 | AAPL | Stock | 22.5657 | 22.6336 | 22.5546 | 22.5998 | 16999696.0 |
| 2012-10-12 10:05:00 | AAPL | Stock | 22.6034 | 22.6118 | 22.5507 | 22.5661 | 9011548.0 |
| 2012-10-12 10:10:00 | AAPL | Stock | 22.5632 | 22.5768 | 22.5232 | 22.5768 | 9482788.0 |
| 2012-10-12 10:15:00 | AAPL | Stock | 22.5761 | 22.685 | 22.5679 | 22.6464 | 13024004.0 |
| 2012-10-12 10:20:00 | AAPL | Stock | 22.6429 | 22.6904 | 22.612 | 22.685 | 9151716.0 |
| 2012-10-12 10:25:00 | AAPL | Stock | 22.6818 | 22.6857 | 22.5932 | 22.615 | 9200660.0 |
| 2012-10-12 10:30:00 | AAPL | Stock | 22.62 | 22.6371 | 22.6018 | 22.6182 | 4375672.0 |
| 2012-10-12 10:35:00 | AAPL | Stock | 22.6171 | 22.6764 | 22.6096 | 22.6764 | 5425196.0 |
| 2012-10-12 10:40:00 | AAPL | Stock | 22.6764 | 22.6911 | 22.6429 | 22.6679 | 7620256.0 |
| 2012-10-12 10:45:00 | AAPL | Stock | 22.6661 | 22.6786 | 22.6321 | 22.6746 | 5119996.0 |
| 2012-10-12 10:50:00 | AAPL | Stock | 22.6739 | 22.6786 | 22.615 | 22.6421 | 5387508.0 |
| 2012-10-12 10:55:00 | AAPL | Stock | 22.6337 | 22.6921 | 22.6337 | 22.6436 | 7052836.0 |
| 2012-10-12 11:00:00 | AAPL | Stock | 22.6437 | 22.6589 | 22.6168 | 22.6204 | 4217136.0 |
> showing 50 of 303,208 rows — these rows as CSV