PREVIEW / stock_5min / 2014-01-29
file: by_date/stock_5min/2014/2014-01-29.parquet size: 5.6 MB rows: 365,169 symbols: 3,524
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-01-29 04:00:00 | AAPL | Stock | 18.1929 | 18.2857 | 18.1929 | 18.2857 | 127988.0 |
| 2014-01-29 04:05:00 | AAPL | Stock | 18.3125 | 18.3125 | 18.2554 | 18.2554 | 37772.0 |
| 2014-01-29 04:10:00 | AAPL | Stock | 18.2261 | 18.2268 | 18.2232 | 18.2268 | 75852.0 |
| 2014-01-29 04:15:00 | AAPL | Stock | 18.2293 | 18.2293 | 18.2293 | 18.2293 | 2800.0 |
| 2014-01-29 04:25:00 | AAPL | Stock | 18.2514 | 18.2514 | 18.2514 | 18.2514 | 2800.0 |
| 2014-01-29 04:30:00 | AAPL | Stock | 18.25 | 18.25 | 18.25 | 18.25 | 2800.0 |
| 2014-01-29 04:35:00 | AAPL | Stock | 18.2414 | 18.2682 | 18.2414 | 18.2682 | 13860.0 |
| 2014-01-29 04:40:00 | AAPL | Stock | 18.2682 | 18.2682 | 18.2589 | 18.2589 | 31920.0 |
| 2014-01-29 04:45:00 | AAPL | Stock | 18.2589 | 18.2589 | 18.2589 | 18.2589 | 2800.0 |
| 2014-01-29 04:55:00 | AAPL | Stock | 18.2589 | 18.2589 | 18.2589 | 18.2589 | 2800.0 |
| 2014-01-29 05:00:00 | AAPL | Stock | 18.2589 | 18.2589 | 18.2589 | 18.2589 | 33600.0 |
| 2014-01-29 05:05:00 | AAPL | Stock | 18.2589 | 18.2589 | 18.2589 | 18.2589 | 8400.0 |
| 2014-01-29 05:10:00 | AAPL | Stock | 18.25 | 18.25 | 18.25 | 18.25 | 4900.0 |
| 2014-01-29 05:15:00 | AAPL | Stock | 18.2482 | 18.2482 | 18.2482 | 18.2482 | 2800.0 |
| 2014-01-29 05:20:00 | AAPL | Stock | 18.2482 | 18.25 | 18.2482 | 18.25 | 23940.0 |
| 2014-01-29 05:25:00 | AAPL | Stock | 18.2411 | 18.2411 | 18.215 | 18.2161 | 53424.0 |
| 2014-01-29 05:30:00 | AAPL | Stock | 18.2161 | 18.2161 | 18.2143 | 18.2143 | 40516.0 |
| 2014-01-29 05:35:00 | AAPL | Stock | 18.2143 | 18.2446 | 18.2143 | 18.2143 | 50400.0 |
| 2014-01-29 05:40:00 | AAPL | Stock | 18.1964 | 18.1964 | 18.1964 | 18.1964 | 8400.0 |
| 2014-01-29 05:45:00 | AAPL | Stock | 18.1964 | 18.1964 | 18.1804 | 18.1964 | 22400.0 |
| 2014-01-29 05:50:00 | AAPL | Stock | 18.2157 | 18.2157 | 18.2157 | 18.2157 | 2800.0 |
| 2014-01-29 05:55:00 | AAPL | Stock | 18.2143 | 18.2143 | 18.2143 | 18.2143 | 8400.0 |
| 2014-01-29 06:00:00 | AAPL | Stock | 18.2125 | 18.2143 | 18.2125 | 18.2125 | 16800.0 |
| 2014-01-29 06:10:00 | AAPL | Stock | 18.1964 | 18.1964 | 18.1964 | 18.1964 | 2800.0 |
| 2014-01-29 06:20:00 | AAPL | Stock | 18.21 | 18.2143 | 18.2036 | 18.2082 | 22400.0 |
| 2014-01-29 06:25:00 | AAPL | Stock | 18.1989 | 18.1989 | 18.1964 | 18.1964 | 24920.0 |
| 2014-01-29 06:30:00 | AAPL | Stock | 18.2071 | 18.2071 | 18.1786 | 18.1786 | 11564.0 |
| 2014-01-29 06:35:00 | AAPL | Stock | 18.1786 | 18.1786 | 18.1704 | 18.1786 | 14000.0 |
| 2014-01-29 06:40:00 | AAPL | Stock | 18.1832 | 18.1832 | 18.1429 | 18.1429 | 119784.0 |
| 2014-01-29 07:00:00 | AAPL | Stock | 18.1696 | 18.1696 | 18.1518 | 18.1518 | 35308.0 |
| 2014-01-29 07:05:00 | AAPL | Stock | 18.1643 | 18.1643 | 18.1607 | 18.1639 | 49056.0 |
| 2014-01-29 07:10:00 | AAPL | Stock | 18.1704 | 18.1786 | 18.1696 | 18.1786 | 72800.0 |
| 2014-01-29 07:15:00 | AAPL | Stock | 18.1786 | 18.1996 | 18.1782 | 18.1996 | 54040.0 |
| 2014-01-29 07:20:00 | AAPL | Stock | 18.1996 | 18.2107 | 18.1911 | 18.1986 | 106092.0 |
| 2014-01-29 07:25:00 | AAPL | Stock | 18.1861 | 18.1861 | 18.1646 | 18.1646 | 25200.0 |
| 2014-01-29 07:30:00 | AAPL | Stock | 18.175 | 18.1857 | 18.175 | 18.175 | 107100.0 |
| 2014-01-29 07:35:00 | AAPL | Stock | 18.1643 | 18.1643 | 18.1193 | 18.125 | 108444.0 |
| 2014-01-29 07:40:00 | AAPL | Stock | 18.1075 | 18.125 | 18.0732 | 18.0786 | 123200.0 |
| 2014-01-29 07:45:00 | AAPL | Stock | 18.0786 | 18.0893 | 18.0714 | 18.0714 | 83832.0 |
| 2014-01-29 07:50:00 | AAPL | Stock | 18.0925 | 18.125 | 18.0925 | 18.1186 | 148120.0 |
| 2014-01-29 07:55:00 | AAPL | Stock | 18.1221 | 18.125 | 18.1161 | 18.125 | 77504.0 |
| 2014-01-29 08:00:00 | AAPL | Stock | 18.125 | 18.2143 | 18.0929 | 18.1079 | 382900.0 |
| 2014-01-29 08:05:00 | AAPL | Stock | 18.1161 | 18.1275 | 18.0925 | 18.1071 | 201824.0 |
| 2014-01-29 08:10:00 | AAPL | Stock | 18.1096 | 18.1264 | 18.1071 | 18.1179 | 49952.0 |
| 2014-01-29 08:15:00 | AAPL | Stock | 18.125 | 18.1261 | 18.1161 | 18.1161 | 83328.0 |
| 2014-01-29 08:20:00 | AAPL | Stock | 18.1161 | 18.1271 | 18.1071 | 18.1118 | 76776.0 |
| 2014-01-29 08:25:00 | AAPL | Stock | 18.1089 | 18.1107 | 18.0914 | 18.0946 | 94108.0 |
| 2014-01-29 08:30:00 | AAPL | Stock | 18.1061 | 18.1061 | 18.0896 | 18.0918 | 123648.0 |
| 2014-01-29 08:35:00 | AAPL | Stock | 18.0893 | 18.1232 | 18.0857 | 18.1071 | 198184.0 |
| 2014-01-29 08:40:00 | AAPL | Stock | 18.0986 | 18.0986 | 18.0789 | 18.0893 | 126952.0 |
> showing 50 of 365,169 rows — these rows as CSV