PREVIEW / stock_1min / 2012-02-23
file: by_date/stock_1min/2012/2012-02-23.parquet size: 13.2 MB rows: 979,755 symbols: 2,854
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 |
|---|---|---|---|---|---|---|---|
| 2012-02-23 04:02:00 | AAPL | Stock | 18.3929 | 18.3929 | 18.3929 | 18.3929 | 14000.0 |
| 2012-02-23 04:03:00 | AAPL | Stock | 18.3929 | 18.3929 | 18.3929 | 18.3929 | 5600.0 |
| 2012-02-23 04:05:00 | AAPL | Stock | 18.3929 | 18.3929 | 18.3929 | 18.3929 | 2800.0 |
| 2012-02-23 04:06:00 | AAPL | Stock | 18.3929 | 18.3929 | 18.3929 | 18.3929 | 5600.0 |
| 2012-02-23 04:08:00 | AAPL | Stock | 18.3929 | 18.3929 | 18.3929 | 18.3929 | 2800.0 |
| 2012-02-23 04:11:00 | AAPL | Stock | 18.4054 | 18.4054 | 18.4054 | 18.4054 | 2800.0 |
| 2012-02-23 04:17:00 | AAPL | Stock | 18.405 | 18.4054 | 18.405 | 18.4054 | 5600.0 |
| 2012-02-23 04:34:00 | AAPL | Stock | 18.3904 | 18.3904 | 18.3904 | 18.3904 | 2800.0 |
| 2012-02-23 04:40:00 | AAPL | Stock | 18.375 | 18.375 | 18.375 | 18.375 | 8120.0 |
| 2012-02-23 04:44:00 | AAPL | Stock | 18.3654 | 18.3654 | 18.3614 | 18.3614 | 5600.0 |
| 2012-02-23 04:45:00 | AAPL | Stock | 18.3611 | 18.3611 | 18.3611 | 18.3611 | 5600.0 |
| 2012-02-23 04:49:00 | AAPL | Stock | 18.3596 | 18.3596 | 18.3596 | 18.3596 | 2800.0 |
| 2012-02-23 04:52:00 | AAPL | Stock | 18.3821 | 18.3821 | 18.3821 | 18.3821 | 8400.0 |
| 2012-02-23 04:53:00 | AAPL | Stock | 18.3821 | 18.3821 | 18.3821 | 18.3821 | 2800.0 |
| 2012-02-23 04:54:00 | AAPL | Stock | 18.3821 | 18.3821 | 18.3821 | 18.3821 | 11200.0 |
| 2012-02-23 04:55:00 | AAPL | Stock | 18.3821 | 18.3821 | 18.3821 | 18.3821 | 5600.0 |
| 2012-02-23 05:02:00 | AAPL | Stock | 18.375 | 18.375 | 18.375 | 18.375 | 2800.0 |
| 2012-02-23 05:15:00 | AAPL | Stock | 18.3786 | 18.3786 | 18.3786 | 18.3786 | 5600.0 |
| 2012-02-23 05:17:00 | AAPL | Stock | 18.3786 | 18.3786 | 18.3786 | 18.3786 | 19600.0 |
| 2012-02-23 05:26:00 | AAPL | Stock | 18.3575 | 18.3575 | 18.3575 | 18.3575 | 16800.0 |
| 2012-02-23 05:30:00 | AAPL | Stock | 18.375 | 18.375 | 18.375 | 18.375 | 2800.0 |
| 2012-02-23 05:38:00 | AAPL | Stock | 18.3679 | 18.3679 | 18.3679 | 18.3679 | 28000.0 |
| 2012-02-23 05:39:00 | AAPL | Stock | 18.3575 | 18.3575 | 18.3575 | 18.3575 | 2800.0 |
| 2012-02-23 05:54:00 | AAPL | Stock | 18.3407 | 18.3571 | 18.3407 | 18.3571 | 16800.0 |
| 2012-02-23 05:59:00 | AAPL | Stock | 18.3571 | 18.3571 | 18.3571 | 18.3571 | 15120.0 |
| 2012-02-23 06:05:00 | AAPL | Stock | 18.3679 | 18.3679 | 18.3679 | 18.3679 | 56000.0 |
| 2012-02-23 06:07:00 | AAPL | Stock | 18.3707 | 18.3707 | 18.3707 | 18.3707 | 2800.0 |
| 2012-02-23 06:08:00 | AAPL | Stock | 18.3679 | 18.3679 | 18.3679 | 18.3679 | 2800.0 |
| 2012-02-23 06:09:00 | AAPL | Stock | 18.3643 | 18.3643 | 18.3643 | 18.3643 | 2800.0 |
| 2012-02-23 06:11:00 | AAPL | Stock | 18.3571 | 18.3571 | 18.3571 | 18.3571 | 8400.0 |
| 2012-02-23 06:20:00 | AAPL | Stock | 18.3679 | 18.3679 | 18.3679 | 18.3679 | 38360.0 |
| 2012-02-23 07:00:00 | AAPL | Stock | 18.3736 | 18.3736 | 18.3571 | 18.3571 | 14140.0 |
| 2012-02-23 07:01:00 | AAPL | Stock | 18.3575 | 18.3711 | 18.3575 | 18.3711 | 10164.0 |
| 2012-02-23 07:02:00 | AAPL | Stock | 18.375 | 18.375 | 18.375 | 18.375 | 2800.0 |
| 2012-02-23 07:03:00 | AAPL | Stock | 18.375 | 18.3786 | 18.3732 | 18.3786 | 30800.0 |
| 2012-02-23 07:04:00 | AAPL | Stock | 18.375 | 18.375 | 18.3718 | 18.3718 | 19600.0 |
| 2012-02-23 07:05:00 | AAPL | Stock | 18.3804 | 18.3804 | 18.3786 | 18.3786 | 8400.0 |
| 2012-02-23 07:06:00 | AAPL | Stock | 18.3718 | 18.3718 | 18.3714 | 18.3714 | 24444.0 |
| 2012-02-23 07:07:00 | AAPL | Stock | 18.375 | 18.375 | 18.3718 | 18.375 | 29428.0 |
| 2012-02-23 07:08:00 | AAPL | Stock | 18.3782 | 18.3782 | 18.3782 | 18.3782 | 2800.0 |
| 2012-02-23 07:11:00 | AAPL | Stock | 18.3804 | 18.3804 | 18.3732 | 18.3732 | 11200.0 |
| 2012-02-23 07:12:00 | AAPL | Stock | 18.38 | 18.3804 | 18.38 | 18.38 | 8400.0 |
| 2012-02-23 07:13:00 | AAPL | Stock | 18.3796 | 18.3839 | 18.375 | 18.3754 | 24220.0 |
| 2012-02-23 07:14:00 | AAPL | Stock | 18.3754 | 18.3754 | 18.3754 | 18.3754 | 3500.0 |
| 2012-02-23 07:18:00 | AAPL | Stock | 18.3804 | 18.3804 | 18.3804 | 18.3804 | 16800.0 |
| 2012-02-23 07:19:00 | AAPL | Stock | 18.3804 | 18.3804 | 18.3804 | 18.3804 | 5600.0 |
| 2012-02-23 07:20:00 | AAPL | Stock | 18.3821 | 18.3821 | 18.3821 | 18.3821 | 8400.0 |
| 2012-02-23 07:23:00 | AAPL | Stock | 18.3821 | 18.3821 | 18.3821 | 18.3821 | 16800.0 |
| 2012-02-23 07:24:00 | AAPL | Stock | 18.3818 | 18.3818 | 18.3818 | 18.3818 | 2800.0 |
| 2012-02-23 07:25:00 | AAPL | Stock | 18.3821 | 18.3821 | 18.3821 | 18.3821 | 2800.0 |
> showing 50 of 979,755 rows — these rows as CSV