PREVIEW / stock_5min / 2005-10-25
file: by_date/stock_5min/2005/2005-10-25.parquet size: 2.8 MB rows: 204,483 symbols: 2,100
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 |
|---|---|---|---|---|---|---|---|
| 2005-10-25 07:50:00 | AAPL | Stock | 2.0143 | 2.0143 | 2.0143 | 2.0143 | 7000.0 |
| 2005-10-25 08:00:00 | AAPL | Stock | 2.0143 | 2.0143 | 2.0107 | 2.0143 | 116116.0 |
| 2005-10-25 08:05:00 | AAPL | Stock | 2.0143 | 2.0143 | 2.0143 | 2.0143 | 44016.0 |
| 2005-10-25 08:10:00 | AAPL | Stock | 2.0143 | 2.0179 | 2.0136 | 2.0179 | 130984.0 |
| 2005-10-25 08:15:00 | AAPL | Stock | 2.0161 | 2.0175 | 2.015 | 2.0175 | 36400.0 |
| 2005-10-25 08:20:00 | AAPL | Stock | 2.0143 | 2.015 | 2.0107 | 2.0107 | 212800.0 |
| 2005-10-25 08:25:00 | AAPL | Stock | 2.0114 | 2.0143 | 2.0111 | 2.0143 | 33600.0 |
| 2005-10-25 08:30:00 | AAPL | Stock | 2.0114 | 2.0139 | 2.0114 | 2.0139 | 19600.0 |
| 2005-10-25 08:35:00 | AAPL | Stock | 2.0143 | 2.0143 | 2.0143 | 2.0143 | 11200.0 |
| 2005-10-25 08:40:00 | AAPL | Stock | 2.0136 | 2.0139 | 2.0136 | 2.0139 | 25760.0 |
| 2005-10-25 08:45:00 | AAPL | Stock | 2.0125 | 2.0139 | 2.0125 | 2.0139 | 9408.0 |
| 2005-10-25 08:50:00 | AAPL | Stock | 2.0143 | 2.0143 | 2.0136 | 2.0136 | 67200.0 |
| 2005-10-25 08:55:00 | AAPL | Stock | 2.0143 | 2.0161 | 2.0143 | 2.0161 | 102116.0 |
| 2005-10-25 09:00:00 | AAPL | Stock | 2.0139 | 2.0139 | 2.0136 | 2.0136 | 36400.0 |
| 2005-10-25 09:05:00 | AAPL | Stock | 2.0139 | 2.0139 | 2.0139 | 2.0139 | 19600.0 |
| 2005-10-25 09:10:00 | AAPL | Stock | 2.0168 | 2.0168 | 2.0168 | 2.0168 | 5600.0 |
| 2005-10-25 09:20:00 | AAPL | Stock | 2.0143 | 2.0143 | 2.0143 | 2.0143 | 92400.0 |
| 2005-10-25 09:25:00 | AAPL | Stock | 2.0143 | 2.0146 | 2.0121 | 2.0146 | 1123360.0 |
| 2005-10-25 09:30:00 | AAPL | Stock | 2.0143 | 2.0207 | 2.0075 | 2.0093 | 17170580.0 |
| 2005-10-25 09:35:00 | AAPL | Stock | 2.0093 | 2.0143 | 2.0079 | 2.0118 | 8435056.0 |
| 2005-10-25 09:40:00 | AAPL | Stock | 2.0114 | 2.0161 | 2.0089 | 2.0121 | 8929844.0 |
| 2005-10-25 09:45:00 | AAPL | Stock | 2.0121 | 2.0136 | 2.0025 | 2.0046 | 6792352.0 |
| 2005-10-25 09:50:00 | AAPL | Stock | 2.0043 | 2.015 | 2.0036 | 2.0132 | 12139960.0 |
| 2005-10-25 09:55:00 | AAPL | Stock | 2.0136 | 2.0168 | 2.0107 | 2.0121 | 11013772.0 |
| 2005-10-25 10:00:00 | AAPL | Stock | 2.0121 | 2.0125 | 2.0039 | 2.0096 | 9703036.0 |
| 2005-10-25 10:05:00 | AAPL | Stock | 2.01 | 2.0118 | 2.0054 | 2.0104 | 5955460.0 |
| 2005-10-25 10:10:00 | AAPL | Stock | 2.0104 | 2.0161 | 2.01 | 2.0154 | 18661804.0 |
| 2005-10-25 10:15:00 | AAPL | Stock | 2.0157 | 2.0204 | 2.0129 | 2.0171 | 9300060.0 |
| 2005-10-25 10:20:00 | AAPL | Stock | 2.0171 | 2.0229 | 2.0161 | 2.0229 | 7838264.0 |
| 2005-10-25 10:25:00 | AAPL | Stock | 2.0229 | 2.0304 | 2.0211 | 2.0304 | 13932996.0 |
| 2005-10-25 10:30:00 | AAPL | Stock | 2.0304 | 2.0304 | 2.0157 | 2.0193 | 15313424.0 |
| 2005-10-25 10:35:00 | AAPL | Stock | 2.0193 | 2.0225 | 2.0179 | 2.0182 | 8090040.0 |
| 2005-10-25 10:40:00 | AAPL | Stock | 2.0182 | 2.0196 | 2.0129 | 2.0143 | 10221988.0 |
| 2005-10-25 10:45:00 | AAPL | Stock | 2.0136 | 2.0164 | 2.0125 | 2.0143 | 6931736.0 |
| 2005-10-25 10:50:00 | AAPL | Stock | 2.0143 | 2.0157 | 2.0093 | 2.0157 | 4374440.0 |
| 2005-10-25 10:55:00 | AAPL | Stock | 2.0154 | 2.0157 | 2.0071 | 2.0079 | 5575080.0 |
| 2005-10-25 11:00:00 | AAPL | Stock | 2.0082 | 2.01 | 2.0071 | 2.0089 | 3622584.0 |
| 2005-10-25 11:05:00 | AAPL | Stock | 2.0089 | 2.0129 | 2.0075 | 2.0086 | 5768812.0 |
| 2005-10-25 11:10:00 | AAPL | Stock | 2.0089 | 2.0104 | 2.0043 | 2.0057 | 7648956.0 |
| 2005-10-25 11:15:00 | AAPL | Stock | 2.0057 | 2.0093 | 2.0025 | 2.0025 | 5549376.0 |
| 2005-10-25 11:20:00 | AAPL | Stock | 2.0025 | 2.0068 | 2.0021 | 2.0054 | 4306848.0 |
| 2005-10-25 11:25:00 | AAPL | Stock | 2.005 | 2.0068 | 2.0029 | 2.0036 | 3996160.0 |
| 2005-10-25 11:30:00 | AAPL | Stock | 2.0035 | 2.0039 | 2.0 | 2.0018 | 7900760.0 |
| 2005-10-25 11:35:00 | AAPL | Stock | 2.0018 | 2.0029 | 1.9971 | 2.0025 | 10933580.0 |
| 2005-10-25 11:40:00 | AAPL | Stock | 2.0021 | 2.0068 | 2.0018 | 2.0054 | 5611956.0 |
| 2005-10-25 11:45:00 | AAPL | Stock | 2.0054 | 2.0068 | 2.0032 | 2.0054 | 2805516.0 |
| 2005-10-25 11:50:00 | AAPL | Stock | 2.005 | 2.0057 | 2.0021 | 2.0043 | 2376500.0 |
| 2005-10-25 11:55:00 | AAPL | Stock | 2.0043 | 2.0054 | 2.0004 | 2.0014 | 3406816.0 |
| 2005-10-25 12:00:00 | AAPL | Stock | 2.0018 | 2.0039 | 2.0004 | 2.0035 | 2653140.0 |
| 2005-10-25 12:05:00 | AAPL | Stock | 2.0035 | 2.0046 | 2.0 | 2.0017 | 2735488.0 |
> showing 50 of 204,483 rows — these rows as CSV