PREVIEW / stock_1min / 2007-01-26
file: by_date/stock_1min/2007/2007-01-26.parquet size: 8.8 MB rows: 721,622 symbols: 2,031
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 |
|---|---|---|---|---|---|---|---|
| 2007-01-26 07:42:00 | AAPL | Stock | 3.0879 | 3.0879 | 3.0879 | 3.0879 | 8400.0 |
| 2007-01-26 07:43:00 | AAPL | Stock | 3.0896 | 3.0896 | 3.0896 | 3.0896 | 2800.0 |
| 2007-01-26 07:53:00 | AAPL | Stock | 3.095 | 3.095 | 3.095 | 3.095 | 11200.0 |
| 2007-01-26 07:55:00 | AAPL | Stock | 3.095 | 3.095 | 3.095 | 3.095 | 5600.0 |
| 2007-01-26 07:56:00 | AAPL | Stock | 3.0964 | 3.0964 | 3.0964 | 3.0964 | 28000.0 |
| 2007-01-26 07:58:00 | AAPL | Stock | 3.0989 | 3.0989 | 3.0989 | 3.0989 | 5600.0 |
| 2007-01-26 07:59:00 | AAPL | Stock | 3.0982 | 3.0989 | 3.0982 | 3.0989 | 16800.0 |
| 2007-01-26 08:00:00 | AAPL | Stock | 3.1004 | 3.1018 | 3.0993 | 3.1018 | 134036.0 |
| 2007-01-26 08:01:00 | AAPL | Stock | 3.1 | 3.1 | 3.0993 | 3.1 | 50400.0 |
| 2007-01-26 08:02:00 | AAPL | Stock | 3.1 | 3.1007 | 3.0993 | 3.0993 | 78400.0 |
| 2007-01-26 08:03:00 | AAPL | Stock | 3.0993 | 3.1 | 3.095 | 3.095 | 163100.0 |
| 2007-01-26 08:04:00 | AAPL | Stock | 3.0968 | 3.0996 | 3.0936 | 3.0936 | 13104.0 |
| 2007-01-26 08:05:00 | AAPL | Stock | 3.095 | 3.0954 | 3.095 | 3.0954 | 5600.0 |
| 2007-01-26 08:06:00 | AAPL | Stock | 3.0964 | 3.0979 | 3.0954 | 3.0954 | 19600.0 |
| 2007-01-26 08:07:00 | AAPL | Stock | 3.0957 | 3.0968 | 3.0957 | 3.0968 | 19600.0 |
| 2007-01-26 08:08:00 | AAPL | Stock | 3.0975 | 3.0975 | 3.0964 | 3.0968 | 25200.0 |
| 2007-01-26 08:09:00 | AAPL | Stock | 3.0968 | 3.0968 | 3.0968 | 3.0968 | 25200.0 |
| 2007-01-26 08:11:00 | AAPL | Stock | 3.0975 | 3.0979 | 3.0964 | 3.0964 | 105700.0 |
| 2007-01-26 08:12:00 | AAPL | Stock | 3.0964 | 3.0964 | 3.0961 | 3.0961 | 42000.0 |
| 2007-01-26 08:13:00 | AAPL | Stock | 3.0954 | 3.0954 | 3.0943 | 3.0943 | 68460.0 |
| 2007-01-26 08:14:00 | AAPL | Stock | 3.0943 | 3.0943 | 3.0936 | 3.0936 | 23100.0 |
| 2007-01-26 08:15:00 | AAPL | Stock | 3.0932 | 3.0936 | 3.0932 | 3.0936 | 12964.0 |
| 2007-01-26 08:16:00 | AAPL | Stock | 3.0932 | 3.0932 | 3.0932 | 3.0932 | 13636.0 |
| 2007-01-26 08:17:00 | AAPL | Stock | 3.0929 | 3.0946 | 3.0929 | 3.0936 | 19600.0 |
| 2007-01-26 08:19:00 | AAPL | Stock | 3.0925 | 3.0929 | 3.0921 | 3.0929 | 19208.0 |
| 2007-01-26 08:20:00 | AAPL | Stock | 3.0929 | 3.0936 | 3.0929 | 3.0936 | 21196.0 |
| 2007-01-26 08:21:00 | AAPL | Stock | 3.0929 | 3.0929 | 3.0929 | 3.0929 | 28000.0 |
| 2007-01-26 08:24:00 | AAPL | Stock | 3.0964 | 3.0964 | 3.0964 | 3.0964 | 14000.0 |
| 2007-01-26 08:25:00 | AAPL | Stock | 3.0961 | 3.0964 | 3.0961 | 3.0964 | 6804.0 |
| 2007-01-26 08:26:00 | AAPL | Stock | 3.095 | 3.0971 | 3.095 | 3.0971 | 28700.0 |
| 2007-01-26 08:27:00 | AAPL | Stock | 3.0971 | 3.0971 | 3.095 | 3.095 | 11928.0 |
| 2007-01-26 08:29:00 | AAPL | Stock | 3.0979 | 3.0979 | 3.0979 | 3.0979 | 28000.0 |
| 2007-01-26 08:30:00 | AAPL | Stock | 3.0957 | 3.0979 | 3.0957 | 3.0979 | 47600.0 |
| 2007-01-26 08:31:00 | AAPL | Stock | 3.0971 | 3.0982 | 3.0957 | 3.0957 | 50400.0 |
| 2007-01-26 08:32:00 | AAPL | Stock | 3.0957 | 3.0957 | 3.0939 | 3.0957 | 44800.0 |
| 2007-01-26 08:33:00 | AAPL | Stock | 3.0961 | 3.0961 | 3.0961 | 3.0961 | 2800.0 |
| 2007-01-26 08:34:00 | AAPL | Stock | 3.0975 | 3.0979 | 3.0975 | 3.0975 | 65436.0 |
| 2007-01-26 08:35:00 | AAPL | Stock | 3.0964 | 3.0964 | 3.0964 | 3.0964 | 39200.0 |
| 2007-01-26 08:36:00 | AAPL | Stock | 3.0961 | 3.0961 | 3.0957 | 3.0957 | 33600.0 |
| 2007-01-26 08:37:00 | AAPL | Stock | 3.0961 | 3.0961 | 3.0961 | 3.0961 | 113400.0 |
| 2007-01-26 08:38:00 | AAPL | Stock | 3.0957 | 3.0957 | 3.0957 | 3.0957 | 8400.0 |
| 2007-01-26 08:39:00 | AAPL | Stock | 3.0957 | 3.0961 | 3.0957 | 3.0961 | 16800.0 |
| 2007-01-26 08:40:00 | AAPL | Stock | 3.0964 | 3.0964 | 3.0964 | 3.0964 | 22400.0 |
| 2007-01-26 08:41:00 | AAPL | Stock | 3.0964 | 3.0968 | 3.0964 | 3.0968 | 60480.0 |
| 2007-01-26 08:43:00 | AAPL | Stock | 3.0968 | 3.0982 | 3.0968 | 3.0971 | 95760.0 |
| 2007-01-26 08:44:00 | AAPL | Stock | 3.0971 | 3.0971 | 3.0971 | 3.0971 | 14000.0 |
| 2007-01-26 08:46:00 | AAPL | Stock | 3.0982 | 3.0982 | 3.0979 | 3.0979 | 11200.0 |
| 2007-01-26 08:47:00 | AAPL | Stock | 3.0993 | 3.1 | 3.0989 | 3.1 | 169036.0 |
| 2007-01-26 08:48:00 | AAPL | Stock | 3.1 | 3.1004 | 3.1 | 3.1004 | 114800.0 |
| 2007-01-26 08:49:00 | AAPL | Stock | 3.1004 | 3.1014 | 3.0996 | 3.1014 | 95620.0 |
> showing 50 of 721,622 rows — these rows as CSV