PREVIEW / stock_1min / 2006-08-18
file: by_date/stock_1min/2006/2006-08-18.parquet size: 7.8 MB rows: 636,675 symbols: 1,900
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-18 08:01:00 | AAPL | Stock | 2.4136 | 2.4136 | 2.4107 | 2.4107 | 5600.0 |
| 2006-08-18 08:06:00 | AAPL | Stock | 2.4107 | 2.4107 | 2.4107 | 2.4107 | 8400.0 |
| 2006-08-18 08:07:00 | AAPL | Stock | 2.4071 | 2.4071 | 2.4071 | 2.4071 | 47600.0 |
| 2006-08-18 08:11:00 | AAPL | Stock | 2.4075 | 2.4075 | 2.4075 | 2.4075 | 2800.0 |
| 2006-08-18 08:14:00 | AAPL | Stock | 2.4075 | 2.4075 | 2.4075 | 2.4075 | 28000.0 |
| 2006-08-18 08:15:00 | AAPL | Stock | 2.4125 | 2.4125 | 2.4104 | 2.4104 | 5600.0 |
| 2006-08-18 08:17:00 | AAPL | Stock | 2.4075 | 2.4075 | 2.4075 | 2.4075 | 14000.0 |
| 2006-08-18 08:20:00 | AAPL | Stock | 2.4089 | 2.4089 | 2.4089 | 2.4089 | 2800.0 |
| 2006-08-18 08:21:00 | AAPL | Stock | 2.4079 | 2.4104 | 2.4079 | 2.4104 | 42140.0 |
| 2006-08-18 08:22:00 | AAPL | Stock | 2.4075 | 2.4075 | 2.4075 | 2.4075 | 10920.0 |
| 2006-08-18 08:23:00 | AAPL | Stock | 2.4071 | 2.4089 | 2.4071 | 2.4089 | 43400.0 |
| 2006-08-18 08:24:00 | AAPL | Stock | 2.4089 | 2.4089 | 2.4089 | 2.4089 | 44800.0 |
| 2006-08-18 08:29:00 | AAPL | Stock | 2.4071 | 2.4071 | 2.4071 | 2.4071 | 7280.0 |
| 2006-08-18 08:30:00 | AAPL | Stock | 2.4054 | 2.4054 | 2.4054 | 2.4054 | 28000.0 |
| 2006-08-18 08:32:00 | AAPL | Stock | 2.4036 | 2.4036 | 2.4036 | 2.4036 | 11200.0 |
| 2006-08-18 08:35:00 | AAPL | Stock | 2.405 | 2.4054 | 2.4039 | 2.4039 | 30800.0 |
| 2006-08-18 08:36:00 | AAPL | Stock | 2.4039 | 2.4039 | 2.4039 | 2.4039 | 14000.0 |
| 2006-08-18 08:37:00 | AAPL | Stock | 2.4039 | 2.4039 | 2.4039 | 2.4039 | 5600.0 |
| 2006-08-18 08:38:00 | AAPL | Stock | 2.4054 | 2.4054 | 2.4054 | 2.4054 | 7000.0 |
| 2006-08-18 08:40:00 | AAPL | Stock | 2.4039 | 2.4039 | 2.4039 | 2.4039 | 51520.0 |
| 2006-08-18 08:41:00 | AAPL | Stock | 2.405 | 2.405 | 2.405 | 2.405 | 2800.0 |
| 2006-08-18 08:42:00 | AAPL | Stock | 2.4071 | 2.4075 | 2.405 | 2.4075 | 61600.0 |
| 2006-08-18 08:43:00 | AAPL | Stock | 2.4068 | 2.4086 | 2.4068 | 2.4086 | 16520.0 |
| 2006-08-18 08:44:00 | AAPL | Stock | 2.4071 | 2.4089 | 2.4071 | 2.4089 | 16800.0 |
| 2006-08-18 08:46:00 | AAPL | Stock | 2.4071 | 2.4071 | 2.4071 | 2.4071 | 5040.0 |
| 2006-08-18 08:47:00 | AAPL | Stock | 2.4071 | 2.4071 | 2.4054 | 2.4054 | 16800.0 |
| 2006-08-18 08:48:00 | AAPL | Stock | 2.4054 | 2.4054 | 2.4054 | 2.4054 | 6160.0 |
| 2006-08-18 08:54:00 | AAPL | Stock | 2.4071 | 2.4071 | 2.4071 | 2.4071 | 50400.0 |
| 2006-08-18 08:55:00 | AAPL | Stock | 2.4071 | 2.4071 | 2.4071 | 2.4071 | 118636.0 |
| 2006-08-18 08:56:00 | AAPL | Stock | 2.4082 | 2.4089 | 2.4082 | 2.4089 | 11200.0 |
| 2006-08-18 08:58:00 | AAPL | Stock | 2.4089 | 2.4089 | 2.4089 | 2.4089 | 5600.0 |
| 2006-08-18 08:59:00 | AAPL | Stock | 2.4089 | 2.4089 | 2.4089 | 2.4089 | 14000.0 |
| 2006-08-18 09:01:00 | AAPL | Stock | 2.4089 | 2.4089 | 2.4089 | 2.4089 | 5600.0 |
| 2006-08-18 09:04:00 | AAPL | Stock | 2.4089 | 2.4089 | 2.4089 | 2.4089 | 84000.0 |
| 2006-08-18 09:06:00 | AAPL | Stock | 2.4079 | 2.4079 | 2.4075 | 2.4075 | 50036.0 |
| 2006-08-18 09:07:00 | AAPL | Stock | 2.4075 | 2.4075 | 2.4075 | 2.4075 | 16800.0 |
| 2006-08-18 09:08:00 | AAPL | Stock | 2.4071 | 2.4071 | 2.4071 | 2.4071 | 8400.0 |
| 2006-08-18 09:09:00 | AAPL | Stock | 2.4082 | 2.4082 | 2.4082 | 2.4082 | 35000.0 |
| 2006-08-18 09:14:00 | AAPL | Stock | 2.4071 | 2.4071 | 2.4071 | 2.4071 | 56000.0 |
| 2006-08-18 09:16:00 | AAPL | Stock | 2.4054 | 2.4054 | 2.4043 | 2.4054 | 40600.0 |
| 2006-08-18 09:19:00 | AAPL | Stock | 2.4082 | 2.4082 | 2.4082 | 2.4082 | 14000.0 |
| 2006-08-18 09:21:00 | AAPL | Stock | 2.4079 | 2.4079 | 2.4079 | 2.4079 | 2800.0 |
| 2006-08-18 09:22:00 | AAPL | Stock | 2.4082 | 2.4089 | 2.4082 | 2.4089 | 13300.0 |
| 2006-08-18 09:23:00 | AAPL | Stock | 2.4089 | 2.4089 | 2.4089 | 2.4089 | 4200.0 |
| 2006-08-18 09:24:00 | AAPL | Stock | 2.4089 | 2.4089 | 2.4089 | 2.4089 | 2800.0 |
| 2006-08-18 09:25:00 | AAPL | Stock | 2.4064 | 2.4064 | 2.4064 | 2.4064 | 2800.0 |
| 2006-08-18 09:27:00 | AAPL | Stock | 2.4089 | 2.4089 | 2.4089 | 2.4089 | 11200.0 |
| 2006-08-18 09:28:00 | AAPL | Stock | 2.4093 | 2.4157 | 2.4089 | 2.4157 | 162400.0 |
| 2006-08-18 09:29:00 | AAPL | Stock | 2.4143 | 2.4196 | 2.4118 | 2.4193 | 943152.0 |
| 2006-08-18 09:30:00 | AAPL | Stock | 2.4182 | 2.4196 | 2.4089 | 2.4112 | 32678800.0 |
> showing 50 of 636,675 rows — these rows as CSV