PREVIEW / stock_1min / 2013-03-12
file: by_date/stock_1min/2013/2013-03-12.parquet size: 13.2 MB rows: 984,282 symbols: 2,801
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-03-12 04:25:00 | AAPL | Stock | 15.5382 | 15.5382 | 15.5382 | 15.5382 | 2800.0 |
| 2013-03-12 05:04:00 | AAPL | Stock | 15.5625 | 15.5625 | 15.5625 | 15.5625 | 2800.0 |
| 2013-03-12 05:05:00 | AAPL | Stock | 15.5625 | 15.5625 | 15.5625 | 15.5625 | 2800.0 |
| 2013-03-12 05:13:00 | AAPL | Stock | 15.555 | 15.555 | 15.5539 | 15.5539 | 12600.0 |
| 2013-03-12 05:15:00 | AAPL | Stock | 15.5786 | 15.5786 | 15.5786 | 15.5786 | 4200.0 |
| 2013-03-12 05:22:00 | AAPL | Stock | 15.555 | 15.555 | 15.5543 | 15.5543 | 14000.0 |
| 2013-03-12 05:29:00 | AAPL | Stock | 15.5707 | 15.5707 | 15.5707 | 15.5707 | 2800.0 |
| 2013-03-12 05:30:00 | AAPL | Stock | 15.5893 | 15.5893 | 15.5893 | 15.5893 | 2800.0 |
| 2013-03-12 05:47:00 | AAPL | Stock | 15.5607 | 15.5607 | 15.5607 | 15.5607 | 2800.0 |
| 2013-03-12 05:55:00 | AAPL | Stock | 15.5604 | 15.5604 | 15.5604 | 15.5604 | 2800.0 |
| 2013-03-12 06:16:00 | AAPL | Stock | 15.5875 | 15.5875 | 15.5875 | 15.5875 | 2800.0 |
| 2013-03-12 06:18:00 | AAPL | Stock | 15.5879 | 15.5879 | 15.5879 | 15.5879 | 2800.0 |
| 2013-03-12 06:20:00 | AAPL | Stock | 15.5889 | 15.5889 | 15.5889 | 15.5889 | 2800.0 |
| 2013-03-12 06:23:00 | AAPL | Stock | 15.5893 | 15.5893 | 15.5893 | 15.5893 | 2800.0 |
| 2013-03-12 06:25:00 | AAPL | Stock | 15.5721 | 15.5721 | 15.5721 | 15.5721 | 8400.0 |
| 2013-03-12 06:36:00 | AAPL | Stock | 15.5893 | 15.5893 | 15.5893 | 15.5893 | 2800.0 |
| 2013-03-12 06:45:00 | AAPL | Stock | 15.5804 | 15.5804 | 15.5804 | 15.5804 | 2800.0 |
| 2013-03-12 06:47:00 | AAPL | Stock | 15.5857 | 15.5857 | 15.5857 | 15.5857 | 2800.0 |
| 2013-03-12 07:01:00 | AAPL | Stock | 15.5854 | 15.5854 | 15.5854 | 15.5854 | 5600.0 |
| 2013-03-12 07:02:00 | AAPL | Stock | 15.5843 | 15.5857 | 15.5843 | 15.5857 | 10080.0 |
| 2013-03-12 07:03:00 | AAPL | Stock | 15.5821 | 15.5821 | 15.5821 | 15.5821 | 2800.0 |
| 2013-03-12 07:04:00 | AAPL | Stock | 15.5854 | 15.5854 | 15.5854 | 15.5854 | 2800.0 |
| 2013-03-12 07:05:00 | AAPL | Stock | 15.5854 | 15.5854 | 15.5814 | 15.5814 | 6160.0 |
| 2013-03-12 07:07:00 | AAPL | Stock | 15.575 | 15.575 | 15.5714 | 15.5714 | 27244.0 |
| 2013-03-12 07:09:00 | AAPL | Stock | 15.5589 | 15.5589 | 15.5589 | 15.5589 | 5600.0 |
| 2013-03-12 07:11:00 | AAPL | Stock | 15.5571 | 15.5571 | 15.5536 | 15.5536 | 17500.0 |
| 2013-03-12 07:12:00 | AAPL | Stock | 15.5379 | 15.5571 | 15.5368 | 15.5368 | 22400.0 |
| 2013-03-12 07:13:00 | AAPL | Stock | 15.5357 | 15.5386 | 15.5268 | 15.5354 | 40516.0 |
| 2013-03-12 07:15:00 | AAPL | Stock | 15.5357 | 15.5357 | 15.5321 | 15.5321 | 9800.0 |
| 2013-03-12 07:18:00 | AAPL | Stock | 15.5214 | 15.5214 | 15.5196 | 15.5196 | 8400.0 |
| 2013-03-12 07:19:00 | AAPL | Stock | 15.5318 | 15.5318 | 15.5179 | 15.5179 | 8288.0 |
| 2013-03-12 07:21:00 | AAPL | Stock | 15.5018 | 15.5071 | 15.4996 | 15.4996 | 35336.0 |
| 2013-03-12 07:22:00 | AAPL | Stock | 15.4993 | 15.5179 | 15.4993 | 15.5179 | 25480.0 |
| 2013-03-12 07:25:00 | AAPL | Stock | 15.5243 | 15.5286 | 15.5243 | 15.5286 | 19600.0 |
| 2013-03-12 07:26:00 | AAPL | Stock | 15.5293 | 15.5357 | 15.5293 | 15.5357 | 8400.0 |
| 2013-03-12 07:27:00 | AAPL | Stock | 15.5457 | 15.5461 | 15.5457 | 15.5457 | 8400.0 |
| 2013-03-12 07:28:00 | AAPL | Stock | 15.5464 | 15.5464 | 15.5371 | 15.5371 | 8400.0 |
| 2013-03-12 07:29:00 | AAPL | Stock | 15.525 | 15.525 | 15.525 | 15.525 | 11200.0 |
| 2013-03-12 07:31:00 | AAPL | Stock | 15.525 | 15.525 | 15.5214 | 15.5214 | 5600.0 |
| 2013-03-12 07:32:00 | AAPL | Stock | 15.525 | 15.525 | 15.525 | 15.525 | 8400.0 |
| 2013-03-12 07:33:00 | AAPL | Stock | 15.5254 | 15.5254 | 15.5254 | 15.5254 | 2800.0 |
| 2013-03-12 07:34:00 | AAPL | Stock | 15.535 | 15.535 | 15.535 | 15.535 | 2800.0 |
| 2013-03-12 07:35:00 | AAPL | Stock | 15.5257 | 15.535 | 15.5257 | 15.535 | 8400.0 |
| 2013-03-12 07:36:00 | AAPL | Stock | 15.5393 | 15.5393 | 15.5393 | 15.5393 | 14000.0 |
| 2013-03-12 07:37:00 | AAPL | Stock | 15.5357 | 15.5357 | 15.5357 | 15.5357 | 3808.0 |
| 2013-03-12 07:38:00 | AAPL | Stock | 15.5464 | 15.5464 | 15.5464 | 15.5464 | 5600.0 |
| 2013-03-12 07:39:00 | AAPL | Stock | 15.5429 | 15.5429 | 15.535 | 15.535 | 8400.0 |
| 2013-03-12 07:43:00 | AAPL | Stock | 15.5461 | 15.5461 | 15.5461 | 15.5461 | 2800.0 |
| 2013-03-12 07:44:00 | AAPL | Stock | 15.5461 | 15.5514 | 15.5461 | 15.5514 | 8400.0 |
| 2013-03-12 07:46:00 | AAPL | Stock | 15.5521 | 15.5525 | 15.55 | 15.5525 | 25844.0 |
> showing 50 of 984,282 rows — these rows as CSV