PREVIEW / stock_1min / 2010-05-03
file: by_date/stock_1min/2010/2010-05-03.parquet size: 13.8 MB rows: 1,037,729 symbols: 2,850
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 |
|---|---|---|---|---|---|---|---|
| 2010-05-03 04:16:00 | AAPL | Stock | 9.3704 | 9.3704 | 9.3704 | 9.3704 | 2800.0 |
| 2010-05-03 06:13:00 | AAPL | Stock | 9.3429 | 9.3429 | 9.3429 | 9.3429 | 11200.0 |
| 2010-05-03 06:14:00 | AAPL | Stock | 9.3318 | 9.3318 | 9.3318 | 9.3318 | 2800.0 |
| 2010-05-03 06:23:00 | AAPL | Stock | 9.3321 | 9.3321 | 9.3321 | 9.3321 | 5600.0 |
| 2010-05-03 06:25:00 | AAPL | Stock | 9.3396 | 9.3396 | 9.3396 | 9.3396 | 2800.0 |
| 2010-05-03 06:30:00 | AAPL | Stock | 9.3396 | 9.3396 | 9.3396 | 9.3396 | 5600.0 |
| 2010-05-03 06:33:00 | AAPL | Stock | 9.3414 | 9.3414 | 9.3414 | 9.3414 | 5600.0 |
| 2010-05-03 06:46:00 | AAPL | Stock | 9.3554 | 9.3568 | 9.3554 | 9.3568 | 11200.0 |
| 2010-05-03 06:48:00 | AAPL | Stock | 9.3575 | 9.3575 | 9.3575 | 9.3575 | 16800.0 |
| 2010-05-03 06:51:00 | AAPL | Stock | 9.3579 | 9.3579 | 9.3579 | 9.3579 | 2800.0 |
| 2010-05-03 06:56:00 | AAPL | Stock | 9.36 | 9.3604 | 9.36 | 9.3604 | 14000.0 |
| 2010-05-03 06:58:00 | AAPL | Stock | 9.3679 | 9.3679 | 9.3679 | 9.3679 | 2800.0 |
| 2010-05-03 06:59:00 | AAPL | Stock | 9.3679 | 9.3679 | 9.3679 | 9.3679 | 5600.0 |
| 2010-05-03 07:02:00 | AAPL | Stock | 9.3814 | 9.3818 | 9.3814 | 9.3818 | 5600.0 |
| 2010-05-03 07:03:00 | AAPL | Stock | 9.3818 | 9.3832 | 9.3818 | 9.3832 | 8400.0 |
| 2010-05-03 07:05:00 | AAPL | Stock | 9.3871 | 9.3907 | 9.3871 | 9.3907 | 19600.0 |
| 2010-05-03 07:07:00 | AAPL | Stock | 9.3996 | 9.3996 | 9.3996 | 9.3996 | 5600.0 |
| 2010-05-03 07:08:00 | AAPL | Stock | 9.4068 | 9.4068 | 9.4068 | 9.4068 | 2800.0 |
| 2010-05-03 07:09:00 | AAPL | Stock | 9.4071 | 9.4071 | 9.4071 | 9.4071 | 5600.0 |
| 2010-05-03 07:18:00 | AAPL | Stock | 9.4068 | 9.4068 | 9.4068 | 9.4068 | 2800.0 |
| 2010-05-03 07:20:00 | AAPL | Stock | 9.4 | 9.4 | 9.3968 | 9.3968 | 5600.0 |
| 2010-05-03 07:29:00 | AAPL | Stock | 9.3968 | 9.3968 | 9.3968 | 9.3968 | 2800.0 |
| 2010-05-03 07:30:00 | AAPL | Stock | 9.3932 | 9.3932 | 9.3839 | 9.3839 | 27580.0 |
| 2010-05-03 07:31:00 | AAPL | Stock | 9.3839 | 9.3839 | 9.3839 | 9.3839 | 5600.0 |
| 2010-05-03 07:32:00 | AAPL | Stock | 9.3843 | 9.3843 | 9.3843 | 9.3843 | 2800.0 |
| 2010-05-03 07:34:00 | AAPL | Stock | 9.3843 | 9.3843 | 9.3843 | 9.3843 | 2800.0 |
| 2010-05-03 07:38:00 | AAPL | Stock | 9.3857 | 9.3857 | 9.3857 | 9.3857 | 2800.0 |
| 2010-05-03 07:39:00 | AAPL | Stock | 9.3846 | 9.3875 | 9.3846 | 9.3875 | 30100.0 |
| 2010-05-03 07:46:00 | AAPL | Stock | 9.3929 | 9.3929 | 9.3929 | 9.3929 | 2800.0 |
| 2010-05-03 07:49:00 | AAPL | Stock | 9.3946 | 9.3946 | 9.3946 | 9.3946 | 7000.0 |
| 2010-05-03 07:50:00 | AAPL | Stock | 9.3946 | 9.3946 | 9.3946 | 9.3946 | 21000.0 |
| 2010-05-03 07:51:00 | AAPL | Stock | 9.3979 | 9.3982 | 9.3979 | 9.3982 | 28000.0 |
| 2010-05-03 07:52:00 | AAPL | Stock | 9.4011 | 9.4014 | 9.4011 | 9.4014 | 28000.0 |
| 2010-05-03 07:53:00 | AAPL | Stock | 9.4014 | 9.4125 | 9.4014 | 9.4125 | 126000.0 |
| 2010-05-03 07:54:00 | AAPL | Stock | 9.4132 | 9.4161 | 9.4132 | 9.4132 | 86800.0 |
| 2010-05-03 07:55:00 | AAPL | Stock | 9.4154 | 9.4164 | 9.4154 | 9.4164 | 32200.0 |
| 2010-05-03 07:56:00 | AAPL | Stock | 9.4168 | 9.4179 | 9.4168 | 9.4179 | 8400.0 |
| 2010-05-03 07:57:00 | AAPL | Stock | 9.4179 | 9.4179 | 9.4179 | 9.4179 | 5600.0 |
| 2010-05-03 07:58:00 | AAPL | Stock | 9.4071 | 9.4071 | 9.4071 | 9.4071 | 19600.0 |
| 2010-05-03 07:59:00 | AAPL | Stock | 9.4089 | 9.4161 | 9.4089 | 9.4161 | 42000.0 |
| 2010-05-03 08:00:00 | AAPL | Stock | 9.4161 | 9.4161 | 9.3246 | 9.3964 | 154560.0 |
| 2010-05-03 08:01:00 | AAPL | Stock | 9.3946 | 9.4054 | 9.3946 | 9.4054 | 49756.0 |
| 2010-05-03 08:02:00 | AAPL | Stock | 9.4032 | 9.4036 | 9.3929 | 9.4032 | 65660.0 |
| 2010-05-03 08:03:00 | AAPL | Stock | 9.3996 | 9.4054 | 9.3968 | 9.3968 | 24360.0 |
| 2010-05-03 08:04:00 | AAPL | Stock | 9.3982 | 9.3982 | 9.3929 | 9.3929 | 23800.0 |
| 2010-05-03 08:05:00 | AAPL | Stock | 9.3932 | 9.4054 | 9.3932 | 9.4054 | 73976.0 |
| 2010-05-03 08:06:00 | AAPL | Stock | 9.4036 | 9.405 | 9.4036 | 9.4039 | 14000.0 |
| 2010-05-03 08:07:00 | AAPL | Stock | 9.4036 | 9.4039 | 9.4036 | 9.4039 | 11200.0 |
| 2010-05-03 08:08:00 | AAPL | Stock | 9.4037 | 9.4039 | 9.4036 | 9.4036 | 11200.0 |
| 2010-05-03 08:09:00 | AAPL | Stock | 9.4054 | 9.4054 | 9.4046 | 9.4046 | 7000.0 |
> showing 50 of 1,037,729 rows — these rows as CSV