PREVIEW / stock_1min / 2008-06-19
file: by_date/stock_1min/2008/2008-06-19.parquet size: 12.2 MB rows: 980,277 symbols: 2,708
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 |
|---|---|---|---|---|---|---|---|
| 2008-06-19 05:36:00 | AAPL | Stock | 6.3857 | 6.3857 | 6.3857 | 6.3857 | 33600.0 |
| 2008-06-19 06:39:00 | AAPL | Stock | 6.3868 | 6.3868 | 6.3868 | 6.3868 | 14000.0 |
| 2008-06-19 06:40:00 | AAPL | Stock | 6.3871 | 6.3871 | 6.3871 | 6.3871 | 12264.0 |
| 2008-06-19 06:52:00 | AAPL | Stock | 6.3893 | 6.3893 | 6.3893 | 6.3893 | 16800.0 |
| 2008-06-19 06:59:00 | AAPL | Stock | 6.3893 | 6.3893 | 6.3893 | 6.3893 | 13160.0 |
| 2008-06-19 07:05:00 | AAPL | Stock | 6.3893 | 6.3893 | 6.3893 | 6.3893 | 5600.0 |
| 2008-06-19 07:13:00 | AAPL | Stock | 6.3893 | 6.3893 | 6.3893 | 6.3893 | 2800.0 |
| 2008-06-19 07:20:00 | AAPL | Stock | 6.3839 | 6.3839 | 6.3839 | 6.3839 | 14000.0 |
| 2008-06-19 07:35:00 | AAPL | Stock | 6.3889 | 6.3889 | 6.3889 | 6.3889 | 4200.0 |
| 2008-06-19 07:36:00 | AAPL | Stock | 6.3889 | 6.3929 | 6.3889 | 6.3929 | 29400.0 |
| 2008-06-19 07:38:00 | AAPL | Stock | 6.41 | 6.4104 | 6.41 | 6.4104 | 8400.0 |
| 2008-06-19 07:39:00 | AAPL | Stock | 6.3893 | 6.4071 | 6.3893 | 6.4071 | 39200.0 |
| 2008-06-19 07:40:00 | AAPL | Stock | 6.4068 | 6.4068 | 6.4068 | 6.4068 | 14000.0 |
| 2008-06-19 07:41:00 | AAPL | Stock | 6.4068 | 6.4068 | 6.4054 | 6.4054 | 19600.0 |
| 2008-06-19 07:42:00 | AAPL | Stock | 6.4054 | 6.4054 | 6.4054 | 6.4054 | 2800.0 |
| 2008-06-19 07:43:00 | AAPL | Stock | 6.405 | 6.4054 | 6.405 | 6.4054 | 27440.0 |
| 2008-06-19 07:44:00 | AAPL | Stock | 6.4054 | 6.4054 | 6.405 | 6.405 | 8400.0 |
| 2008-06-19 07:46:00 | AAPL | Stock | 6.4018 | 6.4018 | 6.4018 | 6.4018 | 2800.0 |
| 2008-06-19 07:51:00 | AAPL | Stock | 6.4043 | 6.4043 | 6.4043 | 6.4043 | 2800.0 |
| 2008-06-19 07:54:00 | AAPL | Stock | 6.4054 | 6.4054 | 6.4054 | 6.4054 | 2800.0 |
| 2008-06-19 07:55:00 | AAPL | Stock | 6.4054 | 6.4054 | 6.4054 | 6.4054 | 5600.0 |
| 2008-06-19 07:56:00 | AAPL | Stock | 6.405 | 6.4054 | 6.405 | 6.4054 | 8400.0 |
| 2008-06-19 07:58:00 | AAPL | Stock | 6.4093 | 6.4107 | 6.4093 | 6.4107 | 16800.0 |
| 2008-06-19 07:59:00 | AAPL | Stock | 6.4132 | 6.4214 | 6.4107 | 6.4107 | 63560.0 |
| 2008-06-19 08:00:00 | AAPL | Stock | 6.4107 | 6.4114 | 6.4 | 6.4061 | 68012.0 |
| 2008-06-19 08:01:00 | AAPL | Stock | 6.4054 | 6.4071 | 6.4043 | 6.4043 | 39368.0 |
| 2008-06-19 08:02:00 | AAPL | Stock | 6.4054 | 6.4125 | 6.4054 | 6.4054 | 121940.0 |
| 2008-06-19 08:03:00 | AAPL | Stock | 6.4064 | 6.41 | 6.4064 | 6.41 | 15624.0 |
| 2008-06-19 08:04:00 | AAPL | Stock | 6.4054 | 6.4054 | 6.4036 | 6.4036 | 18200.0 |
| 2008-06-19 08:05:00 | AAPL | Stock | 6.4039 | 6.4061 | 6.4039 | 6.4039 | 19600.0 |
| 2008-06-19 08:06:00 | AAPL | Stock | 6.405 | 6.4071 | 6.4018 | 6.4071 | 20496.0 |
| 2008-06-19 08:07:00 | AAPL | Stock | 6.4054 | 6.4071 | 6.4018 | 6.4025 | 142800.0 |
| 2008-06-19 08:08:00 | AAPL | Stock | 6.4018 | 6.4018 | 6.3946 | 6.395 | 58156.0 |
| 2008-06-19 08:09:00 | AAPL | Stock | 6.3993 | 6.3996 | 6.3993 | 6.3996 | 18256.0 |
| 2008-06-19 08:10:00 | AAPL | Stock | 6.3993 | 6.3993 | 6.3896 | 6.3896 | 118160.0 |
| 2008-06-19 08:11:00 | AAPL | Stock | 6.3918 | 6.3932 | 6.3918 | 6.3932 | 5600.0 |
| 2008-06-19 08:12:00 | AAPL | Stock | 6.3925 | 6.3925 | 6.3925 | 6.3925 | 23800.0 |
| 2008-06-19 08:13:00 | AAPL | Stock | 6.3929 | 6.3961 | 6.3929 | 6.3929 | 52528.0 |
| 2008-06-19 08:14:00 | AAPL | Stock | 6.3918 | 6.3921 | 6.3918 | 6.3921 | 10920.0 |
| 2008-06-19 08:15:00 | AAPL | Stock | 6.3911 | 6.3925 | 6.3893 | 6.3893 | 79800.0 |
| 2008-06-19 08:16:00 | AAPL | Stock | 6.3893 | 6.3925 | 6.3857 | 6.3857 | 39200.0 |
| 2008-06-19 08:17:00 | AAPL | Stock | 6.3857 | 6.3857 | 6.3836 | 6.3836 | 18340.0 |
| 2008-06-19 08:18:00 | AAPL | Stock | 6.3821 | 6.3821 | 6.3804 | 6.3804 | 35616.0 |
| 2008-06-19 08:19:00 | AAPL | Stock | 6.3807 | 6.3807 | 6.3782 | 6.3786 | 61908.0 |
| 2008-06-19 08:20:00 | AAPL | Stock | 6.3786 | 6.3875 | 6.3786 | 6.3871 | 66668.0 |
| 2008-06-19 08:21:00 | AAPL | Stock | 6.3854 | 6.3882 | 6.3843 | 6.3882 | 34552.0 |
| 2008-06-19 08:22:00 | AAPL | Stock | 6.3882 | 6.3914 | 6.3882 | 6.3911 | 19600.0 |
| 2008-06-19 08:23:00 | AAPL | Stock | 6.3904 | 6.3904 | 6.3857 | 6.3861 | 22400.0 |
| 2008-06-19 08:24:00 | AAPL | Stock | 6.3861 | 6.3861 | 6.3861 | 6.3861 | 11200.0 |
| 2008-06-19 08:25:00 | AAPL | Stock | 6.3936 | 6.3936 | 6.3936 | 6.3936 | 2940.0 |
> showing 50 of 980,277 rows — these rows as CSV