PREVIEW / stock_1min / 2008-07-28
file: by_date/stock_1min/2008/2008-07-28.parquet size: 12.3 MB rows: 989,537 symbols: 2,683
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-28 07:12:00 | AAPL | Stock | 5.8036 | 5.8036 | 5.8036 | 5.8036 | 2800.0 |
| 2008-07-28 07:30:00 | AAPL | Stock | 5.7982 | 5.7982 | 5.7982 | 5.7982 | 2800.0 |
| 2008-07-28 07:31:00 | AAPL | Stock | 5.8018 | 5.8018 | 5.8018 | 5.8018 | 2800.0 |
| 2008-07-28 07:32:00 | AAPL | Stock | 5.8018 | 5.8018 | 5.8018 | 5.8018 | 2800.0 |
| 2008-07-28 07:33:00 | AAPL | Stock | 5.8139 | 5.8214 | 5.7982 | 5.7982 | 50400.0 |
| 2008-07-28 07:34:00 | AAPL | Stock | 5.8 | 5.8132 | 5.8 | 5.8132 | 25200.0 |
| 2008-07-28 07:35:00 | AAPL | Stock | 5.8232 | 5.8232 | 5.8232 | 5.8232 | 25760.0 |
| 2008-07-28 07:38:00 | AAPL | Stock | 5.8232 | 5.8232 | 5.8232 | 5.8232 | 39480.0 |
| 2008-07-28 07:39:00 | AAPL | Stock | 5.8232 | 5.8232 | 5.8196 | 5.8196 | 8120.0 |
| 2008-07-28 07:40:00 | AAPL | Stock | 5.8196 | 5.8393 | 5.8196 | 5.8393 | 11200.0 |
| 2008-07-28 07:44:00 | AAPL | Stock | 5.8232 | 5.8232 | 5.8214 | 5.8214 | 19600.0 |
| 2008-07-28 07:45:00 | AAPL | Stock | 5.8232 | 5.8232 | 5.8232 | 5.8232 | 2800.0 |
| 2008-07-28 07:49:00 | AAPL | Stock | 5.8232 | 5.8232 | 5.8232 | 5.8232 | 2800.0 |
| 2008-07-28 07:53:00 | AAPL | Stock | 5.8232 | 5.8232 | 5.8232 | 5.8232 | 2800.0 |
| 2008-07-28 07:54:00 | AAPL | Stock | 5.8232 | 5.8232 | 5.8232 | 5.8232 | 2800.0 |
| 2008-07-28 07:57:00 | AAPL | Stock | 5.8232 | 5.8232 | 5.8232 | 5.8232 | 8120.0 |
| 2008-07-28 08:00:00 | AAPL | Stock | 5.8232 | 5.8261 | 5.8146 | 5.8261 | 57400.0 |
| 2008-07-28 08:01:00 | AAPL | Stock | 5.8268 | 5.8304 | 5.8261 | 5.8304 | 86800.0 |
| 2008-07-28 08:02:00 | AAPL | Stock | 5.8289 | 5.8289 | 5.825 | 5.825 | 44800.0 |
| 2008-07-28 08:03:00 | AAPL | Stock | 5.8225 | 5.8225 | 5.8214 | 5.8214 | 10416.0 |
| 2008-07-28 08:08:00 | AAPL | Stock | 5.8175 | 5.8214 | 5.8171 | 5.8179 | 113540.0 |
| 2008-07-28 08:10:00 | AAPL | Stock | 5.8129 | 5.8129 | 5.8125 | 5.8125 | 18788.0 |
| 2008-07-28 08:11:00 | AAPL | Stock | 5.8125 | 5.8125 | 5.8125 | 5.8125 | 14000.0 |
| 2008-07-28 08:12:00 | AAPL | Stock | 5.8107 | 5.8107 | 5.8036 | 5.8036 | 31220.0 |
| 2008-07-28 08:13:00 | AAPL | Stock | 5.8021 | 5.8079 | 5.8021 | 5.8079 | 29400.0 |
| 2008-07-28 08:14:00 | AAPL | Stock | 5.8071 | 5.8071 | 5.8071 | 5.8071 | 17640.0 |
| 2008-07-28 08:15:00 | AAPL | Stock | 5.8046 | 5.8046 | 5.8032 | 5.8032 | 19600.0 |
| 2008-07-28 08:16:00 | AAPL | Stock | 5.8032 | 5.8043 | 5.8032 | 5.8036 | 11200.0 |
| 2008-07-28 08:17:00 | AAPL | Stock | 5.8043 | 5.8043 | 5.8036 | 5.8036 | 18200.0 |
| 2008-07-28 08:18:00 | AAPL | Stock | 5.8068 | 5.8068 | 5.8068 | 5.8068 | 10472.0 |
| 2008-07-28 08:19:00 | AAPL | Stock | 5.8071 | 5.8071 | 5.8071 | 5.8071 | 2800.0 |
| 2008-07-28 08:20:00 | AAPL | Stock | 5.8068 | 5.8121 | 5.8068 | 5.8121 | 39200.0 |
| 2008-07-28 08:21:00 | AAPL | Stock | 5.8118 | 5.8125 | 5.8118 | 5.8125 | 54768.0 |
| 2008-07-28 08:22:00 | AAPL | Stock | 5.8125 | 5.8125 | 5.8125 | 5.8125 | 11200.0 |
| 2008-07-28 08:23:00 | AAPL | Stock | 5.8125 | 5.8125 | 5.8118 | 5.8125 | 38808.0 |
| 2008-07-28 08:24:00 | AAPL | Stock | 5.8168 | 5.8168 | 5.815 | 5.8154 | 13160.0 |
| 2008-07-28 08:25:00 | AAPL | Stock | 5.8186 | 5.82 | 5.8186 | 5.82 | 8400.0 |
| 2008-07-28 08:26:00 | AAPL | Stock | 5.8204 | 5.8282 | 5.8204 | 5.8254 | 108584.0 |
| 2008-07-28 08:27:00 | AAPL | Stock | 5.8264 | 5.8268 | 5.8239 | 5.8239 | 67200.0 |
| 2008-07-28 08:28:00 | AAPL | Stock | 5.8239 | 5.825 | 5.8232 | 5.8246 | 74200.0 |
| 2008-07-28 08:29:00 | AAPL | Stock | 5.8232 | 5.8232 | 5.8232 | 5.8232 | 86800.0 |
| 2008-07-28 08:30:00 | AAPL | Stock | 5.8214 | 5.8214 | 5.8175 | 5.8175 | 25200.0 |
| 2008-07-28 08:31:00 | AAPL | Stock | 5.8171 | 5.8171 | 5.8171 | 5.8171 | 2800.0 |
| 2008-07-28 08:32:00 | AAPL | Stock | 5.8182 | 5.8182 | 5.8171 | 5.8182 | 42000.0 |
| 2008-07-28 08:33:00 | AAPL | Stock | 5.8182 | 5.8182 | 5.8182 | 5.8182 | 2800.0 |
| 2008-07-28 08:34:00 | AAPL | Stock | 5.8229 | 5.8232 | 5.8225 | 5.8232 | 49784.0 |
| 2008-07-28 08:35:00 | AAPL | Stock | 5.8232 | 5.8232 | 5.8232 | 5.8232 | 10500.0 |
| 2008-07-28 08:36:00 | AAPL | Stock | 5.8232 | 5.8232 | 5.8182 | 5.8182 | 87500.0 |
| 2008-07-28 08:37:00 | AAPL | Stock | 5.8182 | 5.8196 | 5.8182 | 5.8196 | 11200.0 |
| 2008-07-28 08:38:00 | AAPL | Stock | 5.8182 | 5.8182 | 5.8179 | 5.8179 | 11200.0 |
> showing 50 of 989,537 rows — these rows as CSV