PREVIEW / stock_5min / 2004-12-31
file: by_date/stock_5min/2004/2004-12-31.parquet size: 2.4 MB rows: 181,785 symbols: 1,904
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 |
|---|---|---|---|---|---|---|---|
| 2004-12-31 08:20:00 | AAPL | Stock | 1.1589 | 1.1589 | 1.1589 | 1.1589 | 28000.0 |
| 2004-12-31 08:25:00 | AAPL | Stock | 1.1589 | 1.1589 | 1.1589 | 1.1589 | 11200.0 |
| 2004-12-31 08:30:00 | AAPL | Stock | 1.1598 | 1.1605 | 1.1598 | 1.1605 | 56000.0 |
| 2004-12-31 08:35:00 | AAPL | Stock | 1.1605 | 1.1607 | 1.1605 | 1.1607 | 80080.0 |
| 2004-12-31 08:40:00 | AAPL | Stock | 1.1614 | 1.165 | 1.1614 | 1.1634 | 963200.0 |
| 2004-12-31 08:45:00 | AAPL | Stock | 1.1643 | 1.1643 | 1.1643 | 1.1643 | 11200.0 |
| 2004-12-31 08:50:00 | AAPL | Stock | 1.163 | 1.1634 | 1.1616 | 1.1616 | 95760.0 |
| 2004-12-31 08:55:00 | AAPL | Stock | 1.1616 | 1.1616 | 1.1616 | 1.1616 | 5600.0 |
| 2004-12-31 09:00:00 | AAPL | Stock | 1.1616 | 1.1616 | 1.1616 | 1.1616 | 44800.0 |
| 2004-12-31 09:05:00 | AAPL | Stock | 1.1616 | 1.1616 | 1.1607 | 1.1607 | 76608.0 |
| 2004-12-31 09:10:00 | AAPL | Stock | 1.1607 | 1.1607 | 1.1607 | 1.1607 | 16800.0 |
| 2004-12-31 09:15:00 | AAPL | Stock | 1.1607 | 1.1607 | 1.1607 | 1.1607 | 39200.0 |
| 2004-12-31 09:25:00 | AAPL | Stock | 1.1588 | 1.1607 | 1.1579 | 1.1588 | 395808.0 |
| 2004-12-31 09:30:00 | AAPL | Stock | 1.1588 | 1.1607 | 1.1546 | 1.1546 | 7390096.0 |
| 2004-12-31 09:35:00 | AAPL | Stock | 1.1546 | 1.1584 | 1.1546 | 1.158 | 5168688.0 |
| 2004-12-31 09:40:00 | AAPL | Stock | 1.1579 | 1.16 | 1.1571 | 1.1571 | 5305216.0 |
| 2004-12-31 09:45:00 | AAPL | Stock | 1.1571 | 1.1586 | 1.1557 | 1.1559 | 4880344.0 |
| 2004-12-31 09:50:00 | AAPL | Stock | 1.1559 | 1.1579 | 1.1545 | 1.1577 | 4473784.0 |
| 2004-12-31 09:55:00 | AAPL | Stock | 1.1579 | 1.1579 | 1.1557 | 1.1564 | 2237424.0 |
| 2004-12-31 10:00:00 | AAPL | Stock | 1.1566 | 1.1593 | 1.1561 | 1.1573 | 6339536.0 |
| 2004-12-31 10:05:00 | AAPL | Stock | 1.1573 | 1.1575 | 1.152 | 1.1527 | 6677048.0 |
| 2004-12-31 10:10:00 | AAPL | Stock | 1.1525 | 1.1552 | 1.1518 | 1.1552 | 7032760.0 |
| 2004-12-31 10:15:00 | AAPL | Stock | 1.155 | 1.1559 | 1.1536 | 1.1541 | 2470328.0 |
| 2004-12-31 10:20:00 | AAPL | Stock | 1.1539 | 1.1559 | 1.1538 | 1.1557 | 1583960.0 |
| 2004-12-31 10:25:00 | AAPL | Stock | 1.1555 | 1.157 | 1.1545 | 1.1557 | 2614080.0 |
| 2004-12-31 10:30:00 | AAPL | Stock | 1.1554 | 1.1559 | 1.1548 | 1.1548 | 749448.0 |
| 2004-12-31 10:35:00 | AAPL | Stock | 1.1546 | 1.1557 | 1.1546 | 1.155 | 1328152.0 |
| 2004-12-31 10:40:00 | AAPL | Stock | 1.155 | 1.157 | 1.1536 | 1.1568 | 3138968.0 |
| 2004-12-31 10:45:00 | AAPL | Stock | 1.157 | 1.157 | 1.1543 | 1.1548 | 3882424.0 |
| 2004-12-31 10:50:00 | AAPL | Stock | 1.1546 | 1.155 | 1.1529 | 1.1545 | 3419024.0 |
| 2004-12-31 10:55:00 | AAPL | Stock | 1.1545 | 1.1555 | 1.1545 | 1.155 | 2125480.0 |
| 2004-12-31 11:00:00 | AAPL | Stock | 1.1554 | 1.1554 | 1.1543 | 1.1546 | 630280.0 |
| 2004-12-31 11:05:00 | AAPL | Stock | 1.1545 | 1.1552 | 1.1525 | 1.1527 | 4413136.0 |
| 2004-12-31 11:10:00 | AAPL | Stock | 1.1527 | 1.1527 | 1.152 | 1.1527 | 2170056.0 |
| 2004-12-31 11:15:00 | AAPL | Stock | 1.1523 | 1.1527 | 1.152 | 1.1525 | 2345952.0 |
| 2004-12-31 11:20:00 | AAPL | Stock | 1.1525 | 1.1525 | 1.1502 | 1.1514 | 11591328.0 |
| 2004-12-31 11:25:00 | AAPL | Stock | 1.1514 | 1.1523 | 1.1507 | 1.1514 | 2232216.0 |
| 2004-12-31 11:30:00 | AAPL | Stock | 1.1513 | 1.1516 | 1.1502 | 1.1513 | 2944480.0 |
| 2004-12-31 11:35:00 | AAPL | Stock | 1.1511 | 1.1514 | 1.15 | 1.1513 | 2313136.0 |
| 2004-12-31 11:40:00 | AAPL | Stock | 1.1513 | 1.152 | 1.1511 | 1.1513 | 1666840.0 |
| 2004-12-31 11:45:00 | AAPL | Stock | 1.1511 | 1.1514 | 1.1509 | 1.1512 | 1058120.0 |
| 2004-12-31 11:50:00 | AAPL | Stock | 1.1509 | 1.1514 | 1.1509 | 1.1513 | 1030232.0 |
| 2004-12-31 11:55:00 | AAPL | Stock | 1.1511 | 1.152 | 1.1511 | 1.152 | 1453144.0 |
| 2004-12-31 12:00:00 | AAPL | Stock | 1.1518 | 1.1534 | 1.1514 | 1.1525 | 2017904.0 |
| 2004-12-31 12:05:00 | AAPL | Stock | 1.1525 | 1.1548 | 1.1525 | 1.1527 | 2757440.0 |
| 2004-12-31 12:10:00 | AAPL | Stock | 1.153 | 1.1536 | 1.1529 | 1.1532 | 1746976.0 |
| 2004-12-31 12:15:00 | AAPL | Stock | 1.1529 | 1.1529 | 1.1518 | 1.152 | 1042664.0 |
| 2004-12-31 12:20:00 | AAPL | Stock | 1.1518 | 1.152 | 1.1511 | 1.1514 | 746424.0 |
| 2004-12-31 12:25:00 | AAPL | Stock | 1.1514 | 1.1536 | 1.1511 | 1.1511 | 3253936.0 |
| 2004-12-31 12:30:00 | AAPL | Stock | 1.1511 | 1.1514 | 1.1479 | 1.148 | 6297872.0 |
> showing 50 of 181,785 rows — these rows as CSV