PREVIEW / stock_1min / 2009-12-04
file: by_date/stock_1min/2009/2009-12-04.parquet size: 13.1 MB rows: 981,796 symbols: 2,787
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-04 04:37:00 | AAPL | Stock | 7.0136 | 7.0136 | 7.0136 | 7.0136 | 2800.0 |
| 2009-12-04 07:02:00 | AAPL | Stock | 7.0104 | 7.0104 | 7.0104 | 7.0104 | 17304.0 |
| 2009-12-04 07:26:00 | AAPL | Stock | 7.0096 | 7.0107 | 7.0096 | 7.0107 | 11200.0 |
| 2009-12-04 07:30:00 | AAPL | Stock | 7.0039 | 7.0039 | 7.0039 | 7.0039 | 5600.0 |
| 2009-12-04 07:31:00 | AAPL | Stock | 7.0039 | 7.0039 | 7.0039 | 7.0039 | 2800.0 |
| 2009-12-04 07:35:00 | AAPL | Stock | 7.0039 | 7.0039 | 7.0039 | 7.0039 | 2800.0 |
| 2009-12-04 07:44:00 | AAPL | Stock | 7.0036 | 7.0036 | 7.0032 | 7.0032 | 8400.0 |
| 2009-12-04 07:45:00 | AAPL | Stock | 7.0036 | 7.0036 | 7.0004 | 7.0004 | 70000.0 |
| 2009-12-04 07:46:00 | AAPL | Stock | 7.0011 | 7.0011 | 7.0004 | 7.0004 | 44800.0 |
| 2009-12-04 07:58:00 | AAPL | Stock | 7.0071 | 7.0071 | 7.0071 | 7.0071 | 2800.0 |
| 2009-12-04 07:59:00 | AAPL | Stock | 7.0004 | 7.0004 | 7.0004 | 7.0004 | 2800.0 |
| 2009-12-04 08:00:00 | AAPL | Stock | 7.0039 | 7.0071 | 7.0 | 7.0 | 61376.0 |
| 2009-12-04 08:01:00 | AAPL | Stock | 7.0018 | 7.0036 | 7.0 | 7.0 | 12600.0 |
| 2009-12-04 08:02:00 | AAPL | Stock | 7.0043 | 7.0043 | 6.9996 | 6.9996 | 19600.0 |
| 2009-12-04 08:03:00 | AAPL | Stock | 6.9975 | 7.0 | 6.9975 | 6.9996 | 16212.0 |
| 2009-12-04 08:04:00 | AAPL | Stock | 6.9975 | 6.9975 | 6.9975 | 6.9975 | 5600.0 |
| 2009-12-04 08:05:00 | AAPL | Stock | 6.9982 | 6.9982 | 6.9946 | 6.9968 | 49448.0 |
| 2009-12-04 08:06:00 | AAPL | Stock | 6.9964 | 6.9964 | 6.9929 | 6.9929 | 9800.0 |
| 2009-12-04 08:07:00 | AAPL | Stock | 6.9961 | 6.9961 | 6.9911 | 6.9911 | 16800.0 |
| 2009-12-04 08:08:00 | AAPL | Stock | 6.9929 | 6.9929 | 6.9929 | 6.9929 | 5600.0 |
| 2009-12-04 08:09:00 | AAPL | Stock | 6.9925 | 6.9925 | 6.9925 | 6.9925 | 8400.0 |
| 2009-12-04 08:10:00 | AAPL | Stock | 6.9929 | 6.9929 | 6.9929 | 6.9929 | 2800.0 |
| 2009-12-04 08:11:00 | AAPL | Stock | 6.9914 | 6.9929 | 6.9914 | 6.9914 | 22400.0 |
| 2009-12-04 08:12:00 | AAPL | Stock | 6.9946 | 6.9961 | 6.9945 | 6.9946 | 30800.0 |
| 2009-12-04 08:13:00 | AAPL | Stock | 6.995 | 6.995 | 6.9946 | 6.9946 | 64540.0 |
| 2009-12-04 08:14:00 | AAPL | Stock | 6.9971 | 6.9982 | 6.9971 | 6.9982 | 30800.0 |
| 2009-12-04 08:15:00 | AAPL | Stock | 6.9979 | 7.0004 | 6.9979 | 7.0004 | 39200.0 |
| 2009-12-04 08:16:00 | AAPL | Stock | 7.0036 | 7.0036 | 7.0018 | 7.0018 | 22260.0 |
| 2009-12-04 08:17:00 | AAPL | Stock | 7.0004 | 7.0025 | 7.0004 | 7.0025 | 14700.0 |
| 2009-12-04 08:18:00 | AAPL | Stock | 7.0032 | 7.0032 | 7.0032 | 7.0032 | 2800.0 |
| 2009-12-04 08:19:00 | AAPL | Stock | 7.0014 | 7.0018 | 6.9966 | 6.9966 | 94360.0 |
| 2009-12-04 08:20:00 | AAPL | Stock | 7.0 | 7.0032 | 7.0 | 7.0032 | 72100.0 |
| 2009-12-04 08:21:00 | AAPL | Stock | 7.0032 | 7.0036 | 7.0032 | 7.0036 | 14280.0 |
| 2009-12-04 08:22:00 | AAPL | Stock | 7.0036 | 7.0036 | 7.0018 | 7.0018 | 16800.0 |
| 2009-12-04 08:23:00 | AAPL | Stock | 7.0004 | 7.0011 | 7.0 | 7.0 | 105000.0 |
| 2009-12-04 08:24:00 | AAPL | Stock | 7.0 | 7.0 | 7.0 | 7.0 | 12600.0 |
| 2009-12-04 08:25:00 | AAPL | Stock | 6.9975 | 7.0 | 6.9964 | 7.0 | 102340.0 |
| 2009-12-04 08:26:00 | AAPL | Stock | 7.0 | 7.0 | 7.0 | 7.0 | 15960.0 |
| 2009-12-04 08:27:00 | AAPL | Stock | 6.9996 | 7.0 | 6.9971 | 7.0 | 8400.0 |
| 2009-12-04 08:28:00 | AAPL | Stock | 7.003 | 7.0129 | 7.003 | 7.0129 | 110600.0 |
| 2009-12-04 08:29:00 | AAPL | Stock | 7.0154 | 7.0246 | 7.0118 | 7.0246 | 145040.0 |
| 2009-12-04 08:30:00 | AAPL | Stock | 7.0182 | 7.0907 | 7.0161 | 7.0893 | 873432.0 |
| 2009-12-04 08:31:00 | AAPL | Stock | 7.0886 | 7.1075 | 7.0725 | 7.1054 | 1102248.0 |
| 2009-12-04 08:32:00 | AAPL | Stock | 7.1054 | 7.1054 | 7.0918 | 7.1 | 620480.0 |
| 2009-12-04 08:33:00 | AAPL | Stock | 7.0982 | 7.1161 | 7.0929 | 7.1161 | 1086036.0 |
| 2009-12-04 08:34:00 | AAPL | Stock | 7.1161 | 7.1179 | 7.1071 | 7.1071 | 544880.0 |
| 2009-12-04 08:35:00 | AAPL | Stock | 7.1075 | 7.1161 | 7.1071 | 7.1143 | 267400.0 |
| 2009-12-04 08:36:00 | AAPL | Stock | 7.1143 | 7.12 | 7.1121 | 7.1164 | 479164.0 |
| 2009-12-04 08:37:00 | AAPL | Stock | 7.1179 | 7.125 | 7.1164 | 7.1236 | 399000.0 |
| 2009-12-04 08:38:00 | AAPL | Stock | 7.1236 | 7.1357 | 7.1236 | 7.1314 | 552188.0 |
> showing 50 of 981,796 rows — these rows as CSV