PREVIEW / stock_5min / 2008-06-12
file: by_date/stock_5min/2008/2008-06-12.parquet size: 4.4 MB rows: 312,206 symbols: 3,306
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:05:00 | AAPL | Stock | 6.4911 | 6.4911 | 6.4911 | 6.4911 | 5600.0 |
| 2008-06-12 05:25:00 | AAPL | Stock | 6.4821 | 6.4821 | 6.4821 | 6.4821 | 2800.0 |
| 2008-06-12 06:20: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:40:00 | AAPL | Stock | 6.4679 | 6.4679 | 6.4668 | 6.4668 | 36400.0 |
| 2008-06-12 06:45:00 | AAPL | Stock | 6.475 | 6.475 | 6.475 | 6.475 | 5600.0 |
| 2008-06-12 06:50:00 | AAPL | Stock | 6.475 | 6.475 | 6.475 | 6.475 | 19600.0 |
| 2008-06-12 07:00:00 | AAPL | Stock | 6.4914 | 6.4914 | 6.4914 | 6.4914 | 14000.0 |
| 2008-06-12 07:10:00 | AAPL | Stock | 6.4911 | 6.5 | 6.4911 | 6.5 | 81200.0 |
| 2008-06-12 07:15:00 | AAPL | Stock | 6.5 | 6.5357 | 6.5 | 6.5268 | 182756.0 |
| 2008-06-12 07:20:00 | AAPL | Stock | 6.5179 | 6.5357 | 6.5179 | 6.5357 | 534660.0 |
| 2008-06-12 07:25:00 | AAPL | Stock | 6.5179 | 6.5179 | 6.5179 | 6.5179 | 72912.0 |
| 2008-06-12 07:30:00 | AAPL | Stock | 6.5179 | 6.5179 | 6.515 | 6.515 | 62944.0 |
| 2008-06-12 07:40: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.5054 | 69664.0 |
| 2008-06-12 07:50:00 | AAPL | Stock | 6.5157 | 6.5243 | 6.5157 | 6.5243 | 25732.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.5107 | 590968.0 |
| 2008-06-12 08:05:00 | AAPL | Stock | 6.5107 | 6.5107 | 6.5036 | 6.5043 | 373072.0 |
| 2008-06-12 08:10:00 | AAPL | Stock | 6.5036 | 6.5118 | 6.5036 | 6.5118 | 168588.0 |
| 2008-06-12 08:15:00 | AAPL | Stock | 6.5136 | 6.5146 | 6.5043 | 6.5064 | 279860.0 |
| 2008-06-12 08:20:00 | AAPL | Stock | 6.5082 | 6.5082 | 6.5039 | 6.5057 | 106960.0 |
| 2008-06-12 08:25:00 | AAPL | Stock | 6.5039 | 6.5093 | 6.4964 | 6.5036 | 518252.0 |
| 2008-06-12 08:30:00 | AAPL | Stock | 6.5064 | 6.525 | 6.5039 | 6.5179 | 1134672.0 |
| 2008-06-12 08:35:00 | AAPL | Stock | 6.5193 | 6.5232 | 6.5089 | 6.5157 | 335496.0 |
| 2008-06-12 08:40:00 | AAPL | Stock | 6.5161 | 6.5207 | 6.5143 | 6.5186 | 151760.0 |
| 2008-06-12 08:45:00 | AAPL | Stock | 6.5171 | 6.5179 | 6.4918 | 6.4946 | 396060.0 |
| 2008-06-12 08:50:00 | AAPL | Stock | 6.4921 | 6.4996 | 6.4821 | 6.4896 | 313852.0 |
| 2008-06-12 08:55:00 | AAPL | Stock | 6.4996 | 6.5 | 6.4907 | 6.5 | 169092.0 |
| 2008-06-12 09:00:00 | AAPL | Stock | 6.5021 | 6.5064 | 6.4986 | 6.5011 | 212128.0 |
| 2008-06-12 09:05:00 | AAPL | Stock | 6.5032 | 6.5043 | 6.4989 | 6.5032 | 129780.0 |
| 2008-06-12 09:10:00 | AAPL | Stock | 6.5 | 6.5004 | 6.4982 | 6.4986 | 152880.0 |
| 2008-06-12 09:15:00 | AAPL | Stock | 6.5 | 6.5 | 6.4929 | 6.4968 | 172200.0 |
| 2008-06-12 09:20:00 | AAPL | Stock | 6.4957 | 6.5 | 6.4893 | 6.5 | 322028.0 |
| 2008-06-12 09:25:00 | AAPL | Stock | 6.4996 | 6.5029 | 6.4775 | 6.4821 | 1025416.0 |
| 2008-06-12 09:30:00 | AAPL | Stock | 6.4821 | 6.5214 | 6.4686 | 6.5004 | 26919172.0 |
| 2008-06-12 09:35:00 | AAPL | Stock | 6.5006 | 6.5125 | 6.4429 | 6.4654 | 23147488.0 |
| 2008-06-12 09:40:00 | AAPL | Stock | 6.4654 | 6.4996 | 6.4525 | 6.4954 | 22092112.0 |
| 2008-06-12 09:45:00 | AAPL | Stock | 6.4957 | 6.5075 | 6.4804 | 6.4913 | 14743120.0 |
| 2008-06-12 09:50:00 | AAPL | Stock | 6.4907 | 6.5064 | 6.4782 | 6.4804 | 13277796.0 |
| 2008-06-12 09:55:00 | AAPL | Stock | 6.4804 | 6.4804 | 6.445 | 6.4589 | 19628868.0 |
| 2008-06-12 10:00:00 | AAPL | Stock | 6.4589 | 6.4704 | 6.4254 | 6.4546 | 24362492.0 |
| 2008-06-12 10:05:00 | AAPL | Stock | 6.4546 | 6.4639 | 6.4136 | 6.4332 | 20866384.0 |
| 2008-06-12 10:10:00 | AAPL | Stock | 6.4336 | 6.4464 | 6.3929 | 6.4043 | 17299856.0 |
| 2008-06-12 10:15:00 | AAPL | Stock | 6.4046 | 6.4061 | 6.3539 | 6.355 | 35580972.0 |
| 2008-06-12 10:20:00 | AAPL | Stock | 6.3546 | 6.3571 | 6.2536 | 6.3032 | 72850008.0 |
| 2008-06-12 10:25:00 | AAPL | Stock | 6.3029 | 6.3161 | 6.2857 | 6.3036 | 26560632.0 |
| 2008-06-12 10:30:00 | AAPL | Stock | 6.3021 | 6.3361 | 6.2993 | 6.3143 | 27981968.0 |
| 2008-06-12 10:35:00 | AAPL | Stock | 6.3143 | 6.32 | 6.2857 | 6.3068 | 22275568.0 |
| 2008-06-12 10:40:00 | AAPL | Stock | 6.3064 | 6.3211 | 6.295 | 6.2986 | 14639100.0 |
> showing 50 of 312,206 rows — these rows as CSV