PREVIEW / stock_5min / 2007-03-09
file: by_date/stock_5min/2007/2007-03-09.parquet size: 3.5 MB rows: 252,597 symbols: 2,516
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-03-09 04:55:00 | AAPL | Stock | 3.1561 | 3.1561 | 3.1561 | 3.1561 | 2800.0 |
| 2007-03-09 07:30:00 | AAPL | Stock | 3.1518 | 3.1518 | 3.1518 | 3.1518 | 5600.0 |
| 2007-03-09 07:35:00 | AAPL | Stock | 3.1468 | 3.1518 | 3.1464 | 3.1464 | 142800.0 |
| 2007-03-09 07:55:00 | AAPL | Stock | 3.1514 | 3.1518 | 3.1514 | 3.1518 | 28000.0 |
| 2007-03-09 08:00:00 | AAPL | Stock | 3.1514 | 3.1518 | 3.1486 | 3.1486 | 109760.0 |
| 2007-03-09 08:05:00 | AAPL | Stock | 3.1489 | 3.1489 | 3.1446 | 3.1464 | 215460.0 |
| 2007-03-09 08:10:00 | AAPL | Stock | 3.1446 | 3.1464 | 3.1446 | 3.1464 | 18900.0 |
| 2007-03-09 08:15:00 | AAPL | Stock | 3.1464 | 3.1468 | 3.1464 | 3.1468 | 25760.0 |
| 2007-03-09 08:20:00 | AAPL | Stock | 3.1464 | 3.1471 | 3.1464 | 3.1471 | 49700.0 |
| 2007-03-09 08:25:00 | AAPL | Stock | 3.1464 | 3.1464 | 3.145 | 3.145 | 39200.0 |
| 2007-03-09 08:30:00 | AAPL | Stock | 3.1461 | 3.1679 | 3.1461 | 3.1661 | 1734432.0 |
| 2007-03-09 08:35:00 | AAPL | Stock | 3.1671 | 3.1675 | 3.1596 | 3.1607 | 828576.0 |
| 2007-03-09 08:40:00 | AAPL | Stock | 3.1639 | 3.1639 | 3.1589 | 3.1607 | 770896.0 |
| 2007-03-09 08:45:00 | AAPL | Stock | 3.1607 | 3.1643 | 3.1607 | 3.1643 | 373100.0 |
| 2007-03-09 08:50:00 | AAPL | Stock | 3.1639 | 3.1639 | 3.1625 | 3.1625 | 50904.0 |
| 2007-03-09 08:55:00 | AAPL | Stock | 3.1625 | 3.1643 | 3.1614 | 3.1639 | 356300.0 |
| 2007-03-09 09:00:00 | AAPL | Stock | 3.1639 | 3.1643 | 3.1625 | 3.1643 | 324996.0 |
| 2007-03-09 09:05:00 | AAPL | Stock | 3.1646 | 3.1646 | 3.1614 | 3.1614 | 167468.0 |
| 2007-03-09 09:10:00 | AAPL | Stock | 3.1643 | 3.1682 | 3.1643 | 3.1679 | 832916.0 |
| 2007-03-09 09:15:00 | AAPL | Stock | 3.1686 | 3.1714 | 3.1686 | 3.1714 | 1149316.0 |
| 2007-03-09 09:20:00 | AAPL | Stock | 3.1714 | 3.1761 | 3.1711 | 3.1718 | 1093960.0 |
| 2007-03-09 09:25:00 | AAPL | Stock | 3.1718 | 3.175 | 3.1711 | 3.1714 | 301280.0 |
| 2007-03-09 09:30:00 | AAPL | Stock | 3.1714 | 3.1732 | 3.1589 | 3.1686 | 14756000.0 |
| 2007-03-09 09:35:00 | AAPL | Stock | 3.1679 | 3.1693 | 3.1475 | 3.1507 | 15267840.0 |
| 2007-03-09 09:40:00 | AAPL | Stock | 3.1507 | 3.1554 | 3.1461 | 3.1519 | 11900308.0 |
| 2007-03-09 09:45:00 | AAPL | Stock | 3.1525 | 3.1596 | 3.1511 | 3.1564 | 8456560.0 |
| 2007-03-09 09:50:00 | AAPL | Stock | 3.1561 | 3.1564 | 3.1386 | 3.1407 | 16550296.0 |
| 2007-03-09 09:55:00 | AAPL | Stock | 3.1409 | 3.1454 | 3.1346 | 3.14 | 16394364.0 |
| 2007-03-09 10:00:00 | AAPL | Stock | 3.1396 | 3.1704 | 3.1339 | 3.1379 | 12748960.0 |
| 2007-03-09 10:05:00 | AAPL | Stock | 3.1379 | 3.145 | 3.135 | 3.1368 | 11684960.0 |
| 2007-03-09 10:10:00 | AAPL | Stock | 3.1368 | 3.1429 | 3.1364 | 3.1393 | 7195776.0 |
| 2007-03-09 10:15:00 | AAPL | Stock | 3.1393 | 3.1429 | 3.1343 | 3.1382 | 8986796.0 |
| 2007-03-09 10:20:00 | AAPL | Stock | 3.1389 | 3.1493 | 3.1375 | 3.1471 | 14405916.0 |
| 2007-03-09 10:25:00 | AAPL | Stock | 3.1479 | 3.1511 | 3.1446 | 3.1489 | 7615832.0 |
| 2007-03-09 10:30:00 | AAPL | Stock | 3.1493 | 3.1511 | 3.1454 | 3.1464 | 6852216.0 |
| 2007-03-09 10:35:00 | AAPL | Stock | 3.1464 | 3.1514 | 3.1461 | 3.1486 | 4525332.0 |
| 2007-03-09 10:40:00 | AAPL | Stock | 3.1486 | 3.1521 | 3.1468 | 3.1475 | 6705888.0 |
| 2007-03-09 10:45:00 | AAPL | Stock | 3.1475 | 3.1507 | 3.1446 | 3.1507 | 5379304.0 |
| 2007-03-09 10:50:00 | AAPL | Stock | 3.1507 | 3.1536 | 3.1493 | 3.1507 | 4958016.0 |
| 2007-03-09 10:55:00 | AAPL | Stock | 3.1511 | 3.1529 | 3.1482 | 3.1496 | 2980656.0 |
| 2007-03-09 11:00:00 | AAPL | Stock | 3.1496 | 3.1518 | 3.1468 | 3.1504 | 4993100.0 |
| 2007-03-09 11:05:00 | AAPL | Stock | 3.15 | 3.1514 | 3.1457 | 3.1471 | 3806740.0 |
| 2007-03-09 11:10:00 | AAPL | Stock | 3.1464 | 3.1507 | 3.1461 | 3.1493 | 3823316.0 |
| 2007-03-09 11:15:00 | AAPL | Stock | 3.1493 | 3.1493 | 3.1461 | 3.1482 | 3332000.0 |
| 2007-03-09 11:20:00 | AAPL | Stock | 3.1486 | 3.1496 | 3.1457 | 3.1482 | 3103828.0 |
| 2007-03-09 11:25:00 | AAPL | Stock | 3.1482 | 3.1511 | 3.1475 | 3.15 | 2471616.0 |
| 2007-03-09 11:30:00 | AAPL | Stock | 3.15 | 3.1518 | 3.1479 | 3.1504 | 2012024.0 |
| 2007-03-09 11:35:00 | AAPL | Stock | 3.1504 | 3.155 | 3.1493 | 3.1546 | 6029044.0 |
| 2007-03-09 11:40:00 | AAPL | Stock | 3.1543 | 3.1546 | 3.1507 | 3.1531 | 2997820.0 |
| 2007-03-09 11:45:00 | AAPL | Stock | 3.1532 | 3.1536 | 3.1507 | 3.1518 | 2124248.0 |
> showing 50 of 252,597 rows — these rows as CSV