PREVIEW / stock_5min / 2013-05-29
file: by_date/stock_5min/2013/2013-05-29.parquet size: 5.2 MB rows: 344,621 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 |
|---|---|---|---|---|---|---|---|
| 2013-05-29 05:15:00 | AAPL | Stock | 15.7239 | 15.7239 | 15.7239 | 15.7239 | 2800.0 |
| 2013-05-29 06:20:00 | AAPL | Stock | 15.7239 | 15.7239 | 15.7229 | 15.7229 | 16800.0 |
| 2013-05-29 06:40:00 | AAPL | Stock | 15.7118 | 15.7118 | 15.7118 | 15.7118 | 2800.0 |
| 2013-05-29 07:00:00 | AAPL | Stock | 15.6793 | 15.6896 | 15.6671 | 15.6696 | 147588.0 |
| 2013-05-29 07:05:00 | AAPL | Stock | 15.6786 | 15.6786 | 15.6554 | 15.6554 | 39060.0 |
| 2013-05-29 07:10:00 | AAPL | Stock | 15.6557 | 15.6607 | 15.6504 | 15.6557 | 23324.0 |
| 2013-05-29 07:15:00 | AAPL | Stock | 15.6661 | 15.6732 | 15.6661 | 15.6732 | 10080.0 |
| 2013-05-29 07:20:00 | AAPL | Stock | 15.6725 | 15.6786 | 15.6696 | 15.67 | 78624.0 |
| 2013-05-29 07:25:00 | AAPL | Stock | 15.6643 | 15.6814 | 15.6643 | 15.6668 | 16800.0 |
| 2013-05-29 07:30:00 | AAPL | Stock | 15.6625 | 15.6675 | 15.6518 | 15.6661 | 100912.0 |
| 2013-05-29 07:35:00 | AAPL | Stock | 15.6675 | 15.6696 | 15.6675 | 15.6696 | 5600.0 |
| 2013-05-29 07:40:00 | AAPL | Stock | 15.6679 | 15.6786 | 15.6679 | 15.6786 | 42000.0 |
| 2013-05-29 07:45:00 | AAPL | Stock | 15.6786 | 15.6786 | 15.6536 | 15.6571 | 65800.0 |
| 2013-05-29 07:50:00 | AAPL | Stock | 15.6571 | 15.6571 | 15.6382 | 15.6382 | 70224.0 |
| 2013-05-29 07:55:00 | AAPL | Stock | 15.6357 | 15.6357 | 15.6243 | 15.6261 | 53200.0 |
| 2013-05-29 08:00:00 | AAPL | Stock | 15.6379 | 15.7321 | 15.6211 | 15.7321 | 316820.0 |
| 2013-05-29 08:05:00 | AAPL | Stock | 15.6311 | 15.6311 | 15.5964 | 15.6129 | 384328.0 |
| 2013-05-29 08:10:00 | AAPL | Stock | 15.6111 | 15.6246 | 15.6107 | 15.6243 | 44520.0 |
| 2013-05-29 08:15:00 | AAPL | Stock | 15.625 | 15.6425 | 15.625 | 15.6425 | 219968.0 |
| 2013-05-29 08:20:00 | AAPL | Stock | 15.6421 | 15.6657 | 15.6421 | 15.6636 | 330428.0 |
| 2013-05-29 08:25:00 | AAPL | Stock | 15.6607 | 15.6904 | 15.6504 | 15.6889 | 207340.0 |
| 2013-05-29 08:30:00 | AAPL | Stock | 15.6889 | 15.6964 | 15.6704 | 15.6964 | 168168.0 |
| 2013-05-29 08:35:00 | AAPL | Stock | 15.6896 | 15.7004 | 15.6679 | 15.6789 | 250404.0 |
| 2013-05-29 08:40:00 | AAPL | Stock | 15.68 | 15.6893 | 15.6786 | 15.6893 | 92036.0 |
| 2013-05-29 08:45:00 | AAPL | Stock | 15.6929 | 15.6971 | 15.6796 | 15.6964 | 70924.0 |
| 2013-05-29 08:50:00 | AAPL | Stock | 15.6911 | 15.7018 | 15.6893 | 15.6893 | 97300.0 |
| 2013-05-29 08:55:00 | AAPL | Stock | 15.6904 | 15.6964 | 15.6889 | 15.6889 | 85568.0 |
| 2013-05-29 09:00:00 | AAPL | Stock | 15.6957 | 15.7132 | 15.6939 | 15.7114 | 228788.0 |
| 2013-05-29 09:05:00 | AAPL | Stock | 15.7132 | 15.7275 | 15.7132 | 15.7254 | 189756.0 |
| 2013-05-29 09:10:00 | AAPL | Stock | 15.7246 | 15.7246 | 15.7043 | 15.7136 | 109228.0 |
| 2013-05-29 09:15:00 | AAPL | Stock | 15.7143 | 15.7168 | 15.6968 | 15.7079 | 70196.0 |
| 2013-05-29 09:20:00 | AAPL | Stock | 15.7057 | 15.7279 | 15.7057 | 15.7279 | 156856.0 |
| 2013-05-29 09:25:00 | AAPL | Stock | 15.7289 | 15.7321 | 15.7129 | 15.7146 | 165144.0 |
| 2013-05-29 09:30:00 | AAPL | Stock | 15.7143 | 15.8393 | 15.6929 | 15.8246 | 16812404.0 |
| 2013-05-29 09:35:00 | AAPL | Stock | 15.8282 | 15.8929 | 15.8246 | 15.8518 | 12922868.0 |
| 2013-05-29 09:40:00 | AAPL | Stock | 15.8532 | 15.8711 | 15.8143 | 15.8407 | 8351028.0 |
| 2013-05-29 09:45:00 | AAPL | Stock | 15.8414 | 15.8679 | 15.825 | 15.8536 | 5893132.0 |
| 2013-05-29 09:50:00 | AAPL | Stock | 15.8536 | 15.8746 | 15.8396 | 15.8661 | 5955684.0 |
| 2013-05-29 09:55:00 | AAPL | Stock | 15.8698 | 15.915 | 15.8492 | 15.8943 | 9919420.0 |
| 2013-05-29 10:00:00 | AAPL | Stock | 15.8943 | 15.9357 | 15.8879 | 15.9164 | 10564092.0 |
| 2013-05-29 10:05:00 | AAPL | Stock | 15.9193 | 15.9221 | 15.8664 | 15.8971 | 9277268.0 |
| 2013-05-29 10:10:00 | AAPL | Stock | 15.8975 | 15.93 | 15.8882 | 15.9121 | 5906404.0 |
| 2013-05-29 10:15:00 | AAPL | Stock | 15.9125 | 15.9404 | 15.9082 | 15.9297 | 7026012.0 |
| 2013-05-29 10:20:00 | AAPL | Stock | 15.9354 | 15.9386 | 15.8868 | 15.8893 | 5113892.0 |
| 2013-05-29 10:25:00 | AAPL | Stock | 15.8896 | 15.9 | 15.8707 | 15.8886 | 3795652.0 |
| 2013-05-29 10:30:00 | AAPL | Stock | 15.8886 | 15.8982 | 15.8721 | 15.8879 | 3605700.0 |
| 2013-05-29 10:35:00 | AAPL | Stock | 15.8839 | 15.8882 | 15.8321 | 15.8489 | 4482156.0 |
| 2013-05-29 10:40:00 | AAPL | Stock | 15.8505 | 15.8568 | 15.7914 | 15.8214 | 6600216.0 |
| 2013-05-29 10:45:00 | AAPL | Stock | 15.8214 | 15.84 | 15.8086 | 15.8261 | 4737824.0 |
| 2013-05-29 10:50:00 | AAPL | Stock | 15.8259 | 15.84 | 15.8125 | 15.8386 | 2478224.0 |
> showing 50 of 344,621 rows — these rows as CSV