PREVIEW / stock_1min / 2009-03-16
file: by_date/stock_1min/2009/2009-03-16.parquet size: 12.5 MB rows: 958,155 symbols: 2,707
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 |
|---|---|---|---|---|---|---|---|
| 2009-03-16 05:59:00 | AAPL | Stock | 3.4768 | 3.4768 | 3.4768 | 3.4768 | 25200.0 |
| 2009-03-16 06:00:00 | AAPL | Stock | 3.4768 | 3.4768 | 3.4768 | 3.4768 | 2800.0 |
| 2009-03-16 06:03:00 | AAPL | Stock | 3.4821 | 3.4821 | 3.4821 | 3.4821 | 47600.0 |
| 2009-03-16 07:23:00 | AAPL | Stock | 3.4821 | 3.4821 | 3.4821 | 3.4821 | 5600.0 |
| 2009-03-16 07:27:00 | AAPL | Stock | 3.4779 | 3.4779 | 3.4779 | 3.4779 | 2800.0 |
| 2009-03-16 07:41:00 | AAPL | Stock | 3.4821 | 3.4821 | 3.4821 | 3.4821 | 2800.0 |
| 2009-03-16 07:54:00 | AAPL | Stock | 3.4904 | 3.4904 | 3.4904 | 3.4904 | 2800.0 |
| 2009-03-16 08:00:00 | AAPL | Stock | 3.4836 | 3.4904 | 3.4804 | 3.4821 | 54180.0 |
| 2009-03-16 08:01:00 | AAPL | Stock | 3.4821 | 3.4821 | 3.4821 | 3.4821 | 7000.0 |
| 2009-03-16 08:02:00 | AAPL | Stock | 3.4821 | 3.4843 | 3.4821 | 3.4821 | 42000.0 |
| 2009-03-16 08:05:00 | AAPL | Stock | 3.4804 | 3.4804 | 3.4796 | 3.4804 | 19600.0 |
| 2009-03-16 08:11:00 | AAPL | Stock | 3.4804 | 3.4804 | 3.4804 | 3.4804 | 2800.0 |
| 2009-03-16 08:12:00 | AAPL | Stock | 3.4804 | 3.4804 | 3.4804 | 3.4804 | 3500.0 |
| 2009-03-16 08:13:00 | AAPL | Stock | 3.4757 | 3.4804 | 3.4757 | 3.4804 | 30800.0 |
| 2009-03-16 08:14:00 | AAPL | Stock | 3.48 | 3.48 | 3.48 | 3.48 | 2800.0 |
| 2009-03-16 08:17:00 | AAPL | Stock | 3.4757 | 3.4757 | 3.4757 | 3.4757 | 9240.0 |
| 2009-03-16 08:19:00 | AAPL | Stock | 3.4732 | 3.4732 | 3.4675 | 3.4675 | 35000.0 |
| 2009-03-16 08:22:00 | AAPL | Stock | 3.4679 | 3.4679 | 3.4675 | 3.4675 | 5600.0 |
| 2009-03-16 08:23:00 | AAPL | Stock | 3.47 | 3.47 | 3.47 | 3.47 | 11200.0 |
| 2009-03-16 08:24:00 | AAPL | Stock | 3.465 | 3.465 | 3.465 | 3.465 | 2800.0 |
| 2009-03-16 08:25:00 | AAPL | Stock | 3.4654 | 3.4654 | 3.4643 | 3.4643 | 37800.0 |
| 2009-03-16 08:27:00 | AAPL | Stock | 3.4614 | 3.4629 | 3.4614 | 3.4629 | 16100.0 |
| 2009-03-16 08:28:00 | AAPL | Stock | 3.4661 | 3.4661 | 3.4661 | 3.4661 | 2800.0 |
| 2009-03-16 08:29:00 | AAPL | Stock | 3.4632 | 3.4632 | 3.4589 | 3.4589 | 15792.0 |
| 2009-03-16 08:30:00 | AAPL | Stock | 3.4625 | 3.4625 | 3.46 | 3.46 | 5600.0 |
| 2009-03-16 08:31:00 | AAPL | Stock | 3.4589 | 3.46 | 3.4589 | 3.46 | 51520.0 |
| 2009-03-16 08:32:00 | AAPL | Stock | 3.4589 | 3.4593 | 3.4571 | 3.4593 | 25872.0 |
| 2009-03-16 08:33:00 | AAPL | Stock | 3.4579 | 3.46 | 3.4579 | 3.46 | 16772.0 |
| 2009-03-16 08:34:00 | AAPL | Stock | 3.4582 | 3.4646 | 3.4582 | 3.4646 | 42112.0 |
| 2009-03-16 08:35:00 | AAPL | Stock | 3.4643 | 3.4643 | 3.4643 | 3.4643 | 8400.0 |
| 2009-03-16 08:36:00 | AAPL | Stock | 3.4589 | 3.46 | 3.4571 | 3.4571 | 14000.0 |
| 2009-03-16 08:37:00 | AAPL | Stock | 3.4632 | 3.4643 | 3.4575 | 3.4643 | 87360.0 |
| 2009-03-16 08:41:00 | AAPL | Stock | 3.4661 | 3.4661 | 3.4643 | 3.4643 | 19600.0 |
| 2009-03-16 08:42:00 | AAPL | Stock | 3.4639 | 3.4643 | 3.4639 | 3.4643 | 19600.0 |
| 2009-03-16 08:43:00 | AAPL | Stock | 3.4639 | 3.4643 | 3.4614 | 3.4614 | 12040.0 |
| 2009-03-16 08:44:00 | AAPL | Stock | 3.4632 | 3.4643 | 3.4632 | 3.4643 | 47600.0 |
| 2009-03-16 08:46:00 | AAPL | Stock | 3.4679 | 3.4679 | 3.4679 | 3.4679 | 2800.0 |
| 2009-03-16 08:48:00 | AAPL | Stock | 3.4643 | 3.4682 | 3.4643 | 3.4661 | 56000.0 |
| 2009-03-16 08:51:00 | AAPL | Stock | 3.4671 | 3.4671 | 3.4643 | 3.4643 | 26040.0 |
| 2009-03-16 08:53:00 | AAPL | Stock | 3.4643 | 3.4643 | 3.4643 | 3.4643 | 14840.0 |
| 2009-03-16 08:55:00 | AAPL | Stock | 3.4661 | 3.4661 | 3.4661 | 3.4661 | 8400.0 |
| 2009-03-16 08:56:00 | AAPL | Stock | 3.4654 | 3.4654 | 3.4625 | 3.4625 | 122920.0 |
| 2009-03-16 08:57:00 | AAPL | Stock | 3.4643 | 3.4643 | 3.4643 | 3.4643 | 14000.0 |
| 2009-03-16 08:58:00 | AAPL | Stock | 3.4643 | 3.4643 | 3.4643 | 3.4643 | 14000.0 |
| 2009-03-16 08:59:00 | AAPL | Stock | 3.4589 | 3.4589 | 3.4589 | 3.4589 | 10220.0 |
| 2009-03-16 09:01:00 | AAPL | Stock | 3.4593 | 3.4593 | 3.4582 | 3.4582 | 68180.0 |
| 2009-03-16 09:02:00 | AAPL | Stock | 3.4571 | 3.4571 | 3.455 | 3.455 | 23128.0 |
| 2009-03-16 09:03:00 | AAPL | Stock | 3.455 | 3.455 | 3.4536 | 3.4536 | 25200.0 |
| 2009-03-16 09:04:00 | AAPL | Stock | 3.4543 | 3.455 | 3.4543 | 3.455 | 14000.0 |
| 2009-03-16 09:05:00 | AAPL | Stock | 3.4554 | 3.4554 | 3.4554 | 3.4554 | 28000.0 |
> showing 50 of 958,155 rows — these rows as CSV