PREVIEW / stock_5min / 2011-04-12
file: by_date/stock_5min/2011/2011-04-12.parquet size: 4.9 MB rows: 331,057 symbols: 3,537
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-04-12 04:00:00 | AAPL | Stock | 11.7679 | 11.7679 | 11.7679 | 11.7679 | 2800.0 |
| 2011-04-12 04:05:00 | AAPL | Stock | 11.7675 | 11.7675 | 11.7675 | 11.7675 | 2800.0 |
| 2011-04-12 04:10:00 | AAPL | Stock | 11.7718 | 11.7743 | 11.7718 | 11.7743 | 8400.0 |
| 2011-04-12 04:15:00 | AAPL | Stock | 11.7761 | 11.7764 | 11.7761 | 11.7764 | 5600.0 |
| 2011-04-12 04:25:00 | AAPL | Stock | 11.7368 | 11.7368 | 11.7368 | 11.7368 | 2800.0 |
| 2011-04-12 04:55:00 | AAPL | Stock | 11.7396 | 11.7396 | 11.7396 | 11.7396 | 2800.0 |
| 2011-04-12 05:10:00 | AAPL | Stock | 11.7364 | 11.7364 | 11.7325 | 11.7364 | 10080.0 |
| 2011-04-12 05:15:00 | AAPL | Stock | 11.7482 | 11.7482 | 11.7482 | 11.7482 | 2800.0 |
| 2011-04-12 05:30:00 | AAPL | Stock | 11.75 | 11.75 | 11.75 | 11.75 | 6160.0 |
| 2011-04-12 05:40:00 | AAPL | Stock | 11.7332 | 11.7332 | 11.7332 | 11.7332 | 2800.0 |
| 2011-04-12 05:55:00 | AAPL | Stock | 11.7329 | 11.7329 | 11.7321 | 11.7321 | 8400.0 |
| 2011-04-12 06:00:00 | AAPL | Stock | 11.7461 | 11.7461 | 11.7461 | 11.7461 | 2800.0 |
| 2011-04-12 06:05:00 | AAPL | Stock | 11.7464 | 11.7464 | 11.7357 | 11.7357 | 8400.0 |
| 2011-04-12 06:10:00 | AAPL | Stock | 11.7321 | 11.7321 | 11.7321 | 11.7321 | 5600.0 |
| 2011-04-12 06:15:00 | AAPL | Stock | 11.7339 | 11.75 | 11.7339 | 11.75 | 34412.0 |
| 2011-04-12 06:50:00 | AAPL | Stock | 11.7393 | 11.7393 | 11.7393 | 11.7393 | 5600.0 |
| 2011-04-12 06:55:00 | AAPL | Stock | 11.7393 | 11.7393 | 11.7393 | 11.7393 | 2800.0 |
| 2011-04-12 07:00:00 | AAPL | Stock | 11.7332 | 11.7332 | 11.7232 | 11.7232 | 5600.0 |
| 2011-04-12 07:05:00 | AAPL | Stock | 11.7218 | 11.7218 | 11.6968 | 11.6968 | 238280.0 |
| 2011-04-12 07:10:00 | AAPL | Stock | 11.7018 | 11.7018 | 11.7018 | 11.7018 | 2800.0 |
| 2011-04-12 07:15:00 | AAPL | Stock | 11.7039 | 11.71 | 11.7039 | 11.71 | 5600.0 |
| 2011-04-12 07:20:00 | AAPL | Stock | 11.725 | 11.7464 | 11.7111 | 11.7143 | 89096.0 |
| 2011-04-12 07:25:00 | AAPL | Stock | 11.7143 | 11.7143 | 11.6971 | 11.6971 | 124180.0 |
| 2011-04-12 07:30:00 | AAPL | Stock | 11.6975 | 11.7075 | 11.6961 | 11.7075 | 99680.0 |
| 2011-04-12 07:35:00 | AAPL | Stock | 11.7079 | 11.7079 | 11.7036 | 11.7036 | 33600.0 |
| 2011-04-12 07:40:00 | AAPL | Stock | 11.7036 | 11.7143 | 11.7025 | 11.7143 | 94360.0 |
| 2011-04-12 07:45:00 | AAPL | Stock | 11.7136 | 11.7139 | 11.7071 | 11.7139 | 89600.0 |
| 2011-04-12 07:50:00 | AAPL | Stock | 11.7136 | 11.7154 | 11.7093 | 11.7143 | 34440.0 |
| 2011-04-12 07:55:00 | AAPL | Stock | 11.715 | 11.7679 | 11.715 | 11.725 | 183260.0 |
| 2011-04-12 08:00:00 | AAPL | Stock | 11.73 | 11.7679 | 11.725 | 11.7679 | 469056.0 |
| 2011-04-12 08:05:00 | AAPL | Stock | 11.7575 | 11.7589 | 11.7468 | 11.7589 | 224196.0 |
| 2011-04-12 08:10:00 | AAPL | Stock | 11.75 | 11.7554 | 11.7468 | 11.75 | 92960.0 |
| 2011-04-12 08:15:00 | AAPL | Stock | 11.7471 | 11.75 | 11.7464 | 11.7468 | 74480.0 |
| 2011-04-12 08:20:00 | AAPL | Stock | 11.7536 | 11.7646 | 11.75 | 11.7643 | 123452.0 |
| 2011-04-12 08:25:00 | AAPL | Stock | 11.7643 | 11.7714 | 11.7589 | 11.7714 | 219660.0 |
| 2011-04-12 08:30:00 | AAPL | Stock | 11.7714 | 11.8032 | 11.7661 | 11.8032 | 664160.0 |
| 2011-04-12 08:35:00 | AAPL | Stock | 11.8032 | 11.8361 | 11.7979 | 11.82 | 1016596.0 |
| 2011-04-12 08:40:00 | AAPL | Stock | 11.8129 | 11.8129 | 11.7939 | 11.7946 | 209860.0 |
| 2011-04-12 08:45:00 | AAPL | Stock | 11.7989 | 11.8011 | 11.7854 | 11.8011 | 157528.0 |
| 2011-04-12 08:50:00 | AAPL | Stock | 11.8014 | 11.8268 | 11.8007 | 11.8268 | 355768.0 |
| 2011-04-12 08:55:00 | AAPL | Stock | 11.8318 | 11.8593 | 11.8236 | 11.8482 | 756616.0 |
| 2011-04-12 09:00:00 | AAPL | Stock | 11.8475 | 11.8561 | 11.8464 | 11.8554 | 526848.0 |
| 2011-04-12 09:05:00 | AAPL | Stock | 11.8554 | 11.8589 | 11.825 | 11.8286 | 513296.0 |
| 2011-04-12 09:10:00 | AAPL | Stock | 11.8282 | 11.8393 | 11.8282 | 11.8389 | 107940.0 |
| 2011-04-12 09:15:00 | AAPL | Stock | 11.8389 | 11.84 | 11.8304 | 11.8396 | 102760.0 |
| 2011-04-12 09:20:00 | AAPL | Stock | 11.8389 | 11.8404 | 11.8286 | 11.8286 | 67200.0 |
| 2011-04-12 09:25:00 | AAPL | Stock | 11.8286 | 11.8321 | 11.8032 | 11.8075 | 1001728.0 |
| 2011-04-12 09:30:00 | AAPL | Stock | 11.8064 | 11.8721 | 11.7929 | 11.8675 | 26204752.0 |
| 2011-04-12 09:35:00 | AAPL | Stock | 11.8679 | 11.885 | 11.8507 | 11.8829 | 17755248.0 |
| 2011-04-12 09:40:00 | AAPL | Stock | 11.8826 | 11.9046 | 11.8729 | 11.8921 | 15940680.0 |
> showing 50 of 331,057 rows — these rows as CSV