PREVIEW / stock_1min / 2012-11-23
file: by_date/stock_1min/2012/2012-11-23.parquet size: 6.6 MB rows: 477,180 symbols: 2,690
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 |
|---|---|---|---|---|---|---|---|
| 2012-11-23 04:05:00 | AAPL | Stock | 20.125 | 20.125 | 20.125 | 20.125 | 14000.0 |
| 2012-11-23 04:25:00 | AAPL | Stock | 20.125 | 20.125 | 20.125 | 20.125 | 2800.0 |
| 2012-11-23 04:59:00 | AAPL | Stock | 20.1429 | 20.1429 | 20.1429 | 20.1429 | 5600.0 |
| 2012-11-23 06:06:00 | AAPL | Stock | 20.1625 | 20.1625 | 20.1429 | 20.1429 | 11200.0 |
| 2012-11-23 06:10:00 | AAPL | Stock | 20.1786 | 20.1786 | 20.1786 | 20.1786 | 2800.0 |
| 2012-11-23 06:12:00 | AAPL | Stock | 20.175 | 20.175 | 20.175 | 20.175 | 2800.0 |
| 2012-11-23 06:13:00 | AAPL | Stock | 20.175 | 20.175 | 20.1732 | 20.1732 | 11200.0 |
| 2012-11-23 06:14:00 | AAPL | Stock | 20.175 | 20.175 | 20.1732 | 20.1732 | 8400.0 |
| 2012-11-23 06:15:00 | AAPL | Stock | 20.175 | 20.175 | 20.175 | 20.175 | 11200.0 |
| 2012-11-23 06:17:00 | AAPL | Stock | 20.1786 | 20.1786 | 20.1786 | 20.1786 | 8400.0 |
| 2012-11-23 06:18:00 | AAPL | Stock | 20.1786 | 20.1786 | 20.1786 | 20.1786 | 14000.0 |
| 2012-11-23 06:30:00 | AAPL | Stock | 20.1793 | 20.1793 | 20.1793 | 20.1793 | 2800.0 |
| 2012-11-23 06:31:00 | AAPL | Stock | 20.2107 | 20.2132 | 20.2107 | 20.2132 | 5600.0 |
| 2012-11-23 06:33:00 | AAPL | Stock | 20.2446 | 20.2479 | 20.2446 | 20.2479 | 24780.0 |
| 2012-11-23 07:03:00 | AAPL | Stock | 20.1875 | 20.1875 | 20.1875 | 20.1875 | 5600.0 |
| 2012-11-23 07:05:00 | AAPL | Stock | 20.1875 | 20.1875 | 20.1875 | 20.1875 | 2800.0 |
| 2012-11-23 07:06:00 | AAPL | Stock | 20.1929 | 20.1929 | 20.1786 | 20.1786 | 38248.0 |
| 2012-11-23 07:07:00 | AAPL | Stock | 20.1786 | 20.1839 | 20.1786 | 20.1786 | 25144.0 |
| 2012-11-23 07:08:00 | AAPL | Stock | 20.1507 | 20.1507 | 20.1507 | 20.1507 | 2800.0 |
| 2012-11-23 07:09:00 | AAPL | Stock | 20.1646 | 20.1646 | 20.1418 | 20.1429 | 54656.0 |
| 2012-11-23 07:11:00 | AAPL | Stock | 20.1321 | 20.1321 | 20.1239 | 20.125 | 31136.0 |
| 2012-11-23 07:12:00 | AAPL | Stock | 20.125 | 20.1407 | 20.125 | 20.1407 | 5600.0 |
| 2012-11-23 07:14:00 | AAPL | Stock | 20.1286 | 20.1286 | 20.1286 | 20.1286 | 11200.0 |
| 2012-11-23 07:16:00 | AAPL | Stock | 20.1268 | 20.1268 | 20.1268 | 20.1268 | 2800.0 |
| 2012-11-23 07:17:00 | AAPL | Stock | 20.1268 | 20.1268 | 20.1268 | 20.1268 | 5600.0 |
| 2012-11-23 07:19:00 | AAPL | Stock | 20.1429 | 20.1429 | 20.1429 | 20.1429 | 3836.0 |
| 2012-11-23 07:20:00 | AAPL | Stock | 20.1429 | 20.1429 | 20.1429 | 20.1429 | 5600.0 |
| 2012-11-23 07:24:00 | AAPL | Stock | 20.1461 | 20.1461 | 20.1461 | 20.1461 | 2800.0 |
| 2012-11-23 07:27:00 | AAPL | Stock | 20.1604 | 20.1604 | 20.1604 | 20.1604 | 2800.0 |
| 2012-11-23 07:28:00 | AAPL | Stock | 20.1607 | 20.1607 | 20.1607 | 20.1607 | 2800.0 |
| 2012-11-23 07:37:00 | AAPL | Stock | 20.1607 | 20.1607 | 20.1446 | 20.1446 | 11200.0 |
| 2012-11-23 07:39:00 | AAPL | Stock | 20.1661 | 20.1661 | 20.1661 | 20.1661 | 2800.0 |
| 2012-11-23 07:40:00 | AAPL | Stock | 20.1643 | 20.1643 | 20.1643 | 20.1643 | 2800.0 |
| 2012-11-23 07:41:00 | AAPL | Stock | 20.1679 | 20.1679 | 20.1679 | 20.1679 | 2800.0 |
| 2012-11-23 07:42:00 | AAPL | Stock | 20.1707 | 20.1707 | 20.1643 | 20.1646 | 8400.0 |
| 2012-11-23 07:45:00 | AAPL | Stock | 20.1643 | 20.1643 | 20.1643 | 20.1643 | 2800.0 |
| 2012-11-23 07:46:00 | AAPL | Stock | 20.1521 | 20.1521 | 20.1518 | 20.1518 | 16800.0 |
| 2012-11-23 07:49:00 | AAPL | Stock | 20.1518 | 20.1518 | 20.1518 | 20.1518 | 2800.0 |
| 2012-11-23 07:52:00 | AAPL | Stock | 20.1518 | 20.1518 | 20.1518 | 20.1518 | 8260.0 |
| 2012-11-23 07:55:00 | AAPL | Stock | 20.1493 | 20.1493 | 20.1489 | 20.1489 | 11816.0 |
| 2012-11-23 07:56:00 | AAPL | Stock | 20.1489 | 20.1489 | 20.1489 | 20.1489 | 14000.0 |
| 2012-11-23 08:00:00 | AAPL | Stock | 20.16 | 20.1607 | 20.1504 | 20.1607 | 46564.0 |
| 2012-11-23 08:01:00 | AAPL | Stock | 20.1643 | 20.1711 | 20.1607 | 20.1696 | 56000.0 |
| 2012-11-23 08:02:00 | AAPL | Stock | 20.1707 | 20.1739 | 20.1707 | 20.1739 | 17220.0 |
| 2012-11-23 08:03:00 | AAPL | Stock | 20.1739 | 20.1775 | 20.1707 | 20.1707 | 22400.0 |
| 2012-11-23 08:04:00 | AAPL | Stock | 20.1679 | 20.1771 | 20.1607 | 20.1607 | 25200.0 |
| 2012-11-23 08:05:00 | AAPL | Stock | 20.1546 | 20.1546 | 20.1536 | 20.1546 | 8512.0 |
| 2012-11-23 08:06:00 | AAPL | Stock | 20.155 | 20.155 | 20.1493 | 20.1536 | 35000.0 |
| 2012-11-23 08:07:00 | AAPL | Stock | 20.1604 | 20.1604 | 20.1536 | 20.1539 | 47348.0 |
| 2012-11-23 08:08:00 | AAPL | Stock | 20.1596 | 20.1607 | 20.1589 | 20.1589 | 14000.0 |
> showing 50 of 477,180 rows — these rows as CSV