PREVIEW / stock_5min / 2012-08-10
file: by_date/stock_5min/2012/2012-08-10.parquet size: 4.5 MB rows: 305,365 symbols: 3,493
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-08-10 06:05:00 | AAPL | Stock | 22.1321 | 22.1321 | 22.1321 | 22.1321 | 2800.0 |
| 2012-08-10 06:20:00 | AAPL | Stock | 22.1321 | 22.1321 | 22.1321 | 22.1321 | 6580.0 |
| 2012-08-10 07:00:00 | AAPL | Stock | 22.1218 | 22.1218 | 22.1204 | 22.1204 | 14980.0 |
| 2012-08-10 07:05:00 | AAPL | Stock | 22.125 | 22.125 | 22.1071 | 22.1071 | 29400.0 |
| 2012-08-10 07:10:00 | AAPL | Stock | 22.1071 | 22.1071 | 22.08 | 22.08 | 46452.0 |
| 2012-08-10 07:15:00 | AAPL | Stock | 22.0714 | 22.0714 | 22.0714 | 22.0714 | 5600.0 |
| 2012-08-10 07:20:00 | AAPL | Stock | 22.06 | 22.0714 | 22.06 | 22.0714 | 5600.0 |
| 2012-08-10 07:25:00 | AAPL | Stock | 22.0707 | 22.0714 | 22.0707 | 22.0711 | 28000.0 |
| 2012-08-10 07:30:00 | AAPL | Stock | 22.0714 | 22.0893 | 22.0714 | 22.0893 | 5600.0 |
| 2012-08-10 07:35:00 | AAPL | Stock | 22.0982 | 22.0982 | 22.0982 | 22.0982 | 25200.0 |
| 2012-08-10 07:50:00 | AAPL | Stock | 22.1071 | 22.1071 | 22.0875 | 22.0893 | 53116.0 |
| 2012-08-10 07:55:00 | AAPL | Stock | 22.0839 | 22.0893 | 22.0839 | 22.0893 | 7140.0 |
| 2012-08-10 08:00:00 | AAPL | Stock | 22.0907 | 22.0982 | 22.0893 | 22.0979 | 154084.0 |
| 2012-08-10 08:05:00 | AAPL | Stock | 22.0986 | 22.0986 | 22.0893 | 22.0893 | 47040.0 |
| 2012-08-10 08:10:00 | AAPL | Stock | 22.0911 | 22.0911 | 22.0857 | 22.0893 | 50456.0 |
| 2012-08-10 08:15:00 | AAPL | Stock | 22.0907 | 22.0907 | 22.0582 | 22.0582 | 42000.0 |
| 2012-08-10 08:20:00 | AAPL | Stock | 22.1004 | 22.1004 | 22.0886 | 22.0946 | 15120.0 |
| 2012-08-10 08:25:00 | AAPL | Stock | 22.1029 | 22.1689 | 22.0936 | 22.0993 | 357980.0 |
| 2012-08-10 08:30:00 | AAPL | Stock | 22.1007 | 22.1689 | 22.0929 | 22.0954 | 358400.0 |
| 2012-08-10 08:35:00 | AAPL | Stock | 22.0893 | 22.0993 | 22.0786 | 22.0961 | 121940.0 |
| 2012-08-10 08:40:00 | AAPL | Stock | 22.0929 | 22.0957 | 22.0825 | 22.0929 | 57120.0 |
| 2012-08-10 08:45:00 | AAPL | Stock | 22.0936 | 22.0982 | 22.0929 | 22.0964 | 74200.0 |
| 2012-08-10 08:50:00 | AAPL | Stock | 22.1 | 22.1154 | 22.1 | 22.1154 | 23800.0 |
| 2012-08-10 08:55:00 | AAPL | Stock | 22.1175 | 22.1357 | 22.1157 | 22.1357 | 82292.0 |
| 2012-08-10 09:00:00 | AAPL | Stock | 22.1364 | 22.1364 | 22.1164 | 22.1232 | 202048.0 |
| 2012-08-10 09:05:00 | AAPL | Stock | 22.1293 | 22.1304 | 22.1164 | 22.1164 | 82936.0 |
| 2012-08-10 09:10:00 | AAPL | Stock | 22.1179 | 22.1179 | 22.0989 | 22.1179 | 119532.0 |
| 2012-08-10 09:15:00 | AAPL | Stock | 22.1071 | 22.1186 | 22.1068 | 22.1125 | 60340.0 |
| 2012-08-10 09:20:00 | AAPL | Stock | 22.1121 | 22.1121 | 22.0929 | 22.0929 | 150024.0 |
| 2012-08-10 09:25:00 | AAPL | Stock | 22.0982 | 22.1161 | 22.0921 | 22.11 | 270116.0 |
| 2012-08-10 09:30:00 | AAPL | Stock | 22.1057 | 22.1494 | 22.0968 | 22.1182 | 8157940.0 |
| 2012-08-10 09:35:00 | AAPL | Stock | 22.12 | 22.1639 | 22.0964 | 22.1435 | 7241220.0 |
| 2012-08-10 09:40:00 | AAPL | Stock | 22.145 | 22.1607 | 22.1364 | 22.1432 | 3486196.0 |
| 2012-08-10 09:45:00 | AAPL | Stock | 22.1454 | 22.1482 | 22.125 | 22.1343 | 3924872.0 |
| 2012-08-10 09:50:00 | AAPL | Stock | 22.1375 | 22.1479 | 22.1182 | 22.1208 | 4377800.0 |
| 2012-08-10 09:55:00 | AAPL | Stock | 22.1198 | 22.1482 | 22.1182 | 22.1418 | 2733640.0 |
| 2012-08-10 10:00:00 | AAPL | Stock | 22.1429 | 22.1671 | 22.1393 | 22.1539 | 4365116.0 |
| 2012-08-10 10:05:00 | AAPL | Stock | 22.155 | 22.1729 | 22.1468 | 22.1617 | 2591652.0 |
| 2012-08-10 10:10:00 | AAPL | Stock | 22.1654 | 22.2057 | 22.1614 | 22.1925 | 6609036.0 |
| 2012-08-10 10:15:00 | AAPL | Stock | 22.1929 | 22.1957 | 22.1664 | 22.1686 | 3287592.0 |
| 2012-08-10 10:20:00 | AAPL | Stock | 22.1718 | 22.1807 | 22.1643 | 22.1729 | 2033780.0 |
| 2012-08-10 10:25:00 | AAPL | Stock | 22.1746 | 22.1786 | 22.1611 | 22.1679 | 2102492.0 |
| 2012-08-10 10:30:00 | AAPL | Stock | 22.1682 | 22.1907 | 22.165 | 22.1732 | 3445988.0 |
| 2012-08-10 10:35:00 | AAPL | Stock | 22.1743 | 22.1893 | 22.1661 | 22.1797 | 1770300.0 |
| 2012-08-10 10:40:00 | AAPL | Stock | 22.1786 | 22.1815 | 22.1682 | 22.1729 | 1414280.0 |
| 2012-08-10 10:45:00 | AAPL | Stock | 22.1768 | 22.1779 | 22.1479 | 22.1586 | 2453136.0 |
| 2012-08-10 10:50:00 | AAPL | Stock | 22.1617 | 22.1686 | 22.1511 | 22.1664 | 1243732.0 |
| 2012-08-10 10:55:00 | AAPL | Stock | 22.1652 | 22.1714 | 22.1536 | 22.1625 | 1195656.0 |
| 2012-08-10 11:00:00 | AAPL | Stock | 22.1657 | 22.1711 | 22.1383 | 22.1383 | 2252936.0 |
| 2012-08-10 11:05:00 | AAPL | Stock | 22.1421 | 22.1489 | 22.1286 | 22.1436 | 3030384.0 |
> showing 50 of 305,365 rows — these rows as CSV