PREVIEW / stock_1min / 2010-02-18
file: by_date/stock_1min/2010/2010-02-18.parquet size: 12.1 MB rows: 922,785 symbols: 2,803
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-02-18 04:46:00 | AAPL | Stock | 7.21 | 7.21 | 7.21 | 7.21 | 5600.0 |
| 2010-02-18 04:50:00 | AAPL | Stock | 7.2143 | 7.2143 | 7.2143 | 7.2143 | 2800.0 |
| 2010-02-18 07:48:00 | AAPL | Stock | 7.2279 | 7.2279 | 7.2279 | 7.2279 | 5600.0 |
| 2010-02-18 08:01:00 | AAPL | Stock | 7.2118 | 7.2214 | 7.2118 | 7.2214 | 16884.0 |
| 2010-02-18 08:04:00 | AAPL | Stock | 7.2214 | 7.2214 | 7.2214 | 7.2214 | 2800.0 |
| 2010-02-18 08:05:00 | AAPL | Stock | 7.2268 | 7.2268 | 7.2268 | 7.2268 | 8400.0 |
| 2010-02-18 08:06:00 | AAPL | Stock | 7.2143 | 7.2143 | 7.2143 | 7.2143 | 2800.0 |
| 2010-02-18 08:08:00 | AAPL | Stock | 7.2179 | 7.2179 | 7.2179 | 7.2179 | 2800.0 |
| 2010-02-18 08:10:00 | AAPL | Stock | 7.2179 | 7.2179 | 7.2179 | 7.2179 | 2800.0 |
| 2010-02-18 08:12:00 | AAPL | Stock | 7.2214 | 7.225 | 7.2214 | 7.225 | 33600.0 |
| 2010-02-18 08:15:00 | AAPL | Stock | 7.22 | 7.22 | 7.22 | 7.22 | 11200.0 |
| 2010-02-18 08:16:00 | AAPL | Stock | 7.2196 | 7.2196 | 7.2196 | 7.2196 | 11480.0 |
| 2010-02-18 08:19:00 | AAPL | Stock | 7.2232 | 7.2232 | 7.2232 | 7.2232 | 14000.0 |
| 2010-02-18 08:21:00 | AAPL | Stock | 7.2214 | 7.2214 | 7.2214 | 7.2214 | 5600.0 |
| 2010-02-18 08:26:00 | AAPL | Stock | 7.2236 | 7.2236 | 7.2236 | 7.2236 | 5600.0 |
| 2010-02-18 08:27:00 | AAPL | Stock | 7.225 | 7.225 | 7.225 | 7.225 | 2800.0 |
| 2010-02-18 08:28:00 | AAPL | Stock | 7.2232 | 7.2232 | 7.2232 | 7.2232 | 19600.0 |
| 2010-02-18 08:29:00 | AAPL | Stock | 7.2232 | 7.2232 | 7.2232 | 7.2232 | 7000.0 |
| 2010-02-18 08:30:00 | AAPL | Stock | 7.2204 | 7.2204 | 7.2068 | 7.2068 | 97832.0 |
| 2010-02-18 08:31:00 | AAPL | Stock | 7.2054 | 7.2054 | 7.2 | 7.2 | 32732.0 |
| 2010-02-18 08:32:00 | AAPL | Stock | 7.2036 | 7.2043 | 7.1982 | 7.1986 | 22204.0 |
| 2010-02-18 08:33:00 | AAPL | Stock | 7.1989 | 7.1989 | 7.1914 | 7.1921 | 237496.0 |
| 2010-02-18 08:34:00 | AAPL | Stock | 7.1893 | 7.1896 | 7.1864 | 7.1896 | 29680.0 |
| 2010-02-18 08:35:00 | AAPL | Stock | 7.1911 | 7.1979 | 7.1889 | 7.1911 | 92484.0 |
| 2010-02-18 08:36:00 | AAPL | Stock | 7.1914 | 7.1918 | 7.1857 | 7.1857 | 114800.0 |
| 2010-02-18 08:37:00 | AAPL | Stock | 7.1821 | 7.1857 | 7.1821 | 7.1825 | 148288.0 |
| 2010-02-18 08:38:00 | AAPL | Stock | 7.1839 | 7.1839 | 7.1811 | 7.1839 | 16100.0 |
| 2010-02-18 08:39:00 | AAPL | Stock | 7.1839 | 7.1839 | 7.175 | 7.175 | 76132.0 |
| 2010-02-18 08:40:00 | AAPL | Stock | 7.1789 | 7.1811 | 7.1768 | 7.1811 | 59500.0 |
| 2010-02-18 08:41:00 | AAPL | Stock | 7.1839 | 7.1839 | 7.1814 | 7.1814 | 73920.0 |
| 2010-02-18 08:42:00 | AAPL | Stock | 7.185 | 7.1857 | 7.1786 | 7.1786 | 57904.0 |
| 2010-02-18 08:43:00 | AAPL | Stock | 7.1786 | 7.1786 | 7.1714 | 7.175 | 400904.0 |
| 2010-02-18 08:44:00 | AAPL | Stock | 7.1714 | 7.175 | 7.1714 | 7.175 | 15008.0 |
| 2010-02-18 08:45:00 | AAPL | Stock | 7.1721 | 7.1721 | 7.1679 | 7.1696 | 139244.0 |
| 2010-02-18 08:46:00 | AAPL | Stock | 7.1746 | 7.175 | 7.1696 | 7.1696 | 132804.0 |
| 2010-02-18 08:47:00 | AAPL | Stock | 7.1693 | 7.1711 | 7.1646 | 7.1693 | 70868.0 |
| 2010-02-18 08:48:00 | AAPL | Stock | 7.17 | 7.1739 | 7.1679 | 7.1714 | 92456.0 |
| 2010-02-18 08:49:00 | AAPL | Stock | 7.1714 | 7.1746 | 7.1714 | 7.1714 | 64400.0 |
| 2010-02-18 08:50:00 | AAPL | Stock | 7.1714 | 7.1732 | 7.1668 | 7.1668 | 196560.0 |
| 2010-02-18 08:51:00 | AAPL | Stock | 7.1696 | 7.1714 | 7.1661 | 7.1714 | 108052.0 |
| 2010-02-18 08:52:00 | AAPL | Stock | 7.1714 | 7.1714 | 7.1654 | 7.1704 | 53200.0 |
| 2010-02-18 08:53:00 | AAPL | Stock | 7.1679 | 7.1707 | 7.1668 | 7.1668 | 16800.0 |
| 2010-02-18 08:54:00 | AAPL | Stock | 7.1668 | 7.1714 | 7.1668 | 7.1714 | 64456.0 |
| 2010-02-18 08:55:00 | AAPL | Stock | 7.1714 | 7.1714 | 7.1714 | 7.1714 | 22400.0 |
| 2010-02-18 08:56:00 | AAPL | Stock | 7.1711 | 7.1714 | 7.17 | 7.1714 | 63980.0 |
| 2010-02-18 08:57:00 | AAPL | Stock | 7.1711 | 7.1714 | 7.1696 | 7.1696 | 60704.0 |
| 2010-02-18 08:58:00 | AAPL | Stock | 7.1714 | 7.1714 | 7.1714 | 7.1714 | 28000.0 |
| 2010-02-18 08:59:00 | AAPL | Stock | 7.1711 | 7.1714 | 7.1696 | 7.1714 | 58128.0 |
| 2010-02-18 09:00:00 | AAPL | Stock | 7.1743 | 7.1786 | 7.1743 | 7.1786 | 130060.0 |
| 2010-02-18 09:01:00 | AAPL | Stock | 7.1786 | 7.1843 | 7.1786 | 7.1839 | 72380.0 |
> showing 50 of 922,785 rows — these rows as CSV