PREVIEW / stock_1min / 2009-12-07
file: by_date/stock_1min/2009/2009-12-07.parquet size: 12.2 MB rows: 925,589 symbols: 2,788
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-07 04:18:00 | AAPL | Stock | 6.8611 | 6.8611 | 6.8596 | 6.8596 | 12936.0 |
| 2009-12-07 07:03:00 | AAPL | Stock | 6.8782 | 6.8786 | 6.8782 | 6.8786 | 5600.0 |
| 2009-12-07 07:07:00 | AAPL | Stock | 6.8893 | 6.8893 | 6.8893 | 6.8893 | 4116.0 |
| 2009-12-07 07:13:00 | AAPL | Stock | 6.8971 | 6.8971 | 6.8971 | 6.8971 | 5600.0 |
| 2009-12-07 07:25:00 | AAPL | Stock | 6.9039 | 6.9039 | 6.9039 | 6.9039 | 14000.0 |
| 2009-12-07 07:28:00 | AAPL | Stock | 6.9039 | 6.9039 | 6.9039 | 6.9039 | 2800.0 |
| 2009-12-07 07:43:00 | AAPL | Stock | 6.9179 | 6.9179 | 6.9179 | 6.9179 | 11200.0 |
| 2009-12-07 07:45:00 | AAPL | Stock | 6.9179 | 6.9179 | 6.9179 | 6.9179 | 5600.0 |
| 2009-12-07 07:48:00 | AAPL | Stock | 6.9379 | 6.9379 | 6.9379 | 6.9379 | 2800.0 |
| 2009-12-07 07:50:00 | AAPL | Stock | 6.9321 | 6.9386 | 6.9286 | 6.9286 | 70588.0 |
| 2009-12-07 07:55:00 | AAPL | Stock | 6.9318 | 6.9318 | 6.9318 | 6.9318 | 2800.0 |
| 2009-12-07 08:00:00 | AAPL | Stock | 6.9454 | 6.9464 | 6.9214 | 6.9214 | 26880.0 |
| 2009-12-07 08:01:00 | AAPL | Stock | 6.9214 | 6.9214 | 6.9079 | 6.9079 | 130340.0 |
| 2009-12-07 08:02:00 | AAPL | Stock | 6.9071 | 6.9071 | 6.9071 | 6.9071 | 12936.0 |
| 2009-12-07 08:04:00 | AAPL | Stock | 6.9107 | 6.9107 | 6.9107 | 6.9107 | 2800.0 |
| 2009-12-07 08:05:00 | AAPL | Stock | 6.9143 | 6.9171 | 6.9143 | 6.9171 | 7000.0 |
| 2009-12-07 08:06:00 | AAPL | Stock | 6.9168 | 6.9168 | 6.9168 | 6.9168 | 5964.0 |
| 2009-12-07 08:08:00 | AAPL | Stock | 6.9114 | 6.9114 | 6.9114 | 6.9114 | 53200.0 |
| 2009-12-07 08:10:00 | AAPL | Stock | 6.9143 | 6.9143 | 6.9143 | 6.9143 | 8680.0 |
| 2009-12-07 08:11:00 | AAPL | Stock | 6.9179 | 6.9179 | 6.9179 | 6.9179 | 2800.0 |
| 2009-12-07 08:13:00 | AAPL | Stock | 6.9214 | 6.9232 | 6.9214 | 6.9232 | 5600.0 |
| 2009-12-07 08:14:00 | AAPL | Stock | 6.9189 | 6.9232 | 6.9186 | 6.9232 | 16800.0 |
| 2009-12-07 08:15:00 | AAPL | Stock | 6.925 | 6.9286 | 6.925 | 6.925 | 25200.0 |
| 2009-12-07 08:17:00 | AAPL | Stock | 6.9268 | 6.9268 | 6.925 | 6.925 | 7700.0 |
| 2009-12-07 08:18:00 | AAPL | Stock | 6.925 | 6.9286 | 6.925 | 6.9286 | 40488.0 |
| 2009-12-07 08:19:00 | AAPL | Stock | 6.9279 | 6.9279 | 6.925 | 6.925 | 25284.0 |
| 2009-12-07 08:20:00 | AAPL | Stock | 6.9214 | 6.9239 | 6.9179 | 6.9239 | 16352.0 |
| 2009-12-07 08:21:00 | AAPL | Stock | 6.9236 | 6.9236 | 6.9182 | 6.9182 | 5600.0 |
| 2009-12-07 08:22:00 | AAPL | Stock | 6.9186 | 6.9193 | 6.918 | 6.918 | 18480.0 |
| 2009-12-07 08:23:00 | AAPL | Stock | 6.9136 | 6.9143 | 6.9125 | 6.9143 | 59528.0 |
| 2009-12-07 08:24:00 | AAPL | Stock | 6.9129 | 6.9129 | 6.9125 | 6.9125 | 5600.0 |
| 2009-12-07 08:26:00 | AAPL | Stock | 6.9143 | 6.9143 | 6.9143 | 6.9143 | 2800.0 |
| 2009-12-07 08:27:00 | AAPL | Stock | 6.9129 | 6.9143 | 6.9107 | 6.9107 | 74116.0 |
| 2009-12-07 08:28:00 | AAPL | Stock | 6.9082 | 6.9125 | 6.9082 | 6.9125 | 27692.0 |
| 2009-12-07 08:29:00 | AAPL | Stock | 6.9075 | 6.9075 | 6.9075 | 6.9075 | 2800.0 |
| 2009-12-07 08:30:00 | AAPL | Stock | 6.9082 | 6.9082 | 6.9082 | 6.9082 | 2800.0 |
| 2009-12-07 08:31:00 | AAPL | Stock | 6.9107 | 6.9107 | 6.9073 | 6.9073 | 5600.0 |
| 2009-12-07 08:32:00 | AAPL | Stock | 6.9082 | 6.9082 | 6.9082 | 6.9082 | 8400.0 |
| 2009-12-07 08:34:00 | AAPL | Stock | 6.9139 | 6.9139 | 6.9071 | 6.9071 | 42000.0 |
| 2009-12-07 08:35:00 | AAPL | Stock | 6.9075 | 6.9075 | 6.9075 | 6.9075 | 2800.0 |
| 2009-12-07 08:36:00 | AAPL | Stock | 6.9089 | 6.9136 | 6.9089 | 6.9136 | 8400.0 |
| 2009-12-07 08:39:00 | AAPL | Stock | 6.9121 | 6.9121 | 6.9121 | 6.9121 | 8400.0 |
| 2009-12-07 08:40:00 | AAPL | Stock | 6.9121 | 6.9121 | 6.9089 | 6.9121 | 16800.0 |
| 2009-12-07 08:41:00 | AAPL | Stock | 6.9054 | 6.9054 | 6.9054 | 6.9054 | 2800.0 |
| 2009-12-07 08:43:00 | AAPL | Stock | 6.9089 | 6.9125 | 6.9089 | 6.9125 | 19600.0 |
| 2009-12-07 08:44:00 | AAPL | Stock | 6.9107 | 6.9107 | 6.9107 | 6.9107 | 2800.0 |
| 2009-12-07 08:45:00 | AAPL | Stock | 6.9107 | 6.9107 | 6.9107 | 6.9107 | 2800.0 |
| 2009-12-07 08:46:00 | AAPL | Stock | 6.9125 | 6.9125 | 6.9125 | 6.9125 | 16520.0 |
| 2009-12-07 08:47:00 | AAPL | Stock | 6.9125 | 6.9125 | 6.9125 | 6.9125 | 2800.0 |
| 2009-12-07 08:48:00 | AAPL | Stock | 6.9136 | 6.9136 | 6.9136 | 6.9136 | 2800.0 |
> showing 50 of 925,589 rows — these rows as CSV