PREVIEW / stock_1min / 2013-05-03
file: by_date/stock_1min/2013/2013-05-03.parquet size: 13.8 MB rows: 1,008,724 symbols: 2,834
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-05-03 04:03:00 | AAPL | Stock | 15.9643 | 15.9643 | 15.9643 | 15.9643 | 2800.0 |
| 2013-05-03 04:14:00 | AAPL | Stock | 15.9643 | 15.9643 | 15.9643 | 15.9643 | 2800.0 |
| 2013-05-03 04:24:00 | AAPL | Stock | 15.9661 | 15.9661 | 15.9661 | 15.9661 | 2800.0 |
| 2013-05-03 04:45:00 | AAPL | Stock | 15.985 | 15.985 | 15.985 | 15.985 | 2800.0 |
| 2013-05-03 04:48:00 | AAPL | Stock | 15.9821 | 15.9821 | 15.9821 | 15.9821 | 6244.0 |
| 2013-05-03 05:08:00 | AAPL | Stock | 15.9696 | 15.9696 | 15.9696 | 15.9696 | 2800.0 |
| 2013-05-03 05:09:00 | AAPL | Stock | 15.9643 | 15.9643 | 15.9643 | 15.9643 | 2800.0 |
| 2013-05-03 05:14:00 | AAPL | Stock | 15.9643 | 15.9643 | 15.9643 | 15.9643 | 2800.0 |
| 2013-05-03 05:22:00 | AAPL | Stock | 15.9643 | 15.9643 | 15.9643 | 15.9643 | 2800.0 |
| 2013-05-03 05:23:00 | AAPL | Stock | 15.9571 | 15.9571 | 15.9571 | 15.9571 | 2800.0 |
| 2013-05-03 07:00:00 | AAPL | Stock | 15.9654 | 15.9654 | 15.9464 | 15.9464 | 5600.0 |
| 2013-05-03 07:01:00 | AAPL | Stock | 15.9429 | 15.9429 | 15.9429 | 15.9429 | 2800.0 |
| 2013-05-03 07:08:00 | AAPL | Stock | 15.9636 | 15.9636 | 15.9604 | 15.9604 | 8400.0 |
| 2013-05-03 07:17:00 | AAPL | Stock | 15.9721 | 15.9732 | 15.9721 | 15.9732 | 30800.0 |
| 2013-05-03 07:21:00 | AAPL | Stock | 15.9786 | 15.9786 | 15.9786 | 15.9786 | 2800.0 |
| 2013-05-03 07:23:00 | AAPL | Stock | 15.9714 | 15.9714 | 15.9714 | 15.9714 | 8400.0 |
| 2013-05-03 07:24:00 | AAPL | Stock | 15.9643 | 15.9643 | 15.9643 | 15.9643 | 38108.0 |
| 2013-05-03 07:26:00 | AAPL | Stock | 15.9639 | 15.9639 | 15.9639 | 15.9639 | 5600.0 |
| 2013-05-03 07:29:00 | AAPL | Stock | 15.9561 | 15.9561 | 15.9561 | 15.9561 | 2800.0 |
| 2013-05-03 07:35:00 | AAPL | Stock | 15.9643 | 15.9643 | 15.9643 | 15.9643 | 5600.0 |
| 2013-05-03 07:37:00 | AAPL | Stock | 15.9571 | 15.9571 | 15.9571 | 15.9571 | 5600.0 |
| 2013-05-03 07:38:00 | AAPL | Stock | 15.9518 | 15.9518 | 15.9518 | 15.9518 | 2800.0 |
| 2013-05-03 07:40:00 | AAPL | Stock | 15.9464 | 15.9464 | 15.9464 | 15.9464 | 2800.0 |
| 2013-05-03 07:42:00 | AAPL | Stock | 15.9407 | 15.9407 | 15.9407 | 15.9407 | 3780.0 |
| 2013-05-03 07:43:00 | AAPL | Stock | 15.9532 | 15.955 | 15.9532 | 15.955 | 5600.0 |
| 2013-05-03 07:45:00 | AAPL | Stock | 15.9543 | 15.9543 | 15.9543 | 15.9543 | 2800.0 |
| 2013-05-03 07:46:00 | AAPL | Stock | 15.9643 | 15.9643 | 15.9643 | 15.9643 | 3892.0 |
| 2013-05-03 07:48:00 | AAPL | Stock | 15.9589 | 15.9589 | 15.9571 | 15.9571 | 27580.0 |
| 2013-05-03 07:51:00 | AAPL | Stock | 15.9464 | 15.9464 | 15.9464 | 15.9464 | 10360.0 |
| 2013-05-03 07:54:00 | AAPL | Stock | 15.9464 | 15.9464 | 15.9464 | 15.9464 | 2800.0 |
| 2013-05-03 07:55:00 | AAPL | Stock | 15.9464 | 15.9464 | 15.9464 | 15.9464 | 2800.0 |
| 2013-05-03 08:00:00 | AAPL | Stock | 15.9364 | 15.9786 | 15.9304 | 15.9311 | 121632.0 |
| 2013-05-03 08:01:00 | AAPL | Stock | 15.9393 | 15.9393 | 15.9393 | 15.9393 | 7952.0 |
| 2013-05-03 08:02:00 | AAPL | Stock | 15.9357 | 15.9357 | 15.9304 | 15.9304 | 15960.0 |
| 2013-05-03 08:03:00 | AAPL | Stock | 15.9321 | 15.9457 | 15.9286 | 15.9329 | 81060.0 |
| 2013-05-03 08:05:00 | AAPL | Stock | 15.9404 | 15.9454 | 15.9339 | 15.9446 | 29708.0 |
| 2013-05-03 08:06:00 | AAPL | Stock | 15.9443 | 15.9443 | 15.9443 | 15.9443 | 2800.0 |
| 2013-05-03 08:07:00 | AAPL | Stock | 15.9429 | 15.945 | 15.9346 | 15.945 | 22400.0 |
| 2013-05-03 08:08:00 | AAPL | Stock | 15.9346 | 15.9346 | 15.9339 | 15.9339 | 5992.0 |
| 2013-05-03 08:09:00 | AAPL | Stock | 15.9421 | 15.9429 | 15.9421 | 15.9429 | 12712.0 |
| 2013-05-03 08:10:00 | AAPL | Stock | 15.9368 | 15.9368 | 15.9357 | 15.9357 | 34216.0 |
| 2013-05-03 08:11:00 | AAPL | Stock | 15.9354 | 15.9354 | 15.9286 | 15.9286 | 103348.0 |
| 2013-05-03 08:12:00 | AAPL | Stock | 15.9254 | 15.9254 | 15.9232 | 15.9232 | 21420.0 |
| 2013-05-03 08:13:00 | AAPL | Stock | 15.92 | 15.9214 | 15.92 | 15.9214 | 36400.0 |
| 2013-05-03 08:14:00 | AAPL | Stock | 15.9286 | 15.9357 | 15.9286 | 15.9357 | 72072.0 |
| 2013-05-03 08:15:00 | AAPL | Stock | 15.9375 | 15.9432 | 15.9361 | 15.9361 | 33712.0 |
| 2013-05-03 08:16:00 | AAPL | Stock | 15.9357 | 15.9357 | 15.935 | 15.935 | 5600.0 |
| 2013-05-03 08:17:00 | AAPL | Stock | 15.9389 | 15.9468 | 15.9375 | 15.9464 | 63980.0 |
| 2013-05-03 08:18:00 | AAPL | Stock | 15.9396 | 15.9396 | 15.9329 | 15.9329 | 14980.0 |
| 2013-05-03 08:20:00 | AAPL | Stock | 15.9293 | 15.9293 | 15.9286 | 15.9286 | 7476.0 |
> showing 50 of 1,008,724 rows — these rows as CSV