PREVIEW / stock_5min / 2014-03-11
file: by_date/stock_5min/2014/2014-03-11.parquet size: 5.6 MB rows: 366,614 symbols: 3,535
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 |
|---|---|---|---|---|---|---|---|
| 2014-03-11 04:00:00 | AAPL | Stock | 18.9143 | 18.9143 | 18.9143 | 18.9143 | 25200.0 |
| 2014-03-11 04:10:00 | AAPL | Stock | 19.005 | 19.0329 | 19.005 | 19.0329 | 75376.0 |
| 2014-03-11 04:15:00 | AAPL | Stock | 19.0514 | 19.0539 | 19.0514 | 19.0539 | 5600.0 |
| 2014-03-11 04:20:00 | AAPL | Stock | 19.0946 | 19.0946 | 19.0946 | 19.0946 | 2800.0 |
| 2014-03-11 04:25:00 | AAPL | Stock | 19.0539 | 19.0696 | 19.0518 | 19.0696 | 16800.0 |
| 2014-03-11 04:35:00 | AAPL | Stock | 19.0804 | 19.0964 | 19.0804 | 19.0964 | 33600.0 |
| 2014-03-11 04:45:00 | AAPL | Stock | 19.1071 | 19.1286 | 19.1071 | 19.1071 | 33600.0 |
| 2014-03-11 04:50:00 | AAPL | Stock | 19.1071 | 19.1075 | 19.1071 | 19.1075 | 11200.0 |
| 2014-03-11 05:00:00 | AAPL | Stock | 19.1057 | 19.1057 | 19.1057 | 19.1057 | 2800.0 |
| 2014-03-11 05:05:00 | AAPL | Stock | 19.0896 | 19.0929 | 19.0896 | 19.0929 | 14000.0 |
| 2014-03-11 05:15:00 | AAPL | Stock | 19.0879 | 19.0879 | 19.0879 | 19.0879 | 2800.0 |
| 2014-03-11 05:20:00 | AAPL | Stock | 19.0886 | 19.0893 | 19.0879 | 19.0893 | 24360.0 |
| 2014-03-11 05:35:00 | AAPL | Stock | 19.1004 | 19.1004 | 19.0714 | 19.0714 | 5600.0 |
| 2014-03-11 06:10:00 | AAPL | Stock | 19.0589 | 19.0946 | 19.0589 | 19.0946 | 5600.0 |
| 2014-03-11 06:15:00 | AAPL | Stock | 19.0589 | 19.0589 | 19.0589 | 19.0589 | 5600.0 |
| 2014-03-11 06:20:00 | AAPL | Stock | 19.0711 | 19.0711 | 19.0711 | 19.0711 | 2800.0 |
| 2014-03-11 06:30:00 | AAPL | Stock | 19.0736 | 19.0939 | 19.0736 | 19.0939 | 9800.0 |
| 2014-03-11 06:35:00 | AAPL | Stock | 19.075 | 19.075 | 19.075 | 19.075 | 5600.0 |
| 2014-03-11 06:45:00 | AAPL | Stock | 19.0714 | 19.075 | 19.0714 | 19.075 | 5600.0 |
| 2014-03-11 07:00:00 | AAPL | Stock | 19.0964 | 19.0964 | 19.0964 | 19.0964 | 2800.0 |
| 2014-03-11 07:05:00 | AAPL | Stock | 19.0961 | 19.0961 | 19.0961 | 19.0961 | 2800.0 |
| 2014-03-11 07:10:00 | AAPL | Stock | 19.0893 | 19.0929 | 19.0714 | 19.0714 | 78400.0 |
| 2014-03-11 07:15:00 | AAPL | Stock | 19.0714 | 19.0714 | 19.0714 | 19.0714 | 18256.0 |
| 2014-03-11 07:20:00 | AAPL | Stock | 19.0639 | 19.0639 | 19.0536 | 19.0536 | 8400.0 |
| 2014-03-11 07:25:00 | AAPL | Stock | 19.0639 | 19.0657 | 19.0639 | 19.0657 | 5600.0 |
| 2014-03-11 07:30:00 | AAPL | Stock | 19.0657 | 19.0768 | 19.0657 | 19.0768 | 21000.0 |
| 2014-03-11 07:35:00 | AAPL | Stock | 19.0768 | 19.0879 | 19.0714 | 19.0857 | 57120.0 |
| 2014-03-11 07:40:00 | AAPL | Stock | 19.0821 | 19.0914 | 19.0729 | 19.0729 | 45864.0 |
| 2014-03-11 07:45:00 | AAPL | Stock | 19.0611 | 19.0611 | 19.0571 | 19.0571 | 41384.0 |
| 2014-03-11 07:50:00 | AAPL | Stock | 19.0689 | 19.0879 | 19.0689 | 19.0879 | 93940.0 |
| 2014-03-11 07:55:00 | AAPL | Stock | 19.0821 | 19.0821 | 19.075 | 19.075 | 14000.0 |
| 2014-03-11 08:00:00 | AAPL | Stock | 19.0893 | 19.0914 | 19.0446 | 19.0464 | 261660.0 |
| 2014-03-11 08:05:00 | AAPL | Stock | 19.0536 | 19.0536 | 19.0518 | 19.0518 | 29064.0 |
| 2014-03-11 08:10:00 | AAPL | Stock | 19.0536 | 19.0714 | 19.0521 | 19.0714 | 112000.0 |
| 2014-03-11 08:15:00 | AAPL | Stock | 19.0786 | 19.0829 | 19.0643 | 19.0643 | 91700.0 |
| 2014-03-11 08:20:00 | AAPL | Stock | 19.0711 | 19.0721 | 19.0693 | 19.0693 | 69776.0 |
| 2014-03-11 08:30:00 | AAPL | Stock | 19.0689 | 19.0696 | 19.0579 | 19.0696 | 19600.0 |
| 2014-03-11 08:35:00 | AAPL | Stock | 19.0636 | 19.0693 | 19.0536 | 19.0546 | 112000.0 |
| 2014-03-11 08:40:00 | AAPL | Stock | 19.0593 | 19.0714 | 19.0539 | 19.0704 | 202692.0 |
| 2014-03-11 08:45:00 | AAPL | Stock | 19.0661 | 19.0786 | 19.0654 | 19.0714 | 344596.0 |
| 2014-03-11 08:50:00 | AAPL | Stock | 19.0714 | 19.0732 | 19.0661 | 19.0714 | 159712.0 |
| 2014-03-11 08:55:00 | AAPL | Stock | 19.0707 | 19.0725 | 19.0661 | 19.0711 | 114296.0 |
| 2014-03-11 09:00:00 | AAPL | Stock | 19.0689 | 19.0779 | 19.0689 | 19.0775 | 92540.0 |
| 2014-03-11 09:05:00 | AAPL | Stock | 19.0775 | 19.0839 | 19.0768 | 19.0768 | 131180.0 |
| 2014-03-11 09:10:00 | AAPL | Stock | 19.0804 | 19.0839 | 19.08 | 19.0839 | 51800.0 |
| 2014-03-11 09:15:00 | AAPL | Stock | 19.0839 | 19.1036 | 19.0839 | 19.1036 | 410928.0 |
| 2014-03-11 09:20:00 | AAPL | Stock | 19.105 | 19.15 | 19.1036 | 19.1407 | 686280.0 |
| 2014-03-11 09:25:00 | AAPL | Stock | 19.1393 | 19.1468 | 19.1107 | 19.1204 | 1047564.0 |
| 2014-03-11 09:30:00 | AAPL | Stock | 19.1282 | 19.185 | 19.1093 | 19.1675 | 20593804.0 |
| 2014-03-11 09:35:00 | AAPL | Stock | 19.1707 | 19.1964 | 19.1472 | 19.1925 | 9131584.0 |
> showing 50 of 366,614 rows — these rows as CSV