PREVIEW / stock_1min / 2013-03-15
file: by_date/stock_1min/2013/2013-03-15.parquet size: 13.7 MB rows: 1,016,427 symbols: 2,805
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-15 04:37:00 | AAPL | Stock | 15.4393 | 15.4393 | 15.4393 | 15.4393 | 6720.0 |
| 2013-03-15 05:14:00 | AAPL | Stock | 15.4554 | 15.4636 | 15.4554 | 15.4636 | 17080.0 |
| 2013-03-15 05:38:00 | AAPL | Stock | 15.4546 | 15.4554 | 15.4546 | 15.4554 | 27972.0 |
| 2013-03-15 05:49:00 | AAPL | Stock | 15.4554 | 15.4554 | 15.4554 | 15.4554 | 12292.0 |
| 2013-03-15 05:56:00 | AAPL | Stock | 15.4629 | 15.4629 | 15.4629 | 15.4629 | 2800.0 |
| 2013-03-15 06:01:00 | AAPL | Stock | 15.4643 | 15.4643 | 15.4643 | 15.4643 | 2800.0 |
| 2013-03-15 06:05:00 | AAPL | Stock | 15.4911 | 15.4911 | 15.4911 | 15.4911 | 2800.0 |
| 2013-03-15 06:07:00 | AAPL | Stock | 15.5179 | 15.5179 | 15.5179 | 15.5179 | 3052.0 |
| 2013-03-15 06:18:00 | AAPL | Stock | 15.5357 | 15.5357 | 15.5357 | 15.5357 | 11200.0 |
| 2013-03-15 06:19:00 | AAPL | Stock | 15.5357 | 15.5357 | 15.5357 | 15.5357 | 2800.0 |
| 2013-03-15 06:23:00 | AAPL | Stock | 15.5639 | 15.5639 | 15.5639 | 15.5639 | 5600.0 |
| 2013-03-15 06:24:00 | AAPL | Stock | 15.5714 | 15.5714 | 15.5714 | 15.5714 | 2800.0 |
| 2013-03-15 06:31:00 | AAPL | Stock | 15.5636 | 15.5636 | 15.5636 | 15.5636 | 2800.0 |
| 2013-03-15 06:36:00 | AAPL | Stock | 15.5536 | 15.5536 | 15.5536 | 15.5536 | 2800.0 |
| 2013-03-15 06:40:00 | AAPL | Stock | 15.5564 | 15.5586 | 15.5564 | 15.5586 | 11200.0 |
| 2013-03-15 06:55:00 | AAPL | Stock | 15.5504 | 15.5571 | 15.5504 | 15.5571 | 13776.0 |
| 2013-03-15 06:59:00 | AAPL | Stock | 15.5707 | 15.5707 | 15.5707 | 15.5707 | 8400.0 |
| 2013-03-15 07:01:00 | AAPL | Stock | 15.5771 | 15.5871 | 15.5771 | 15.5871 | 54880.0 |
| 2013-03-15 07:02:00 | AAPL | Stock | 15.5868 | 15.5871 | 15.5857 | 15.5857 | 11200.0 |
| 2013-03-15 07:03:00 | AAPL | Stock | 15.5811 | 15.5982 | 15.5786 | 15.5814 | 30800.0 |
| 2013-03-15 07:04:00 | AAPL | Stock | 15.5839 | 15.5839 | 15.5839 | 15.5839 | 2800.0 |
| 2013-03-15 07:05:00 | AAPL | Stock | 15.5846 | 15.59 | 15.5846 | 15.5886 | 33180.0 |
| 2013-03-15 07:06:00 | AAPL | Stock | 15.5886 | 15.5886 | 15.5886 | 15.5886 | 2800.0 |
| 2013-03-15 07:07:00 | AAPL | Stock | 15.5804 | 15.5804 | 15.5804 | 15.5804 | 52780.0 |
| 2013-03-15 07:08:00 | AAPL | Stock | 15.5804 | 15.5986 | 15.5804 | 15.5986 | 11200.0 |
| 2013-03-15 07:09:00 | AAPL | Stock | 15.6 | 15.6 | 15.5896 | 15.5896 | 5600.0 |
| 2013-03-15 07:10:00 | AAPL | Stock | 15.5979 | 15.6161 | 15.5979 | 15.6161 | 43540.0 |
| 2013-03-15 07:11:00 | AAPL | Stock | 15.6214 | 15.6236 | 15.5982 | 15.6082 | 102116.0 |
| 2013-03-15 07:12:00 | AAPL | Stock | 15.6079 | 15.6082 | 15.6079 | 15.6079 | 12040.0 |
| 2013-03-15 07:13:00 | AAPL | Stock | 15.6111 | 15.6111 | 15.6111 | 15.6111 | 2800.0 |
| 2013-03-15 07:14:00 | AAPL | Stock | 15.6179 | 15.6232 | 15.6107 | 15.6232 | 19880.0 |
| 2013-03-15 07:15:00 | AAPL | Stock | 15.6229 | 15.6286 | 15.6229 | 15.6286 | 30800.0 |
| 2013-03-15 07:16:00 | AAPL | Stock | 15.635 | 15.635 | 15.635 | 15.635 | 5600.0 |
| 2013-03-15 07:17:00 | AAPL | Stock | 15.635 | 15.6571 | 15.635 | 15.6507 | 55860.0 |
| 2013-03-15 07:18:00 | AAPL | Stock | 15.6507 | 15.6714 | 15.6507 | 15.6696 | 49868.0 |
| 2013-03-15 07:19:00 | AAPL | Stock | 15.6607 | 15.6607 | 15.6539 | 15.6604 | 21000.0 |
| 2013-03-15 07:20:00 | AAPL | Stock | 15.6539 | 15.6539 | 15.6429 | 15.6432 | 45864.0 |
| 2013-03-15 07:21:00 | AAPL | Stock | 15.6314 | 15.6314 | 15.6314 | 15.6314 | 2800.0 |
| 2013-03-15 07:22:00 | AAPL | Stock | 15.6304 | 15.6357 | 15.6304 | 15.6357 | 5600.0 |
| 2013-03-15 07:23:00 | AAPL | Stock | 15.6286 | 15.6286 | 15.6268 | 15.6268 | 7056.0 |
| 2013-03-15 07:24:00 | AAPL | Stock | 15.6268 | 15.6429 | 15.625 | 15.6429 | 56000.0 |
| 2013-03-15 07:25:00 | AAPL | Stock | 15.6429 | 15.6518 | 15.6429 | 15.6518 | 23996.0 |
| 2013-03-15 07:26:00 | AAPL | Stock | 15.6429 | 15.6643 | 15.6429 | 15.6607 | 87304.0 |
| 2013-03-15 07:27:00 | AAPL | Stock | 15.6518 | 15.6607 | 15.6518 | 15.655 | 36400.0 |
| 2013-03-15 07:28:00 | AAPL | Stock | 15.6518 | 15.655 | 15.6518 | 15.6518 | 34580.0 |
| 2013-03-15 07:29:00 | AAPL | Stock | 15.6429 | 15.6429 | 15.6429 | 15.6429 | 19600.0 |
| 2013-03-15 07:30:00 | AAPL | Stock | 15.6514 | 15.6518 | 15.6289 | 15.6339 | 60032.0 |
| 2013-03-15 07:31:00 | AAPL | Stock | 15.6339 | 15.6339 | 15.625 | 15.625 | 9800.0 |
| 2013-03-15 07:32:00 | AAPL | Stock | 15.6407 | 15.655 | 15.6332 | 15.655 | 89600.0 |
| 2013-03-15 07:33:00 | AAPL | Stock | 15.6518 | 15.6607 | 15.6518 | 15.6596 | 136892.0 |
> showing 50 of 1,016,427 rows — these rows as CSV