PREVIEW / stock_1min / 2006-08-03
file: by_date/stock_1min/2006/2006-08-03.parquet size: 8.6 MB rows: 708,169 symbols: 1,891
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 |
|---|---|---|---|---|---|---|---|
| 2006-08-03 07:58:00 | AAPL | Stock | 2.4304 | 2.4304 | 2.4304 | 2.4304 | 2800.0 |
| 2006-08-03 08:00:00 | AAPL | Stock | 2.425 | 2.4336 | 2.425 | 2.425 | 117600.0 |
| 2006-08-03 08:02:00 | AAPL | Stock | 2.4196 | 2.4196 | 2.4161 | 2.4161 | 14000.0 |
| 2006-08-03 08:03:00 | AAPL | Stock | 2.4161 | 2.4161 | 2.4161 | 2.4161 | 2800.0 |
| 2006-08-03 08:04:00 | AAPL | Stock | 2.4143 | 2.4146 | 2.4143 | 2.4146 | 19600.0 |
| 2006-08-03 08:06:00 | AAPL | Stock | 2.4179 | 2.4196 | 2.4179 | 2.4196 | 36400.0 |
| 2006-08-03 08:07:00 | AAPL | Stock | 2.4182 | 2.4182 | 2.4161 | 2.4161 | 21140.0 |
| 2006-08-03 08:09:00 | AAPL | Stock | 2.4161 | 2.4161 | 2.4146 | 2.4146 | 97076.0 |
| 2006-08-03 08:11:00 | AAPL | Stock | 2.4154 | 2.4154 | 2.4154 | 2.4154 | 14000.0 |
| 2006-08-03 08:12:00 | AAPL | Stock | 2.4154 | 2.4154 | 2.4107 | 2.4107 | 75600.0 |
| 2006-08-03 08:13:00 | AAPL | Stock | 2.4093 | 2.4143 | 2.3664 | 2.4143 | 377776.0 |
| 2006-08-03 08:15:00 | AAPL | Stock | 2.4032 | 2.4036 | 2.4032 | 2.4036 | 16800.0 |
| 2006-08-03 08:17:00 | AAPL | Stock | 2.4011 | 2.4011 | 2.4011 | 2.4011 | 7000.0 |
| 2006-08-03 08:18:00 | AAPL | Stock | 2.4071 | 2.4093 | 2.4036 | 2.4093 | 19600.0 |
| 2006-08-03 08:20:00 | AAPL | Stock | 2.4071 | 2.4071 | 2.4071 | 2.4071 | 16800.0 |
| 2006-08-03 08:21:00 | AAPL | Stock | 2.4036 | 2.4036 | 2.4036 | 2.4036 | 22400.0 |
| 2006-08-03 08:22:00 | AAPL | Stock | 2.4071 | 2.4071 | 2.4071 | 2.4071 | 11200.0 |
| 2006-08-03 08:23:00 | AAPL | Stock | 2.4046 | 2.4046 | 2.4043 | 2.4043 | 28000.0 |
| 2006-08-03 08:24:00 | AAPL | Stock | 2.4036 | 2.4046 | 2.4036 | 2.4043 | 30800.0 |
| 2006-08-03 08:25:00 | AAPL | Stock | 2.4043 | 2.4054 | 2.4036 | 2.4036 | 19600.0 |
| 2006-08-03 08:26:00 | AAPL | Stock | 2.4036 | 2.4036 | 2.4036 | 2.4036 | 2800.0 |
| 2006-08-03 08:27:00 | AAPL | Stock | 2.4036 | 2.4036 | 2.4036 | 2.4036 | 11200.0 |
| 2006-08-03 08:29:00 | AAPL | Stock | 2.4043 | 2.4043 | 2.4021 | 2.4021 | 78400.0 |
| 2006-08-03 08:30:00 | AAPL | Stock | 2.4036 | 2.4036 | 2.4018 | 2.4036 | 199080.0 |
| 2006-08-03 08:31:00 | AAPL | Stock | 2.4036 | 2.4039 | 2.4036 | 2.4039 | 14000.0 |
| 2006-08-03 08:33:00 | AAPL | Stock | 2.4036 | 2.4075 | 2.4036 | 2.4075 | 74200.0 |
| 2006-08-03 08:34:00 | AAPL | Stock | 2.4079 | 2.4125 | 2.4079 | 2.4125 | 171640.0 |
| 2006-08-03 08:35:00 | AAPL | Stock | 2.4143 | 2.4143 | 2.4107 | 2.4107 | 11200.0 |
| 2006-08-03 08:36:00 | AAPL | Stock | 2.4107 | 2.4143 | 2.4107 | 2.4143 | 88480.0 |
| 2006-08-03 08:37:00 | AAPL | Stock | 2.4143 | 2.4143 | 2.4143 | 2.4143 | 61600.0 |
| 2006-08-03 08:38:00 | AAPL | Stock | 2.4136 | 2.4179 | 2.4136 | 2.4136 | 92400.0 |
| 2006-08-03 08:39:00 | AAPL | Stock | 2.4179 | 2.4214 | 2.4143 | 2.4179 | 95816.0 |
| 2006-08-03 08:41:00 | AAPL | Stock | 2.4143 | 2.4143 | 2.4143 | 2.4143 | 50400.0 |
| 2006-08-03 08:42:00 | AAPL | Stock | 2.4143 | 2.4143 | 2.4111 | 2.4111 | 35560.0 |
| 2006-08-03 08:43:00 | AAPL | Stock | 2.4111 | 2.4125 | 2.4107 | 2.4125 | 47600.0 |
| 2006-08-03 08:44:00 | AAPL | Stock | 2.4125 | 2.4125 | 2.4111 | 2.4111 | 28000.0 |
| 2006-08-03 08:45:00 | AAPL | Stock | 2.4111 | 2.4125 | 2.4107 | 2.4107 | 119000.0 |
| 2006-08-03 08:46:00 | AAPL | Stock | 2.4107 | 2.4107 | 2.4107 | 2.4107 | 19600.0 |
| 2006-08-03 08:47:00 | AAPL | Stock | 2.4107 | 2.4107 | 2.4107 | 2.4107 | 23800.0 |
| 2006-08-03 08:48:00 | AAPL | Stock | 2.4107 | 2.4107 | 2.4107 | 2.4107 | 14000.0 |
| 2006-08-03 08:49:00 | AAPL | Stock | 2.4107 | 2.4107 | 2.4107 | 2.4107 | 78400.0 |
| 2006-08-03 08:50:00 | AAPL | Stock | 2.4107 | 2.4107 | 2.4107 | 2.4107 | 131600.0 |
| 2006-08-03 08:51:00 | AAPL | Stock | 2.4111 | 2.4161 | 2.4111 | 2.4161 | 133392.0 |
| 2006-08-03 08:52:00 | AAPL | Stock | 2.4161 | 2.4175 | 2.4161 | 2.4175 | 42000.0 |
| 2006-08-03 08:53:00 | AAPL | Stock | 2.4164 | 2.4164 | 2.4161 | 2.4161 | 16800.0 |
| 2006-08-03 08:54:00 | AAPL | Stock | 2.4136 | 2.4161 | 2.4136 | 2.4161 | 18256.0 |
| 2006-08-03 08:55:00 | AAPL | Stock | 2.4161 | 2.4161 | 2.4161 | 2.4161 | 8400.0 |
| 2006-08-03 08:56:00 | AAPL | Stock | 2.4161 | 2.4164 | 2.4161 | 2.4161 | 50400.0 |
| 2006-08-03 08:57:00 | AAPL | Stock | 2.4125 | 2.4125 | 2.4125 | 2.4125 | 11200.0 |
| 2006-08-03 08:58:00 | AAPL | Stock | 2.4161 | 2.4164 | 2.4157 | 2.4161 | 82264.0 |
> showing 50 of 708,169 rows — these rows as CSV