PREVIEW / stock_1min / 2009-08-12
file: by_date/stock_1min/2009/2009-08-12.parquet size: 12.8 MB rows: 975,432 symbols: 2,740
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-08-12 06:12:00 | AAPL | Stock | 5.8093 | 5.8107 | 5.8093 | 5.8107 | 22400.0 |
| 2009-08-12 07:03:00 | AAPL | Stock | 5.8214 | 5.8282 | 5.8214 | 5.8282 | 7000.0 |
| 2009-08-12 08:00:00 | AAPL | Stock | 5.8189 | 5.8214 | 5.8143 | 5.815 | 110880.0 |
| 2009-08-12 08:01:00 | AAPL | Stock | 5.8071 | 5.8154 | 5.8071 | 5.8154 | 11900.0 |
| 2009-08-12 08:04:00 | AAPL | Stock | 5.8143 | 5.8143 | 5.8143 | 5.8143 | 4200.0 |
| 2009-08-12 08:07:00 | AAPL | Stock | 5.8086 | 5.8086 | 5.8075 | 5.8082 | 12488.0 |
| 2009-08-12 08:09:00 | AAPL | Stock | 5.8082 | 5.8082 | 5.8082 | 5.8082 | 2800.0 |
| 2009-08-12 08:11:00 | AAPL | Stock | 5.8082 | 5.8082 | 5.8079 | 5.8079 | 14000.0 |
| 2009-08-12 08:15:00 | AAPL | Stock | 5.8143 | 5.8154 | 5.8143 | 5.8154 | 6384.0 |
| 2009-08-12 08:16:00 | AAPL | Stock | 5.815 | 5.815 | 5.815 | 5.815 | 5600.0 |
| 2009-08-12 08:18:00 | AAPL | Stock | 5.8204 | 5.8204 | 5.8204 | 5.8204 | 2800.0 |
| 2009-08-12 08:23:00 | AAPL | Stock | 5.8204 | 5.8204 | 5.82 | 5.82 | 25564.0 |
| 2009-08-12 08:26:00 | AAPL | Stock | 5.8211 | 5.8214 | 5.8211 | 5.8214 | 5600.0 |
| 2009-08-12 08:28:00 | AAPL | Stock | 5.8214 | 5.8214 | 5.8214 | 5.8214 | 6720.0 |
| 2009-08-12 08:29:00 | AAPL | Stock | 5.8214 | 5.8214 | 5.8214 | 5.8214 | 2800.0 |
| 2009-08-12 08:32:00 | AAPL | Stock | 5.8107 | 5.8125 | 5.8086 | 5.8086 | 67200.0 |
| 2009-08-12 08:33:00 | AAPL | Stock | 5.8089 | 5.8089 | 5.8071 | 5.8071 | 7924.0 |
| 2009-08-12 08:34:00 | AAPL | Stock | 5.8079 | 5.8079 | 5.8079 | 5.8079 | 14000.0 |
| 2009-08-12 08:35:00 | AAPL | Stock | 5.8068 | 5.8068 | 5.8068 | 5.8068 | 8400.0 |
| 2009-08-12 08:36:00 | AAPL | Stock | 5.8071 | 5.8071 | 5.8071 | 5.8071 | 5600.0 |
| 2009-08-12 08:37:00 | AAPL | Stock | 5.8079 | 5.8079 | 5.8036 | 5.8036 | 182644.0 |
| 2009-08-12 08:38:00 | AAPL | Stock | 5.8054 | 5.8054 | 5.8054 | 5.8054 | 7840.0 |
| 2009-08-12 08:39:00 | AAPL | Stock | 5.8054 | 5.8054 | 5.8054 | 5.8054 | 6160.0 |
| 2009-08-12 08:41:00 | AAPL | Stock | 5.8043 | 5.8043 | 5.8043 | 5.8043 | 2800.0 |
| 2009-08-12 08:42:00 | AAPL | Stock | 5.8054 | 5.8054 | 5.8054 | 5.8054 | 5600.0 |
| 2009-08-12 08:43:00 | AAPL | Stock | 5.8054 | 5.8054 | 5.8054 | 5.8054 | 16800.0 |
| 2009-08-12 08:45:00 | AAPL | Stock | 5.8071 | 5.8071 | 5.8071 | 5.8071 | 2800.0 |
| 2009-08-12 08:48:00 | AAPL | Stock | 5.8071 | 5.8071 | 5.8071 | 5.8071 | 2800.0 |
| 2009-08-12 08:49:00 | AAPL | Stock | 5.8061 | 5.8061 | 5.8061 | 5.8061 | 2800.0 |
| 2009-08-12 08:53:00 | AAPL | Stock | 5.805 | 5.8054 | 5.8036 | 5.8036 | 66556.0 |
| 2009-08-12 08:57:00 | AAPL | Stock | 5.8011 | 5.8011 | 5.8011 | 5.8011 | 8400.0 |
| 2009-08-12 08:58:00 | AAPL | Stock | 5.8 | 5.8 | 5.8 | 5.8 | 14000.0 |
| 2009-08-12 09:02:00 | AAPL | Stock | 5.7986 | 5.7986 | 5.7986 | 5.7986 | 2800.0 |
| 2009-08-12 09:03:00 | AAPL | Stock | 5.8014 | 5.8014 | 5.8014 | 5.8014 | 8400.0 |
| 2009-08-12 09:04:00 | AAPL | Stock | 5.8014 | 5.8018 | 5.8014 | 5.8018 | 40320.0 |
| 2009-08-12 09:05:00 | AAPL | Stock | 5.8032 | 5.8032 | 5.8032 | 5.8032 | 27076.0 |
| 2009-08-12 09:06:00 | AAPL | Stock | 5.8125 | 5.8125 | 5.8096 | 5.8096 | 5600.0 |
| 2009-08-12 09:08:00 | AAPL | Stock | 5.8096 | 5.8096 | 5.8096 | 5.8096 | 8400.0 |
| 2009-08-12 09:10:00 | AAPL | Stock | 5.8032 | 5.8032 | 5.8032 | 5.8032 | 5516.0 |
| 2009-08-12 09:21:00 | AAPL | Stock | 5.8121 | 5.8121 | 5.8121 | 5.8121 | 2800.0 |
| 2009-08-12 09:22:00 | AAPL | Stock | 5.8089 | 5.8089 | 5.8086 | 5.8086 | 14840.0 |
| 2009-08-12 09:23:00 | AAPL | Stock | 5.8086 | 5.8086 | 5.8079 | 5.8079 | 19908.0 |
| 2009-08-12 09:26:00 | AAPL | Stock | 5.8061 | 5.8061 | 5.8061 | 5.8061 | 2800.0 |
| 2009-08-12 09:28:00 | AAPL | Stock | 5.8064 | 5.8064 | 5.8039 | 5.8039 | 42000.0 |
| 2009-08-12 09:29:00 | AAPL | Stock | 5.8036 | 5.8036 | 5.8029 | 5.8029 | 6188.0 |
| 2009-08-12 09:30:00 | AAPL | Stock | 5.8054 | 5.8129 | 5.8021 | 5.8107 | 3145800.0 |
| 2009-08-12 09:31:00 | AAPL | Stock | 5.8128 | 5.83 | 5.8107 | 5.825 | 2053464.0 |
| 2009-08-12 09:32:00 | AAPL | Stock | 5.8254 | 5.8304 | 5.8214 | 5.8229 | 2571576.0 |
| 2009-08-12 09:33:00 | AAPL | Stock | 5.8236 | 5.835 | 5.8225 | 5.8331 | 1570856.0 |
| 2009-08-12 09:34:00 | AAPL | Stock | 5.8332 | 5.8386 | 5.8332 | 5.8346 | 1098496.0 |
> showing 50 of 975,432 rows — these rows as CSV