PREVIEW / stock_1min / 2008-02-21
file: by_date/stock_1min/2008/2008-02-21.parquet size: 12.4 MB rows: 1,004,041 symbols: 2,648
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-02-21 05:36:00 | AAPL | Stock | 4.4464 | 4.4464 | 4.4457 | 4.4457 | 47600.0 |
| 2008-02-21 06:21:00 | AAPL | Stock | 4.4643 | 4.4643 | 4.4643 | 4.4643 | 19600.0 |
| 2008-02-21 06:23:00 | AAPL | Stock | 4.4643 | 4.4643 | 4.4643 | 4.4643 | 28000.0 |
| 2008-02-21 06:54:00 | AAPL | Stock | 4.4857 | 4.4857 | 4.4857 | 4.4857 | 28000.0 |
| 2008-02-21 06:56:00 | AAPL | Stock | 4.4993 | 4.5 | 4.4993 | 4.5 | 33600.0 |
| 2008-02-21 07:00:00 | AAPL | Stock | 4.5 | 4.5 | 4.5 | 4.5 | 22400.0 |
| 2008-02-21 07:01:00 | AAPL | Stock | 4.5 | 4.5 | 4.5 | 4.5 | 14000.0 |
| 2008-02-21 07:02:00 | AAPL | Stock | 4.5 | 4.5 | 4.5 | 4.5 | 8400.0 |
| 2008-02-21 07:03:00 | AAPL | Stock | 4.5 | 4.5 | 4.5 | 4.5 | 28000.0 |
| 2008-02-21 07:06:00 | AAPL | Stock | 4.5 | 4.5 | 4.5 | 4.5 | 11200.0 |
| 2008-02-21 07:08:00 | AAPL | Stock | 4.5 | 4.5 | 4.5 | 4.5 | 11200.0 |
| 2008-02-21 07:09:00 | AAPL | Stock | 4.4918 | 4.4918 | 4.4918 | 4.4918 | 2800.0 |
| 2008-02-21 07:10:00 | AAPL | Stock | 4.4914 | 4.4914 | 4.4914 | 4.4914 | 33600.0 |
| 2008-02-21 07:11:00 | AAPL | Stock | 4.4911 | 4.4911 | 4.4911 | 4.4911 | 14000.0 |
| 2008-02-21 07:16:00 | AAPL | Stock | 4.4996 | 4.4996 | 4.4996 | 4.4996 | 2800.0 |
| 2008-02-21 07:17:00 | AAPL | Stock | 4.4996 | 4.5054 | 4.4996 | 4.5054 | 24724.0 |
| 2008-02-21 07:18:00 | AAPL | Stock | 4.5 | 4.5054 | 4.5 | 4.5018 | 58800.0 |
| 2008-02-21 07:21:00 | AAPL | Stock | 4.51 | 4.51 | 4.5018 | 4.5018 | 19600.0 |
| 2008-02-21 07:22:00 | AAPL | Stock | 4.5 | 4.5179 | 4.5 | 4.5089 | 109200.0 |
| 2008-02-21 07:24:00 | AAPL | Stock | 4.5179 | 4.5179 | 4.5179 | 4.5179 | 54712.0 |
| 2008-02-21 07:25:00 | AAPL | Stock | 4.5232 | 4.525 | 4.5196 | 4.5196 | 70000.0 |
| 2008-02-21 07:26:00 | AAPL | Stock | 4.525 | 4.525 | 4.525 | 4.525 | 14000.0 |
| 2008-02-21 07:27:00 | AAPL | Stock | 4.5196 | 4.5196 | 4.5196 | 4.5196 | 58800.0 |
| 2008-02-21 07:28:00 | AAPL | Stock | 4.5196 | 4.5196 | 4.5196 | 4.5196 | 2800.0 |
| 2008-02-21 07:29:00 | AAPL | Stock | 4.525 | 4.525 | 4.525 | 4.525 | 14000.0 |
| 2008-02-21 07:30:00 | AAPL | Stock | 4.5271 | 4.5286 | 4.5268 | 4.5286 | 141512.0 |
| 2008-02-21 07:32:00 | AAPL | Stock | 4.5311 | 4.5311 | 4.5286 | 4.5311 | 15400.0 |
| 2008-02-21 07:33:00 | AAPL | Stock | 4.5311 | 4.5311 | 4.5304 | 4.5304 | 56000.0 |
| 2008-02-21 07:35:00 | AAPL | Stock | 4.5304 | 4.5304 | 4.5304 | 4.5304 | 12600.0 |
| 2008-02-21 07:36:00 | AAPL | Stock | 4.5318 | 4.5318 | 4.5179 | 4.5179 | 57400.0 |
| 2008-02-21 07:39:00 | AAPL | Stock | 4.5179 | 4.5179 | 4.5179 | 4.5179 | 42000.0 |
| 2008-02-21 07:40:00 | AAPL | Stock | 4.5179 | 4.5179 | 4.5179 | 4.5179 | 24500.0 |
| 2008-02-21 07:42:00 | AAPL | Stock | 4.5179 | 4.5179 | 4.5179 | 4.5179 | 2800.0 |
| 2008-02-21 07:44:00 | AAPL | Stock | 4.5111 | 4.5143 | 4.5111 | 4.5143 | 28000.0 |
| 2008-02-21 07:46:00 | AAPL | Stock | 4.5161 | 4.5161 | 4.5161 | 4.5161 | 5600.0 |
| 2008-02-21 07:48:00 | AAPL | Stock | 4.525 | 4.525 | 4.525 | 4.525 | 2800.0 |
| 2008-02-21 07:50:00 | AAPL | Stock | 4.5282 | 4.5289 | 4.5282 | 4.5289 | 44800.0 |
| 2008-02-21 07:51:00 | AAPL | Stock | 4.5289 | 4.5318 | 4.5271 | 4.5271 | 33600.0 |
| 2008-02-21 07:52:00 | AAPL | Stock | 4.5286 | 4.5289 | 4.5186 | 4.5186 | 49000.0 |
| 2008-02-21 07:53:00 | AAPL | Stock | 4.5186 | 4.5186 | 4.5186 | 4.5186 | 2800.0 |
| 2008-02-21 07:54:00 | AAPL | Stock | 4.5186 | 4.5186 | 4.5179 | 4.5179 | 51268.0 |
| 2008-02-21 07:56:00 | AAPL | Stock | 4.5175 | 4.5179 | 4.5175 | 4.5179 | 5600.0 |
| 2008-02-21 07:57:00 | AAPL | Stock | 4.5229 | 4.5229 | 4.5229 | 4.5229 | 5600.0 |
| 2008-02-21 07:58:00 | AAPL | Stock | 4.5121 | 4.5121 | 4.5121 | 4.5121 | 2800.0 |
| 2008-02-21 07:59:00 | AAPL | Stock | 4.5121 | 4.5121 | 4.5118 | 4.5121 | 14000.0 |
| 2008-02-21 08:00:00 | AAPL | Stock | 4.5179 | 4.5179 | 4.5039 | 4.5039 | 322392.0 |
| 2008-02-21 08:01:00 | AAPL | Stock | 4.5039 | 4.5125 | 4.5039 | 4.5125 | 291928.0 |
| 2008-02-21 08:02:00 | AAPL | Stock | 4.5125 | 4.5143 | 4.5061 | 4.5143 | 116452.0 |
| 2008-02-21 08:03:00 | AAPL | Stock | 4.5146 | 4.5243 | 4.5146 | 4.5243 | 310380.0 |
| 2008-02-21 08:04:00 | AAPL | Stock | 4.525 | 4.525 | 4.5157 | 4.5246 | 142016.0 |
> showing 50 of 1,004,041 rows — these rows as CSV