PREVIEW / stock_1min / 2008-01-08
file: by_date/stock_1min/2008/2008-01-08.parquet size: 13.1 MB rows: 1,054,013 symbols: 2,665
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-01-08 04:15:00 | AAPL | Stock | 6.3804 | 6.3804 | 6.3786 | 6.3786 | 5600.0 |
| 2008-01-08 05:19:00 | AAPL | Stock | 6.4054 | 6.4054 | 6.4054 | 6.4054 | 2800.0 |
| 2008-01-08 05:22:00 | AAPL | Stock | 6.3786 | 6.3786 | 6.3786 | 6.3786 | 2800.0 |
| 2008-01-08 05:25:00 | AAPL | Stock | 6.3857 | 6.3857 | 6.3857 | 6.3857 | 2800.0 |
| 2008-01-08 05:32:00 | AAPL | Stock | 6.375 | 6.375 | 6.375 | 6.375 | 2800.0 |
| 2008-01-08 05:34:00 | AAPL | Stock | 6.375 | 6.375 | 6.3714 | 6.3714 | 11200.0 |
| 2008-01-08 05:35:00 | AAPL | Stock | 6.3607 | 6.3607 | 6.3607 | 6.3607 | 2800.0 |
| 2008-01-08 06:56:00 | AAPL | Stock | 6.4054 | 6.4054 | 6.4054 | 6.4054 | 2800.0 |
| 2008-01-08 07:00:00 | AAPL | Stock | 6.3964 | 6.3964 | 6.3964 | 6.3964 | 2800.0 |
| 2008-01-08 07:01:00 | AAPL | Stock | 6.3964 | 6.3964 | 6.3964 | 6.3964 | 2800.0 |
| 2008-01-08 07:02:00 | AAPL | Stock | 6.3932 | 6.4111 | 6.3932 | 6.4111 | 68600.0 |
| 2008-01-08 07:03:00 | AAPL | Stock | 6.4068 | 6.4175 | 6.4068 | 6.4175 | 5600.0 |
| 2008-01-08 07:04:00 | AAPL | Stock | 6.4179 | 6.4179 | 6.4179 | 6.4179 | 12600.0 |
| 2008-01-08 07:12:00 | AAPL | Stock | 6.4157 | 6.4157 | 6.4157 | 6.4157 | 12600.0 |
| 2008-01-08 07:13:00 | AAPL | Stock | 6.4107 | 6.4107 | 6.4107 | 6.4107 | 50400.0 |
| 2008-01-08 07:14:00 | AAPL | Stock | 6.4107 | 6.4107 | 6.4107 | 6.4107 | 60200.0 |
| 2008-01-08 07:18:00 | AAPL | Stock | 6.4139 | 6.4161 | 6.4139 | 6.4161 | 9800.0 |
| 2008-01-08 07:23:00 | AAPL | Stock | 6.4179 | 6.4189 | 6.4179 | 6.4189 | 50400.0 |
| 2008-01-08 07:26:00 | AAPL | Stock | 6.4189 | 6.4189 | 6.4189 | 6.4189 | 25200.0 |
| 2008-01-08 07:27:00 | AAPL | Stock | 6.4189 | 6.4189 | 6.4189 | 6.4189 | 30800.0 |
| 2008-01-08 07:28:00 | AAPL | Stock | 6.4189 | 6.4286 | 6.4189 | 6.4193 | 49000.0 |
| 2008-01-08 07:29:00 | AAPL | Stock | 6.4279 | 6.4279 | 6.4279 | 6.4279 | 11200.0 |
| 2008-01-08 07:30:00 | AAPL | Stock | 6.4464 | 6.4464 | 6.4357 | 6.4425 | 47600.0 |
| 2008-01-08 07:31:00 | AAPL | Stock | 6.4425 | 6.4429 | 6.4425 | 6.4429 | 28000.0 |
| 2008-01-08 07:33:00 | AAPL | Stock | 6.4286 | 6.4293 | 6.4286 | 6.4293 | 30800.0 |
| 2008-01-08 07:34:00 | AAPL | Stock | 6.4282 | 6.4282 | 6.4282 | 6.4282 | 12040.0 |
| 2008-01-08 07:35:00 | AAPL | Stock | 6.4282 | 6.4282 | 6.4282 | 6.4282 | 5600.0 |
| 2008-01-08 07:36:00 | AAPL | Stock | 6.4282 | 6.4282 | 6.4282 | 6.4282 | 8400.0 |
| 2008-01-08 07:37:00 | AAPL | Stock | 6.4286 | 6.4286 | 6.4286 | 6.4286 | 5600.0 |
| 2008-01-08 07:46:00 | AAPL | Stock | 6.4107 | 6.4107 | 6.4107 | 6.4107 | 2800.0 |
| 2008-01-08 07:47:00 | AAPL | Stock | 6.4107 | 6.4132 | 6.4107 | 6.4132 | 19600.0 |
| 2008-01-08 07:48:00 | AAPL | Stock | 6.4193 | 6.4193 | 6.4193 | 6.4193 | 2800.0 |
| 2008-01-08 07:49:00 | AAPL | Stock | 6.4196 | 6.4196 | 6.4161 | 6.4161 | 16800.0 |
| 2008-01-08 07:50:00 | AAPL | Stock | 6.4132 | 6.4132 | 6.4125 | 6.4125 | 14000.0 |
| 2008-01-08 07:51:00 | AAPL | Stock | 6.4125 | 6.4129 | 6.4125 | 6.4129 | 5600.0 |
| 2008-01-08 07:52:00 | AAPL | Stock | 6.4132 | 6.4132 | 6.4132 | 6.4132 | 2800.0 |
| 2008-01-08 07:53:00 | AAPL | Stock | 6.4143 | 6.4161 | 6.4143 | 6.4143 | 67200.0 |
| 2008-01-08 07:54:00 | AAPL | Stock | 6.4143 | 6.4143 | 6.4107 | 6.4143 | 11200.0 |
| 2008-01-08 07:55:00 | AAPL | Stock | 6.4071 | 6.4104 | 6.4071 | 6.4096 | 39200.0 |
| 2008-01-08 07:56:00 | AAPL | Stock | 6.4104 | 6.4104 | 6.4071 | 6.4071 | 14000.0 |
| 2008-01-08 07:57:00 | AAPL | Stock | 6.4068 | 6.4139 | 6.4068 | 6.4107 | 18200.0 |
| 2008-01-08 07:59:00 | AAPL | Stock | 6.4107 | 6.4107 | 6.4107 | 6.4107 | 7000.0 |
| 2008-01-08 08:00:00 | AAPL | Stock | 6.4136 | 6.4282 | 6.4071 | 6.4157 | 254940.0 |
| 2008-01-08 08:01:00 | AAPL | Stock | 6.4193 | 6.4193 | 6.4071 | 6.4139 | 175112.0 |
| 2008-01-08 08:02:00 | AAPL | Stock | 6.4118 | 6.4157 | 6.4036 | 6.4036 | 131488.0 |
| 2008-01-08 08:03:00 | AAPL | Stock | 6.4036 | 6.4107 | 6.3929 | 6.3964 | 365400.0 |
| 2008-01-08 08:04:00 | AAPL | Stock | 6.3971 | 6.4014 | 6.3929 | 6.3968 | 173040.0 |
| 2008-01-08 08:05:00 | AAPL | Stock | 6.3968 | 6.4036 | 6.3936 | 6.4036 | 385840.0 |
| 2008-01-08 08:06:00 | AAPL | Stock | 6.4079 | 6.4107 | 6.4071 | 6.4089 | 263200.0 |
| 2008-01-08 08:07:00 | AAPL | Stock | 6.4096 | 6.4096 | 6.4068 | 6.4071 | 77840.0 |
> showing 50 of 1,054,013 rows — these rows as CSV