PREVIEW / stock_5min / 2012-12-24
file: by_date/stock_5min/2012/2012-12-24.parquet size: 2.7 MB rows: 175,494 symbols: 3,456
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 |
|---|---|---|---|---|---|---|---|
| 2012-12-24 04:00:00 | AAPL | Stock | 18.5393 | 18.5393 | 18.5393 | 18.5393 | 2800.0 |
| 2012-12-24 04:20:00 | AAPL | Stock | 18.5818 | 18.5818 | 18.5818 | 18.5818 | 56000.0 |
| 2012-12-24 05:25:00 | AAPL | Stock | 18.6064 | 18.6064 | 18.6064 | 18.6064 | 2800.0 |
| 2012-12-24 05:50:00 | AAPL | Stock | 18.6064 | 18.6064 | 18.6064 | 18.6064 | 69860.0 |
| 2012-12-24 05:55:00 | AAPL | Stock | 18.6064 | 18.6064 | 18.6064 | 18.6064 | 8400.0 |
| 2012-12-24 06:20:00 | AAPL | Stock | 18.625 | 18.625 | 18.625 | 18.625 | 2800.0 |
| 2012-12-24 07:00:00 | AAPL | Stock | 18.625 | 18.6429 | 18.625 | 18.6429 | 26180.0 |
| 2012-12-24 07:05:00 | AAPL | Stock | 18.6532 | 18.6554 | 18.6532 | 18.6554 | 21840.0 |
| 2012-12-24 07:10:00 | AAPL | Stock | 18.6554 | 18.6554 | 18.6554 | 18.6554 | 7000.0 |
| 2012-12-24 07:15:00 | AAPL | Stock | 18.6289 | 18.6293 | 18.625 | 18.625 | 30240.0 |
| 2012-12-24 07:20:00 | AAPL | Stock | 18.6036 | 18.6036 | 18.5714 | 18.5714 | 34832.0 |
| 2012-12-24 07:25:00 | AAPL | Stock | 18.6014 | 18.6161 | 18.6014 | 18.6161 | 51940.0 |
| 2012-12-24 07:30:00 | AAPL | Stock | 18.6168 | 18.6168 | 18.6161 | 18.6161 | 6300.0 |
| 2012-12-24 07:35:00 | AAPL | Stock | 18.6321 | 18.6407 | 18.6182 | 18.6407 | 30128.0 |
| 2012-12-24 07:40:00 | AAPL | Stock | 18.6429 | 18.6429 | 18.6189 | 18.6375 | 25200.0 |
| 2012-12-24 07:45:00 | AAPL | Stock | 18.6232 | 18.6232 | 18.5789 | 18.5789 | 61796.0 |
| 2012-12-24 07:50:00 | AAPL | Stock | 18.5839 | 18.5889 | 18.5839 | 18.5839 | 16688.0 |
| 2012-12-24 07:55:00 | AAPL | Stock | 18.6068 | 18.6082 | 18.6054 | 18.6071 | 34300.0 |
| 2012-12-24 08:00:00 | AAPL | Stock | 18.6225 | 18.6421 | 18.5475 | 18.5475 | 143248.0 |
| 2012-12-24 08:05:00 | AAPL | Stock | 18.6429 | 18.6518 | 18.6321 | 18.6432 | 67928.0 |
| 2012-12-24 08:10:00 | AAPL | Stock | 18.6518 | 18.71 | 18.6482 | 18.7089 | 237328.0 |
| 2012-12-24 08:15:00 | AAPL | Stock | 18.7071 | 18.7143 | 18.6857 | 18.7036 | 248808.0 |
| 2012-12-24 08:20:00 | AAPL | Stock | 18.7032 | 18.7579 | 18.6964 | 18.7493 | 429380.0 |
| 2012-12-24 08:25:00 | AAPL | Stock | 18.7411 | 18.7504 | 18.7286 | 18.7393 | 246428.0 |
| 2012-12-24 08:30:00 | AAPL | Stock | 18.7507 | 18.7571 | 18.7321 | 18.7343 | 218372.0 |
| 2012-12-24 08:35:00 | AAPL | Stock | 18.7411 | 18.7714 | 18.7411 | 18.75 | 322140.0 |
| 2012-12-24 08:40:00 | AAPL | Stock | 18.7432 | 18.7489 | 18.7221 | 18.7221 | 161840.0 |
| 2012-12-24 08:45:00 | AAPL | Stock | 18.7179 | 18.7282 | 18.6964 | 18.6964 | 234472.0 |
| 2012-12-24 08:50:00 | AAPL | Stock | 18.6882 | 18.7211 | 18.6882 | 18.7093 | 118160.0 |
| 2012-12-24 08:55:00 | AAPL | Stock | 18.7071 | 18.7071 | 18.6964 | 18.6996 | 75600.0 |
| 2012-12-24 09:00:00 | AAPL | Stock | 18.6964 | 18.6964 | 18.6575 | 18.6596 | 288652.0 |
| 2012-12-24 09:05:00 | AAPL | Stock | 18.6464 | 18.6914 | 18.6464 | 18.6914 | 254996.0 |
| 2012-12-24 09:10:00 | AAPL | Stock | 18.6914 | 18.7025 | 18.6789 | 18.6821 | 103320.0 |
| 2012-12-24 09:15:00 | AAPL | Stock | 18.6839 | 18.6839 | 18.6429 | 18.6589 | 333340.0 |
| 2012-12-24 09:20:00 | AAPL | Stock | 18.6536 | 18.6536 | 18.6468 | 18.6468 | 68180.0 |
| 2012-12-24 09:25:00 | AAPL | Stock | 18.655 | 18.6721 | 18.5768 | 18.5768 | 908096.0 |
| 2012-12-24 09:30:00 | AAPL | Stock | 18.5839 | 18.6429 | 18.5539 | 18.6332 | 13207152.0 |
| 2012-12-24 09:35:00 | AAPL | Stock | 18.6386 | 18.6689 | 18.6129 | 18.6429 | 6825420.0 |
| 2012-12-24 09:40:00 | AAPL | Stock | 18.6425 | 18.7179 | 18.6407 | 18.7051 | 8044708.0 |
| 2012-12-24 09:45:00 | AAPL | Stock | 18.7061 | 18.7232 | 18.6693 | 18.7082 | 6179292.0 |
| 2012-12-24 09:50:00 | AAPL | Stock | 18.7082 | 18.7125 | 18.6182 | 18.635 | 7205100.0 |
| 2012-12-24 09:55:00 | AAPL | Stock | 18.6346 | 18.7004 | 18.625 | 18.6746 | 5647852.0 |
| 2012-12-24 10:00:00 | AAPL | Stock | 18.6782 | 18.6946 | 18.6689 | 18.6811 | 3084984.0 |
| 2012-12-24 10:05:00 | AAPL | Stock | 18.6796 | 18.6927 | 18.6457 | 18.6532 | 4078900.0 |
| 2012-12-24 10:10:00 | AAPL | Stock | 18.6507 | 18.6864 | 18.6468 | 18.6652 | 3448984.0 |
| 2012-12-24 10:15:00 | AAPL | Stock | 18.6675 | 18.6775 | 18.6507 | 18.6661 | 4105108.0 |
| 2012-12-24 10:20:00 | AAPL | Stock | 18.6632 | 18.67 | 18.6296 | 18.6425 | 4125464.0 |
| 2012-12-24 10:25:00 | AAPL | Stock | 18.6425 | 18.6507 | 18.6268 | 18.6389 | 3180912.0 |
| 2012-12-24 10:30:00 | AAPL | Stock | 18.6371 | 18.6714 | 18.6343 | 18.6557 | 4000108.0 |
| 2012-12-24 10:35:00 | AAPL | Stock | 18.6582 | 18.6586 | 18.6418 | 18.6482 | 1986236.0 |
> showing 50 of 175,494 rows — these rows as CSV