PREVIEW / stock_5min / 2008-05-28
file: by_date/stock_5min/2008/2008-05-28.parquet size: 4.4 MB rows: 316,107 symbols: 3,302
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-05-28 07:20:00 | AAPL | Stock | 6.675 | 6.6893 | 6.675 | 6.675 | 10780.0 |
| 2008-05-28 07:25:00 | AAPL | Stock | 6.675 | 6.6786 | 6.675 | 6.6786 | 10332.0 |
| 2008-05-28 07:30:00 | AAPL | Stock | 6.6786 | 6.6786 | 6.6786 | 6.6786 | 19600.0 |
| 2008-05-28 07:35:00 | AAPL | Stock | 6.6846 | 6.6886 | 6.6846 | 6.6886 | 28000.0 |
| 2008-05-28 07:40:00 | AAPL | Stock | 6.6886 | 6.6946 | 6.6886 | 6.6946 | 92400.0 |
| 2008-05-28 07:45:00 | AAPL | Stock | 6.6943 | 6.6961 | 6.6929 | 6.6929 | 53480.0 |
| 2008-05-28 07:50:00 | AAPL | Stock | 6.6929 | 6.6946 | 6.6929 | 6.6929 | 39200.0 |
| 2008-05-28 07:55:00 | AAPL | Stock | 6.6936 | 6.6946 | 6.6929 | 6.6929 | 72800.0 |
| 2008-05-28 08:00:00 | AAPL | Stock | 6.6964 | 6.7 | 6.6839 | 6.6982 | 1147748.0 |
| 2008-05-28 08:05:00 | AAPL | Stock | 6.6929 | 6.6929 | 6.6804 | 6.6893 | 585116.0 |
| 2008-05-28 08:10:00 | AAPL | Stock | 6.6893 | 6.6911 | 6.6875 | 6.6893 | 243040.0 |
| 2008-05-28 08:15:00 | AAPL | Stock | 6.6875 | 6.6875 | 6.6807 | 6.6832 | 387520.0 |
| 2008-05-28 08:20:00 | AAPL | Stock | 6.6821 | 6.6836 | 6.6761 | 6.6786 | 344540.0 |
| 2008-05-28 08:25:00 | AAPL | Stock | 6.6786 | 6.6825 | 6.6771 | 6.6825 | 229600.0 |
| 2008-05-28 08:30:00 | AAPL | Stock | 6.6829 | 6.6964 | 6.6825 | 6.6946 | 893984.0 |
| 2008-05-28 08:35:00 | AAPL | Stock | 6.6946 | 6.7057 | 6.6911 | 6.7057 | 931392.0 |
| 2008-05-28 08:40:00 | AAPL | Stock | 6.7057 | 6.7107 | 6.7043 | 6.7075 | 613676.0 |
| 2008-05-28 08:45:00 | AAPL | Stock | 6.7075 | 6.7136 | 6.7068 | 6.7107 | 621544.0 |
| 2008-05-28 08:50:00 | AAPL | Stock | 6.7107 | 6.7114 | 6.7036 | 6.7079 | 242620.0 |
| 2008-05-28 08:55:00 | AAPL | Stock | 6.7096 | 6.7118 | 6.7075 | 6.7086 | 303268.0 |
| 2008-05-28 09:00:00 | AAPL | Stock | 6.7064 | 6.7107 | 6.7046 | 6.71 | 453908.0 |
| 2008-05-28 09:05:00 | AAPL | Stock | 6.7093 | 6.7107 | 6.705 | 6.7089 | 282296.0 |
| 2008-05-28 09:10:00 | AAPL | Stock | 6.7093 | 6.7125 | 6.7057 | 6.7082 | 674184.0 |
| 2008-05-28 09:15:00 | AAPL | Stock | 6.7082 | 6.7082 | 6.6989 | 6.7 | 725900.0 |
| 2008-05-28 09:20:00 | AAPL | Stock | 6.6996 | 6.7021 | 6.6911 | 6.6929 | 604240.0 |
| 2008-05-28 09:25:00 | AAPL | Stock | 6.6943 | 6.6946 | 6.6857 | 6.6932 | 977396.0 |
| 2008-05-28 09:30:00 | AAPL | Stock | 6.6932 | 6.6964 | 6.6679 | 6.6925 | 32472244.0 |
| 2008-05-28 09:35:00 | AAPL | Stock | 6.6911 | 6.7107 | 6.6729 | 6.7082 | 23208696.0 |
| 2008-05-28 09:40:00 | AAPL | Stock | 6.7086 | 6.7125 | 6.6625 | 6.6657 | 27682508.0 |
| 2008-05-28 09:45:00 | AAPL | Stock | 6.6657 | 6.6943 | 6.6554 | 6.6574 | 22536556.0 |
| 2008-05-28 09:50:00 | AAPL | Stock | 6.6571 | 6.6764 | 6.6536 | 6.6575 | 13840204.0 |
| 2008-05-28 09:55:00 | AAPL | Stock | 6.6575 | 6.6675 | 6.6386 | 6.6489 | 20546540.0 |
| 2008-05-28 10:00:00 | AAPL | Stock | 6.6493 | 6.6518 | 6.6275 | 6.6304 | 15916852.0 |
| 2008-05-28 10:05:00 | AAPL | Stock | 6.6296 | 6.6482 | 6.6279 | 6.6404 | 11532752.0 |
| 2008-05-28 10:10:00 | AAPL | Stock | 6.6405 | 6.6671 | 6.6375 | 6.6643 | 15829520.0 |
| 2008-05-28 10:15:00 | AAPL | Stock | 6.6646 | 6.6725 | 6.6471 | 6.65 | 15483328.0 |
| 2008-05-28 10:20:00 | AAPL | Stock | 6.6504 | 6.6571 | 6.6336 | 6.6554 | 11352460.0 |
| 2008-05-28 10:25:00 | AAPL | Stock | 6.6554 | 6.6604 | 6.6396 | 6.6504 | 8085784.0 |
| 2008-05-28 10:30:00 | AAPL | Stock | 6.6504 | 6.6643 | 6.6496 | 6.6607 | 8931832.0 |
| 2008-05-28 10:35:00 | AAPL | Stock | 6.6607 | 6.6616 | 6.635 | 6.6493 | 7943404.0 |
| 2008-05-28 10:40:00 | AAPL | Stock | 6.6486 | 6.6514 | 6.6425 | 6.6436 | 7237608.0 |
| 2008-05-28 10:45:00 | AAPL | Stock | 6.6446 | 6.6471 | 6.6296 | 6.6311 | 8222956.0 |
| 2008-05-28 10:50:00 | AAPL | Stock | 6.6314 | 6.6375 | 6.6161 | 6.6246 | 12379640.0 |
| 2008-05-28 10:55:00 | AAPL | Stock | 6.6239 | 6.6471 | 6.6211 | 6.6429 | 10666264.0 |
| 2008-05-28 11:00:00 | AAPL | Stock | 6.6421 | 6.6464 | 6.6314 | 6.64 | 8703408.0 |
| 2008-05-28 11:05:00 | AAPL | Stock | 6.6371 | 6.6454 | 6.6346 | 6.6364 | 4635204.0 |
| 2008-05-28 11:10:00 | AAPL | Stock | 6.6364 | 6.6425 | 6.6196 | 6.62 | 9287460.0 |
| 2008-05-28 11:15:00 | AAPL | Stock | 6.6207 | 6.625 | 6.6093 | 6.6143 | 11192776.0 |
| 2008-05-28 11:20:00 | AAPL | Stock | 6.6146 | 6.6218 | 6.5932 | 6.5943 | 11888688.0 |
| 2008-05-28 11:25:00 | AAPL | Stock | 6.5943 | 6.6014 | 6.5826 | 6.5864 | 10548160.0 |
> showing 50 of 316,107 rows — these rows as CSV