PREVIEW / stock_5min / 2014-02-18
file: by_date/stock_5min/2014/2014-02-18.parquet size: 5.6 MB rows: 364,546 symbols: 3,568
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:10:00 | AAPL | Stock | 19.4982 | 19.4982 | 19.4643 | 19.4643 | 11200.0 |
| 2014-02-18 04:15:00 | AAPL | Stock | 19.4982 | 19.4982 | 19.4982 | 19.4982 | 2800.0 |
| 2014-02-18 04:45: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:05:00 | AAPL | Stock | 19.4796 | 19.4796 | 19.4796 | 19.4796 | 11088.0 |
| 2014-02-18 05:30:00 | AAPL | Stock | 19.4664 | 19.4664 | 19.4664 | 19.4664 | 8400.0 |
| 2014-02-18 06:00:00 | AAPL | Stock | 19.4604 | 19.4643 | 19.4604 | 19.4643 | 24136.0 |
| 2014-02-18 06:05:00 | AAPL | Stock | 19.4286 | 19.4286 | 19.4286 | 19.4286 | 5600.0 |
| 2014-02-18 06:25:00 | AAPL | Stock | 19.4275 | 19.4275 | 19.4275 | 19.4275 | 2800.0 |
| 2014-02-18 06:30:00 | AAPL | Stock | 19.4264 | 19.4264 | 19.4264 | 19.4264 | 11060.0 |
| 2014-02-18 06:35:00 | AAPL | Stock | 19.4304 | 19.4304 | 19.4304 | 19.4304 | 5600.0 |
| 2014-02-18 07:00:00 | AAPL | Stock | 19.4464 | 19.4464 | 19.4357 | 19.4357 | 14000.0 |
| 2014-02-18 07:05:00 | AAPL | Stock | 19.4464 | 19.4775 | 19.4464 | 19.4732 | 44520.0 |
| 2014-02-18 07:10:00 | AAPL | Stock | 19.4643 | 19.4643 | 19.4643 | 19.4643 | 8400.0 |
| 2014-02-18 07:15:00 | AAPL | Stock | 19.4839 | 19.4857 | 19.4821 | 19.4857 | 28196.0 |
| 2014-02-18 07:20:00 | AAPL | Stock | 19.4886 | 19.4886 | 19.4886 | 19.4886 | 4200.0 |
| 2014-02-18 07:30:00 | AAPL | Stock | 19.4821 | 19.4821 | 19.4732 | 19.4732 | 11200.0 |
| 2014-02-18 07:35:00 | AAPL | Stock | 19.4804 | 19.4886 | 19.4804 | 19.4857 | 25200.0 |
| 2014-02-18 07:40:00 | AAPL | Stock | 19.4854 | 19.4886 | 19.4804 | 19.4804 | 51156.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.5357 | 19.4107 | 19.5357 | 353640.0 |
| 2014-02-18 08:05:00 | AAPL | Stock | 19.5457 | 19.5714 | 19.5457 | 19.5486 | 297164.0 |
| 2014-02-18 08:10:00 | AAPL | Stock | 19.5418 | 19.5429 | 19.5196 | 19.5225 | 64064.0 |
| 2014-02-18 08:15:00 | AAPL | Stock | 19.52 | 19.5225 | 19.5161 | 19.5225 | 40824.0 |
| 2014-02-18 08:20:00 | AAPL | Stock | 19.5225 | 19.5343 | 19.5179 | 19.5343 | 24864.0 |
| 2014-02-18 08:25:00 | AAPL | Stock | 19.5343 | 19.5343 | 19.5268 | 19.5268 | 58800.0 |
| 2014-02-18 08:30:00 | AAPL | Stock | 19.5264 | 19.5264 | 19.5029 | 19.5175 | 192052.0 |
| 2014-02-18 08:35:00 | AAPL | Stock | 19.5093 | 19.5289 | 19.5093 | 19.5157 | 63000.0 |
| 2014-02-18 08:40:00 | AAPL | Stock | 19.5243 | 19.5343 | 19.5193 | 19.5343 | 216048.0 |
| 2014-02-18 08:45:00 | AAPL | Stock | 19.5214 | 19.525 | 19.5179 | 19.525 | 72800.0 |
| 2014-02-18 08:50:00 | AAPL | Stock | 19.5329 | 19.5375 | 19.5268 | 19.5304 | 83020.0 |
| 2014-02-18 08:55:00 | AAPL | Stock | 19.5261 | 19.5321 | 19.5218 | 19.5289 | 71680.0 |
| 2014-02-18 09:00:00 | AAPL | Stock | 19.5343 | 19.5468 | 19.5343 | 19.5429 | 130200.0 |
| 2014-02-18 09:05:00 | AAPL | Stock | 19.5439 | 19.5439 | 19.5393 | 19.5436 | 77112.0 |
| 2014-02-18 09:10:00 | AAPL | Stock | 19.5375 | 19.5536 | 19.5357 | 19.5536 | 86884.0 |
| 2014-02-18 09:15:00 | AAPL | Stock | 19.5461 | 19.5461 | 19.5314 | 19.5361 | 131600.0 |
| 2014-02-18 09:20:00 | AAPL | Stock | 19.5336 | 19.5357 | 19.5179 | 19.5179 | 33600.0 |
| 2014-02-18 09:25:00 | AAPL | Stock | 19.5182 | 19.5182 | 19.4929 | 19.5004 | 205912.0 |
| 2014-02-18 09:30:00 | AAPL | Stock | 19.5004 | 19.5743 | 19.4861 | 19.5468 | 14282072.0 |
| 2014-02-18 09:35:00 | AAPL | Stock | 19.5482 | 19.5832 | 19.5082 | 19.5832 | 8397620.0 |
| 2014-02-18 09:40:00 | AAPL | Stock | 19.5825 | 19.585 | 19.5446 | 19.5811 | 5350436.0 |
| 2014-02-18 09:45:00 | AAPL | Stock | 19.5789 | 19.5807 | 19.5322 | 19.5489 | 5800928.0 |
| 2014-02-18 09:50:00 | AAPL | Stock | 19.5507 | 19.5882 | 19.5461 | 19.5611 | 4445000.0 |
| 2014-02-18 09:55:00 | AAPL | Stock | 19.5629 | 19.5629 | 19.5 | 19.5086 | 4945304.0 |
| 2014-02-18 10:00:00 | AAPL | Stock | 19.5071 | 19.5439 | 19.4861 | 19.5264 | 4758824.0 |
| 2014-02-18 10:05:00 | AAPL | Stock | 19.5279 | 19.6321 | 19.5243 | 19.6279 | 9749012.0 |
| 2014-02-18 10:10:00 | AAPL | Stock | 19.6279 | 19.6318 | 19.5943 | 19.6061 | 4878916.0 |
| 2014-02-18 10:15:00 | AAPL | Stock | 19.6043 | 19.6525 | 19.6043 | 19.6396 | 9448516.0 |
| 2014-02-18 10:20:00 | AAPL | Stock | 19.64 | 19.6854 | 19.6304 | 19.6689 | 6866468.0 |
| 2014-02-18 10:25:00 | AAPL | Stock | 19.6675 | 19.6721 | 19.6361 | 19.6582 | 3534076.0 |
> showing 50 of 364,546 rows — these rows as CSV