PREVIEW / stock_5min / 2008-06-09
file: by_date/stock_5min/2008/2008-06-09.parquet size: 4.5 MB rows: 321,360 symbols: 3,326
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 |
|---|---|---|---|---|---|---|---|
| 2008-06-09 06:30:00 | AAPL | Stock | 6.6782 | 6.6782 | 6.6668 | 6.6668 | 19600.0 |
| 2008-06-09 06:35:00 | AAPL | Stock | 6.6668 | 6.6668 | 6.6668 | 6.6668 | 2828.0 |
| 2008-06-09 06:40:00 | AAPL | Stock | 6.6489 | 6.6786 | 6.6489 | 6.6786 | 27440.0 |
| 2008-06-09 06:45:00 | AAPL | Stock | 6.6518 | 6.6786 | 6.6518 | 6.6786 | 23800.0 |
| 2008-06-09 06:50:00 | AAPL | Stock | 6.6611 | 6.6611 | 6.6611 | 6.6611 | 14000.0 |
| 2008-06-09 06:55:00 | AAPL | Stock | 6.6611 | 6.6614 | 6.6482 | 6.6482 | 22400.0 |
| 2008-06-09 07:00:00 | AAPL | Stock | 6.6432 | 6.6432 | 6.6339 | 6.6339 | 70000.0 |
| 2008-06-09 07:10:00 | AAPL | Stock | 6.6429 | 6.6532 | 6.6429 | 6.6532 | 55160.0 |
| 2008-06-09 07:15:00 | AAPL | Stock | 6.6429 | 6.6525 | 6.6429 | 6.6457 | 33600.0 |
| 2008-06-09 07:20:00 | AAPL | Stock | 6.6464 | 6.6536 | 6.6357 | 6.6536 | 63560.0 |
| 2008-06-09 07:25:00 | AAPL | Stock | 6.6554 | 6.6554 | 6.655 | 6.6554 | 14000.0 |
| 2008-06-09 07:30:00 | AAPL | Stock | 6.6546 | 6.6546 | 6.6518 | 6.6518 | 220640.0 |
| 2008-06-09 07:40:00 | AAPL | Stock | 6.6518 | 6.6518 | 6.6518 | 6.6518 | 47012.0 |
| 2008-06-09 07:45:00 | AAPL | Stock | 6.6518 | 6.6518 | 6.6518 | 6.6518 | 70000.0 |
| 2008-06-09 07:50:00 | AAPL | Stock | 6.6471 | 6.6514 | 6.6429 | 6.6443 | 68768.0 |
| 2008-06-09 07:55:00 | AAPL | Stock | 6.6436 | 6.6436 | 6.6425 | 6.6425 | 42000.0 |
| 2008-06-09 08:00:00 | AAPL | Stock | 6.65 | 6.6754 | 6.65 | 6.6682 | 1108184.0 |
| 2008-06-09 08:05:00 | AAPL | Stock | 6.6657 | 6.6904 | 6.6589 | 6.6839 | 847980.0 |
| 2008-06-09 08:10:00 | AAPL | Stock | 6.6839 | 6.69 | 6.6786 | 6.6854 | 910812.0 |
| 2008-06-09 08:15:00 | AAPL | Stock | 6.6836 | 6.6893 | 6.6786 | 6.6786 | 792568.0 |
| 2008-06-09 08:20:00 | AAPL | Stock | 6.6821 | 6.6879 | 6.67 | 6.6732 | 420028.0 |
| 2008-06-09 08:25:00 | AAPL | Stock | 6.6732 | 6.6732 | 6.6339 | 6.6425 | 2209620.0 |
| 2008-06-09 08:30:00 | AAPL | Stock | 6.6429 | 6.6511 | 6.5304 | 6.5593 | 3497900.0 |
| 2008-06-09 08:35:00 | AAPL | Stock | 6.5593 | 6.5836 | 6.5536 | 6.5707 | 1072624.0 |
| 2008-06-09 08:40:00 | AAPL | Stock | 6.5711 | 6.6071 | 6.5679 | 6.575 | 1086540.0 |
| 2008-06-09 08:45:00 | AAPL | Stock | 6.5782 | 6.6229 | 6.5782 | 6.6139 | 941248.0 |
| 2008-06-09 08:50:00 | AAPL | Stock | 6.6111 | 6.6239 | 6.5857 | 6.6071 | 2029188.0 |
| 2008-06-09 08:55:00 | AAPL | Stock | 6.6068 | 6.6071 | 6.5929 | 6.6011 | 800520.0 |
| 2008-06-09 09:00:00 | AAPL | Stock | 6.6014 | 6.6025 | 6.5893 | 6.5946 | 790804.0 |
| 2008-06-09 09:05:00 | AAPL | Stock | 6.5904 | 6.6071 | 6.5893 | 6.6018 | 600880.0 |
| 2008-06-09 09:10:00 | AAPL | Stock | 6.5982 | 6.6071 | 6.5968 | 6.6036 | 578732.0 |
| 2008-06-09 09:15:00 | AAPL | Stock | 6.6029 | 6.6071 | 6.5882 | 6.5882 | 507220.0 |
| 2008-06-09 09:20:00 | AAPL | Stock | 6.5882 | 6.5961 | 6.5857 | 6.5857 | 481208.0 |
| 2008-06-09 09:25:00 | AAPL | Stock | 6.5843 | 6.6043 | 6.5743 | 6.6018 | 1069964.0 |
| 2008-06-09 09:30:00 | AAPL | Stock | 6.6004 | 6.605 | 6.55 | 6.5507 | 39294948.0 |
| 2008-06-09 09:35:00 | AAPL | Stock | 6.5504 | 6.5536 | 6.5057 | 6.5375 | 38181164.0 |
| 2008-06-09 09:40:00 | AAPL | Stock | 6.5379 | 6.5846 | 6.5236 | 6.5714 | 23882096.0 |
| 2008-06-09 09:45:00 | AAPL | Stock | 6.57 | 6.5757 | 6.5211 | 6.5279 | 21307076.0 |
| 2008-06-09 09:50:00 | AAPL | Stock | 6.5282 | 6.5289 | 6.4289 | 6.4554 | 50253196.0 |
| 2008-06-09 09:55:00 | AAPL | Stock | 6.4561 | 6.5 | 6.4536 | 6.4964 | 26691924.0 |
| 2008-06-09 10:00:00 | AAPL | Stock | 6.4954 | 6.5229 | 6.4782 | 6.5014 | 21505932.0 |
| 2008-06-09 10:05:00 | AAPL | Stock | 6.5004 | 6.5321 | 6.4971 | 6.5218 | 18978344.0 |
| 2008-06-09 10:10:00 | AAPL | Stock | 6.5213 | 6.5514 | 6.5125 | 6.5468 | 18434640.0 |
| 2008-06-09 10:15:00 | AAPL | Stock | 6.5507 | 6.5679 | 6.5482 | 6.5546 | 21374612.0 |
| 2008-06-09 10:20:00 | AAPL | Stock | 6.555 | 6.5736 | 6.5414 | 6.55 | 18928840.0 |
| 2008-06-09 10:25:00 | AAPL | Stock | 6.5476 | 6.5589 | 6.5357 | 6.5475 | 11576880.0 |
| 2008-06-09 10:30:00 | AAPL | Stock | 6.5461 | 6.5579 | 6.5357 | 6.5521 | 7397404.0 |
| 2008-06-09 10:35:00 | AAPL | Stock | 6.5525 | 6.5546 | 6.5093 | 6.5096 | 12668264.0 |
| 2008-06-09 10:40:00 | AAPL | Stock | 6.5096 | 6.5175 | 6.4929 | 6.5061 | 11383596.0 |
| 2008-06-09 10:45:00 | AAPL | Stock | 6.5061 | 6.5125 | 6.4929 | 6.5104 | 9254840.0 |
> showing 50 of 321,360 rows — these rows as CSV