PREVIEW / stock_1min / 2014-02-18
file: by_date/stock_1min/2014/2014-02-18.parquet size: 15.0 MB rows: 1,076,963 symbols: 2,885
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 |
|---|---|---|---|---|---|---|---|
| 2014-02-18 04:12:00 | AAPL | Stock | 19.4982 | 19.4982 | 19.4982 | 19.4982 | 2800.0 |
| 2014-02-18 04:14:00 | AAPL | Stock | 19.4657 | 19.4929 | 19.4643 | 19.4643 | 8400.0 |
| 2014-02-18 04:18:00 | AAPL | Stock | 19.4982 | 19.4982 | 19.4982 | 19.4982 | 2800.0 |
| 2014-02-18 04:48:00 | AAPL | Stock | 19.4911 | 19.4911 | 19.4911 | 19.4911 | 2800.0 |
| 2014-02-18 04:55:00 | AAPL | Stock | 19.4796 | 19.4796 | 19.4796 | 19.4796 | 2800.0 |
| 2014-02-18 05:09:00 | AAPL | Stock | 19.4796 | 19.4796 | 19.4796 | 19.4796 | 11088.0 |
| 2014-02-18 05:31:00 | AAPL | Stock | 19.4664 | 19.4664 | 19.4664 | 19.4664 | 8400.0 |
| 2014-02-18 06:03:00 | AAPL | Stock | 19.4604 | 19.4643 | 19.4604 | 19.4643 | 24136.0 |
| 2014-02-18 06:06:00 | AAPL | Stock | 19.4286 | 19.4286 | 19.4286 | 19.4286 | 5600.0 |
| 2014-02-18 06:29:00 | AAPL | Stock | 19.4275 | 19.4275 | 19.4275 | 19.4275 | 2800.0 |
| 2014-02-18 06:34:00 | AAPL | Stock | 19.4264 | 19.4264 | 19.4264 | 19.4264 | 11060.0 |
| 2014-02-18 06:37:00 | AAPL | Stock | 19.4304 | 19.4304 | 19.4304 | 19.4304 | 5600.0 |
| 2014-02-18 07:03:00 | AAPL | Stock | 19.4464 | 19.4464 | 19.4464 | 19.4464 | 2800.0 |
| 2014-02-18 07:04:00 | AAPL | Stock | 19.4357 | 19.4357 | 19.4357 | 19.4357 | 11200.0 |
| 2014-02-18 07:05:00 | AAPL | Stock | 19.4464 | 19.4482 | 19.4464 | 19.4482 | 13580.0 |
| 2014-02-18 07:06:00 | AAPL | Stock | 19.45 | 19.45 | 19.45 | 19.45 | 8400.0 |
| 2014-02-18 07:07:00 | AAPL | Stock | 19.4554 | 19.4554 | 19.4554 | 19.4554 | 14000.0 |
| 2014-02-18 07:09:00 | AAPL | Stock | 19.4775 | 19.4775 | 19.4732 | 19.4732 | 8540.0 |
| 2014-02-18 07:11:00 | AAPL | Stock | 19.4643 | 19.4643 | 19.4643 | 19.4643 | 8400.0 |
| 2014-02-18 07:15:00 | AAPL | Stock | 19.4839 | 19.4839 | 19.4839 | 19.4839 | 19600.0 |
| 2014-02-18 07:18:00 | AAPL | Stock | 19.4821 | 19.4821 | 19.4821 | 19.4821 | 4200.0 |
| 2014-02-18 07:19:00 | AAPL | Stock | 19.4857 | 19.4857 | 19.4857 | 19.4857 | 4396.0 |
| 2014-02-18 07:24:00 | AAPL | Stock | 19.4886 | 19.4886 | 19.4886 | 19.4886 | 4200.0 |
| 2014-02-18 07:31:00 | AAPL | Stock | 19.4821 | 19.4821 | 19.4821 | 19.4821 | 8400.0 |
| 2014-02-18 07:33:00 | AAPL | Stock | 19.4732 | 19.4732 | 19.4732 | 19.4732 | 2800.0 |
| 2014-02-18 07:38:00 | AAPL | Stock | 19.4804 | 19.4854 | 19.4804 | 19.4854 | 16800.0 |
| 2014-02-18 07:39:00 | AAPL | Stock | 19.4886 | 19.4886 | 19.4857 | 19.4857 | 8400.0 |
| 2014-02-18 07:41:00 | AAPL | Stock | 19.4854 | 19.4886 | 19.4854 | 19.4886 | 37156.0 |
| 2014-02-18 07:43:00 | AAPL | Stock | 19.4854 | 19.4854 | 19.4804 | 19.4804 | 14000.0 |
| 2014-02-18 07:45:00 | AAPL | Stock | 19.4804 | 19.4804 | 19.4804 | 19.4804 | 2800.0 |
| 2014-02-18 08:00:00 | AAPL | Stock | 19.4768 | 19.4886 | 19.4268 | 19.4879 | 110488.0 |
| 2014-02-18 08:01:00 | AAPL | Stock | 19.4839 | 19.4839 | 19.4107 | 19.4107 | 11200.0 |
| 2014-02-18 08:02:00 | AAPL | Stock | 19.4914 | 19.4957 | 19.4914 | 19.4957 | 22400.0 |
| 2014-02-18 08:03:00 | AAPL | Stock | 19.4893 | 19.5236 | 19.4893 | 19.5236 | 101164.0 |
| 2014-02-18 08:04:00 | AAPL | Stock | 19.4954 | 19.5357 | 19.4954 | 19.5357 | 108388.0 |
| 2014-02-18 08:05:00 | AAPL | Stock | 19.5457 | 19.5714 | 19.5457 | 19.5536 | 64596.0 |
| 2014-02-18 08:06:00 | AAPL | Stock | 19.5571 | 19.5571 | 19.5571 | 19.5571 | 5600.0 |
| 2014-02-18 08:07:00 | AAPL | Stock | 19.5536 | 19.5643 | 19.5536 | 19.5554 | 138768.0 |
| 2014-02-18 08:08:00 | AAPL | Stock | 19.5661 | 19.5679 | 19.5661 | 19.5661 | 39200.0 |
| 2014-02-18 08:09:00 | AAPL | Stock | 19.5575 | 19.5607 | 19.5486 | 19.5486 | 49000.0 |
| 2014-02-18 08:10:00 | AAPL | Stock | 19.5418 | 19.5429 | 19.5357 | 19.5357 | 14000.0 |
| 2014-02-18 08:11:00 | AAPL | Stock | 19.5357 | 19.5357 | 19.5275 | 19.5275 | 8400.0 |
| 2014-02-18 08:12:00 | AAPL | Stock | 19.525 | 19.525 | 19.525 | 19.525 | 2800.0 |
| 2014-02-18 08:13:00 | AAPL | Stock | 19.53 | 19.5321 | 19.5286 | 19.5286 | 10920.0 |
| 2014-02-18 08:14:00 | AAPL | Stock | 19.5211 | 19.5225 | 19.5196 | 19.5225 | 27944.0 |
| 2014-02-18 08:15:00 | AAPL | Stock | 19.52 | 19.52 | 19.5193 | 19.5193 | 5600.0 |
| 2014-02-18 08:17:00 | AAPL | Stock | 19.5161 | 19.5225 | 19.5161 | 19.5225 | 11200.0 |
| 2014-02-18 08:18:00 | AAPL | Stock | 19.5179 | 19.5225 | 19.5179 | 19.5225 | 14000.0 |
| 2014-02-18 08:19:00 | AAPL | Stock | 19.5221 | 19.5225 | 19.5221 | 19.5225 | 10024.0 |
| 2014-02-18 08:20:00 | AAPL | Stock | 19.5225 | 19.5225 | 19.5179 | 19.5179 | 8624.0 |
> showing 50 of 1,076,963 rows — these rows as CSV