PREVIEW / stock_5min / 2006-04-10
file: by_date/stock_5min/2006/2006-04-10.parquet size: 3.1 MB rows: 223,046 symbols: 2,225
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-04-10 06:00:00 | AAPL | Stock | 2.5054 | 2.5054 | 2.5054 | 2.5054 | 2800.0 |
| 2006-04-10 08:00:00 | AAPL | Stock | 2.4964 | 2.5071 | 2.4954 | 2.5036 | 148456.0 |
| 2006-04-10 08:05:00 | AAPL | Stock | 2.5 | 2.5036 | 2.5 | 2.5036 | 105000.0 |
| 2006-04-10 08:10:00 | AAPL | Stock | 2.5036 | 2.5075 | 2.5 | 2.5 | 485744.0 |
| 2006-04-10 08:15:00 | AAPL | Stock | 2.5 | 2.5039 | 2.4964 | 2.4964 | 163156.0 |
| 2006-04-10 08:20:00 | AAPL | Stock | 2.5054 | 2.5071 | 2.5004 | 2.5007 | 306936.0 |
| 2006-04-10 08:25:00 | AAPL | Stock | 2.5007 | 2.5018 | 2.5004 | 2.5018 | 87696.0 |
| 2006-04-10 08:30:00 | AAPL | Stock | 2.5018 | 2.5018 | 2.5007 | 2.5007 | 66584.0 |
| 2006-04-10 08:35:00 | AAPL | Stock | 2.5007 | 2.5018 | 2.5 | 2.5 | 153160.0 |
| 2006-04-10 08:40:00 | AAPL | Stock | 2.5 | 2.5007 | 2.5 | 2.5007 | 289688.0 |
| 2006-04-10 08:45:00 | AAPL | Stock | 2.5 | 2.5007 | 2.5 | 2.5007 | 138768.0 |
| 2006-04-10 08:50:00 | AAPL | Stock | 2.5007 | 2.5007 | 2.5 | 2.5 | 36400.0 |
| 2006-04-10 08:55:00 | AAPL | Stock | 2.5007 | 2.5036 | 2.5007 | 2.5036 | 14672.0 |
| 2006-04-10 09:00:00 | AAPL | Stock | 2.5036 | 2.5064 | 2.5021 | 2.5021 | 117600.0 |
| 2006-04-10 09:05:00 | AAPL | Stock | 2.5021 | 2.5029 | 2.5021 | 2.5029 | 30800.0 |
| 2006-04-10 09:10:00 | AAPL | Stock | 2.5029 | 2.505 | 2.5029 | 2.5036 | 123200.0 |
| 2006-04-10 09:15:00 | AAPL | Stock | 2.5036 | 2.5054 | 2.5036 | 2.5054 | 81200.0 |
| 2006-04-10 09:20:00 | AAPL | Stock | 2.5054 | 2.5071 | 2.505 | 2.5054 | 408520.0 |
| 2006-04-10 09:25:00 | AAPL | Stock | 2.5079 | 2.5107 | 2.5054 | 2.5107 | 413140.0 |
| 2006-04-10 09:30:00 | AAPL | Stock | 2.5104 | 2.5214 | 2.5 | 2.5057 | 28194936.0 |
| 2006-04-10 09:35:00 | AAPL | Stock | 2.5058 | 2.5179 | 2.5054 | 2.5107 | 17526656.0 |
| 2006-04-10 09:40:00 | AAPL | Stock | 2.5111 | 2.5157 | 2.5032 | 2.5139 | 19296508.0 |
| 2006-04-10 09:45:00 | AAPL | Stock | 2.5143 | 2.5157 | 2.5079 | 2.5129 | 13270348.0 |
| 2006-04-10 09:50:00 | AAPL | Stock | 2.5129 | 2.5129 | 2.4982 | 2.5096 | 27607804.0 |
| 2006-04-10 09:55:00 | AAPL | Stock | 2.51 | 2.5107 | 2.495 | 2.4982 | 20493760.0 |
| 2006-04-10 10:00:00 | AAPL | Stock | 2.4982 | 2.5068 | 2.4964 | 2.5046 | 14708120.0 |
| 2006-04-10 10:05:00 | AAPL | Stock | 2.5047 | 2.5261 | 2.5036 | 2.5232 | 31871084.0 |
| 2006-04-10 10:10:00 | AAPL | Stock | 2.5236 | 2.5332 | 2.5214 | 2.5236 | 28362600.0 |
| 2006-04-10 10:15:00 | AAPL | Stock | 2.5236 | 2.5286 | 2.5189 | 2.5221 | 14896532.0 |
| 2006-04-10 10:20:00 | AAPL | Stock | 2.5221 | 2.5275 | 2.5186 | 2.525 | 13951700.0 |
| 2006-04-10 10:25:00 | AAPL | Stock | 2.5246 | 2.5252 | 2.515 | 2.5179 | 12559484.0 |
| 2006-04-10 10:30:00 | AAPL | Stock | 2.5179 | 2.5204 | 2.5111 | 2.5132 | 13998544.0 |
| 2006-04-10 10:35:00 | AAPL | Stock | 2.5136 | 2.5161 | 2.5089 | 2.5157 | 11681936.0 |
| 2006-04-10 10:40:00 | AAPL | Stock | 2.5157 | 2.5161 | 2.5075 | 2.51 | 9632840.0 |
| 2006-04-10 10:45:00 | AAPL | Stock | 2.51 | 2.5175 | 2.5096 | 2.5161 | 12540472.0 |
| 2006-04-10 10:50:00 | AAPL | Stock | 2.5161 | 2.5175 | 2.5129 | 2.5143 | 7376264.0 |
| 2006-04-10 10:55:00 | AAPL | Stock | 2.5136 | 2.5175 | 2.5096 | 2.5118 | 8081332.0 |
| 2006-04-10 11:00:00 | AAPL | Stock | 2.5118 | 2.5121 | 2.5061 | 2.5075 | 10548300.0 |
| 2006-04-10 11:05:00 | AAPL | Stock | 2.5075 | 2.5139 | 2.5071 | 2.5079 | 9311988.0 |
| 2006-04-10 11:10:00 | AAPL | Stock | 2.5079 | 2.5104 | 2.5029 | 2.5054 | 7634452.0 |
| 2006-04-10 11:15:00 | AAPL | Stock | 2.505 | 2.5082 | 2.5025 | 2.506 | 10187240.0 |
| 2006-04-10 11:20:00 | AAPL | Stock | 2.5064 | 2.51 | 2.5014 | 2.5029 | 9644656.0 |
| 2006-04-10 11:25:00 | AAPL | Stock | 2.5029 | 2.5082 | 2.5018 | 2.5075 | 8572564.0 |
| 2006-04-10 11:30:00 | AAPL | Stock | 2.5079 | 2.5111 | 2.505 | 2.5064 | 8838172.0 |
| 2006-04-10 11:35:00 | AAPL | Stock | 2.5064 | 2.5068 | 2.4964 | 2.4993 | 11530092.0 |
| 2006-04-10 11:40:00 | AAPL | Stock | 2.4989 | 2.5025 | 2.4932 | 2.4986 | 14403116.0 |
| 2006-04-10 11:45:00 | AAPL | Stock | 2.4986 | 2.4989 | 2.4904 | 2.4936 | 12524624.0 |
| 2006-04-10 11:50:00 | AAPL | Stock | 2.4936 | 2.4936 | 2.4879 | 2.4896 | 9690968.0 |
| 2006-04-10 11:55:00 | AAPL | Stock | 2.4896 | 2.495 | 2.4886 | 2.495 | 7555492.0 |
| 2006-04-10 12:00:00 | AAPL | Stock | 2.495 | 2.4989 | 2.4932 | 2.4975 | 8157856.0 |
> showing 50 of 223,046 rows — these rows as CSV