PREVIEW / stock_5min / 2005-03-31
file: by_date/stock_5min/2005/2005-03-31.parquet size: 2.7 MB rows: 197,544 symbols: 1,957
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 |
|---|---|---|---|---|---|---|---|
| 2005-03-31 08:00:00 | AAPL | Stock | 1.5286 | 1.5346 | 1.5268 | 1.5268 | 123200.0 |
| 2005-03-31 08:05:00 | AAPL | Stock | 1.5286 | 1.5286 | 1.525 | 1.525 | 114800.0 |
| 2005-03-31 08:10:00 | AAPL | Stock | 1.525 | 1.5264 | 1.5214 | 1.5221 | 163240.0 |
| 2005-03-31 08:15:00 | AAPL | Stock | 1.5232 | 1.5236 | 1.5193 | 1.5193 | 47600.0 |
| 2005-03-31 08:20:00 | AAPL | Stock | 1.5179 | 1.5218 | 1.5179 | 1.5182 | 235480.0 |
| 2005-03-31 08:25:00 | AAPL | Stock | 1.5239 | 1.525 | 1.5239 | 1.5246 | 19600.0 |
| 2005-03-31 08:30:00 | AAPL | Stock | 1.5246 | 1.5296 | 1.5232 | 1.5264 | 565152.0 |
| 2005-03-31 08:35:00 | AAPL | Stock | 1.5275 | 1.5304 | 1.5275 | 1.53 | 1006600.0 |
| 2005-03-31 08:40:00 | AAPL | Stock | 1.5286 | 1.5304 | 1.5286 | 1.5286 | 100184.0 |
| 2005-03-31 08:45:00 | AAPL | Stock | 1.5296 | 1.5296 | 1.5275 | 1.5275 | 33600.0 |
| 2005-03-31 08:50:00 | AAPL | Stock | 1.525 | 1.5261 | 1.5246 | 1.5246 | 41160.0 |
| 2005-03-31 08:55:00 | AAPL | Stock | 1.5246 | 1.525 | 1.5232 | 1.5239 | 48160.0 |
| 2005-03-31 09:00:00 | AAPL | Stock | 1.5236 | 1.5236 | 1.5214 | 1.5214 | 155680.0 |
| 2005-03-31 09:05:00 | AAPL | Stock | 1.5196 | 1.5214 | 1.5182 | 1.52 | 331800.0 |
| 2005-03-31 09:10:00 | AAPL | Stock | 1.5186 | 1.52 | 1.5179 | 1.5179 | 763000.0 |
| 2005-03-31 09:15:00 | AAPL | Stock | 1.5179 | 1.5193 | 1.5171 | 1.5175 | 505400.0 |
| 2005-03-31 09:20:00 | AAPL | Stock | 1.5179 | 1.5196 | 1.5157 | 1.5157 | 2332400.0 |
| 2005-03-31 09:25:00 | AAPL | Stock | 1.5171 | 1.5179 | 1.5107 | 1.5125 | 3568124.0 |
| 2005-03-31 09:30:00 | AAPL | Stock | 1.5161 | 1.5161 | 1.4964 | 1.4989 | 39890368.0 |
| 2005-03-31 09:35:00 | AAPL | Stock | 1.4989 | 1.5104 | 1.4986 | 1.5104 | 24878392.0 |
| 2005-03-31 09:40:00 | AAPL | Stock | 1.5104 | 1.5129 | 1.5018 | 1.5129 | 23513420.0 |
| 2005-03-31 09:45:00 | AAPL | Stock | 1.5129 | 1.5186 | 1.5054 | 1.5161 | 17901548.0 |
| 2005-03-31 09:50:00 | AAPL | Stock | 1.5157 | 1.5171 | 1.5067 | 1.5093 | 11772544.0 |
| 2005-03-31 09:55:00 | AAPL | Stock | 1.5093 | 1.5104 | 1.5054 | 1.5086 | 14858144.0 |
| 2005-03-31 10:00:00 | AAPL | Stock | 1.5086 | 1.5104 | 1.5064 | 1.5071 | 9501856.0 |
| 2005-03-31 10:05:00 | AAPL | Stock | 1.5075 | 1.5075 | 1.5 | 1.5046 | 10658088.0 |
| 2005-03-31 10:10:00 | AAPL | Stock | 1.5046 | 1.5061 | 1.5018 | 1.5057 | 13508936.0 |
| 2005-03-31 10:15:00 | AAPL | Stock | 1.5061 | 1.5071 | 1.5036 | 1.5057 | 6061916.0 |
| 2005-03-31 10:20:00 | AAPL | Stock | 1.5057 | 1.5089 | 1.5057 | 1.5071 | 4359824.0 |
| 2005-03-31 10:25:00 | AAPL | Stock | 1.5064 | 1.5089 | 1.5046 | 1.5082 | 7147000.0 |
| 2005-03-31 10:30:00 | AAPL | Stock | 1.5082 | 1.5096 | 1.5064 | 1.5086 | 5510764.0 |
| 2005-03-31 10:35:00 | AAPL | Stock | 1.5086 | 1.5104 | 1.5054 | 1.5068 | 5196884.0 |
| 2005-03-31 10:40:00 | AAPL | Stock | 1.5068 | 1.5082 | 1.5057 | 1.5082 | 2495360.0 |
| 2005-03-31 10:45:00 | AAPL | Stock | 1.5086 | 1.5093 | 1.5057 | 1.5075 | 3632692.0 |
| 2005-03-31 10:50:00 | AAPL | Stock | 1.5071 | 1.5089 | 1.5054 | 1.5054 | 3977484.0 |
| 2005-03-31 10:55:00 | AAPL | Stock | 1.5054 | 1.5054 | 1.5011 | 1.5043 | 6981772.0 |
| 2005-03-31 11:00:00 | AAPL | Stock | 1.5039 | 1.5046 | 1.5011 | 1.5014 | 9132424.0 |
| 2005-03-31 11:05:00 | AAPL | Stock | 1.5011 | 1.505 | 1.5004 | 1.5039 | 5864628.0 |
| 2005-03-31 11:10:00 | AAPL | Stock | 1.5036 | 1.5064 | 1.5036 | 1.505 | 4465188.0 |
| 2005-03-31 11:15:00 | AAPL | Stock | 1.505 | 1.5093 | 1.505 | 1.5075 | 5914356.0 |
| 2005-03-31 11:20:00 | AAPL | Stock | 1.5079 | 1.5093 | 1.5064 | 1.5079 | 3502128.0 |
| 2005-03-31 11:25:00 | AAPL | Stock | 1.5079 | 1.5086 | 1.5054 | 1.5057 | 4178272.0 |
| 2005-03-31 11:30:00 | AAPL | Stock | 1.5054 | 1.5075 | 1.5054 | 1.5075 | 1003548.0 |
| 2005-03-31 11:35:00 | AAPL | Stock | 1.5075 | 1.5075 | 1.5057 | 1.5061 | 2233784.0 |
| 2005-03-31 11:40:00 | AAPL | Stock | 1.5061 | 1.5071 | 1.5018 | 1.5039 | 3336032.0 |
| 2005-03-31 11:45:00 | AAPL | Stock | 1.5039 | 1.5039 | 1.4989 | 1.4989 | 12292756.0 |
| 2005-03-31 11:50:00 | AAPL | Stock | 1.4989 | 1.5007 | 1.4971 | 1.5007 | 6328616.0 |
| 2005-03-31 11:55:00 | AAPL | Stock | 1.5007 | 1.5029 | 1.5004 | 1.5011 | 4753168.0 |
| 2005-03-31 12:00:00 | AAPL | Stock | 1.5011 | 1.5014 | 1.4996 | 1.5 | 4270896.0 |
| 2005-03-31 12:05:00 | AAPL | Stock | 1.4996 | 1.5 | 1.4964 | 1.4975 | 9120888.0 |
> showing 50 of 197,544 rows — these rows as CSV