PREVIEW / stock_1min / 2012-03-26
file: by_date/stock_1min/2012/2012-03-26.parquet size: 13.4 MB rows: 994,849 symbols: 2,876
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-03-26 04:00:00 | AAPL | Stock | 21.3571 | 21.3571 | 21.3571 | 21.3571 | 2800.0 |
| 2012-03-26 04:46:00 | AAPL | Stock | 21.3514 | 21.3514 | 21.3514 | 21.3514 | 8400.0 |
| 2012-03-26 05:13:00 | AAPL | Stock | 21.3071 | 21.3071 | 21.3071 | 21.3071 | 2800.0 |
| 2012-03-26 05:35:00 | AAPL | Stock | 21.3214 | 21.3214 | 21.3214 | 21.3214 | 8316.0 |
| 2012-03-26 05:38:00 | AAPL | Stock | 21.3214 | 21.3214 | 21.3214 | 21.3214 | 5600.0 |
| 2012-03-26 05:39:00 | AAPL | Stock | 21.3214 | 21.3214 | 21.3214 | 21.3214 | 9996.0 |
| 2012-03-26 06:15:00 | AAPL | Stock | 21.3446 | 21.3496 | 21.3446 | 21.3496 | 56000.0 |
| 2012-03-26 06:16:00 | AAPL | Stock | 21.3482 | 21.3518 | 21.3482 | 21.3518 | 72800.0 |
| 2012-03-26 06:17:00 | AAPL | Stock | 21.3568 | 21.3571 | 21.3568 | 21.3571 | 113148.0 |
| 2012-03-26 06:18:00 | AAPL | Stock | 21.3571 | 21.3571 | 21.3571 | 21.3571 | 56000.0 |
| 2012-03-26 06:19:00 | AAPL | Stock | 21.3571 | 21.3571 | 21.3571 | 21.3571 | 77504.0 |
| 2012-03-26 06:35:00 | AAPL | Stock | 21.3625 | 21.3625 | 21.3625 | 21.3625 | 2800.0 |
| 2012-03-26 06:43:00 | AAPL | Stock | 21.3611 | 21.3611 | 21.3611 | 21.3611 | 2800.0 |
| 2012-03-26 06:51:00 | AAPL | Stock | 21.3486 | 21.3486 | 21.3486 | 21.3486 | 2800.0 |
| 2012-03-26 06:52:00 | AAPL | Stock | 21.3493 | 21.3493 | 21.3493 | 21.3493 | 2884.0 |
| 2012-03-26 06:55:00 | AAPL | Stock | 21.3611 | 21.3611 | 21.3611 | 21.3611 | 5600.0 |
| 2012-03-26 07:00:00 | AAPL | Stock | 21.3611 | 21.3611 | 21.3493 | 21.3571 | 13440.0 |
| 2012-03-26 07:01:00 | AAPL | Stock | 21.3571 | 21.3571 | 21.3571 | 21.3571 | 2800.0 |
| 2012-03-26 07:02:00 | AAPL | Stock | 21.3589 | 21.3611 | 21.3589 | 21.3611 | 12040.0 |
| 2012-03-26 07:04:00 | AAPL | Stock | 21.3679 | 21.3768 | 21.3679 | 21.3768 | 27916.0 |
| 2012-03-26 07:05:00 | AAPL | Stock | 21.375 | 21.375 | 21.3611 | 21.3611 | 38220.0 |
| 2012-03-26 07:08:00 | AAPL | Stock | 21.3732 | 21.3746 | 21.3732 | 21.3746 | 6580.0 |
| 2012-03-26 07:11:00 | AAPL | Stock | 21.3714 | 21.3775 | 21.3679 | 21.3679 | 58800.0 |
| 2012-03-26 07:12:00 | AAPL | Stock | 21.3768 | 21.3768 | 21.3768 | 21.3768 | 2800.0 |
| 2012-03-26 07:13:00 | AAPL | Stock | 21.375 | 21.375 | 21.375 | 21.375 | 5600.0 |
| 2012-03-26 07:14:00 | AAPL | Stock | 21.3925 | 21.3925 | 21.3925 | 21.3925 | 4508.0 |
| 2012-03-26 07:16:00 | AAPL | Stock | 21.3893 | 21.3929 | 21.3886 | 21.3929 | 37884.0 |
| 2012-03-26 07:17:00 | AAPL | Stock | 21.3964 | 21.3982 | 21.3961 | 21.3961 | 26320.0 |
| 2012-03-26 07:18:00 | AAPL | Stock | 21.3929 | 21.4107 | 21.3929 | 21.4107 | 87780.0 |
| 2012-03-26 07:19:00 | AAPL | Stock | 21.3971 | 21.3971 | 21.3929 | 21.3929 | 11200.0 |
| 2012-03-26 07:21:00 | AAPL | Stock | 21.3929 | 21.3929 | 21.3929 | 21.3929 | 2800.0 |
| 2012-03-26 07:26:00 | AAPL | Stock | 21.3925 | 21.3925 | 21.3811 | 21.3832 | 11200.0 |
| 2012-03-26 07:27:00 | AAPL | Stock | 21.3839 | 21.3839 | 21.3786 | 21.3786 | 11200.0 |
| 2012-03-26 07:30:00 | AAPL | Stock | 21.3839 | 21.3893 | 21.3839 | 21.3893 | 31780.0 |
| 2012-03-26 07:31:00 | AAPL | Stock | 21.4018 | 21.4018 | 21.3964 | 21.4 | 18200.0 |
| 2012-03-26 07:32:00 | AAPL | Stock | 21.3939 | 21.3939 | 21.3893 | 21.3893 | 14000.0 |
| 2012-03-26 07:34:00 | AAPL | Stock | 21.3839 | 21.3839 | 21.3839 | 21.3839 | 5040.0 |
| 2012-03-26 07:37:00 | AAPL | Stock | 21.3839 | 21.3839 | 21.375 | 21.375 | 17024.0 |
| 2012-03-26 07:39:00 | AAPL | Stock | 21.3821 | 21.3821 | 21.3821 | 21.3821 | 4200.0 |
| 2012-03-26 07:43:00 | AAPL | Stock | 21.3821 | 21.3821 | 21.3821 | 21.3821 | 3304.0 |
| 2012-03-26 07:44:00 | AAPL | Stock | 21.3907 | 21.3921 | 21.3907 | 21.3921 | 14140.0 |
| 2012-03-26 07:46:00 | AAPL | Stock | 21.3893 | 21.3893 | 21.3893 | 21.3893 | 7840.0 |
| 2012-03-26 07:47:00 | AAPL | Stock | 21.3921 | 21.3929 | 21.3893 | 21.3929 | 76720.0 |
| 2012-03-26 07:48:00 | AAPL | Stock | 21.3921 | 21.3921 | 21.3921 | 21.3921 | 2800.0 |
| 2012-03-26 07:49:00 | AAPL | Stock | 21.3889 | 21.3893 | 21.3857 | 21.3857 | 25060.0 |
| 2012-03-26 07:54:00 | AAPL | Stock | 21.3882 | 21.3882 | 21.3839 | 21.3839 | 11200.0 |
| 2012-03-26 07:57:00 | AAPL | Stock | 21.3839 | 21.3839 | 21.3786 | 21.3786 | 30296.0 |
| 2012-03-26 07:58:00 | AAPL | Stock | 21.3804 | 21.3804 | 21.3804 | 21.3804 | 2800.0 |
| 2012-03-26 07:59:00 | AAPL | Stock | 21.3821 | 21.3821 | 21.3821 | 21.3821 | 2800.0 |
| 2012-03-26 08:00:00 | AAPL | Stock | 21.3832 | 21.3868 | 21.345 | 21.375 | 361228.0 |
> showing 50 of 994,849 rows — these rows as CSV