PREVIEW / stock_1min / 2006-05-10
file: by_date/stock_1min/2006/2006-05-10.parquet size: 8.4 MB rows: 686,213 symbols: 1,847
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 |
|---|---|---|---|---|---|---|---|
| 2006-05-10 04:23:00 | AAPL | Stock | 2.5386 | 2.5386 | 2.5386 | 2.5386 | 8400.0 |
| 2006-05-10 04:29:00 | AAPL | Stock | 2.5386 | 2.5386 | 2.5386 | 2.5386 | 5600.0 |
| 2006-05-10 04:30:00 | AAPL | Stock | 2.5386 | 2.5386 | 2.5386 | 2.5386 | 28000.0 |
| 2006-05-10 04:32:00 | AAPL | Stock | 2.5386 | 2.5386 | 2.5386 | 2.5386 | 22400.0 |
| 2006-05-10 08:02:00 | AAPL | Stock | 2.5393 | 2.5393 | 2.5393 | 2.5393 | 14000.0 |
| 2006-05-10 08:03:00 | AAPL | Stock | 2.5429 | 2.5443 | 2.5429 | 2.5443 | 58800.0 |
| 2006-05-10 08:09:00 | AAPL | Stock | 2.5389 | 2.5389 | 2.5357 | 2.5357 | 26572.0 |
| 2006-05-10 08:11:00 | AAPL | Stock | 2.5389 | 2.5389 | 2.5389 | 2.5389 | 28000.0 |
| 2006-05-10 08:13:00 | AAPL | Stock | 2.5396 | 2.5429 | 2.5396 | 2.5429 | 43036.0 |
| 2006-05-10 08:16:00 | AAPL | Stock | 2.5429 | 2.5429 | 2.5429 | 2.5429 | 28000.0 |
| 2006-05-10 08:17:00 | AAPL | Stock | 2.5429 | 2.5429 | 2.5429 | 2.5429 | 28000.0 |
| 2006-05-10 08:24:00 | AAPL | Stock | 2.5429 | 2.5429 | 2.5429 | 2.5429 | 2800.0 |
| 2006-05-10 08:27:00 | AAPL | Stock | 2.5429 | 2.5429 | 2.5429 | 2.5429 | 42000.0 |
| 2006-05-10 08:31:00 | AAPL | Stock | 2.5375 | 2.5375 | 2.5375 | 2.5375 | 8400.0 |
| 2006-05-10 08:32:00 | AAPL | Stock | 2.5375 | 2.5375 | 2.5375 | 2.5375 | 5600.0 |
| 2006-05-10 08:45:00 | AAPL | Stock | 2.5425 | 2.5429 | 2.5425 | 2.5429 | 14000.0 |
| 2006-05-10 08:49:00 | AAPL | Stock | 2.5411 | 2.5411 | 2.5411 | 2.5411 | 2800.0 |
| 2006-05-10 08:51:00 | AAPL | Stock | 2.5414 | 2.5414 | 2.5414 | 2.5414 | 2800.0 |
| 2006-05-10 08:53:00 | AAPL | Stock | 2.5414 | 2.5414 | 2.5414 | 2.5414 | 14000.0 |
| 2006-05-10 08:56:00 | AAPL | Stock | 2.5411 | 2.5411 | 2.54 | 2.5411 | 42000.0 |
| 2006-05-10 08:57:00 | AAPL | Stock | 2.54 | 2.54 | 2.54 | 2.54 | 6860.0 |
| 2006-05-10 09:00:00 | AAPL | Stock | 2.5407 | 2.5407 | 2.5407 | 2.5407 | 28000.0 |
| 2006-05-10 09:01:00 | AAPL | Stock | 2.5386 | 2.54 | 2.5386 | 2.54 | 9408.0 |
| 2006-05-10 09:02:00 | AAPL | Stock | 2.54 | 2.54 | 2.54 | 2.54 | 6636.0 |
| 2006-05-10 09:03:00 | AAPL | Stock | 2.54 | 2.5411 | 2.54 | 2.54 | 22400.0 |
| 2006-05-10 09:04:00 | AAPL | Stock | 2.5389 | 2.5389 | 2.5389 | 2.5389 | 2800.0 |
| 2006-05-10 09:05:00 | AAPL | Stock | 2.5404 | 2.5404 | 2.5393 | 2.5393 | 61600.0 |
| 2006-05-10 09:06:00 | AAPL | Stock | 2.5389 | 2.5389 | 2.5389 | 2.5389 | 58800.0 |
| 2006-05-10 09:09:00 | AAPL | Stock | 2.5389 | 2.5389 | 2.5389 | 2.5389 | 2800.0 |
| 2006-05-10 09:11:00 | AAPL | Stock | 2.5389 | 2.5389 | 2.5389 | 2.5389 | 35840.0 |
| 2006-05-10 09:13:00 | AAPL | Stock | 2.5389 | 2.5389 | 2.5389 | 2.5389 | 8400.0 |
| 2006-05-10 09:15:00 | AAPL | Stock | 2.5382 | 2.5382 | 2.5382 | 2.5382 | 8232.0 |
| 2006-05-10 09:18:00 | AAPL | Stock | 2.5393 | 2.5429 | 2.5393 | 2.5429 | 33600.0 |
| 2006-05-10 09:25:00 | AAPL | Stock | 2.5382 | 2.5382 | 2.5357 | 2.5375 | 22568.0 |
| 2006-05-10 09:27:00 | AAPL | Stock | 2.5379 | 2.5379 | 2.5379 | 2.5379 | 2800.0 |
| 2006-05-10 09:28:00 | AAPL | Stock | 2.5382 | 2.5429 | 2.5382 | 2.5429 | 33040.0 |
| 2006-05-10 09:29:00 | AAPL | Stock | 2.5425 | 2.5464 | 2.5425 | 2.5464 | 248360.0 |
| 2006-05-10 09:30:00 | AAPL | Stock | 2.5461 | 2.5475 | 2.5368 | 2.5382 | 5611760.0 |
| 2006-05-10 09:31:00 | AAPL | Stock | 2.5382 | 2.5414 | 2.5296 | 2.5314 | 2268448.0 |
| 2006-05-10 09:32:00 | AAPL | Stock | 2.5311 | 2.5393 | 2.5289 | 2.5368 | 2675680.0 |
| 2006-05-10 09:33:00 | AAPL | Stock | 2.5371 | 2.5379 | 2.53 | 2.5343 | 2027844.0 |
| 2006-05-10 09:34:00 | AAPL | Stock | 2.5346 | 2.5464 | 2.5229 | 2.5236 | 5464592.0 |
| 2006-05-10 09:35:00 | AAPL | Stock | 2.5243 | 2.53 | 2.5239 | 2.53 | 1796760.0 |
| 2006-05-10 09:36:00 | AAPL | Stock | 2.53 | 2.5325 | 2.5268 | 2.5279 | 1450988.0 |
| 2006-05-10 09:37:00 | AAPL | Stock | 2.5282 | 2.5289 | 2.5236 | 2.5243 | 2534364.0 |
| 2006-05-10 09:38:00 | AAPL | Stock | 2.525 | 2.5254 | 2.5236 | 2.525 | 785960.0 |
| 2006-05-10 09:39:00 | AAPL | Stock | 2.525 | 2.525 | 2.5221 | 2.5236 | 1141980.0 |
| 2006-05-10 09:40:00 | AAPL | Stock | 2.5221 | 2.5229 | 2.5179 | 2.5218 | 3025036.0 |
| 2006-05-10 09:41:00 | AAPL | Stock | 2.5221 | 2.525 | 2.5193 | 2.5246 | 1866648.0 |
| 2006-05-10 09:42:00 | AAPL | Stock | 2.525 | 2.53 | 2.5236 | 2.5268 | 2674868.0 |
> showing 50 of 686,213 rows — these rows as CSV