PREVIEW / stock_1min / 2013-04-25
file: by_date/stock_1min/2013/2013-04-25.parquet size: 13.5 MB rows: 985,627 symbols: 2,832
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 |
|---|---|---|---|---|---|---|---|
| 2013-04-25 04:12:00 | AAPL | Stock | 14.5218 | 14.5218 | 14.5218 | 14.5218 | 6664.0 |
| 2013-04-25 04:14:00 | AAPL | Stock | 14.5354 | 14.5354 | 14.5354 | 14.5354 | 14000.0 |
| 2013-04-25 04:16:00 | AAPL | Stock | 14.5339 | 14.5339 | 14.5339 | 14.5339 | 5600.0 |
| 2013-04-25 04:22:00 | AAPL | Stock | 14.5339 | 14.5339 | 14.5339 | 14.5339 | 2800.0 |
| 2013-04-25 04:24:00 | AAPL | Stock | 14.5243 | 14.5243 | 14.5243 | 14.5243 | 7000.0 |
| 2013-04-25 04:25:00 | AAPL | Stock | 14.5243 | 14.5243 | 14.5243 | 14.5243 | 6720.0 |
| 2013-04-25 04:50:00 | AAPL | Stock | 14.5232 | 14.5232 | 14.5232 | 14.5232 | 5600.0 |
| 2013-04-25 04:55:00 | AAPL | Stock | 14.5136 | 14.5136 | 14.5136 | 14.5136 | 5600.0 |
| 2013-04-25 04:56:00 | AAPL | Stock | 14.5136 | 14.5136 | 14.5136 | 14.5136 | 5600.0 |
| 2013-04-25 05:09:00 | AAPL | Stock | 14.5232 | 14.5232 | 14.5232 | 14.5232 | 5600.0 |
| 2013-04-25 05:13:00 | AAPL | Stock | 14.5254 | 14.5261 | 14.5254 | 14.5261 | 14000.0 |
| 2013-04-25 05:14:00 | AAPL | Stock | 14.5261 | 14.5261 | 14.5229 | 14.5229 | 5600.0 |
| 2013-04-25 05:35:00 | AAPL | Stock | 14.5261 | 14.5261 | 14.5261 | 14.5261 | 2800.0 |
| 2013-04-25 05:36:00 | AAPL | Stock | 14.5261 | 14.5261 | 14.5261 | 14.5261 | 2800.0 |
| 2013-04-25 06:20:00 | AAPL | Stock | 14.525 | 14.5304 | 14.525 | 14.5304 | 41160.0 |
| 2013-04-25 06:22:00 | AAPL | Stock | 14.5304 | 14.5357 | 14.5304 | 14.5357 | 35644.0 |
| 2013-04-25 06:23:00 | AAPL | Stock | 14.5411 | 14.5411 | 14.5411 | 14.5411 | 5600.0 |
| 2013-04-25 06:59:00 | AAPL | Stock | 14.5625 | 14.5625 | 14.5625 | 14.5625 | 2800.0 |
| 2013-04-25 07:00:00 | AAPL | Stock | 14.5418 | 14.5418 | 14.5411 | 14.5411 | 36400.0 |
| 2013-04-25 07:01:00 | AAPL | Stock | 14.5361 | 14.5368 | 14.5361 | 14.5361 | 14336.0 |
| 2013-04-25 07:03:00 | AAPL | Stock | 14.5357 | 14.5364 | 14.5357 | 14.5364 | 5600.0 |
| 2013-04-25 07:06:00 | AAPL | Stock | 14.5361 | 14.5361 | 14.5361 | 14.5361 | 2800.0 |
| 2013-04-25 07:07:00 | AAPL | Stock | 14.5368 | 14.5368 | 14.5357 | 14.5357 | 16100.0 |
| 2013-04-25 07:08:00 | AAPL | Stock | 14.535 | 14.535 | 14.535 | 14.535 | 2800.0 |
| 2013-04-25 07:10:00 | AAPL | Stock | 14.55 | 14.5536 | 14.55 | 14.5536 | 5600.0 |
| 2013-04-25 07:11:00 | AAPL | Stock | 14.5714 | 14.5714 | 14.5714 | 14.5714 | 5600.0 |
| 2013-04-25 07:12:00 | AAPL | Stock | 14.5718 | 14.5721 | 14.5714 | 14.5714 | 19600.0 |
| 2013-04-25 07:13:00 | AAPL | Stock | 14.5857 | 14.5857 | 14.5857 | 14.5857 | 14840.0 |
| 2013-04-25 07:14:00 | AAPL | Stock | 14.585 | 14.5857 | 14.585 | 14.5857 | 44520.0 |
| 2013-04-25 07:15:00 | AAPL | Stock | 14.5893 | 14.6071 | 14.5893 | 14.6071 | 41664.0 |
| 2013-04-25 07:16:00 | AAPL | Stock | 14.5875 | 14.5875 | 14.5875 | 14.5875 | 8400.0 |
| 2013-04-25 07:17:00 | AAPL | Stock | 14.5861 | 14.5861 | 14.5857 | 14.5861 | 8400.0 |
| 2013-04-25 07:18:00 | AAPL | Stock | 14.5857 | 14.5857 | 14.5857 | 14.5857 | 2800.0 |
| 2013-04-25 07:19:00 | AAPL | Stock | 14.585 | 14.5893 | 14.5839 | 14.5893 | 41216.0 |
| 2013-04-25 07:20:00 | AAPL | Stock | 14.6 | 14.6207 | 14.6 | 14.6207 | 75264.0 |
| 2013-04-25 07:21:00 | AAPL | Stock | 14.6079 | 14.6207 | 14.5925 | 14.6071 | 54600.0 |
| 2013-04-25 07:24:00 | AAPL | Stock | 14.5946 | 14.6018 | 14.5946 | 14.6018 | 30800.0 |
| 2013-04-25 07:25:00 | AAPL | Stock | 14.595 | 14.6071 | 14.595 | 14.5982 | 58436.0 |
| 2013-04-25 07:27:00 | AAPL | Stock | 14.5982 | 14.5982 | 14.5904 | 14.5904 | 16800.0 |
| 2013-04-25 07:28:00 | AAPL | Stock | 14.5861 | 14.59 | 14.5714 | 14.5893 | 141512.0 |
| 2013-04-25 07:29:00 | AAPL | Stock | 14.585 | 14.5854 | 14.585 | 14.5854 | 14000.0 |
| 2013-04-25 07:30:00 | AAPL | Stock | 14.5768 | 14.5768 | 14.5768 | 14.5768 | 2800.0 |
| 2013-04-25 07:32:00 | AAPL | Stock | 14.5714 | 14.5714 | 14.5625 | 14.5625 | 11200.0 |
| 2013-04-25 07:39:00 | AAPL | Stock | 14.5711 | 14.5711 | 14.5711 | 14.5711 | 11200.0 |
| 2013-04-25 07:40:00 | AAPL | Stock | 14.5711 | 14.5711 | 14.5646 | 14.5646 | 28000.0 |
| 2013-04-25 07:41:00 | AAPL | Stock | 14.5575 | 14.5575 | 14.5518 | 14.5518 | 5600.0 |
| 2013-04-25 07:43:00 | AAPL | Stock | 14.5536 | 14.5536 | 14.5368 | 14.5521 | 22120.0 |
| 2013-04-25 07:44:00 | AAPL | Stock | 14.5625 | 14.5625 | 14.5618 | 14.5618 | 5600.0 |
| 2013-04-25 07:45:00 | AAPL | Stock | 14.56 | 14.56 | 14.5546 | 14.5546 | 5600.0 |
| 2013-04-25 07:54:00 | AAPL | Stock | 14.5625 | 14.5693 | 14.5625 | 14.5693 | 5600.0 |
> showing 50 of 985,627 rows — these rows as CSV