PREVIEW / stock_1min / 2012-02-10
file: by_date/stock_1min/2012/2012-02-10.parquet size: 12.8 MB rows: 949,546 symbols: 2,858
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-02-10 04:24:00 | AAPL | Stock | 17.6607 | 17.6607 | 17.6607 | 17.6607 | 5600.0 |
| 2012-02-10 04:26:00 | AAPL | Stock | 17.6607 | 17.6607 | 17.6607 | 17.6607 | 2800.0 |
| 2012-02-10 04:27:00 | AAPL | Stock | 17.6607 | 17.6607 | 17.6607 | 17.6607 | 5600.0 |
| 2012-02-10 04:54:00 | AAPL | Stock | 17.6607 | 17.6607 | 17.6607 | 17.6607 | 14000.0 |
| 2012-02-10 04:56:00 | AAPL | Stock | 17.6661 | 17.6661 | 17.6661 | 17.6661 | 14000.0 |
| 2012-02-10 05:02:00 | AAPL | Stock | 17.6518 | 17.6518 | 17.6429 | 17.6429 | 16800.0 |
| 2012-02-10 05:05:00 | AAPL | Stock | 17.6321 | 17.6321 | 17.6321 | 17.6321 | 5600.0 |
| 2012-02-10 05:06:00 | AAPL | Stock | 17.6243 | 17.6243 | 17.6218 | 17.6218 | 5600.0 |
| 2012-02-10 05:10:00 | AAPL | Stock | 17.6164 | 17.6164 | 17.6071 | 17.6071 | 30800.0 |
| 2012-02-10 05:11:00 | AAPL | Stock | 17.6071 | 17.6218 | 17.6071 | 17.6218 | 25200.0 |
| 2012-02-10 05:20:00 | AAPL | Stock | 17.6071 | 17.6071 | 17.6 | 17.6 | 27720.0 |
| 2012-02-10 06:15:00 | AAPL | Stock | 17.6096 | 17.6096 | 17.6096 | 17.6096 | 5600.0 |
| 2012-02-10 06:16:00 | AAPL | Stock | 17.6093 | 17.6093 | 17.6093 | 17.6093 | 5040.0 |
| 2012-02-10 06:24:00 | AAPL | Stock | 17.6179 | 17.6179 | 17.6179 | 17.6179 | 5600.0 |
| 2012-02-10 06:45:00 | AAPL | Stock | 17.6093 | 17.6093 | 17.6093 | 17.6093 | 5180.0 |
| 2012-02-10 06:50:00 | AAPL | Stock | 17.625 | 17.625 | 17.625 | 17.625 | 6160.0 |
| 2012-02-10 06:53:00 | AAPL | Stock | 17.6093 | 17.6093 | 17.6093 | 17.6093 | 2800.0 |
| 2012-02-10 07:00:00 | AAPL | Stock | 17.6179 | 17.6182 | 17.6179 | 17.6179 | 28000.0 |
| 2012-02-10 07:01:00 | AAPL | Stock | 17.6179 | 17.6196 | 17.6179 | 17.6179 | 33320.0 |
| 2012-02-10 07:02:00 | AAPL | Stock | 17.6179 | 17.6246 | 17.6132 | 17.6179 | 61600.0 |
| 2012-02-10 07:03:00 | AAPL | Stock | 17.6071 | 17.6246 | 17.6071 | 17.6246 | 20440.0 |
| 2012-02-10 07:06:00 | AAPL | Stock | 17.6071 | 17.6071 | 17.5893 | 17.5893 | 17836.0 |
| 2012-02-10 07:07:00 | AAPL | Stock | 17.5896 | 17.5936 | 17.4561 | 17.5936 | 103096.0 |
| 2012-02-10 07:08:00 | AAPL | Stock | 17.5914 | 17.5914 | 17.5671 | 17.5671 | 68040.0 |
| 2012-02-10 07:09:00 | AAPL | Stock | 17.5804 | 17.5804 | 17.5671 | 17.5671 | 25984.0 |
| 2012-02-10 07:10:00 | AAPL | Stock | 17.5714 | 17.5714 | 17.5671 | 17.5671 | 11200.0 |
| 2012-02-10 07:11:00 | AAPL | Stock | 17.5671 | 17.5714 | 17.5654 | 17.5654 | 23800.0 |
| 2012-02-10 07:12:00 | AAPL | Stock | 17.5582 | 17.5582 | 17.545 | 17.545 | 22400.0 |
| 2012-02-10 07:13:00 | AAPL | Stock | 17.5357 | 17.5357 | 17.5179 | 17.525 | 39340.0 |
| 2012-02-10 07:14:00 | AAPL | Stock | 17.525 | 17.525 | 17.4896 | 17.4896 | 78400.0 |
| 2012-02-10 07:15:00 | AAPL | Stock | 17.5 | 17.5004 | 17.5 | 17.5004 | 64064.0 |
| 2012-02-10 07:16:00 | AAPL | Stock | 17.5054 | 17.5179 | 17.4929 | 17.4929 | 63476.0 |
| 2012-02-10 07:17:00 | AAPL | Stock | 17.4929 | 17.4929 | 17.4857 | 17.4857 | 45276.0 |
| 2012-02-10 07:18:00 | AAPL | Stock | 17.4982 | 17.4982 | 17.4889 | 17.4889 | 16800.0 |
| 2012-02-10 07:19:00 | AAPL | Stock | 17.4946 | 17.5 | 17.4946 | 17.5 | 49000.0 |
| 2012-02-10 07:20:00 | AAPL | Stock | 17.5 | 17.5007 | 17.5 | 17.5007 | 175000.0 |
| 2012-02-10 07:21:00 | AAPL | Stock | 17.5004 | 17.5004 | 17.5 | 17.5 | 23464.0 |
| 2012-02-10 07:22:00 | AAPL | Stock | 17.5214 | 17.5357 | 17.5125 | 17.5357 | 37520.0 |
| 2012-02-10 07:23:00 | AAPL | Stock | 17.5354 | 17.5357 | 17.5354 | 17.5357 | 5600.0 |
| 2012-02-10 07:24:00 | AAPL | Stock | 17.5446 | 17.5571 | 17.5446 | 17.5536 | 30800.0 |
| 2012-02-10 07:25:00 | AAPL | Stock | 17.5393 | 17.54 | 17.5393 | 17.54 | 5600.0 |
| 2012-02-10 07:26:00 | AAPL | Stock | 17.5532 | 17.5536 | 17.5421 | 17.5421 | 30240.0 |
| 2012-02-10 07:27:00 | AAPL | Stock | 17.5536 | 17.5536 | 17.5536 | 17.5536 | 17752.0 |
| 2012-02-10 07:28:00 | AAPL | Stock | 17.5468 | 17.5471 | 17.5468 | 17.5471 | 5600.0 |
| 2012-02-10 07:29:00 | AAPL | Stock | 17.5532 | 17.5639 | 17.5504 | 17.5571 | 25200.0 |
| 2012-02-10 07:30:00 | AAPL | Stock | 17.5632 | 17.5632 | 17.5632 | 17.5632 | 2800.0 |
| 2012-02-10 07:31:00 | AAPL | Stock | 17.5607 | 17.5607 | 17.5607 | 17.5607 | 2800.0 |
| 2012-02-10 07:32:00 | AAPL | Stock | 17.555 | 17.555 | 17.5404 | 17.5411 | 33600.0 |
| 2012-02-10 07:33:00 | AAPL | Stock | 17.5411 | 17.5496 | 17.5411 | 17.5496 | 13048.0 |
| 2012-02-10 07:35:00 | AAPL | Stock | 17.5479 | 17.5536 | 17.5479 | 17.5536 | 5600.0 |
> showing 50 of 949,546 rows — these rows as CSV