PREVIEW / stock_1min / 2008-04-07
file: by_date/stock_1min/2008/2008-04-07.parquet size: 12.1 MB rows: 980,229 symbols: 2,676
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-04-07 04:21:00 | AAPL | Stock | 5.5118 | 5.5118 | 5.5118 | 5.5118 | 2800.0 |
| 2008-04-07 04:36:00 | AAPL | Stock | 5.5039 | 5.5039 | 5.5039 | 5.5039 | 25200.0 |
| 2008-04-07 05:14:00 | AAPL | Stock | 5.5232 | 5.5279 | 5.5232 | 5.5279 | 5600.0 |
| 2008-04-07 05:15:00 | AAPL | Stock | 5.5354 | 5.5354 | 5.5354 | 5.5354 | 2800.0 |
| 2008-04-07 05:31:00 | AAPL | Stock | 5.5446 | 5.5464 | 5.5446 | 5.5464 | 25760.0 |
| 2008-04-07 05:32:00 | AAPL | Stock | 5.5511 | 5.5511 | 5.5511 | 5.5511 | 11200.0 |
| 2008-04-07 06:39:00 | AAPL | Stock | 5.5536 | 5.5536 | 5.5536 | 5.5536 | 84000.0 |
| 2008-04-07 06:40:00 | AAPL | Stock | 5.5625 | 5.5625 | 5.5625 | 5.5625 | 25200.0 |
| 2008-04-07 06:41:00 | AAPL | Stock | 5.5625 | 5.5679 | 5.5571 | 5.5679 | 11200.0 |
| 2008-04-07 06:42:00 | AAPL | Stock | 5.5571 | 5.5575 | 5.5571 | 5.5571 | 16800.0 |
| 2008-04-07 06:43:00 | AAPL | Stock | 5.5679 | 5.5679 | 5.5571 | 5.5571 | 47600.0 |
| 2008-04-07 06:47:00 | AAPL | Stock | 5.5679 | 5.5679 | 5.5679 | 5.5679 | 8400.0 |
| 2008-04-07 06:49:00 | AAPL | Stock | 5.5686 | 5.5743 | 5.5686 | 5.5714 | 58800.0 |
| 2008-04-07 06:51:00 | AAPL | Stock | 5.5625 | 5.5625 | 5.5625 | 5.5625 | 28000.0 |
| 2008-04-07 06:56:00 | AAPL | Stock | 5.555 | 5.555 | 5.5536 | 5.5536 | 42000.0 |
| 2008-04-07 06:57:00 | AAPL | Stock | 5.5536 | 5.5536 | 5.5536 | 5.5536 | 53200.0 |
| 2008-04-07 06:59:00 | AAPL | Stock | 5.5536 | 5.5536 | 5.5536 | 5.5536 | 2800.0 |
| 2008-04-07 07:02:00 | AAPL | Stock | 5.5436 | 5.5475 | 5.5436 | 5.5475 | 11200.0 |
| 2008-04-07 07:03:00 | AAPL | Stock | 5.5436 | 5.5436 | 5.5436 | 5.5436 | 19040.0 |
| 2008-04-07 07:04:00 | AAPL | Stock | 5.5536 | 5.5536 | 5.5536 | 5.5536 | 23268.0 |
| 2008-04-07 07:07:00 | AAPL | Stock | 5.5439 | 5.5536 | 5.5439 | 5.5536 | 48496.0 |
| 2008-04-07 07:08:00 | AAPL | Stock | 5.5536 | 5.5536 | 5.5536 | 5.5536 | 38164.0 |
| 2008-04-07 07:09:00 | AAPL | Stock | 5.5536 | 5.5536 | 5.5536 | 5.5536 | 6132.0 |
| 2008-04-07 07:11:00 | AAPL | Stock | 5.5536 | 5.5536 | 5.5536 | 5.5536 | 5600.0 |
| 2008-04-07 07:13:00 | AAPL | Stock | 5.5439 | 5.5439 | 5.5321 | 5.5321 | 28000.0 |
| 2008-04-07 07:18:00 | AAPL | Stock | 5.5529 | 5.5529 | 5.5521 | 5.5521 | 56000.0 |
| 2008-04-07 07:21:00 | AAPL | Stock | 5.5536 | 5.5536 | 5.5536 | 5.5536 | 2800.0 |
| 2008-04-07 07:26:00 | AAPL | Stock | 5.555 | 5.5568 | 5.555 | 5.5568 | 30100.0 |
| 2008-04-07 07:30:00 | AAPL | Stock | 5.5586 | 5.5586 | 5.5586 | 5.5586 | 2800.0 |
| 2008-04-07 07:31:00 | AAPL | Stock | 5.5554 | 5.5554 | 5.5554 | 5.5554 | 11200.0 |
| 2008-04-07 07:34:00 | AAPL | Stock | 5.5571 | 5.5571 | 5.5571 | 5.5571 | 5600.0 |
| 2008-04-07 07:35:00 | AAPL | Stock | 5.5571 | 5.5571 | 5.5571 | 5.5571 | 8288.0 |
| 2008-04-07 07:36:00 | AAPL | Stock | 5.5589 | 5.5679 | 5.5589 | 5.5679 | 39200.0 |
| 2008-04-07 07:41:00 | AAPL | Stock | 5.5664 | 5.5664 | 5.5554 | 5.5554 | 56700.0 |
| 2008-04-07 07:45:00 | AAPL | Stock | 5.5554 | 5.5554 | 5.5554 | 5.5554 | 25900.0 |
| 2008-04-07 07:48:00 | AAPL | Stock | 5.5557 | 5.5557 | 5.5536 | 5.5536 | 33544.0 |
| 2008-04-07 07:49:00 | AAPL | Stock | 5.5482 | 5.5482 | 5.5357 | 5.5357 | 98000.0 |
| 2008-04-07 07:53:00 | AAPL | Stock | 5.5529 | 5.5536 | 5.5529 | 5.5536 | 66948.0 |
| 2008-04-07 07:55:00 | AAPL | Stock | 5.5575 | 5.5589 | 5.5571 | 5.5571 | 34076.0 |
| 2008-04-07 07:59:00 | AAPL | Stock | 5.5596 | 5.56 | 5.5596 | 5.56 | 33600.0 |
| 2008-04-07 08:00:00 | AAPL | Stock | 5.5582 | 5.56 | 5.5482 | 5.5571 | 437332.0 |
| 2008-04-07 08:01:00 | AAPL | Stock | 5.5568 | 5.5568 | 5.5529 | 5.5529 | 93240.0 |
| 2008-04-07 08:02:00 | AAPL | Stock | 5.5554 | 5.5554 | 5.5504 | 5.5536 | 30268.0 |
| 2008-04-07 08:03:00 | AAPL | Stock | 5.5518 | 5.5518 | 5.5446 | 5.5461 | 223384.0 |
| 2008-04-07 08:04:00 | AAPL | Stock | 5.5443 | 5.5471 | 5.5407 | 5.5464 | 109312.0 |
| 2008-04-07 08:05:00 | AAPL | Stock | 5.5482 | 5.5482 | 5.5432 | 5.5464 | 99400.0 |
| 2008-04-07 08:06:00 | AAPL | Stock | 5.5464 | 5.5464 | 5.5446 | 5.5464 | 98560.0 |
| 2008-04-07 08:07:00 | AAPL | Stock | 5.5464 | 5.5482 | 5.5464 | 5.5471 | 58324.0 |
| 2008-04-07 08:08:00 | AAPL | Stock | 5.5489 | 5.5525 | 5.5489 | 5.5525 | 47600.0 |
| 2008-04-07 08:09:00 | AAPL | Stock | 5.5536 | 5.5546 | 5.5529 | 5.5536 | 47600.0 |
> showing 50 of 980,229 rows — these rows as CSV