PREVIEW / stock_1min / 2010-06-01
file: by_date/stock_1min/2010/2010-06-01.parquet size: 13.5 MB rows: 1,032,541 symbols: 2,794
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-06-01 04:07:00 | AAPL | Stock | 9.1714 | 9.1771 | 9.1714 | 9.1771 | 16800.0 |
| 2010-06-01 04:08:00 | AAPL | Stock | 9.1743 | 9.1743 | 9.1743 | 9.1743 | 2800.0 |
| 2010-06-01 04:14:00 | AAPL | Stock | 9.1743 | 9.1743 | 9.1714 | 9.1714 | 16800.0 |
| 2010-06-01 04:15:00 | AAPL | Stock | 9.1625 | 9.1625 | 9.1625 | 9.1625 | 2800.0 |
| 2010-06-01 04:16:00 | AAPL | Stock | 9.1661 | 9.1661 | 9.1661 | 9.1661 | 25200.0 |
| 2010-06-01 04:17:00 | AAPL | Stock | 9.1661 | 9.1661 | 9.1661 | 9.1661 | 30800.0 |
| 2010-06-01 04:29:00 | AAPL | Stock | 9.1679 | 9.1679 | 9.1679 | 9.1679 | 14000.0 |
| 2010-06-01 04:33:00 | AAPL | Stock | 9.1679 | 9.1679 | 9.1679 | 9.1679 | 11200.0 |
| 2010-06-01 04:34:00 | AAPL | Stock | 9.1679 | 9.1679 | 9.1679 | 9.1679 | 14000.0 |
| 2010-06-01 04:36:00 | AAPL | Stock | 9.1657 | 9.1739 | 9.1657 | 9.1739 | 16800.0 |
| 2010-06-01 04:39:00 | AAPL | Stock | 9.1582 | 9.1582 | 9.1582 | 9.1582 | 19600.0 |
| 2010-06-01 04:41:00 | AAPL | Stock | 9.1575 | 9.1575 | 9.1575 | 9.1575 | 8400.0 |
| 2010-06-01 04:44:00 | AAPL | Stock | 9.1214 | 9.1571 | 9.1214 | 9.1571 | 16520.0 |
| 2010-06-01 05:05:00 | AAPL | Stock | 9.1211 | 9.1211 | 9.1211 | 9.1211 | 2940.0 |
| 2010-06-01 05:08:00 | AAPL | Stock | 9.1214 | 9.1214 | 9.1214 | 9.1214 | 4788.0 |
| 2010-06-01 05:38:00 | AAPL | Stock | 9.1304 | 9.1304 | 9.1304 | 9.1304 | 2800.0 |
| 2010-06-01 05:59:00 | AAPL | Stock | 9.125 | 9.125 | 9.125 | 9.125 | 8400.0 |
| 2010-06-01 06:10:00 | AAPL | Stock | 9.1321 | 9.1429 | 9.1321 | 9.1429 | 32676.0 |
| 2010-06-01 06:14:00 | AAPL | Stock | 9.1429 | 9.1429 | 9.1429 | 9.1429 | 5600.0 |
| 2010-06-01 06:31:00 | AAPL | Stock | 9.175 | 9.175 | 9.175 | 9.175 | 6048.0 |
| 2010-06-01 06:45:00 | AAPL | Stock | 9.1464 | 9.1464 | 9.1464 | 9.1464 | 25900.0 |
| 2010-06-01 07:01:00 | AAPL | Stock | 9.175 | 9.175 | 9.175 | 9.175 | 5600.0 |
| 2010-06-01 07:03:00 | AAPL | Stock | 9.175 | 9.1857 | 9.175 | 9.1857 | 31248.0 |
| 2010-06-01 07:04:00 | AAPL | Stock | 9.1857 | 9.1857 | 9.185 | 9.1854 | 70000.0 |
| 2010-06-01 07:05:00 | AAPL | Stock | 9.1854 | 9.1925 | 9.1743 | 9.1743 | 44940.0 |
| 2010-06-01 07:07:00 | AAPL | Stock | 9.1875 | 9.1875 | 9.1786 | 9.1786 | 157444.0 |
| 2010-06-01 07:09:00 | AAPL | Stock | 9.1825 | 9.1875 | 9.1825 | 9.1829 | 139160.0 |
| 2010-06-01 07:10:00 | AAPL | Stock | 9.1986 | 9.1986 | 9.1986 | 9.1986 | 5600.0 |
| 2010-06-01 07:11:00 | AAPL | Stock | 9.1875 | 9.1875 | 9.1875 | 9.1875 | 14000.0 |
| 2010-06-01 07:13:00 | AAPL | Stock | 9.1979 | 9.1979 | 9.1857 | 9.1857 | 44660.0 |
| 2010-06-01 07:16:00 | AAPL | Stock | 9.1961 | 9.1964 | 9.1854 | 9.1964 | 53200.0 |
| 2010-06-01 07:17:00 | AAPL | Stock | 9.1964 | 9.1986 | 9.1954 | 9.1968 | 64400.0 |
| 2010-06-01 07:24:00 | AAPL | Stock | 9.1875 | 9.1875 | 9.1875 | 9.1875 | 2800.0 |
| 2010-06-01 07:25:00 | AAPL | Stock | 9.1964 | 9.1964 | 9.1964 | 9.1964 | 2800.0 |
| 2010-06-01 07:27:00 | AAPL | Stock | 9.1964 | 9.1964 | 9.1964 | 9.1964 | 28000.0 |
| 2010-06-01 07:30:00 | AAPL | Stock | 9.1879 | 9.1879 | 9.1879 | 9.1879 | 5600.0 |
| 2010-06-01 07:32:00 | AAPL | Stock | 9.1982 | 9.1982 | 9.1982 | 9.1982 | 2800.0 |
| 2010-06-01 07:33:00 | AAPL | Stock | 9.1893 | 9.1929 | 9.1893 | 9.1929 | 14000.0 |
| 2010-06-01 07:34:00 | AAPL | Stock | 9.1964 | 9.2061 | 9.1964 | 9.2061 | 5600.0 |
| 2010-06-01 07:35:00 | AAPL | Stock | 9.1964 | 9.2161 | 9.1961 | 9.2161 | 53340.0 |
| 2010-06-01 07:36:00 | AAPL | Stock | 9.2296 | 9.2357 | 9.2232 | 9.2329 | 104020.0 |
| 2010-06-01 07:37:00 | AAPL | Stock | 9.2318 | 9.2357 | 9.2318 | 9.2321 | 42140.0 |
| 2010-06-01 07:38:00 | AAPL | Stock | 9.2393 | 9.2393 | 9.2393 | 9.2393 | 2800.0 |
| 2010-06-01 07:39:00 | AAPL | Stock | 9.2286 | 9.2286 | 9.225 | 9.225 | 26600.0 |
| 2010-06-01 07:42:00 | AAPL | Stock | 9.2318 | 9.2318 | 9.2318 | 9.2318 | 2800.0 |
| 2010-06-01 07:44:00 | AAPL | Stock | 9.2232 | 9.2236 | 9.2036 | 9.2232 | 63336.0 |
| 2010-06-01 07:45:00 | AAPL | Stock | 9.2232 | 9.2236 | 9.2232 | 9.2232 | 26768.0 |
| 2010-06-01 07:48:00 | AAPL | Stock | 9.225 | 9.225 | 9.225 | 9.225 | 2800.0 |
| 2010-06-01 07:49:00 | AAPL | Stock | 9.2143 | 9.2143 | 9.2143 | 9.2143 | 14000.0 |
| 2010-06-01 07:50:00 | AAPL | Stock | 9.2143 | 9.2143 | 9.2143 | 9.2143 | 19320.0 |
> showing 50 of 1,032,541 rows — these rows as CSV