PREVIEW / stock_1min / 2004-06-14
file: by_date/stock_1min/2004/2004-06-14.parquet size: 6.1 MB rows: 522,955 symbols: 1,466
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 |
|---|---|---|---|---|---|---|---|
| 2004-06-14 08:01:00 | AAPL | Stock | 0.5455 | 0.5455 | 0.5455 | 0.5455 | 56000.0 |
| 2004-06-14 08:05:00 | AAPL | Stock | 0.5446 | 0.5446 | 0.5446 | 0.5446 | 5600.0 |
| 2004-06-14 08:14:00 | AAPL | Stock | 0.5445 | 0.5445 | 0.5445 | 0.5445 | 22400.0 |
| 2004-06-14 08:17:00 | AAPL | Stock | 0.5446 | 0.5446 | 0.5446 | 0.5446 | 50400.0 |
| 2004-06-14 08:19:00 | AAPL | Stock | 0.5448 | 0.5448 | 0.5448 | 0.5448 | 22400.0 |
| 2004-06-14 08:20:00 | AAPL | Stock | 0.5448 | 0.5448 | 0.5448 | 0.5448 | 5600.0 |
| 2004-06-14 08:21:00 | AAPL | Stock | 0.5446 | 0.5446 | 0.5446 | 0.5446 | 28000.0 |
| 2004-06-14 08:28:00 | AAPL | Stock | 0.5446 | 0.5446 | 0.5446 | 0.5446 | 5600.0 |
| 2004-06-14 08:29:00 | AAPL | Stock | 0.5489 | 0.5489 | 0.5489 | 0.5489 | 72800.0 |
| 2004-06-14 08:32:00 | AAPL | Stock | 0.5446 | 0.5446 | 0.5446 | 0.5446 | 28000.0 |
| 2004-06-14 08:39:00 | AAPL | Stock | 0.5438 | 0.5438 | 0.5438 | 0.5438 | 5600.0 |
| 2004-06-14 08:41:00 | AAPL | Stock | 0.5446 | 0.5446 | 0.5446 | 0.5446 | 56000.0 |
| 2004-06-14 08:49:00 | AAPL | Stock | 0.5454 | 0.5454 | 0.5454 | 0.5454 | 5600.0 |
| 2004-06-14 08:51:00 | AAPL | Stock | 0.5454 | 0.5454 | 0.5454 | 0.5454 | 25200.0 |
| 2004-06-14 08:55:00 | AAPL | Stock | 0.5454 | 0.5455 | 0.5454 | 0.5455 | 53200.0 |
| 2004-06-14 09:14:00 | AAPL | Stock | 0.5455 | 0.5455 | 0.5455 | 0.5455 | 22400.0 |
| 2004-06-14 09:18:00 | AAPL | Stock | 0.5459 | 0.5459 | 0.5459 | 0.5459 | 5600.0 |
| 2004-06-14 09:26:00 | AAPL | Stock | 0.5455 | 0.5455 | 0.5454 | 0.5454 | 112000.0 |
| 2004-06-14 09:27:00 | AAPL | Stock | 0.5455 | 0.5455 | 0.5455 | 0.5455 | 7000.0 |
| 2004-06-14 09:29:00 | AAPL | Stock | 0.5463 | 0.5477 | 0.545 | 0.5473 | 468944.0 |
| 2004-06-14 09:30:00 | AAPL | Stock | 0.5473 | 0.5479 | 0.5455 | 0.5459 | 5562144.0 |
| 2004-06-14 09:31:00 | AAPL | Stock | 0.5454 | 0.547 | 0.5443 | 0.545 | 1508472.0 |
| 2004-06-14 09:32:00 | AAPL | Stock | 0.545 | 0.5455 | 0.545 | 0.5454 | 406168.0 |
| 2004-06-14 09:33:00 | AAPL | Stock | 0.545 | 0.5455 | 0.545 | 0.545 | 1412096.0 |
| 2004-06-14 09:34:00 | AAPL | Stock | 0.545 | 0.545 | 0.5439 | 0.5439 | 1716400.0 |
| 2004-06-14 09:35:00 | AAPL | Stock | 0.5438 | 0.5446 | 0.5427 | 0.5436 | 1824144.0 |
| 2004-06-14 09:36:00 | AAPL | Stock | 0.5438 | 0.5443 | 0.5436 | 0.5443 | 596792.0 |
| 2004-06-14 09:37:00 | AAPL | Stock | 0.5443 | 0.5448 | 0.5441 | 0.5445 | 2052736.0 |
| 2004-06-14 09:38:00 | AAPL | Stock | 0.5443 | 0.5445 | 0.5443 | 0.5445 | 747880.0 |
| 2004-06-14 09:39:00 | AAPL | Stock | 0.5445 | 0.5448 | 0.5445 | 0.5446 | 886424.0 |
| 2004-06-14 09:40:00 | AAPL | Stock | 0.5446 | 0.5446 | 0.5443 | 0.5443 | 1198288.0 |
| 2004-06-14 09:41:00 | AAPL | Stock | 0.5443 | 0.5445 | 0.5439 | 0.5441 | 870800.0 |
| 2004-06-14 09:42:00 | AAPL | Stock | 0.5439 | 0.5441 | 0.5436 | 0.5438 | 595336.0 |
| 2004-06-14 09:43:00 | AAPL | Stock | 0.5438 | 0.5439 | 0.5434 | 0.5436 | 700392.0 |
| 2004-06-14 09:44:00 | AAPL | Stock | 0.5434 | 0.5436 | 0.5434 | 0.5434 | 1067472.0 |
| 2004-06-14 09:45:00 | AAPL | Stock | 0.5436 | 0.5438 | 0.5434 | 0.5436 | 711200.0 |
| 2004-06-14 09:46:00 | AAPL | Stock | 0.5436 | 0.5436 | 0.5429 | 0.5429 | 1802248.0 |
| 2004-06-14 09:47:00 | AAPL | Stock | 0.5429 | 0.5432 | 0.5429 | 0.5432 | 763672.0 |
| 2004-06-14 09:48:00 | AAPL | Stock | 0.5429 | 0.5432 | 0.5427 | 0.5429 | 1041600.0 |
| 2004-06-14 09:49:00 | AAPL | Stock | 0.5429 | 0.543 | 0.5429 | 0.543 | 865536.0 |
| 2004-06-14 09:50:00 | AAPL | Stock | 0.5432 | 0.5436 | 0.5429 | 0.5432 | 764400.0 |
| 2004-06-14 09:51:00 | AAPL | Stock | 0.5432 | 0.5438 | 0.5431 | 0.5432 | 773864.0 |
| 2004-06-14 09:52:00 | AAPL | Stock | 0.543 | 0.5434 | 0.543 | 0.5434 | 201600.0 |
| 2004-06-14 09:53:00 | AAPL | Stock | 0.5436 | 0.5441 | 0.5434 | 0.5441 | 935480.0 |
| 2004-06-14 09:54:00 | AAPL | Stock | 0.5441 | 0.5443 | 0.5441 | 0.5443 | 330400.0 |
| 2004-06-14 09:55:00 | AAPL | Stock | 0.5439 | 0.5443 | 0.5438 | 0.5443 | 479808.0 |
| 2004-06-14 09:56:00 | AAPL | Stock | 0.5438 | 0.5438 | 0.5438 | 0.5438 | 140000.0 |
| 2004-06-14 09:57:00 | AAPL | Stock | 0.5439 | 0.5441 | 0.5439 | 0.5439 | 854560.0 |
| 2004-06-14 09:58:00 | AAPL | Stock | 0.5439 | 0.5439 | 0.5436 | 0.5436 | 632800.0 |
| 2004-06-14 09:59:00 | AAPL | Stock | 0.5434 | 0.5446 | 0.5432 | 0.5443 | 806400.0 |
> showing 50 of 522,955 rows — these rows as CSV