PREVIEW / stock_1min / 2010-04-07
file: by_date/stock_1min/2010/2010-04-07.parquet size: 13.3 MB rows: 1,010,978 symbols: 2,836
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 |
|---|---|---|---|---|---|---|---|
| 2010-04-07 04:17:00 | AAPL | Stock | 8.5582 | 8.5582 | 8.5582 | 8.5582 | 22400.0 |
| 2010-04-07 04:18:00 | AAPL | Stock | 8.5582 | 8.5582 | 8.5582 | 8.5582 | 28000.0 |
| 2010-04-07 06:15:00 | AAPL | Stock | 8.5589 | 8.5589 | 8.5589 | 8.5589 | 2800.0 |
| 2010-04-07 07:17:00 | AAPL | Stock | 8.5446 | 8.5446 | 8.5446 | 8.5446 | 2800.0 |
| 2010-04-07 07:25:00 | AAPL | Stock | 8.5425 | 8.5425 | 8.5425 | 8.5425 | 2800.0 |
| 2010-04-07 07:29:00 | AAPL | Stock | 8.5339 | 8.5339 | 8.5339 | 8.5339 | 2800.0 |
| 2010-04-07 07:30:00 | AAPL | Stock | 8.5311 | 8.5311 | 8.5311 | 8.5311 | 2800.0 |
| 2010-04-07 07:36:00 | AAPL | Stock | 8.5436 | 8.5436 | 8.5436 | 8.5436 | 8400.0 |
| 2010-04-07 07:40:00 | AAPL | Stock | 8.5321 | 8.5321 | 8.5293 | 8.5304 | 18592.0 |
| 2010-04-07 07:41:00 | AAPL | Stock | 8.5282 | 8.5282 | 8.5271 | 8.5271 | 8400.0 |
| 2010-04-07 07:42:00 | AAPL | Stock | 8.5282 | 8.5282 | 8.5282 | 8.5282 | 11200.0 |
| 2010-04-07 07:48:00 | AAPL | Stock | 8.5339 | 8.5339 | 8.5339 | 8.5339 | 14000.0 |
| 2010-04-07 07:51:00 | AAPL | Stock | 8.5339 | 8.5339 | 8.5339 | 8.5339 | 5600.0 |
| 2010-04-07 07:55:00 | AAPL | Stock | 8.5379 | 8.5393 | 8.5361 | 8.5361 | 15820.0 |
| 2010-04-07 07:56:00 | AAPL | Stock | 8.5361 | 8.5361 | 8.5361 | 8.5361 | 5600.0 |
| 2010-04-07 08:00:00 | AAPL | Stock | 8.5361 | 8.5379 | 8.5357 | 8.5379 | 65436.0 |
| 2010-04-07 08:02:00 | AAPL | Stock | 8.5357 | 8.5375 | 8.5357 | 8.5375 | 71400.0 |
| 2010-04-07 08:03:00 | AAPL | Stock | 8.5393 | 8.5393 | 8.5386 | 8.5386 | 16800.0 |
| 2010-04-07 08:04:00 | AAPL | Stock | 8.5389 | 8.5393 | 8.5382 | 8.5382 | 36400.0 |
| 2010-04-07 08:05:00 | AAPL | Stock | 8.5382 | 8.5396 | 8.5382 | 8.5393 | 39620.0 |
| 2010-04-07 08:06:00 | AAPL | Stock | 8.5396 | 8.5396 | 8.5396 | 8.5396 | 2800.0 |
| 2010-04-07 08:07:00 | AAPL | Stock | 8.5396 | 8.5425 | 8.5396 | 8.5425 | 8400.0 |
| 2010-04-07 08:08:00 | AAPL | Stock | 8.5421 | 8.5436 | 8.5421 | 8.5436 | 11200.0 |
| 2010-04-07 08:09:00 | AAPL | Stock | 8.545 | 8.5464 | 8.545 | 8.5464 | 5600.0 |
| 2010-04-07 08:10:00 | AAPL | Stock | 8.5464 | 8.5468 | 8.5443 | 8.5446 | 30800.0 |
| 2010-04-07 08:11:00 | AAPL | Stock | 8.5436 | 8.5443 | 8.5393 | 8.5393 | 87472.0 |
| 2010-04-07 08:12:00 | AAPL | Stock | 8.5411 | 8.5411 | 8.5404 | 8.5404 | 5600.0 |
| 2010-04-07 08:15:00 | AAPL | Stock | 8.5414 | 8.5432 | 8.5404 | 8.5404 | 70000.0 |
| 2010-04-07 08:16:00 | AAPL | Stock | 8.54 | 8.54 | 8.54 | 8.54 | 2800.0 |
| 2010-04-07 08:17:00 | AAPL | Stock | 8.54 | 8.5418 | 8.5375 | 8.5412 | 37660.0 |
| 2010-04-07 08:18:00 | AAPL | Stock | 8.54 | 8.5414 | 8.54 | 8.5414 | 11200.0 |
| 2010-04-07 08:19:00 | AAPL | Stock | 8.5414 | 8.5414 | 8.5411 | 8.5411 | 19040.0 |
| 2010-04-07 08:22:00 | AAPL | Stock | 8.54 | 8.54 | 8.5357 | 8.5375 | 204120.0 |
| 2010-04-07 08:24:00 | AAPL | Stock | 8.537 | 8.537 | 8.537 | 8.537 | 2800.0 |
| 2010-04-07 08:25:00 | AAPL | Stock | 8.5364 | 8.5393 | 8.5357 | 8.5391 | 30800.0 |
| 2010-04-07 08:26:00 | AAPL | Stock | 8.5375 | 8.5375 | 8.5368 | 8.5375 | 28000.0 |
| 2010-04-07 08:27:00 | AAPL | Stock | 8.5393 | 8.5393 | 8.5393 | 8.5393 | 2800.0 |
| 2010-04-07 08:28:00 | AAPL | Stock | 8.5393 | 8.5425 | 8.5393 | 8.5396 | 132020.0 |
| 2010-04-07 08:29:00 | AAPL | Stock | 8.5393 | 8.5393 | 8.5371 | 8.5371 | 36400.0 |
| 2010-04-07 08:30:00 | AAPL | Stock | 8.5386 | 8.5393 | 8.5361 | 8.5393 | 91840.0 |
| 2010-04-07 08:31:00 | AAPL | Stock | 8.5393 | 8.5414 | 8.5393 | 8.5414 | 28000.0 |
| 2010-04-07 08:32:00 | AAPL | Stock | 8.5414 | 8.5429 | 8.5414 | 8.5429 | 33600.0 |
| 2010-04-07 08:33:00 | AAPL | Stock | 8.5436 | 8.5436 | 8.5429 | 8.5432 | 31164.0 |
| 2010-04-07 08:35:00 | AAPL | Stock | 8.5432 | 8.5432 | 8.5429 | 8.5432 | 22400.0 |
| 2010-04-07 08:36:00 | AAPL | Stock | 8.5429 | 8.5429 | 8.5404 | 8.5414 | 80080.0 |
| 2010-04-07 08:37:00 | AAPL | Stock | 8.5414 | 8.5414 | 8.5414 | 8.5414 | 5600.0 |
| 2010-04-07 08:38:00 | AAPL | Stock | 8.5414 | 8.5414 | 8.5411 | 8.5411 | 36400.0 |
| 2010-04-07 08:39:00 | AAPL | Stock | 8.5414 | 8.5414 | 8.5414 | 8.5414 | 2800.0 |
| 2010-04-07 08:40:00 | AAPL | Stock | 8.5432 | 8.5432 | 8.5432 | 8.5432 | 2800.0 |
| 2010-04-07 08:42:00 | AAPL | Stock | 8.5411 | 8.5411 | 8.5407 | 8.5407 | 5600.0 |
> showing 50 of 1,010,978 rows — these rows as CSV