PREVIEW / stock_1min / 2012-01-13
file: by_date/stock_1min/2012/2012-01-13.parquet size: 12.3 MB rows: 919,371 symbols: 2,846
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 |
|---|---|---|---|---|---|---|---|
| 2012-01-13 04:51:00 | AAPL | Stock | 15.0829 | 15.0829 | 15.0829 | 15.0829 | 2800.0 |
| 2012-01-13 04:58:00 | AAPL | Stock | 15.0786 | 15.0786 | 15.0786 | 15.0786 | 5600.0 |
| 2012-01-13 05:00:00 | AAPL | Stock | 15.0786 | 15.0821 | 15.0786 | 15.0821 | 19600.0 |
| 2012-01-13 05:22:00 | AAPL | Stock | 15.0643 | 15.0643 | 15.0643 | 15.0643 | 8400.0 |
| 2012-01-13 05:23:00 | AAPL | Stock | 15.0643 | 15.0643 | 15.0643 | 15.0643 | 5600.0 |
| 2012-01-13 05:24:00 | AAPL | Stock | 15.0643 | 15.0643 | 15.0643 | 15.0643 | 5600.0 |
| 2012-01-13 05:34:00 | AAPL | Stock | 15.0679 | 15.0679 | 15.0679 | 15.0679 | 4200.0 |
| 2012-01-13 05:41:00 | AAPL | Stock | 15.0643 | 15.0643 | 15.0643 | 15.0643 | 3304.0 |
| 2012-01-13 06:31:00 | AAPL | Stock | 15.0643 | 15.0643 | 15.0643 | 15.0643 | 2800.0 |
| 2012-01-13 06:33:00 | AAPL | Stock | 15.0643 | 15.0643 | 15.0643 | 15.0643 | 2800.0 |
| 2012-01-13 07:01:00 | AAPL | Stock | 15.05 | 15.05 | 15.05 | 15.05 | 7000.0 |
| 2012-01-13 07:23:00 | AAPL | Stock | 15.0507 | 15.0507 | 15.05 | 15.05 | 14000.0 |
| 2012-01-13 07:27:00 | AAPL | Stock | 15.0518 | 15.0518 | 15.0518 | 15.0518 | 2800.0 |
| 2012-01-13 07:29:00 | AAPL | Stock | 15.0518 | 15.0518 | 15.0518 | 15.0518 | 5852.0 |
| 2012-01-13 07:42:00 | AAPL | Stock | 15.0679 | 15.0679 | 15.0679 | 15.0679 | 11200.0 |
| 2012-01-13 07:43:00 | AAPL | Stock | 15.0511 | 15.0511 | 15.0464 | 15.0464 | 12628.0 |
| 2012-01-13 07:48:00 | AAPL | Stock | 15.0468 | 15.0468 | 15.0464 | 15.0464 | 24864.0 |
| 2012-01-13 07:51:00 | AAPL | Stock | 15.0361 | 15.0361 | 15.0343 | 15.0343 | 7700.0 |
| 2012-01-13 07:54:00 | AAPL | Stock | 15.0261 | 15.0261 | 15.0261 | 15.0261 | 5600.0 |
| 2012-01-13 07:55:00 | AAPL | Stock | 15.0357 | 15.0396 | 15.035 | 15.0371 | 24808.0 |
| 2012-01-13 07:56:00 | AAPL | Stock | 15.0371 | 15.0371 | 15.0229 | 15.0229 | 105840.0 |
| 2012-01-13 07:59:00 | AAPL | Stock | 15.0296 | 15.0296 | 15.0296 | 15.0296 | 5600.0 |
| 2012-01-13 08:00:00 | AAPL | Stock | 15.0296 | 15.0357 | 15.0293 | 15.0357 | 43260.0 |
| 2012-01-13 08:01:00 | AAPL | Stock | 15.0268 | 15.0268 | 15.0268 | 15.0268 | 2800.0 |
| 2012-01-13 08:03:00 | AAPL | Stock | 15.0321 | 15.0357 | 15.0321 | 15.0357 | 11200.0 |
| 2012-01-13 08:05:00 | AAPL | Stock | 15.035 | 15.0354 | 15.0314 | 15.0321 | 22400.0 |
| 2012-01-13 08:06:00 | AAPL | Stock | 15.0275 | 15.0275 | 15.0196 | 15.0196 | 68292.0 |
| 2012-01-13 08:09:00 | AAPL | Stock | 15.0286 | 15.0286 | 15.025 | 15.025 | 17472.0 |
| 2012-01-13 08:10:00 | AAPL | Stock | 15.0275 | 15.0275 | 15.0236 | 15.0236 | 10472.0 |
| 2012-01-13 08:11:00 | AAPL | Stock | 15.0214 | 15.0214 | 15.0214 | 15.0214 | 4872.0 |
| 2012-01-13 08:12:00 | AAPL | Stock | 15.0329 | 15.0357 | 15.0329 | 15.0357 | 107604.0 |
| 2012-01-13 08:15:00 | AAPL | Stock | 15.0429 | 15.0429 | 15.0429 | 15.0429 | 5600.0 |
| 2012-01-13 08:17:00 | AAPL | Stock | 15.0429 | 15.0446 | 15.0429 | 15.0446 | 40180.0 |
| 2012-01-13 08:18:00 | AAPL | Stock | 15.0532 | 15.0536 | 15.0532 | 15.0536 | 34580.0 |
| 2012-01-13 08:19:00 | AAPL | Stock | 15.0464 | 15.0464 | 15.0464 | 15.0464 | 28000.0 |
| 2012-01-13 08:20:00 | AAPL | Stock | 15.0464 | 15.0546 | 15.0429 | 15.0546 | 55132.0 |
| 2012-01-13 08:21:00 | AAPL | Stock | 15.0554 | 15.0589 | 15.0536 | 15.0536 | 33600.0 |
| 2012-01-13 08:23:00 | AAPL | Stock | 15.0571 | 15.0571 | 15.0571 | 15.0571 | 2800.0 |
| 2012-01-13 08:24:00 | AAPL | Stock | 15.06 | 15.0661 | 15.06 | 15.0643 | 9800.0 |
| 2012-01-13 08:25:00 | AAPL | Stock | 15.0679 | 15.0696 | 15.0664 | 15.0696 | 50400.0 |
| 2012-01-13 08:26:00 | AAPL | Stock | 15.07 | 15.07 | 15.0675 | 15.0675 | 46200.0 |
| 2012-01-13 08:28:00 | AAPL | Stock | 15.0675 | 15.0689 | 15.06 | 15.0639 | 76720.0 |
| 2012-01-13 08:29:00 | AAPL | Stock | 15.0636 | 15.0636 | 15.0636 | 15.0636 | 27860.0 |
| 2012-01-13 08:31:00 | AAPL | Stock | 15.0536 | 15.0546 | 15.0536 | 15.0536 | 8400.0 |
| 2012-01-13 08:32:00 | AAPL | Stock | 15.0575 | 15.0575 | 15.0536 | 15.0536 | 22400.0 |
| 2012-01-13 08:36:00 | AAPL | Stock | 15.0421 | 15.0421 | 15.0196 | 15.0196 | 191968.0 |
| 2012-01-13 08:37:00 | AAPL | Stock | 15.03 | 15.0329 | 15.03 | 15.0329 | 26628.0 |
| 2012-01-13 08:38:00 | AAPL | Stock | 15.0225 | 15.0225 | 15.0225 | 15.0225 | 5600.0 |
| 2012-01-13 08:39:00 | AAPL | Stock | 15.0261 | 15.0261 | 15.0257 | 15.0257 | 8372.0 |
| 2012-01-13 08:40:00 | AAPL | Stock | 15.0339 | 15.0354 | 15.0339 | 15.0354 | 22400.0 |
> showing 50 of 919,371 rows — these rows as CSV