PREVIEW / stock_5min / 2004-12-20
file: by_date/stock_5min/2004/2004-12-20.parquet size: 2.6 MB rows: 189,694 symbols: 1,908
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-20 08:00:00 | AAPL | Stock | 1.1696 | 1.1738 | 1.1661 | 1.1704 | 359520.0 |
| 2004-12-20 08:05:00 | AAPL | Stock | 1.1704 | 1.1732 | 1.1704 | 1.1714 | 334320.0 |
| 2004-12-20 08:10:00 | AAPL | Stock | 1.1723 | 1.1786 | 1.1723 | 1.1759 | 791280.0 |
| 2004-12-20 08:15:00 | AAPL | Stock | 1.175 | 1.1759 | 1.1723 | 1.1723 | 110880.0 |
| 2004-12-20 08:20:00 | AAPL | Stock | 1.1746 | 1.1746 | 1.1746 | 1.1746 | 11200.0 |
| 2004-12-20 08:25:00 | AAPL | Stock | 1.1745 | 1.1745 | 1.1741 | 1.1741 | 55160.0 |
| 2004-12-20 08:30:00 | AAPL | Stock | 1.1729 | 1.1732 | 1.1729 | 1.1732 | 39200.0 |
| 2004-12-20 08:35:00 | AAPL | Stock | 1.1736 | 1.1739 | 1.1729 | 1.1729 | 182840.0 |
| 2004-12-20 08:40:00 | AAPL | Stock | 1.1729 | 1.1729 | 1.1688 | 1.1696 | 212800.0 |
| 2004-12-20 08:45:00 | AAPL | Stock | 1.1696 | 1.1714 | 1.1673 | 1.1714 | 518280.0 |
| 2004-12-20 08:50:00 | AAPL | Stock | 1.1714 | 1.1714 | 1.1688 | 1.1696 | 232960.0 |
| 2004-12-20 08:55:00 | AAPL | Stock | 1.1688 | 1.1693 | 1.1673 | 1.1673 | 196000.0 |
| 2004-12-20 09:00:00 | AAPL | Stock | 1.1684 | 1.1684 | 1.1625 | 1.1625 | 802480.0 |
| 2004-12-20 09:05:00 | AAPL | Stock | 1.1634 | 1.1679 | 1.1634 | 1.1661 | 411600.0 |
| 2004-12-20 09:10:00 | AAPL | Stock | 1.167 | 1.167 | 1.1643 | 1.1643 | 226800.0 |
| 2004-12-20 09:15:00 | AAPL | Stock | 1.1643 | 1.1723 | 1.1643 | 1.1723 | 665952.0 |
| 2004-12-20 09:20:00 | AAPL | Stock | 1.1723 | 1.1723 | 1.1698 | 1.1714 | 253680.0 |
| 2004-12-20 09:25:00 | AAPL | Stock | 1.1714 | 1.1718 | 1.1634 | 1.1693 | 2876440.0 |
| 2004-12-20 09:30:00 | AAPL | Stock | 1.1693 | 1.1763 | 1.1673 | 1.1673 | 28715008.0 |
| 2004-12-20 09:35:00 | AAPL | Stock | 1.1673 | 1.1746 | 1.1652 | 1.1716 | 15448888.0 |
| 2004-12-20 09:40:00 | AAPL | Stock | 1.1717 | 1.1786 | 1.1702 | 1.1745 | 21024528.0 |
| 2004-12-20 09:45:00 | AAPL | Stock | 1.1743 | 1.1777 | 1.1723 | 1.1723 | 16691080.0 |
| 2004-12-20 09:50:00 | AAPL | Stock | 1.1723 | 1.1741 | 1.1698 | 1.1725 | 17756200.0 |
| 2004-12-20 09:55:00 | AAPL | Stock | 1.1729 | 1.1732 | 1.1652 | 1.1677 | 12502448.0 |
| 2004-12-20 10:00:00 | AAPL | Stock | 1.1675 | 1.1716 | 1.1611 | 1.1652 | 23280824.0 |
| 2004-12-20 10:05:00 | AAPL | Stock | 1.1652 | 1.1663 | 1.1563 | 1.1574 | 24698520.0 |
| 2004-12-20 10:10:00 | AAPL | Stock | 1.1573 | 1.1573 | 1.1434 | 1.1466 | 32366768.0 |
| 2004-12-20 10:15:00 | AAPL | Stock | 1.1466 | 1.1516 | 1.1457 | 1.1491 | 23418360.0 |
| 2004-12-20 10:20:00 | AAPL | Stock | 1.1491 | 1.1566 | 1.1491 | 1.153 | 13655712.0 |
| 2004-12-20 10:25:00 | AAPL | Stock | 1.1529 | 1.1534 | 1.1509 | 1.1534 | 8038968.0 |
| 2004-12-20 10:30:00 | AAPL | Stock | 1.1534 | 1.1539 | 1.1484 | 1.15 | 9087624.0 |
| 2004-12-20 10:35:00 | AAPL | Stock | 1.1498 | 1.1532 | 1.1498 | 1.1516 | 6101816.0 |
| 2004-12-20 10:40:00 | AAPL | Stock | 1.1516 | 1.1518 | 1.1464 | 1.1473 | 11197088.0 |
| 2004-12-20 10:45:00 | AAPL | Stock | 1.1473 | 1.1477 | 1.1436 | 1.1453 | 17641792.0 |
| 2004-12-20 10:50:00 | AAPL | Stock | 1.1452 | 1.1468 | 1.135 | 1.1355 | 34037024.0 |
| 2004-12-20 10:55:00 | AAPL | Stock | 1.1359 | 1.1386 | 1.133 | 1.1371 | 29834448.0 |
| 2004-12-20 11:00:00 | AAPL | Stock | 1.1375 | 1.1375 | 1.1277 | 1.1289 | 21730744.0 |
| 2004-12-20 11:05:00 | AAPL | Stock | 1.1288 | 1.1354 | 1.1282 | 1.1346 | 15990464.0 |
| 2004-12-20 11:10:00 | AAPL | Stock | 1.1343 | 1.1391 | 1.1343 | 1.135 | 13846056.0 |
| 2004-12-20 11:15:00 | AAPL | Stock | 1.1348 | 1.1366 | 1.1325 | 1.1325 | 12505640.0 |
| 2004-12-20 11:20:00 | AAPL | Stock | 1.1325 | 1.137 | 1.1309 | 1.1357 | 11514048.0 |
| 2004-12-20 11:25:00 | AAPL | Stock | 1.1363 | 1.137 | 1.1348 | 1.1354 | 6139448.0 |
| 2004-12-20 11:30:00 | AAPL | Stock | 1.135 | 1.1427 | 1.135 | 1.1423 | 11818912.0 |
| 2004-12-20 11:35:00 | AAPL | Stock | 1.1425 | 1.1429 | 1.1377 | 1.1388 | 10816176.0 |
| 2004-12-20 11:40:00 | AAPL | Stock | 1.1393 | 1.1414 | 1.1377 | 1.1395 | 5931968.0 |
| 2004-12-20 11:45:00 | AAPL | Stock | 1.1395 | 1.14 | 1.1348 | 1.1355 | 6819904.0 |
| 2004-12-20 11:50:00 | AAPL | Stock | 1.1355 | 1.1357 | 1.1334 | 1.1341 | 8497888.0 |
| 2004-12-20 11:55:00 | AAPL | Stock | 1.1341 | 1.1341 | 1.1295 | 1.1304 | 8402184.0 |
| 2004-12-20 12:00:00 | AAPL | Stock | 1.1307 | 1.133 | 1.1296 | 1.13 | 7320488.0 |
| 2004-12-20 12:05:00 | AAPL | Stock | 1.1302 | 1.1321 | 1.1295 | 1.1318 | 6411552.0 |
> showing 50 of 189,694 rows — these rows as CSV