PREVIEW / stock_1min / 2008-06-12
file: by_date/stock_1min/2008/2008-06-12.parquet size: 12.1 MB rows: 975,574 symbols: 2,693
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-12 05:09:00 | AAPL | Stock | 6.4911 | 6.4911 | 6.4911 | 6.4911 | 5600.0 |
| 2008-06-12 05:29:00 | AAPL | Stock | 6.4821 | 6.4821 | 6.4821 | 6.4821 | 2800.0 |
| 2008-06-12 06:24:00 | AAPL | Stock | 6.4811 | 6.4811 | 6.475 | 6.475 | 14000.0 |
| 2008-06-12 06:25:00 | AAPL | Stock | 6.475 | 6.475 | 6.4589 | 6.4589 | 47600.0 |
| 2008-06-12 06:42:00 | AAPL | Stock | 6.4679 | 6.4679 | 6.4679 | 6.4679 | 16800.0 |
| 2008-06-12 06:43:00 | AAPL | Stock | 6.4679 | 6.4679 | 6.4668 | 6.4668 | 19600.0 |
| 2008-06-12 06:45:00 | AAPL | Stock | 6.475 | 6.475 | 6.475 | 6.475 | 2800.0 |
| 2008-06-12 06:47:00 | AAPL | Stock | 6.475 | 6.475 | 6.475 | 6.475 | 2800.0 |
| 2008-06-12 06:51:00 | AAPL | Stock | 6.475 | 6.475 | 6.475 | 6.475 | 19600.0 |
| 2008-06-12 07:01:00 | AAPL | Stock | 6.4914 | 6.4914 | 6.4914 | 6.4914 | 14000.0 |
| 2008-06-12 07:10:00 | AAPL | Stock | 6.4911 | 6.4911 | 6.4911 | 6.4911 | 28000.0 |
| 2008-06-12 07:12:00 | AAPL | Stock | 6.4911 | 6.5 | 6.4911 | 6.5 | 53200.0 |
| 2008-06-12 07:17:00 | AAPL | Stock | 6.5 | 6.5357 | 6.5 | 6.5179 | 168756.0 |
| 2008-06-12 07:18:00 | AAPL | Stock | 6.5268 | 6.5268 | 6.5268 | 6.5268 | 14000.0 |
| 2008-06-12 07:22:00 | AAPL | Stock | 6.5179 | 6.5179 | 6.5179 | 6.5179 | 8260.0 |
| 2008-06-12 07:23:00 | AAPL | Stock | 6.5264 | 6.5357 | 6.5264 | 6.5357 | 526400.0 |
| 2008-06-12 07:27:00 | AAPL | Stock | 6.5179 | 6.5179 | 6.5179 | 6.5179 | 5628.0 |
| 2008-06-12 07:29:00 | AAPL | Stock | 6.5179 | 6.5179 | 6.5179 | 6.5179 | 67284.0 |
| 2008-06-12 07:31:00 | AAPL | Stock | 6.5179 | 6.5179 | 6.515 | 6.515 | 62944.0 |
| 2008-06-12 07:44:00 | AAPL | Stock | 6.5071 | 6.5071 | 6.5029 | 6.5029 | 61600.0 |
| 2008-06-12 07:45:00 | AAPL | Stock | 6.5054 | 6.5057 | 6.5054 | 6.5057 | 8400.0 |
| 2008-06-12 07:47:00 | AAPL | Stock | 6.5057 | 6.5057 | 6.5054 | 6.5054 | 61264.0 |
| 2008-06-12 07:50:00 | AAPL | Stock | 6.5157 | 6.5157 | 6.5157 | 6.5157 | 6132.0 |
| 2008-06-12 07:52:00 | AAPL | Stock | 6.5179 | 6.5243 | 6.5179 | 6.5243 | 19600.0 |
| 2008-06-12 07:55:00 | AAPL | Stock | 6.5304 | 6.5304 | 6.5304 | 6.5304 | 3500.0 |
| 2008-06-12 08:00:00 | AAPL | Stock | 6.5243 | 6.5243 | 6.5089 | 6.5154 | 309484.0 |
| 2008-06-12 08:01:00 | AAPL | Stock | 6.5107 | 6.515 | 6.5107 | 6.515 | 22400.0 |
| 2008-06-12 08:02:00 | AAPL | Stock | 6.5121 | 6.5157 | 6.5121 | 6.5157 | 33600.0 |
| 2008-06-12 08:03:00 | AAPL | Stock | 6.5154 | 6.5179 | 6.5154 | 6.5164 | 98000.0 |
| 2008-06-12 08:04:00 | AAPL | Stock | 6.5164 | 6.5179 | 6.5107 | 6.5107 | 127484.0 |
| 2008-06-12 08:05:00 | AAPL | Stock | 6.5107 | 6.5107 | 6.5075 | 6.5075 | 140000.0 |
| 2008-06-12 08:06:00 | AAPL | Stock | 6.5075 | 6.5075 | 6.5036 | 6.5054 | 106680.0 |
| 2008-06-12 08:07:00 | AAPL | Stock | 6.5071 | 6.5071 | 6.5068 | 6.5071 | 45192.0 |
| 2008-06-12 08:09:00 | AAPL | Stock | 6.5061 | 6.5061 | 6.5036 | 6.5043 | 81200.0 |
| 2008-06-12 08:10:00 | AAPL | Stock | 6.5036 | 6.5068 | 6.5036 | 6.5036 | 44800.0 |
| 2008-06-12 08:11:00 | AAPL | Stock | 6.5064 | 6.5071 | 6.5064 | 6.5068 | 25900.0 |
| 2008-06-12 08:12:00 | AAPL | Stock | 6.5071 | 6.5071 | 6.5039 | 6.5071 | 63000.0 |
| 2008-06-12 08:13:00 | AAPL | Stock | 6.5071 | 6.5089 | 6.5054 | 6.5089 | 29288.0 |
| 2008-06-12 08:14:00 | AAPL | Stock | 6.5118 | 6.5118 | 6.5118 | 6.5118 | 5600.0 |
| 2008-06-12 08:15:00 | AAPL | Stock | 6.5136 | 6.5146 | 6.5136 | 6.5146 | 15120.0 |
| 2008-06-12 08:16:00 | AAPL | Stock | 6.5136 | 6.5136 | 6.5104 | 6.5104 | 53480.0 |
| 2008-06-12 08:17:00 | AAPL | Stock | 6.5107 | 6.5143 | 6.5071 | 6.5071 | 127260.0 |
| 2008-06-12 08:18:00 | AAPL | Stock | 6.5071 | 6.5071 | 6.5043 | 6.5043 | 30800.0 |
| 2008-06-12 08:19:00 | AAPL | Stock | 6.5075 | 6.5086 | 6.5064 | 6.5064 | 53200.0 |
| 2008-06-12 08:20:00 | AAPL | Stock | 6.5082 | 6.5082 | 6.5064 | 6.5064 | 14000.0 |
| 2008-06-12 08:21:00 | AAPL | Stock | 6.5061 | 6.5064 | 6.5061 | 6.5064 | 11760.0 |
| 2008-06-12 08:23:00 | AAPL | Stock | 6.5057 | 6.5061 | 6.5057 | 6.5057 | 42000.0 |
| 2008-06-12 08:24:00 | AAPL | Stock | 6.5061 | 6.5061 | 6.5039 | 6.5057 | 39200.0 |
| 2008-06-12 08:25:00 | AAPL | Stock | 6.5039 | 6.5043 | 6.5011 | 6.5029 | 82460.0 |
| 2008-06-12 08:26:00 | AAPL | Stock | 6.5029 | 6.5029 | 6.5011 | 6.5011 | 182252.0 |
> showing 50 of 975,574 rows — these rows as CSV