PREVIEW / stock_5min / 2010-04-26
file: by_date/stock_5min/2010/2010-04-26.parquet size: 5.0 MB rows: 339,292 symbols: 3,510
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 |
|---|---|---|---|---|---|---|---|
| 2010-04-26 04:20:00 | AAPL | Stock | 9.7143 | 9.7143 | 9.7143 | 9.7143 | 5600.0 |
| 2010-04-26 04:35:00 | AAPL | Stock | 9.7143 | 9.7143 | 9.7143 | 9.7143 | 5600.0 |
| 2010-04-26 05:10:00 | AAPL | Stock | 9.7143 | 9.7143 | 9.7143 | 9.7143 | 5600.0 |
| 2010-04-26 05:40:00 | AAPL | Stock | 9.7143 | 9.7143 | 9.7143 | 9.7143 | 37548.0 |
| 2010-04-26 06:10:00 | AAPL | Stock | 9.7221 | 9.7232 | 9.7221 | 9.7232 | 5600.0 |
| 2010-04-26 06:15:00 | AAPL | Stock | 9.7232 | 9.7232 | 9.7232 | 9.7232 | 11200.0 |
| 2010-04-26 06:35:00 | AAPL | Stock | 9.725 | 9.725 | 9.7232 | 9.7232 | 14000.0 |
| 2010-04-26 06:40:00 | AAPL | Stock | 9.7179 | 9.725 | 9.7179 | 9.725 | 10976.0 |
| 2010-04-26 06:55:00 | AAPL | Stock | 9.7286 | 9.7286 | 9.7286 | 9.7286 | 2800.0 |
| 2010-04-26 07:00:00 | AAPL | Stock | 9.7321 | 9.7357 | 9.7321 | 9.7357 | 71960.0 |
| 2010-04-26 07:05:00 | AAPL | Stock | 9.7357 | 9.7411 | 9.7325 | 9.7375 | 42588.0 |
| 2010-04-26 07:10:00 | AAPL | Stock | 9.7357 | 9.7375 | 9.7357 | 9.7357 | 15120.0 |
| 2010-04-26 07:15:00 | AAPL | Stock | 9.7321 | 9.7321 | 9.7314 | 9.7314 | 34272.0 |
| 2010-04-26 07:20:00 | AAPL | Stock | 9.7321 | 9.7375 | 9.7318 | 9.7375 | 34160.0 |
| 2010-04-26 07:25:00 | AAPL | Stock | 9.7357 | 9.7357 | 9.7296 | 9.7296 | 8400.0 |
| 2010-04-26 07:30:00 | AAPL | Stock | 9.7371 | 9.7407 | 9.7311 | 9.7321 | 20720.0 |
| 2010-04-26 07:35:00 | AAPL | Stock | 9.7411 | 9.7429 | 9.7411 | 9.7411 | 39200.0 |
| 2010-04-26 07:40:00 | AAPL | Stock | 9.7321 | 9.7321 | 9.7321 | 9.7321 | 16800.0 |
| 2010-04-26 07:50:00 | AAPL | Stock | 9.7321 | 9.7375 | 9.7286 | 9.7375 | 14000.0 |
| 2010-04-26 07:55:00 | AAPL | Stock | 9.7311 | 9.7321 | 9.7311 | 9.7321 | 19600.0 |
| 2010-04-26 08:00:00 | AAPL | Stock | 9.7321 | 9.7321 | 9.7107 | 9.7179 | 922600.0 |
| 2010-04-26 08:05:00 | AAPL | Stock | 9.7179 | 9.7193 | 9.6914 | 9.7004 | 493724.0 |
| 2010-04-26 08:10:00 | AAPL | Stock | 9.7018 | 9.7107 | 9.7018 | 9.7036 | 187460.0 |
| 2010-04-26 08:15:00 | AAPL | Stock | 9.7064 | 9.7093 | 9.7039 | 9.7054 | 129136.0 |
| 2010-04-26 08:20:00 | AAPL | Stock | 9.7004 | 9.7175 | 9.7 | 9.7107 | 455000.0 |
| 2010-04-26 08:25:00 | AAPL | Stock | 9.7107 | 9.7209 | 9.7057 | 9.7143 | 336560.0 |
| 2010-04-26 08:30:00 | AAPL | Stock | 9.7171 | 9.7189 | 9.6986 | 9.7107 | 600936.0 |
| 2010-04-26 08:35:00 | AAPL | Stock | 9.7107 | 9.7121 | 9.7061 | 9.7086 | 76160.0 |
| 2010-04-26 08:40:00 | AAPL | Stock | 9.7107 | 9.7143 | 9.7054 | 9.7143 | 276696.0 |
| 2010-04-26 08:45:00 | AAPL | Stock | 9.7096 | 9.7136 | 9.7057 | 9.7077 | 91084.0 |
| 2010-04-26 08:50:00 | AAPL | Stock | 9.7125 | 9.7143 | 9.7057 | 9.7143 | 219268.0 |
| 2010-04-26 08:55:00 | AAPL | Stock | 9.7179 | 9.7186 | 9.7125 | 9.7136 | 224308.0 |
| 2010-04-26 09:00:00 | AAPL | Stock | 9.7107 | 9.7182 | 9.7107 | 9.7179 | 77476.0 |
| 2010-04-26 09:05:00 | AAPL | Stock | 9.7179 | 9.7218 | 9.7143 | 9.7157 | 176232.0 |
| 2010-04-26 09:10:00 | AAPL | Stock | 9.715 | 9.7161 | 9.7111 | 9.7132 | 81844.0 |
| 2010-04-26 09:15:00 | AAPL | Stock | 9.7143 | 9.7154 | 9.7071 | 9.7071 | 154840.0 |
| 2010-04-26 09:20:00 | AAPL | Stock | 9.7089 | 9.7114 | 9.7054 | 9.7114 | 170520.0 |
| 2010-04-26 09:25:00 | AAPL | Stock | 9.7114 | 9.7118 | 9.7068 | 9.7082 | 117600.0 |
| 2010-04-26 09:30:00 | AAPL | Stock | 9.71 | 9.7307 | 9.6971 | 9.7032 | 24976672.0 |
| 2010-04-26 09:35:00 | AAPL | Stock | 9.7032 | 9.7098 | 9.6786 | 9.6932 | 16167928.0 |
| 2010-04-26 09:40:00 | AAPL | Stock | 9.6946 | 9.7036 | 9.6664 | 9.675 | 14139048.0 |
| 2010-04-26 09:45:00 | AAPL | Stock | 9.675 | 9.6814 | 9.6357 | 9.658 | 21182224.0 |
| 2010-04-26 09:50:00 | AAPL | Stock | 9.6571 | 9.6579 | 9.6361 | 9.6439 | 12881484.0 |
| 2010-04-26 09:55:00 | AAPL | Stock | 9.6439 | 9.6486 | 9.5843 | 9.595 | 25389336.0 |
| 2010-04-26 10:00:00 | AAPL | Stock | 9.5966 | 9.63 | 9.595 | 9.6218 | 14320516.0 |
| 2010-04-26 10:05:00 | AAPL | Stock | 9.6204 | 9.6421 | 9.6171 | 9.6404 | 8996680.0 |
| 2010-04-26 10:10:00 | AAPL | Stock | 9.6411 | 9.6536 | 9.6392 | 9.6405 | 8011696.0 |
| 2010-04-26 10:15:00 | AAPL | Stock | 9.6417 | 9.6436 | 9.6096 | 9.6107 | 8691312.0 |
| 2010-04-26 10:20:00 | AAPL | Stock | 9.6129 | 9.6375 | 9.6107 | 9.6375 | 6271972.0 |
| 2010-04-26 10:25:00 | AAPL | Stock | 9.6375 | 9.6464 | 9.6196 | 9.6204 | 4768064.0 |
> showing 50 of 339,292 rows — these rows as CSV