PREVIEW / stock_1min / 2008-05-20
file: by_date/stock_1min/2008/2008-05-20.parquet size: 12.4 MB rows: 1,001,035 symbols: 2,704
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-05-20 05:38:00 | AAPL | Stock | 6.5661 | 6.5661 | 6.5614 | 6.5614 | 11200.0 |
| 2008-05-20 06:23:00 | AAPL | Stock | 6.5711 | 6.5711 | 6.5711 | 6.5711 | 5600.0 |
| 2008-05-20 06:43:00 | AAPL | Stock | 6.5539 | 6.5539 | 6.5539 | 6.5539 | 8400.0 |
| 2008-05-20 07:00:00 | AAPL | Stock | 6.5182 | 6.5182 | 6.5182 | 6.5182 | 11088.0 |
| 2008-05-20 07:42:00 | AAPL | Stock | 6.5446 | 6.5446 | 6.5446 | 6.5446 | 2800.0 |
| 2008-05-20 07:45:00 | AAPL | Stock | 6.5279 | 6.5279 | 6.5275 | 6.5275 | 5600.0 |
| 2008-05-20 07:47:00 | AAPL | Stock | 6.5282 | 6.5282 | 6.5282 | 6.5282 | 5600.0 |
| 2008-05-20 07:48:00 | AAPL | Stock | 6.5357 | 6.5357 | 6.5357 | 6.5357 | 2800.0 |
| 2008-05-20 07:49:00 | AAPL | Stock | 6.5321 | 6.5321 | 6.5321 | 6.5321 | 2800.0 |
| 2008-05-20 07:51:00 | AAPL | Stock | 6.5357 | 6.5357 | 6.5357 | 6.5357 | 2800.0 |
| 2008-05-20 07:52:00 | AAPL | Stock | 6.5357 | 6.5357 | 6.5357 | 6.5357 | 2800.0 |
| 2008-05-20 07:54:00 | AAPL | Stock | 6.5357 | 6.5357 | 6.5357 | 6.5357 | 2800.0 |
| 2008-05-20 07:56:00 | AAPL | Stock | 6.5357 | 6.5357 | 6.5357 | 6.5357 | 19600.0 |
| 2008-05-20 07:59:00 | AAPL | Stock | 6.5357 | 6.5357 | 6.5357 | 6.5357 | 2800.0 |
| 2008-05-20 08:00:00 | AAPL | Stock | 6.5304 | 6.5393 | 6.5304 | 6.5357 | 146132.0 |
| 2008-05-20 08:01:00 | AAPL | Stock | 6.5354 | 6.5361 | 6.5354 | 6.5357 | 117936.0 |
| 2008-05-20 08:02:00 | AAPL | Stock | 6.5386 | 6.5429 | 6.5386 | 6.5429 | 19600.0 |
| 2008-05-20 08:03:00 | AAPL | Stock | 6.5482 | 6.5532 | 6.5396 | 6.55 | 204484.0 |
| 2008-05-20 08:04:00 | AAPL | Stock | 6.5518 | 6.5543 | 6.55 | 6.5543 | 130844.0 |
| 2008-05-20 08:05:00 | AAPL | Stock | 6.5543 | 6.5621 | 6.5543 | 6.5586 | 144088.0 |
| 2008-05-20 08:06:00 | AAPL | Stock | 6.5571 | 6.5607 | 6.5536 | 6.5536 | 94668.0 |
| 2008-05-20 08:07:00 | AAPL | Stock | 6.555 | 6.5571 | 6.5532 | 6.5571 | 83552.0 |
| 2008-05-20 08:08:00 | AAPL | Stock | 6.5539 | 6.555 | 6.5521 | 6.555 | 14000.0 |
| 2008-05-20 08:10:00 | AAPL | Stock | 6.5536 | 6.5536 | 6.5504 | 6.5525 | 48020.0 |
| 2008-05-20 08:11:00 | AAPL | Stock | 6.5521 | 6.5539 | 6.5521 | 6.5521 | 35364.0 |
| 2008-05-20 08:13:00 | AAPL | Stock | 6.5532 | 6.5532 | 6.5504 | 6.5504 | 5740.0 |
| 2008-05-20 08:14:00 | AAPL | Stock | 6.5532 | 6.5536 | 6.5507 | 6.5507 | 86800.0 |
| 2008-05-20 08:15:00 | AAPL | Stock | 6.55 | 6.55 | 6.5464 | 6.5464 | 197344.0 |
| 2008-05-20 08:16:00 | AAPL | Stock | 6.5464 | 6.5464 | 6.5429 | 6.5429 | 54600.0 |
| 2008-05-20 08:17:00 | AAPL | Stock | 6.5393 | 6.5393 | 6.5379 | 6.5379 | 16800.0 |
| 2008-05-20 08:18:00 | AAPL | Stock | 6.5414 | 6.5414 | 6.5411 | 6.5414 | 8400.0 |
| 2008-05-20 08:19:00 | AAPL | Stock | 6.5411 | 6.5411 | 6.5357 | 6.5357 | 97440.0 |
| 2008-05-20 08:20:00 | AAPL | Stock | 6.5357 | 6.5357 | 6.5268 | 6.5286 | 101332.0 |
| 2008-05-20 08:21:00 | AAPL | Stock | 6.5318 | 6.5339 | 6.5268 | 6.5339 | 64400.0 |
| 2008-05-20 08:22:00 | AAPL | Stock | 6.5357 | 6.5357 | 6.5286 | 6.5289 | 56000.0 |
| 2008-05-20 08:24:00 | AAPL | Stock | 6.5307 | 6.5343 | 6.5307 | 6.5343 | 16800.0 |
| 2008-05-20 08:25:00 | AAPL | Stock | 6.5314 | 6.5318 | 6.5282 | 6.5311 | 45080.0 |
| 2008-05-20 08:26:00 | AAPL | Stock | 6.5311 | 6.5336 | 6.5293 | 6.5311 | 31640.0 |
| 2008-05-20 08:27:00 | AAPL | Stock | 6.5329 | 6.5329 | 6.5329 | 6.5329 | 5600.0 |
| 2008-05-20 08:28:00 | AAPL | Stock | 6.5321 | 6.5325 | 6.5321 | 6.5325 | 5600.0 |
| 2008-05-20 08:29:00 | AAPL | Stock | 6.5336 | 6.5357 | 6.5336 | 6.5357 | 36400.0 |
| 2008-05-20 08:30:00 | AAPL | Stock | 6.5404 | 6.5425 | 6.5286 | 6.5421 | 95172.0 |
| 2008-05-20 08:31:00 | AAPL | Stock | 6.5332 | 6.535 | 6.5289 | 6.5307 | 92400.0 |
| 2008-05-20 08:32:00 | AAPL | Stock | 6.5321 | 6.5332 | 6.525 | 6.525 | 45080.0 |
| 2008-05-20 08:33:00 | AAPL | Stock | 6.5239 | 6.5239 | 6.5179 | 6.5207 | 216412.0 |
| 2008-05-20 08:34:00 | AAPL | Stock | 6.5214 | 6.5214 | 6.5179 | 6.5193 | 208684.0 |
| 2008-05-20 08:35:00 | AAPL | Stock | 6.5204 | 6.5243 | 6.5189 | 6.5232 | 125636.0 |
| 2008-05-20 08:36:00 | AAPL | Stock | 6.5232 | 6.5318 | 6.5232 | 6.5318 | 33600.0 |
| 2008-05-20 08:37:00 | AAPL | Stock | 6.5236 | 6.5286 | 6.52 | 6.52 | 89572.0 |
| 2008-05-20 08:38:00 | AAPL | Stock | 6.5196 | 6.525 | 6.5179 | 6.5214 | 116816.0 |
> showing 50 of 1,001,035 rows — these rows as CSV