PREVIEW / stock_5min / 2014-12-31
file: by_date/stock_5min/2014/2014-12-31.parquet size: 5.6 MB rows: 369,549 symbols: 3,560
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-12-31 04:05:00 | AAPL | Stock | 28.2225 | 28.2225 | 28.2225 | 28.2225 | 400.0 |
| 2014-12-31 04:15:00 | AAPL | Stock | 28.2225 | 28.2225 | 28.2225 | 28.2225 | 2400.0 |
| 2014-12-31 04:45:00 | AAPL | Stock | 28.2225 | 28.2225 | 28.2225 | 28.2225 | 800.0 |
| 2014-12-31 04:55:00 | AAPL | Stock | 28.2225 | 28.2225 | 28.2225 | 28.2225 | 400.0 |
| 2014-12-31 07:00:00 | AAPL | Stock | 28.2125 | 28.2125 | 28.2125 | 28.2125 | 1200.0 |
| 2014-12-31 07:05:00 | AAPL | Stock | 28.1875 | 28.1875 | 28.1875 | 28.1875 | 800.0 |
| 2014-12-31 07:15:00 | AAPL | Stock | 28.1875 | 28.2 | 28.1875 | 28.2 | 3600.0 |
| 2014-12-31 07:25:00 | AAPL | Stock | 28.2 | 28.2 | 28.2 | 28.2 | 1600.0 |
| 2014-12-31 07:30:00 | AAPL | Stock | 28.2 | 28.2 | 28.2 | 28.2 | 4044.0 |
| 2014-12-31 07:45:00 | AAPL | Stock | 28.1975 | 28.2 | 28.1975 | 28.2 | 3440.0 |
| 2014-12-31 07:50:00 | AAPL | Stock | 28.2 | 28.2 | 28.2 | 28.2 | 3956.0 |
| 2014-12-31 07:55:00 | AAPL | Stock | 28.2075 | 28.2125 | 28.2075 | 28.2125 | 12044.0 |
| 2014-12-31 08:00:00 | AAPL | Stock | 28.2125 | 28.215 | 28.1825 | 28.2 | 64560.0 |
| 2014-12-31 08:05:00 | AAPL | Stock | 28.19 | 28.2 | 28.19 | 28.2 | 20208.0 |
| 2014-12-31 08:10:00 | AAPL | Stock | 28.2 | 28.2075 | 28.2 | 28.2075 | 6908.0 |
| 2014-12-31 08:15:00 | AAPL | Stock | 28.2075 | 28.2175 | 28.2075 | 28.2075 | 4800.0 |
| 2014-12-31 08:20:00 | AAPL | Stock | 28.21 | 28.225 | 28.21 | 28.22 | 32312.0 |
| 2014-12-31 08:25:00 | AAPL | Stock | 28.22 | 28.2425 | 28.215 | 28.215 | 26936.0 |
| 2014-12-31 08:30:00 | AAPL | Stock | 28.2275 | 28.23 | 28.2275 | 28.23 | 9200.0 |
| 2014-12-31 08:35:00 | AAPL | Stock | 28.2375 | 28.2575 | 28.2375 | 28.2475 | 43840.0 |
| 2014-12-31 08:40:00 | AAPL | Stock | 28.2375 | 28.255 | 28.2375 | 28.255 | 17740.0 |
| 2014-12-31 08:45:00 | AAPL | Stock | 28.255 | 28.26 | 28.2375 | 28.24 | 17744.0 |
| 2014-12-31 08:50:00 | AAPL | Stock | 28.245 | 28.2475 | 28.24 | 28.24 | 13280.0 |
| 2014-12-31 08:55:00 | AAPL | Stock | 28.2425 | 28.28 | 28.2425 | 28.2675 | 49424.0 |
| 2014-12-31 09:00:00 | AAPL | Stock | 28.2625 | 28.2625 | 28.255 | 28.26 | 21760.0 |
| 2014-12-31 09:05:00 | AAPL | Stock | 28.25 | 28.26 | 28.2375 | 28.25 | 43544.0 |
| 2014-12-31 09:10:00 | AAPL | Stock | 28.2625 | 28.265 | 28.2575 | 28.265 | 22836.0 |
| 2014-12-31 09:15:00 | AAPL | Stock | 28.2575 | 28.2575 | 28.2425 | 28.2425 | 15196.0 |
| 2014-12-31 09:20:00 | AAPL | Stock | 28.24 | 28.24 | 28.225 | 28.225 | 14560.0 |
| 2014-12-31 09:25:00 | AAPL | Stock | 28.225 | 28.2325 | 28.1675 | 28.2125 | 211488.0 |
| 2014-12-31 09:30:00 | AAPL | Stock | 28.205 | 28.255 | 28.1325 | 28.2375 | 4171400.0 |
| 2014-12-31 09:35:00 | AAPL | Stock | 28.228 | 28.2825 | 28.1875 | 28.2225 | 2291360.0 |
| 2014-12-31 09:40:00 | AAPL | Stock | 28.2225 | 28.24 | 28.1575 | 28.158 | 1701032.0 |
| 2014-12-31 09:45:00 | AAPL | Stock | 28.1625 | 28.19 | 28.1475 | 28.1602 | 1605228.0 |
| 2014-12-31 09:50:00 | AAPL | Stock | 28.1625 | 28.202 | 28.155 | 28.1925 | 1399240.0 |
| 2014-12-31 09:55:00 | AAPL | Stock | 28.1932 | 28.1975 | 28.16 | 28.1925 | 1018892.0 |
| 2014-12-31 10:00:00 | AAPL | Stock | 28.1925 | 28.2025 | 28.1775 | 28.19 | 875840.0 |
| 2014-12-31 10:05:00 | AAPL | Stock | 28.1918 | 28.2025 | 28.175 | 28.1795 | 994044.0 |
| 2014-12-31 10:10:00 | AAPL | Stock | 28.179 | 28.1925 | 28.15 | 28.1612 | 873392.0 |
| 2014-12-31 10:15:00 | AAPL | Stock | 28.1625 | 28.165 | 28.0875 | 28.1092 | 2071928.0 |
| 2014-12-31 10:20:00 | AAPL | Stock | 28.11 | 28.14 | 28.1 | 28.1175 | 1083860.0 |
| 2014-12-31 10:25:00 | AAPL | Stock | 28.1162 | 28.1375 | 28.1162 | 28.1275 | 804472.0 |
| 2014-12-31 10:30:00 | AAPL | Stock | 28.1275 | 28.16 | 28.1275 | 28.1462 | 1054820.0 |
| 2014-12-31 10:35:00 | AAPL | Stock | 28.1452 | 28.1525 | 28.095 | 28.12 | 1267912.0 |
| 2014-12-31 10:40:00 | AAPL | Stock | 28.1225 | 28.1225 | 28.1 | 28.1075 | 770772.0 |
| 2014-12-31 10:45:00 | AAPL | Stock | 28.1058 | 28.1225 | 28.099 | 28.1225 | 643068.0 |
| 2014-12-31 10:50:00 | AAPL | Stock | 28.1225 | 28.1748 | 28.115 | 28.1675 | 1534736.0 |
| 2014-12-31 10:55:00 | AAPL | Stock | 28.1675 | 28.175 | 28.1525 | 28.1748 | 783672.0 |
| 2014-12-31 11:00:00 | AAPL | Stock | 28.1725 | 28.1798 | 28.1275 | 28.1315 | 1053392.0 |
| 2014-12-31 11:05:00 | AAPL | Stock | 28.1325 | 28.1475 | 28.1275 | 28.1425 | 888488.0 |
> showing 50 of 369,549 rows — these rows as CSV