PREVIEW / stock_5min / 2007-09-05
file: by_date/stock_5min/2007/2007-09-05.parquet size: 4.0 MB rows: 295,454 symbols: 3,102
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 |
|---|---|---|---|---|---|---|---|
| 2007-09-05 09:30:00 | AAPL | Stock | 5.1775 | 5.2086 | 5.1468 | 5.1771 | 56496636.0 |
| 2007-09-05 09:35:00 | AAPL | Stock | 5.1775 | 5.1818 | 5.1171 | 5.1482 | 56974708.0 |
| 2007-09-05 09:40:00 | AAPL | Stock | 5.1482 | 5.16 | 5.1286 | 5.1525 | 32887400.0 |
| 2007-09-05 09:45:00 | AAPL | Stock | 5.1529 | 5.1825 | 5.1479 | 5.1707 | 33538064.0 |
| 2007-09-05 09:50:00 | AAPL | Stock | 5.1714 | 5.1889 | 5.17 | 5.1736 | 23262036.0 |
| 2007-09-05 09:55:00 | AAPL | Stock | 5.1736 | 5.1757 | 5.1454 | 5.1521 | 20422024.0 |
| 2007-09-05 10:00:00 | AAPL | Stock | 5.1525 | 5.1664 | 5.1411 | 5.1525 | 25602836.0 |
| 2007-09-05 10:05:00 | AAPL | Stock | 5.1531 | 5.1604 | 5.1464 | 5.1579 | 14278348.0 |
| 2007-09-05 10:10:00 | AAPL | Stock | 5.1579 | 5.1579 | 5.1386 | 5.1432 | 16724008.0 |
| 2007-09-05 10:15:00 | AAPL | Stock | 5.1436 | 5.1543 | 5.1407 | 5.1532 | 15718556.0 |
| 2007-09-05 10:20:00 | AAPL | Stock | 5.1525 | 5.1554 | 5.1429 | 5.15 | 13901636.0 |
| 2007-09-05 10:25:00 | AAPL | Stock | 5.1504 | 5.1532 | 5.1407 | 5.1529 | 14133196.0 |
| 2007-09-05 10:30:00 | AAPL | Stock | 5.1525 | 5.1571 | 5.1482 | 5.1535 | 9630152.0 |
| 2007-09-05 10:35:00 | AAPL | Stock | 5.1529 | 5.1661 | 5.1511 | 5.1629 | 13954276.0 |
| 2007-09-05 10:40:00 | AAPL | Stock | 5.1629 | 5.1714 | 5.1611 | 5.1671 | 13397020.0 |
| 2007-09-05 10:45:00 | AAPL | Stock | 5.1671 | 5.1839 | 5.1668 | 5.1739 | 22227100.0 |
| 2007-09-05 10:50:00 | AAPL | Stock | 5.1732 | 5.1864 | 5.1696 | 5.185 | 13046124.0 |
| 2007-09-05 10:55:00 | AAPL | Stock | 5.1854 | 5.1864 | 5.1768 | 5.1851 | 12450284.0 |
| 2007-09-05 11:00:00 | AAPL | Stock | 5.185 | 5.1857 | 5.1725 | 5.1779 | 12810560.0 |
| 2007-09-05 11:05:00 | AAPL | Stock | 5.178 | 5.18 | 5.165 | 5.1689 | 12786340.0 |
| 2007-09-05 11:10:00 | AAPL | Stock | 5.1686 | 5.1696 | 5.155 | 5.1685 | 14577416.0 |
| 2007-09-05 11:15:00 | AAPL | Stock | 5.1676 | 5.1757 | 5.1629 | 5.1736 | 9021320.0 |
| 2007-09-05 11:20:00 | AAPL | Stock | 5.1729 | 5.1757 | 5.1482 | 5.155 | 14665112.0 |
| 2007-09-05 11:25:00 | AAPL | Stock | 5.155 | 5.1614 | 5.1475 | 5.1579 | 10560116.0 |
| 2007-09-05 11:30:00 | AAPL | Stock | 5.1582 | 5.1593 | 5.1489 | 5.15 | 8476188.0 |
| 2007-09-05 11:35:00 | AAPL | Stock | 5.1493 | 5.15 | 5.1368 | 5.1368 | 19441800.0 |
| 2007-09-05 11:40:00 | AAPL | Stock | 5.1371 | 5.1496 | 5.1332 | 5.1475 | 17490956.0 |
| 2007-09-05 11:45:00 | AAPL | Stock | 5.1465 | 5.1529 | 5.1393 | 5.1457 | 12853708.0 |
| 2007-09-05 11:50:00 | AAPL | Stock | 5.1457 | 5.1521 | 5.1454 | 5.1508 | 7148036.0 |
| 2007-09-05 11:55:00 | AAPL | Stock | 5.1507 | 5.1671 | 5.1507 | 5.1614 | 13499696.0 |
| 2007-09-05 12:00:00 | AAPL | Stock | 5.1614 | 5.1632 | 5.1546 | 5.1561 | 6451172.0 |
| 2007-09-05 12:05:00 | AAPL | Stock | 5.1561 | 5.1561 | 5.15 | 5.1554 | 6034504.0 |
| 2007-09-05 12:10:00 | AAPL | Stock | 5.155 | 5.1629 | 5.1543 | 5.1614 | 7321748.0 |
| 2007-09-05 12:15:00 | AAPL | Stock | 5.1611 | 5.1682 | 5.1571 | 5.1657 | 9795324.0 |
| 2007-09-05 12:20:00 | AAPL | Stock | 5.1661 | 5.1711 | 5.1636 | 5.1646 | 14636692.0 |
| 2007-09-05 12:25:00 | AAPL | Stock | 5.1646 | 5.1775 | 5.1636 | 5.1704 | 12173756.0 |
| 2007-09-05 12:30:00 | AAPL | Stock | 5.1707 | 5.1718 | 5.1611 | 5.1652 | 8198736.0 |
| 2007-09-05 12:35:00 | AAPL | Stock | 5.1654 | 5.1711 | 5.1625 | 5.1693 | 6208020.0 |
| 2007-09-05 12:40:00 | AAPL | Stock | 5.1696 | 5.1711 | 5.1496 | 5.1557 | 8185604.0 |
| 2007-09-05 12:45:00 | AAPL | Stock | 5.1557 | 5.1575 | 5.1429 | 5.15 | 11111212.0 |
| 2007-09-05 12:50:00 | AAPL | Stock | 5.1496 | 5.15 | 5.1389 | 5.1482 | 12554472.0 |
| 2007-09-05 12:55:00 | AAPL | Stock | 5.1475 | 5.1554 | 5.1461 | 5.1532 | 10879736.0 |
| 2007-09-05 13:00:00 | AAPL | Stock | 5.1529 | 5.1686 | 5.0964 | 5.0982 | 39753868.0 |
| 2007-09-05 13:05:00 | AAPL | Stock | 5.0982 | 5.1329 | 5.0714 | 5.0975 | 63062300.0 |
| 2007-09-05 13:10:00 | AAPL | Stock | 5.0975 | 5.1321 | 5.0921 | 5.1175 | 37342032.0 |
| 2007-09-05 13:15:00 | AAPL | Stock | 5.1175 | 5.15 | 5.1021 | 5.1081 | 41775944.0 |
| 2007-09-05 13:20:00 | AAPL | Stock | 5.1071 | 5.1082 | 4.9286 | 5.0129 | 78478260.0 |
| 2007-09-05 13:25:00 | AAPL | Stock | 5.0143 | 5.0921 | 5.0114 | 5.0354 | 37230312.0 |
| 2007-09-05 13:30:00 | AAPL | Stock | 5.0356 | 5.0707 | 5.0204 | 5.0614 | 36214500.0 |
| 2007-09-05 13:35:00 | AAPL | Stock | 5.0614 | 5.1032 | 5.0546 | 5.0936 | 43464540.0 |
> showing 50 of 295,454 rows — these rows as CSV