PREVIEW / stock_5min / 2011-03-03
file: by_date/stock_5min/2011/2011-03-03.parquet size: 5.0 MB rows: 339,396 symbols: 3,525
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-03-03 04:00:00 | AAPL | Stock | 12.6721 | 12.6764 | 12.6721 | 12.6764 | 28000.0 |
| 2011-03-03 04:05:00 | AAPL | Stock | 12.6764 | 12.6764 | 12.6754 | 12.6754 | 5600.0 |
| 2011-03-03 04:40:00 | AAPL | Stock | 12.6743 | 12.6743 | 12.6743 | 12.6743 | 2800.0 |
| 2011-03-03 04:45:00 | AAPL | Stock | 12.6743 | 12.6743 | 12.6743 | 12.6743 | 5600.0 |
| 2011-03-03 04:55:00 | AAPL | Stock | 12.6696 | 12.6696 | 12.6696 | 12.6696 | 2800.0 |
| 2011-03-03 05:00:00 | AAPL | Stock | 12.6743 | 12.6743 | 12.6743 | 12.6743 | 2800.0 |
| 2011-03-03 05:05:00 | AAPL | Stock | 12.6743 | 12.6743 | 12.6743 | 12.6743 | 2800.0 |
| 2011-03-03 05:10:00 | AAPL | Stock | 12.6743 | 12.675 | 12.6736 | 12.675 | 19600.0 |
| 2011-03-03 05:15:00 | AAPL | Stock | 12.6714 | 12.675 | 12.6714 | 12.675 | 5600.0 |
| 2011-03-03 05:20:00 | AAPL | Stock | 12.675 | 12.675 | 12.675 | 12.675 | 2800.0 |
| 2011-03-03 05:25:00 | AAPL | Stock | 12.675 | 12.675 | 12.675 | 12.675 | 19600.0 |
| 2011-03-03 05:30:00 | AAPL | Stock | 12.6764 | 12.6764 | 12.6754 | 12.6761 | 19600.0 |
| 2011-03-03 05:35:00 | AAPL | Stock | 12.6761 | 12.6764 | 12.675 | 12.675 | 95200.0 |
| 2011-03-03 05:45:00 | AAPL | Stock | 12.6732 | 12.6732 | 12.6732 | 12.6732 | 16520.0 |
| 2011-03-03 05:50:00 | AAPL | Stock | 12.6732 | 12.6732 | 12.6732 | 12.6732 | 2800.0 |
| 2011-03-03 06:00:00 | AAPL | Stock | 12.6732 | 12.6743 | 12.6732 | 12.6743 | 14000.0 |
| 2011-03-03 06:05:00 | AAPL | Stock | 12.6743 | 12.6743 | 12.6643 | 12.6643 | 24640.0 |
| 2011-03-03 06:15:00 | AAPL | Stock | 12.675 | 12.6764 | 12.675 | 12.6764 | 58800.0 |
| 2011-03-03 06:20:00 | AAPL | Stock | 12.6764 | 12.6764 | 12.6764 | 12.6764 | 2800.0 |
| 2011-03-03 06:25:00 | AAPL | Stock | 12.675 | 12.6757 | 12.675 | 12.6757 | 19600.0 |
| 2011-03-03 06:30:00 | AAPL | Stock | 12.675 | 12.6764 | 12.675 | 12.6764 | 84000.0 |
| 2011-03-03 06:35:00 | AAPL | Stock | 12.675 | 12.6764 | 12.675 | 12.6764 | 47880.0 |
| 2011-03-03 06:40:00 | AAPL | Stock | 12.6764 | 12.6764 | 12.6764 | 12.6764 | 30800.0 |
| 2011-03-03 06:45:00 | AAPL | Stock | 12.675 | 12.675 | 12.675 | 12.675 | 9800.0 |
| 2011-03-03 06:50:00 | AAPL | Stock | 12.675 | 12.6764 | 12.675 | 12.675 | 31948.0 |
| 2011-03-03 07:00:00 | AAPL | Stock | 12.675 | 12.6764 | 12.6668 | 12.6696 | 79800.0 |
| 2011-03-03 07:05:00 | AAPL | Stock | 12.6714 | 12.6714 | 12.665 | 12.6679 | 49000.0 |
| 2011-03-03 07:10:00 | AAPL | Stock | 12.6643 | 12.6657 | 12.6561 | 12.6657 | 30660.0 |
| 2011-03-03 07:15:00 | AAPL | Stock | 12.6643 | 12.6882 | 12.6643 | 12.6821 | 173432.0 |
| 2011-03-03 07:20:00 | AAPL | Stock | 12.6821 | 12.6957 | 12.6786 | 12.6911 | 92232.0 |
| 2011-03-03 07:25:00 | AAPL | Stock | 12.6861 | 12.6861 | 12.6786 | 12.6786 | 63056.0 |
| 2011-03-03 07:30:00 | AAPL | Stock | 12.6821 | 12.7018 | 12.6821 | 12.7018 | 100940.0 |
| 2011-03-03 07:35:00 | AAPL | Stock | 12.7018 | 12.7036 | 12.6964 | 12.6964 | 212912.0 |
| 2011-03-03 07:40:00 | AAPL | Stock | 12.6964 | 12.6971 | 12.6946 | 12.6971 | 95788.0 |
| 2011-03-03 07:45:00 | AAPL | Stock | 12.6871 | 12.6871 | 12.6857 | 12.6857 | 7000.0 |
| 2011-03-03 07:50:00 | AAPL | Stock | 12.6857 | 12.7 | 12.6821 | 12.7 | 99540.0 |
| 2011-03-03 07:55:00 | AAPL | Stock | 12.7018 | 12.7029 | 12.6964 | 12.6964 | 50540.0 |
| 2011-03-03 08:00:00 | AAPL | Stock | 12.6946 | 12.6964 | 12.6718 | 12.6882 | 449652.0 |
| 2011-03-03 08:05:00 | AAPL | Stock | 12.6857 | 12.6882 | 12.6786 | 12.6786 | 184856.0 |
| 2011-03-03 08:10:00 | AAPL | Stock | 12.6786 | 12.6875 | 12.6786 | 12.6857 | 179900.0 |
| 2011-03-03 08:15:00 | AAPL | Stock | 12.6868 | 12.6946 | 12.6786 | 12.6821 | 253008.0 |
| 2011-03-03 08:20:00 | AAPL | Stock | 12.6871 | 12.6871 | 12.6793 | 12.6839 | 110824.0 |
| 2011-03-03 08:25:00 | AAPL | Stock | 12.6821 | 12.6868 | 12.6789 | 12.6814 | 495320.0 |
| 2011-03-03 08:30:00 | AAPL | Stock | 12.6814 | 12.7029 | 12.6786 | 12.6993 | 915796.0 |
| 2011-03-03 08:35:00 | AAPL | Stock | 12.7 | 12.7139 | 12.7 | 12.7036 | 931980.0 |
| 2011-03-03 08:40:00 | AAPL | Stock | 12.7036 | 12.7139 | 12.7036 | 12.7139 | 191884.0 |
| 2011-03-03 08:45:00 | AAPL | Stock | 12.7139 | 12.7243 | 12.7111 | 12.7221 | 925932.0 |
| 2011-03-03 08:50:00 | AAPL | Stock | 12.725 | 12.725 | 12.7046 | 12.7132 | 518112.0 |
| 2011-03-03 08:55:00 | AAPL | Stock | 12.7139 | 12.7179 | 12.7125 | 12.7175 | 150136.0 |
| 2011-03-03 09:00:00 | AAPL | Stock | 12.7146 | 12.7214 | 12.7132 | 12.7171 | 302988.0 |
> showing 50 of 339,396 rows — these rows as CSV