PREVIEW / stock_1min / 2008-10-07
file: by_date/stock_1min/2008/2008-10-07.parquet size: 13.9 MB rows: 1,077,834 symbols: 2,753
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-10-07 07:04:00 | AAPL | Stock | 3.5143 | 3.5143 | 3.5143 | 3.5143 | 2800.0 |
| 2008-10-07 07:05:00 | AAPL | Stock | 3.5143 | 3.5625 | 3.5143 | 3.5625 | 8400.0 |
| 2008-10-07 07:07:00 | AAPL | Stock | 3.5536 | 3.5536 | 3.5536 | 3.5536 | 5600.0 |
| 2008-10-07 07:10:00 | AAPL | Stock | 3.5407 | 3.5407 | 3.5407 | 3.5407 | 4900.0 |
| 2008-10-07 07:15:00 | AAPL | Stock | 3.5196 | 3.5411 | 3.5196 | 3.5411 | 40740.0 |
| 2008-10-07 07:16:00 | AAPL | Stock | 3.5482 | 3.5482 | 3.5482 | 3.5482 | 9800.0 |
| 2008-10-07 07:17:00 | AAPL | Stock | 3.5482 | 3.5482 | 3.5482 | 3.5482 | 4200.0 |
| 2008-10-07 07:18:00 | AAPL | Stock | 3.5268 | 3.5268 | 3.5268 | 3.5268 | 2800.0 |
| 2008-10-07 07:21:00 | AAPL | Stock | 3.5393 | 3.5393 | 3.5393 | 3.5393 | 2800.0 |
| 2008-10-07 07:22:00 | AAPL | Stock | 3.5461 | 3.5464 | 3.5461 | 3.5464 | 12488.0 |
| 2008-10-07 07:29:00 | AAPL | Stock | 3.5421 | 3.5464 | 3.5393 | 3.5464 | 44800.0 |
| 2008-10-07 07:30:00 | AAPL | Stock | 3.5393 | 3.5464 | 3.5393 | 3.5429 | 114800.0 |
| 2008-10-07 07:31:00 | AAPL | Stock | 3.5464 | 3.5464 | 3.5464 | 3.5464 | 2800.0 |
| 2008-10-07 07:32:00 | AAPL | Stock | 3.5464 | 3.5464 | 3.5464 | 3.5464 | 2800.0 |
| 2008-10-07 07:33:00 | AAPL | Stock | 3.5496 | 3.5496 | 3.5496 | 3.5496 | 8400.0 |
| 2008-10-07 07:35:00 | AAPL | Stock | 3.5429 | 3.5429 | 3.5429 | 3.5429 | 11200.0 |
| 2008-10-07 07:39:00 | AAPL | Stock | 3.5496 | 3.5496 | 3.5496 | 3.5496 | 14000.0 |
| 2008-10-07 07:40:00 | AAPL | Stock | 3.5496 | 3.5496 | 3.5496 | 3.5496 | 2800.0 |
| 2008-10-07 07:42:00 | AAPL | Stock | 3.5393 | 3.5393 | 3.5393 | 3.5393 | 5600.0 |
| 2008-10-07 07:46:00 | AAPL | Stock | 3.5232 | 3.5232 | 3.5232 | 3.5232 | 11200.0 |
| 2008-10-07 07:47:00 | AAPL | Stock | 3.5357 | 3.5357 | 3.5357 | 3.5357 | 2800.0 |
| 2008-10-07 07:48:00 | AAPL | Stock | 3.5339 | 3.5339 | 3.5339 | 3.5339 | 2800.0 |
| 2008-10-07 07:54:00 | AAPL | Stock | 3.5239 | 3.5239 | 3.5232 | 3.5232 | 14000.0 |
| 2008-10-07 07:56:00 | AAPL | Stock | 3.5304 | 3.5357 | 3.5304 | 3.5357 | 28000.0 |
| 2008-10-07 07:57:00 | AAPL | Stock | 3.5357 | 3.5357 | 3.5357 | 3.5357 | 14000.0 |
| 2008-10-07 07:59:00 | AAPL | Stock | 3.5411 | 3.5411 | 3.5411 | 3.5411 | 2800.0 |
| 2008-10-07 08:00:00 | AAPL | Stock | 3.5411 | 3.5411 | 3.525 | 3.5357 | 207760.0 |
| 2008-10-07 08:01:00 | AAPL | Stock | 3.5357 | 3.5357 | 3.5254 | 3.5264 | 69776.0 |
| 2008-10-07 08:02:00 | AAPL | Stock | 3.5268 | 3.5286 | 3.525 | 3.5286 | 40124.0 |
| 2008-10-07 08:03:00 | AAPL | Stock | 3.525 | 3.525 | 3.5232 | 3.5232 | 33572.0 |
| 2008-10-07 08:04:00 | AAPL | Stock | 3.5239 | 3.5239 | 3.5232 | 3.5232 | 25900.0 |
| 2008-10-07 08:05:00 | AAPL | Stock | 3.5232 | 3.5293 | 3.5214 | 3.5214 | 24640.0 |
| 2008-10-07 08:06:00 | AAPL | Stock | 3.5264 | 3.5268 | 3.5214 | 3.5268 | 78400.0 |
| 2008-10-07 08:07:00 | AAPL | Stock | 3.5221 | 3.5286 | 3.5214 | 3.5286 | 117600.0 |
| 2008-10-07 08:08:00 | AAPL | Stock | 3.5214 | 3.5268 | 3.5214 | 3.5268 | 9100.0 |
| 2008-10-07 08:09:00 | AAPL | Stock | 3.5304 | 3.535 | 3.5304 | 3.535 | 302400.0 |
| 2008-10-07 08:10:00 | AAPL | Stock | 3.535 | 3.535 | 3.5307 | 3.5314 | 82460.0 |
| 2008-10-07 08:11:00 | AAPL | Stock | 3.5346 | 3.535 | 3.5321 | 3.535 | 112000.0 |
| 2008-10-07 08:12:00 | AAPL | Stock | 3.5321 | 3.5321 | 3.5304 | 3.5304 | 68796.0 |
| 2008-10-07 08:13:00 | AAPL | Stock | 3.5321 | 3.535 | 3.5321 | 3.5329 | 112000.0 |
| 2008-10-07 08:14:00 | AAPL | Stock | 3.5307 | 3.5318 | 3.5304 | 3.5318 | 16800.0 |
| 2008-10-07 08:15:00 | AAPL | Stock | 3.5346 | 3.535 | 3.5161 | 3.5179 | 497868.0 |
| 2008-10-07 08:16:00 | AAPL | Stock | 3.5125 | 3.5286 | 3.5011 | 3.5143 | 217000.0 |
| 2008-10-07 08:17:00 | AAPL | Stock | 3.515 | 3.5296 | 3.5143 | 3.5214 | 148400.0 |
| 2008-10-07 08:18:00 | AAPL | Stock | 3.5214 | 3.5218 | 3.4989 | 3.5086 | 207368.0 |
| 2008-10-07 08:19:00 | AAPL | Stock | 3.4954 | 3.5036 | 3.4932 | 3.4932 | 357980.0 |
| 2008-10-07 08:20:00 | AAPL | Stock | 3.4964 | 3.5036 | 3.4914 | 3.4936 | 75600.0 |
| 2008-10-07 08:21:00 | AAPL | Stock | 3.4936 | 3.5 | 3.485 | 3.485 | 89600.0 |
| 2008-10-07 08:22:00 | AAPL | Stock | 3.485 | 3.4886 | 3.4614 | 3.4614 | 151340.0 |
| 2008-10-07 08:23:00 | AAPL | Stock | 3.4611 | 3.4643 | 3.4571 | 3.4575 | 153384.0 |
> showing 50 of 1,077,834 rows — these rows as CSV