PREVIEW / stock_1min / 2009-09-17
file: by_date/stock_1min/2009/2009-09-17.parquet size: 13.1 MB rows: 972,096 symbols: 2,749
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 |
|---|---|---|---|---|---|---|---|
| 2009-09-17 07:02:00 | AAPL | Stock | 6.4968 | 6.4968 | 6.4968 | 6.4968 | 5600.0 |
| 2009-09-17 07:03:00 | AAPL | Stock | 6.4968 | 6.4968 | 6.4968 | 6.4968 | 2800.0 |
| 2009-09-17 07:05:00 | AAPL | Stock | 6.5 | 6.5 | 6.5 | 6.5 | 2800.0 |
| 2009-09-17 07:17:00 | AAPL | Stock | 6.4911 | 6.4911 | 6.4911 | 6.4911 | 8400.0 |
| 2009-09-17 07:29:00 | AAPL | Stock | 6.4893 | 6.4893 | 6.4893 | 6.4893 | 5600.0 |
| 2009-09-17 07:35:00 | AAPL | Stock | 6.5089 | 6.5089 | 6.5089 | 6.5089 | 5600.0 |
| 2009-09-17 07:37:00 | AAPL | Stock | 6.51 | 6.51 | 6.51 | 6.51 | 2800.0 |
| 2009-09-17 07:38:00 | AAPL | Stock | 6.5068 | 6.5068 | 6.5068 | 6.5068 | 2800.0 |
| 2009-09-17 07:42:00 | AAPL | Stock | 6.5004 | 6.5004 | 6.5004 | 6.5004 | 4200.0 |
| 2009-09-17 07:43:00 | AAPL | Stock | 6.5 | 6.5 | 6.5 | 6.5 | 28532.0 |
| 2009-09-17 07:46:00 | AAPL | Stock | 6.5046 | 6.5046 | 6.5046 | 6.5046 | 2800.0 |
| 2009-09-17 07:53:00 | AAPL | Stock | 6.4936 | 6.4936 | 6.4936 | 6.4936 | 4900.0 |
| 2009-09-17 07:55:00 | AAPL | Stock | 6.4936 | 6.4936 | 6.4936 | 6.4936 | 2800.0 |
| 2009-09-17 07:57:00 | AAPL | Stock | 6.4982 | 6.4982 | 6.4982 | 6.4982 | 2800.0 |
| 2009-09-17 08:00:00 | AAPL | Stock | 6.5 | 6.5 | 6.4975 | 6.4975 | 24780.0 |
| 2009-09-17 08:01:00 | AAPL | Stock | 6.4954 | 6.5039 | 6.4954 | 6.5039 | 34580.0 |
| 2009-09-17 08:02:00 | AAPL | Stock | 6.5036 | 6.5036 | 6.4975 | 6.4975 | 19600.0 |
| 2009-09-17 08:03:00 | AAPL | Stock | 6.4982 | 6.5 | 6.4982 | 6.5 | 15400.0 |
| 2009-09-17 08:04:00 | AAPL | Stock | 6.4961 | 6.4964 | 6.4957 | 6.4964 | 30324.0 |
| 2009-09-17 08:05:00 | AAPL | Stock | 6.4964 | 6.5179 | 6.4964 | 6.5179 | 279300.0 |
| 2009-09-17 08:06:00 | AAPL | Stock | 6.5179 | 6.5179 | 6.5014 | 6.5107 | 53200.0 |
| 2009-09-17 08:07:00 | AAPL | Stock | 6.51 | 6.5107 | 6.51 | 6.5107 | 13440.0 |
| 2009-09-17 08:08:00 | AAPL | Stock | 6.5107 | 6.5214 | 6.5107 | 6.5189 | 193032.0 |
| 2009-09-17 08:09:00 | AAPL | Stock | 6.5221 | 6.5221 | 6.5057 | 6.5161 | 247576.0 |
| 2009-09-17 08:10:00 | AAPL | Stock | 6.5143 | 6.5171 | 6.5143 | 6.5161 | 33152.0 |
| 2009-09-17 08:11:00 | AAPL | Stock | 6.5179 | 6.5179 | 6.5161 | 6.5179 | 22904.0 |
| 2009-09-17 08:12:00 | AAPL | Stock | 6.5179 | 6.5193 | 6.5161 | 6.5161 | 31752.0 |
| 2009-09-17 08:13:00 | AAPL | Stock | 6.5179 | 6.5196 | 6.5179 | 6.5179 | 44800.0 |
| 2009-09-17 08:14:00 | AAPL | Stock | 6.5179 | 6.5179 | 6.5146 | 6.515 | 16520.0 |
| 2009-09-17 08:15:00 | AAPL | Stock | 6.5161 | 6.5161 | 6.5143 | 6.5161 | 30520.0 |
| 2009-09-17 08:16:00 | AAPL | Stock | 6.5161 | 6.5179 | 6.5161 | 6.5179 | 12320.0 |
| 2009-09-17 08:17:00 | AAPL | Stock | 6.5179 | 6.5179 | 6.5161 | 6.5161 | 22400.0 |
| 2009-09-17 08:18:00 | AAPL | Stock | 6.5193 | 6.5193 | 6.5143 | 6.5146 | 57540.0 |
| 2009-09-17 08:19:00 | AAPL | Stock | 6.5161 | 6.5189 | 6.5161 | 6.5189 | 30800.0 |
| 2009-09-17 08:20:00 | AAPL | Stock | 6.5179 | 6.5186 | 6.5179 | 6.5186 | 11200.0 |
| 2009-09-17 08:22:00 | AAPL | Stock | 6.5179 | 6.5179 | 6.5161 | 6.5179 | 11200.0 |
| 2009-09-17 08:23:00 | AAPL | Stock | 6.5146 | 6.5146 | 6.5146 | 6.5146 | 22400.0 |
| 2009-09-17 08:24:00 | AAPL | Stock | 6.5146 | 6.5161 | 6.5146 | 6.5161 | 63980.0 |
| 2009-09-17 08:25:00 | AAPL | Stock | 6.5161 | 6.5189 | 6.5161 | 6.5189 | 25200.0 |
| 2009-09-17 08:26:00 | AAPL | Stock | 6.5171 | 6.5171 | 6.5171 | 6.5171 | 8400.0 |
| 2009-09-17 08:27:00 | AAPL | Stock | 6.5175 | 6.5196 | 6.5175 | 6.5189 | 26964.0 |
| 2009-09-17 08:28:00 | AAPL | Stock | 6.5214 | 6.5243 | 6.5214 | 6.5243 | 109536.0 |
| 2009-09-17 08:29:00 | AAPL | Stock | 6.5243 | 6.5261 | 6.5243 | 6.5261 | 17528.0 |
| 2009-09-17 08:30:00 | AAPL | Stock | 6.525 | 6.5321 | 6.5243 | 6.525 | 243460.0 |
| 2009-09-17 08:31:00 | AAPL | Stock | 6.5268 | 6.5268 | 6.5082 | 6.5139 | 367108.0 |
| 2009-09-17 08:32:00 | AAPL | Stock | 6.5139 | 6.5179 | 6.5104 | 6.5139 | 96600.0 |
| 2009-09-17 08:33:00 | AAPL | Stock | 6.5143 | 6.5168 | 6.5125 | 6.5168 | 51660.0 |
| 2009-09-17 08:34:00 | AAPL | Stock | 6.515 | 6.515 | 6.515 | 6.515 | 14000.0 |
| 2009-09-17 08:35:00 | AAPL | Stock | 6.5107 | 6.5111 | 6.5093 | 6.5093 | 60032.0 |
| 2009-09-17 08:36:00 | AAPL | Stock | 6.5093 | 6.5093 | 6.5043 | 6.5043 | 49252.0 |
> showing 50 of 972,096 rows — these rows as CSV