PREVIEW / stock_5min / 2008-03-27
file: by_date/stock_5min/2008/2008-03-27.parquet size: 4.3 MB rows: 311,596 symbols: 3,275
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 |
|---|---|---|---|---|---|---|---|
| 2008-03-27 06:15:00 | AAPL | Stock | 5.1775 | 5.1775 | 5.1775 | 5.1775 | 3976.0 |
| 2008-03-27 06:20:00 | AAPL | Stock | 5.1786 | 5.1786 | 5.1786 | 5.1786 | 2800.0 |
| 2008-03-27 06:25:00 | AAPL | Stock | 5.1714 | 5.1714 | 5.1639 | 5.1639 | 16800.0 |
| 2008-03-27 06:30:00 | AAPL | Stock | 5.1518 | 5.1518 | 5.1489 | 5.1489 | 100800.0 |
| 2008-03-27 06:35:00 | AAPL | Stock | 5.1489 | 5.1489 | 5.1375 | 5.1375 | 19600.0 |
| 2008-03-27 06:45:00 | AAPL | Stock | 5.1457 | 5.1489 | 5.1457 | 5.1489 | 19600.0 |
| 2008-03-27 07:00:00 | AAPL | Stock | 5.1489 | 5.1518 | 5.1482 | 5.1482 | 51800.0 |
| 2008-03-27 07:05:00 | AAPL | Stock | 5.1518 | 5.1518 | 5.1518 | 5.1518 | 36400.0 |
| 2008-03-27 07:10:00 | AAPL | Stock | 5.1518 | 5.1639 | 5.1518 | 5.1518 | 79940.0 |
| 2008-03-27 07:15:00 | AAPL | Stock | 5.1589 | 5.1589 | 5.1589 | 5.1589 | 2800.0 |
| 2008-03-27 07:20:00 | AAPL | Stock | 5.1586 | 5.1714 | 5.1586 | 5.1714 | 60340.0 |
| 2008-03-27 07:25:00 | AAPL | Stock | 5.1696 | 5.1696 | 5.1646 | 5.1646 | 70840.0 |
| 2008-03-27 07:30:00 | AAPL | Stock | 5.1643 | 5.1643 | 5.1607 | 5.1607 | 39200.0 |
| 2008-03-27 07:35:00 | AAPL | Stock | 5.1536 | 5.1536 | 5.1507 | 5.1536 | 69132.0 |
| 2008-03-27 07:40:00 | AAPL | Stock | 5.15 | 5.1554 | 5.15 | 5.1554 | 99232.0 |
| 2008-03-27 07:45:00 | AAPL | Stock | 5.1554 | 5.1571 | 5.15 | 5.15 | 87416.0 |
| 2008-03-27 07:50:00 | AAPL | Stock | 5.1582 | 5.1582 | 5.1582 | 5.1582 | 11200.0 |
| 2008-03-27 07:55:00 | AAPL | Stock | 5.1507 | 5.1507 | 5.1507 | 5.1507 | 6776.0 |
| 2008-03-27 08:00:00 | AAPL | Stock | 5.15 | 5.15 | 5.1321 | 5.1321 | 482580.0 |
| 2008-03-27 08:05:00 | AAPL | Stock | 5.1336 | 5.1357 | 5.125 | 5.1357 | 177128.0 |
| 2008-03-27 08:10:00 | AAPL | Stock | 5.1339 | 5.1375 | 5.1339 | 5.1339 | 47012.0 |
| 2008-03-27 08:15:00 | AAPL | Stock | 5.1375 | 5.1429 | 5.1357 | 5.1386 | 40824.0 |
| 2008-03-27 08:20:00 | AAPL | Stock | 5.1386 | 5.1436 | 5.1386 | 5.1425 | 80192.0 |
| 2008-03-27 08:25:00 | AAPL | Stock | 5.1393 | 5.1393 | 5.1339 | 5.1371 | 118664.0 |
| 2008-03-27 08:30:00 | AAPL | Stock | 5.1407 | 5.1786 | 5.1407 | 5.1639 | 1308468.0 |
| 2008-03-27 08:35:00 | AAPL | Stock | 5.1643 | 5.1714 | 5.1639 | 5.1696 | 339752.0 |
| 2008-03-27 08:40:00 | AAPL | Stock | 5.1696 | 5.1768 | 5.1661 | 5.1764 | 369880.0 |
| 2008-03-27 08:45:00 | AAPL | Stock | 5.1736 | 5.1768 | 5.1718 | 5.175 | 368060.0 |
| 2008-03-27 08:50:00 | AAPL | Stock | 5.175 | 5.175 | 5.1714 | 5.1714 | 175560.0 |
| 2008-03-27 08:55:00 | AAPL | Stock | 5.1714 | 5.1736 | 5.1696 | 5.1732 | 86940.0 |
| 2008-03-27 09:00:00 | AAPL | Stock | 5.1736 | 5.1757 | 5.1675 | 5.1732 | 732788.0 |
| 2008-03-27 09:05:00 | AAPL | Stock | 5.1707 | 5.1718 | 5.1511 | 5.155 | 388976.0 |
| 2008-03-27 09:10:00 | AAPL | Stock | 5.1568 | 5.1636 | 5.1429 | 5.1571 | 882588.0 |
| 2008-03-27 09:15:00 | AAPL | Stock | 5.1554 | 5.1639 | 5.1532 | 5.1639 | 124936.0 |
| 2008-03-27 09:20:00 | AAPL | Stock | 5.1639 | 5.1668 | 5.1557 | 5.1661 | 173908.0 |
| 2008-03-27 09:25:00 | AAPL | Stock | 5.1661 | 5.1779 | 5.1636 | 5.1779 | 1488704.0 |
| 2008-03-27 09:30:00 | AAPL | Stock | 5.1768 | 5.1896 | 5.1539 | 5.1732 | 26335848.0 |
| 2008-03-27 09:35:00 | AAPL | Stock | 5.1739 | 5.1743 | 5.125 | 5.1389 | 25714500.0 |
| 2008-03-27 09:40:00 | AAPL | Stock | 5.1386 | 5.1661 | 5.1293 | 5.1518 | 22089284.0 |
| 2008-03-27 09:45:00 | AAPL | Stock | 5.1507 | 5.1643 | 5.1379 | 5.1496 | 17572072.0 |
| 2008-03-27 09:50:00 | AAPL | Stock | 5.1489 | 5.1564 | 5.1361 | 5.15 | 18401152.0 |
| 2008-03-27 09:55:00 | AAPL | Stock | 5.1507 | 5.1786 | 5.1414 | 5.1736 | 15567328.0 |
| 2008-03-27 10:00:00 | AAPL | Stock | 5.1736 | 5.175 | 5.1571 | 5.1625 | 12988444.0 |
| 2008-03-27 10:05:00 | AAPL | Stock | 5.1614 | 5.1629 | 5.1464 | 5.1529 | 11408544.0 |
| 2008-03-27 10:10:00 | AAPL | Stock | 5.1511 | 5.1786 | 5.1446 | 5.1761 | 14808976.0 |
| 2008-03-27 10:15:00 | AAPL | Stock | 5.1757 | 5.1875 | 5.1625 | 5.1643 | 20910260.0 |
| 2008-03-27 10:20:00 | AAPL | Stock | 5.1636 | 5.1664 | 5.15 | 5.1606 | 15984332.0 |
| 2008-03-27 10:25:00 | AAPL | Stock | 5.1579 | 5.1611 | 5.1346 | 5.1368 | 15928220.0 |
| 2008-03-27 10:30:00 | AAPL | Stock | 5.1368 | 5.1461 | 5.1118 | 5.1139 | 21180404.0 |
| 2008-03-27 10:35:00 | AAPL | Stock | 5.115 | 5.1189 | 5.0968 | 5.1097 | 25187204.0 |
> showing 50 of 311,596 rows — these rows as CSV