PREVIEW / stock_5min / 2011-06-16
file: by_date/stock_5min/2011/2011-06-16.parquet size: 5.0 MB rows: 336,580 symbols: 3,548
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-06-16 04:25:00 | AAPL | Stock | 11.6886 | 11.6886 | 11.6886 | 11.6886 | 2800.0 |
| 2011-06-16 05:45:00 | AAPL | Stock | 11.6518 | 11.6518 | 11.6518 | 11.6518 | 8400.0 |
| 2011-06-16 06:05:00 | AAPL | Stock | 11.6421 | 11.6421 | 11.6421 | 11.6421 | 2800.0 |
| 2011-06-16 06:30:00 | AAPL | Stock | 11.6179 | 11.6179 | 11.6146 | 11.6146 | 5600.0 |
| 2011-06-16 06:55:00 | AAPL | Stock | 11.6271 | 11.6271 | 11.6271 | 11.6271 | 2800.0 |
| 2011-06-16 07:00:00 | AAPL | Stock | 11.6271 | 11.6571 | 11.6271 | 11.6571 | 8400.0 |
| 2011-06-16 07:10:00 | AAPL | Stock | 11.635 | 11.6557 | 11.6339 | 11.6507 | 56000.0 |
| 2011-06-16 07:15:00 | AAPL | Stock | 11.6607 | 11.6607 | 11.6493 | 11.6493 | 11200.0 |
| 2011-06-16 07:20:00 | AAPL | Stock | 11.6429 | 11.6429 | 11.6429 | 11.6429 | 2800.0 |
| 2011-06-16 07:30:00 | AAPL | Stock | 11.6364 | 11.6371 | 11.6364 | 11.6371 | 5600.0 |
| 2011-06-16 07:35:00 | AAPL | Stock | 11.65 | 11.65 | 11.65 | 11.65 | 2800.0 |
| 2011-06-16 07:40:00 | AAPL | Stock | 11.6557 | 11.6561 | 11.6361 | 11.6432 | 11200.0 |
| 2011-06-16 07:55:00 | AAPL | Stock | 11.6429 | 11.6429 | 11.6339 | 11.6339 | 33600.0 |
| 2011-06-16 08:00:00 | AAPL | Stock | 11.6389 | 11.6393 | 11.625 | 11.6393 | 107044.0 |
| 2011-06-16 08:05:00 | AAPL | Stock | 11.6357 | 11.6357 | 11.6257 | 11.6257 | 50204.0 |
| 2011-06-16 08:10:00 | AAPL | Stock | 11.6286 | 11.6429 | 11.6286 | 11.6357 | 76776.0 |
| 2011-06-16 08:20:00 | AAPL | Stock | 11.6321 | 11.6321 | 11.6179 | 11.6289 | 99120.0 |
| 2011-06-16 08:25:00 | AAPL | Stock | 11.6257 | 11.6304 | 11.625 | 11.625 | 61320.0 |
| 2011-06-16 08:30:00 | AAPL | Stock | 11.6304 | 11.6789 | 11.6304 | 11.6675 | 594972.0 |
| 2011-06-16 08:35:00 | AAPL | Stock | 11.6675 | 11.6786 | 11.6675 | 11.6743 | 99820.0 |
| 2011-06-16 08:40:00 | AAPL | Stock | 11.6743 | 11.6779 | 11.6579 | 11.6779 | 108332.0 |
| 2011-06-16 08:45:00 | AAPL | Stock | 11.6682 | 11.6786 | 11.6682 | 11.6786 | 89880.0 |
| 2011-06-16 08:50:00 | AAPL | Stock | 11.6736 | 11.6768 | 11.6607 | 11.6714 | 177240.0 |
| 2011-06-16 08:55:00 | AAPL | Stock | 11.6771 | 11.6964 | 11.6679 | 11.6964 | 518672.0 |
| 2011-06-16 09:00:00 | AAPL | Stock | 11.7004 | 11.7057 | 11.6914 | 11.7039 | 211932.0 |
| 2011-06-16 09:05:00 | AAPL | Stock | 11.6982 | 11.7071 | 11.6982 | 11.7054 | 117880.0 |
| 2011-06-16 09:10:00 | AAPL | Stock | 11.7018 | 11.7054 | 11.6975 | 11.6975 | 105896.0 |
| 2011-06-16 09:15:00 | AAPL | Stock | 11.7 | 11.7021 | 11.6946 | 11.6961 | 220612.0 |
| 2011-06-16 09:20:00 | AAPL | Stock | 11.6968 | 11.6968 | 11.675 | 11.6821 | 332500.0 |
| 2011-06-16 09:25:00 | AAPL | Stock | 11.6861 | 11.695 | 11.6511 | 11.6804 | 701512.0 |
| 2011-06-16 09:30:00 | AAPL | Stock | 11.6782 | 11.6957 | 11.6339 | 11.6471 | 15161860.0 |
| 2011-06-16 09:35:00 | AAPL | Stock | 11.6484 | 11.6857 | 11.6439 | 11.6671 | 10221876.0 |
| 2011-06-16 09:40:00 | AAPL | Stock | 11.6654 | 11.6914 | 11.6607 | 11.6636 | 8005312.0 |
| 2011-06-16 09:45:00 | AAPL | Stock | 11.6632 | 11.6746 | 11.6586 | 11.6639 | 5624276.0 |
| 2011-06-16 09:50:00 | AAPL | Stock | 11.6614 | 11.6954 | 11.6611 | 11.6854 | 7323932.0 |
| 2011-06-16 09:55:00 | AAPL | Stock | 11.6859 | 11.6946 | 11.6789 | 11.6911 | 3883712.0 |
| 2011-06-16 10:00:00 | AAPL | Stock | 11.69 | 11.6904 | 11.65 | 11.6818 | 14818804.0 |
| 2011-06-16 10:05:00 | AAPL | Stock | 11.6818 | 11.7193 | 11.6761 | 11.7134 | 9448740.0 |
| 2011-06-16 10:10:00 | AAPL | Stock | 11.7134 | 11.7379 | 11.7125 | 11.7314 | 9088240.0 |
| 2011-06-16 10:15:00 | AAPL | Stock | 11.7286 | 11.7386 | 11.7143 | 11.7221 | 4902772.0 |
| 2011-06-16 10:20:00 | AAPL | Stock | 11.7232 | 11.7321 | 11.7125 | 11.7321 | 4213188.0 |
| 2011-06-16 10:25:00 | AAPL | Stock | 11.7321 | 11.7375 | 11.7082 | 11.7089 | 4569460.0 |
| 2011-06-16 10:30:00 | AAPL | Stock | 11.7089 | 11.7129 | 11.6964 | 11.7079 | 5131868.0 |
| 2011-06-16 10:35:00 | AAPL | Stock | 11.7096 | 11.7261 | 11.7064 | 11.7261 | 3225432.0 |
| 2011-06-16 10:40:00 | AAPL | Stock | 11.7239 | 11.735 | 11.7143 | 11.7196 | 2835672.0 |
| 2011-06-16 10:45:00 | AAPL | Stock | 11.7196 | 11.7214 | 11.7082 | 11.7143 | 2208696.0 |
| 2011-06-16 10:50:00 | AAPL | Stock | 11.7171 | 11.7357 | 11.7104 | 11.7146 | 5415816.0 |
| 2011-06-16 10:55:00 | AAPL | Stock | 11.7152 | 11.7196 | 11.705 | 11.7075 | 2956604.0 |
| 2011-06-16 11:00:00 | AAPL | Stock | 11.7066 | 11.7075 | 11.6789 | 11.6846 | 3981404.0 |
| 2011-06-16 11:05:00 | AAPL | Stock | 11.6822 | 11.6925 | 11.6786 | 11.6868 | 2686740.0 |
> showing 50 of 336,580 rows — these rows as CSV