PREVIEW / stock_5min / 2011-04-26
file: by_date/stock_5min/2011/2011-04-26.parquet size: 5.0 MB rows: 335,515 symbols: 3,564
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 |
|---|---|---|---|---|---|---|---|
| 2011-04-26 04:00:00 | AAPL | Stock | 12.6432 | 12.6432 | 12.6432 | 12.6432 | 2800.0 |
| 2011-04-26 04:15:00 | AAPL | Stock | 12.6514 | 12.6514 | 12.6514 | 12.6514 | 2800.0 |
| 2011-04-26 04:35:00 | AAPL | Stock | 12.6518 | 12.6518 | 12.6518 | 12.6518 | 5600.0 |
| 2011-04-26 04:45:00 | AAPL | Stock | 12.6375 | 12.6389 | 12.6375 | 12.6389 | 8400.0 |
| 2011-04-26 04:55:00 | AAPL | Stock | 12.6496 | 12.6496 | 12.6496 | 12.6496 | 2800.0 |
| 2011-04-26 05:35:00 | AAPL | Stock | 12.6607 | 12.6607 | 12.6607 | 12.6607 | 4200.0 |
| 2011-04-26 07:00:00 | AAPL | Stock | 12.6429 | 12.6429 | 12.6404 | 12.6404 | 5600.0 |
| 2011-04-26 07:10:00 | AAPL | Stock | 12.6389 | 12.6389 | 12.6389 | 12.6389 | 42000.0 |
| 2011-04-26 07:15:00 | AAPL | Stock | 12.6375 | 12.6404 | 12.6375 | 12.6375 | 26544.0 |
| 2011-04-26 07:20:00 | AAPL | Stock | 12.6393 | 12.6425 | 12.6393 | 12.6425 | 8400.0 |
| 2011-04-26 07:25:00 | AAPL | Stock | 12.6464 | 12.6464 | 12.6464 | 12.6464 | 2800.0 |
| 2011-04-26 07:30:00 | AAPL | Stock | 12.6464 | 12.6464 | 12.6464 | 12.6464 | 2800.0 |
| 2011-04-26 07:40:00 | AAPL | Stock | 12.6418 | 12.6418 | 12.6418 | 12.6418 | 2800.0 |
| 2011-04-26 07:45:00 | AAPL | Stock | 12.65 | 12.65 | 12.65 | 12.65 | 5600.0 |
| 2011-04-26 07:50:00 | AAPL | Stock | 12.6436 | 12.6436 | 12.6429 | 12.6429 | 33600.0 |
| 2011-04-26 07:55:00 | AAPL | Stock | 12.6429 | 12.65 | 12.6429 | 12.6482 | 39200.0 |
| 2011-04-26 08:00:00 | AAPL | Stock | 12.65 | 12.6571 | 12.6425 | 12.6429 | 171892.0 |
| 2011-04-26 08:05:00 | AAPL | Stock | 12.6429 | 12.6479 | 12.6429 | 12.6479 | 59556.0 |
| 2011-04-26 08:10:00 | AAPL | Stock | 12.6479 | 12.6507 | 12.6446 | 12.6464 | 81508.0 |
| 2011-04-26 08:15:00 | AAPL | Stock | 12.6482 | 12.65 | 12.6393 | 12.6393 | 67816.0 |
| 2011-04-26 08:20:00 | AAPL | Stock | 12.6429 | 12.6475 | 12.6429 | 12.6468 | 33516.0 |
| 2011-04-26 08:25:00 | AAPL | Stock | 12.6468 | 12.6482 | 12.6443 | 12.645 | 22400.0 |
| 2011-04-26 08:30:00 | AAPL | Stock | 12.645 | 12.645 | 12.6375 | 12.6429 | 83132.0 |
| 2011-04-26 08:35:00 | AAPL | Stock | 12.6429 | 12.6429 | 12.6389 | 12.6389 | 17416.0 |
| 2011-04-26 08:45:00 | AAPL | Stock | 12.6321 | 12.6382 | 12.625 | 12.625 | 93016.0 |
| 2011-04-26 08:50:00 | AAPL | Stock | 12.6254 | 12.6321 | 12.6254 | 12.6321 | 94528.0 |
| 2011-04-26 08:55:00 | AAPL | Stock | 12.6271 | 12.6271 | 12.6243 | 12.6243 | 42000.0 |
| 2011-04-26 09:00:00 | AAPL | Stock | 12.6243 | 12.6243 | 12.6111 | 12.6179 | 35336.0 |
| 2011-04-26 09:05:00 | AAPL | Stock | 12.6179 | 12.6339 | 12.6125 | 12.6293 | 80388.0 |
| 2011-04-26 09:10:00 | AAPL | Stock | 12.6286 | 12.6354 | 12.6286 | 12.6346 | 28420.0 |
| 2011-04-26 09:15:00 | AAPL | Stock | 12.6346 | 12.6421 | 12.6339 | 12.6411 | 87640.0 |
| 2011-04-26 09:20:00 | AAPL | Stock | 12.6386 | 12.6396 | 12.6386 | 12.6396 | 28000.0 |
| 2011-04-26 09:25:00 | AAPL | Stock | 12.6396 | 12.6411 | 12.6293 | 12.63 | 115640.0 |
| 2011-04-26 09:30:00 | AAPL | Stock | 12.6293 | 12.6782 | 12.5804 | 12.5867 | 17453828.0 |
| 2011-04-26 09:35:00 | AAPL | Stock | 12.5879 | 12.6071 | 12.5661 | 12.5808 | 8617140.0 |
| 2011-04-26 09:40:00 | AAPL | Stock | 12.5789 | 12.5911 | 12.5636 | 12.5854 | 7351820.0 |
| 2011-04-26 09:45:00 | AAPL | Stock | 12.5854 | 12.6046 | 12.5825 | 12.6043 | 5905956.0 |
| 2011-04-26 09:50:00 | AAPL | Stock | 12.6046 | 12.6143 | 12.5893 | 12.6059 | 6841156.0 |
| 2011-04-26 09:55:00 | AAPL | Stock | 12.6051 | 12.61 | 12.6 | 12.6006 | 3904460.0 |
| 2011-04-26 10:00:00 | AAPL | Stock | 12.6 | 12.605 | 12.5836 | 12.5857 | 5154464.0 |
| 2011-04-26 10:05:00 | AAPL | Stock | 12.585 | 12.5971 | 12.5707 | 12.5768 | 4821964.0 |
| 2011-04-26 10:10:00 | AAPL | Stock | 12.5771 | 12.5871 | 12.5736 | 12.5839 | 3589236.0 |
| 2011-04-26 10:15:00 | AAPL | Stock | 12.585 | 12.585 | 12.5536 | 12.5632 | 5682936.0 |
| 2011-04-26 10:20:00 | AAPL | Stock | 12.5643 | 12.5857 | 12.5606 | 12.5801 | 4142628.0 |
| 2011-04-26 10:25:00 | AAPL | Stock | 12.5811 | 12.5943 | 12.5768 | 12.5796 | 4016768.0 |
| 2011-04-26 10:30:00 | AAPL | Stock | 12.5804 | 12.5882 | 12.5743 | 12.5793 | 2922976.0 |
| 2011-04-26 10:35:00 | AAPL | Stock | 12.5807 | 12.5854 | 12.5607 | 12.5707 | 3330096.0 |
| 2011-04-26 10:40:00 | AAPL | Stock | 12.5707 | 12.5918 | 12.5679 | 12.5902 | 4098864.0 |
| 2011-04-26 10:45:00 | AAPL | Stock | 12.5918 | 12.5975 | 12.5846 | 12.5886 | 3395280.0 |
| 2011-04-26 10:50:00 | AAPL | Stock | 12.5893 | 12.6143 | 12.5879 | 12.61 | 5326496.0 |
> showing 50 of 335,515 rows — these rows as CSV