PREVIEW / stock_5min / 2012-02-10
file: by_date/stock_5min/2012/2012-02-10.parquet size: 4.8 MB rows: 326,370 symbols: 3,532
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-02-10 04:20:00 | AAPL | Stock | 17.6607 | 17.6607 | 17.6607 | 17.6607 | 5600.0 |
| 2012-02-10 04:25:00 | AAPL | Stock | 17.6607 | 17.6607 | 17.6607 | 17.6607 | 8400.0 |
| 2012-02-10 04:50:00 | AAPL | Stock | 17.6607 | 17.6607 | 17.6607 | 17.6607 | 14000.0 |
| 2012-02-10 04:55:00 | AAPL | Stock | 17.6661 | 17.6661 | 17.6661 | 17.6661 | 14000.0 |
| 2012-02-10 05:00:00 | AAPL | Stock | 17.6518 | 17.6518 | 17.6429 | 17.6429 | 16800.0 |
| 2012-02-10 05:05:00 | AAPL | Stock | 17.6321 | 17.6321 | 17.6218 | 17.6218 | 11200.0 |
| 2012-02-10 05:10:00 | AAPL | Stock | 17.6164 | 17.6218 | 17.6071 | 17.6218 | 56000.0 |
| 2012-02-10 05:20:00 | AAPL | Stock | 17.6071 | 17.6071 | 17.6 | 17.6 | 27720.0 |
| 2012-02-10 06:15:00 | AAPL | Stock | 17.6096 | 17.6096 | 17.6093 | 17.6093 | 10640.0 |
| 2012-02-10 06:20:00 | AAPL | Stock | 17.6179 | 17.6179 | 17.6179 | 17.6179 | 5600.0 |
| 2012-02-10 06:45:00 | AAPL | Stock | 17.6093 | 17.6093 | 17.6093 | 17.6093 | 5180.0 |
| 2012-02-10 06:50:00 | AAPL | Stock | 17.625 | 17.625 | 17.6093 | 17.6093 | 8960.0 |
| 2012-02-10 07:00:00 | AAPL | Stock | 17.6179 | 17.6246 | 17.6071 | 17.6246 | 143360.0 |
| 2012-02-10 07:05:00 | AAPL | Stock | 17.6071 | 17.6071 | 17.4561 | 17.5671 | 214956.0 |
| 2012-02-10 07:10:00 | AAPL | Stock | 17.5714 | 17.5714 | 17.4896 | 17.4896 | 175140.0 |
| 2012-02-10 07:15:00 | AAPL | Stock | 17.5 | 17.5179 | 17.4857 | 17.5 | 238616.0 |
| 2012-02-10 07:20:00 | AAPL | Stock | 17.5 | 17.5571 | 17.5 | 17.5536 | 272384.0 |
| 2012-02-10 07:25:00 | AAPL | Stock | 17.5393 | 17.5639 | 17.5393 | 17.5571 | 84392.0 |
| 2012-02-10 07:30:00 | AAPL | Stock | 17.5632 | 17.5632 | 17.5404 | 17.5496 | 52248.0 |
| 2012-02-10 07:35:00 | AAPL | Stock | 17.5479 | 17.5536 | 17.5357 | 17.5393 | 111916.0 |
| 2012-02-10 07:40:00 | AAPL | Stock | 17.5443 | 17.5482 | 17.5221 | 17.5482 | 72212.0 |
| 2012-02-10 07:45:00 | AAPL | Stock | 17.55 | 17.5504 | 17.5446 | 17.5446 | 121520.0 |
| 2012-02-10 07:50:00 | AAPL | Stock | 17.5379 | 17.5379 | 17.5161 | 17.5161 | 235508.0 |
| 2012-02-10 07:55:00 | AAPL | Stock | 17.5296 | 17.5318 | 17.5164 | 17.5179 | 39200.0 |
| 2012-02-10 08:00:00 | AAPL | Stock | 17.5321 | 17.5357 | 17.5 | 17.5214 | 432460.0 |
| 2012-02-10 08:05:00 | AAPL | Stock | 17.5232 | 17.5868 | 17.5232 | 17.55 | 389340.0 |
| 2012-02-10 08:10:00 | AAPL | Stock | 17.5493 | 17.5893 | 17.5446 | 17.5729 | 590184.0 |
| 2012-02-10 08:15:00 | AAPL | Stock | 17.5804 | 17.5964 | 17.5736 | 17.5893 | 448280.0 |
| 2012-02-10 08:20:00 | AAPL | Stock | 17.5893 | 17.6146 | 17.5875 | 17.6146 | 444668.0 |
| 2012-02-10 08:25:00 | AAPL | Stock | 17.6139 | 17.6346 | 17.6107 | 17.6314 | 578816.0 |
| 2012-02-10 08:30:00 | AAPL | Stock | 17.6332 | 17.6343 | 17.6071 | 17.6096 | 976360.0 |
| 2012-02-10 08:35:00 | AAPL | Stock | 17.6107 | 17.6107 | 17.5982 | 17.5982 | 533008.0 |
| 2012-02-10 08:40:00 | AAPL | Stock | 17.5982 | 17.5982 | 17.5607 | 17.5607 | 665364.0 |
| 2012-02-10 08:45:00 | AAPL | Stock | 17.5604 | 17.5868 | 17.5446 | 17.5682 | 488964.0 |
| 2012-02-10 08:50:00 | AAPL | Stock | 17.5732 | 17.5843 | 17.5704 | 17.5811 | 226520.0 |
| 2012-02-10 08:55:00 | AAPL | Stock | 17.5818 | 17.5875 | 17.5754 | 17.5807 | 128408.0 |
| 2012-02-10 09:00:00 | AAPL | Stock | 17.5821 | 17.5857 | 17.5536 | 17.5625 | 669704.0 |
| 2012-02-10 09:05:00 | AAPL | Stock | 17.5625 | 17.5643 | 17.5368 | 17.5368 | 268128.0 |
| 2012-02-10 09:10:00 | AAPL | Stock | 17.5357 | 17.5464 | 17.5186 | 17.5389 | 869568.0 |
| 2012-02-10 09:15:00 | AAPL | Stock | 17.5371 | 17.5454 | 17.5179 | 17.5207 | 304724.0 |
| 2012-02-10 09:20:00 | AAPL | Stock | 17.5204 | 17.5271 | 17.5107 | 17.5143 | 422632.0 |
| 2012-02-10 09:25:00 | AAPL | Stock | 17.52 | 17.5457 | 17.5107 | 17.5425 | 470344.0 |
| 2012-02-10 09:30:00 | AAPL | Stock | 17.5421 | 17.6143 | 17.4482 | 17.5946 | 35462420.0 |
| 2012-02-10 09:35:00 | AAPL | Stock | 17.5929 | 17.625 | 17.545 | 17.6243 | 20272420.0 |
| 2012-02-10 09:40:00 | AAPL | Stock | 17.6218 | 17.7211 | 17.6196 | 17.7093 | 24279668.0 |
| 2012-02-10 09:45:00 | AAPL | Stock | 17.7118 | 17.7721 | 17.6879 | 17.7487 | 31635688.0 |
| 2012-02-10 09:50:00 | AAPL | Stock | 17.7496 | 17.76 | 17.6804 | 17.6929 | 20724872.0 |
| 2012-02-10 09:55:00 | AAPL | Stock | 17.6922 | 17.7049 | 17.6189 | 17.6436 | 20556648.0 |
| 2012-02-10 10:00:00 | AAPL | Stock | 17.6414 | 17.6893 | 17.5643 | 17.5761 | 17964576.0 |
| 2012-02-10 10:05:00 | AAPL | Stock | 17.5721 | 17.6564 | 17.5643 | 17.6452 | 16949968.0 |
> showing 50 of 326,370 rows — these rows as CSV