PREVIEW / stock_5min / 2011-08-17
file: by_date/stock_5min/2011/2011-08-17.parquet size: 4.8 MB rows: 324,242 symbols: 3,515
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-08-17 04:20:00 | AAPL | Stock | 13.58 | 13.58 | 13.58 | 13.58 | 2800.0 |
| 2011-08-17 04:50:00 | AAPL | Stock | 13.5532 | 13.5532 | 13.5532 | 13.5532 | 2800.0 |
| 2011-08-17 05:40:00 | AAPL | Stock | 13.6246 | 13.6246 | 13.6246 | 13.6246 | 8400.0 |
| 2011-08-17 06:15:00 | AAPL | Stock | 13.5696 | 13.5696 | 13.5689 | 13.5689 | 5600.0 |
| 2011-08-17 06:45:00 | AAPL | Stock | 13.6143 | 13.6143 | 13.6143 | 13.6143 | 5600.0 |
| 2011-08-17 06:50:00 | AAPL | Stock | 13.6225 | 13.6386 | 13.6225 | 13.6386 | 8400.0 |
| 2011-08-17 06:55:00 | AAPL | Stock | 13.645 | 13.6475 | 13.645 | 13.6475 | 5600.0 |
| 2011-08-17 07:00:00 | AAPL | Stock | 13.6075 | 13.6346 | 13.6071 | 13.6346 | 28000.0 |
| 2011-08-17 07:05:00 | AAPL | Stock | 13.6386 | 13.6439 | 13.6386 | 13.6439 | 14000.0 |
| 2011-08-17 07:10:00 | AAPL | Stock | 13.6411 | 13.6475 | 13.6411 | 13.6475 | 18844.0 |
| 2011-08-17 07:15:00 | AAPL | Stock | 13.6507 | 13.6607 | 13.6429 | 13.6429 | 27972.0 |
| 2011-08-17 07:20:00 | AAPL | Stock | 13.6425 | 13.6425 | 13.6425 | 13.6425 | 2800.0 |
| 2011-08-17 07:25:00 | AAPL | Stock | 13.6429 | 13.6446 | 13.6429 | 13.6446 | 15372.0 |
| 2011-08-17 07:30:00 | AAPL | Stock | 13.6529 | 13.6529 | 13.6461 | 13.6461 | 25200.0 |
| 2011-08-17 07:35:00 | AAPL | Stock | 13.6529 | 13.6732 | 13.6529 | 13.6721 | 33600.0 |
| 2011-08-17 07:40:00 | AAPL | Stock | 13.6693 | 13.6704 | 13.6557 | 13.6557 | 185920.0 |
| 2011-08-17 07:45:00 | AAPL | Stock | 13.6539 | 13.6539 | 13.625 | 13.6286 | 119280.0 |
| 2011-08-17 07:50:00 | AAPL | Stock | 13.6314 | 13.6386 | 13.6314 | 13.6386 | 16800.0 |
| 2011-08-17 07:55:00 | AAPL | Stock | 13.6439 | 13.6439 | 13.6439 | 13.6439 | 5600.0 |
| 2011-08-17 08:00:00 | AAPL | Stock | 13.6411 | 13.6571 | 13.6411 | 13.6536 | 165144.0 |
| 2011-08-17 08:05:00 | AAPL | Stock | 13.6536 | 13.6571 | 13.6496 | 13.6518 | 197568.0 |
| 2011-08-17 08:10:00 | AAPL | Stock | 13.5886 | 13.6571 | 13.5886 | 13.6414 | 359660.0 |
| 2011-08-17 08:15:00 | AAPL | Stock | 13.6346 | 13.6429 | 13.6286 | 13.6339 | 179816.0 |
| 2011-08-17 08:20:00 | AAPL | Stock | 13.6346 | 13.6429 | 13.6346 | 13.6429 | 86800.0 |
| 2011-08-17 08:25:00 | AAPL | Stock | 13.6432 | 13.6643 | 13.6411 | 13.6643 | 213080.0 |
| 2011-08-17 08:30:00 | AAPL | Stock | 13.6636 | 13.6636 | 13.6429 | 13.6486 | 267680.0 |
| 2011-08-17 08:35:00 | AAPL | Stock | 13.6507 | 13.655 | 13.6464 | 13.6464 | 103600.0 |
| 2011-08-17 08:40:00 | AAPL | Stock | 13.6429 | 13.6429 | 13.6357 | 13.6357 | 121520.0 |
| 2011-08-17 08:45:00 | AAPL | Stock | 13.6382 | 13.6464 | 13.6307 | 13.6307 | 200088.0 |
| 2011-08-17 08:50:00 | AAPL | Stock | 13.6364 | 13.6518 | 13.6364 | 13.6518 | 322196.0 |
| 2011-08-17 08:55:00 | AAPL | Stock | 13.6443 | 13.6514 | 13.6429 | 13.6482 | 169260.0 |
| 2011-08-17 09:00:00 | AAPL | Stock | 13.6461 | 13.6607 | 13.6429 | 13.6582 | 552048.0 |
| 2011-08-17 09:05:00 | AAPL | Stock | 13.66 | 13.6661 | 13.6546 | 13.6643 | 446376.0 |
| 2011-08-17 09:10:00 | AAPL | Stock | 13.6604 | 13.6704 | 13.6564 | 13.6661 | 338128.0 |
| 2011-08-17 09:15:00 | AAPL | Stock | 13.6621 | 13.6625 | 13.6468 | 13.65 | 163352.0 |
| 2011-08-17 09:20:00 | AAPL | Stock | 13.6461 | 13.6507 | 13.6311 | 13.6343 | 575652.0 |
| 2011-08-17 09:25:00 | AAPL | Stock | 13.6371 | 13.6607 | 13.6371 | 13.6554 | 330372.0 |
| 2011-08-17 09:30:00 | AAPL | Stock | 13.6554 | 13.6607 | 13.6093 | 13.6361 | 12471704.0 |
| 2011-08-17 09:35:00 | AAPL | Stock | 13.6379 | 13.6736 | 13.6286 | 13.6457 | 8970864.0 |
| 2011-08-17 09:40:00 | AAPL | Stock | 13.6446 | 13.6643 | 13.6332 | 13.6557 | 5048176.0 |
| 2011-08-17 09:45:00 | AAPL | Stock | 13.6561 | 13.7143 | 13.6561 | 13.6961 | 12605824.0 |
| 2011-08-17 09:50:00 | AAPL | Stock | 13.6961 | 13.7329 | 13.6921 | 13.7036 | 11169060.0 |
| 2011-08-17 09:55:00 | AAPL | Stock | 13.705 | 13.7218 | 13.7007 | 13.7104 | 5711916.0 |
| 2011-08-17 10:00:00 | AAPL | Stock | 13.7064 | 13.7143 | 13.6893 | 13.6996 | 5535544.0 |
| 2011-08-17 10:05:00 | AAPL | Stock | 13.6993 | 13.7079 | 13.6914 | 13.6989 | 4662476.0 |
| 2011-08-17 10:10:00 | AAPL | Stock | 13.6989 | 13.7107 | 13.675 | 13.7093 | 7404152.0 |
| 2011-08-17 10:15:00 | AAPL | Stock | 13.7089 | 13.715 | 13.7029 | 13.7086 | 6923168.0 |
| 2011-08-17 10:20:00 | AAPL | Stock | 13.7089 | 13.7196 | 13.6996 | 13.7075 | 5957112.0 |
| 2011-08-17 10:25:00 | AAPL | Stock | 13.7082 | 13.7214 | 13.7043 | 13.72 | 4057900.0 |
| 2011-08-17 10:30:00 | AAPL | Stock | 13.7186 | 13.7197 | 13.6864 | 13.7032 | 5869752.0 |
> showing 50 of 324,242 rows — these rows as CSV