PREVIEW / stock_1min / 2012-12-11
file: by_date/stock_1min/2012/2012-12-11.parquet size: 13.1 MB rows: 969,725 symbols: 2,827
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-12-11 04:04:00 | AAPL | Stock | 19.0179 | 19.0486 | 19.0179 | 19.0486 | 8400.0 |
| 2012-12-11 04:05:00 | AAPL | Stock | 19.0511 | 19.0729 | 19.0511 | 19.0729 | 9800.0 |
| 2012-12-11 04:11:00 | AAPL | Stock | 19.0839 | 19.0839 | 19.0839 | 19.0839 | 2800.0 |
| 2012-12-11 04:18:00 | AAPL | Stock | 19.0557 | 19.0557 | 19.0554 | 19.0554 | 5600.0 |
| 2012-12-11 04:19:00 | AAPL | Stock | 19.0714 | 19.0975 | 19.0714 | 19.0975 | 5600.0 |
| 2012-12-11 04:23:00 | AAPL | Stock | 19.0546 | 19.0546 | 19.0357 | 19.0357 | 17136.0 |
| 2012-12-11 04:36:00 | AAPL | Stock | 19.0368 | 19.0368 | 19.0368 | 19.0368 | 2800.0 |
| 2012-12-11 04:43:00 | AAPL | Stock | 19.0186 | 19.0186 | 19.0186 | 19.0186 | 2800.0 |
| 2012-12-11 04:48:00 | AAPL | Stock | 19.0818 | 19.0818 | 19.0818 | 19.0818 | 10640.0 |
| 2012-12-11 05:08:00 | AAPL | Stock | 19.0714 | 19.0714 | 19.0714 | 19.0714 | 2800.0 |
| 2012-12-11 05:09:00 | AAPL | Stock | 19.0654 | 19.0654 | 19.0654 | 19.0654 | 2800.0 |
| 2012-12-11 05:10:00 | AAPL | Stock | 19.0518 | 19.0518 | 19.0518 | 19.0518 | 2800.0 |
| 2012-12-11 05:12:00 | AAPL | Stock | 19.0704 | 19.0714 | 19.0704 | 19.0714 | 11200.0 |
| 2012-12-11 05:13:00 | AAPL | Stock | 19.0714 | 19.0714 | 19.0714 | 19.0714 | 11200.0 |
| 2012-12-11 05:21:00 | AAPL | Stock | 19.0804 | 19.0804 | 19.0804 | 19.0804 | 5600.0 |
| 2012-12-11 05:27:00 | AAPL | Stock | 19.0839 | 19.0839 | 19.0839 | 19.0839 | 5600.0 |
| 2012-12-11 05:46:00 | AAPL | Stock | 19.0571 | 19.0571 | 19.0571 | 19.0571 | 2800.0 |
| 2012-12-11 05:51:00 | AAPL | Stock | 19.0807 | 19.0807 | 19.0807 | 19.0807 | 2800.0 |
| 2012-12-11 05:52:00 | AAPL | Stock | 19.0804 | 19.0804 | 19.0536 | 19.0536 | 14000.0 |
| 2012-12-11 06:06:00 | AAPL | Stock | 19.0586 | 19.0586 | 19.0586 | 19.0586 | 2800.0 |
| 2012-12-11 06:11:00 | AAPL | Stock | 19.0446 | 19.0446 | 19.0446 | 19.0446 | 2800.0 |
| 2012-12-11 06:19:00 | AAPL | Stock | 19.0693 | 19.0693 | 19.0693 | 19.0693 | 2800.0 |
| 2012-12-11 06:30:00 | AAPL | Stock | 19.0511 | 19.0511 | 19.0511 | 19.0511 | 2800.0 |
| 2012-12-11 06:36:00 | AAPL | Stock | 19.0525 | 19.0525 | 19.0525 | 19.0525 | 2800.0 |
| 2012-12-11 06:39:00 | AAPL | Stock | 19.0546 | 19.0546 | 19.0546 | 19.0546 | 2800.0 |
| 2012-12-11 06:43:00 | AAPL | Stock | 19.0446 | 19.0446 | 19.0446 | 19.0446 | 2800.0 |
| 2012-12-11 06:46:00 | AAPL | Stock | 19.0486 | 19.0486 | 19.0486 | 19.0486 | 2800.0 |
| 2012-12-11 06:48:00 | AAPL | Stock | 19.0536 | 19.0536 | 19.0446 | 19.0446 | 11200.0 |
| 2012-12-11 06:52:00 | AAPL | Stock | 19.0607 | 19.0679 | 19.0607 | 19.0632 | 19600.0 |
| 2012-12-11 06:59:00 | AAPL | Stock | 19.0668 | 19.0668 | 19.0668 | 19.0668 | 2800.0 |
| 2012-12-11 07:00:00 | AAPL | Stock | 19.0614 | 19.0614 | 19.0071 | 19.0071 | 30800.0 |
| 2012-12-11 07:01:00 | AAPL | Stock | 19.0429 | 19.0429 | 19.0429 | 19.0429 | 14000.0 |
| 2012-12-11 07:04:00 | AAPL | Stock | 19.0268 | 19.0268 | 19.0268 | 19.0268 | 2800.0 |
| 2012-12-11 07:05:00 | AAPL | Stock | 19.02 | 19.02 | 19.02 | 19.02 | 3416.0 |
| 2012-12-11 07:09:00 | AAPL | Stock | 19.0357 | 19.0357 | 19.0357 | 19.0357 | 8400.0 |
| 2012-12-11 07:10:00 | AAPL | Stock | 19.0446 | 19.0446 | 19.0446 | 19.0446 | 2800.0 |
| 2012-12-11 07:13:00 | AAPL | Stock | 19.0464 | 19.0464 | 19.0464 | 19.0464 | 32060.0 |
| 2012-12-11 07:14:00 | AAPL | Stock | 19.0486 | 19.0486 | 19.0482 | 19.0482 | 19600.0 |
| 2012-12-11 07:16:00 | AAPL | Stock | 19.0396 | 19.0396 | 19.0357 | 19.0357 | 22260.0 |
| 2012-12-11 07:18:00 | AAPL | Stock | 19.0329 | 19.0329 | 19.0329 | 19.0329 | 2800.0 |
| 2012-12-11 07:19:00 | AAPL | Stock | 19.0386 | 19.0386 | 19.0386 | 19.0386 | 2800.0 |
| 2012-12-11 07:20:00 | AAPL | Stock | 19.0446 | 19.0625 | 19.0446 | 19.0446 | 49252.0 |
| 2012-12-11 07:25:00 | AAPL | Stock | 19.0536 | 19.0536 | 19.0536 | 19.0536 | 5600.0 |
| 2012-12-11 07:26:00 | AAPL | Stock | 19.0632 | 19.0632 | 19.0554 | 19.0629 | 11200.0 |
| 2012-12-11 07:27:00 | AAPL | Stock | 19.0639 | 19.0714 | 19.0639 | 19.0714 | 14728.0 |
| 2012-12-11 07:28:00 | AAPL | Stock | 19.0871 | 19.0993 | 19.0871 | 19.0893 | 14140.0 |
| 2012-12-11 07:29:00 | AAPL | Stock | 19.1 | 19.1 | 19.1 | 19.1 | 2800.0 |
| 2012-12-11 07:30:00 | AAPL | Stock | 19.0993 | 19.1 | 19.0821 | 19.0954 | 29344.0 |
| 2012-12-11 07:31:00 | AAPL | Stock | 19.0939 | 19.0939 | 19.0871 | 19.0871 | 5600.0 |
| 2012-12-11 07:32:00 | AAPL | Stock | 19.0804 | 19.0943 | 19.0804 | 19.0943 | 31136.0 |
> showing 50 of 969,725 rows — these rows as CSV