PREVIEW / stock_5min / 2011-12-09
file: by_date/stock_5min/2011/2011-12-09.parquet size: 4.7 MB rows: 321,442 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-12-09 04:05:00 | AAPL | Stock | 14.0 | 14.0 | 14.0 | 14.0 | 5600.0 |
| 2011-12-09 04:20:00 | AAPL | Stock | 14.0179 | 14.0179 | 14.0179 | 14.0179 | 2800.0 |
| 2011-12-09 05:10:00 | AAPL | Stock | 14.0339 | 14.0339 | 14.0339 | 14.0339 | 9072.0 |
| 2011-12-09 05:55:00 | AAPL | Stock | 14.0321 | 14.0357 | 14.0321 | 14.0357 | 35000.0 |
| 2011-12-09 06:00:00 | AAPL | Stock | 14.0621 | 14.0621 | 14.0621 | 14.0621 | 11200.0 |
| 2011-12-09 06:10:00 | AAPL | Stock | 14.0475 | 14.0475 | 14.0475 | 14.0475 | 5600.0 |
| 2011-12-09 06:20:00 | AAPL | Stock | 14.0536 | 14.0536 | 14.0536 | 14.0536 | 5320.0 |
| 2011-12-09 06:50:00 | AAPL | Stock | 14.06 | 14.0604 | 14.06 | 14.0604 | 19600.0 |
| 2011-12-09 06:55:00 | AAPL | Stock | 14.0636 | 14.0636 | 14.0636 | 14.0636 | 2800.0 |
| 2011-12-09 07:00:00 | AAPL | Stock | 14.0579 | 14.0714 | 14.0536 | 14.0646 | 16800.0 |
| 2011-12-09 07:05:00 | AAPL | Stock | 14.0618 | 14.0786 | 14.0618 | 14.0786 | 72100.0 |
| 2011-12-09 07:10:00 | AAPL | Stock | 14.0714 | 14.0714 | 14.0646 | 14.0646 | 121800.0 |
| 2011-12-09 07:20:00 | AAPL | Stock | 14.0689 | 14.0925 | 14.0682 | 14.0893 | 103096.0 |
| 2011-12-09 07:25:00 | AAPL | Stock | 14.075 | 14.08 | 14.0714 | 14.0786 | 52248.0 |
| 2011-12-09 07:30:00 | AAPL | Stock | 14.0696 | 14.0718 | 14.0639 | 14.0639 | 66920.0 |
| 2011-12-09 07:35:00 | AAPL | Stock | 14.0636 | 14.0675 | 14.0564 | 14.0675 | 37800.0 |
| 2011-12-09 07:40:00 | AAPL | Stock | 14.0554 | 14.0554 | 14.0471 | 14.0532 | 33600.0 |
| 2011-12-09 07:45:00 | AAPL | Stock | 14.0464 | 14.0536 | 14.0464 | 14.0482 | 100800.0 |
| 2011-12-09 07:50:00 | AAPL | Stock | 14.0536 | 14.0607 | 14.0536 | 14.0607 | 27300.0 |
| 2011-12-09 07:55:00 | AAPL | Stock | 14.0557 | 14.0557 | 14.0482 | 14.0536 | 39200.0 |
| 2011-12-09 08:00:00 | AAPL | Stock | 14.0539 | 14.0625 | 14.0182 | 14.0239 | 202468.0 |
| 2011-12-09 08:05:00 | AAPL | Stock | 14.0204 | 14.0268 | 14.0107 | 14.0268 | 101920.0 |
| 2011-12-09 08:10:00 | AAPL | Stock | 14.0339 | 14.0357 | 14.0286 | 14.0325 | 85680.0 |
| 2011-12-09 08:15:00 | AAPL | Stock | 14.035 | 14.0493 | 14.035 | 14.0411 | 129696.0 |
| 2011-12-09 08:20:00 | AAPL | Stock | 14.0482 | 14.0482 | 14.0321 | 14.0357 | 34188.0 |
| 2011-12-09 08:25:00 | AAPL | Stock | 14.0339 | 14.0339 | 14.0268 | 14.0271 | 94360.0 |
| 2011-12-09 08:30:00 | AAPL | Stock | 14.0286 | 14.0286 | 14.0179 | 14.0179 | 59388.0 |
| 2011-12-09 08:35:00 | AAPL | Stock | 14.01 | 14.0268 | 14.01 | 14.0196 | 292908.0 |
| 2011-12-09 08:40:00 | AAPL | Stock | 14.0196 | 14.0336 | 14.0196 | 14.0304 | 29400.0 |
| 2011-12-09 08:45:00 | AAPL | Stock | 14.0304 | 14.0304 | 14.0218 | 14.0279 | 91000.0 |
| 2011-12-09 08:50:00 | AAPL | Stock | 14.0221 | 14.0321 | 14.01 | 14.0268 | 587664.0 |
| 2011-12-09 08:55:00 | AAPL | Stock | 14.0182 | 14.025 | 14.015 | 14.02 | 136640.0 |
| 2011-12-09 09:00:00 | AAPL | Stock | 14.0218 | 14.0218 | 14.0179 | 14.0179 | 190400.0 |
| 2011-12-09 09:05:00 | AAPL | Stock | 14.0196 | 14.0196 | 14.0125 | 14.0161 | 186060.0 |
| 2011-12-09 09:10:00 | AAPL | Stock | 14.0179 | 14.0304 | 14.0179 | 14.0232 | 251944.0 |
| 2011-12-09 09:15:00 | AAPL | Stock | 14.0232 | 14.0261 | 14.0179 | 14.0261 | 73528.0 |
| 2011-12-09 09:20:00 | AAPL | Stock | 14.0261 | 14.0286 | 14.0214 | 14.0214 | 70112.0 |
| 2011-12-09 09:25:00 | AAPL | Stock | 14.0232 | 14.0357 | 14.0232 | 14.0264 | 203952.0 |
| 2011-12-09 09:30:00 | AAPL | Stock | 14.0271 | 14.0571 | 14.0182 | 14.047 | 11423328.0 |
| 2011-12-09 09:35:00 | AAPL | Stock | 14.0436 | 14.0657 | 14.0389 | 14.0443 | 7320964.0 |
| 2011-12-09 09:40:00 | AAPL | Stock | 14.0489 | 14.0536 | 13.9793 | 13.9794 | 8837332.0 |
| 2011-12-09 09:45:00 | AAPL | Stock | 13.9793 | 14.0175 | 13.9743 | 14.015 | 8549688.0 |
| 2011-12-09 09:50:00 | AAPL | Stock | 14.0154 | 14.0429 | 14.0129 | 14.0239 | 6603548.0 |
| 2011-12-09 09:55:00 | AAPL | Stock | 14.0243 | 14.0304 | 14.0036 | 14.0086 | 6766900.0 |
| 2011-12-09 10:00:00 | AAPL | Stock | 14.0125 | 14.0264 | 14.0061 | 14.0209 | 5065172.0 |
| 2011-12-09 10:05:00 | AAPL | Stock | 14.0232 | 14.0393 | 14.0218 | 14.0346 | 4429656.0 |
| 2011-12-09 10:10:00 | AAPL | Stock | 14.0307 | 14.0457 | 14.0154 | 14.0207 | 6044976.0 |
| 2011-12-09 10:15:00 | AAPL | Stock | 14.0239 | 14.0279 | 13.9807 | 13.9825 | 6366416.0 |
| 2011-12-09 10:20:00 | AAPL | Stock | 13.9807 | 13.995 | 13.9654 | 13.9911 | 7825720.0 |
| 2011-12-09 10:25:00 | AAPL | Stock | 13.9918 | 14.0025 | 13.97 | 14.0025 | 4202072.0 |
> showing 50 of 321,442 rows — these rows as CSV