PREVIEW / stock_1min / 2013-06-13
file: by_date/stock_1min/2013/2013-06-13.parquet size: 13.4 MB rows: 981,350 symbols: 2,820
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 |
|---|---|---|---|---|---|---|---|
| 2013-06-13 04:00:00 | AAPL | Stock | 15.4214 | 15.4214 | 15.2696 | 15.2696 | 27244.0 |
| 2013-06-13 04:02:00 | AAPL | Stock | 15.3571 | 15.4257 | 15.3571 | 15.4257 | 11200.0 |
| 2013-06-13 04:33:00 | AAPL | Stock | 15.3168 | 15.3168 | 15.3168 | 15.3168 | 2800.0 |
| 2013-06-13 04:38:00 | AAPL | Stock | 15.3036 | 15.3036 | 15.3036 | 15.3036 | 2800.0 |
| 2013-06-13 05:00:00 | AAPL | Stock | 15.2896 | 15.2896 | 15.2896 | 15.2896 | 2800.0 |
| 2013-06-13 05:14:00 | AAPL | Stock | 15.3164 | 15.3164 | 15.3164 | 15.3164 | 17780.0 |
| 2013-06-13 05:23:00 | AAPL | Stock | 15.3093 | 15.3093 | 15.3093 | 15.3093 | 7000.0 |
| 2013-06-13 05:24:00 | AAPL | Stock | 15.2946 | 15.3214 | 15.2946 | 15.3214 | 28000.0 |
| 2013-06-13 05:29:00 | AAPL | Stock | 15.3243 | 15.3243 | 15.3243 | 15.3243 | 14000.0 |
| 2013-06-13 05:30:00 | AAPL | Stock | 15.3243 | 15.3243 | 15.3243 | 15.3243 | 2800.0 |
| 2013-06-13 05:32:00 | AAPL | Stock | 15.3214 | 15.3214 | 15.3214 | 15.3214 | 14000.0 |
| 2013-06-13 05:42:00 | AAPL | Stock | 15.3282 | 15.3286 | 15.3282 | 15.3286 | 5600.0 |
| 2013-06-13 06:31:00 | AAPL | Stock | 15.3896 | 15.3896 | 15.3896 | 15.3896 | 2800.0 |
| 2013-06-13 06:34:00 | AAPL | Stock | 15.3882 | 15.3882 | 15.3882 | 15.3882 | 5600.0 |
| 2013-06-13 06:43:00 | AAPL | Stock | 15.3904 | 15.3904 | 15.3904 | 15.3904 | 5320.0 |
| 2013-06-13 06:47:00 | AAPL | Stock | 15.3829 | 15.3829 | 15.3829 | 15.3829 | 13692.0 |
| 2013-06-13 06:54:00 | AAPL | Stock | 15.3814 | 15.3814 | 15.3814 | 15.3814 | 2800.0 |
| 2013-06-13 07:00:00 | AAPL | Stock | 15.3879 | 15.3889 | 15.3875 | 15.3889 | 42000.0 |
| 2013-06-13 07:01:00 | AAPL | Stock | 15.375 | 15.375 | 15.375 | 15.375 | 2800.0 |
| 2013-06-13 07:04:00 | AAPL | Stock | 15.3821 | 15.3821 | 15.3771 | 15.3771 | 11200.0 |
| 2013-06-13 07:05:00 | AAPL | Stock | 15.37 | 15.37 | 15.37 | 15.37 | 2800.0 |
| 2013-06-13 07:06:00 | AAPL | Stock | 15.375 | 15.375 | 15.3714 | 15.3729 | 28000.0 |
| 2013-06-13 07:08:00 | AAPL | Stock | 15.3657 | 15.3836 | 15.3611 | 15.3611 | 11200.0 |
| 2013-06-13 07:09:00 | AAPL | Stock | 15.3571 | 15.3586 | 15.3571 | 15.3586 | 5600.0 |
| 2013-06-13 07:10:00 | AAPL | Stock | 15.3571 | 15.3571 | 15.3571 | 15.3571 | 2800.0 |
| 2013-06-13 07:15:00 | AAPL | Stock | 15.3536 | 15.3536 | 15.3536 | 15.3536 | 3248.0 |
| 2013-06-13 07:16:00 | AAPL | Stock | 15.355 | 15.355 | 15.355 | 15.355 | 5544.0 |
| 2013-06-13 07:19:00 | AAPL | Stock | 15.3639 | 15.3661 | 15.3639 | 15.3661 | 57400.0 |
| 2013-06-13 07:21:00 | AAPL | Stock | 15.3661 | 15.3661 | 15.3661 | 15.3661 | 5600.0 |
| 2013-06-13 07:22:00 | AAPL | Stock | 15.3668 | 15.3668 | 15.3668 | 15.3668 | 2800.0 |
| 2013-06-13 07:30:00 | AAPL | Stock | 15.3682 | 15.3682 | 15.3679 | 15.3679 | 14000.0 |
| 2013-06-13 07:31:00 | AAPL | Stock | 15.3679 | 15.3679 | 15.3486 | 15.3486 | 67088.0 |
| 2013-06-13 07:35:00 | AAPL | Stock | 15.3668 | 15.3746 | 15.3668 | 15.3746 | 33600.0 |
| 2013-06-13 07:36:00 | AAPL | Stock | 15.3804 | 15.3839 | 15.3729 | 15.3839 | 25200.0 |
| 2013-06-13 07:38:00 | AAPL | Stock | 15.3814 | 15.3814 | 15.3814 | 15.3814 | 2800.0 |
| 2013-06-13 07:39:00 | AAPL | Stock | 15.3836 | 15.3836 | 15.3836 | 15.3836 | 2800.0 |
| 2013-06-13 07:40:00 | AAPL | Stock | 15.3929 | 15.3929 | 15.3929 | 15.3929 | 25312.0 |
| 2013-06-13 07:42:00 | AAPL | Stock | 15.3929 | 15.3929 | 15.3929 | 15.3929 | 5600.0 |
| 2013-06-13 07:51:00 | AAPL | Stock | 15.3832 | 15.3893 | 15.3818 | 15.3893 | 19600.0 |
| 2013-06-13 07:52:00 | AAPL | Stock | 15.3929 | 15.3929 | 15.3929 | 15.3929 | 5600.0 |
| 2013-06-13 07:55:00 | AAPL | Stock | 15.3771 | 15.3771 | 15.3771 | 15.3771 | 5600.0 |
| 2013-06-13 07:57:00 | AAPL | Stock | 15.3832 | 15.4096 | 15.3832 | 15.4096 | 9800.0 |
| 2013-06-13 07:58:00 | AAPL | Stock | 15.3939 | 15.3939 | 15.3814 | 15.3814 | 16800.0 |
| 2013-06-13 07:59:00 | AAPL | Stock | 15.3821 | 15.3821 | 15.3821 | 15.3821 | 2800.0 |
| 2013-06-13 08:00:00 | AAPL | Stock | 15.3804 | 15.3925 | 15.3482 | 15.3925 | 143752.0 |
| 2013-06-13 08:01:00 | AAPL | Stock | 15.3904 | 15.3907 | 15.3764 | 15.38 | 19600.0 |
| 2013-06-13 08:02:00 | AAPL | Stock | 15.3889 | 15.3921 | 15.3889 | 15.3907 | 11004.0 |
| 2013-06-13 08:03:00 | AAPL | Stock | 15.5 | 15.5 | 15.3896 | 15.3896 | 16800.0 |
| 2013-06-13 08:04:00 | AAPL | Stock | 15.3786 | 15.3879 | 15.3786 | 15.3854 | 40404.0 |
| 2013-06-13 08:05:00 | AAPL | Stock | 15.3857 | 15.3857 | 15.3761 | 15.3761 | 61404.0 |
> showing 50 of 981,350 rows — these rows as CSV