PREVIEW / stock_1min / 2011-03-22
file: by_date/stock_1min/2011/2011-03-22.parquet size: 12.7 MB rows: 951,045 symbols: 2,834
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 |
|---|---|---|---|---|---|---|---|
| 2011-03-22 04:02:00 | AAPL | Stock | 12.1429 | 12.1429 | 12.1429 | 12.1429 | 2800.0 |
| 2011-03-22 04:12:00 | AAPL | Stock | 12.15 | 12.15 | 12.15 | 12.15 | 2800.0 |
| 2011-03-22 04:13:00 | AAPL | Stock | 12.15 | 12.15 | 12.15 | 12.15 | 11200.0 |
| 2011-03-22 04:14:00 | AAPL | Stock | 12.1536 | 12.1536 | 12.1536 | 12.1536 | 2800.0 |
| 2011-03-22 04:26:00 | AAPL | Stock | 12.15 | 12.15 | 12.15 | 12.15 | 2800.0 |
| 2011-03-22 04:31:00 | AAPL | Stock | 12.15 | 12.15 | 12.15 | 12.15 | 11200.0 |
| 2011-03-22 04:34:00 | AAPL | Stock | 12.1607 | 12.1607 | 12.1607 | 12.1607 | 5600.0 |
| 2011-03-22 04:35:00 | AAPL | Stock | 12.1607 | 12.1607 | 12.1607 | 12.1607 | 8400.0 |
| 2011-03-22 04:36:00 | AAPL | Stock | 12.1607 | 12.1607 | 12.1607 | 12.1607 | 2800.0 |
| 2011-03-22 04:39:00 | AAPL | Stock | 12.1607 | 12.1607 | 12.1607 | 12.1607 | 2800.0 |
| 2011-03-22 04:47:00 | AAPL | Stock | 12.1607 | 12.1675 | 12.1607 | 12.1675 | 8400.0 |
| 2011-03-22 06:15:00 | AAPL | Stock | 12.1818 | 12.1818 | 12.1818 | 12.1818 | 2800.0 |
| 2011-03-22 06:21:00 | AAPL | Stock | 12.1786 | 12.1786 | 12.1786 | 12.1786 | 14000.0 |
| 2011-03-22 06:32:00 | AAPL | Stock | 12.1768 | 12.1786 | 12.1768 | 12.1786 | 5600.0 |
| 2011-03-22 06:53:00 | AAPL | Stock | 12.1607 | 12.1607 | 12.1607 | 12.1607 | 2800.0 |
| 2011-03-22 06:56:00 | AAPL | Stock | 12.1607 | 12.1607 | 12.1607 | 12.1607 | 8820.0 |
| 2011-03-22 07:00:00 | AAPL | Stock | 12.1507 | 12.1507 | 12.1507 | 12.1507 | 2800.0 |
| 2011-03-22 07:01:00 | AAPL | Stock | 12.1493 | 12.1493 | 12.1493 | 12.1493 | 5600.0 |
| 2011-03-22 07:02:00 | AAPL | Stock | 12.1429 | 12.1429 | 12.1429 | 12.1429 | 7980.0 |
| 2011-03-22 07:05:00 | AAPL | Stock | 12.1429 | 12.1679 | 12.1429 | 12.1679 | 42000.0 |
| 2011-03-22 07:06:00 | AAPL | Stock | 12.1736 | 12.1736 | 12.1736 | 12.1736 | 2800.0 |
| 2011-03-22 07:07:00 | AAPL | Stock | 12.1736 | 12.1736 | 12.1736 | 12.1736 | 11200.0 |
| 2011-03-22 07:08:00 | AAPL | Stock | 12.1732 | 12.1732 | 12.1732 | 12.1732 | 2800.0 |
| 2011-03-22 07:09:00 | AAPL | Stock | 12.1732 | 12.1732 | 12.1732 | 12.1732 | 8400.0 |
| 2011-03-22 07:11:00 | AAPL | Stock | 12.1732 | 12.1732 | 12.1732 | 12.1732 | 14000.0 |
| 2011-03-22 07:14:00 | AAPL | Stock | 12.1786 | 12.1786 | 12.1786 | 12.1786 | 8400.0 |
| 2011-03-22 07:16:00 | AAPL | Stock | 12.1821 | 12.1857 | 12.1821 | 12.1857 | 6720.0 |
| 2011-03-22 07:20:00 | AAPL | Stock | 12.1893 | 12.1893 | 12.1893 | 12.1893 | 19600.0 |
| 2011-03-22 07:21:00 | AAPL | Stock | 12.185 | 12.1889 | 12.185 | 12.1889 | 5600.0 |
| 2011-03-22 07:22:00 | AAPL | Stock | 12.1875 | 12.1875 | 12.1854 | 12.1857 | 30800.0 |
| 2011-03-22 07:25:00 | AAPL | Stock | 12.1818 | 12.1818 | 12.1818 | 12.1818 | 2800.0 |
| 2011-03-22 07:27:00 | AAPL | Stock | 12.18 | 12.18 | 12.18 | 12.18 | 5600.0 |
| 2011-03-22 07:28:00 | AAPL | Stock | 12.1714 | 12.1714 | 12.1714 | 12.1714 | 2800.0 |
| 2011-03-22 07:29:00 | AAPL | Stock | 12.1721 | 12.1721 | 12.1714 | 12.1714 | 24080.0 |
| 2011-03-22 07:30:00 | AAPL | Stock | 12.1696 | 12.1696 | 12.1696 | 12.1696 | 5600.0 |
| 2011-03-22 07:37:00 | AAPL | Stock | 12.1714 | 12.1714 | 12.1714 | 12.1714 | 2800.0 |
| 2011-03-22 07:38:00 | AAPL | Stock | 12.1746 | 12.1746 | 12.1746 | 12.1746 | 2800.0 |
| 2011-03-22 07:39:00 | AAPL | Stock | 12.1714 | 12.1714 | 12.1714 | 12.1714 | 14000.0 |
| 2011-03-22 07:40:00 | AAPL | Stock | 12.1818 | 12.1857 | 12.1818 | 12.1857 | 30800.0 |
| 2011-03-22 07:41:00 | AAPL | Stock | 12.1857 | 12.2007 | 12.1857 | 12.1964 | 26208.0 |
| 2011-03-22 07:42:00 | AAPL | Stock | 12.1968 | 12.1968 | 12.1968 | 12.1968 | 2800.0 |
| 2011-03-22 07:43:00 | AAPL | Stock | 12.1936 | 12.1936 | 12.1936 | 12.1936 | 5600.0 |
| 2011-03-22 07:44:00 | AAPL | Stock | 12.1936 | 12.1939 | 12.1936 | 12.1939 | 5600.0 |
| 2011-03-22 07:45:00 | AAPL | Stock | 12.1936 | 12.1968 | 12.1929 | 12.1929 | 11200.0 |
| 2011-03-22 07:46:00 | AAPL | Stock | 12.1936 | 12.1968 | 12.1821 | 12.1821 | 50400.0 |
| 2011-03-22 07:47:00 | AAPL | Stock | 12.1821 | 12.1821 | 12.1821 | 12.1821 | 22400.0 |
| 2011-03-22 07:48:00 | AAPL | Stock | 12.1889 | 12.1889 | 12.1889 | 12.1889 | 2800.0 |
| 2011-03-22 07:52:00 | AAPL | Stock | 12.1714 | 12.1714 | 12.1714 | 12.1714 | 13720.0 |
| 2011-03-22 07:56:00 | AAPL | Stock | 12.1714 | 12.1714 | 12.1714 | 12.1714 | 5600.0 |
| 2011-03-22 07:58:00 | AAPL | Stock | 12.1646 | 12.1646 | 12.1643 | 12.1643 | 5600.0 |
> showing 50 of 951,045 rows — these rows as CSV