PREVIEW / stock_5min / 2011-09-13
file: by_date/stock_5min/2011/2011-09-13.parquet size: 4.7 MB rows: 324,425 symbols: 3,484
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-09-13 04:00:00 | AAPL | Stock | 13.5029 | 13.5029 | 13.5029 | 13.5029 | 2800.0 |
| 2011-09-13 04:10:00 | AAPL | Stock | 13.4557 | 13.4643 | 13.4411 | 13.4643 | 39200.0 |
| 2011-09-13 04:15:00 | AAPL | Stock | 13.4325 | 13.4325 | 13.4325 | 13.4325 | 2800.0 |
| 2011-09-13 04:50:00 | AAPL | Stock | 13.4632 | 13.4632 | 13.4632 | 13.4632 | 2800.0 |
| 2011-09-13 04:55:00 | AAPL | Stock | 13.4964 | 13.4964 | 13.4964 | 13.4964 | 2800.0 |
| 2011-09-13 07:00:00 | AAPL | Stock | 13.5032 | 13.5257 | 13.5 | 13.5182 | 92400.0 |
| 2011-09-13 07:05:00 | AAPL | Stock | 13.5171 | 13.5214 | 13.5089 | 13.5196 | 61880.0 |
| 2011-09-13 07:10:00 | AAPL | Stock | 13.5279 | 13.5736 | 13.5279 | 13.5732 | 109340.0 |
| 2011-09-13 07:15:00 | AAPL | Stock | 13.5714 | 13.5893 | 13.5464 | 13.5464 | 108780.0 |
| 2011-09-13 07:20:00 | AAPL | Stock | 13.5468 | 13.5668 | 13.5357 | 13.5668 | 211400.0 |
| 2011-09-13 07:25:00 | AAPL | Stock | 13.5604 | 13.5964 | 13.5543 | 13.5907 | 136500.0 |
| 2011-09-13 07:30:00 | AAPL | Stock | 13.595 | 13.6536 | 13.5786 | 13.6536 | 417200.0 |
| 2011-09-13 07:35:00 | AAPL | Stock | 13.6546 | 13.6589 | 13.6254 | 13.6589 | 156520.0 |
| 2011-09-13 07:40:00 | AAPL | Stock | 13.6429 | 13.6429 | 13.6246 | 13.6246 | 68012.0 |
| 2011-09-13 07:45:00 | AAPL | Stock | 13.6229 | 13.625 | 13.5396 | 13.5964 | 549024.0 |
| 2011-09-13 07:50:00 | AAPL | Stock | 13.5961 | 13.5964 | 13.5714 | 13.5714 | 53200.0 |
| 2011-09-13 07:55:00 | AAPL | Stock | 13.5714 | 13.6046 | 13.5714 | 13.6046 | 22400.0 |
| 2011-09-13 08:00:00 | AAPL | Stock | 13.5893 | 13.5982 | 13.5575 | 13.5714 | 376908.0 |
| 2011-09-13 08:05:00 | AAPL | Stock | 13.5593 | 13.585 | 13.5446 | 13.5768 | 289772.0 |
| 2011-09-13 08:10:00 | AAPL | Stock | 13.5768 | 13.5846 | 13.5707 | 13.5821 | 247940.0 |
| 2011-09-13 08:15:00 | AAPL | Stock | 13.5757 | 13.5757 | 13.545 | 13.5596 | 287364.0 |
| 2011-09-13 08:20:00 | AAPL | Stock | 13.55 | 13.5714 | 13.55 | 13.5714 | 39200.0 |
| 2011-09-13 08:25:00 | AAPL | Stock | 13.5829 | 13.585 | 13.5818 | 13.5821 | 70392.0 |
| 2011-09-13 08:30:00 | AAPL | Stock | 13.585 | 13.605 | 13.5804 | 13.6007 | 252532.0 |
| 2011-09-13 08:35:00 | AAPL | Stock | 13.6057 | 13.6496 | 13.6057 | 13.6496 | 349664.0 |
| 2011-09-13 08:40:00 | AAPL | Stock | 13.6518 | 13.6518 | 13.6279 | 13.6293 | 306992.0 |
| 2011-09-13 08:45:00 | AAPL | Stock | 13.6325 | 13.65 | 13.6321 | 13.6464 | 386288.0 |
| 2011-09-13 08:50:00 | AAPL | Stock | 13.6411 | 13.6418 | 13.6293 | 13.6382 | 100688.0 |
| 2011-09-13 08:55:00 | AAPL | Stock | 13.6311 | 13.6311 | 13.6036 | 13.6036 | 329280.0 |
| 2011-09-13 09:00:00 | AAPL | Stock | 13.6029 | 13.6186 | 13.5982 | 13.6125 | 540764.0 |
| 2011-09-13 09:05:00 | AAPL | Stock | 13.6161 | 13.6182 | 13.6054 | 13.6104 | 252840.0 |
| 2011-09-13 09:10:00 | AAPL | Stock | 13.6093 | 13.6389 | 13.6086 | 13.6318 | 316232.0 |
| 2011-09-13 09:15:00 | AAPL | Stock | 13.6339 | 13.6357 | 13.6107 | 13.6357 | 547680.0 |
| 2011-09-13 09:20:00 | AAPL | Stock | 13.6361 | 13.6414 | 13.6329 | 13.6339 | 195916.0 |
| 2011-09-13 09:25:00 | AAPL | Stock | 13.6375 | 13.6482 | 13.6339 | 13.6479 | 973084.0 |
| 2011-09-13 09:30:00 | AAPL | Stock | 13.6479 | 13.6645 | 13.6011 | 13.6142 | 19846176.0 |
| 2011-09-13 09:35:00 | AAPL | Stock | 13.6139 | 13.6346 | 13.5893 | 13.605 | 8912624.0 |
| 2011-09-13 09:40:00 | AAPL | Stock | 13.6034 | 13.6429 | 13.5986 | 13.6239 | 10046736.0 |
| 2011-09-13 09:45:00 | AAPL | Stock | 13.6239 | 13.6536 | 13.5804 | 13.6514 | 12740392.0 |
| 2011-09-13 09:50:00 | AAPL | Stock | 13.6513 | 13.6661 | 13.6286 | 13.6494 | 8741404.0 |
| 2011-09-13 09:55:00 | AAPL | Stock | 13.6468 | 13.6554 | 13.6018 | 13.6343 | 8932728.0 |
| 2011-09-13 10:00:00 | AAPL | Stock | 13.6343 | 13.6536 | 13.6193 | 13.6464 | 6090028.0 |
| 2011-09-13 10:05:00 | AAPL | Stock | 13.6477 | 13.6836 | 13.6446 | 13.6775 | 10783248.0 |
| 2011-09-13 10:10:00 | AAPL | Stock | 13.6771 | 13.6857 | 13.6554 | 13.6554 | 7085792.0 |
| 2011-09-13 10:15:00 | AAPL | Stock | 13.6563 | 13.6718 | 13.6554 | 13.6611 | 4577076.0 |
| 2011-09-13 10:20:00 | AAPL | Stock | 13.6636 | 13.6829 | 13.6579 | 13.68 | 7231756.0 |
| 2011-09-13 10:25:00 | AAPL | Stock | 13.6825 | 13.6964 | 13.6779 | 13.6854 | 7648032.0 |
| 2011-09-13 10:30:00 | AAPL | Stock | 13.6861 | 13.6964 | 13.6546 | 13.6682 | 6950412.0 |
| 2011-09-13 10:35:00 | AAPL | Stock | 13.6646 | 13.6661 | 13.6366 | 13.6454 | 6798456.0 |
| 2011-09-13 10:40:00 | AAPL | Stock | 13.6429 | 13.6582 | 13.6382 | 13.6471 | 3910592.0 |
> showing 50 of 324,425 rows — these rows as CSV