PREVIEW / stock_1min / 2012-01-19
file: by_date/stock_1min/2012/2012-01-19.parquet size: 12.9 MB rows: 953,176 symbols: 2,829
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-01-19 05:32:00 | AAPL | Stock | 15.3861 | 15.3861 | 15.3861 | 15.3861 | 5600.0 |
| 2012-01-19 06:04:00 | AAPL | Stock | 15.3771 | 15.3771 | 15.375 | 15.375 | 8400.0 |
| 2012-01-19 06:15:00 | AAPL | Stock | 15.3857 | 15.3857 | 15.3857 | 15.3857 | 2800.0 |
| 2012-01-19 06:21:00 | AAPL | Stock | 15.375 | 15.375 | 15.375 | 15.375 | 2800.0 |
| 2012-01-19 06:42:00 | AAPL | Stock | 15.3829 | 15.3857 | 15.3829 | 15.3857 | 11200.0 |
| 2012-01-19 06:53:00 | AAPL | Stock | 15.3857 | 15.3857 | 15.3857 | 15.3857 | 5600.0 |
| 2012-01-19 06:55:00 | AAPL | Stock | 15.3854 | 15.3854 | 15.3854 | 15.3854 | 2800.0 |
| 2012-01-19 06:59:00 | AAPL | Stock | 15.375 | 15.375 | 15.3714 | 15.3714 | 22400.0 |
| 2012-01-19 07:00:00 | AAPL | Stock | 15.3714 | 15.3714 | 15.3714 | 15.3714 | 2800.0 |
| 2012-01-19 07:03:00 | AAPL | Stock | 15.375 | 15.375 | 15.375 | 15.375 | 2800.0 |
| 2012-01-19 07:04:00 | AAPL | Stock | 15.3804 | 15.3804 | 15.3804 | 15.3804 | 2800.0 |
| 2012-01-19 07:06:00 | AAPL | Stock | 15.3675 | 15.3746 | 15.3675 | 15.3746 | 10472.0 |
| 2012-01-19 07:07:00 | AAPL | Stock | 15.3804 | 15.3804 | 15.3804 | 15.3804 | 2800.0 |
| 2012-01-19 07:15:00 | AAPL | Stock | 15.3625 | 15.3625 | 15.3625 | 15.3625 | 16800.0 |
| 2012-01-19 07:17:00 | AAPL | Stock | 15.3621 | 15.3621 | 15.3607 | 15.3607 | 32368.0 |
| 2012-01-19 07:18:00 | AAPL | Stock | 15.3621 | 15.3657 | 15.3621 | 15.3657 | 11900.0 |
| 2012-01-19 07:19:00 | AAPL | Stock | 15.3621 | 15.3661 | 15.3621 | 15.3661 | 5600.0 |
| 2012-01-19 07:20:00 | AAPL | Stock | 15.3707 | 15.3707 | 15.3707 | 15.3707 | 2800.0 |
| 2012-01-19 07:21:00 | AAPL | Stock | 15.3711 | 15.3743 | 15.3711 | 15.3743 | 8400.0 |
| 2012-01-19 07:22:00 | AAPL | Stock | 15.375 | 15.3968 | 15.375 | 15.3968 | 45220.0 |
| 2012-01-19 07:23:00 | AAPL | Stock | 15.3929 | 15.3929 | 15.3925 | 15.3925 | 5600.0 |
| 2012-01-19 07:25:00 | AAPL | Stock | 15.385 | 15.3896 | 15.3761 | 15.3896 | 36400.0 |
| 2012-01-19 07:26:00 | AAPL | Stock | 15.3871 | 15.3871 | 15.3871 | 15.3871 | 2800.0 |
| 2012-01-19 07:27:00 | AAPL | Stock | 15.3775 | 15.3775 | 15.3768 | 15.3768 | 19600.0 |
| 2012-01-19 07:30:00 | AAPL | Stock | 15.3821 | 15.3821 | 15.3821 | 15.3821 | 2800.0 |
| 2012-01-19 07:31:00 | AAPL | Stock | 15.3821 | 15.3857 | 15.3821 | 15.3857 | 11200.0 |
| 2012-01-19 07:32:00 | AAPL | Stock | 15.3857 | 15.3857 | 15.3839 | 15.3839 | 36400.0 |
| 2012-01-19 07:33:00 | AAPL | Stock | 15.3821 | 15.3821 | 15.3821 | 15.3821 | 2800.0 |
| 2012-01-19 07:34:00 | AAPL | Stock | 15.3825 | 15.3825 | 15.3825 | 15.3825 | 2800.0 |
| 2012-01-19 07:35:00 | AAPL | Stock | 15.39 | 15.39 | 15.3879 | 15.3879 | 8400.0 |
| 2012-01-19 07:36:00 | AAPL | Stock | 15.3904 | 15.3968 | 15.3904 | 15.3929 | 78344.0 |
| 2012-01-19 07:37:00 | AAPL | Stock | 15.3911 | 15.3911 | 15.3886 | 15.3886 | 24136.0 |
| 2012-01-19 07:39:00 | AAPL | Stock | 15.3882 | 15.3882 | 15.3882 | 15.3882 | 5600.0 |
| 2012-01-19 07:40:00 | AAPL | Stock | 15.3886 | 15.3886 | 15.3886 | 15.3886 | 2800.0 |
| 2012-01-19 07:41:00 | AAPL | Stock | 15.3825 | 15.3825 | 15.3821 | 15.3821 | 13720.0 |
| 2012-01-19 07:44:00 | AAPL | Stock | 15.3829 | 15.3829 | 15.3829 | 15.3829 | 4900.0 |
| 2012-01-19 07:45:00 | AAPL | Stock | 15.375 | 15.375 | 15.3714 | 15.3714 | 19600.0 |
| 2012-01-19 07:51:00 | AAPL | Stock | 15.3793 | 15.3911 | 15.3793 | 15.3911 | 19600.0 |
| 2012-01-19 07:52:00 | AAPL | Stock | 15.3904 | 15.3904 | 15.3904 | 15.3904 | 5600.0 |
| 2012-01-19 07:53:00 | AAPL | Stock | 15.3879 | 15.3879 | 15.385 | 15.385 | 11200.0 |
| 2012-01-19 07:54:00 | AAPL | Stock | 15.3846 | 15.3846 | 15.3846 | 15.3846 | 2800.0 |
| 2012-01-19 07:55:00 | AAPL | Stock | 15.3846 | 15.3846 | 15.3729 | 15.3846 | 28000.0 |
| 2012-01-19 07:57:00 | AAPL | Stock | 15.3764 | 15.3764 | 15.3764 | 15.3764 | 11200.0 |
| 2012-01-19 07:58:00 | AAPL | Stock | 15.3768 | 15.3807 | 15.3768 | 15.3807 | 14000.0 |
| 2012-01-19 07:59:00 | AAPL | Stock | 15.3761 | 15.3868 | 15.3761 | 15.3761 | 9800.0 |
| 2012-01-19 08:00:00 | AAPL | Stock | 15.375 | 15.3893 | 15.3621 | 15.3821 | 109816.0 |
| 2012-01-19 08:01:00 | AAPL | Stock | 15.3857 | 15.3893 | 15.3857 | 15.3893 | 37408.0 |
| 2012-01-19 08:02:00 | AAPL | Stock | 15.3893 | 15.3893 | 15.3843 | 15.3846 | 68320.0 |
| 2012-01-19 08:03:00 | AAPL | Stock | 15.3843 | 15.3929 | 15.3821 | 15.3929 | 48440.0 |
| 2012-01-19 08:04:00 | AAPL | Stock | 15.3132 | 15.3132 | 15.3132 | 15.3132 | 81200.0 |
> showing 50 of 953,176 rows — these rows as CSV