PREVIEW / stock_1min / 2009-05-26
file: by_date/stock_1min/2009/2009-05-26.parquet size: 13.2 MB rows: 1,006,602 symbols: 2,714
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-05-26 04:15:00 | AAPL | Stock | 4.3843 | 4.3843 | 4.3843 | 4.3843 | 2800.0 |
| 2009-05-26 05:06:00 | AAPL | Stock | 4.3836 | 4.3839 | 4.3836 | 4.3839 | 19600.0 |
| 2009-05-26 05:07:00 | AAPL | Stock | 4.385 | 4.385 | 4.385 | 4.385 | 5656.0 |
| 2009-05-26 05:11:00 | AAPL | Stock | 4.3907 | 4.4032 | 4.3907 | 4.4032 | 23100.0 |
| 2009-05-26 05:20:00 | AAPL | Stock | 4.4179 | 4.4268 | 4.4143 | 4.4143 | 39200.0 |
| 2009-05-26 05:23:00 | AAPL | Stock | 4.4464 | 4.4464 | 4.4464 | 4.4464 | 36400.0 |
| 2009-05-26 05:27:00 | AAPL | Stock | 4.4321 | 4.4321 | 4.4286 | 4.4286 | 33600.0 |
| 2009-05-26 06:05:00 | AAPL | Stock | 4.4536 | 4.4536 | 4.4536 | 4.4536 | 7000.0 |
| 2009-05-26 06:21:00 | AAPL | Stock | 4.4557 | 4.4557 | 4.4557 | 4.4557 | 5600.0 |
| 2009-05-26 06:23:00 | AAPL | Stock | 4.4557 | 4.4557 | 4.4557 | 4.4557 | 5600.0 |
| 2009-05-26 06:25:00 | AAPL | Stock | 4.4561 | 4.4561 | 4.4561 | 4.4561 | 2800.0 |
| 2009-05-26 06:32:00 | AAPL | Stock | 4.4643 | 4.4643 | 4.4643 | 4.4643 | 56000.0 |
| 2009-05-26 06:41:00 | AAPL | Stock | 4.4643 | 4.4643 | 4.4643 | 4.4643 | 39200.0 |
| 2009-05-26 06:45:00 | AAPL | Stock | 4.4557 | 4.4557 | 4.4557 | 4.4557 | 7000.0 |
| 2009-05-26 06:46:00 | AAPL | Stock | 4.4554 | 4.4554 | 4.4554 | 4.4554 | 8400.0 |
| 2009-05-26 06:47:00 | AAPL | Stock | 4.4554 | 4.4554 | 4.4554 | 4.4554 | 2800.0 |
| 2009-05-26 06:49:00 | AAPL | Stock | 4.4554 | 4.4643 | 4.4554 | 4.4643 | 39200.0 |
| 2009-05-26 06:51:00 | AAPL | Stock | 4.4643 | 4.4643 | 4.4643 | 4.4643 | 82600.0 |
| 2009-05-26 06:53:00 | AAPL | Stock | 4.4643 | 4.4643 | 4.4643 | 4.4643 | 35000.0 |
| 2009-05-26 06:54:00 | AAPL | Stock | 4.4561 | 4.4561 | 4.4561 | 4.4561 | 28000.0 |
| 2009-05-26 06:55:00 | AAPL | Stock | 4.4561 | 4.4561 | 4.4561 | 4.4561 | 16800.0 |
| 2009-05-26 06:56:00 | AAPL | Stock | 4.4643 | 4.4643 | 4.4643 | 4.4643 | 16800.0 |
| 2009-05-26 07:00:00 | AAPL | Stock | 4.4643 | 4.4643 | 4.4643 | 4.4643 | 11200.0 |
| 2009-05-26 07:02:00 | AAPL | Stock | 4.4725 | 4.4725 | 4.4725 | 4.4725 | 19600.0 |
| 2009-05-26 07:03:00 | AAPL | Stock | 4.4725 | 4.4732 | 4.4725 | 4.4732 | 5600.0 |
| 2009-05-26 07:04:00 | AAPL | Stock | 4.4814 | 4.4821 | 4.4814 | 4.4821 | 14000.0 |
| 2009-05-26 07:05:00 | AAPL | Stock | 4.4821 | 4.4821 | 4.4821 | 4.4821 | 2800.0 |
| 2009-05-26 07:06:00 | AAPL | Stock | 4.4821 | 4.4821 | 4.4821 | 4.4821 | 5600.0 |
| 2009-05-26 07:09:00 | AAPL | Stock | 4.4839 | 4.4839 | 4.4839 | 4.4839 | 28000.0 |
| 2009-05-26 07:10:00 | AAPL | Stock | 4.4839 | 4.4839 | 4.4839 | 4.4839 | 14000.0 |
| 2009-05-26 07:15:00 | AAPL | Stock | 4.4789 | 4.4839 | 4.4789 | 4.4839 | 12600.0 |
| 2009-05-26 07:16:00 | AAPL | Stock | 4.4786 | 4.4786 | 4.4786 | 4.4786 | 22400.0 |
| 2009-05-26 07:17:00 | AAPL | Stock | 4.4786 | 4.4786 | 4.4786 | 4.4786 | 5600.0 |
| 2009-05-26 07:18:00 | AAPL | Stock | 4.4821 | 4.4839 | 4.4814 | 4.4839 | 64400.0 |
| 2009-05-26 07:21:00 | AAPL | Stock | 4.4821 | 4.4839 | 4.4821 | 4.4839 | 8400.0 |
| 2009-05-26 07:22:00 | AAPL | Stock | 4.4821 | 4.4821 | 4.4821 | 4.4821 | 30100.0 |
| 2009-05-26 07:24:00 | AAPL | Stock | 4.4782 | 4.4782 | 4.4782 | 4.4782 | 2800.0 |
| 2009-05-26 07:25:00 | AAPL | Stock | 4.4818 | 4.4821 | 4.4782 | 4.4782 | 22400.0 |
| 2009-05-26 07:31:00 | AAPL | Stock | 4.475 | 4.4804 | 4.475 | 4.4804 | 23520.0 |
| 2009-05-26 07:35:00 | AAPL | Stock | 4.4779 | 4.4804 | 4.4779 | 4.4804 | 44800.0 |
| 2009-05-26 07:36:00 | AAPL | Stock | 4.4779 | 4.4804 | 4.4779 | 4.4804 | 28896.0 |
| 2009-05-26 07:37:00 | AAPL | Stock | 4.4736 | 4.4736 | 4.4732 | 4.4732 | 103488.0 |
| 2009-05-26 07:39:00 | AAPL | Stock | 4.4732 | 4.4732 | 4.4732 | 4.4732 | 5600.0 |
| 2009-05-26 07:43:00 | AAPL | Stock | 4.4729 | 4.4729 | 4.4729 | 4.4729 | 14000.0 |
| 2009-05-26 07:45:00 | AAPL | Stock | 4.4729 | 4.4729 | 4.4729 | 4.4729 | 5600.0 |
| 2009-05-26 07:46:00 | AAPL | Stock | 4.4721 | 4.4721 | 4.4721 | 4.4721 | 22400.0 |
| 2009-05-26 07:47:00 | AAPL | Stock | 4.4664 | 4.4664 | 4.4664 | 4.4664 | 5600.0 |
| 2009-05-26 07:49:00 | AAPL | Stock | 4.4668 | 4.4668 | 4.4668 | 4.4668 | 5600.0 |
| 2009-05-26 07:50:00 | AAPL | Stock | 4.4696 | 4.4696 | 4.4696 | 4.4696 | 8400.0 |
| 2009-05-26 07:51:00 | AAPL | Stock | 4.4679 | 4.4679 | 4.4679 | 4.4679 | 2800.0 |
> showing 50 of 1,006,602 rows — these rows as CSV