PREVIEW / stock_5min / 2007-08-13
file: by_date/stock_5min/2007/2007-08-13.parquet size: 4.3 MB rows: 309,759 symbols: 3,134
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 |
|---|---|---|---|---|---|---|---|
| 2007-08-13 09:30:00 | AAPL | Stock | 4.5829 | 4.595 | 4.5357 | 4.5391 | 32804296.0 |
| 2007-08-13 09:35:00 | AAPL | Stock | 4.5386 | 4.5618 | 4.5289 | 4.5436 | 26215980.0 |
| 2007-08-13 09:40:00 | AAPL | Stock | 4.5436 | 4.5518 | 4.5311 | 4.5454 | 16067492.0 |
| 2007-08-13 09:45:00 | AAPL | Stock | 4.5454 | 4.5571 | 4.5401 | 4.5479 | 13365884.0 |
| 2007-08-13 09:50:00 | AAPL | Stock | 4.5486 | 4.55 | 4.5268 | 4.5461 | 16593500.0 |
| 2007-08-13 09:55:00 | AAPL | Stock | 4.5457 | 4.5461 | 4.5179 | 4.5289 | 17253180.0 |
| 2007-08-13 10:00:00 | AAPL | Stock | 4.5296 | 4.5518 | 4.5282 | 4.5464 | 12840520.0 |
| 2007-08-13 10:05:00 | AAPL | Stock | 4.5468 | 4.5554 | 4.5379 | 4.5425 | 8729112.0 |
| 2007-08-13 10:10:00 | AAPL | Stock | 4.5425 | 4.5536 | 4.5357 | 4.5396 | 8171352.0 |
| 2007-08-13 10:15:00 | AAPL | Stock | 4.5393 | 4.5625 | 4.5375 | 4.5568 | 11922120.0 |
| 2007-08-13 10:20:00 | AAPL | Stock | 4.5561 | 4.5657 | 4.5486 | 4.5525 | 13252288.0 |
| 2007-08-13 10:25:00 | AAPL | Stock | 4.5525 | 4.5607 | 4.5496 | 4.5568 | 5993092.0 |
| 2007-08-13 10:30:00 | AAPL | Stock | 4.5571 | 4.5582 | 4.5489 | 4.5493 | 5898956.0 |
| 2007-08-13 10:35:00 | AAPL | Stock | 4.5486 | 4.5589 | 4.5446 | 4.5564 | 7898884.0 |
| 2007-08-13 10:40:00 | AAPL | Stock | 4.5557 | 4.5618 | 4.5479 | 4.5536 | 8374744.0 |
| 2007-08-13 10:45:00 | AAPL | Stock | 4.5525 | 4.5746 | 4.55 | 4.5746 | 11127508.0 |
| 2007-08-13 10:50:00 | AAPL | Stock | 4.5736 | 4.5754 | 4.5596 | 4.5639 | 9131528.0 |
| 2007-08-13 10:55:00 | AAPL | Stock | 4.5639 | 4.5675 | 4.5536 | 4.5643 | 7219800.0 |
| 2007-08-13 11:00:00 | AAPL | Stock | 4.5636 | 4.5786 | 4.5636 | 4.5757 | 8849680.0 |
| 2007-08-13 11:05:00 | AAPL | Stock | 4.5761 | 4.5761 | 4.5621 | 4.5714 | 10756312.0 |
| 2007-08-13 11:10:00 | AAPL | Stock | 4.5721 | 4.595 | 4.5721 | 4.5921 | 15734684.0 |
| 2007-08-13 11:15:00 | AAPL | Stock | 4.5929 | 4.605 | 4.5879 | 4.6036 | 13341244.0 |
| 2007-08-13 11:20:00 | AAPL | Stock | 4.6036 | 4.6118 | 4.6 | 4.6 | 13838524.0 |
| 2007-08-13 11:25:00 | AAPL | Stock | 4.6 | 4.6143 | 4.5982 | 4.6136 | 9612120.0 |
| 2007-08-13 11:30:00 | AAPL | Stock | 4.6136 | 4.6175 | 4.6036 | 4.6071 | 14140616.0 |
| 2007-08-13 11:35:00 | AAPL | Stock | 4.6071 | 4.6111 | 4.6018 | 4.6054 | 7092876.0 |
| 2007-08-13 11:40:00 | AAPL | Stock | 4.6043 | 4.6139 | 4.6029 | 4.6125 | 6264244.0 |
| 2007-08-13 11:45:00 | AAPL | Stock | 4.6125 | 4.6161 | 4.6011 | 4.6107 | 7835548.0 |
| 2007-08-13 11:50:00 | AAPL | Stock | 4.6104 | 4.6121 | 4.6036 | 4.6046 | 4678576.0 |
| 2007-08-13 11:55:00 | AAPL | Stock | 4.6046 | 4.61 | 4.5936 | 4.6093 | 8959804.0 |
| 2007-08-13 12:00:00 | AAPL | Stock | 4.6086 | 4.6096 | 4.5968 | 4.6 | 4888100.0 |
| 2007-08-13 12:05:00 | AAPL | Stock | 4.6 | 4.6018 | 4.59 | 4.5989 | 6050212.0 |
| 2007-08-13 12:10:00 | AAPL | Stock | 4.5989 | 4.6011 | 4.5868 | 4.5907 | 5556376.0 |
| 2007-08-13 12:15:00 | AAPL | Stock | 4.5907 | 4.5911 | 4.5818 | 4.5821 | 6055000.0 |
| 2007-08-13 12:20:00 | AAPL | Stock | 4.5821 | 4.5836 | 4.5718 | 4.5764 | 8727068.0 |
| 2007-08-13 12:25:00 | AAPL | Stock | 4.5764 | 4.5871 | 4.5764 | 4.5768 | 5998608.0 |
| 2007-08-13 12:30:00 | AAPL | Stock | 4.5764 | 4.5843 | 4.5764 | 4.5813 | 4374244.0 |
| 2007-08-13 12:35:00 | AAPL | Stock | 4.5814 | 4.5946 | 4.5787 | 4.5907 | 5778164.0 |
| 2007-08-13 12:40:00 | AAPL | Stock | 4.5907 | 4.5968 | 4.585 | 4.5911 | 5970720.0 |
| 2007-08-13 12:45:00 | AAPL | Stock | 4.5907 | 4.5918 | 4.5818 | 4.5889 | 4621204.0 |
| 2007-08-13 12:50:00 | AAPL | Stock | 4.5889 | 4.5954 | 4.5861 | 4.5943 | 4435620.0 |
| 2007-08-13 12:55:00 | AAPL | Stock | 4.5936 | 4.5996 | 4.5921 | 4.5986 | 5917100.0 |
| 2007-08-13 13:00:00 | AAPL | Stock | 4.5982 | 4.6 | 4.5861 | 4.5861 | 5809328.0 |
| 2007-08-13 13:05:00 | AAPL | Stock | 4.5861 | 4.5889 | 4.5786 | 4.5854 | 6693484.0 |
| 2007-08-13 13:10:00 | AAPL | Stock | 4.5857 | 4.5886 | 4.5821 | 4.5829 | 5045516.0 |
| 2007-08-13 13:15:00 | AAPL | Stock | 4.5825 | 4.5911 | 4.5821 | 4.5831 | 6190408.0 |
| 2007-08-13 13:20:00 | AAPL | Stock | 4.5836 | 4.5864 | 4.5668 | 4.58 | 12690048.0 |
| 2007-08-13 13:25:00 | AAPL | Stock | 4.58 | 4.5857 | 4.5743 | 4.5818 | 6559672.0 |
| 2007-08-13 13:30:00 | AAPL | Stock | 4.5821 | 4.5821 | 4.5643 | 4.5804 | 8394568.0 |
| 2007-08-13 13:35:00 | AAPL | Stock | 4.5807 | 4.5889 | 4.5793 | 4.5886 | 6988240.0 |
> showing 50 of 309,759 rows — these rows as CSV