PREVIEW / stock_1min / 2008-08-05
file: by_date/stock_1min/2008/2008-08-05.parquet size: 13.0 MB rows: 1,047,237 symbols: 2,695
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-08-05 07:00:00 | AAPL | Stock | 5.5586 | 5.5586 | 5.5586 | 5.5586 | 11200.0 |
| 2008-08-05 07:01:00 | AAPL | Stock | 5.5586 | 5.5586 | 5.5586 | 5.5586 | 14000.0 |
| 2008-08-05 07:04:00 | AAPL | Stock | 5.5357 | 5.5357 | 5.5357 | 5.5357 | 2800.0 |
| 2008-08-05 07:22:00 | AAPL | Stock | 5.5371 | 5.5371 | 5.5368 | 5.5368 | 14000.0 |
| 2008-08-05 07:24:00 | AAPL | Stock | 5.5539 | 5.5579 | 5.5539 | 5.5579 | 28000.0 |
| 2008-08-05 07:26:00 | AAPL | Stock | 5.5389 | 5.5536 | 5.5389 | 5.5536 | 39200.0 |
| 2008-08-05 07:27:00 | AAPL | Stock | 5.5579 | 5.5589 | 5.5579 | 5.5589 | 42000.0 |
| 2008-08-05 07:28:00 | AAPL | Stock | 5.5589 | 5.5589 | 5.5589 | 5.5589 | 5460.0 |
| 2008-08-05 07:35:00 | AAPL | Stock | 5.5625 | 5.5625 | 5.5625 | 5.5625 | 13720.0 |
| 2008-08-05 07:37:00 | AAPL | Stock | 5.5704 | 5.5714 | 5.5704 | 5.5714 | 42000.0 |
| 2008-08-05 07:38:00 | AAPL | Stock | 5.5796 | 5.5796 | 5.5796 | 5.5796 | 2800.0 |
| 2008-08-05 07:39:00 | AAPL | Stock | 5.5714 | 5.5714 | 5.5714 | 5.5714 | 2800.0 |
| 2008-08-05 07:40:00 | AAPL | Stock | 5.5654 | 5.5654 | 5.5625 | 5.5625 | 5600.0 |
| 2008-08-05 07:41:00 | AAPL | Stock | 5.5589 | 5.5607 | 5.5589 | 5.5589 | 30800.0 |
| 2008-08-05 07:42:00 | AAPL | Stock | 5.5571 | 5.5589 | 5.5464 | 5.55 | 28000.0 |
| 2008-08-05 07:44:00 | AAPL | Stock | 5.5521 | 5.5521 | 5.5454 | 5.5454 | 19600.0 |
| 2008-08-05 07:47:00 | AAPL | Stock | 5.5446 | 5.5446 | 5.5446 | 5.5446 | 33600.0 |
| 2008-08-05 07:48:00 | AAPL | Stock | 5.5479 | 5.5479 | 5.5479 | 5.5479 | 3164.0 |
| 2008-08-05 07:49:00 | AAPL | Stock | 5.5479 | 5.5511 | 5.5479 | 5.5511 | 22036.0 |
| 2008-08-05 07:51:00 | AAPL | Stock | 5.5511 | 5.5511 | 5.5511 | 5.5511 | 14000.0 |
| 2008-08-05 07:52:00 | AAPL | Stock | 5.5511 | 5.5511 | 5.5511 | 5.5511 | 2800.0 |
| 2008-08-05 07:53:00 | AAPL | Stock | 5.5511 | 5.5511 | 5.5511 | 5.5511 | 2800.0 |
| 2008-08-05 07:56:00 | AAPL | Stock | 5.5496 | 5.5496 | 5.5496 | 5.5496 | 2800.0 |
| 2008-08-05 07:58:00 | AAPL | Stock | 5.5496 | 5.5511 | 5.5496 | 5.5511 | 44800.0 |
| 2008-08-05 07:59:00 | AAPL | Stock | 5.5511 | 5.5511 | 5.5511 | 5.5511 | 36400.0 |
| 2008-08-05 08:00:00 | AAPL | Stock | 5.5504 | 5.5625 | 5.5464 | 5.5504 | 193508.0 |
| 2008-08-05 08:01:00 | AAPL | Stock | 5.55 | 5.5543 | 5.55 | 5.5532 | 103600.0 |
| 2008-08-05 08:02:00 | AAPL | Stock | 5.5489 | 5.5514 | 5.5464 | 5.5464 | 70028.0 |
| 2008-08-05 08:03:00 | AAPL | Stock | 5.5482 | 5.5482 | 5.5479 | 5.5482 | 51660.0 |
| 2008-08-05 08:04:00 | AAPL | Stock | 5.55 | 5.55 | 5.545 | 5.5493 | 21000.0 |
| 2008-08-05 08:05:00 | AAPL | Stock | 5.5475 | 5.5486 | 5.5446 | 5.5464 | 97720.0 |
| 2008-08-05 08:06:00 | AAPL | Stock | 5.5446 | 5.545 | 5.5446 | 5.545 | 19600.0 |
| 2008-08-05 08:07:00 | AAPL | Stock | 5.5446 | 5.5446 | 5.5404 | 5.5411 | 41748.0 |
| 2008-08-05 08:08:00 | AAPL | Stock | 5.5411 | 5.5411 | 5.5357 | 5.5357 | 146104.0 |
| 2008-08-05 08:09:00 | AAPL | Stock | 5.5371 | 5.5371 | 5.5314 | 5.5325 | 28000.0 |
| 2008-08-05 08:10:00 | AAPL | Stock | 5.5336 | 5.5368 | 5.5318 | 5.5368 | 147056.0 |
| 2008-08-05 08:11:00 | AAPL | Stock | 5.5368 | 5.5432 | 5.5357 | 5.5432 | 60928.0 |
| 2008-08-05 08:12:00 | AAPL | Stock | 5.5396 | 5.5425 | 5.5382 | 5.5425 | 22400.0 |
| 2008-08-05 08:13:00 | AAPL | Stock | 5.5396 | 5.5425 | 5.5396 | 5.5425 | 8400.0 |
| 2008-08-05 08:15:00 | AAPL | Stock | 5.5411 | 5.5432 | 5.5411 | 5.5432 | 19600.0 |
| 2008-08-05 08:16:00 | AAPL | Stock | 5.5432 | 5.5432 | 5.5432 | 5.5432 | 2800.0 |
| 2008-08-05 08:18:00 | AAPL | Stock | 5.5429 | 5.5429 | 5.5321 | 5.5329 | 132916.0 |
| 2008-08-05 08:19:00 | AAPL | Stock | 5.5343 | 5.5371 | 5.5343 | 5.5371 | 16800.0 |
| 2008-08-05 08:20:00 | AAPL | Stock | 5.5346 | 5.5407 | 5.5346 | 5.54 | 64540.0 |
| 2008-08-05 08:21:00 | AAPL | Stock | 5.5407 | 5.5429 | 5.54 | 5.5411 | 227360.0 |
| 2008-08-05 08:22:00 | AAPL | Stock | 5.5411 | 5.5411 | 5.5346 | 5.5346 | 21000.0 |
| 2008-08-05 08:23:00 | AAPL | Stock | 5.5368 | 5.5368 | 5.5368 | 5.5368 | 5600.0 |
| 2008-08-05 08:25:00 | AAPL | Stock | 5.5386 | 5.5404 | 5.5361 | 5.5404 | 11200.0 |
| 2008-08-05 08:26:00 | AAPL | Stock | 5.5386 | 5.5393 | 5.5386 | 5.5393 | 53200.0 |
| 2008-08-05 08:27:00 | AAPL | Stock | 5.5393 | 5.5393 | 5.5386 | 5.5386 | 5600.0 |
> showing 50 of 1,047,237 rows — these rows as CSV