PREVIEW / stock_1min / 2014-01-09
file: by_date/stock_1min/2014/2014-01-09.parquet size: 15.1 MB rows: 1,081,719 symbols: 2,855
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-01-09 04:00:00 | AAPL | Stock | 19.4586 | 19.4586 | 19.4586 | 19.4586 | 2800.0 |
| 2014-01-09 04:03:00 | AAPL | Stock | 19.4875 | 19.4875 | 19.4875 | 19.4875 | 5600.0 |
| 2014-01-09 04:05:00 | AAPL | Stock | 19.5225 | 19.5225 | 19.5225 | 19.5225 | 2800.0 |
| 2014-01-09 04:31:00 | AAPL | Stock | 19.4971 | 19.4971 | 19.4971 | 19.4971 | 2800.0 |
| 2014-01-09 04:41:00 | AAPL | Stock | 19.4643 | 19.4643 | 19.4643 | 19.4643 | 2800.0 |
| 2014-01-09 05:05:00 | AAPL | Stock | 19.4864 | 19.4929 | 19.4864 | 19.4929 | 12600.0 |
| 2014-01-09 05:30:00 | AAPL | Stock | 19.4743 | 19.4743 | 19.4743 | 19.4743 | 2800.0 |
| 2014-01-09 05:36:00 | AAPL | Stock | 19.4821 | 19.4821 | 19.4821 | 19.4821 | 2800.0 |
| 2014-01-09 05:51:00 | AAPL | Stock | 19.4979 | 19.4979 | 19.4979 | 19.4979 | 2800.0 |
| 2014-01-09 06:42:00 | AAPL | Stock | 19.4821 | 19.4821 | 19.4821 | 19.4821 | 2800.0 |
| 2014-01-09 06:45:00 | AAPL | Stock | 19.4714 | 19.4714 | 19.4714 | 19.4714 | 2800.0 |
| 2014-01-09 06:58:00 | AAPL | Stock | 19.4739 | 19.4739 | 19.4714 | 19.4714 | 5600.0 |
| 2014-01-09 06:59:00 | AAPL | Stock | 19.4839 | 19.4846 | 19.4839 | 19.4846 | 5600.0 |
| 2014-01-09 07:00:00 | AAPL | Stock | 19.4714 | 19.4714 | 19.4714 | 19.4714 | 14000.0 |
| 2014-01-09 07:01:00 | AAPL | Stock | 19.4846 | 19.4846 | 19.4846 | 19.4846 | 2800.0 |
| 2014-01-09 07:02:00 | AAPL | Stock | 19.4839 | 19.4879 | 19.4839 | 19.4879 | 13384.0 |
| 2014-01-09 07:03:00 | AAPL | Stock | 19.4946 | 19.4946 | 19.4946 | 19.4946 | 5600.0 |
| 2014-01-09 07:06:00 | AAPL | Stock | 19.4886 | 19.4986 | 19.4886 | 19.4986 | 28000.0 |
| 2014-01-09 07:11:00 | AAPL | Stock | 19.4961 | 19.5 | 19.4961 | 19.5 | 35560.0 |
| 2014-01-09 07:13:00 | AAPL | Stock | 19.5018 | 19.5018 | 19.5 | 19.5 | 16520.0 |
| 2014-01-09 07:15:00 | AAPL | Stock | 19.5007 | 19.5007 | 19.5007 | 19.5007 | 11200.0 |
| 2014-01-09 07:17:00 | AAPL | Stock | 19.5 | 19.5039 | 19.5 | 19.5 | 11200.0 |
| 2014-01-09 07:18:00 | AAPL | Stock | 19.5096 | 19.5096 | 19.5096 | 19.5096 | 2800.0 |
| 2014-01-09 07:20:00 | AAPL | Stock | 19.5086 | 19.5086 | 19.5086 | 19.5086 | 2800.0 |
| 2014-01-09 07:24:00 | AAPL | Stock | 19.5014 | 19.5014 | 19.5014 | 19.5014 | 5600.0 |
| 2014-01-09 07:28:00 | AAPL | Stock | 19.5007 | 19.5007 | 19.5007 | 19.5007 | 2800.0 |
| 2014-01-09 07:35:00 | AAPL | Stock | 19.5086 | 19.5086 | 19.5086 | 19.5086 | 2800.0 |
| 2014-01-09 07:36:00 | AAPL | Stock | 19.5089 | 19.5161 | 19.5089 | 19.5154 | 54320.0 |
| 2014-01-09 07:37:00 | AAPL | Stock | 19.5157 | 19.5179 | 19.515 | 19.5179 | 41552.0 |
| 2014-01-09 07:40:00 | AAPL | Stock | 19.5196 | 19.5243 | 19.5143 | 19.5243 | 32480.0 |
| 2014-01-09 07:41:00 | AAPL | Stock | 19.5321 | 19.5321 | 19.5311 | 19.5311 | 15680.0 |
| 2014-01-09 07:42:00 | AAPL | Stock | 19.535 | 19.5357 | 19.535 | 19.5357 | 14000.0 |
| 2014-01-09 07:45:00 | AAPL | Stock | 19.5318 | 19.5493 | 19.5318 | 19.5493 | 44604.0 |
| 2014-01-09 07:46:00 | AAPL | Stock | 19.5486 | 19.5757 | 19.5486 | 19.5754 | 58800.0 |
| 2014-01-09 07:47:00 | AAPL | Stock | 19.5711 | 19.5711 | 19.5707 | 19.5707 | 5600.0 |
| 2014-01-09 07:49:00 | AAPL | Stock | 19.5489 | 19.5489 | 19.5446 | 19.5446 | 14000.0 |
| 2014-01-09 07:50:00 | AAPL | Stock | 19.5518 | 19.5518 | 19.5518 | 19.5518 | 2800.0 |
| 2014-01-09 07:53:00 | AAPL | Stock | 19.5557 | 19.5557 | 19.5557 | 19.5557 | 2800.0 |
| 2014-01-09 07:54:00 | AAPL | Stock | 19.5557 | 19.5557 | 19.5379 | 19.5379 | 39480.0 |
| 2014-01-09 07:56:00 | AAPL | Stock | 19.5357 | 19.5357 | 19.5357 | 19.5357 | 2800.0 |
| 2014-01-09 07:57:00 | AAPL | Stock | 19.5357 | 19.5357 | 19.5357 | 19.5357 | 2800.0 |
| 2014-01-09 07:58:00 | AAPL | Stock | 19.5364 | 19.5364 | 19.5364 | 19.5364 | 8400.0 |
| 2014-01-09 07:59:00 | AAPL | Stock | 19.5361 | 19.5361 | 19.5361 | 19.5361 | 2800.0 |
| 2014-01-09 08:00:00 | AAPL | Stock | 19.4843 | 19.5482 | 19.4843 | 19.5179 | 180516.0 |
| 2014-01-09 08:01:00 | AAPL | Stock | 19.5336 | 19.5357 | 19.5325 | 19.5357 | 53144.0 |
| 2014-01-09 08:02:00 | AAPL | Stock | 19.5354 | 19.5411 | 19.5354 | 19.5357 | 20944.0 |
| 2014-01-09 08:04:00 | AAPL | Stock | 19.5446 | 19.5446 | 19.5446 | 19.5446 | 5600.0 |
| 2014-01-09 08:05:00 | AAPL | Stock | 19.5464 | 19.5464 | 19.5464 | 19.5464 | 11200.0 |
| 2014-01-09 08:06:00 | AAPL | Stock | 19.5464 | 19.5464 | 19.5393 | 19.5393 | 23156.0 |
| 2014-01-09 08:07:00 | AAPL | Stock | 19.5364 | 19.5364 | 19.5364 | 19.5364 | 2800.0 |
> showing 50 of 1,081,719 rows — these rows as CSV