PREVIEW / stock_1min / 2010-01-29
file: by_date/stock_1min/2010/2010-01-29.parquet size: 13.3 MB rows: 994,628 symbols: 2,785
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 |
|---|---|---|---|---|---|---|---|
| 2010-01-29 04:28:00 | AAPL | Stock | 7.1279 | 7.1279 | 7.1279 | 7.1279 | 3500.0 |
| 2010-01-29 05:18:00 | AAPL | Stock | 7.125 | 7.125 | 7.125 | 7.125 | 2800.0 |
| 2010-01-29 05:23:00 | AAPL | Stock | 7.125 | 7.125 | 7.125 | 7.125 | 2800.0 |
| 2010-01-29 06:54:00 | AAPL | Stock | 7.1425 | 7.1425 | 7.1425 | 7.1425 | 33600.0 |
| 2010-01-29 07:01:00 | AAPL | Stock | 7.15 | 7.15 | 7.15 | 7.15 | 2800.0 |
| 2010-01-29 07:03:00 | AAPL | Stock | 7.1429 | 7.1429 | 7.1429 | 7.1429 | 6188.0 |
| 2010-01-29 07:14:00 | AAPL | Stock | 7.1389 | 7.1389 | 7.1389 | 7.1389 | 11200.0 |
| 2010-01-29 07:15:00 | AAPL | Stock | 7.1393 | 7.1393 | 7.1393 | 7.1393 | 22400.0 |
| 2010-01-29 07:19:00 | AAPL | Stock | 7.1393 | 7.1393 | 7.1393 | 7.1393 | 2800.0 |
| 2010-01-29 07:22:00 | AAPL | Stock | 7.1411 | 7.1414 | 7.1411 | 7.1414 | 15680.0 |
| 2010-01-29 07:23:00 | AAPL | Stock | 7.1414 | 7.1414 | 7.1414 | 7.1414 | 2800.0 |
| 2010-01-29 07:33:00 | AAPL | Stock | 7.1404 | 7.1404 | 7.1404 | 7.1404 | 2800.0 |
| 2010-01-29 07:34:00 | AAPL | Stock | 7.1414 | 7.1414 | 7.1414 | 7.1414 | 8372.0 |
| 2010-01-29 07:46:00 | AAPL | Stock | 7.1432 | 7.1432 | 7.1432 | 7.1432 | 5600.0 |
| 2010-01-29 07:48:00 | AAPL | Stock | 7.1425 | 7.1436 | 7.1425 | 7.1436 | 11536.0 |
| 2010-01-29 07:49:00 | AAPL | Stock | 7.1436 | 7.1482 | 7.1436 | 7.1479 | 44800.0 |
| 2010-01-29 07:50:00 | AAPL | Stock | 7.1482 | 7.1482 | 7.1482 | 7.1482 | 2800.0 |
| 2010-01-29 07:51:00 | AAPL | Stock | 7.1482 | 7.15 | 7.1482 | 7.15 | 31220.0 |
| 2010-01-29 07:52:00 | AAPL | Stock | 7.1554 | 7.1554 | 7.1518 | 7.1536 | 75600.0 |
| 2010-01-29 07:55:00 | AAPL | Stock | 7.1557 | 7.1607 | 7.1557 | 7.1607 | 36400.0 |
| 2010-01-29 07:56:00 | AAPL | Stock | 7.1604 | 7.1604 | 7.1604 | 7.1604 | 2800.0 |
| 2010-01-29 07:57:00 | AAPL | Stock | 7.16 | 7.16 | 7.1579 | 7.1579 | 11200.0 |
| 2010-01-29 07:58:00 | AAPL | Stock | 7.1589 | 7.1621 | 7.1589 | 7.1621 | 109200.0 |
| 2010-01-29 08:00:00 | AAPL | Stock | 7.1554 | 7.1611 | 7.1518 | 7.1536 | 117180.0 |
| 2010-01-29 08:01:00 | AAPL | Stock | 7.1518 | 7.1564 | 7.1489 | 7.1518 | 62160.0 |
| 2010-01-29 08:02:00 | AAPL | Stock | 7.1521 | 7.1554 | 7.1468 | 7.1468 | 51184.0 |
| 2010-01-29 08:03:00 | AAPL | Stock | 7.1468 | 7.1468 | 7.1393 | 7.1396 | 121100.0 |
| 2010-01-29 08:04:00 | AAPL | Stock | 7.1396 | 7.1425 | 7.1393 | 7.1393 | 64400.0 |
| 2010-01-29 08:05:00 | AAPL | Stock | 7.1418 | 7.1429 | 7.1389 | 7.1429 | 88060.0 |
| 2010-01-29 08:06:00 | AAPL | Stock | 7.1411 | 7.1429 | 7.1404 | 7.1429 | 98308.0 |
| 2010-01-29 08:07:00 | AAPL | Stock | 7.1582 | 7.1582 | 7.1457 | 7.1457 | 33460.0 |
| 2010-01-29 08:08:00 | AAPL | Stock | 7.1479 | 7.1479 | 7.1429 | 7.1457 | 30800.0 |
| 2010-01-29 08:09:00 | AAPL | Stock | 7.1439 | 7.1439 | 7.1425 | 7.1425 | 75208.0 |
| 2010-01-29 08:10:00 | AAPL | Stock | 7.1421 | 7.1568 | 7.1421 | 7.1518 | 119560.0 |
| 2010-01-29 08:11:00 | AAPL | Stock | 7.15 | 7.1518 | 7.1471 | 7.1471 | 41580.0 |
| 2010-01-29 08:13:00 | AAPL | Stock | 7.1464 | 7.15 | 7.1429 | 7.1429 | 130200.0 |
| 2010-01-29 08:14:00 | AAPL | Stock | 7.1429 | 7.1429 | 7.1429 | 7.1429 | 2800.0 |
| 2010-01-29 08:15:00 | AAPL | Stock | 7.1471 | 7.15 | 7.1432 | 7.1432 | 30800.0 |
| 2010-01-29 08:16:00 | AAPL | Stock | 7.1493 | 7.1518 | 7.1493 | 7.1504 | 18760.0 |
| 2010-01-29 08:17:00 | AAPL | Stock | 7.1504 | 7.1557 | 7.1504 | 7.1529 | 64400.0 |
| 2010-01-29 08:18:00 | AAPL | Stock | 7.1511 | 7.155 | 7.15 | 7.155 | 54600.0 |
| 2010-01-29 08:19:00 | AAPL | Stock | 7.1518 | 7.1518 | 7.1482 | 7.1482 | 16324.0 |
| 2010-01-29 08:20:00 | AAPL | Stock | 7.1514 | 7.1514 | 7.15 | 7.15 | 7000.0 |
| 2010-01-29 08:21:00 | AAPL | Stock | 7.15 | 7.15 | 7.1486 | 7.15 | 9800.0 |
| 2010-01-29 08:22:00 | AAPL | Stock | 7.1486 | 7.1518 | 7.1486 | 7.1518 | 28644.0 |
| 2010-01-29 08:23:00 | AAPL | Stock | 7.1536 | 7.1579 | 7.1518 | 7.1554 | 107380.0 |
| 2010-01-29 08:24:00 | AAPL | Stock | 7.1575 | 7.1707 | 7.1554 | 7.1707 | 228956.0 |
| 2010-01-29 08:25:00 | AAPL | Stock | 7.1714 | 7.1757 | 7.1691 | 7.1714 | 168308.0 |
| 2010-01-29 08:26:00 | AAPL | Stock | 7.1696 | 7.1714 | 7.1679 | 7.1682 | 67256.0 |
| 2010-01-29 08:27:00 | AAPL | Stock | 7.1696 | 7.1739 | 7.1696 | 7.1739 | 136136.0 |
> showing 50 of 994,628 rows — these rows as CSV