PREVIEW / stock_1min / 2012-12-03
file: by_date/stock_1min/2012/2012-12-03.parquet size: 12.9 MB rows: 962,810 symbols: 2,835
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-03 04:00:00 | AAPL | Stock | 21.0536 | 21.0536 | 21.0536 | 21.0536 | 2800.0 |
| 2012-12-03 04:04:00 | AAPL | Stock | 21.0536 | 21.0536 | 21.0471 | 21.0471 | 12460.0 |
| 2012-12-03 04:12:00 | AAPL | Stock | 21.0789 | 21.0789 | 21.0789 | 21.0789 | 2800.0 |
| 2012-12-03 04:31:00 | AAPL | Stock | 21.0679 | 21.0679 | 21.0679 | 21.0679 | 2800.0 |
| 2012-12-03 04:53:00 | AAPL | Stock | 21.0479 | 21.0479 | 21.0479 | 21.0479 | 2800.0 |
| 2012-12-03 04:57:00 | AAPL | Stock | 21.0396 | 21.0396 | 21.0396 | 21.0396 | 2800.0 |
| 2012-12-03 04:59:00 | AAPL | Stock | 21.0679 | 21.0714 | 21.0679 | 21.0714 | 8400.0 |
| 2012-12-03 05:00:00 | AAPL | Stock | 21.0536 | 21.0536 | 21.0536 | 21.0536 | 2800.0 |
| 2012-12-03 05:15:00 | AAPL | Stock | 21.0364 | 21.0364 | 21.0357 | 21.0357 | 5600.0 |
| 2012-12-03 05:20:00 | AAPL | Stock | 21.0429 | 21.0429 | 21.0429 | 21.0429 | 2800.0 |
| 2012-12-03 05:22:00 | AAPL | Stock | 21.0429 | 21.0429 | 21.0429 | 21.0429 | 25760.0 |
| 2012-12-03 05:24:00 | AAPL | Stock | 21.0429 | 21.0429 | 21.0429 | 21.0429 | 2800.0 |
| 2012-12-03 05:28:00 | AAPL | Stock | 21.0364 | 21.0364 | 21.0364 | 21.0364 | 2800.0 |
| 2012-12-03 05:34:00 | AAPL | Stock | 21.0379 | 21.0379 | 21.0379 | 21.0379 | 5600.0 |
| 2012-12-03 05:57:00 | AAPL | Stock | 21.0429 | 21.0429 | 21.0429 | 21.0429 | 8400.0 |
| 2012-12-03 06:12:00 | AAPL | Stock | 21.0429 | 21.0429 | 21.0429 | 21.0429 | 2800.0 |
| 2012-12-03 06:14:00 | AAPL | Stock | 21.0536 | 21.0536 | 21.0536 | 21.0536 | 2800.0 |
| 2012-12-03 06:21:00 | AAPL | Stock | 21.0432 | 21.0432 | 21.0429 | 21.0429 | 5600.0 |
| 2012-12-03 06:23:00 | AAPL | Stock | 21.0439 | 21.0439 | 21.0439 | 21.0439 | 2800.0 |
| 2012-12-03 06:24:00 | AAPL | Stock | 21.0429 | 21.0429 | 21.0429 | 21.0429 | 5600.0 |
| 2012-12-03 06:31:00 | AAPL | Stock | 21.0439 | 21.0439 | 21.0439 | 21.0439 | 2800.0 |
| 2012-12-03 07:00:00 | AAPL | Stock | 21.0625 | 21.0625 | 21.0536 | 21.0536 | 11200.0 |
| 2012-12-03 07:01:00 | AAPL | Stock | 21.0668 | 21.0668 | 21.0668 | 21.0668 | 4312.0 |
| 2012-12-03 07:02:00 | AAPL | Stock | 21.0607 | 21.0607 | 21.0546 | 21.0546 | 17612.0 |
| 2012-12-03 07:04:00 | AAPL | Stock | 21.0543 | 21.0546 | 21.0536 | 21.0546 | 9800.0 |
| 2012-12-03 07:05:00 | AAPL | Stock | 21.0543 | 21.0543 | 21.0543 | 21.0543 | 2800.0 |
| 2012-12-03 07:07:00 | AAPL | Stock | 21.0664 | 21.0664 | 21.0664 | 21.0664 | 2800.0 |
| 2012-12-03 07:12:00 | AAPL | Stock | 21.0704 | 21.0704 | 21.0704 | 21.0704 | 2800.0 |
| 2012-12-03 07:13:00 | AAPL | Stock | 21.0607 | 21.0661 | 21.0607 | 21.0661 | 5600.0 |
| 2012-12-03 07:19:00 | AAPL | Stock | 21.0714 | 21.0714 | 21.0714 | 21.0714 | 2800.0 |
| 2012-12-03 07:20:00 | AAPL | Stock | 21.0714 | 21.0714 | 21.0714 | 21.0714 | 2800.0 |
| 2012-12-03 07:22:00 | AAPL | Stock | 21.0761 | 21.0893 | 21.0761 | 21.0893 | 31220.0 |
| 2012-12-03 07:23:00 | AAPL | Stock | 21.0889 | 21.0893 | 21.0839 | 21.0839 | 23604.0 |
| 2012-12-03 07:24:00 | AAPL | Stock | 21.0839 | 21.0839 | 21.0839 | 21.0839 | 11200.0 |
| 2012-12-03 07:25:00 | AAPL | Stock | 21.0839 | 21.0839 | 21.0839 | 21.0839 | 5600.0 |
| 2012-12-03 07:26:00 | AAPL | Stock | 21.0857 | 21.0857 | 21.0857 | 21.0857 | 5096.0 |
| 2012-12-03 07:27:00 | AAPL | Stock | 21.0889 | 21.0889 | 21.0732 | 21.0732 | 15512.0 |
| 2012-12-03 07:28:00 | AAPL | Stock | 21.0854 | 21.0854 | 21.0854 | 21.0854 | 2800.0 |
| 2012-12-03 07:31:00 | AAPL | Stock | 21.0839 | 21.0839 | 21.0839 | 21.0839 | 4592.0 |
| 2012-12-03 07:33:00 | AAPL | Stock | 21.0768 | 21.0768 | 21.075 | 21.075 | 5600.0 |
| 2012-12-03 07:34:00 | AAPL | Stock | 21.0736 | 21.0736 | 21.0729 | 21.0729 | 5600.0 |
| 2012-12-03 07:36:00 | AAPL | Stock | 21.0679 | 21.0804 | 21.0679 | 21.0804 | 46900.0 |
| 2012-12-03 07:37:00 | AAPL | Stock | 21.0804 | 21.0804 | 21.0804 | 21.0804 | 7392.0 |
| 2012-12-03 07:38:00 | AAPL | Stock | 21.08 | 21.0804 | 21.0718 | 21.0804 | 19600.0 |
| 2012-12-03 07:41:00 | AAPL | Stock | 21.0804 | 21.0911 | 21.08 | 21.0911 | 73668.0 |
| 2012-12-03 07:42:00 | AAPL | Stock | 21.105 | 21.1071 | 21.105 | 21.1071 | 28000.0 |
| 2012-12-03 07:43:00 | AAPL | Stock | 21.1075 | 21.1075 | 21.1071 | 21.1071 | 8400.0 |
| 2012-12-03 07:44:00 | AAPL | Stock | 21.1161 | 21.125 | 21.1161 | 21.125 | 22400.0 |
| 2012-12-03 07:45:00 | AAPL | Stock | 21.1243 | 21.1289 | 21.1243 | 21.1289 | 37492.0 |
| 2012-12-03 07:46:00 | AAPL | Stock | 21.11 | 21.11 | 21.1082 | 21.1082 | 11312.0 |
> showing 50 of 962,810 rows — these rows as CSV