PREVIEW / stock_5min / 2010-01-29
file: by_date/stock_5min/2010/2010-01-29.parquet size: 4.9 MB rows: 329,831 symbols: 3,431
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 |
|---|---|---|---|---|---|---|---|
| 2010-01-29 04:25:00 | AAPL | Stock | 7.1279 | 7.1279 | 7.1279 | 7.1279 | 3500.0 |
| 2010-01-29 05:15:00 | AAPL | Stock | 7.125 | 7.125 | 7.125 | 7.125 | 2800.0 |
| 2010-01-29 05:20:00 | AAPL | Stock | 7.125 | 7.125 | 7.125 | 7.125 | 2800.0 |
| 2010-01-29 06:50:00 | AAPL | Stock | 7.1425 | 7.1425 | 7.1425 | 7.1425 | 33600.0 |
| 2010-01-29 07:00:00 | AAPL | Stock | 7.15 | 7.15 | 7.1429 | 7.1429 | 8988.0 |
| 2010-01-29 07:10:00 | AAPL | Stock | 7.1389 | 7.1389 | 7.1389 | 7.1389 | 11200.0 |
| 2010-01-29 07:15:00 | AAPL | Stock | 7.1393 | 7.1393 | 7.1393 | 7.1393 | 25200.0 |
| 2010-01-29 07:20:00 | AAPL | Stock | 7.1411 | 7.1414 | 7.1411 | 7.1414 | 18480.0 |
| 2010-01-29 07:30:00 | AAPL | Stock | 7.1404 | 7.1414 | 7.1404 | 7.1414 | 11172.0 |
| 2010-01-29 07:45:00 | AAPL | Stock | 7.1432 | 7.1482 | 7.1425 | 7.1479 | 61936.0 |
| 2010-01-29 07:50:00 | AAPL | Stock | 7.1482 | 7.1554 | 7.1482 | 7.1536 | 109620.0 |
| 2010-01-29 07:55:00 | AAPL | Stock | 7.1557 | 7.1621 | 7.1557 | 7.1621 | 159600.0 |
| 2010-01-29 08:00:00 | AAPL | Stock | 7.1554 | 7.1611 | 7.1393 | 7.1393 | 416024.0 |
| 2010-01-29 08:05:00 | AAPL | Stock | 7.1418 | 7.1582 | 7.1389 | 7.1425 | 325836.0 |
| 2010-01-29 08:10:00 | AAPL | Stock | 7.1421 | 7.1568 | 7.1421 | 7.1429 | 294140.0 |
| 2010-01-29 08:15:00 | AAPL | Stock | 7.1471 | 7.1557 | 7.1432 | 7.1482 | 184884.0 |
| 2010-01-29 08:20:00 | AAPL | Stock | 7.1514 | 7.1707 | 7.1486 | 7.1707 | 381780.0 |
| 2010-01-29 08:25:00 | AAPL | Stock | 7.1714 | 7.1757 | 7.1679 | 7.1696 | 515368.0 |
| 2010-01-29 08:30:00 | AAPL | Stock | 7.1714 | 7.2018 | 7.1704 | 7.2 | 1448860.0 |
| 2010-01-29 08:35:00 | AAPL | Stock | 7.2 | 7.2411 | 7.2 | 7.2179 | 2215248.0 |
| 2010-01-29 08:40:00 | AAPL | Stock | 7.2168 | 7.2179 | 7.2029 | 7.2071 | 1241772.0 |
| 2010-01-29 08:45:00 | AAPL | Stock | 7.2039 | 7.2057 | 7.1921 | 7.2036 | 371728.0 |
| 2010-01-29 08:50:00 | AAPL | Stock | 7.2036 | 7.2039 | 7.1821 | 7.1836 | 745920.0 |
| 2010-01-29 08:55:00 | AAPL | Stock | 7.1839 | 7.1946 | 7.1804 | 7.1929 | 561512.0 |
| 2010-01-29 09:00:00 | AAPL | Stock | 7.1921 | 7.1921 | 7.1786 | 7.1814 | 602616.0 |
| 2010-01-29 09:05:00 | AAPL | Stock | 7.1811 | 7.1839 | 7.1764 | 7.1832 | 832496.0 |
| 2010-01-29 09:10:00 | AAPL | Stock | 7.1832 | 7.1839 | 7.1718 | 7.175 | 563836.0 |
| 2010-01-29 09:15:00 | AAPL | Stock | 7.175 | 7.1821 | 7.1711 | 7.1804 | 636048.0 |
| 2010-01-29 09:20:00 | AAPL | Stock | 7.1789 | 7.1818 | 7.1714 | 7.1811 | 418040.0 |
| 2010-01-29 09:25:00 | AAPL | Stock | 7.1786 | 7.1818 | 7.1746 | 7.1807 | 396284.0 |
| 2010-01-29 09:30:00 | AAPL | Stock | 7.1811 | 7.1964 | 7.1486 | 7.1664 | 24652432.0 |
| 2010-01-29 09:35:00 | AAPL | Stock | 7.1664 | 7.2214 | 7.1525 | 7.2061 | 27966148.0 |
| 2010-01-29 09:40:00 | AAPL | Stock | 7.2061 | 7.2079 | 7.1518 | 7.1607 | 23042992.0 |
| 2010-01-29 09:45:00 | AAPL | Stock | 7.1604 | 7.1771 | 7.1389 | 7.1599 | 24249596.0 |
| 2010-01-29 09:50:00 | AAPL | Stock | 7.16 | 7.1946 | 7.1582 | 7.19 | 17546144.0 |
| 2010-01-29 09:55:00 | AAPL | Stock | 7.19 | 7.1996 | 7.1686 | 7.1696 | 13525988.0 |
| 2010-01-29 10:00:00 | AAPL | Stock | 7.1711 | 7.1725 | 7.1304 | 7.1356 | 16249716.0 |
| 2010-01-29 10:05:00 | AAPL | Stock | 7.1361 | 7.1386 | 7.0861 | 7.0864 | 26765284.0 |
| 2010-01-29 10:10:00 | AAPL | Stock | 7.0868 | 7.1825 | 7.0829 | 7.1086 | 21692048.0 |
| 2010-01-29 10:15:00 | AAPL | Stock | 7.1075 | 7.1311 | 7.1004 | 7.1129 | 12714912.0 |
| 2010-01-29 10:20:00 | AAPL | Stock | 7.1121 | 7.1518 | 7.0929 | 7.1468 | 18765236.0 |
| 2010-01-29 10:25:00 | AAPL | Stock | 7.1471 | 7.1546 | 7.1336 | 7.1487 | 10714592.0 |
| 2010-01-29 10:30:00 | AAPL | Stock | 7.1489 | 7.1636 | 7.1357 | 7.1447 | 13504848.0 |
| 2010-01-29 10:35:00 | AAPL | Stock | 7.1447 | 7.1457 | 7.1204 | 7.1286 | 7364140.0 |
| 2010-01-29 10:40:00 | AAPL | Stock | 7.1264 | 7.1321 | 7.1014 | 7.1032 | 10554040.0 |
| 2010-01-29 10:45:00 | AAPL | Stock | 7.1014 | 7.1225 | 7.0982 | 7.1218 | 8944824.0 |
| 2010-01-29 10:50:00 | AAPL | Stock | 7.1211 | 7.1225 | 7.0968 | 7.0979 | 7595588.0 |
| 2010-01-29 10:55:00 | AAPL | Stock | 7.0986 | 7.0993 | 7.0754 | 7.08 | 18793432.0 |
| 2010-01-29 11:00:00 | AAPL | Stock | 7.0799 | 7.0854 | 7.0536 | 7.0685 | 28501704.0 |
| 2010-01-29 11:05:00 | AAPL | Stock | 7.0689 | 7.0714 | 7.0364 | 7.0379 | 18759328.0 |
> showing 50 of 329,831 rows — these rows as CSV