PREVIEW / stock_5min / 2008-11-17
file: by_date/stock_5min/2008/2008-11-17.parquet size: 4.2 MB rows: 307,318 symbols: 3,310
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-11-17 07:00:00 | AAPL | Stock | 3.225 | 3.225 | 3.2018 | 3.2018 | 64400.0 |
| 2008-11-17 07:10:00 | AAPL | Stock | 3.2 | 3.2 | 3.2 | 3.2 | 2800.0 |
| 2008-11-17 07:15:00 | AAPL | Stock | 3.2018 | 3.2018 | 3.2018 | 3.2018 | 8400.0 |
| 2008-11-17 07:25:00 | AAPL | Stock | 3.1961 | 3.1964 | 3.1961 | 3.1964 | 7000.0 |
| 2008-11-17 07:55:00 | AAPL | Stock | 3.1786 | 3.1786 | 3.1786 | 3.1786 | 112000.0 |
| 2008-11-17 08:00:00 | AAPL | Stock | 3.1786 | 3.1921 | 3.1786 | 3.1875 | 143304.0 |
| 2008-11-17 08:05:00 | AAPL | Stock | 3.1843 | 3.1857 | 3.1786 | 3.1786 | 309260.0 |
| 2008-11-17 08:10:00 | AAPL | Stock | 3.1793 | 3.1793 | 3.1639 | 3.175 | 216496.0 |
| 2008-11-17 08:15:00 | AAPL | Stock | 3.1736 | 3.1754 | 3.1736 | 3.1754 | 10276.0 |
| 2008-11-17 08:20:00 | AAPL | Stock | 3.1793 | 3.1836 | 3.1786 | 3.1786 | 152264.0 |
| 2008-11-17 08:25:00 | AAPL | Stock | 3.1754 | 3.1786 | 3.1732 | 3.1786 | 438956.0 |
| 2008-11-17 08:30:00 | AAPL | Stock | 3.1818 | 3.1843 | 3.1736 | 3.1793 | 237860.0 |
| 2008-11-17 08:35:00 | AAPL | Stock | 3.1793 | 3.1825 | 3.1704 | 3.1743 | 276640.0 |
| 2008-11-17 08:40:00 | AAPL | Stock | 3.1743 | 3.1743 | 3.1607 | 3.1621 | 167384.0 |
| 2008-11-17 08:45:00 | AAPL | Stock | 3.1643 | 3.1643 | 3.1518 | 3.1554 | 927136.0 |
| 2008-11-17 08:50:00 | AAPL | Stock | 3.1554 | 3.1554 | 3.1304 | 3.1357 | 1136324.0 |
| 2008-11-17 08:55:00 | AAPL | Stock | 3.1393 | 3.1461 | 3.1386 | 3.1393 | 230804.0 |
| 2008-11-17 09:00:00 | AAPL | Stock | 3.1393 | 3.1429 | 3.135 | 3.1361 | 361228.0 |
| 2008-11-17 09:05:00 | AAPL | Stock | 3.1361 | 3.1429 | 3.135 | 3.1429 | 373240.0 |
| 2008-11-17 09:10:00 | AAPL | Stock | 3.1461 | 3.1543 | 3.1393 | 3.1525 | 507080.0 |
| 2008-11-17 09:15:00 | AAPL | Stock | 3.1529 | 3.1625 | 3.1421 | 3.15 | 456960.0 |
| 2008-11-17 09:20:00 | AAPL | Stock | 3.15 | 3.1675 | 3.15 | 3.1607 | 402920.0 |
| 2008-11-17 09:25:00 | AAPL | Stock | 3.1621 | 3.1621 | 3.15 | 3.1589 | 502768.0 |
| 2008-11-17 09:30:00 | AAPL | Stock | 3.16 | 3.1868 | 3.1429 | 3.1532 | 29487584.0 |
| 2008-11-17 09:35:00 | AAPL | Stock | 3.1529 | 3.2082 | 3.1523 | 3.1721 | 27106352.0 |
| 2008-11-17 09:40:00 | AAPL | Stock | 3.1714 | 3.1736 | 3.1379 | 3.1561 | 25234524.0 |
| 2008-11-17 09:45:00 | AAPL | Stock | 3.155 | 3.1714 | 3.1414 | 3.1654 | 22444044.0 |
| 2008-11-17 09:50:00 | AAPL | Stock | 3.1664 | 3.1911 | 3.1536 | 3.1664 | 22937292.0 |
| 2008-11-17 09:55:00 | AAPL | Stock | 3.1668 | 3.1818 | 3.1482 | 3.1482 | 20503280.0 |
| 2008-11-17 10:00:00 | AAPL | Stock | 3.1489 | 3.1525 | 3.1221 | 3.1379 | 29885212.0 |
| 2008-11-17 10:05:00 | AAPL | Stock | 3.1364 | 3.1521 | 3.1282 | 3.1486 | 19511884.0 |
| 2008-11-17 10:10:00 | AAPL | Stock | 3.1486 | 3.1518 | 3.1261 | 3.1411 | 18431448.0 |
| 2008-11-17 10:15:00 | AAPL | Stock | 3.1407 | 3.1486 | 3.1182 | 3.1218 | 19444544.0 |
| 2008-11-17 10:20:00 | AAPL | Stock | 3.1211 | 3.1443 | 3.1179 | 3.14 | 19886720.0 |
| 2008-11-17 10:25:00 | AAPL | Stock | 3.1407 | 3.1546 | 3.1296 | 3.1307 | 20558664.0 |
| 2008-11-17 10:30:00 | AAPL | Stock | 3.1314 | 3.1411 | 3.1171 | 3.1275 | 18207952.0 |
| 2008-11-17 10:35:00 | AAPL | Stock | 3.1268 | 3.1368 | 3.1164 | 3.1307 | 15345064.0 |
| 2008-11-17 10:40:00 | AAPL | Stock | 3.1314 | 3.1518 | 3.1257 | 3.1393 | 14322224.0 |
| 2008-11-17 10:45:00 | AAPL | Stock | 3.14 | 3.1454 | 3.1275 | 3.1343 | 13297760.0 |
| 2008-11-17 10:50:00 | AAPL | Stock | 3.135 | 3.1468 | 3.1311 | 3.1375 | 9952964.0 |
| 2008-11-17 10:55:00 | AAPL | Stock | 3.1375 | 3.1464 | 3.1339 | 3.1382 | 10245508.0 |
| 2008-11-17 11:00:00 | AAPL | Stock | 3.1375 | 3.1689 | 3.1361 | 3.1646 | 16815512.0 |
| 2008-11-17 11:05:00 | AAPL | Stock | 3.165 | 3.1714 | 3.1561 | 3.1639 | 11397232.0 |
| 2008-11-17 11:10:00 | AAPL | Stock | 3.1632 | 3.1736 | 3.1589 | 3.1621 | 13303220.0 |
| 2008-11-17 11:15:00 | AAPL | Stock | 3.1623 | 3.1679 | 3.1489 | 3.1632 | 10750180.0 |
| 2008-11-17 11:20:00 | AAPL | Stock | 3.1618 | 3.1714 | 3.1525 | 3.1557 | 8718612.0 |
| 2008-11-17 11:25:00 | AAPL | Stock | 3.1561 | 3.1668 | 3.1489 | 3.1543 | 8364860.0 |
| 2008-11-17 11:30:00 | AAPL | Stock | 3.1546 | 3.1696 | 3.1532 | 3.1693 | 8131060.0 |
| 2008-11-17 11:35:00 | AAPL | Stock | 3.1696 | 3.1757 | 3.1593 | 3.1732 | 8452948.0 |
| 2008-11-17 11:40:00 | AAPL | Stock | 3.1732 | 3.175 | 3.1575 | 3.1661 | 8988252.0 |
> showing 50 of 307,318 rows — these rows as CSV