PREVIEW / stock_1min / 2005-11-04
file: by_date/stock_1min/2005/2005-11-04.parquet size: 7.4 MB rows: 597,388 symbols: 1,724
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-11-04 05:24:00 | AAPL | Stock | 2.175 | 2.175 | 2.175 | 2.175 | 14000.0 |
| 2005-11-04 05:25:00 | AAPL | Stock | 2.175 | 2.175 | 2.175 | 2.175 | 11200.0 |
| 2005-11-04 05:41:00 | AAPL | Stock | 2.1754 | 2.1754 | 2.175 | 2.175 | 28000.0 |
| 2005-11-04 06:05:00 | AAPL | Stock | 2.1696 | 2.1696 | 2.1696 | 2.1696 | 14000.0 |
| 2005-11-04 06:40:00 | AAPL | Stock | 2.1607 | 2.1607 | 2.1607 | 2.1607 | 2800.0 |
| 2005-11-04 07:00:00 | AAPL | Stock | 2.15 | 2.1504 | 2.15 | 2.1504 | 42000.0 |
| 2005-11-04 07:02:00 | AAPL | Stock | 2.1604 | 2.1689 | 2.1604 | 2.1689 | 44800.0 |
| 2005-11-04 07:06:00 | AAPL | Stock | 2.1571 | 2.1589 | 2.1571 | 2.1589 | 775600.0 |
| 2005-11-04 07:07:00 | AAPL | Stock | 2.1589 | 2.1589 | 2.1589 | 2.1589 | 187600.0 |
| 2005-11-04 07:08:00 | AAPL | Stock | 2.1589 | 2.1589 | 2.1589 | 2.1589 | 162400.0 |
| 2005-11-04 07:09:00 | AAPL | Stock | 2.1607 | 2.1607 | 2.1607 | 2.1607 | 64400.0 |
| 2005-11-04 07:11:00 | AAPL | Stock | 2.1589 | 2.1607 | 2.1589 | 2.1607 | 33600.0 |
| 2005-11-04 07:12:00 | AAPL | Stock | 2.1589 | 2.1589 | 2.1589 | 2.1589 | 11200.0 |
| 2005-11-04 07:14:00 | AAPL | Stock | 2.1589 | 2.1589 | 2.1589 | 2.1589 | 28000.0 |
| 2005-11-04 07:15:00 | AAPL | Stock | 2.1568 | 2.1568 | 2.1564 | 2.1564 | 42000.0 |
| 2005-11-04 07:16:00 | AAPL | Stock | 2.1564 | 2.1564 | 2.1564 | 2.1564 | 5600.0 |
| 2005-11-04 07:17:00 | AAPL | Stock | 2.1561 | 2.1561 | 2.1557 | 2.1557 | 25200.0 |
| 2005-11-04 07:18:00 | AAPL | Stock | 2.1579 | 2.1579 | 2.1575 | 2.1575 | 14000.0 |
| 2005-11-04 07:19:00 | AAPL | Stock | 2.1571 | 2.1571 | 2.1568 | 2.1571 | 42000.0 |
| 2005-11-04 07:20:00 | AAPL | Stock | 2.1571 | 2.1607 | 2.1571 | 2.1607 | 22400.0 |
| 2005-11-04 07:21:00 | AAPL | Stock | 2.1543 | 2.1543 | 2.1539 | 2.1539 | 27972.0 |
| 2005-11-04 07:23:00 | AAPL | Stock | 2.1579 | 2.1579 | 2.1579 | 2.1579 | 42000.0 |
| 2005-11-04 07:29:00 | AAPL | Stock | 2.1579 | 2.1579 | 2.1579 | 2.1579 | 14000.0 |
| 2005-11-04 07:31:00 | AAPL | Stock | 2.1579 | 2.1579 | 2.1579 | 2.1579 | 19600.0 |
| 2005-11-04 07:36:00 | AAPL | Stock | 2.1579 | 2.1579 | 2.1579 | 2.1579 | 36400.0 |
| 2005-11-04 07:40:00 | AAPL | Stock | 2.1582 | 2.1582 | 2.1582 | 2.1582 | 8372.0 |
| 2005-11-04 07:41:00 | AAPL | Stock | 2.1582 | 2.1604 | 2.1582 | 2.1604 | 11228.0 |
| 2005-11-04 07:43:00 | AAPL | Stock | 2.1607 | 2.1607 | 2.1607 | 2.1607 | 5600.0 |
| 2005-11-04 07:45:00 | AAPL | Stock | 2.1607 | 2.1607 | 2.1607 | 2.1607 | 14000.0 |
| 2005-11-04 07:46:00 | AAPL | Stock | 2.1589 | 2.1589 | 2.1571 | 2.1571 | 82852.0 |
| 2005-11-04 07:47:00 | AAPL | Stock | 2.1575 | 2.1589 | 2.1575 | 2.1589 | 11200.0 |
| 2005-11-04 07:50:00 | AAPL | Stock | 2.1589 | 2.1607 | 2.1589 | 2.1607 | 84000.0 |
| 2005-11-04 07:51:00 | AAPL | Stock | 2.1607 | 2.1632 | 2.1607 | 2.1632 | 21812.0 |
| 2005-11-04 07:57:00 | AAPL | Stock | 2.1636 | 2.165 | 2.1636 | 2.165 | 14000.0 |
| 2005-11-04 07:58:00 | AAPL | Stock | 2.1657 | 2.1657 | 2.1657 | 2.1657 | 16800.0 |
| 2005-11-04 08:00:00 | AAPL | Stock | 2.1629 | 2.1768 | 2.1546 | 2.1607 | 312284.0 |
| 2005-11-04 08:01:00 | AAPL | Stock | 2.1579 | 2.1686 | 2.1525 | 2.1536 | 1326052.0 |
| 2005-11-04 08:02:00 | AAPL | Stock | 2.1525 | 2.1589 | 2.1525 | 2.1568 | 118160.0 |
| 2005-11-04 08:03:00 | AAPL | Stock | 2.1554 | 2.1596 | 2.1554 | 2.1571 | 93128.0 |
| 2005-11-04 08:04:00 | AAPL | Stock | 2.1586 | 2.1586 | 2.1554 | 2.1557 | 151200.0 |
| 2005-11-04 08:05:00 | AAPL | Stock | 2.1557 | 2.1564 | 2.1525 | 2.1525 | 352660.0 |
| 2005-11-04 08:06:00 | AAPL | Stock | 2.1525 | 2.1546 | 2.1518 | 2.1546 | 250040.0 |
| 2005-11-04 08:07:00 | AAPL | Stock | 2.1546 | 2.1564 | 2.1536 | 2.1564 | 99540.0 |
| 2005-11-04 08:08:00 | AAPL | Stock | 2.1571 | 2.1621 | 2.1564 | 2.1618 | 304080.0 |
| 2005-11-04 08:09:00 | AAPL | Stock | 2.1621 | 2.1625 | 2.1593 | 2.1604 | 165200.0 |
| 2005-11-04 08:10:00 | AAPL | Stock | 2.1589 | 2.1596 | 2.1575 | 2.1589 | 85036.0 |
| 2005-11-04 08:11:00 | AAPL | Stock | 2.1593 | 2.1614 | 2.1593 | 2.1607 | 152768.0 |
| 2005-11-04 08:12:00 | AAPL | Stock | 2.1604 | 2.1639 | 2.1604 | 2.1629 | 70000.0 |
| 2005-11-04 08:13:00 | AAPL | Stock | 2.1639 | 2.1668 | 2.1639 | 2.1668 | 47600.0 |
| 2005-11-04 08:14:00 | AAPL | Stock | 2.1682 | 2.1682 | 2.1646 | 2.1675 | 179200.0 |
> showing 50 of 597,388 rows — these rows as CSV