PREVIEW / stock_5min / 2005-01-04
file: by_date/stock_5min/2005/2005-01-04.parquet size: 2.8 MB rows: 199,745 symbols: 1,916
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 |
|---|---|---|---|---|---|---|---|
| 2005-01-04 08:05:00 | AAPL | Stock | 1.1348 | 1.1411 | 1.1348 | 1.1411 | 116200.0 |
| 2005-01-04 08:10:00 | AAPL | Stock | 1.1389 | 1.143 | 1.1389 | 1.143 | 987280.0 |
| 2005-01-04 08:15:00 | AAPL | Stock | 1.143 | 1.1446 | 1.1402 | 1.142 | 530320.0 |
| 2005-01-04 08:20:00 | AAPL | Stock | 1.1404 | 1.1411 | 1.1366 | 1.1366 | 660800.0 |
| 2005-01-04 08:25:00 | AAPL | Stock | 1.1366 | 1.138 | 1.1366 | 1.1375 | 736736.0 |
| 2005-01-04 08:30:00 | AAPL | Stock | 1.1375 | 1.1436 | 1.1375 | 1.143 | 618632.0 |
| 2005-01-04 08:35:00 | AAPL | Stock | 1.1432 | 1.1432 | 1.1414 | 1.1414 | 301504.0 |
| 2005-01-04 08:40:00 | AAPL | Stock | 1.142 | 1.142 | 1.1407 | 1.1407 | 92680.0 |
| 2005-01-04 08:45:00 | AAPL | Stock | 1.1411 | 1.1411 | 1.1393 | 1.1395 | 299600.0 |
| 2005-01-04 08:50:00 | AAPL | Stock | 1.1393 | 1.1393 | 1.1393 | 1.1393 | 89600.0 |
| 2005-01-04 08:55:00 | AAPL | Stock | 1.1402 | 1.1402 | 1.1393 | 1.1393 | 140000.0 |
| 2005-01-04 09:00:00 | AAPL | Stock | 1.1311 | 1.1393 | 1.1311 | 1.1393 | 184800.0 |
| 2005-01-04 09:05:00 | AAPL | Stock | 1.1393 | 1.1411 | 1.1393 | 1.1393 | 246120.0 |
| 2005-01-04 09:10:00 | AAPL | Stock | 1.1393 | 1.1393 | 1.1384 | 1.1384 | 428400.0 |
| 2005-01-04 09:15:00 | AAPL | Stock | 1.1377 | 1.1384 | 1.1375 | 1.1384 | 134344.0 |
| 2005-01-04 09:20:00 | AAPL | Stock | 1.1375 | 1.1375 | 1.1375 | 1.1375 | 341600.0 |
| 2005-01-04 09:25:00 | AAPL | Stock | 1.1334 | 1.1393 | 1.1334 | 1.1393 | 2024848.0 |
| 2005-01-04 09:30:00 | AAPL | Stock | 1.1393 | 1.1421 | 1.1339 | 1.1377 | 25113872.0 |
| 2005-01-04 09:35:00 | AAPL | Stock | 1.1375 | 1.1384 | 1.1309 | 1.1364 | 23392264.0 |
| 2005-01-04 09:40:00 | AAPL | Stock | 1.1361 | 1.1396 | 1.1341 | 1.1391 | 14020496.0 |
| 2005-01-04 09:45:00 | AAPL | Stock | 1.1391 | 1.1457 | 1.1329 | 1.1441 | 23928968.0 |
| 2005-01-04 09:50:00 | AAPL | Stock | 1.1445 | 1.1518 | 1.1432 | 1.1509 | 28173432.0 |
| 2005-01-04 09:55:00 | AAPL | Stock | 1.1514 | 1.1518 | 1.1473 | 1.1473 | 24768128.0 |
| 2005-01-04 10:00:00 | AAPL | Stock | 1.1475 | 1.1604 | 1.1473 | 1.1598 | 40508720.0 |
| 2005-01-04 10:05:00 | AAPL | Stock | 1.1598 | 1.1691 | 1.1489 | 1.1661 | 58616544.0 |
| 2005-01-04 10:10:00 | AAPL | Stock | 1.1655 | 1.1688 | 1.1638 | 1.1638 | 34246632.0 |
| 2005-01-04 10:15:00 | AAPL | Stock | 1.1639 | 1.1675 | 1.1584 | 1.1595 | 29639624.0 |
| 2005-01-04 10:20:00 | AAPL | Stock | 1.1596 | 1.1625 | 1.1339 | 1.1595 | 23242688.0 |
| 2005-01-04 10:25:00 | AAPL | Stock | 1.1598 | 1.1643 | 1.1582 | 1.1634 | 22842904.0 |
| 2005-01-04 10:30:00 | AAPL | Stock | 1.1636 | 1.1652 | 1.1545 | 1.1554 | 22241352.0 |
| 2005-01-04 10:35:00 | AAPL | Stock | 1.1552 | 1.1679 | 1.1546 | 1.1602 | 19271168.0 |
| 2005-01-04 10:40:00 | AAPL | Stock | 1.16 | 1.1607 | 1.1584 | 1.1591 | 9900240.0 |
| 2005-01-04 10:45:00 | AAPL | Stock | 1.1591 | 1.1614 | 1.1582 | 1.1602 | 16571240.0 |
| 2005-01-04 10:50:00 | AAPL | Stock | 1.1604 | 1.1641 | 1.1595 | 1.1619 | 16562000.0 |
| 2005-01-04 10:55:00 | AAPL | Stock | 1.1618 | 1.167 | 1.16 | 1.1666 | 22330112.0 |
| 2005-01-04 11:00:00 | AAPL | Stock | 1.1666 | 1.168 | 1.1629 | 1.1629 | 15729560.0 |
| 2005-01-04 11:05:00 | AAPL | Stock | 1.1629 | 1.1629 | 1.1563 | 1.1607 | 18064032.0 |
| 2005-01-04 11:10:00 | AAPL | Stock | 1.1607 | 1.1623 | 1.158 | 1.1602 | 7638736.0 |
| 2005-01-04 11:15:00 | AAPL | Stock | 1.1604 | 1.1621 | 1.158 | 1.1609 | 40052544.0 |
| 2005-01-04 11:20:00 | AAPL | Stock | 1.1609 | 1.1614 | 1.1584 | 1.1596 | 7069272.0 |
| 2005-01-04 11:25:00 | AAPL | Stock | 1.1598 | 1.1607 | 1.1589 | 1.1596 | 3418856.0 |
| 2005-01-04 11:30:00 | AAPL | Stock | 1.16 | 1.1613 | 1.1593 | 1.1605 | 4802840.0 |
| 2005-01-04 11:35:00 | AAPL | Stock | 1.1604 | 1.1613 | 1.1588 | 1.1607 | 7522368.0 |
| 2005-01-04 11:40:00 | AAPL | Stock | 1.1604 | 1.1623 | 1.1602 | 1.1614 | 8677592.0 |
| 2005-01-04 11:45:00 | AAPL | Stock | 1.1614 | 1.1616 | 1.1593 | 1.1605 | 7152488.0 |
| 2005-01-04 11:50:00 | AAPL | Stock | 1.1604 | 1.1611 | 1.1595 | 1.1609 | 4462416.0 |
| 2005-01-04 11:55:00 | AAPL | Stock | 1.1609 | 1.1609 | 1.1586 | 1.1589 | 6801256.0 |
| 2005-01-04 12:00:00 | AAPL | Stock | 1.1589 | 1.1598 | 1.1527 | 1.1539 | 17484096.0 |
| 2005-01-04 12:05:00 | AAPL | Stock | 1.1536 | 1.1561 | 1.1536 | 1.1555 | 7181272.0 |
| 2005-01-04 12:10:00 | AAPL | Stock | 1.1554 | 1.1559 | 1.1514 | 1.1518 | 13760320.0 |
> showing 50 of 199,745 rows — these rows as CSV